Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.649 MB / 0.65 MB Application: afterLoad

Time: 52.7 ms / 52.7 ms Memory: 5.641 MB / 6.29 MB Application: afterInitialise

Time: 47.5 ms / 100.2 ms Memory: 5.567 MB / 11.86 MB Application: afterRoute

Time: 92.7 ms / 192.9 ms Memory: 11.108 MB / 22.96 MB Application: afterDispatch

Time: 30.5 ms / 223.5 ms Memory: 3.239 MB / 26.20 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 26.4 ms / 249.9 ms Memory: 1.756 MB / 27.96 MB Application: afterRenderModule mod_roknavmenu ()

Time: 9.8 ms / 259.7 ms Memory: 0.027 MB / 27.99 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 3.6 ms / 263.3 ms Memory: 0.086 MB / 28.07 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.1 ms / 263.4 ms Memory: 0.000 MB / 28.07 MB Application: beforeRenderModule mod_custom (Follow Us)

Time: 1.0 ms / 264.4 ms Memory: 0.010 MB / 28.08 MB Application: afterRenderModule mod_custom (Follow Us)

Time: 0.1 ms / 264.5 ms Memory: 0.005 MB / 28.08 MB Application: beforeRenderModule mod_acymailing (Newsletter)

Time: 13.7 ms / 278.2 ms Memory: 1.243 MB / 29.32 MB Application: afterRenderModule mod_acymailing (Newsletter)

Time: 0.1 ms / 278.4 ms Memory: 0.000 MB / 29.30 MB Application: beforeRenderModule mod_menu ( Used Equipment)

Time: 5.2 ms / 283.6 ms Memory: 0.249 MB / 29.55 MB Application: afterRenderModule mod_menu ( Used Equipment)

Time: 0.1 ms / 283.7 ms Memory: 0.000 MB / 29.54 MB Application: beforeRenderModule mod_menu (New Equipment)

Time: 2.7 ms / 286.4 ms Memory: 0.116 MB / 29.66 MB Application: afterRenderModule mod_menu (New Equipment)

Time: 0.1 ms / 286.5 ms Memory: 0.001 MB / 29.66 MB Application: beforeRenderModule mod_cblogin (Seller Login)

Time: 7.9 ms / 294.4 ms Memory: 0.680 MB / 30.34 MB Application: afterRenderModule mod_cblogin (Seller Login)

Time: 0.1 ms / 294.5 ms Memory: 0.000 MB / 30.31 MB Application: beforeRenderModule mod_adsnew_ads (Featured New Ads)

Time: 6.7 ms / 301.2 ms Memory: 0.807 MB / 31.12 MB Application: afterRenderModule mod_adsnew_ads (Featured New Ads)

Time: 0.1 ms / 301.2 ms Memory: 0.000 MB / 31.07 MB Application: beforeRenderModule mod_adsused_ads (Featured Used Ads)

Time: 6.6 ms / 307.9 ms Memory: 0.836 MB / 31.91 MB Application: afterRenderModule mod_adsused_ads (Featured Used Ads)

Time: 0.1 ms / 308.0 ms Memory: 0.000 MB / 31.85 MB Application: beforeRenderModule mod_adsnew_menu (New Equipment)

Time: 7.7 ms / 315.6 ms Memory: 0.553 MB / 32.40 MB Application: afterRenderModule mod_adsnew_menu (New Equipment)

Time: 0.2 ms / 315.8 ms Memory: 0.000 MB / 32.29 MB Application: beforeRenderModule mod_adsused_menu (Used Equipment)

Time: 9.0 ms / 324.8 ms Memory: 0.623 MB / 32.91 MB Application: afterRenderModule mod_adsused_menu (Used Equipment)

Time: 0.1 ms / 324.9 ms Memory: 0.000 MB / 32.78 MB Application: beforeRenderModule mod_acymailing (Newsletter)

Time: 1.5 ms / 326.4 ms Memory: 0.047 MB / 32.83 MB Application: afterRenderModule mod_acymailing (Newsletter)

Time: 0.1 ms / 326.5 ms Memory: 0.000 MB / 32.80 MB Application: beforeRenderModule mod_adsnew_search (New Equipment Search)

Time: 2.9 ms / 329.4 ms Memory: 0.202 MB / 33.00 MB Application: afterRenderModule mod_adsnew_search (New Equipment Search)

