Joomla! Debug Console

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.610 MB / 0.61 MB Application: afterLoad

Time: 52.9 ms / 52.9 ms Memory: 5.633 MB / 6.24 MB Application: afterInitialise

Time: 68.6 ms / 121.6 ms Memory: 2.742 MB / 8.99 MB Application: afterRoute

Time: 27.3 ms / 148.8 ms Memory: 2.552 MB / 11.54 MB Application: beforeRenderModule mod_adsused_prevNext (AdsUsed Navigation)

Time: 16.7 ms / 165.5 ms Memory: 1.264 MB / 12.80 MB Application: afterRenderModule mod_adsused_prevNext (AdsUsed Navigation)

Time: 4.7 ms / 170.2 ms Memory: 0.000 MB / 12.60 MB Application: afterDispatch

Time: 66.9 ms / 237.1 ms Memory: 3.041 MB / 15.64 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 20.1 ms / 257.2 ms Memory: 1.639 MB / 17.28 MB Application: afterRenderModule mod_roknavmenu ()

Time: 6.5 ms / 263.7 ms Memory: 0.026 MB / 17.31 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 54.0 ms / 317.7 ms Memory: 0.059 MB / 17.37 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.2 ms / 317.9 ms Memory: 0.000 MB / 17.36 MB Application: beforeRenderModule mod_custom (Follow Us)

Time: 1.3 ms / 319.2 ms Memory: 0.010 MB / 17.37 MB Application: afterRenderModule mod_custom (Follow Us)

Time: 0.2 ms / 319.4 ms Memory: 0.005 MB / 17.38 MB Application: beforeRenderModule mod_acymailing (Newsletter)

Time: 16.4 ms / 335.8 ms Memory: 1.239 MB / 18.62 MB Application: afterRenderModule mod_acymailing (Newsletter)

Time: 0.3 ms / 336.0 ms Memory: 0.000 MB / 18.59 MB Application: beforeRenderModule mod_menu ( Used Equipment)

Time: 7.3 ms / 343.4 ms Memory: 0.251 MB / 18.84 MB Application: afterRenderModule mod_menu ( Used Equipment)

Time: 0.2 ms / 343.6 ms Memory: 0.000 MB / 18.84 MB Application: beforeRenderModule mod_menu (New Equipment)

Time: 3.5 ms / 347.1 ms Memory: 0.116 MB / 18.95 MB Application: afterRenderModule mod_menu (New Equipment)

Time: 0.2 ms / 347.3 ms Memory: 0.001 MB / 18.95 MB Application: beforeRenderModule mod_cblogin (Seller Login)

Time: 177.3 ms / 524.6 ms Memory: 11.734 MB / 30.69 MB Application: afterRenderModule mod_cblogin (Seller Login)

Time: 0.2 ms / 524.8 ms Memory: 0.000 MB / 30.66 MB Application: beforeRenderModule mod_adsnew_ads (Featured New Ads)

Time: 14.4 ms / 539.2 ms Memory: 0.775 MB / 31.44 MB Application: afterRenderModule mod_adsnew_ads (Featured New Ads)

Time: 0.2 ms / 539.4 ms Memory: 0.000 MB / 31.39 MB Application: beforeRenderModule mod_adsused_ads (Featured Used Ads)

Time: 52.3 ms / 591.8 ms Memory: 0.236 MB / 31.63 MB Application: afterRenderModule mod_adsused_ads (Featured Used Ads)

Time: 0.3 ms / 592.1 ms Memory: 0.000 MB / 31.57 MB Application: beforeRenderModule mod_adsused_menu (Used Equipment)

Time: 28.2 ms / 620.3 ms Memory: 0.652 MB / 32.22 MB Application: afterRenderModule mod_adsused_menu (Used Equipment)

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

Time: 3.6 ms / 624.1 ms Memory: 0.202 MB / 32.28 MB Application: afterRenderModule mod_adsnew_search (New Equipment Search)

Time: 0.1 ms / 624.2 ms Memory: 0.000 MB / 32.19 MB Application: beforeRenderModule mod_custom (Tagline)

Time: 0.3 ms / 624.5 ms Memory: 0.007 MB / 32.20 MB Application: afterRenderModule mod_custom (Tagline)

Time: 11.5 ms / 635.9 ms Memory: 0.463 MB / 32.66 MB Application: afterRender

