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

July 2018

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
1 Summer Bandstan ...	2	3	4	5	6	7
8 Summer Bandstan ...	9	10	11	12	13 LEGEND: The Bob ...	14
15 Summer Bandstan ...	16	17	18	19	20 Steve Jones 1 M ...	21
22 Summer Bandstan ...	23 Summer School	24 Summer School	25 Summer School	26 Summer School	27 Summer School	28
29 Summer Bandstan ...	30 Summer School	31 Summer School	1	2	3	4

Show events from all categories

Aneurin Leisure Christmas & New Year Opening Times

Christmas Eve Opening Times 2019 Abertillery Sports Centre 8.30am – 11.30am Tredegar Sports Centre 8.30am – 11.30am Ebbw...

Posted: 04 December 2019

Creative Writing Competition with Blaenau Gwent Libraries

This month our Blalenau Gwent Libraries Service has launched a brand-new Short Story and Poetry Competition which is open to adults and children, enco...

Posted: 03 December 2019

12 Days of Christmas

Looking to get a head start on your health and well-being goals for 2020? Don’t miss our fantastic 12 Days of Christmas life membership offer, which...

Posted: 03 December 2019

Latest Events

Go to Events

Adult Crafts for Christmas
Date: Thu Dec 12 @10:00AM - 12:00PM
Location:Blaenau Gwent Libraries
Join our Nurture, Equip, Thrive project team for a series of free adult craft se...
Read more
Environmental Volunteer Days
Date: Thu Dec 12 @10:00AM - 02:00PM
Location:Parc Bryn Bach
Would you like to volunteer for a good cause and meet like minded people?Join Bi...
Read more
Elf Day
Date: Fri Dec 13 @11:00AM - 02:00PM
Location:Ebbw Vale Learning Action Centre
Join us for Elf Day at Ebbw Vale Learning Action Centre as we raise money for th...
Read more
The West End at Christmas
Date: Fri Dec 13 @ 2:30PM -
Location:The Met
Matinee Performance at 2:30pm & Evening Performance at 7:30pm We are delighted...
Read more
Christmas Party Night with Fast Company
Date: Fri Dec 13 @ 7:00PM -
Location:Bedwellty House & Park
Add a touch of glitz and glamour to your festive season by celebrating Christmas...
Read more
The West End at Christmas
Date: Fri Dec 13 @ 7:30PM -
Location:The Met
Matinee Performance at 2:30pm & Evening Performance at 7:30pmWe are delighted t...
Read more
Breakfast with Santa
Date: Sat Dec 14 @10:00AM -
Location:Bedwellty House & Park
Join us at 10am for a scrumptious hot breakfast, freshly prepared by Mrs Claus, ...
Read more
Super Santa-Day
Date: Sat Dec 14 @12:00PM - 03:00PM
Location:Tredegar Sports Centre
Look who is going to be at Tredegar Sports Centre on the 14th December from 12pm...
Read more
Family Festive Afternoon Tea
Date: Sat Dec 14 @ 2:00PM - 04:00PM
Location:Bedwellty House & Park
Join us for a Traditional Bedwellty Afternoon Tea with a festive twist, served w...
Read more
Christmas Party Night with Fast Company
Date: Sat Dec 14 @ 7:00PM -
Location:Bedwellty House & Park
Add a touch of glitz and glamour to your festive season by celebrating Christmas...
Read more

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576025516,
                "last": 1576025516,
                "now": 1576025516
            },
            "token": "2mFiGhGKbZHvhIE9aZCoaQmswpZH7DsZ"
        },
        "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: 27.85 ms / 27.85 ms Memory: 0.180 MB / 0.45 MB Application: afterLoad

Time: 182.36 ms / 210.21 ms Memory: 1.962 MB / 2.41 MB Application: afterInitialise

Time: 61.26 ms / 271.48 ms Memory: 1.041 MB / 3.45 MB Application: afterRoute

Time: 4.93 ms / 276.41 ms Memory: 0.116 MB / 3.57 MB Application: beforeRenderComponent com_jevents

Time: 343.25 ms / 619.66 ms Memory: 3.070 MB / 6.64 MB Application: afterRenderComponent com_jevents

Time: 2.54 ms / 622.20 ms Memory: 0.009 MB / 6.64 MB Application: afterDispatch

Time: 3.34 ms / 625.54 ms Memory: 0.047 MB / 6.69 MB Application: beforeRenderModule mod_jevents_latest (Latest Events)

Time: 68.68 ms / 694.22 ms Memory: 0.372 MB / 7.06 MB Application: afterRenderModule mod_jevents_latest (Latest Events)

Time: 0.55 ms / 694.77 ms Memory: 0.000 MB / 6.85 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 11.58 ms / 706.36 ms Memory: 0.051 MB / 6.90 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.34 ms / 706.70 ms Memory: 0.000 MB / 6.90 MB Application: beforeRenderModule mod_latestblogs (Latest Blogs)

Time: 251.19 ms / 957.89 ms Memory: 3.489 MB / 10.39 MB Application: afterRenderModule mod_latestblogs (Latest Blogs)