Time: 0.1 ms / 329.5 ms Memory: 0.000 MB / 32.91 MB Application: beforeRenderModule mod_custom (Tagline)

Time: 0.2 ms / 329.8 ms Memory: 0.007 MB / 32.91 MB Application: afterRenderModule mod_custom (Tagline)

Time: 6.2 ms / 336.0 ms Memory: 0.290 MB / 33.20 MB Application: afterRender

Database queries total: 35.3 ms

Memory Usage

Database Queries

121 Queries Logged 35.3 ms

32 duplicate found!

2 duplicates: #22 #36

2 duplicates: #24 #68

3 duplicates: #40 #59 #114

2 duplicates: #42 #113

2 duplicates: #45 #105

2 duplicates: #46 #106

2 duplicates: #47 #107

2 duplicates: #49 #108

2 duplicates: #51 #101

2 duplicates: #52 #86

2 duplicates: #53 #89

2 duplicates: #54 #90

2 duplicates: #55 #92

3 duplicates: #60 #69 #115

2 duplicates: #61 #116

Query Time: 0.46 ms Query memory: 0.015 MB Memory before query: 2.312 MB Rows returned: 0
```
SELECT `data`

  FROM `fly9i_session`

  WHERE `session_id` = '0qmojbp10l5kln0ugns12lbsk0'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_session const PRIMARY PRIMARY 602 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:672
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
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.92 ms After last query: 1.12 ms Query memory: 0.008 MB Memory before query: 2.449 MB
```
DELETE 

  FROM `fly9i_session`

  WHERE `time` < '1701332719'
```
Explain
EXPLAIN not possible on query: DELETE FROM `fly9i_session` WHERE `time` < '1701332719'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:689
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
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.46 ms After last query: 0.08 ms Query memory: 0.012 MB Memory before query: 2.461 MB Rows returned: 0
```
SELECT `session_id`

  FROM `fly9i_session`

  WHERE `session_id` = '0qmojbp10l5kln0ugns12lbsk0' 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_session const PRIMARY PRIMARY 602 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
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.57 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 2.474 MB
```
INSERT INTO `fly9i_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('0qmojbp10l5kln0ugns12lbsk0', 0, '1701333619')
```
Explain
EXPLAIN not possible on query: INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`) VALUES ('0qmojbp10l5kln0ugns12lbsk0', 0, '1701333619')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
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.45 ms After last query: 2.39 ms Query memory: 0.015 MB Memory before query: 2.831 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM fly9i_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:541
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.12 ms After last query: 0.91 ms Query memory: 0.014 MB Memory before query: 2.935 MB Rows returned: 1
```
SELECT b.id

  FROM fly9i_usergroups AS a

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

  WHERE a.id = 1
```
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 1 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.10 ms After last query: 0.43 ms Query memory: 0.013 MB Memory before query: 2.998 MB Rows returned: 5
```
SELECT id, rules

  FROM `fly9i_viewlevels`
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
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.13 ms Query memory: 0.014 MB Memory before query: 3.017 MB Rows returned: 66
```
SELECT folder AS type, element AS name, params

  FROM fly9i_extensions

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

  ORDER BY ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 216 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
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.35 ms Query memory: 0.014 MB Memory before query: 3.105 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM fly9i_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:599
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.16 ms After last query: 9.04 ms Query memory: 0.016 MB Memory before query: 4.445 MB Rows returned: 0
```
SELECT *

  FROM `fly9i_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')
```
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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/admintools/admintools/main.php:526
JROOT/plugins/system/admintools/admintools/main.php:447
JROOT/plugins/system/admintools/admintools/main.php:90
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.12 ms After last query: 0.52 ms Query memory: 0.018 MB Memory before query: 4.518 MB Rows returned: 1
```
SELECT `value`

  FROM `fly9i_admintools_storage`

  WHERE `key` = 'cparams'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_admintools_storage const PRIMARY PRIMARY 302 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_admintools/models/storage.php:99
