Business English - Intermediate Level

The Intermediate Business English is for students who have successfully completed the Pre-Intermediate Business English course or who have a good knowledge of Business English and want to expand and become more confident in using English in the work place or are seeking a promotion.

The course is based on conversations and tasks used in everyday situations in the work place such as:

Communicate confidently in everyday business situations
Use and understand International English
Understand global business cultures
Follow a comprehensive course-book based on interesting themes, ideas and topics, while homework exercises mean that you can continue learning outside the classroom
Have regular checks on your progress in grammar and vocabulary and your teacher will give you feedback and guidance in all areas throughout the course.

Intermediate Business English addresses all four skill areas where listening and reading texts are kept to manageable lengths and speaking and writing tasks have structured support, therefore placing realistic demands on students in terms of support.

The topics of the course are used in Business situations such as:

An International project
New Companies
World Languages
Consumer Trends
Time for a break?
Home and away
Bridging the culture gap
On a global scale
What if…..?
Transitions
Critical Incidents
Hard news, soft news

The Intermediate Business English Course is a twelve - eighteen week intensive course with all lessons being held in the language Lab. At an established point in the course the student will receive advice on their progress, areas for improvement and advice for future studies.

The student will receive a certificate for Business English ESP (which is recognized worldwide) at the end of the course if they have attended at least 80% of the classes and satisfactorily completed all relevant parts to the course.

Students who complete the Intermediate Business English course may wish to do the TOEIC course and/or examination for a promotion in the work place.

Course to be finalized closer to commencement of course

Search Courses

eLearning

REGISTERED ACADEMY STUDENTS

Select your eLearning program:

► Study Link

► Learning Management System

Cambridge Banner

We accept CEQ logo RGB

Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.341 MB / 0.34 MB Application: afterLoad

Time: 86.2 ms / 86.2 ms Memory: 1.613 MB / 1.95 MB Application: afterInitialise

Time: 37.7 ms / 124.0 ms Memory: 1.196 MB / 3.15 MB Application: afterRoute

Time: 51.7 ms / 175.7 ms Memory: 0.910 MB / 4.06 MB Application: afterDispatch

Time: 5.3 ms / 181.0 ms Memory: 0.092 MB / 4.15 MB Application: beforeRenderModule mod_custom (Footer EN)

Time: 1.6 ms / 182.6 ms Memory: 0.011 MB / 4.16 MB Application: afterRenderModule mod_custom (Footer EN)

Time: 0.1 ms / 182.7 ms Memory: 0.000 MB / 4.16 MB Application: beforeRenderModule mod_eb_search (Search Courses)

Time: 5.6 ms / 188.2 ms Memory: 0.069 MB / 4.23 MB Application: afterRenderModule mod_eb_search (Search Courses)

Time: 0.1 ms / 188.3 ms Memory: 0.000 MB / 4.21 MB Application: beforeRenderModule mod_custom (eLearning)

Time: 0.1 ms / 188.4 ms Memory: 0.007 MB / 4.22 MB Application: afterRenderModule mod_custom (eLearning)

Time: 0.0 ms / 188.4 ms Memory: 0.000 MB / 4.22 MB Application: beforeRenderModule mod_custom (Cambridge Banner)

Time: 0.1 ms / 188.5 ms Memory: 0.007 MB / 4.22 MB Application: afterRenderModule mod_custom (Cambridge Banner)

Time: 0.1 ms / 188.5 ms Memory: 0.000 MB / 4.22 MB Application: beforeRenderModule mod_breadcrumbs_adv (Breadcrumbs)

Time: 1.9 ms / 190.5 ms Memory: 0.028 MB / 4.25 MB Application: afterRenderModule mod_breadcrumbs_adv (Breadcrumbs)

Time: 0.1 ms / 190.5 ms Memory: 0.000 MB / 4.24 MB Application: beforeRenderModule mod_custom (QuickBar)

Time: 0.2 ms / 190.7 ms Memory: 0.006 MB / 4.25 MB Application: afterRenderModule mod_custom (QuickBar)

Time: 0.2 ms / 190.9 ms Memory: 0.004 MB / 4.25 MB Application: beforeRenderModule mod_djimageslider (Slideshow Courses)

Time: 6.3 ms / 197.2 ms Memory: 0.131 MB / 4.38 MB Application: afterRenderModule mod_djimageslider (Slideshow Courses)

Time: 0.1 ms / 197.3 ms Memory: 0.000 MB / 4.35 MB Application: beforeRenderModule mod_ariextmenu (Main Menu EN)

Time: 10.0 ms / 207.4 ms Memory: 0.148 MB / 4.50 MB Application: afterRenderModule mod_ariextmenu (Main Menu EN)

Time: 0.1 ms / 207.5 ms Memory: 0.000 MB / 4.49 MB Application: beforeRenderModule mod_search (Search)