Database queries total: 103.6 ms

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

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

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)

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_adsused_ads	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_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	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	adcat	range	PRIMARY	PRIMARY	8	NULL	26	Using where; Using index
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.adcat.catid	1
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.c.parent	1	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_user_usergroup_map	ref	PRIMARY	PRIMARY	4	const	1	Using index

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

EXPLAIN not possible on query: UPDATE `fly9i_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713516930;s:18:\"session.timer.last\";i:1713516930;s:17:\"session.timer.now\";i:1713516930;s:24:\"session.client.forwarded\";s:13:\"3.137.220.120\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1713516931' WHERE `session_id` = 'ml0n64k6o6go5fl5015e5hrkd4'

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.1 ms
Updating	0.2 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.4 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/session/storage/database.php:85

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

53 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

28 × SELECT name 
  FROM fly9i_adsused_categories

11 × SELECT id,language 
  FROM fly9i_menu

9 × SELECT c.* 
  FROM fly9i_adsused_categories as c

7 × SELECT group_id 
  FROM fly9i_user_usergroup_map

5 × SELECT name 
  FROM fly9i_adsnew_categories

5 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM fly9i_extensions

4 × SELECT * 
  FROM fly9i_adsused_confi

```
4 × SELECT `id`  
  FROM `fly9i_menu`
```

3 × SELECT c.* 
  FROM fly9i_adsnew_categories as c

3 × SELECT ad_headline 
  FROM fly9i_adsused_ads

3 × SELECT * 
  FROM fly9i_adsnew_confi

```
2 × SELECT id 
  FROM fly9i_menu
```

2 × SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname  
  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  
  INNER JOIN fly9i_adsused_categories as c 
  ON adcat.catid = c.id  
  LEFT JOIN fly9i_adsused_categories as p 
  ON c.parent = p.id

2 × SELECT * 
  FROM fly9i_adsused_categories

2 × 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

1 × SELECT template 
  FROM fly9i_template_styles

1 × SELECT * 
  FROM fly9i_acymailing_confi

1 × SELECT * 
  FROM fly9i_acymailing_list

1 × SELECT f.* 
  FROM fly9i_comprofiler_fields f  
  INNER JOIN fly9i_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)

1 × SELECT `params`  
  FROM `fly9i_comprofiler_plugin`

1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `fly9i_comprofiler_plugin`

1 × SELECT ac.catid,ac.adid  
  FROM fly9i_adsused_adcat as ac 
  INNER JOIN fly9i_adsused_ads as a 
  ON a.id = ac.adid

1 × SELECT * 
  FROM fly9i_template_styles

1 × SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user  
  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  
  INNER JOIN fly9i_adsused_categories as c 
  ON adcat.catid = c.id  
  LEFT JOIN fly9i_adsused_categories as p 
  ON c.parent = p.id

1 × SELECT ad_headline 
  FROM fly9i_adsnew_ads

1 × SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user  
  FROM fly9i_adsnew_ads as a  
  INNER JOIN fly9i_adsnew_adcat as adcat 
  ON adcat.adid = a.id  
  LEFT JOIN fly9i_users as u 
  ON a.userid = u.id  
  INNER JOIN fly9i_adsnew_categories as c 
  ON adcat.catid = c.id  
  LEFT JOIN fly9i_adsnew_categories as p 
  ON c.parent = p.id

1 × SELECT ts.template 
  FROM fly9i_template_styles AS ts 
  INNER JOIN fly9i_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT f.* 
  FROM fly9i_adsused_fields AS f

1 × SELECT * 
  FROM `fly9i_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `fly9i_admintools_storage`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM fly9i_menu AS m 
  LEFT JOIN fly9i_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT folder AS type, element AS name, params 
  FROM fly9i_extensions

1 × SELECT id, rules 
  FROM `fly9i_viewlevels

1 × SELECT `session_id` 
  FROM `fly9i_session`

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

```
1 × SELECT * 
  FROM fly9i_languages
```

1 × SELECT * 
  FROM fly9i_adsused_positions

1 × 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

1 × SELECT c.id, c.name,c.parent  
  FROM fly9i_adsused_categories as c

1 × SELECT * 
  FROM fly9i_adsused_fields as f

1 × SELECT fieldid,cbfieldvalues 
  FROM fly9i_adsused_fields as f

1 × SELECT `data` 
  FROM `fly9i_session`

1 × SELECT * 
  FROM fly9i_adsused_field_values

1 × SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname  
  FROM fly9i_adsused_ads as a  
  INNER JOIN fly9i_adsused_adcat as adcat 
  ON adcat.adid = a.id  
  LEFT JOIN fly9i_comprofiler as cb 
  ON cb.user_id = a.userid  
  LEFT JOIN fly9i_users as u 
  ON a.userid = u.id  
  INNER JOIN fly9i_adsused_categories as c 
  ON adcat.catid = c.id  
  LEFT JOIN fly9i_adsused_categories as p 
  ON c.parent = p.id

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `fly9i_users

