New Season of Shows at The Met, Abertillery

Try a game of Footgolf at Parc Bryn Bach this Summer

New Courses for Adults brochure available to download


By Month	Jump to month

17 January 2020

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
29	30	31	1	2	3 Groovy UV Show	4 Live Superstars ...
5	6	7	8	9 Heritage Talk Beauty & The Be ...	10 Beauty & The Be ... Beauty & The Be ...	11 Beauty & The Be ... Beauty & The Be ...
12 Beauty & The Be ...	13 Mari Lwyd Les Mills: The ...	14 Murder Most Fou ... Murder Most Fou ...	15	16	17	18
19	20	21	22 Up Pompeii	23	24	25
26 Wedding Fayre	27	28	29	30	31	1

Show events from all categories

Libraries Poetry & Short Story Competition 2020

Following on from the success of last year's inaugural creative writing competition, our Blaenau Gwent Libraries Service are once again running a Shor...

Posted: 10 January 2020

New Year New Goals

Whether you have specific health and fitness goals for 2020, or you’ve just over-indulged during the Christmas holidays and want to get back on trac...

Posted: 06 January 2020

The Superstars of Welsh Wrestling Return to The Met

If you’re looking for a post-Christmas treat to enjoy with the family, join us for a one-night wrestling extravaganza at The Met in Abertillery on S...

Posted: 19 December 2019

Latest Events

Go to Events

Up Pompeii
Date: Wed Jan 22 @ 7:30PM -
Location:The Met
Based on the original characters in the Frankie Howerd BBC comedy, this hilariou...
Read more
Wedding Fayre
Date: Sun Jan 26 @11:00AM - 03:00PM
Location:Bedwellty House & Park
Join us for our next wonderful Wedding Fayre at Bedwellty House & Park.We'll be ...
Read more
The Carpenters Experience
Date: Thu Feb 06 @ 8:00PM -
Location:The Met
Back by popular demand!The Carpenters Experience are the UK's leading tribute t...
Read more
The Carpenters Experience
Date: Fri Feb 07 @ 8:00PM -
Location:The Met
Back by popular demand!The Carpenters Experience are the UK's leading tribute t...
Read more
Golden Melodies with Craig & Jason
Date: Wed Feb 12 @ 2:00PM -
Location:The Met
Join us at The Met for an afternoon of golden oldie songs and entertainment with...
Read more

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1579265926,
                "last": 1579265926,
                "now": 1579265926
            },
            "token": "Z9oSYQOm4NmIK4dQkxOhb7pZmVgWNNMn"
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "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": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_rsfirewall": {
            "geoip": ""
        }
    }
}

Profile Information

Time

Memory

Time: 35.06 ms / 35.06 ms Memory: 0.180 MB / 0.45 MB Application: afterLoad

Time: 208.27 ms / 243.33 ms Memory: 1.961 MB / 2.41 MB Application: afterInitialise

Time: 56.20 ms / 299.53 ms Memory: 0.936 MB / 3.34 MB Application: afterRoute

Time: 5.06 ms / 304.59 ms Memory: 0.116 MB / 3.46 MB Application: beforeRenderComponent com_jevents

Time: 372.68 ms / 677.27 ms Memory: 3.194 MB / 6.65 MB Application: afterRenderComponent com_jevents

Time: 2.59 ms / 679.86 ms Memory: 0.009 MB / 6.66 MB Application: afterDispatch

Time: 3.77 ms / 683.63 ms Memory: 0.047 MB / 6.71 MB Application: beforeRenderModule mod_jevents_latest (Latest Events)

Time: 40.66 ms / 724.29 ms Memory: 0.251 MB / 6.96 MB Application: afterRenderModule mod_jevents_latest (Latest Events)

Time: 0.38 ms / 724.66 ms Memory: 0.000 MB / 6.85 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 11.07 ms / 735.73 ms Memory: 0.051 MB / 6.90 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.36 ms / 736.09 ms Memory: 0.000 MB / 6.90 MB Application: beforeRenderModule mod_latestblogs (Latest Blogs)

Time: 257.10 ms / 993.20 ms Memory: 3.433 MB / 10.33 MB Application: afterRenderModule mod_latestblogs (Latest Blogs)