Time: 1.9 ms / 209.3 ms Memory: 0.023 MB / 4.51 MB Application: afterRenderModule mod_search (Search)

Time: 0.1 ms / 209.4 ms Memory: 0.000 MB / 4.50 MB Application: beforeRenderModule mod_languages (Lang Switcher)

Time: 7.2 ms / 216.6 ms Memory: 0.269 MB / 4.77 MB Application: afterRenderModule mod_languages (Lang Switcher)

Time: 9.3 ms / 225.9 ms Memory: 0.089 MB / 4.86 MB Application: afterRender

Database queries total: 46.9 ms

Memory Usage

Database Queries

181 Queries Logged 46.9 ms

9 duplicate found!

2 duplicates: #17 #26

3 duplicates: #30 #45 #50

2 duplicates: #37 #38

2 duplicates: #44 #49

Query Time: 0.67 ms Query memory: 0.015 MB Memory before query: 0.759 MB Rows returned: 0

SELECT `data`

  FROM `jconn_session`

  WHERE `session_id` = 'nrkv1g9u17mqivd0fvu954ikb6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_session	const	PRIMARY	PRIMARY	602	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.1 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:46

JROOT/libraries/joomla/session/session.php:658

JROOT/libraries/joomla/session/session.php:596

JROOT/libraries/cms/application/cms.php:686

JROOT/libraries/cms/application/cms.php:140

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:341

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Query Time: 1.42 ms After last query: 2.21 ms Query memory: 0.008 MB Memory before query: 0.806 MB

DELETE 

  FROM `jconn_session`

  WHERE `time` < '1713248807'

Explain

EXPLAIN not possible on query: DELETE FROM `jconn_session` WHERE `time` < '1713248807'

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.0 ms
Updating	0.2 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.7 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:703

JROOT/libraries/cms/application/cms.php:140

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:341

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Query Time: 0.72 ms After last query: 0.23 ms Query memory: 0.012 MB Memory before query: 0.818 MB Rows returned: 0

SELECT `session_id`

  FROM `jconn_session`

  WHERE `session_id` = 'nrkv1g9u17mqivd0fvu954ikb6' 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_session	const	PRIMARY	PRIMARY	602	const	1	Using index

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.2 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:184

JROOT/libraries/cms/application/cms.php:712

JROOT/libraries/cms/application/cms.php:140

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:341

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Query Time: 1.26 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 0.830 MB

INSERT INTO `jconn_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('nrkv1g9u17mqivd0fvu954ikb6', 0, '1713252407')

Explain

EXPLAIN not possible on query: INSERT INTO `jconn_session` (`session_id`, `client_id`, `time`) VALUES ('nrkv1g9u17mqivd0fvu954ikb6', 0, '1713252407')

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.1 ms
table lock	0.0 ms
init for update	0.0 ms
Update	0.2 ms
Waiting for query cache lock	0.0 ms
Update	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.5 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.1 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:216

JROOT/libraries/cms/application/cms.php:712

JROOT/libraries/cms/application/cms.php:140

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:341

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Query Time: 1.06 ms After last query: 5.33 ms Query memory: 0.015 MB Memory before query: 0.908 MB Rows returned: 1

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

  FROM jconn_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.2 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.2 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:395

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:539

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.86 ms After last query: 1.65 ms Query memory: 0.014 MB Memory before query: 0.925 MB Rows returned: 2

SELECT b.id

  FROM jconn_usergroups AS a

  LEFT JOIN jconn_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	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.2 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:336

JROOT/libraries/joomla/access/access.php:405

JROOT/libraries/joomla/user/user.php:420

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:544

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.44 ms After last query: 0.84 ms Query memory: 0.013 MB Memory before query: 0.945 MB Rows returned: 4

SELECT id, rules

  FROM `jconn_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.1 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:422

JROOT/libraries/joomla/user/user.php:420

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:544

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.90 ms After last query: 0.13 ms Query memory: 0.013 MB Memory before query: 0.963 MB Rows returned: 40

SELECT folder AS type, element AS name, params

  FROM jconn_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/plugin/helper.php:312

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:544

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.90 ms After last query: 4.83 ms Query memory: 0.016 MB Memory before query: 1.080 MB Rows returned: 4

SELECT *

  FROM jconn_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/language/helper.php:166

JROOT/plugins/system/languagefilter/languagefilter.php:58

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/site.php:544

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

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

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

  FROM jconn_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:395

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/plugins/system/languagefilter/languagefilter.php:60

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/site.php:544

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.56 ms After last query: 0.51 ms Query memory: 0.013 MB Memory before query: 1.126 MB Rows returned: 1