Time: 0.35 ms / 958.24 ms Memory: 0.000 MB / 10.27 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 5.71 ms / 963.95 ms Memory: 0.033 MB / 10.30 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

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

Time: 48.03 ms / 1012.27 ms Memory: 0.617 MB / 10.92 MB Application: afterRenderModule mod_fpss (Slideshow)

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

Time: 2.78 ms / 1015.69 ms Memory: 0.027 MB / 10.55 MB Application: afterRenderModule mod_menu (Header Bottom Menu - Desktop)

Time: 0.17 ms / 1015.86 ms Memory: 0.000 MB / 10.54 MB Application: beforeRenderModule mod_search (Search)

Time: 5.88 ms / 1021.74 ms Memory: 0.030 MB / 10.57 MB Application: afterRenderModule mod_search (Search)

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

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

Time: 72.87 ms / 1099.14 ms Memory: 0.358 MB / 10.96 MB Application: afterRender

Database queries total: 102.46 ms

Memory Usage

Database Queries

69 Queries Logged 102.46 ms

8 duplicate found!

2 duplicates: #25 #29

2 duplicates: #26 #30

2 duplicates: #27 #31

2 duplicates: #28 #32

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

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'dembupo2a66617sphe2hse0e10'

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.10 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 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.43 ms After last query: 6.75 ms Query memory: 0.012 MB Memory before query: 1.010 MB Rows returned: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'dembupo2a66617sphe2hse0e10' 
  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.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 15.53 ms After last query: 0.23 ms Query memory: 0.009 MB Memory before query: 1.022 MB

INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('dembupo2a66617sphe2hse0e10', 0, '1576025516')

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('dembupo2a66617sphe2hse0e10', 0, '1576025516')

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.12 ms
end	0.02 ms
query end	15.16 ms
closing tables	0.03 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.81 ms After last query: 10.79 ms Query memory: 0.030 MB Memory before query: 1.105 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.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.30 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.58 ms After last query: 3.94 ms Query memory: 0.014 MB Memory before query: 1.198 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.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.42 ms After last query: 1.44 ms Query memory: 0.013 MB Memory before query: 1.218 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.04 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.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.07 ms After last query: 0.32 ms Query memory: 0.013 MB Memory before query: 1.237 MB Rows returned: 57

SELECT folder AS type, element AS name, params

  FROM jos_extensions

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

  ORDER BY ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.48 ms After last query: 14.75 ms Query memory: 0.017 MB Memory before query: 1.438 MB Rows returned: 0

SELECT `path`

  FROM jos_rsfirewall_ignored

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.43 ms After last query: 0.24 ms Query memory: 0.017 MB Memory before query: 1.455 MB Rows returned: 0

SELECT `file`

  FROM jos_rsfirewall_hashes

  WHERE `type`='protect'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.33 ms After last query: 0.17 ms Query memory: 0.019 MB Memory before query: 1.470 MB Rows returned: 51

SELECT *

  FROM jos_rsfirewall_configuration

Explain

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

Profile

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

Call Stack

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

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

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

SHOW FULL COLUMNS 
  FROM `jos_rsfirewall_logs`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.65 ms After last query: 62.61 ms Query memory: 0.033 MB Memory before query: 2.469 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.17 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.84 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.79 ms After last query: 19.51 ms Query memory: 0.016 MB Memory before query: 3.209 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.12 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.12 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.33 ms After last query: 1.28 ms Query memory: 0.017 MB Memory before query: 3.228 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

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

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 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.92 ms After last query: 0.27 ms Query memory: 0.017 MB Memory before query: 3.261 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jos_rsfirewall_lists

  WHERE (`ip`='18.207.255.49' 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	463	99.35	Using where

Profile

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

Call Stack

#	Caller	File and line number
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.54 ms After last query: 1.68 ms Query memory: 0.018 MB Memory before query: 3.286 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.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.66 ms After last query: 1.92 ms Query memory: 0.025 MB Memory before query: 3.321 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.06 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 14.98 ms After last query: 0.48 ms Query memory: 0.019 MB Memory before query: 3.329 MB

UPDATE `jos_extensions`

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

  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.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.07 ms
updating	0.08 ms
end	0.03 ms
query end	14.48 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/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.73 ms After last query: 11.35 ms Query memory: 0.013 MB Memory before query: 3.533 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.75 ms After last query: 0.70 ms Query memory: 0.010 MB Memory before query: 3.554 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.02 ms
optimizing	0.07 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.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.59 ms After last query: 67.57 ms Query memory: 0.020 MB Memory before query: 4.132 MB Rows returned: 1

SELECT template

  FROM jos_template_styles

  WHERE id ='11'

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 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.65 ms After last query: 7.07 ms Query memory: 0.025 MB Memory before query: 4.169 MB Rows returned: 1

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1)

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

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.07 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.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.28 ms After last query: 2.05 ms Query memory: 0.025 MB Memory before query: 4.203 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	315	98.41	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.02 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.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.83 ms After last query: 23.64 ms Query memory: 0.031 MB Memory before query: 4.322 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.16 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.05 ms
Sorting result	0.07 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.88 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.55 ms After last query: 25.94 ms Query memory: 0.034 MB Memory before query: 4.739 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.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 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.39 ms After last query: 4.55 ms Query memory: 0.035 MB Memory before query: 4.780 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.35 ms After last query: 0.23 ms Query memory: 0.035 MB Memory before query: 4.814 MB Rows returned: 1