1 × SHOW FULL COLUMNS 
  FROM `fly9i_template_styles

1 × UPDATE `fly9i_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713516930;s:18:\"session.timer.last\";i:1713516930;s:17:\"session.timer.now\";i:1713516930;s:24:\"session.client.forwarded\";s:13:\"3.137.220.120\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'  , `time` = '1713516931'

1 × UPDATE fly9i_adsused_ads 
  SET views = LAST_INSERT_ID(views+1)

1 × SHOW FULL COLUMNS 
  FROM `fly9i_content

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM fly9i_acymailing_actio

1 × UPDATE `fly9i_extensions` 
  SET `params` = '{\"mediaversion\":\"96f187ed556d40645abdf531d10d4d22\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}'

1 × INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('ml0n64k6o6go5fl5015e5hrkd4', 0, '1713516930'

	Here is a list of some of our goods Wanted & For sale both local and from our associates overseas. Follow the links or contact us for further information. Plenty more available on our site, or shoot me an email if there is something your looking for. Got something to sell, place it on BAV.com.au or send me the information and I will market it free of charge. You have nothing to lose. All prices are Ex GST, Most prices are negotiable. Please contact us if you have any questions.

	Wanted:
	Canon CN7x17 KAS S Cine-Servo 17-120mm T2.95
	Fujinon 19-90mm with Servo
	Looking for a Sony PMW-200 or EX3 Camcorder, possibly 2 if the price is right. Please let me know if you can assist.
	Sony PMW-F55
	Sony PMW-F5
	Sony RM-IP500 Professional Remote Controller for Select Sony PTZ Cameras (Used)
	Sony JH3 HD Player
	Mini DV Player

	For Sale

	Lenses:
NEW	Fujinon UA24X7.8BERD 2/3" 24x 4K UHD ENG Zoom with 2x Extender	$27,328
NEW	Fujinon 4K UA14x4.5 BERD ENG Style Lens with Servo Zoom and Doubler	$27,328
NEW	Fujinon UA46x9.5BERD is an ultra-high zoom 4K lens with world’s highest 46x zoom magnification	$72,432
Ex Demo	Fujinon HA42x9.7-BERD-U48 2/3" 42x ENG HDTV Lens with Built-In Stabilizer - 1-3 months light use only - 1 yr Warranty - Comes with Fujinon ALH-117C-01A Lens Supporter & Brand New $SS-130 Zoom/Focus	$41,035
NEW	Canon CJ45EX9.7B IASE-V H 4k Ultra Telephoto Broadcast Lens w/Supporter, ZSD-300D, and FPD-400D x 2 available	$71,432
NEW	Canon CJ45ex13.6B IASE V-H, 4k Ultra Telephoto Broadcast Lens Tele Lens w/Supporter, ZSD-300D and FPD-400D x 4 avail	$73,903
NEW	Canon CN20 X 50 PL mount (goes to 1500 mm)	$81,940
NEW	Canon CJ14ex4.3B IASE full servo (4K) price is per lens.. Less if multiple are purchased.. Contact for details	$25,528
NEW	Canon CJ24ex7.5B IASE full servo (4K)	$25,528
NEW	Canon UJ90 X 9B 4K UHD box lens, supporter, servo controls set	$100,574
NEW	Canon HJ24 IASE full servo HD lens with 2x doubler - price for each. Less if multiple are purchased	$20,316
NEW	Canon HJ22 IRSE lens - no Box	$12,750
	Canon HJ22 IRSE lens - Used	$9,074
	Canon HJ11 IASE full servo lens - Used	$7,068
	Please inquire for pricing on brand new Canon 30-300 PL, 18-80, 70-200, UJ66, CJ18, CJ25, CJ20, CJ12, XJ95, XJ80, CN7 or any other Canon B4, PL or HD or UHD box lens model
	1 X HJ11 IASE full servo for US$3999	$6,881
	3 X ZA17 BERM, one that is almost new (Priced) , and x2 very well used lenses in good optical condition for around 4k each	$7,616
	2 X HA13 BERM excellent Condition lens	$6,146
	2 X HA13 BERM Fair condition lens	$5,410
	1 X HJ14 IRSE for a like new lens	$11,734
	1 X HA18 BERM (front element has a few dents, but image is fine. Front element can be replaced for only $750)	$5,410
	1 X HJ17 IRSE	$5,410
New	1 X Brand new (no box) Canon HJ22 IRSE lens	$12,015
	1 X Used Canon HJ22 IRSE lens	$9,074
	1 X Used Canon HJ21 in good condition	$6,868
New	HA18 BERD brand new	$15,704
New	Th13 brand new	$6,881
	HJ11 KLL-SC used	$8,351
New	A20 BERM brand new	$4,368
	Fujinon HA42x9.7BERD-G48, most expensive version with remote extender and ERS-42 remote, supporter, EPD / ERD / ERS remotes, original case, very good condition and Fujifilm checked 2/2019	$40,465
	Fujinon HA14x4.5BERD-S1 , new condition	$13,126
	Fujinon A22X7.8BDERM-M (Used) w/ratio & 2x extender	$2,698
	Canon XJ60x9.3B IESD-BB, ZDJ-A01, CR-30 (2), FFP-T61, Flex Cables (2), Canon SUP-NS2- Tan & Case	$40,500
	Canon HJ40x10B, FPD-400D, ZSD-300D, Sled, Case	$42,669
	Canon 72x	$34,467
	3 x Canon 86x	$53,820
	Canon XJ 100AF	$82,689
	2 x Canon HJ11x4.7BIAS with full servo controls	$10,016

	Camcorders / Servers/ Cards/Matt Boxes
1525	4 x Panasonic AJ-P2C216RG 16gig R Series Memory cards price is for all 4 or $250 each	$900
1527	2 x JVC GY-HD251E cameras each with the supplied Fujinon 16x5.5BRMU Lens – 240 and 259 Drum, 2 x Fujinon 0.82x Wide Angle adaptors WCV-82SC, 2 x Aluminium Road cases, 5 Batteries, 3 chargers, ProHD DR-HD100 recorder, Miller 2 stage tripod, 75mm Bowl, DS20 Head and JVC KA551U Baseplate, Miller 2 stage tripod, 100mm Bowl, DS25 Head and JVC KA551U Baseplate, About 60 Mini DV Tapes, About 60 DVDs of royalty free backgrounds. Other Accessories including 7” monitor and LED light. Prefer to sell as complete Kit but may split. Contact if interested.	TBA
	Varicam LT kit, inc- Cinema VariCam LT 4K S35 Digital Cinema Camera, HD colour VF, Eyepiece, Shoulder mount, Grip Module, PL & EF Mount Adapter, 3 x 256GB P2 Cards, AU-XPD1 P2 Memory Card Drive, Idx Vlock and original Anton Bauer QRC-GOLD Compact Universal Gold Mount Battery Mounting Plate. 550h operation, bought in march 2017 - Excellent Condition,	$24,500
	Brand New JVC GY-LS300 CHE KIT with Free lens EZ-M1240PRO Zoom Zuiko Pro 12-40mm F/2.8 and a super nice 5" monitor JVC DT-X53F F1920 x 1080 HDMI, 3G-SDI	$4,953
	Sony PMW-f55 Camera KIT, just 507hrs, DVF-EL100 Oled Viewfinder, AXS-R5 recorder, AXS-CR1 reader, 2x AXS-512S24, 2x AXS card adapter, Shoulder pad, IFU-WLM3 USB wireless LAN module & Manual - Excellent Condition	$22,172
1519	Sony PMW-EX1R XDCam HD Camcorder with Batteries, Cards, Remote, Case etc..	$2,200
1309	Awesome Canon C300 PL camcorder 4 sale - mint condition with stacks of accessories. See online for details	$5,500
1108	ARRI Alexa Classic's - 16:9, 120fps high-speed, 1080p, 2K ProRes - excellent Contrition with stacks of accessories. See online	$19,500
	6 x Sony HDC 1450, HDCU1500, HDXF100 Lemo4E, RCP920, HDVF20a	$14,295
	6 x Sony HDC 1500, HDCU1500,RCP920, HDVF20a	$15,434
	9 x Sony HDC 1500, HDCU1000,RCP920, HDVF20a	$13,795
	6 x Sony HDC 2400 HDCU2500, RCP1500, HDVF20a	$37,426
	7 x Sony HDC2500, HDCU2500,RCP1500,HDVF20a	$43,164
	3 x Sony HDC3300, HDCU3300, RCP1500, HDLA1500,HDVF700A	$33,967
	8 x Sony HDLA1500+HDVF700	$4,279
	3 x GV LDK 8000/70, CCU LDK 4502, OCP LDK4640, 2inchVF LDK 5302	$20,123
	3 x GV LDK 8000/60, CCU LDK 4502, OCP LDK4640, 2inchVF LDK 5302	$12,885
	2 x GV LDK 8000/6, CCU LDK 4502, OCP LDK4640, 2inchVF LDK 5302	$13,295
	2 x GV LDK 8000/20, CCU LDK 4506, OCP LDK4640, 5 inch VF LDK 5305	$15,234
	Trimix router 128x128HD	$36,926
	Concerto router Inc. Panels 96x96 HD	$13,795
	4 x Panasonic AK-UC3000GS 4K Cameras with Fibre connector with Flight case, 1 / 2 x Monocular viewfinder, 4 x AK-HVF100G LCD Studio Viewfinder in Flight cases, 4 x AK-UCU500ESJ Camera Controls -CCU,4 x AK-HRP1000G RCP, Some fibre cable also. Price is for entire kit.	$134,745
	XT2 -EVS Server 6 channel HD with single controller. Open config. Super Motion, Keyboard. Interface cables. Dual Power supplies , Very clean condition - ex studio use, 2 units available. Price for each	$51,613
	Panasonic Varicam HS KIT (around 500 hours use from memory and not a mark on it) INC- Panasonic AU-V23HS1 VariCam HS 2/3" 1080p Camera Module - B4 Mount, AU-VREC1 Recording Module, AU-VCFV1 Color Viewfinder, and AU-VSHL1 Shoulder Mount Module.	$70,447
1522	Arri MB20 Matte-Box (3 stage) includes 3x trays, top and bottom flags, 2x side flags, clip-on bracket, 3x clip-on donuts, 15mm or 19mm rods, hard case, new tray in box	3590
1515	Panasonic HPX 3100G P2 Camera, 4 x 64 gb and 3 x 32 gb cards and p2 card reader Hours meter reads 00280 x 10h P. on times 12387	7900

	Tripods, Lights, Monitors
	Sachtler Video 20 with Carbon Fibre Legs - Good condition, Pics available.	$5,897
	Sachtler 18SB head and CF tripod in bag - As New Condition	$6,217
1517	Miller Carbon Fiber Tripod and Miller Compass 15 lock bowl head – As new condition	$2,500
	Sachtler Video 20 CF Tripod	$5,274

	VTR's, Audio & Accessories
	Sony DVW-500P Digi Beta, Plays back perfectly however record has a few minor issues.	$500
	Sony DVW-500P Digi Beta Player/Recorder good condition with low hrs	$700
	Sony DSR-1800P with SDI out, perfect working order	Offers
	Sony BVH-2000 1 Inch Type C Video Tape Recorder - Excellent Condition	$3,500
1487	Sony UVW-1800 & UVW-1600 & Sony FXE 100 Edit Controller	$800
1443	Panasonic DVC Pro 50 AJ-D960 Edit VTR that has had very little use. (less than 500 tape hours)	$995
1490	Dedolight Felloni Tecpro 50 Degree Standard Bicolor LED Light, Tripod and Case - As New.. Price Neg	$1,200
1524	Samsung SMP-150P CRT monitor - pics available, good condition and works well	Offers
	Sony SRW-5500 SR VTR	Offers
	Sony SRW-5800 SR VTR	Offers
1523	Brand New - Avid Artist Mix Compact 8-Fader control surface	$900
1521	Red Rock Micro - One Man Crew. Motorised, multiple function, parabolic slider for dynamic interviews and motion time-lapse etc. as New	$2,200
1512	All aluminium underwater housing with manual camera controls. Suitable for either Sony F5 or F55 cameras - see pics and full inclusions online	$17,500

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

2019 June

ID : 1529

Description

We Make it Safe for both Buyer and Seller

Used Equipment

Seller Login

Featured New Ads

Featured Used Ads

New Equipment

Used Equipment

Newsletter

Follow Us

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

128 Queries Logged 103.6 ms

47 duplicate found!

53 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: