Castletown Pharmacy is a progressive, independent, family run vibrant pharmacy located on the Main Street in Celbridge, Co Kildare across from the Castletown Gates.

Blood Pressure 24 Hour Home Monitor - Available to Rent

Tuesday, 10 September 2019

Pery

Castletown Pharmacy News

504 Hits

Wondering what your blood pressure is?

High blood pressure can be a silent disease i.e. you can have no symptoms even if you have high blood pressure. If left untreated, high blood pressure and irregular heartbeat increase your risk of heart attack, stroke, vascular disease and kidney failure. The only way of knowing if there is a problem is to have your blood pressure measured.

Early detection of high blood pressure and irregular heartbeat means you can be treated and prevent stroke or heart attack. All adults should have their blood pressure checked at least every five years.

We have a Microlife 24-hour blood pressure monitor in store which you can rent and wear for 24 hours. This monitor will measure your blood pressure over a 24-hour period and will detect high blood pressure and an irregular heartbeat.

We will give you full instructions about how to use the monitor. (It is quite simple to use) When you return the monitor, one of our pharmacists will analyse your results and explain them fully to you. The total cost of renting the monitor and getting your results analysed is €40.

Drop into our pharmacy or call us on 01 6273962 for more information!

Tags:

About the author

Pery

View author's profile More posts from author

Author's recent posts

Friday, 17 January 2020 Treating Coughs, Colds and Sore Throats

Friday, 17 January 2020 Tips for a healthy New Year

Tuesday, 08 October 2019 Flu Vaccines Are Available In-store Now!

Tuesday, 10 September 2019 Blood Pressure 24 Hour Home Monitor - Available to Rent

Tuesday, 10 September 2019 Back to School Advice

Search our Site

FULL HEALTH CHECK €19.95

Cholesterol, Diabetes, BMI and Blood Pressure

Check including advice on Diet and lifestyle

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1618831383,
                "last": 1618831383,
                "now": 1618831383
            },
            "token": "TWFTaHq6rUFD1awzDFXSjhPqXG1grWkL"
        },
        "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
        },
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-name": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-logo-type": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-logo-custom-image": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-showcase-overlay": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-showcase-background": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-showcase-type": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-showcase-customshowcase-image": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-feature-overlay": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-feature-background": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-maintop-overlay": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-maintop-background": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-main-body-style": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-main-accent": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-main-accent2": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-mainbottom-overlay": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-mainbottom-background": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-footer-overlay": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-footer-background": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-footer-type": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-footer-customfooter-image": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-font-family": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-font-size-is": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-menu-type": null,
        "acacia-7c0cd9a372f4c50dc6f77d3f277976ea-layout-mode": null
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

102 Queries Logged 98.20 ms

24 duplicate found!

2 duplicates: #8 #9

2 duplicates: #15 #17

3 duplicates: #24 #37 #97

2 duplicates: #25 #38

5 duplicates: #26 #39 #54 #58 #98

2 duplicates: #27 #40

2 duplicates: #71 #75

2 duplicates: #72 #76

2 duplicates: #73 #77

2 duplicates: #74 #78

Query Time: 14.17 ms

SELECT `data`

  FROM `bos_session`

  WHERE `session_id` = 's72vm3o1mgo0ngb3vec037g082'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.76 ms After last query: 6.66 ms

SELECT `session_id`

  FROM `bos_session`

  WHERE `session_id` = 's72vm3o1mgo0ngb3vec037g082' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:214
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.65 ms After last query: 0.52 ms

INSERT INTO `bos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('s72vm3o1mgo0ngb3vec037g082', 1, '1618831383', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `bos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('s72vm3o1mgo0ngb3vec037g082', 1, '1618831383', 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Application/CMSApplication.php:254
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.76 ms After last query: 25.02 ms

SELECT id, rules

  FROM `bos_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.71 ms After last query: 0.30 ms

SELECT b.id

  FROM bos_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.67 ms After last query: 25.69 ms

SELECT `value`

  FROM `bos_admintools_storage`

  WHERE `key` = 'cparams'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:118
11	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:48
10	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
9	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:270
8	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 5.21 ms

SELECT *

  FROM `bos_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1496
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:555
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:469
8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:99
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 37.66 ms

Duplicate queries: #9

SELECT template

  FROM bos_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.41 ms

Duplicate queries: #8

SELECT template

  FROM bos_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 19.94 ms

SELECT extension, file, type

  FROM bos_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.63 ms After last query: 72.59 ms

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:327
12	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
11	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
9	plgSystemAdmintools->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.54 ms

SELECT `source`,`keepurlparams`

  FROM `bos_admintools_redirects`

  WHERE ((`dest` = 'index.php/blog/entry/blood-pressure-24-hour-home-monitor-available-to-rent.html') OR (`dest` = 'index.php/blog/entry/blood-pressure-24-hour-home-monitor-available-to-rent.html') OR ('index.php/blog/entry/blood-pressure-24-hour-home-monitor-available-to-rent.html' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1763
12	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
11	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
9	plgSystemAdmintools->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.52 ms After last query: 9.13 ms

SHOW FULL COLUMNS 
  FROM `bos_extensions`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 2.82 ms

SELECT `extension_id`

  FROM `bos_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.41 ms

Duplicate queries: #17

SELECT *

  FROM bos_extensions

  WHERE `extension_id` = '10041'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.35 ms

SELECT `extension_id`

  FROM `bos_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.45 ms

Duplicate queries: #15

SELECT *

  FROM bos_extensions

  WHERE `extension_id` = '10041'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.14 ms After last query: 154.34 ms

SELECT *

  FROM bos_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:441
11	EB::config()	JROOT/components/com_easyblog/router.php:345
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.69 ms After last query: 32.11 ms

UPDATE `bos_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	bos_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
18	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
17	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_easyblog/includes/utils.php:56
13	EasyBlog->__construct()	JROOT/administrator/components/com_easyblog/includes/post/post.php:213
12	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3514
11	EB::post()	JROOT/components/com_easyblog/router.php:473
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.37 ms After last query: 17.53 ms

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_acl	NULL	ALL	idx_acl_published,idx_acl_published_id	NO INDEX KEY COULD BE USED	NULL	NULL	44	97.73	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:309
15	EasyBlogAcl::getRules()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:38
14	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:169
13	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:222
12	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3514
11	EB::post()	JROOT/components/com_easyblog/router.php:473
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.62 ms After last query: 0.56 ms

SELECT * 
  FROM `bos_easyblog_acl_group` 
  WHERE `content_id` IN (1) 
  AND `type`='
  group'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_acl_group	NULL	ref	easyblog_post_acl_content_type	easyblog_post_acl_content_type	775	const,const	60	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:114
15	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/acl/acl.php:114
14	EasyBlogAcl::getRuleSet()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:169
13	EB::acl()	JROOT/administrator/components/com_easyblog/includes/post/post.php:222
12	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3514
11	EB::post()	JROOT/components/com_easyblog/router.php:473
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 0.96 ms

SELECT `id` 
  FROM `bos_easyblog_post` 
  WHERE `permalink`='blood:pressure-24-hour-home-monitor-available-to-rent'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_post	NULL	ref	idx_post_permalink	idx_post_permalink	767	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	Same as call in the line below.
14	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:426
12	EasyBlogDbJoomla->loadResult()	JROOT/administrator/components/com_easyblog/includes/post/post.php:426
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:474
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 1.32 ms

SELECT `id` 
  FROM `bos_easyblog_post` 
  WHERE `permalink`='blood-pressure-24-hour-home-monitor-available-to-rent'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_post	NULL	ref	idx_post_permalink	idx_post_permalink	767	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	Same as call in the line below.
14	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
13	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/post/post.php:440
12	EasyBlogDbJoomla->loadResult()	JROOT/administrator/components/com_easyblog/includes/post/post.php:440
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:474
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.14 ms After last query: 6.02 ms

Duplicate queries: #37 #97

SELECT *

  FROM bos_easyblog_post

  WHERE `id` = '60'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/post.php:76
14	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:366
13	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:269
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:444
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:474
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.94 ms After last query: 3.38 ms

Duplicate queries: #38

SELECT *

  FROM bos_easyblog_revisions

  WHERE `id` = '214'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:402
13	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:298
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:444
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:474
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 28.18 ms

Duplicate queries: #39 #54 #58 #98

SELECT COUNT(1) 
  FROM `bos_easyblog_featured` 
  WHERE `content_id`='60' 
  AND `type`='post'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	Same as call in the line below.
16	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:58
14	EasyBlogDbJoomla->loadResult()	JROOT/administrator/components/com_easyblog/models/blog.php:58
13	EasyBlogModelBlog->isFeatured()	JROOT/administrator/components/com_easyblog/includes/post/post.php:328
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:444
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:474
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 1.98 ms

Duplicate queries: #40

SELECT * 
  FROM `bos_easyblog_meta` 
  WHERE `type`='post' 
  AND `content_id`='60'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_meta	NULL	ref	idx_meta_content_type	idx_meta_content_type	66	const,const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:49
15	EasyBlogDbJoomla->loadObject()	JROOT/administrator/components/com_easyblog/tables/meta.php:49
14	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:479
13	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:341
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:444
11	EasyBlogPost->loadByPermalink()	JROOT/components/com_easyblog/router.php:474
10	EasyBlogParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.46 ms After last query: 12.99 ms

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

  FROM `bos_assets`

  WHERE `name` IN ('root.1','com_admintools','com_ajax','com_akeeba','com_associations','com_config','com_content','com_contenthistory','com_creativecontactform','com_easyblog','com_fields','com_finder','com_gantry','com_jantivirus','com_joomgallery','com_joomlaupdate','com_languages','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rokcandy','com_rokgallery','com_rokmodule','com_roksprocket','com_search','com_securitycheck','com_sitemapgenerator','com_tags','com_templates','com_users','com_weblinks','com_xmap')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	173	21.39	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:954
8	EB::isSiteAdmin()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:95
7	EB::checkEnvironment()	JROOT/components/com_easyblog/easyblog.php:21
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.66 ms After last query: 9.43 ms

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	bos_easyblog_mailq	NULL	range	easyblog_mailq_status,idx_mailq_statuscreated	easyblog_mailq_status	1	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:39
11	EasyBlogDbJoomla->Query()	JROOT/administrator/components/com_easyblog/models/mailer.php:39
10	EasyBlogModelMailer->cleanup()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:29
9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.21 ms

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/mailer.php:65
11	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/mailer.php:65
10	EasyBlogModelMailer->getPendingEmails()	JROOT/administrator/components/com_easyblog/includes/mailer/mailer.php:32
9	EasyBlogMailer->dispatch()	JROOT/components/com_easyblog/services/maintenance.php:18
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 21.80 ms

SELECT * 
  FROM `bos_easyblog_post` 
  WHERE `publish_up`<='2021-04-19 11:23:03' 
  AND `published`='2' 
  AND `state`='0' 
  ORDER BY `id` 
  LIMIT 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_post	NULL	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_blogger_list	1	const	1	5.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:353
11	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/blogs.php:353
10	EasyBlogModelBlogs->getScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:51
9	EasyBlogScheduler->publish()	JROOT/components/com_easyblog/services/maintenance.php:22
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.52 ms

SELECT id, created_by 
  FROM`bos_easyblog_post` 
  WHERE `publish_down` > `publish_up` 
  AND `publish_down` <= '2021-04-19 11:23:03' 
  AND `publish_down` != '0000-00-00 00:00:00' 
  AND `published` = '1' 
  AND `state` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_post	NULL	ref	easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	idx_pre_soucetype_postcount	5	const,const	18	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
12	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blogs.php:396
11	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/blogs.php:396
10	EasyBlogModelBlogs->getUnpublishScheduledPosts()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:26
9	EasyBlogScheduler->unpublish()	JROOT/components/com_easyblog/services/maintenance.php:25
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.33 ms

SELECT * 
  FROM `bos_easyblog_uploader_tmp` 
  WHERE `created` <= DATE_SUB('2021-04-19 11:23:03' , INTERVAL 120 MINUTE)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	Same as call in the line below.
12	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:94
10	EasyBlogDbJoomla->loadObject()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:94
9	EasyBlogScheduler->removeTmpFiles()	JROOT/components/com_easyblog/services/maintenance.php:28
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 0.37 ms

SELECT a.`id` 
  FROM `bos_easyblog_post` as a	
  inner join `bos_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2021-04-19 11:23:03', INTERVAL 3 DAY)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_published	1	const	1	33.33	Using where
1	SIMPLE	b	NULL	ref	idx_postid,idx_ordering,idx_revision_state	idx_postid	8	webdesi5_castletown.a.id	1	100.00	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	Same as call in the line below.
12	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:136
10	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:136
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:31
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.27 ms

DELETE a, b 
  FROM `bos_easyblog_post` as a	
  inner join `bos_easyblog_revisions` as b 
  on a.`id` = b.`post_id` 
  where a.`published` = '9' 
  and a.`created` <= DATE_SUB('2021-04-19 11:23:03', INTERVAL 3 DAY)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	a	NULL	ref	PRIMARY,easyblog_post_published,easyblog_post_blogger_list,easyblog_frontpage1,idx_pre_soucetype_postcount,idx_post_sql1	easyblog_post_published	1	const	1	33.33	Using where
1	DELETE	b	NULL	ref	idx_postid,idx_ordering,idx_revision_state	idx_postid	8	webdesi5_castletown.a.id	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/database.php:33
13	JDatabase->query()	Same as call in the line below.
12	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
11	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:149
10	EasyBlogDbJoomla->query()	JROOT/administrator/components/com_easyblog/includes/scheduler/scheduler.php:149
9	EasyBlogScheduler->removeBlankPosts()	JROOT/components/com_easyblog/services/maintenance.php:31
8	require_once JROOT/components/com_easyblog/services/maintenance.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.19 ms After last query: 9.78 ms

SELECT * 
  FROM `bos_menu` 
  WHERE `published`='1' 
  AND `link` LIKE 'index.php?option=com_easyblog%' 
  AND `client_id` = '0' 
  ORDER BY `id`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	34	1.11	Using index condition; Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
14	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/menu.php:66
13	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/menu.php:66
12	EasyBlogModelMenu->getAssociatedMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:67
11	EBR::getMenus()	JROOT/administrator/components/com_easyblog/includes/router.php:367
10	EBR::_()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3413
9	EB::_()	JROOT/components/com_easyblog/services/weblog.php:26
8	require_once JROOT/components/com_easyblog/services/weblog.php	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3367
7	EB::loadServices()	JROOT/components/com_easyblog/easyblog.php:28
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 15.51 ms

Duplicate queries: #24 #97

SELECT *

  FROM bos_easyblog_post

  WHERE `id` = '60'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/tables/post.php:76
14	EasyBlogTablePost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:366
13	EasyBlogPost->loadPost()	JROOT/administrator/components/com_easyblog/includes/post/post.php:269
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:228
11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3514
10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:30
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.53 ms

Duplicate queries: #25

SELECT *

  FROM bos_easyblog_revisions

  WHERE `id` = '214'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1455
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:402
13	EasyBlogPost::loadRevision()	JROOT/administrator/components/com_easyblog/includes/post/post.php:298
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:228
11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3514
10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:30
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.70 ms

Duplicate queries: #26 #54 #58 #98

SELECT COUNT(1) 
  FROM `bos_easyblog_featured` 
  WHERE `content_id`='60' 
  AND `type`='post'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
17	JDatabaseDriver->loadResult()	Same as call in the line below.
16	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
15	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/blog.php:58
14	EasyBlogDbJoomla->loadResult()	JROOT/administrator/components/com_easyblog/models/blog.php:58
13	EasyBlogModelBlog->isFeatured()	JROOT/administrator/components/com_easyblog/includes/post/post.php:328
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:228
11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3514
10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:30
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.35 ms

Duplicate queries: #27

SELECT * 
  FROM `bos_easyblog_meta` 
  WHERE `type`='post' 
  AND `content_id`='60'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bos_easyblog_meta	NULL	ref	idx_meta_content_type	idx_meta_content_type	66	const,const	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
16	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/tables/meta.php:49
15	EasyBlogDbJoomla->loadObject()	JROOT/administrator/components/com_easyblog/tables/meta.php:49
14	EasyBlogTableMeta->loadByType()	JROOT/administrator/components/com_easyblog/includes/post/post.php:479
13	EasyBlogPost->loadMeta()	JROOT/administrator/components/com_easyblog/includes/post/post.php:341
12	EasyBlogPost->load()	JROOT/administrator/components/com_easyblog/includes/post/post.php:228
11	EasyBlogPost->__construct()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:3514
10	EB::post()	JROOT/components/com_easyblog/views/entry/view.html.php:30
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 2.22 ms

SELECT COUNT(1) as `voted`, `uid` 
  FROM `bos_easyblog_ratings` 
  WHERE `uid` = '60' 
  AND `type`='entry' 
  AND `created_by`='0' 
  AND (`sessionid` = 's72vm3o1mgo0ngb3vec037g082' OR `ip` = '3.236.228.250') 
  GROUP BY `uid` 
  ORDER BY NULL

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
14	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:135
13	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/ratings.php:135
12	EasyBlogModelRatings->preloadUserPostRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:347
11	EasyBlogCache->cacheVoted()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:267
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:41
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.33 ms

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
14	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/ratings.php:176
13	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/ratings.php:176
12	EasyBlogModelRatings->preloadRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:478
11	EasyBlogCache->cacheRatings()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:270
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:41
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 5.91 ms

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
14	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/comment.php:616
13	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/comment.php:616
12	EasyBlogModelComment->preloadCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:536
11	EasyBlogCache->cacheCommentCount()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:278
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:41
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 6.36 ms

select a.*, b.`post_id`, b.`primary` 
  from `bos_easyblog_category` as a 
  inner join `bos_easyblog_post_category` as b 
  on a.`id` = b.`category_id` 
  where b.`post_id` IN ( 60)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	eb_post_category_postid,eb_post_category_catid,eb_post_category_post_cat,eb_post_category_cat_post	eb_post_category_postid	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	8	webdesi5_castletown.b.category_id	1	100.00	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
14	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/category.php:1550
13	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/category.php:1550
12	EasyBlogModelCategory->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:621
11	EasyBlogCache->cacheCategories()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:281
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:41
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.99 ms After last query: 8.41 ms

select a.*, b.`post_id` 
  from `bos_easyblog_tag` as a 
  inner join `bos_easyblog_post_tag` as b 
  on a.`id` = b.`tag_id` 
  where b.`post_id` IN ( 60)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	easyblog_post_tag_tag_id,easyblog_post_tag_post_id,easyblog_post_tagpost_id	easyblog_post_tag_post_id	8	const	5	100.00	NULL
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	8	webdesi5_castletown.b.tag_id	1	100.00	NULL

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Same as call in the line below.
15	call_user_func_array()	JROOT/administrator/components/com_easyblog/includes/utils.php:278
14	EasyBlogDbJoomla->__call()	JROOT/administrator/components/com_easyblog/models/tags.php:804
13	EasyBlogDbJoomla->loadObjectList()	JROOT/administrator/components/com_easyblog/models/tags.php:804
12	EasyBlogModelTags->preloadByPosts()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:699
11	EasyBlogCache->cacheTags()	JROOT/administrator/components/com_easyblog/includes/cache/cache.php:284
10	EasyBlogCache->insert()	JROOT/components/com_easyblog/views/entry/view.html.php:41
9	EasyBlogViewEntry->display()	JROOT/components/com_easyblog/controllers/controller.php:105
8	EasyBlogController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easyblog/easyblog.php:37
6	require_once JROOT/components/com_easyblog/easyblog.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 10.40 ms

Blood Pressure 24 Hour Home Monitor - Available to Rent

Wondering what your blood pressure is?

About the author

Pery

Author's recent posts

Search our Site

FULL HEALTH CHECK €19.95

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

102 Queries Logged 98.20 ms

24 duplicate found!

Blood Pressure 24 Hour Home Monitor - Available to Rent

Wondering what your blood pressure is?

About the author

Pery

Author's recent posts

Search our Site

FULL HEALTH CHECK €19.95

Parking

Opening Hours

Contact Details

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

102 Queries Logged 98.20 ms

24 duplicate found!