Time: 0.37 ms / 993.56 ms Memory: 0.000 MB / 10.27 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 6.25 ms / 999.81 ms Memory: 0.034 MB / 10.30 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.29 ms / 1000.10 ms Memory: 0.000 MB / 10.30 MB Application: beforeRenderModule mod_fpss (Slideshow)

Time: 50.96 ms / 1051.06 ms Memory: 0.617 MB / 10.92 MB Application: afterRenderModule mod_fpss (Slideshow)

Time: 0.80 ms / 1051.86 ms Memory: 0.000 MB / 10.52 MB Application: beforeRenderModule mod_menu (Header Bottom Menu - Desktop)

Time: 3.03 ms / 1054.89 ms Memory: 0.028 MB / 10.55 MB Application: afterRenderModule mod_menu (Header Bottom Menu - Desktop)

Time: 0.21 ms / 1055.10 ms Memory: 0.000 MB / 10.55 MB Application: beforeRenderModule mod_search (Search)

Time: 7.31 ms / 1062.42 ms Memory: 0.030 MB / 10.57 MB Application: afterRenderModule mod_search (Search)

Time: 0.35 ms / 1062.77 ms Memory: 0.000 MB / 10.57 MB Application: beforeRenderModule mod_menu (Header Top Menu)

Time: 4.83 ms / 1067.60 ms Memory: 0.035 MB / 10.60 MB Application: afterRenderModule mod_menu (Header Top Menu)

Time: 80.07 ms / 1147.68 ms Memory: 0.351 MB / 10.95 MB Application: afterRender

Database queries total: 97.82 ms

Memory Usage

Database Queries

69 Queries Logged 97.82 ms

8 duplicate found!

2 duplicates: #25 #29

2 duplicates: #26 #30

2 duplicates: #27 #31

2 duplicates: #28 #32

Query Time: 0.66 ms Query memory: 0.018 MB Memory before query: 0.943 MB Rows returned: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = '2itumtk11v77d3icuduq7o74q5'

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.55 ms After last query: 8.16 ms Query memory: 0.012 MB Memory before query: 1.009 MB Rows returned: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = '2itumtk11v77d3icuduq7o74q5' 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 14.33 ms After last query: 0.25 ms Query memory: 0.009 MB Memory before query: 1.021 MB

INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('2itumtk11v77d3icuduq7o74q5', 0, '1579265926')

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('2itumtk11v77d3icuduq7o74q5', 0, '1579265926')

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	13.85 ms
closing tables	0.05 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.95 ms After last query: 12.42 ms Query memory: 0.030 MB Memory before query: 1.104 MB Rows returned: 41

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

  FROM jos_extensions

  WHERE `type` = 'component'

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.32 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.79 ms After last query: 4.49 ms Query memory: 0.014 MB Memory before query: 1.197 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Using where
1	SIMPLE	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:423
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.48 ms After last query: 1.84 ms Query memory: 0.013 MB Memory before query: 1.217 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1497
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:440
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.00 ms After last query: 0.36 ms Query memory: 0.013 MB Memory before query: 1.236 MB Rows returned: 57

SELECT folder AS type, element AS name, params

  FROM jos_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.57 ms After last query: 16.44 ms Query memory: 0.017 MB Memory before query: 1.437 MB Rows returned: 0

SELECT `path`

  FROM jos_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:52
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