SELECT COUNT(*)

  FROM `jconn_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	123	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32

JROOT/plugins/system/languagefilter/languagefilter.php:62

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/site.php:544

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.59 ms After last query: 5.34 ms Query memory: 0.017 MB Memory before query: 1.189 MB Rows returned: 0

SELECT `path`

  FROM jconn_rsfirewall_ignored

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

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.1 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.2 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsfirewall/helpers/config.php:53

JROOT/administrator/components/com_rsfirewall/helpers/config.php:19

JROOT/administrator/components/com_rsfirewall/helpers/config.php:141

JROOT/plugins/system/rsfirewall/rsfirewall.php:25

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:600

JROOT/libraries/cms/application/site.php:618

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

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

SELECT `file`

  FROM jconn_rsfirewall_hashes

  WHERE `type`='protect'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	491	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.2 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsfirewall/helpers/config.php:59

JROOT/administrator/components/com_rsfirewall/helpers/config.php:19

JROOT/administrator/components/com_rsfirewall/helpers/config.php:141

JROOT/plugins/system/rsfirewall/rsfirewall.php:25

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:600

JROOT/libraries/cms/application/site.php:618

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.65 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 1.221 MB Rows returned: 40

SELECT *

  FROM jconn_rsfirewall_configuration

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_rsfirewall_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	40

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	1.7 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsfirewall/helpers/config.php:67

JROOT/administrator/components/com_rsfirewall/helpers/config.php:19

JROOT/administrator/components/com_rsfirewall/helpers/config.php:141

JROOT/plugins/system/rsfirewall/rsfirewall.php:25

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:600

JROOT/libraries/cms/application/site.php:618

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.39 ms After last query: 15.54 ms Query memory: 0.016 MB Memory before query: 1.543 MB Rows returned: 1

SELECT `value`

  FROM `jconn_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_admintools_storage	const	PRIMARY	PRIMARY	767	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.2 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_admintools/models/storage.php:70

JROOT/administrator/components/com_admintools/models/storage.php:38

JROOT/plugins/system/admintools/admintools/core.php:89

JROOT/plugins/system/admintools/admintools/main.php:48

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:600

JROOT/libraries/cms/application/site.php:618

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 1.32 ms After last query: 15.77 ms Query memory: 0.031 MB Memory before query: 1.974 MB Rows returned: 42

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 jconn_menu AS m

  LEFT JOIN jconn_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	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	46	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rcon1599_joomla.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.4 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.1 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:366

JROOT/libraries/cms/application/site.php:250

JROOT/libraries/cms/router/site.php:210

JROOT/libraries/cms/router/router.php:391

JROOT/libraries/cms/router/router.php:184

JROOT/libraries/cms/router/site.php:82

JROOT/libraries/cms/application/cms.php:1043

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.92 ms After last query: 3.03 ms Query memory: 0.015 MB Memory before query: 2.466 MB Rows returned: 1

Duplicate queries: #26

SELECT `query`

  FROM jconn_eb_urls

  WHERE md5_key="d00e345e0400d21e8f182ad31434b728"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_urls	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	973	Using where

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.3 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/router.php:266

JROOT/libraries/cms/router/site.php:366

JROOT/libraries/cms/router/router.php:391

JROOT/libraries/cms/router/router.php:184

JROOT/libraries/cms/router/site.php:82

JROOT/libraries/cms/application/cms.php:1043

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 1.35 ms After last query: 2.27 ms Query memory: 0.025 MB Memory before query: 2.626 MB Rows returned: 10

SHOW FULL COLUMNS 
  FROM `jconn_rsfirewall_logs`

Explain

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

Profile

Status	Duration
Starting	0.2 ms
checking permissions	0.0 ms
closing tables	0.0 ms
Opening tables	0.4 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Filling schema table	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
checking permissions	0.2 ms
closing tables	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Removing tmp table	0.1 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:229

JROOT/libraries/joomla/table/table.php:150

JROOT/administrator/components/com_rsfirewall/tables/logs.php:36

JROOT/libraries/joomla/table/table.php:294

JROOT/administrator/components/com_rsfirewall/helpers/log.php:22

JROOT/administrator/components/com_rsfirewall/helpers/log.php:56

JROOT/plugins/system/rsfirewall/rsfirewall.php:761

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.77 ms After last query: 0.71 ms Query memory: 0.016 MB Memory before query: 2.681 MB Rows returned: 4

SELECT *

  FROM jconn_rsfirewall_hashes

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	491	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.2 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/rsfirewall/rsfirewall.php:779

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.47 ms After last query: 0.82 ms Query memory: 0.017 MB Memory before query: 2.705 MB Rows returned: 0

SELECT *

  FROM jconn_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

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

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47

JROOT/plugins/system/rsfirewall/rsfirewall.php:802

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

