Image	ID	Manufacturer	Model	Price	Currency	Negotiable
	2088	Probel	Various	$Offers	AUD	Y
Probel Router control system plus panels & Accessories - contact if you need any additional info
	2074	AVID	S6 m40/32/9D	$TBA	AUD	Y
Avid S6 m40/32/9D
	2073	Avid	S3 & S6 M40/8/5D	$TBA	AUD	Y
Avid S3 & S6 M40/8/5D
	2055	Avid	Unity	$1000	AUD	Y
Avid media fiber Storage units for sale.. Approx 60 TB's. Comes with spare drives, Licence, Fiber switch etc. Or use it for just the storage. Approx 240kg
	2017	Behringer	X1204USB	$250	AUD	Y
Behringer Xenyx X1204USB 12-Input Mixer w/ FX & USB.1 Left for sale
	2006	Blackmagic	VHUB/ST	$offers	AUD	Y
Blackmagic Studio Videohub 16 x 32 3G HD/SDI Routing Switcher with Master Panel
	1871	Panasonic	av-hs450	$1999	AUD	Y
Panasonic av-hs450 16 input HD SDI Vision switcher
	1847	BARCO	PDS-902	$1500	AUD	N
BARCO PDS-902 Seamless Switcher

Joomla! Debug Console

Session

Profile Information

Time

Memory

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

Time: 38.0 ms / 38.0 ms Memory: 5.632 MB / 6.28 MB Application: afterInitialise

Time: 21.8 ms / 59.8 ms Memory: 2.717 MB / 9.00 MB Application: afterRoute

Time: 31.4 ms / 91.2 ms Memory: 3.519 MB / 12.52 MB Application: afterDispatch

Time: 26.2 ms / 117.4 ms Memory: 3.190 MB / 15.71 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 19.7 ms / 137.1 ms Memory: 1.669 MB / 17.38 MB Application: afterRenderModule mod_roknavmenu ()

Time: 5.7 ms / 142.8 ms Memory: 0.026 MB / 17.40 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 2.3 ms / 145.1 ms Memory: 0.059 MB / 17.46 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.1 ms / 145.2 ms Memory: 0.000 MB / 17.45 MB Application: beforeRenderModule mod_custom (Follow Us)

Time: 0.7 ms / 145.9 ms Memory: 0.010 MB / 17.46 MB Application: afterRenderModule mod_custom (Follow Us)

Time: 0.1 ms / 146.0 ms Memory: 0.005 MB / 17.47 MB Application: beforeRenderModule mod_acymailing (Newsletter)

Time: 8.3 ms / 154.4 ms Memory: 1.238 MB / 18.71 MB Application: afterRenderModule mod_acymailing (Newsletter)

Time: 0.1 ms / 154.5 ms Memory: 0.000 MB / 18.68 MB Application: beforeRenderModule mod_menu ( Used Equipment)

Time: 4.3 ms / 158.8 ms Memory: 0.249 MB / 18.93 MB Application: afterRenderModule mod_menu ( Used Equipment)

Time: 0.1 ms / 158.9 ms Memory: 0.000 MB / 18.92 MB Application: beforeRenderModule mod_menu (New Equipment)

Time: 2.0 ms / 160.9 ms Memory: 0.116 MB / 19.04 MB Application: afterRenderModule mod_menu (New Equipment)

Time: 0.1 ms / 161.0 ms Memory: 0.001 MB / 19.04 MB Application: beforeRenderModule mod_cblogin (Seller Login)

Time: 51.6 ms / 212.6 ms Memory: 11.735 MB / 30.78 MB Application: afterRenderModule mod_cblogin (Seller Login)

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

Time: 6.5 ms / 219.2 ms Memory: 0.781 MB / 31.53 MB Application: afterRenderModule mod_adsnew_ads (Featured New Ads)

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

Time: 3.5 ms / 222.8 ms Memory: 0.244 MB / 31.73 MB Application: afterRenderModule mod_adsused_ads (Featured Used Ads)

Time: 0.1 ms / 222.9 ms Memory: 0.000 MB / 31.67 MB Application: beforeRenderModule mod_adsused_menu (Used Equipment)

Time: 8.7 ms / 231.6 ms Memory: 0.669 MB / 32.34 MB Application: afterRenderModule mod_adsused_menu (Used Equipment)

Time: 0.2 ms / 231.8 ms Memory: 0.000 MB / 32.21 MB Application: beforeRenderModule mod_adsnew_search (New Equipment Search)

Time: 2.9 ms / 234.7 ms Memory: 0.201 MB / 32.41 MB Application: afterRenderModule mod_adsnew_search (New Equipment Search)

Time: 0.1 ms / 234.8 ms Memory: 0.000 MB / 32.31 MB Application: beforeRenderModule mod_custom (Tagline)

