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

25 February 2020

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
26	27	28	29	30	31	1
2	3	4	5	6 The Carpenters ...	7 The Carpenters ...	8
9	10	11	12 Golden Melodies ...	13 Free Heritage T ...	14	15
16 A very Royal Va ...	17 Abertillery Pla ... Ebbw Vale Plays ...	18 Cardiff City FC ... Tredegar Playsc ... Goldilocks Stor ...	19 Abertillery Pla ... Kites & Lantern ...	20 Nerf Wars Ebbw vale Plays ... Tredegar Playsc ...	21 Abertillery Pla ... Build a Nest Bo ... The Dinosaur Sh ...	22 Mother's Day Su ...
23	24	25	26	27	28	29

Show events from all categories

February Half Term Fun with Aneurin Leisure

This February Half Term we have a fun filled week of activities planned for children of all ages at our Aneurin Leisure venues.Throughout half term ...

Posted: 12 February 2020

Work Set to Begin on New Play Area at Parc Bryn Bach

Work is due to begin this week on our new adventure play area at Parc Bryn Bach! The existing play area will be dismantled at the end of this week, an...

Posted: 10 February 2020

Exciting Play Area Development at Parc Bryn Bach

Our plans to improve the facilities at Parc Bryn Bach with a new Adventure Play Area and Bunkhouse accommodation are off to a flying st...

Posted: 07 February 2020

Latest Events

Go to Events

Jukebox Heroes 3 with Owen Money
Date: Fri Mar 06 @ 7:30PM -
Location:The Met
Following the huge success of Jukebox Heroes in 2016, and then in 2018 Owen Mo...
Read more
I Want That Hair
Date: Fri Mar 13 @ 7:30PM -
Location:The Met
Set in a fading hairdresser’s, in a town in northern England, ‘I Want That H...
Read more
Women's GO TRI
Date: Sat Mar 14 @ 9:00AM -
Location:Ebbw Vale Sports Centre
This event is running in honour of International Women's Day and includes: 2...
Read more
An Evening with Rugby Legend: Jonathan 'Fox' Davies
Date: Thu Mar 19 @ 7:00PM -
Location:Bedwellty House & Park
Join Wales Centre and British Lions Player of the Series (New Zealand 2017) Jona...
Read more
Mummy & Me Afternoon Tea
Date: Sat Mar 21
Location:Bedwellty House & Park
After last year's success, we are so pleased to once again be offering this love...
Read more
Mother's Day Afternoon Teas
Date: Sat Mar 21 @12:00PM - 05:00PM
Location:Bedwellty House & Park
Treat your Mum to a special dining experience this Mother's Day!Join us for a de...
Read more
Mike Doyle - Rocking with Laughter
Date: Sat Mar 21 @ 7:30PM -
Location:The Met
Come and join Mike Doyle and his fabulous live band for a sensational evening of...
Read more
Mother's Day Afternoon Tea
Date: Sun Mar 22 @ 3:30PM - 05:00PM
Location:Bedwellty House & Park
Treat your Mum to a special dining experience this Mother's Day!Join us for a de...
Read more
Rhymney Millennium Mixed Choral Concert
Date: Thu Mar 26 @ 7:30PM -
Location:The Met
An evening of great music with this local mixed choir and special guest artist S...
Read more

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1582609160,
                "last": 1582609160,
                "now": 1582609160
            },
            "token": "W9OFQbef1di6o1ivouAYZwwxitpuA1MN"
        },
        "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: 30.49 ms / 30.49 ms Memory: 0.181 MB / 0.40 MB Application: afterLoad

Time: 188.69 ms / 219.18 ms Memory: 1.962 MB / 2.36 MB Application: afterInitialise

Time: 53.64 ms / 272.82 ms Memory: 0.936 MB / 3.30 MB Application: afterRoute

Time: 4.44 ms / 277.26 ms Memory: 0.115 MB / 3.41 MB Application: beforeRenderComponent com_jevents

Time: 372.95 ms / 650.21 ms Memory: 3.318 MB / 6.73 MB Application: afterRenderComponent com_jevents

Time: 2.65 ms / 652.86 ms Memory: 0.009 MB / 6.74 MB Application: afterDispatch

Time: 3.46 ms / 656.32 ms Memory: 0.047 MB / 6.79 MB Application: beforeRenderModule mod_jevents_latest (Latest Events)

Time: 57.20 ms / 713.52 ms Memory: 0.345 MB / 7.13 MB Application: afterRenderModule mod_jevents_latest (Latest Events)

Time: 0.43 ms / 713.95 ms Memory: 0.000 MB / 6.94 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 11.57 ms / 725.53 ms Memory: 0.051 MB / 6.99 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.36 ms / 725.89 ms Memory: 0.000 MB / 6.99 MB Application: beforeRenderModule mod_latestblogs (Latest Blogs)

Time: 248.63 ms / 974.52 ms Memory: 3.509 MB / 10.50 MB Application: afterRenderModule mod_latestblogs (Latest Blogs)