JROOT/administrator/components/com_admintools/models/storage.php:49
JROOT/plugins/system/admintools/feature/httpsizer.php:26
JROOT/plugins/system/admintools/admintools/main.php:356
JROOT/plugins/system/admintools/admintools/main.php:93
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.06 ms After last query: 14.67 ms Query memory: 0.022 MB Memory before query: 5.794 MB Rows returned: 149
```
SHOW TABLES
```
Explain
EXPLAIN not possible on query: SHOW TABLES
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/admintools/feature/utf8mb4.php:28
JROOT/plugins/system/admintools/admintools/main.php:685
JROOT/plugins/system/admintools/admintools/main.php:118
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:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
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.22 ms Query memory: 0.021 MB Memory before query: 5.840 MB Rows returned: 21
```
SHOW FULL COLUMNS 
  FROM fly9i_acymailing_action
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM fly9i_acymailing_action
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/admintools/feature/utf8mb4.php:28
JROOT/plugins/system/admintools/admintools/main.php:685
JROOT/plugins/system/admintools/admintools/main.php:118
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:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

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

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_admintools_storage	const	PRIMARY	PRIMARY	302	const	1

Query Time: 1.08 ms After last query: 5.95 ms Query memory: 0.033 MB Memory before query: 6.354 MB Rows returned: 48

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

  LEFT JOIN fly9i_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	78	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.m.component_id	1	Using where

Profile

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

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:357

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:1022

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

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

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

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: 9.38 ms Query memory: 0.023 MB Memory before query: 7.438 MB Rows returned: 30
```
SHOW FULL COLUMNS 
  FROM `fly9i_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `fly9i_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/articlesanywhere/helper.php:56
JROOT/plugins/system/nnframework/helpers/helper.php:29
JROOT/plugins/system/articlesanywhere/articlesanywhere.php:102
JROOT/plugins/system/articlesanywhere/articlesanywhere.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:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.46 ms After last query: 0.36 ms Query memory: 0.024 MB Memory before query: 7.481 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM fly9i_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/articlesanywhere/helper.php:70
JROOT/plugins/system/nnframework/helpers/helper.php:29
JROOT/plugins/system/articlesanywhere/articlesanywhere.php:102
JROOT/plugins/system/articlesanywhere/articlesanywhere.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:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
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.63 ms Query memory: 0.024 MB Memory before query: 7.505 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM fly9i_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.78 ms After last query: 0.20 ms Query memory: 0.018 MB Memory before query: 7.513 MB
```
UPDATE `fly9i_extensions`

  SET `params` = '{\"mediaversion\":\"1017266658b4e20fd2eb3916ab8439ea\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `fly9i_extensions` SET `params` = '{\"mediaversion\":\"1017266658b4e20fd2eb3916ab8439ea\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.17 ms After last query: 23.11 ms Query memory: 0.043 MB Memory before query: 10.163 MB Rows returned: 1
```
SELECT `params`
 
  FROM `fly9i_comprofiler_plugin`
 
  WHERE `id` = 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_comprofiler_plugin const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345
JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
JROOT/libraries/CBLib/CB/Application/CBApplication.php:44
JROOT/libraries/CBLib/CBLib/Application/Config.php:38
JROOT/libraries/CBLib/CBLib/Core/CBLib.php:70
JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:605
JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
JROOT/libraries/CBLib/CBLib/Application/Application.php:179
JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:109
JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:643
JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:496
JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:132
JROOT/administrator/components/com_comprofiler/plugin.foundation.php:33
JROOT/components/com_comprofiler/router.php:75
JROOT/components/com_comprofiler/router.php:125
JROOT/components/com_comprofiler/router.php:466
JROOT/libraries/cms/router/site.php:455
JROOT/libraries/cms/router/site.php:413
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:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 9.32 ms Query memory: 0.015 MB Memory before query: 11.880 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM fly9i_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_comprofiler'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using index condition; Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:299
JROOT/libraries/cms/application/site.php:122
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.12 ms After last query: 0.45 ms Query memory: 0.013 MB Memory before query: 11.906 MB Rows returned: 1
```
SELECT *

  FROM fly9i_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:166
JROOT/libraries/cms/application/site.php:307
JROOT/libraries/cms/application/site.php:122
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

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

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

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

Query Time: 0.48 ms After last query: 0.23 ms Query memory: 0.014 MB Memory before query: 11.926 MB Rows returned: 3

Duplicate queries: #36

SELECT id, home, template, s.params

  FROM fly9i_template_styles as s

  LEFT JOIN fly9i_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	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

Profile

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

Call Stack

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.18 ms After last query: 7.78 ms Query memory: 0.021 MB Memory before query: 13.278 MB Rows returned: 6

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `fly9i_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1)
 
  AND `type` = 'user'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_comprofiler_plugin	ref	type_pub_order,idx_folder	type_pub_order	304	const,const	6	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394

JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181

JROOT/components/com_comprofiler/comprofiler.php:922

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.29 ms After last query: 22.40 ms Query memory: 0.043 MB Memory before query: 18.695 MB Rows returned: 1

Duplicate queries: #68

SELECT * 
  FROM fly9i_adsused_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsused_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_adsused/lib/core.php:94

JROOT/components/com_comprofiler/plugin/user/plug_adsused-tab/adsused.plugin.php:10

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238

JROOT/components/com_comprofiler/plugin/user/plug_cbarticles/cbarticles.php:22

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:402

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:238

JROOT/components/com_comprofiler/comprofiler.php:922

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.08 ms After last query: 13.00 ms Query memory: 0.025 MB Memory before query: 20.128 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `fly9i_users`

Explain

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

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
closing tables	0.0 ms
Opening tables	0.3 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.1 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.0 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/libraries/joomla/table/user.php:38

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

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

JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:160

JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:120

JROOT/components/com_comprofiler/comprofiler.php:949

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

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: 1.24 ms Query memory: 0.023 MB Memory before query: 20.200 MB Rows returned: 1

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `fly9i_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1)
 
  AND `type` = 'templates'
 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_comprofiler_plugin	ref	type_pub_order,idx_folder	type_pub_order	304	const,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.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.1 ms
Preparing	0.0 ms
Sorting result	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.0 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/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394

JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181

JROOT/components/com_comprofiler/comprofiler.html.php:328

JROOT/components/com_comprofiler/comprofiler.html.php:880

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

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: 9.76 ms Query memory: 0.024 MB Memory before query: 21.153 MB Rows returned: 12

SELECT * 
  FROM fly9i_comprofiler_tabs t
 
  WHERE t.enabled = 1
 
  ORDER BY t.ordering_register, t.position, t.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	enabled_position_ordering,orderreg_enabled_pos_order,orderedit_enabled_pos_order	NO INDEX KEY COULD BE USED	NULL	NULL	19	Using where; Using filesort

Profile

Status	Duration
Starting	0.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.5 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.0 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/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394

JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:850

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:719

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.63 ms After last query: 0.47 ms Query memory: 0.027 MB Memory before query: 21.223 MB Rows returned: 10

SELECT f.* 
  FROM fly9i_comprofiler_fields f
 
  INNER JOIN fly9i_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1 
  AND f.registration > 0 
  AND t.enabled = 1
 
  ORDER BY t.ordering_register, t.position, t.ordering, f.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	tabid_pub_prof_order,registration_published_order	NO INDEX KEY COULD BE USED	NULL	NULL	36	Using where; Using temporary; Using filesort
1	SIMPLE	t	eq_ref\|filter	PRIMARY,enabled_position_ordering,orderreg_enabled_pos_order,orderedit_enabled_pos_order	PRIMARY\|enabled_position_ordering	4\|1	broadcas_2015.f.tabid	1 (63%)	Using where; Using rowid filter

Profile

Status	Duration
Starting	0.0 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.3 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.8 ms
Creating sort index	0.1 ms
Removing tmp table	0.1 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.0 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.7 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:394

JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:446

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:958

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:725

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.16 ms After last query: 9.59 ms Query memory: 0.031 MB Memory before query: 21.866 MB Rows returned: 1

SELECT a.rules

  FROM fly9i_assets AS a

  WHERE (a.id = 1)

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

Explain

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

Profile

Status	Duration
Starting	0.0 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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

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

JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsUser.php:291

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:216

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:277

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:233

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:308

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3240

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:881

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1375

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1290

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1053

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:768

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

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: 3.77 ms Query memory: 0.039 MB Memory before query: 22.227 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `fly9i_assets`

Explain

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

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
closing tables	0.0 ms
Opening tables	0.3 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.1 ms
closing tables	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
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.0 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/libraries/joomla/table/asset.php:63

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

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

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

JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsUser.php:291

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:216

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:277

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:233

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:308

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3240

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:881

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1375

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1290

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1053

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:768

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

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.21 ms Query memory: 0.032 MB Memory before query: 22.280 MB Rows returned: 1

SELECT id

  FROM fly9i_assets

  WHERE parent_id = 0

Explain

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

Profile

Status	Duration
Starting	0.0 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.7 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.0 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/table/nested.php:1214

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

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

JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsUser.php:291

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:216

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:277

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:233

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:308

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3240

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:881

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1375

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1290

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1053

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:768

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.79 ms After last query: 0.13 ms Query memory: 0.032 MB Memory before query: 22.313 MB Rows returned: 1

SELECT b.rules

  FROM fly9i_assets AS a

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

  WHERE (a.id = 1)

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

  ORDER BY b.lft

Explain

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

Profile

Status	Duration
Starting	0.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
Unlocking tables	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.0 ms
Removing tmp table	0.1 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.0 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:250

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

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

JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsUser.php:291

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:216

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:277

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:233

JROOT/libraries/CBLib/CBLib/Entity/User/User.php:308

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3240

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:881

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1375

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1290

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1053

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:768

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.55 ms After last query: 3.17 ms Query memory: 0.033 MB Memory before query: 22.382 MB Rows returned: 0

SELECT `id`
 
  FROM `fly9i_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=pluginclass&plugin=cbantispam%' OR `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbantispam%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1 )
 
  AND `language` IN ( 'en-GB', '*', '' )