Time: 0.2 ms / 235.0 ms Memory: 0.007 MB / 32.32 MB Application: afterRenderModule mod_custom (Tagline)

Time: 5.0 ms / 240.1 ms Memory: 0.266 MB / 32.59 MB Application: afterRender

Database queries total: 36.4 ms

Memory Usage

Database Queries

141 Queries Logged 36.4 ms

50 duplicate found!

2 duplicates: #14 #70

3 duplicates: #15 #23 #107

14 duplicates: #20 #32 #49 #53 #55 #57 #59 #61 #63 #65 #67 #69 #81 #128

7 duplicates: #25 #28 #36 #40 #99 #108 #135

5 duplicates: #26 #29 #37 #41 #109

2 duplicates: #35 #39

2 duplicates: #48 #115

2 duplicates: #50 #111

3 duplicates: #74 #98 #134

2 duplicates: #79 #126

2 duplicates: #80 #127

2 duplicates: #83 #129

2 duplicates: #85 #122

2 duplicates: #100 #136

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` = '2p88rvterjghp5lbmo2hn71pp1'
```
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.32 ms After last query: 0.96 ms Query memory: 0.012 MB Memory before query: 2.451 MB Rows returned: 0
```
SELECT `session_id`

  FROM `fly9i_session`

  WHERE `session_id` = '2p88rvterjghp5lbmo2hn71pp1' 
  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.71 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 2.463 MB
```
INSERT INTO `fly9i_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('2p88rvterjghp5lbmo2hn71pp1', 0, '1701331240')
```
Explain
EXPLAIN not possible on query: INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`) VALUES ('2p88rvterjghp5lbmo2hn71pp1', 0, '1701331240')
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.49 ms After last query: 2.02 ms Query memory: 0.015 MB Memory before query: 2.822 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.78 ms Query memory: 0.014 MB Memory before query: 2.927 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.36 ms Query memory: 0.013 MB Memory before query: 2.990 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.62 ms After last query: 0.13 ms Query memory: 0.014 MB Memory before query: 3.009 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.35 ms After last query: 0.25 ms Query memory: 0.014 MB Memory before query: 3.096 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.14 ms After last query: 7.27 ms Query memory: 0.016 MB Memory before query: 4.437 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.51 ms Query memory: 0.018 MB Memory before query: 4.510 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: 0.89 ms After last query: 8.12 ms Query memory: 0.022 MB Memory before query: 5.786 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.78 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 5.832 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	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

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	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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.00 ms After last query: 3.48 ms Query memory: 0.033 MB Memory before query: 6.345 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.17 ms After last query: 6.94 ms Query memory: 0.022 MB Memory before query: 7.794 MB Rows returned: 3

Duplicate queries: #70

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/components/com_adsused/lib/core.php:78

JROOT/components/com_adsused/router.php:13

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

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.16 ms After last query: 0.41 ms Query memory: 0.038 MB Memory before query: 7.847 MB Rows returned: 1
Duplicate queries: #23 #107
```
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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/lib/core.php:94
JROOT/components/com_adsused/router.php:13
JROOT/libraries/cms/router/site.php:381
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.56 ms After last query: 0.36 ms Query memory: 0.026 MB Memory before query: 7.930 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/components/com_adsused/lib/core.php:127
JROOT/components/com_adsused/router.php:13
JROOT/libraries/cms/router/site.php:381
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.81 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 7.941 MB
```
UPDATE `fly9i_extensions`

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

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `fly9i_extensions` SET `params` = '{\"mediaversion\":\"dd3ad5c44430c444423c6d072feac5ab\",\"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/components/com_adsused/lib/core.php:127
JROOT/components/com_adsused/router.php:13
JROOT/libraries/cms/router/site.php:381
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: 1.01 ms After last query: 7.86 ms Query memory: 0.024 MB Memory before query: 8.926 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.40 ms After last query: 0.27 ms Query memory: 0.024 MB Memory before query: 8.970 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.10 ms After last query: 0.70 ms Query memory: 0.022 MB Memory before query: 8.957 MB Rows returned: 1
Duplicate queries: #32 #49 #53 #55 #57 #59 #61 #63 #65 #67 #69 #81 #128
```
SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 7
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/router.php:20
JROOT/components/com_adsused/router.php:96
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.39 ms After last query: 0.49 ms Query memory: 0.015 MB Memory before query: 9.022 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM fly9i_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_adsused'
```
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.11 ms After last query: 0.39 ms Query memory: 0.014 MB Memory before query: 9.047 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]
Query Time: 0.21 ms After last query: 7.31 ms Query memory: 0.037 MB Memory before query: 10.275 MB Rows returned: 1
Duplicate queries: #15 #107
```
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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/configuration.php:27
JROOT/components/com_adsused/controller.php:95
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.51 ms After last query: 0.72 ms Query memory: 0.022 MB Memory before query: 10.379 MB Rows returned: 1
```
SELECT * 
  FROM fly9i_adsused_categories 
  WHERE id = 7
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/category.php:23
JROOT/components/com_adsused/views/list/view.html.php:65
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.10 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 10.404 MB Rows returned: 1
Duplicate queries: #28 #36 #40 #99 #108 #135
```
SELECT group_id 
  FROM fly9i_user_usergroup_map
						
  WHERE user_id = 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/helpers/usergroups.php:19
JROOT/components/com_adsused/lib/tpermissions.php:21
JROOT/administrator/components/com_adsused/models/category.php:131
JROOT/components/com_adsused/views/list/view.html.php:153
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.11 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 10.426 MB Rows returned: 26
Duplicate queries: #29 #37 #41 #109
```
SELECT c.* 
  FROM fly9i_adsused_categories as c 
  WHERE  1   
  ORDER BY c.parent,c.ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/category.php:69
JROOT/components/com_adsused/lib/tpermissions.php:26
JROOT/administrator/components/com_adsused/models/category.php:131
JROOT/components/com_adsused/views/list/view.html.php:153
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.69 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 10.447 MB Rows returned: 0
```
SELECT c.* 
  FROM fly9i_adsused_categories as c 
  WHERE c.parent = 7 
  AND c.published = 1  
  AND c.id IN (33,10,25,26,28,5,6,7,8,34,35,30,18,19,29,14,15,17,12,13,21,20,31,3,24)  
  ORDER BY c.ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 27 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/category.php:143
JROOT/components/com_adsused/views/list/view.html.php:153
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.12 ms After last query: 0.04 ms Query memory: 0.023 MB Memory before query: 10.466 MB Rows returned: 1
Duplicate queries: #25 #36 #40 #99 #108 #135
```
SELECT group_id 
  FROM fly9i_user_usergroup_map
						
  WHERE user_id = 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/helpers/usergroups.php:19
JROOT/components/com_adsused/lib/tpermissions.php:21
JROOT/administrator/components/com_adsused/models/category.php:56
JROOT/administrator/components/com_adsused/models/category.php:78
JROOT/components/com_adsused/views/list/view.html.php:154
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.12 ms After last query: 0.05 ms Query memory: 0.028 MB Memory before query: 10.489 MB Rows returned: 26
Duplicate queries: #26 #37 #41 #109
```
SELECT c.* 
  FROM fly9i_adsused_categories as c 
  WHERE  1   
  ORDER BY c.parent,c.ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/category.php:69
JROOT/components/com_adsused/lib/tpermissions.php:26
JROOT/administrator/components/com_adsused/models/category.php:56
JROOT/administrator/components/com_adsused/models/category.php:78
JROOT/components/com_adsused/views/list/view.html.php:154
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.14 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 10.510 MB Rows returned: 25
```
SELECT c.* 
  FROM fly9i_adsused_categories as c 
  WHERE  c.published = 1   
  AND c.id IN (33,10,25,26,28,5,6,7,8,34,35,30,18,19,29,14,15,17,12,13,21,20,31,3,24)  
  ORDER BY c.parent,c.ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 27 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/category.php:69
JROOT/administrator/components/com_adsused/models/category.php:78
JROOT/components/com_adsused/views/list/view.html.php:154
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.10 ms After last query: 0.47 ms Query memory: 0.022 MB Memory before query: 10.621 MB Rows returned: 0
```
SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsused&view=list%' 
  AND published ='1' 
  AND type ='component'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 148 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/lib/route.php:210
JROOT/components/com_adsused/lib/route.php:94
JROOT/administrator/components/com_adsused/models/category.php:96
JROOT/components/com_adsused/views/list/view.html.php:154
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.09 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 10.646 MB Rows returned: 1
Duplicate queries: #20 #49 #53 #55 #57 #59 #61 #63 #65 #67 #69 #81 #128
```
SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 7
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_adsused_categories const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/router.php:20
JROOT/components/com_adsused/router.php:96
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/components/com_adsused/lib/route.php:176
JROOT/administrator/components/com_adsused/models/category.php:96
JROOT/components/com_adsused/views/list/view.html.php:154
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.09 ms After last query: 0.25 ms Query memory: 0.020 MB Memory before query: 10.610 MB Rows returned: 4
```
SELECT f.title,f.fieldid,f.catsid 
  FROM fly9i_adsused_fields AS f 
  WHERE f.sort = 1 
  AND f.published = 1 
  ORDER BY f.ordering ASC
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 36 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/field.php:59
JROOT/components/com_adsused/views/list/view.html.php:162
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.13 ms After last query: 0.09 ms Query memory: 0.033 MB Memory before query: 10.633 MB Rows returned: 31
```
SELECT * 
  FROM fly9i_adsused_fields as f 
  WHERE  f.published = 1  
  ORDER by f.ordering ASC
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE f ALL NULL NO INDEX KEY COULD BE USED NULL NULL 36 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/field.php:88
JROOT/components/com_adsused/views/list/view.html.php:173
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.09 ms After last query: 0.37 ms Query memory: 0.022 MB Memory before query: 10.853 MB Rows returned: 26
Duplicate queries: #39
```
SELECT c.id, c.name,c.parent  
  FROM fly9i_adsused_categories as c 
  WHERE c.published = 1 
  ORDER BY c.parent,c.ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/content.php:217
JROOT/administrator/components/com_adsused/models/content.php:412
JROOT/components/com_adsused/views/list/view.html.php:189
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.08 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 10.873 MB Rows returned: 1
Duplicate queries: #25 #28 #40 #99 #108 #135
```
SELECT group_id 
  FROM fly9i_user_usergroup_map
						
  WHERE user_id = 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/helpers/usergroups.php:19
JROOT/components/com_adsused/lib/tpermissions.php:21
JROOT/administrator/components/com_adsused/models/content.php:418
JROOT/components/com_adsused/views/list/view.html.php:189
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.09 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 10.895 MB Rows returned: 26
Duplicate queries: #26 #29 #41 #109
```
SELECT c.* 
  FROM fly9i_adsused_categories as c 
  WHERE  1   
  ORDER BY c.parent,c.ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/category.php:69
JROOT/components/com_adsused/lib/tpermissions.php:26
JROOT/administrator/components/com_adsused/models/content.php:418
JROOT/components/com_adsused/views/list/view.html.php:189
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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]

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

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_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_adsused_categories	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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Query Time: 1.02 ms After last query: 0.21 ms Query memory: 0.020 MB Memory before query: 10.915 MB Rows returned: 8

SELECT a.id  
  FROM fly9i_adsused_ads as a  
  INNER JOIN fly9i_adsused_adcat as adcat 
  ON adcat.adid = a.id  
  LEFT JOIN fly9i_users as u 
  ON a.userid = u.id  
  LEFT JOIN fly9i_comprofiler as cb 
  ON cb.user_id = a.userid  
  INNER JOIN fly9i_adsused_categories as c 
  ON adcat.catid = c.id  
  LEFT JOIN fly9i_adsused_categories as p 
  ON c.parent = p.id  
  WHERE  a.published = 1 
  AND c.published = TRUE  
  AND c.id IN (7)  
  AND c.id IN (33,10,25,26,28,5,6,7,8,34,35,30,18,19,29,14,15,17,12,13,21,20,31,3,24)  
  GROUP BY a.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	adcat	index	PRIMARY	PRIMARY	8	NULL	1302	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.adcat.adid	1	Using where

Profile

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

Call Stack

JROOT/administrator/components/com_adsused/models/content.php:444

JROOT/components/com_adsused/views/list/view.html.php:189

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

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

JROOT/components/com_adsused/controller.php:145

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

JROOT/components/com_adsused/adsused.php:29

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.12 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 10.935 MB Rows returned: 26
Duplicate queries: #35
```
SELECT c.id, c.name,c.parent  
  FROM fly9i_adsused_categories as c 
  WHERE c.published = 1 
  ORDER BY c.parent,c.ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_adsused/models/content.php:217
JROOT/administrator/components/com_adsused/models/content.php:339
JROOT/components/com_adsused/views/list/view.html.php:190
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.09 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 10.954 MB Rows returned: 1
Duplicate queries: #25 #28 #36 #99 #108 #135
```
SELECT group_id 
  FROM fly9i_user_usergroup_map
						
  WHERE user_id = 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE fly9i_user_usergroup_map ref PRIMARY PRIMARY 4 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_adsused/helpers/usergroups.php:19
JROOT/components/com_adsused/lib/tpermissions.php:21
JROOT/administrator/components/com_adsused/models/content.php:349
JROOT/components/com_adsused/views/list/view.html.php:190
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/joomla/cache/controller/callback.php:43
JROOT/components/com_adsused/controller.php:145
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_adsused/adsused.php:29
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.10 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 10.976 MB Rows returned: 26

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

Switchers & Mixers/ NLE/ Servers

Used Equipment

Seller Login

Featured New Ads

Featured Used Ads

New Equipment

Used Equipment

Newsletter

Follow Us

Joomla! Debug Console

Session

__default

__adsused

Profile Information

Time

Memory

Memory Usage

Database Queries

141 Queries Logged 36.4 ms

50 duplicate found!