Time: 0.33 ms / 974.85 ms Memory: 0.000 MB / 10.36 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 5.55 ms / 980.40 ms Memory: 0.034 MB / 10.39 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.26 ms / 980.66 ms Memory: 0.000 MB / 10.39 MB Application: beforeRenderModule mod_fpss (Slideshow)

Time: 48.51 ms / 1029.18 ms Memory: 0.617 MB / 11.01 MB Application: afterRenderModule mod_fpss (Slideshow)

Time: 0.73 ms / 1029.90 ms Memory: 0.000 MB / 10.61 MB Application: beforeRenderModule mod_menu (Header Bottom Menu - Desktop)

Time: 2.92 ms / 1032.82 ms Memory: 0.028 MB / 10.64 MB Application: afterRenderModule mod_menu (Header Bottom Menu - Desktop)

Time: 0.17 ms / 1032.99 ms Memory: 0.000 MB / 10.64 MB Application: beforeRenderModule mod_search (Search)

Time: 6.10 ms / 1039.09 ms Memory: 0.030 MB / 10.67 MB Application: afterRenderModule mod_search (Search)

Time: 0.23 ms / 1039.32 ms Memory: 0.000 MB / 10.66 MB Application: beforeRenderModule mod_menu (Header Top Menu)

Time: 4.44 ms / 1043.76 ms Memory: 0.034 MB / 10.69 MB Application: afterRenderModule mod_menu (Header Top Menu)

Time: 74.80 ms / 1118.56 ms Memory: 0.363 MB / 11.06 MB Application: afterRender

Database queries total: 85.58 ms

Memory Usage

Database Queries

69 Queries Logged 85.58 ms

8 duplicate found!

2 duplicates: #25 #29

2 duplicates: #26 #30

2 duplicates: #27 #31

2 duplicates: #28 #32

Query Time: 0.39 ms Query memory: 0.018 MB Memory before query: 0.896 MB Rows returned: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = '3049608af64f89eda5619ce8d9aec225'

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.08 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	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
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.31 ms After last query: 7.03 ms Query memory: 0.012 MB Memory before query: 0.962 MB Rows returned: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = '3049608af64f89eda5619ce8d9aec225' 
  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.06 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.05 ms
executing	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
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: 13.18 ms After last query: 0.24 ms Query memory: 0.009 MB Memory before query: 0.974 MB

INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('3049608af64f89eda5619ce8d9aec225', 0, '1582609160')

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('3049608af64f89eda5619ce8d9aec225', 0, '1582609160')

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.10 ms
end	0.01 ms
query end	12.93 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php: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.66 ms After last query: 11.18 ms Query memory: 0.030 MB Memory before query: 1.057 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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.29 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
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.46 ms After last query: 4.39 ms Query memory: 0.014 MB Memory before query: 1.150 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.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.06 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
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.28 ms After last query: 1.71 ms Query memory: 0.013 MB Memory before query: 1.170 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.05 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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 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: 0.83 ms After last query: 0.32 ms Query memory: 0.013 MB Memory before query: 1.189 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.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.46 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
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.35 ms After last query: 15.18 ms Query memory: 0.017 MB Memory before query: 1.390 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.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	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
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.28 ms After last query: 0.22 ms Query memory: 0.017 MB Memory before query: 1.407 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 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.23 ms After last query: 0.16 ms Query memory: 0.019 MB Memory before query: 1.422 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 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: 0.80 ms After last query: 15.49 ms Query memory: 0.024 MB Memory before query: 1.724 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.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.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.02 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.44 ms After last query: 66.19 ms Query memory: 0.033 MB Memory before query: 2.422 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.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.89 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/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.55 ms After last query: 12.42 ms Query memory: 0.016 MB Memory before query: 3.068 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.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.15 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
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.24 ms After last query: 1.49 ms Query memory: 0.017 MB Memory before query: 3.088 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.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.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.31 ms After last query: 0.30 ms Query memory: 0.017 MB Memory before query: 3.104 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

  WHERE (`ip`='34.204.183.113' 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 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.82 ms After last query: 0.27 ms Query memory: 0.017 MB Memory before query: 3.121 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

  WHERE (`ip`='34.204.183.113' 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	502	99.60	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.60 ms
end	0.01 ms
query end	0.00 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: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.30 ms After last query: 3.07 ms Query memory: 0.018 MB Memory before query: 3.149 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 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
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.45 ms After last query: 1.94 ms Query memory: 0.025 MB Memory before query: 3.185 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.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.11 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
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.69 ms After last query: 0.49 ms Query memory: 0.019 MB Memory before query: 3.193 MB

UPDATE `jos_extensions`

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

  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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.07 ms
updating	0.08 ms
end	0.01 ms
query end	13.38 ms
closing tables	0.02 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.52 ms After last query: 11.46 ms Query memory: 0.013 MB Memory before query: 3.381 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.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 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.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/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.51 ms After last query: 0.72 ms Query memory: 0.010 MB Memory before query: 3.402 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.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.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/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.46 ms After last query: 72.24 ms Query memory: 0.020 MB Memory before query: 4.068 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.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 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.06 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
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.37 ms After last query: 6.93 ms Query memory: 0.025 MB Memory before query: 4.105 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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 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
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.09 ms After last query: 2.16 ms Query memory: 0.025 MB Memory before query: 4.139 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	320	98.44	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.11 ms
preparing	0.03 ms
Creating tmp table	0.08 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.06 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
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.47 ms After last query: 23.57 ms Query memory: 0.031 MB Memory before query: 4.258 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.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.86 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
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.46 ms After last query: 27.83 ms Query memory: 0.034 MB Memory before query: 4.675 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.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 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
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.35 ms After last query: 4.89 ms Query memory: 0.035 MB Memory before query: 4.715 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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: 0.19 ms After last query: 0.24 ms Query memory: 0.035 MB Memory before query: 4.750 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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.48 ms After last query: 5.01 ms Query memory: 0.032 MB Memory before query: 4.656 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.12 ms
checking permissions	0.01 ms
checking permissions	0.00 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.12 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.88 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/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.29 ms After last query: 7.28 ms Query memory: 0.035 MB Memory before query: 4.969 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.05 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.06 ms
preparing	0.01 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/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.22 ms After last query: 2.43 ms Query memory: 0.036 MB Memory before query: 5.009 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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
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.18 ms After last query: 0.21 ms Query memory: 0.036 MB Memory before query: 5.044 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.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
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.90 ms After last query: 4.25 ms Query memory: 0.034 MB Memory before query: 4.982 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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
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: 1.94 ms After last query: 10.25 ms Query memory: 0.037 MB Memory before query: 5.122 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.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.05 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
Creating tmp table	0.10 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.07 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.47 ms
Creating sort index	0.09 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.01 ms
freeing items	0.03 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.50 ms After last query: 0.90 ms Query memory: 0.026 MB Memory before query: 5.185 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.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.11 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
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.53 ms After last query: 2.64 ms Query memory: 0.052 MB Memory before query: 5.227 MB Rows returned: 19

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-02-01 00:00:00' 
  AND rpt.startrepeat <= '2020-02-29 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	78	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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	1.84 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
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.19 ms After last query: 52.62 ms Query memory: 0.040 MB Memory before query: 6.040 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.08 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.01 ms
Opening tables	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.09 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.03 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.72 ms After last query: 42.96 ms Query memory: 0.033 MB Memory before query: 6.425 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.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.17 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
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.49 ms After last query: 12.20 ms Query memory: 0.029 MB Memory before query: 6.559 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.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 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.04 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
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.31 ms After last query: 2.11 ms Query memory: 0.030 MB Memory before query: 6.592 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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.00 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/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: 0.81 ms After last query: 65.43 ms Query memory: 0.034 MB Memory before query: 6.677 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.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 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.01 ms
closing tables	0.01 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.77 ms After last query: 29.93 ms Query memory: 0.047 MB Memory before query: 6.884 MB Rows returned: 9

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-02-25 05:39:20' 
  AND rpt.startrepeat <= '2020-03-26 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	45	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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 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.20 ms
preparing	0.08 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.05 ms
Creating sort index	0.64 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.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.40 ms After last query: 3.06 ms Query memory: 0.042 MB Memory before query: 7.077 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-02-25 05:39:20' 
  AND rpt.startrepeat <= '2020-02-25 05:39:20' 
  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	45	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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.51 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.04 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
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.22 ms After last query: 0.38 ms Query memory: 0.042 MB Memory before query: 7.101 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-02-25 05:39:20' 
  AND rpt.startrepeat <= '2020-02-25 05:39:20' 
  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	45	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.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.06 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.48 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.04 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
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.93 ms After last query: 110.50 ms Query memory: 0.031 MB Memory before query: 7.574 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.01 ms
checking permissions	0.01 ms
Opening tables	0.24 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.05 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.09 ms
closing tables	0.01 ms
freeing items	0.04 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.32 ms After last query: 0.48 ms Query memory: 0.038 MB Memory before query: 7.611 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.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 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: 0.85 ms After last query: 49.01 ms Query memory: 0.036 MB Memory before query: 8.312 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.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.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/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.29 ms After last query: 0.34 ms Query memory: 0.027 MB Memory before query: 8.362 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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.68 ms After last query: 0.26 ms Query memory: 0.027 MB Memory before query: 8.391 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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.21 ms
Creating sort index	0.06 ms
end	0.01 ms
removing tmp table	0.05 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
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: 0.73 ms After last query: 5.01 ms Query memory: 0.035 MB Memory before query: 8.461 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.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.05 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.27 ms After last query: 2.47 ms Query memory: 0.029 MB Memory before query: 8.528 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.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.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.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.45 ms After last query: 0.87 ms Query memory: 0.033 MB Memory before query: 8.564 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.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.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.22 ms
end	0.01 ms
query end	0.00 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()	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.56 ms After last query: 0.47 ms Query memory: 0.032 MB Memory before query: 8.637 MB Rows returned: 36