Duplicate queries: #32

SELECT t.parent_id

  FROM jos_menu as t

  WHERE t.id = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
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.55 ms After last query: 4.50 ms Query memory: 0.032 MB Memory before query: 4.719 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.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.81 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.41 ms After last query: 7.02 ms Query memory: 0.035 MB Memory before query: 5.032 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.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
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.30 ms After last query: 2.45 ms Query memory: 0.036 MB Memory before query: 5.072 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.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.36 ms After last query: 0.23 ms Query memory: 0.036 MB Memory before query: 5.107 MB Rows returned: 1

Duplicate queries: #28

SELECT t.parent_id

  FROM jos_menu as t

  WHERE t.id = 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.32 ms After last query: 4.15 ms Query memory: 0.034 MB Memory before query: 5.045 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.28 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 2.15 ms After last query: 10.30 ms Query memory: 0.037 MB Memory before query: 5.186 MB Rows returned: 5

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

  FROM jos_categories as c

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

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

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

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
starting	0.24 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.02 ms
Sending data	0.07 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.08 ms
removing tmp table	0.02 ms
Creating sort index	0.45 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.02 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.68 ms After last query: 0.83 ms Query memory: 0.026 MB Memory before query: 5.249 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.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 2.25 ms After last query: 2.42 ms Query memory: 0.049 MB Memory before query: 5.290 MB Rows returned: 14

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 >= '2018-07-01 00:00:00' 
  AND rpt.startrepeat <= '2018-07-31 23:59:59' 
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
1	SIMPLE	rpt	ALL	eventid,eventstart,eventend,startrepeat,startend,endrepeat	NO INDEX KEY COULD BE USED	NULL	NULL	1816	38.22	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.20 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
Opening tables	0.04 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	1.36 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 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.61 ms After last query: 45.51 ms Query memory: 0.040 MB Memory before query: 5.963 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.09 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.93 ms After last query: 42.67 ms Query memory: 0.034 MB Memory before query: 6.348 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.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
19	JDatabaseDriver->loadObjectList()	JROOT/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.65 ms After last query: 12.23 ms Query memory: 0.029 MB Memory before query: 6.482 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.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.53 ms After last query: 1.96 ms Query memory: 0.030 MB Memory before query: 6.516 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.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.06 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.09 ms After last query: 48.16 ms Query memory: 0.034 MB Memory before query: 6.590 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.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.27 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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: 4.24 ms After last query: 28.87 ms Query memory: 0.048 MB Memory before query: 6.789 MB Rows returned: 10

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 >= '2019-12-11 00:51:56' 
  AND rpt.startrepeat <= '2020-01-10 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	70	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.24 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
Opening tables	0.05 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.23 ms
preparing	0.08 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	2.01 ms
Creating sort index	0.89 ms
end	0.02 ms
removing tmp table	0.08 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.02 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.73 ms After last query: 3.40 ms Query memory: 0.042 MB Memory before query: 7.008 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 >= '2019-12-11 00:51:56' 
  AND rpt.startrepeat <= '2019-12-11 00:51:56' 
  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	70	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.19 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
Opening tables	0.03 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.07 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.57 ms
Creating sort index	0.03 ms
end	0.01 ms
removing tmp table	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 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.91 ms After last query: 0.96 ms Query memory: 0.042 MB Memory before query: 7.031 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 >= '2019-12-11 00:51:56' 
  AND rpt.startrepeat <= '2019-12-11 00:51:56' 
  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	70	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.19 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
Opening tables	0.04 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.07 ms
Creating tmp table	0.10 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.60 ms
Creating sort index	0.03 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.02 ms After last query: 120.60 ms Query memory: 0.032 MB Memory before query: 7.484 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.10 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.23 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.09 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/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.39 ms After last query: 0.37 ms Query memory: 0.038 MB Memory before query: 7.521 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.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

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

SHOW FULL COLUMNS 
  FROM `jos_assets`

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 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.61 ms After last query: 0.38 ms Query memory: 0.027 MB Memory before query: 8.272 MB Rows returned: 1

SELECT id

  FROM jos_assets

  WHERE parent_id = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1541
20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/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: 1.04 ms After last query: 0.31 ms Query memory: 0.027 MB Memory before query: 8.301 MB Rows returned: 1

SELECT b.rules

  FROM jos_assets AS a

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

  WHERE (a.id = 1)

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

  ORDER BY b.lft

Explain

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

Profile

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

Call Stack

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

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

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

SHOW FULL COLUMNS 
  FROM `jos_easyblog_users`

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.04 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.04 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.46 ms After last query: 2.61 ms Query memory: 0.029 MB Memory before query: 8.438 MB Rows returned: 1

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

Explain

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

Profile

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

Call Stack

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

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

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

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

Explain

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

Profile

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

Call Stack

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

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

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