[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.25 ms Query memory: 0.017 MB Memory before query: 1.454 MB Rows returned: 0

SELECT `file`

  FROM jos_rsfirewall_hashes

  WHERE `type`='protect'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:59
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

[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.18 ms Query memory: 0.019 MB Memory before query: 1.469 MB Rows returned: 51

SELECT *

  FROM jos_rsfirewall_configuration

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:67
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.09 ms After last query: 16.28 ms Query memory: 0.024 MB Memory before query: 1.771 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `jos_rsfirewall_logs`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:35
11	RSFirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:305
10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:22
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:56
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:662
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.59 ms After last query: 74.46 ms Query memory: 0.033 MB Memory before query: 2.468 MB Rows returned: 55

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.79 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.77 ms After last query: 12.90 ms Query memory: 0.016 MB Memory before query: 3.115 MB Rows returned: 0

SELECT *

  FROM jos_rsfirewall_hashes

  WHERE (`type`='3.5.1' OR `type`='protect') 
  AND `flag`!='C'

Explain

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

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:947
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.36 ms After last query: 1.50 ms Query memory: 0.017 MB Memory before query: 3.134 MB Rows returned: 0

SELECT *

  FROM jos_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:46
10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:970
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.45 ms After last query: 0.31 ms Query memory: 0.017 MB Memory before query: 3.151 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

  WHERE (`ip`='3.83.32.171' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_rsfirewall_lists	ref	published,type	type	1	const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
10	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:998
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.95 ms After last query: 0.30 ms Query memory: 0.017 MB Memory before query: 3.167 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

  WHERE (`ip`='3.83.32.171' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_rsfirewall_lists	ALL	published,type	NO INDEX KEY COULD BE USED	NULL	NULL	485	99.59	Using where

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
10	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1002
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.48 ms After last query: 3.14 ms Query memory: 0.018 MB Memory before query: 3.196 MB Rows returned: 1

SELECT *

  FROM jos_rsfirewall_exceptions

  WHERE `published`='1'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:640
10	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1050
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.66 ms After last query: 2.02 ms Query memory: 0.025 MB Memory before query: 3.231 MB Rows returned: 1

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

  FROM jos_extensions

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

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
19	JDatabaseDriver->loadObject()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
17	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
16	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
15	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
14	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
13	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
12	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
11	JFactory::getDocument()	JROOT/plugins/system/cachecleaner/cachecleaner.php:60
10	plgSystemCacheCleaner->getHelper()	JROOT/plugins/system/cachecleaner/cachecleaner.php:30
9	plgSystemCacheCleaner->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 13.24 ms After last query: 0.53 ms Query memory: 0.019 MB Memory before query: 3.240 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"f7ab67671ded94b87071e7637b7cd350\"}'

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.08 ms
updating	0.09 ms
end	0.02 ms
query end	12.77 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
15	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
14	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
13	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
12	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
11	JFactory::getDocument()	JROOT/plugins/system/cachecleaner/cachecleaner.php:60
10	plgSystemCacheCleaner->getHelper()	JROOT/plugins/system/cachecleaner/cachecleaner.php:30
9	plgSystemCacheCleaner->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.72 ms After last query: 11.97 ms Query memory: 0.013 MB Memory before query: 3.428 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.73 ms After last query: 0.78 ms Query memory: 0.010 MB Memory before query: 3.449 MB Rows returned: 5

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.64 ms After last query: 74.27 ms Query memory: 0.019 MB Memory before query: 4.115 MB Rows returned: 1

SELECT template

  FROM jos_template_styles

  WHERE id ='11'

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:44
12	JEventsAbstractView->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:48
11	JEventsDefaultView->__construct()	JROOT/libraries/legacy/controller/legacy.php:622
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:863
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/month.php:51
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.63 ms After last query: 7.19 ms Query memory: 0.024 MB Memory before query: 4.151 MB Rows returned: 1

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
15	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:1986
14	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2068
13	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:36
12	JEventsDataModel->JEventsDataModel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:57
11	JEventsDefaultView->__construct()	JROOT/libraries/legacy/controller/legacy.php:622
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:863
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/month.php:51
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.31 ms After last query: 2.32 ms Query memory: 0.025 MB Memory before query: 4.185 MB Rows returned: 2

SELECT b.rules

  FROM jos_assets AS a

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

  WHERE (a.name = 'com_jevents')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	316	98.42	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.46 ms
Creating sort index	0.06 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:1986
14	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2068
13	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:36
12	JEventsDataModel->JEventsDataModel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:57
11	JEventsDefaultView->__construct()	JROOT/libraries/legacy/controller/legacy.php:622
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:863
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/month.php:51
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.75 ms After last query: 24.22 ms Query memory: 0.031 MB Memory before query: 4.304 MB Rows returned: 24

Duplicate queries: #29

SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM jos_modules AS m

  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN jos_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.client_id = 0 
  AND m.access IN (1,1,5)

  ORDER BY m.ordering, m.id

Explain

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

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.86 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/modulehelper.php:455
18	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:366
17	JModuleHelper::_load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
16	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:102
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.63 ms After last query: 27.45 ms Query memory: 0.034 MB Memory before query: 4.721 MB Rows returned: 1

Duplicate queries: #30

SELECT m.menutype

  FROM jos_menu AS m

  WHERE m.id = 105

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
26	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:75
25	NNFrameworkAssignmentsMenu->getMenuType()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:27
24	NNFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:293
23	NNFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:270
22	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
19	JApplicationBase->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
18	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:366
17	JModuleHelper::_load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
16	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:102
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.52 ms After last query: 4.90 ms Query memory: 0.035 MB Memory before query: 4.761 MB Rows returned: 1

Duplicate queries: #31

SELECT t.parent_id

  FROM jos_menu as t

  WHERE t.id = 105

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
27	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments.php:455
26	NNFrameworkAssignmentsHelper->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:63
25	NNFrameworkAssignmentsMenu->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:39
24	NNFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:293
23	NNFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:270
22	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
19	JApplicationBase->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
18	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:366
17	JModuleHelper::_load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
16	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:102
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.33 ms After last query: 0.26 ms Query memory: 0.035 MB Memory before query: 4.795 MB Rows returned: 1

Duplicate queries: #32

SELECT t.parent_id

  FROM jos_menu as t

  WHERE t.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
27	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments.php:455
26	NNFrameworkAssignmentsHelper->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:63
25	NNFrameworkAssignmentsMenu->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:39
24	NNFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:293
23	NNFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:270
22	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
20	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
19	JApplicationBase->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
18	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:366
17	JModuleHelper::_load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
16	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:102
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.67 ms After last query: 5.08 ms Query memory: 0.033 MB Memory before query: 4.701 MB Rows returned: 24

Duplicate queries: #25

SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM jos_modules AS m

  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN jos_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.client_id = 0 
  AND m.access IN (1,1,5)

  ORDER BY m.ordering, m.id

Explain

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

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.83 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/modulehelper.php:455
19	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:52
18	JModuleHelper::getModule()	JROOT/components/com_jevents/libraries/filters.php:302
17	jevFilter->jevFilter()	JROOT/components/com_jevents/libraries/filters/Published.php:45
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.56 ms After last query: 7.37 ms Query memory: 0.035 MB Memory before query: 5.014 MB Rows returned: 1

Duplicate queries: #26

SELECT m.menutype

  FROM jos_menu AS m

  WHERE m.id = 105

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
27	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:75
26	NNFrameworkAssignmentsMenu->getMenuType()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:27
25	NNFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:293
24	NNFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:270
23	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
21	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
20	JApplicationBase->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
19	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:52
18	JModuleHelper::getModule()	JROOT/components/com_jevents/libraries/filters.php:302
17	jevFilter->jevFilter()	JROOT/components/com_jevents/libraries/filters/Published.php:45
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.40 ms After last query: 2.53 ms Query memory: 0.036 MB Memory before query: 5.055 MB Rows returned: 1

Duplicate queries: #27

SELECT t.parent_id

  FROM jos_menu as t

  WHERE t.id = 105

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
28	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments.php:455
27	NNFrameworkAssignmentsHelper->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:63
26	NNFrameworkAssignmentsMenu->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:39
25	NNFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:293
24	NNFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:270
23	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
21	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
20	JApplicationBase->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
19	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:52
18	JModuleHelper::getModule()	JROOT/components/com_jevents/libraries/filters.php:302
17	jevFilter->jevFilter()	JROOT/components/com_jevents/libraries/filters/Published.php:45
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.29 ms After last query: 0.24 ms Query memory: 0.036 MB Memory before query: 5.090 MB Rows returned: 1

Duplicate queries: #28

SELECT t.parent_id

  FROM jos_menu as t

  WHERE t.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
28	JDatabaseDriver->loadResult()	JROOT/plugins/system/nnframework/helpers/assignments.php:455
27	NNFrameworkAssignmentsHelper->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:63
26	NNFrameworkAssignmentsMenu->getParentIds()	JROOT/plugins/system/nnframework/helpers/assignments/menu.php:39
25	NNFrameworkAssignmentsMenu->passMenu()	JROOT/plugins/system/nnframework/helpers/assignments.php:293
24	NNFrameworkAssignmentsHelper->passAll()	JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:270
23	plgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
22	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
21	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
20	JApplicationBase->triggerEvent()	JROOT/plugins/system/advancedmodules/modulehelper.php:508
19	JModuleHelper::load()	JROOT/plugins/system/advancedmodules/modulehelper.php:52
18	JModuleHelper::getModule()	JROOT/components/com_jevents/libraries/filters.php:302
17	jevFilter->jevFilter()	JROOT/components/com_jevents/libraries/filters/Published.php:45
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.17 ms After last query: 4.35 ms Query memory: 0.034 MB Memory before query: 5.028 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `jos_jev_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:67
19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1930
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1015
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:48
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 2.21 ms After last query: 10.87 ms Query memory: 0.037 MB Memory before query: 5.167 MB Rows returned: 5

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_jevents' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	ALL	cat_idx,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	36	19.44	Using where; Using temporary; Using filesort
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	newlife_v1.c.id	7	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	36	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.05 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.02 ms
Sending data	0.08 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.04 ms
removing tmp table	0.01 ms
Creating sort index	0.48 ms
Creating sort index	0.10 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
21	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:47
20	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
19	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:76
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:881
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.76 ms After last query: 0.94 ms Query memory: 0.026 MB Memory before query: 5.231 MB Rows returned: 4

SELECT c.id

  FROM jos_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('en-GB','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	5	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:141
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:881
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1974
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 2.09 ms After last query: 2.79 ms Query memory: 0.050 MB Memory before query: 5.273 MB Rows returned: 15

SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM jos_jevents_repetition as rpt
 
  LEFT JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  LEFT JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  LEFT JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,27,28,29,30)
 
  AND rpt.endrepeat >= '2020-01-01 00:00:00' 
  AND rpt.startrepeat <= '2020-01-31 23:59:59' 
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	rpt	range	eventid,eventstart,eventend,startrepeat,startend,endrepeat	endrepeat	8	NULL	36	100.00	Using index condition; Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx	PRIMARY	4	newlife_v1.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	newlife_v1.rpt.eventdetail_id	1	100.00	NULL
1	SIMPLE	rr	ref	eventid	eventid	4	newlife_v1.rpt.eventid	1	100.00	NULL

Profile

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.17 ms
preparing	0.07 ms
executing	0.01 ms
Sending data	1.17 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2203
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2163
13	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
12	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:239
11	JEventsDataModel->getCalendarData()	JROOT/components/com_jevents/views/default/month/view.html.php:35
10	DefaultViewMonth->calendar()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:72
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.43 ms After last query: 53.03 ms Query memory: 0.040 MB Memory before query: 5.979 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `jos_content`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
28	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
27	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
26	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:305
25	JTable::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11
24	DefaultLoadModules()	Same as call in the line below.
23	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
22	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:7
21	DefaultViewMonth->loadModules()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:7
20	DefaultViewHelperHeader16()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
17	DefaultViewMonth->_header16()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
16	DefaultViewHelperHeader()	Same as call in the line below.
15	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/month/tmpl/calendar.php:4
13	DefaultViewMonth->_header()	JROOT/components/com_jevents/views/default/month/tmpl/calendar.php:4
12	include JROOT/components/com_jevents/views/default/month/tmpl/calendar.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:209
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:90
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.93 ms After last query: 45.16 ms Query memory: 0.034 MB Memory before query: 6.364 MB Rows returned: 4

SELECT c.* 
  FROM jos_categories as c 
  WHERE extension='com_jevents' 
  order by c.lft asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	cat_idx	cat_idx	202	const	4	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:89
18	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:114
17	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:283
16	jEventCal->bgcolor()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_cell.php:343
15	EventCalendarCell_default->calendarCell()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php:78
14	include JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php	JROOT/libraries/legacy/view/legacy.php:670
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/month/tmpl/calendar.php:10
12	include JROOT/components/com_jevents/views/default/month/tmpl/calendar.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:209
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:90
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.76 ms After last query: 12.76 ms Query memory: 0.029 MB Memory before query: 6.498 MB Rows returned: 0

SELECT * 
  FROM jos_jev_defaults 
  WHERE state=1 
  AND name= 'month.calendar_cell' 
  AND language in ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_jev_defaults	ref	name,langcodename	name	52	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:21
19	DefaultLoadedFromTemplate()	Same as call in the line below.
18	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_cell.php:379
16	EventCalendarCell_default->loadedFromTemplate()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_cell.php:379
15	EventCalendarCell_default->calendarCell()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php:78
14	include JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php	JROOT/libraries/legacy/view/legacy.php:670
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/month/tmpl/calendar.php:10
12	include JROOT/components/com_jevents/views/default/month/tmpl/calendar.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:209
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:90
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.50 ms After last query: 2.07 ms Query memory: 0.030 MB Memory before query: 6.531 MB Rows returned: 1

SELECT * 
  FROM jos_jev_defaults 
  WHERE state=1 
  AND name= 'month.calendar_tip' 
  AND language in ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_jev_defaults	ref	name,langcodename	name	52	const	1	100.00	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:21
20	DefaultLoadedFromTemplate()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_cell.php:310
17	EventCalendarCell_default->loadedFromTemplate()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_cell.php:310
16	EventCalendarCell_default->calendarCell_tooltip()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_cell.php:442
15	EventCalendarCell_default->calendarCell()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php:78
14	include JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php	JROOT/libraries/legacy/view/legacy.php:670
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/month/tmpl/calendar.php:10
12	include JROOT/components/com_jevents/views/default/month/tmpl/calendar.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:209
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:90
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.04 ms After last query: 54.09 ms Query memory: 0.035 MB Memory before query: 6.607 MB Rows returned: 4

SELECT c.* 
  FROM jos_categories as c 
  WHERE extension='com_jevents' 
  AND  c.access   IN (1,1,5)
  
  AND c.language in ('en-GB','*') 
  AND c.published = 1
 
  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	5	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jevents_legend/tmpl/default/legend.php:261
20	DefaultModLegendView->getCategoryHierarchy()	JROOT/modules/mod_jevents_legend/tmpl/default/legend.php:153
19	DefaultModLegendView->displayCalendarLegend()	JROOT/components/com_jevents/views/default/helpers/defaulteventslegend.php:25
18	DefaultEventsLegend()	Same as call in the line below.
17	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php:93
15	DefaultViewMonth->eventsLegend()	JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php:93
14	include JROOT/components/com_jevents/views/default/month/tmpl/calendar_body.php	JROOT/libraries/legacy/view/legacy.php:670
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/default/month/tmpl/calendar.php:10
12	include JROOT/components/com_jevents/views/default/month/tmpl/calendar.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:209
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:90
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/month.php:69
8	MonthController->calendar()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:275
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 2.08 ms After last query: 30.88 ms Query memory: 0.045 MB Memory before query: 6.808 MB Rows returned: 5

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM jos_jevents_repetition as rpt
 
  LEFT JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  LEFT JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  LEFT JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,27,28,29,30)
 
  AND rpt.endrepeat >= '2020-01-17 12:58:46' 
  AND rpt.startrepeat <= '2020-02-16 23:59:59' 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using temporary; Using filesort
1	SIMPLE	rpt	range	eventid,eventstart,eventend,startrepeat,startend,endrepeat	endrepeat	8	NULL	20	100.00	Using index condition; Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx	PRIMARY	4	newlife_v1.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	newlife_v1.rpt.eventdetail_id	1	100.00	NULL
1	SIMPLE	rr	ref	eventid	eventid	4	newlife_v1.rpt.eventid	1	100.00	NULL

Profile

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.07 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.71 ms
Creating sort index	0.27 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2203
16	JEventsDBModel->_cachedlistIcalEvents()	Same as call in the line below.
15	call_user_func_array()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1063
13	JEventsDBModel->listLatestIcalEvents()	JROOT/templates/life-desktop/html/mod_jevents_latest/default/latest.php:291
12	DefaultModLatestView->getLatestEventsData()	JROOT/templates/life-desktop/html/mod_jevents_latest/default/latest.php:706
11	DefaultModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.57 ms After last query: 2.08 ms Query memory: 0.042 MB Memory before query: 6.922 MB Rows returned: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM jos_jevents_repetition as rpt
 
  LEFT JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  LEFT JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  LEFT JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,27,28,29,30)
 
  AND rpt.endrepeat >= '2020-01-17 12:58:46' 
  AND rpt.startrepeat <= '2020-01-17 12:58:46' 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using temporary; Using filesort
1	SIMPLE	rpt	range	eventid,eventstart,eventend,startrepeat,startend,endrepeat	endrepeat	8	NULL	20	100.00	Using index condition; Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx	PRIMARY	4	newlife_v1.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	newlife_v1.rpt.eventdetail_id	1	100.00	NULL
1	SIMPLE	rr	ref	eventid	eventid	4	newlife_v1.rpt.eventid	1	100.00	NULL

Profile

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.07 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.45 ms
Creating sort index	0.03 ms
end	0.01 ms
removing tmp table	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2203
16	JEventsDBModel->_cachedlistIcalEvents()	Same as call in the line below.
15	call_user_func_array()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1100
13	JEventsDBModel->listLatestIcalEvents()	JROOT/templates/life-desktop/html/mod_jevents_latest/default/latest.php:291
12	DefaultModLatestView->getLatestEventsData()	JROOT/templates/life-desktop/html/mod_jevents_latest/default/latest.php:706
11	DefaultModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.50 ms After last query: 0.47 ms Query memory: 0.041 MB Memory before query: 6.945 MB Rows returned: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM jos_jevents_repetition as rpt
 
  LEFT JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  LEFT JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  LEFT JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,27,28,29,30)
 
  AND rpt.endrepeat >= '2020-01-17 12:58:46' 
  AND rpt.startrepeat <= '2020-01-17 12:58:46' 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using temporary; Using filesort
1	SIMPLE	rpt	range	eventid,eventstart,eventend,startrepeat,startend,endrepeat	endrepeat	8	NULL	20	100.00	Using index condition; Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx	PRIMARY	4	newlife_v1.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	newlife_v1.rpt.eventdetail_id	1	100.00	NULL
1	SIMPLE	rr	ref	eventid	eventid	4	newlife_v1.rpt.eventid	1	100.00	NULL

Profile

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.06 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.44 ms
Creating sort index	0.03 ms
end	0.01 ms
removing tmp table	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2203
16	JEventsDBModel->_cachedlistIcalEvents()	Same as call in the line below.
15	call_user_func_array()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1136
13	JEventsDBModel->listLatestIcalEvents()	JROOT/templates/life-desktop/html/mod_jevents_latest/default/latest.php:291
12	DefaultModLatestView->getLatestEventsData()	JROOT/templates/life-desktop/html/mod_jevents_latest/default/latest.php:706
11	DefaultModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.89 ms After last query: 97.47 ms Query memory: 0.031 MB Memory before query: 7.485 MB Rows returned: 2

SHOW FULL COLUMNS 
  FROM `jos_easyblog_configs`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
18	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
17	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/configs.php:39
16	EasyBlogTableConfigs->__construct()	JROOT/libraries/joomla/table/table.php:305
15	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
14	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
13	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/helpers/helper.php:591
12	EasyBlogHelper::getConfig()	JROOT/components/com_easyblog/helpers/helper.php:3486
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

[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.38 ms Query memory: 0.038 MB Memory before query: 7.522 MB Rows returned: 1

SELECT *

  FROM jos_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1456
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:728
13	JTable->load()	JROOT/components/com_easyblog/helpers/helper.php:592
12	EasyBlogHelper::getConfig()	JROOT/components/com_easyblog/helpers/helper.php:3486
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.15 ms After last query: 49.79 ms Query memory: 0.036 MB Memory before query: 8.222 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `jos_assets`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
21	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:61
20	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:305
19	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:100
18	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
17	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
16	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
15	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
14	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
13	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
12	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3526
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.49 ms After last query: 0.38 ms Query memory: 0.027 MB Memory before query: 8.273 MB Rows returned: 1

SELECT id

  FROM jos_assets

  WHERE parent_id = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1216
19	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:101
18	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
17	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
16	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
15	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
14	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
13	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
12	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3526
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.90 ms After last query: 0.27 ms Query memory: 0.027 MB Memory before query: 8.301 MB Rows returned: 1

SELECT b.rules

  FROM jos_assets AS a

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

  WHERE (a.id = 1)

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	2	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.22 ms
Creating sort index	0.05 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
19	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
18	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
17	JUser->authorise()	JROOT/components/com_easyblog/helpers/helper.php:625
16	EasyBlogHelper::isSiteAdmin()	JROOT/components/com_easyblog/classes/themes.php:71
15	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
14	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
13	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
12	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3526
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 1.12 ms After last query: 5.20 ms Query memory: 0.035 MB Memory before query: 8.371 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `jos_easyblog_users`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
21	JTable->__construct()	JROOT/administrator/components/com_easyblog/tables/table.php:18
20	EasyBlogTable->__construct()	JROOT/administrator/components/com_easyblog/tables/profile.php:39
19	EasyBlogTableProfile->__construct()	JROOT/libraries/joomla/table/table.php:305
18	JTable::getInstance()	JROOT/administrator/components/com_easyblog/tables/table.php:54
17	EasyBlogTable::getInstance()	JROOT/components/com_easyblog/helpers/helper.php:539
16	EasyBlogHelper::getTable()	JROOT/components/com_easyblog/classes/themes.php:73
15	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
14	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
13	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
12	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3526
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.53 ms After last query: 2.60 ms Query memory: 0.029 MB Memory before query: 8.438 MB Rows returned: 1

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

Explain

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
23	JDatabaseDriver->loadResult()	Same as call in the line below.
22	call_user_func_array()	JROOT/components/com_easyblog/helpers/db.php:109
21	EasyBlogDbJoomla30->__call()	Same as call in the line below.
20	EasyBlogDbJoomla30->loadResult()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_easyblog/helpers/db.php:43
18	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/classes/themes.php:156
17	EasyBlogDBHelper->loadResult()	JROOT/components/com_easyblog/classes/themes.php:156
16	CodeThemes->_getThemeConfig()	JROOT/components/com_easyblog/classes/themes.php:106
15	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
14	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
13	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
12	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3526
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.72 ms After last query: 1.01 ms Query memory: 0.033 MB Memory before query: 8.474 MB Rows returned: 32

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
24	JDatabaseDriver->loadObjectList()	Same as call in the line below.
23	call_user_func_array()	JROOT/components/com_easyblog/helpers/db.php:109
22	EasyBlogDbJoomla30->__call()	Same as call in the line below.
21	EasyBlogDbJoomla30->loadObjectList()	Same as call in the line below.
20	call_user_func_array()	JROOT/components/com_easyblog/helpers/db.php:43
19	EasyBlogDBHelper->__call()	JROOT/components/com_easyblog/helpers/acl.php:317
18	EasyBlogDBHelper->loadObjectList()	JROOT/components/com_easyblog/helpers/acl.php:317
17	EasyBlogACLHelper::getRules()	JROOT/components/com_easyblog/helpers/acl.php:33
16	EasyBlogACLHelper::getRuleSet()	JROOT/components/com_easyblog/classes/themes.php:121
15	CodeThemes->__construct()	JROOT/components/com_easyblog/classes/compiler.php:259
14	EasyBlogCompiler->getResourcesSettings()	JROOT/components/com_easyblog/classes/compiler.php:145
13	EasyBlogCompiler->getResources()	JROOT/components/com_easyblog/classes/configuration.php:99
12	EasyBlogConfiguration->attach()	JROOT/components/com_easyblog/helpers/helper.php:3526
11	EasyBlogHelper::loadHeaders()	JROOT/modules/mod_latestblogs/mod_latestblogs.php:34
10	include JROOT/modules/mod_latestblogs/mod_latestblogs.php	JROOT/plugins/system/advancedmodules/modulehelper.php:208
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:50

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

Query Time: 0.80 ms After last query: 0.50 ms Query memory: 0.032 MB Memory before query: 8.547 MB Rows returned: 36