SELECT `ip`,`reason`

  FROM jconn_rsfirewall_lists

  WHERE (`ip`='3.144.42.196' OR `ip` LIKE '%*%') 
  AND `type`='1' 
  AND `published`='1'

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/rsfirewall/rsfirewall.php:153

JROOT/plugins/system/rsfirewall/rsfirewall.php:133

JROOT/plugins/system/rsfirewall/rsfirewall.php:819

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.41 ms After last query: 0.09 ms Query memory: 0.017 MB Memory before query: 2.737 MB Rows returned: 0

SELECT `ip`,`reason`

  FROM jconn_rsfirewall_lists

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

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/rsfirewall/rsfirewall.php:153

JROOT/plugins/system/rsfirewall/rsfirewall.php:129

JROOT/plugins/system/rsfirewall/rsfirewall.php:823

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.51 ms After last query: 0.74 ms Query memory: 0.018 MB Memory before query: 2.760 MB Rows returned: 0

SELECT *

  FROM jconn_rsfirewall_exceptions

  WHERE `published`='1'

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/rsfirewall/rsfirewall.php:526

JROOT/plugins/system/rsfirewall/rsfirewall.php:857

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.81 ms After last query: 6.76 ms Query memory: 0.024 MB Memory before query: 2.839 MB Rows returned: 1

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

  FROM jconn_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.2 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/library/helper.php:156

JROOT/libraries/cms/library/helper.php:47

JROOT/libraries/cms/library/helper.php:90

JROOT/libraries/cms/version/version.php:179

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/sef/sef.php:30

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 1.61 ms After last query: 0.19 ms Query memory: 0.018 MB Memory before query: 2.846 MB

UPDATE `jconn_extensions`

  SET `params` = '{\"mediaversion\":\"156a3f6933cd1935ec25457d5553ecd3\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `jconn_extensions` SET `params` = '{\"mediaversion\":\"156a3f6933cd1935ec25457d5553ecd3\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.0 ms
Updating	0.1 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.3 ms
Query end	0.0 ms
Commit	0.7 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:230

JROOT/libraries/cms/version/version.php:189

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/sef/sef.php:30

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.24 ms After last query: 2.60 ms Query memory: 0.020 MB Memory before query: 2.930 MB Rows returned: 1

Duplicate queries: #17

SELECT `query`

  FROM jconn_eb_urls

  WHERE md5_key="d00e345e0400d21e8f182ad31434b728"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_urls	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	973	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
Sending cached result to clien	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/router.php:266

JROOT/libraries/cms/router/site.php:366

JROOT/libraries/cms/router/router.php:391

JROOT/libraries/cms/router/router.php:184

JROOT/libraries/cms/router/site.php:82

JROOT/plugins/system/sef/sef.php:47

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.86 ms After last query: 5.28 ms Query memory: 0.029 MB Memory before query: 2.983 MB Rows returned: 165

SELECT config_key, config_value

  FROM jconn_eb_configs

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	165

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.2 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/helper.php:37

JROOT/components/com_eventbooking/helper/route.php:111

JROOT/components/com_eventbooking/router.php:89

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:49

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.71 ms After last query: 0.50 ms Query memory: 0.023 MB Memory before query: 3.038 MB Rows returned: 1

SELECT id, event_type, parent_id,  title

  FROM jconn_eb_events

  WHERE id=15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_events	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/route.php:121

JROOT/components/com_eventbooking/router.php:89

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:49

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.38 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 3.060 MB Rows returned: 21

SELECT id, name, parent

  FROM jconn_eb_categories

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	21

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/route.php:148

JROOT/components/com_eventbooking/router.php:93

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:49

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.84 ms After last query: 1.45 ms Query memory: 0.021 MB Memory before query: 3.137 MB Rows returned: 1

Duplicate queries: #45 #50

SELECT COUNT(*)

  FROM jconn_eb_urls

  WHERE md5_key="d00e345e0400d21e8f182ad31434b728"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_urls	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	973	Using where

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.3 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/router.php:232

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:49

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1052

JROOT/libraries/cms/application/site.php:727

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

[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.75 ms Query memory: 0.015 MB Memory before query: 3.171 MB Rows returned: 1

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

  FROM jconn_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_eventbooking'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.2 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:395

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:298

JROOT/libraries/cms/application/site.php:122

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.73 ms After last query: 0.47 ms Query memory: 0.010 MB Memory before query: 3.176 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM jconn_template_styles as s

  LEFT JOIN jconn_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	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	3	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.1 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	1.4 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/application/site.php:455

JROOT/libraries/cms/application/site.php:152

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.66 ms After last query: 17.08 ms Query memory: 0.019 MB Memory before query: 3.448 MB Rows returned: 1

SELECT `access` 
  FROM jconn_eb_events 
  WHERE id=15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_events	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/helper.php:1608

JROOT/components/com_eventbooking/views/event/view.html.php:42

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.49 ms After last query: 0.13 ms Query memory: 0.017 MB Memory before query: 3.468 MB Rows returned: 1

SELECT COUNT(*)

  FROM jconn_eb_events

  WHERE id=15 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_events	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/views/event/view.html.php:48

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.51 ms After last query: 1.02 ms Query memory: 0.038 MB Memory before query: 3.499 MB Rows returned: 1

SELECT * 
  FROM jconn_eb_events 
  WHERE id=15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_events	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/models/event.php:60

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_eventbooking/views/event/view.html.php:54

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.65 ms After last query: 0.10 ms Query memory: 0.019 MB Memory before query: 3.535 MB Rows returned: 1

SELECT SUM(number_registrants) 
  FROM jconn_eb_registrants 
  WHERE event_id=15 
  AND group_id=0 
  AND (published = 1 OR (payment_method LIKE "os_offline%" 
  AND published != 2))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_registrants	ref	jos_eb_registrants_FKIndex1	jos_eb_registrants_FKIndex1	5	const	1	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/models/event.php:64

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_eventbooking/views/event/view.html.php:54

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.37 ms After last query: 0.06 ms Query memory: 0.019 MB Memory before query: 3.553 MB Rows returned: 1

Duplicate queries: #38

SELECT category_id 
  FROM jconn_eb_event_categories 
  WHERE event_id=15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_event_categories	ref	jconn_eb_event_categories_FKIndex1	jconn_eb_event_categories_FKIndex1	5	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/models/event.php:67

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_eventbooking/views/event/view.html.php:54

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.019 MB Memory before query: 3.572 MB Rows returned: 1

Duplicate queries: #37

SELECT category_id 
  FROM jconn_eb_event_categories 
  WHERE event_id=15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_event_categories	ref	jconn_eb_event_categories_FKIndex1	jconn_eb_event_categories_FKIndex1	5	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
Sending cached result to clien	0.1 ms
Updating status	0.0 ms
Reset for next command	0.2 ms

Call Stack

JROOT/components/com_eventbooking/models/event.php:119

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_eventbooking/views/event/view.html.php:60

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.59 ms After last query: 0.06 ms Query memory: 0.019 MB Memory before query: 3.590 MB Rows returned: 1

SELECT id, name, parent 
  FROM jconn_eb_categories 
  WHERE id = 3 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/models/event.php:124

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_eventbooking/views/event/view.html.php:60

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.53 ms After last query: 0.06 ms Query memory: 0.019 MB Memory before query: 3.609 MB Rows returned: 0

SELECT id, name, parent 
  FROM jconn_eb_categories 
  WHERE id = 6 
  AND published=1

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.2 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/models/event.php:132

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_eventbooking/views/event/view.html.php:60

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.94 ms After last query: 0.82 ms Query memory: 0.023 MB Memory before query: 3.636 MB Rows returned: 1

SELECT COUNT(*)

  FROM jconn_eb_urls

  WHERE md5_key="25e7257e7f311c1cb093364a6f789d19"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_urls	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	973	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.4 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.3 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/router.php:232

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/components/com_eventbooking/views/event/view.html.php:66

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

[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.98 ms Query memory: 0.017 MB Memory before query: 3.757 MB Rows returned: 1

SELECT name

  FROM jconn_eb_categories

  WHERE id=3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.4 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/views/event/view.html.php:97

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.70 ms After last query: 0.09 ms Query memory: 0.017 MB Memory before query: 3.774 MB Rows returned: 0

SELECT *

  FROM jconn_eb_event_group_prices

  WHERE event_id=15

  ORDER BY id

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/views/event/view.html.php:109

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.93 ms After last query: 1.36 ms Query memory: 0.021 MB Memory before query: 3.834 MB Rows returned: 1

Duplicate queries: #49

SELECT b.id

  FROM jconn_eb_event_categories AS a

  INNER JOIN jconn_eb_categories AS b 
  ON a.category_id=b.id

  WHERE a.event_id=15

  ORDER BY b.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	jconn_eb_event_categories_FKIndex1,jconn_eb_event_categories_FKIndex2	jconn_eb_event_categories_FKIndex1	5	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	rcon1599_joomla.a.category_id	1

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.2 ms
Creating sort index	0.1 ms
Removing tmp table	0.0 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/route.php:42

JROOT/templates/connies/html/com_eventbooking/event/default.php:13

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_eventbooking/views/event/view.html.php:158

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.21 ms After last query: 0.47 ms Query memory: 0.027 MB Memory before query: 3.857 MB Rows returned: 1

Duplicate queries: #30 #50

SELECT COUNT(*)

  FROM jconn_eb_urls

  WHERE md5_key="d00e345e0400d21e8f182ad31434b728"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_urls	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	973	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking privileges on cached	0.1 ms
checking permissions	0.0 ms
Sending cached result to clien	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/router.php:232

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/templates/connies/html/com_eventbooking/event/default.php:13

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_eventbooking/views/event/view.html.php:158

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.66 ms After last query: 0.11 ms Query memory: 0.037 MB Memory before query: 3.877 MB Rows returned: 1

SELECT * 
  FROM jconn_eb_events 
  WHERE id=15 
  AND published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_events	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.3 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/helper.php:633

JROOT/templates/connies/html/com_eventbooking/event/default.php:14

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_eventbooking/views/event/view.html.php:158

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.52 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 3.912 MB Rows returned: 1

SELECT DATEDIFF(NOW(), event_date) AS number_days 
  FROM jconn_eb_events 
  WHERE id=15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_events	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/helper.php:653

JROOT/templates/connies/html/com_eventbooking/event/default.php:14

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_eventbooking/views/event/view.html.php:158

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 1.00 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 3.935 MB Rows returned: 1

SELECT config_value

  FROM jconn_eb_configs

  WHERE config_key="prevent_duplicate_registration"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	165	Using where

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.2 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/helper.php:64

JROOT/components/com_eventbooking/helper/helper.php:669

JROOT/templates/connies/html/com_eventbooking/event/default.php:14

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_eventbooking/views/event/view.html.php:158

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.20 ms After last query: 3.37 ms Query memory: 0.022 MB Memory before query: 3.983 MB Rows returned: 1

Duplicate queries: #44

SELECT b.id

  FROM jconn_eb_event_categories AS a

  INNER JOIN jconn_eb_categories AS b 
  ON a.category_id=b.id

  WHERE a.event_id=15

  ORDER BY b.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	jconn_eb_event_categories_FKIndex1,jconn_eb_event_categories_FKIndex2	jconn_eb_event_categories_FKIndex1	5	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	rcon1599_joomla.a.category_id	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
Sending cached result to clien	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/route.php:42

JROOT/templates/connies/html/com_eventbooking/event/default.php:18

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_eventbooking/views/event/view.html.php:158

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 0.25 ms After last query: 0.46 ms Query memory: 0.027 MB Memory before query: 4.006 MB Rows returned: 1

Duplicate queries: #30 #45

SELECT COUNT(*)

  FROM jconn_eb_urls

  WHERE md5_key="d00e345e0400d21e8f182ad31434b728"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_eb_urls	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	973	Using where

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
Sending cached result to clien	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/router.php:232

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/templates/connies/html/com_eventbooking/event/default.php:18

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_eventbooking/views/event/view.html.php:158

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_eventbooking/controller/controller.php:202

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_eventbooking/eventbooking.php:28

JROOT/libraries/cms/component/helper.php:351

JROOT/libraries/cms/component/helper.php:331

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:264

JROOT/index.php:40

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

Query Time: 2.16 ms After last query: 7.26 ms Query memory: 0.022 MB Memory before query: 4.098 MB Rows returned: 53

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jconn_modules AS m

  LEFT JOIN jconn_modules_menu AS mm 
  ON mm.moduleid = m.id

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-16 07:26:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-16 07:26:47') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 122 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	49	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	rcon1599_joomla.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	rcon1599_joomla.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.1 ms
Statistics	0.4 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.1 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.2 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/module/helper.php:362

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:502

JROOT/templates/connies/index.php:126

JROOT/libraries/joomla/document/html/html.php:570

JROOT/libraries/joomla/document/html/html.php:628

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:999

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 1.62 ms After last query: 3.78 ms Query memory: 0.018 MB Memory before query: 4.180 MB Rows returned: 4

SELECT id, parent, parent AS parent_id, name, name AS title 
  FROM jconn_eb_categories 
  WHERE published = 1 
  AND (`access` = 0 OR `access` IN (1,1,5)) 
  AND `language` IN ('en-GB','*') 
  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	1.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_eb_search/mod_eb_search.php:39

JROOT/libraries/cms/module/helper.php:177

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:1013

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 0.82 ms After last query: 2.30 ms Query memory: 0.018 MB Memory before query: 4.225 MB Rows returned: 2

SELECT id

  FROM jconn_menu AS a

  WHERE a.link LIKE "%index.php?option=com_eventbooking%" 
  AND a.published=1 
  AND a.access IN (1,1,5) 
  AND a.language IN ('en-GB','*')

  ORDER BY a.access

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_eventbooking/helper/helper.php:199

JROOT/modules/mod_eb_search/mod_eb_search.php:85

JROOT/libraries/cms/module/helper.php:177

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:1013

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 1.13 ms After last query: 5.71 ms Query memory: 0.023 MB Memory before query: 4.336 MB Rows returned: 1

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

  FROM jconn_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_djimageslider'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.3 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.2 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.1 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.2 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:395

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:73

JROOT/modules/mod_djimageslider/mod_djimageslider.php:41

JROOT/libraries/cms/module/helper.php:177

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:1013

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

[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.18 ms Query memory: 0.021 MB Memory before query: 4.342 MB Rows returned: 4

SELECT a.*

  FROM jconn_djimageslider AS a

  WHERE a.catid = 16 
  AND a.published = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-16 07:26:47') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-16 07:26:47')

  ORDER BY a.ordering ASC 
  LIMIT 0, 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	4	Using where; Using filesort

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_djimageslider/helper.php:90

JROOT/modules/mod_djimageslider/mod_djimageslider.php:45

JROOT/libraries/cms/module/helper.php:177

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:1013

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 0.58 ms After last query: 0.23 ms Query memory: 0.017 MB Memory before query: 4.376 MB Rows returned: 0

SELECT manifest_cache 
  FROM jconn_extensions 
  WHERE element='mod_dimageslider' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_extensions	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using index condition

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.1 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.1 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_djimageslider/mod_djimageslider.php:97

JROOT/libraries/cms/module/helper.php:177

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:1013

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 0.56 ms After last query: 8.75 ms Query memory: 0.034 MB Memory before query: 4.496 MB Rows returned: 1

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

  FROM jconn_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jconn_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:395

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/components/com_content/router.php:26

JROOT/libraries/cms/router/site.php:437

JROOT/libraries/cms/router/site.php:395

JROOT/libraries/cms/router/router.php:216

JROOT/libraries/cms/router/site.php:98

JROOT/libraries/joomla/application/route.php:62

JROOT/modules/mod_ariextmenu/mod_ariextmenu/kernel/Menu/class.Menu.php:236

JROOT/templates/connies/html/mod_ariextmenu/menu.php:58

JROOT/modules/mod_ariextmenu/mod_ariextmenu/kernel/Template/class.Template.php:19

JROOT/templates/connies/html/mod_ariextmenu/default.php:31

JROOT/modules/mod_ariextmenu/mod_ariextmenu.php:55

JROOT/libraries/cms/module/helper.php:177

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:1013

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 0.67 ms After last query: 5.99 ms Query memory: 0.019 MB Memory before query: 4.547 MB Rows returned: 3

SELECT m2.language, m2.id

  FROM jconn_menu as m

  INNER JOIN jconn_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN jconn_associations as a2 
  ON a.key=a2.key

  INNER JOIN jconn_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=122

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	156	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	96	const	3	Using index
1	SIMPLE	m2	eq_ref	PRIMARY	PRIMARY	4	rcon1599_joomla.a2.id	1

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_menus/helpers/menus.php:268

JROOT/modules/mod_languages/helper.php:47

JROOT/modules/mod_languages/mod_languages.php:18

JROOT/libraries/cms/module/helper.php:177

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:1013

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 0.97 ms After last query: 9.02 ms Query memory: 0.015 MB Memory before query: 4.880 MB Rows returned: 4

SELECT id,name,color_code

  FROM jconn_eb_categories

  WHERE language="en-gb" 
  AND parent="6"

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.2 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/templates/connies/jumi/quickbar.php:52

JROOT/plugins/system/jumi/jumi.php:79

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1019

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 0.91 ms After last query: 0.11 ms Query memory: 0.016 MB Memory before query: 4.899 MB Rows returned: 35

SELECT ev.id,ev.title,c.category_id

  FROM jconn_eb_events AS ev

  LEFT JOIN jconn_eb_event_categories AS c 
  ON c.event_id=ev.id

  WHERE ev.language="en-gb"

  ORDER BY ev.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ev	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	86	Using where; Using filesort
1	SIMPLE	c	ref	jconn_eb_event_categories_FKIndex1	jconn_eb_event_categories_FKIndex1	5	rcon1599_joomla.ev.id	1

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.4 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.1 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/templates/connies/jumi/quickbar.php:63

JROOT/plugins/system/jumi/jumi.php:79

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1019

JROOT/libraries/cms/application/site.php:709

JROOT/libraries/cms/application/cms.php:270

JROOT/index.php:40

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

Query Time: 1.92 ms After last query: 2.78 ms Query memory: 0.003 MB Memory before query: 4.863 MB

UPDATE `jconn_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713252407;s:18:\"session.timer.last\";i:1713252407;s:17:\"session.timer.now\";i:1713252407;s:22:\"session.client.browser\";s:9:\"claudebot\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:13:\"session.token\";s:32:\"f4c39d8066b382660c65ac865ca52da0\";}'
	, `time` = '1713252407'

  WHERE `session_id` = 'nrkv1g9u17mqivd0fvu954ikb6'

Explain

EXPLAIN not possible on query: UPDATE `jconn_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713252407;s:18:\"session.timer.last\";i:1713252407;s:17:\"session.timer.now\";i:1713252407;s:22:\"session.client.browser\";s:9:\"claudebot\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:13:\"session.token\";s:32:\"f4c39d8066b382660c65ac865ca52da0\";}' , `time` = '1713252407' WHERE `session_id` = 'nrkv1g9u17mqivd0fvu954ikb6'

Profile

Status	Duration
Starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.1 ms
Updating	0.2 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	1.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:85

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

47 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jconn_extensions

4 × SELECT COUNT(*) 
  FROM jconn_eb_urls

2 × SELECT id, name, parent 
  FROM jconn_eb_categories

2 × SELECT category_id 
  FROM jconn_eb_event_categories

2 × SELECT `ip`,`reason` 
  FROM jconn_rsfirewall_lists

```
2 × SELECT * 
  FROM jconn_eb_events
```

2 × SELECT b.id 
  FROM jconn_eb_event_categories AS a 
  INNER JOIN jconn_eb_categories AS b 
  ON a.category_id=b.id

2 × SELECT `query` 
  FROM jconn_eb_urls

1 × SELECT * 
  FROM jconn_eb_event_group_prices

1 × SELECT SUM(number_registrants) 
  FROM jconn_eb_registrants

1 × SELECT COUNT(*) 
  FROM jconn_eb_events

1 × SELECT name 
  FROM jconn_eb_categories

1 × SELECT DATEDIFF(NOW(), event_date) AS number_days 
  FROM jconn_eb_events

1 × SELECT manifest_cache 
  FROM jconn_extensions

1 × SELECT m2.language, m2.id 
  FROM jconn_menu as m 
  INNER JOIN jconn_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN jconn_associations as a2 
  ON a.key=a2.key 
  INNER JOIN jconn_menu as m2 
  ON a2.id=m2.id

1 × SELECT id,name,color_code 
  FROM jconn_eb_categories

1 × SELECT ev.id,ev.title,c.category_id 
  FROM jconn_eb_events AS ev 
  LEFT JOIN jconn_eb_event_categories AS c 
  ON c.event_id=ev.id

1 × SELECT a.* 
  FROM jconn_djimageslider AS a

```
1 × SELECT id 
  FROM jconn_menu AS a
```

1 × SELECT config_value 
  FROM jconn_eb_configs

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jconn_modules AS m 
  LEFT JOIN jconn_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jconn_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id, parent, parent AS parent_id, name, name AS title 
  FROM jconn_eb_categories

1 × SELECT `access` 
  FROM jconn_eb_events

1 × SELECT id, name, parent 
  FROM jconn_eb_categorie

1 × SELECT COUNT(*) 
  FROM `jconn_menu`

1 × SELECT `path` 
  FROM jconn_rsfirewall_ignored

1 × SELECT `file` 
  FROM jconn_rsfirewall_hashes

```
1 × SELECT * 
  FROM jconn_languages
```

1 × SELECT folder AS type, element AS name, params 
  FROM jconn_extensions

1 × SELECT `session_id` 
  FROM `jconn_session`

1 × SELECT b.id 
  FROM jconn_usergroups AS a 
  LEFT JOIN jconn_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `jconn_viewlevels

1 × SELECT * 
  FROM jconn_rsfirewall_configuratio

1 × SELECT `value` 
  FROM `jconn_admintools_storage`

1 × SELECT config_key, config_value 
  FROM jconn_eb_config

1 × SELECT id, event_type, parent_id,  title 
  FROM jconn_eb_events

1 × SELECT `data` 
  FROM `jconn_session`

1 × SELECT * 
  FROM jconn_rsfirewall_exceptions

1 × SELECT * 
  FROM jconn_rsfirewall_snapshots

1 × 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 jconn_menu AS m 
  LEFT JOIN jconn_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM jconn_rsfirewall_hashes

1 × SELECT id, home, template, s.params 
  FROM jconn_template_styles as s 
  LEFT JOIN jconn_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

OTHER Tables:

1 × UPDATE `jconn_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713252407;s:18:\"session.timer.last\";i:1713252407;s:17:\"session.timer.now\";i:1713252407;s:22:\"session.client.browser\";s:9:\"claudebot\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:13:\"session.token\";s:32:\"f4c39d8066b382660c65ac865ca52da0\";}'  , `time` = '1713252407'

1 × UPDATE `jconn_extensions` 
  SET `params` = '{\"mediaversion\":\"156a3f6933cd1935ec25457d5553ecd3\"}'

1 × SHOW FULL COLUMNS 
  FROM `jconn_rsfirewall_logs

1 × INSERT INTO `jconn_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('nrkv1g9u17mqivd0fvu954ikb6', 0, '1713252407'

```
1 × DELETE  
  FROM `jconn_session`
```