Explain

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

Profile

Status	Duration
Starting	0.0 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.0 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/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345

JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222

JROOT/libraries/CBLib/CB/Legacy/CBframework.php:953

JROOT/libraries/CBLib/CB/Legacy/CBframework.php:1078

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:762

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:931

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:974

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3268

JROOT/libraries/CBLib/CB/Legacy/cbFieldHandler.php:100

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3246

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:881

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1375

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1290

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1053

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:768

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.17 ms After last query: 0.14 ms Query memory: 0.033 MB Memory before query: 22.415 MB Rows returned: 1

SELECT `id`
 
  FROM `fly9i_menu`
 
  WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
 
  AND `published` = 1
 
  AND `access` IN ( 1 )
 
  AND `language` IN ( 'en-GB', '*', '' )

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.1 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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345

JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:242

JROOT/libraries/CBLib/CB/Legacy/CBframework.php:953

JROOT/libraries/CBLib/CB/Legacy/CBframework.php:1078

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:762

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:931

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:974

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3268

JROOT/libraries/CBLib/CB/Legacy/cbFieldHandler.php:100

JROOT/components/com_comprofiler/plugin/user/plug_cbantispam/cbantispam.php:3246

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:881

JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:1077

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1375

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1290

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1053

JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:768

JROOT/components/com_comprofiler/comprofiler.html.php:899

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

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: 1.06 ms Query memory: 0.017 MB Memory before query: 22.461 MB Rows returned: 0

SELECT `id`
 
  FROM `fly9i_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=saveregisters%' OR `link` LIKE 'index.php?option=com_comprofiler&task=saveregisters%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1 )
 
  AND `language` IN ( 'en-GB', '*', '' )

Explain

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

Profile

Status	Duration
Starting	0.0 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.0 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/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345

JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:222

JROOT/libraries/CBLib/CB/Legacy/CBframework.php:921

JROOT/components/com_comprofiler/comprofiler.html.php:948

JROOT/components/com_comprofiler/comprofiler.php:956

JROOT/components/com_comprofiler/comprofiler.php:127

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

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

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

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

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

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: 22.92 ms Query memory: 0.025 MB Memory before query: 25.241 MB Rows returned: 3

Duplicate queries: #22

SELECT id, home, template, s.params

  FROM fly9i_template_styles as s

  LEFT JOIN fly9i_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	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	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 privileges on cached	0.0 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/libraries/gantry/core/gantrytemplate.class.php:638

JROOT/libraries/gantry/core/gantrytemplate.class.php:590

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36

JROOT/libraries/gantry/core/gantry.class.php:1843

JROOT/libraries/gantry/core/gantry.class.php:392

JROOT/libraries/gantry/gantry.php:275

JROOT/libraries/gantry/gantry.php:432

JROOT/templates/gantry/lib/gantry/gantry.php:21

JROOT/templates/gantry/index.php:15

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:978

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

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

JROOT/index.php:40

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

Query Time: 1.30 ms After last query: 13.40 ms Query memory: 0.025 MB Memory before query: 26.070 MB Rows returned: 55

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

  FROM fly9i_modules AS m

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

  LEFT JOIN fly9i_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 <= '2023-11-30 08:40:20') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-30 08:40:20') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 616 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	96	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	broadcas_2015.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	broadcas_2015.m.module,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.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.1 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.1 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.0 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/cms/module/helper.php:376

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

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

JROOT/libraries/gantry/core/gantry.class.php:804

JROOT/libraries/gantry/core/gantry.class.php:757

JROOT/templates/gantry/index.php:74

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:978

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

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

JROOT/index.php:40

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

Query Time: 0.50 ms After last query: 8.35 ms Query memory: 0.024 MB Memory before query: 26.981 MB Rows returned: 0

SELECT ts.template

  FROM fly9i_template_styles AS ts

  INNER JOIN fly9i_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 616 
  AND m.template_style_id != 0

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.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.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.0 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_roknavmenu/lib/RokNavMenu.php:98

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22

JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21

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

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

JROOT/templates/gantry/features/dropdownmenu.php:56

JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65

JROOT/libraries/gantry/core/gantry.class.php:867

JROOT/templates/gantry/index.php:87

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:978

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

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

JROOT/index.php:40

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

Query Time: 1.23 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 27.003 MB Rows returned: 1

SELECT template

  FROM fly9i_template_styles

  WHERE home = 1 
  AND client_id = 0

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	1.1 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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:113

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22

JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21

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

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

JROOT/templates/gantry/features/dropdownmenu.php:56

JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65

JROOT/libraries/gantry/core/gantry.class.php:867

JROOT/templates/gantry/index.php:87

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:978

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

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

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: 7.42 ms Query memory: 0.056 MB Memory before query: 27.682 MB Rows returned: 1

Duplicate queries: #59 #114

SELECT * 
  FROM fly9i_adsnew_config

Explain

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

Profile

Status	Duration
Starting	0.0 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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_adsnew/lib/core.php:94

JROOT/components/com_adsnew/router.php:13

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

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

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

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

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

JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:174

JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:207

JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:273

JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php:65

JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenu.php:88

JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:22

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

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

JROOT/templates/gantry/features/dropdownmenu.php:56

JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65

JROOT/libraries/gantry/core/gantry.class.php:867

JROOT/templates/gantry/index.php:87

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:978

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

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

JROOT/index.php:40

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

Query Time: 0.26 ms After last query: 33.51 ms Query memory: 0.025 MB Memory before query: 28.920 MB Rows returned: 138

SELECT * 
  FROM fly9i_acymailing_config

Explain

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

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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/cpanel.php:17

JROOT/administrator/components/com_acymailing/helpers/helper.php:473

JROOT/administrator/components/com_acymailing/helpers/helper.php:1183

JROOT/modules/mod_acymailing/mod_acymailing.php:12

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

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:992

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

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

JROOT/index.php:40

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

Query Time: 0.17 ms After last query: 3.76 ms Query memory: 0.022 MB Memory before query: 29.400 MB Rows returned: 1

Duplicate queries: #113

SELECT * 
  FROM fly9i_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_acymailing_list	system	typeorderingindex,typeuseridindex	NO INDEX KEY COULD BE USED	NULL	NULL	1

Profile

Status	Duration
Starting	0.0 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.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/list.php:29

JROOT/modules/mod_acymailing/mod_acymailing.php:125

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

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:992

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

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

JROOT/index.php:40

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

Query Time: 0.11 ms After last query: 1.68 ms Query memory: 0.025 MB Memory before query: 29.332 MB Rows returned: 0
```
SEL
```

The No 1. Market Place for Professional AV and Broadcast Equipment !

Join us!

New Equipment

Used Equipment

Newsletter

Seller Login

Featured New Ads

Featured Used Ads

New Equipment

Used Equipment

Newsletter

Follow Us

Joomla! Debug Console

Session

__default

antispam_captcha

Profile Information

Time

Memory

Memory Usage

Database Queries

121 Queries Logged 35.3 ms

32 duplicate found!