Joomla! Debug Console

Profile Information

Time

Memory

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

Time: 52.3 ms / 52.3 ms Memory: 5.643 MB / 6.26 MB Application: afterInitialise

Time: 25.8 ms / 78.1 ms Memory: 2.639 MB / 8.89 MB Application: afterRoute

Time: 19.4 ms / 97.4 ms Memory: 1.919 MB / 10.81 MB Application: afterDispatch

Time: 32.4 ms / 129.8 ms Memory: 3.190 MB / 14.00 MB Application: beforeRenderModule mod_roknavmenu ()

Time: 20.7 ms / 150.5 ms Memory: 1.666 MB / 15.67 MB Application: afterRenderModule mod_roknavmenu ()

Time: 6.3 ms / 156.8 ms Memory: 0.027 MB / 15.70 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 2.5 ms / 159.3 ms Memory: 0.085 MB / 15.78 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.1 ms / 159.4 ms Memory: 0.000 MB / 15.78 MB Application: beforeRenderModule mod_custom (Follow Us)

Time: 0.8 ms / 160.2 ms Memory: 0.010 MB / 15.79 MB Application: afterRenderModule mod_custom (Follow Us)

Time: 0.1 ms / 160.3 ms Memory: 0.005 MB / 15.79 MB Application: beforeRenderModule mod_acymailing (Newsletter)

Time: 10.5 ms / 170.8 ms Memory: 1.241 MB / 17.03 MB Application: afterRenderModule mod_acymailing (Newsletter)

Time: 0.1 ms / 170.9 ms Memory: 0.000 MB / 17.00 MB Application: beforeRenderModule mod_menu ( Used Equipment)

Time: 4.5 ms / 175.4 ms Memory: 0.249 MB / 17.25 MB Application: afterRenderModule mod_menu ( Used Equipment)

Time: 0.1 ms / 175.5 ms Memory: 0.000 MB / 17.25 MB Application: beforeRenderModule mod_menu (New Equipment)

Time: 2.5 ms / 178.0 ms Memory: 0.116 MB / 17.36 MB Application: afterRenderModule mod_menu (New Equipment)

Time: 0.1 ms / 178.1 ms Memory: 0.001 MB / 17.37 MB Application: beforeRenderModule mod_cblogin (Seller Login)

Time: 66.4 ms / 244.5 ms Memory: 11.736 MB / 29.10 MB Application: afterRenderModule mod_cblogin (Seller Login)

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

Time: 7.6 ms / 252.2 ms Memory: 0.781 MB / 29.86 MB Application: afterRenderModule mod_adsnew_ads (Featured New Ads)

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

Time: 4.3 ms / 256.6 ms Memory: 0.267 MB / 30.08 MB Application: afterRenderModule mod_adsused_ads (Featured Used Ads)

Time: 0.1 ms / 256.7 ms Memory: 0.000 MB / 30.02 MB Application: beforeRenderModule mod_adsused_menu (Used Equipment)

Time: 14.5 ms / 271.2 ms Memory: 0.881 MB / 30.90 MB Application: afterRenderModule mod_adsused_menu (Used Equipment)

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

Time: 3.5 ms / 274.9 ms Memory: 0.202 MB / 30.97 MB Application: afterRenderModule mod_adsnew_search (New Equipment Search)

Time: 0.1 ms / 275.0 ms Memory: 0.000 MB / 30.87 MB Application: beforeRenderModule mod_custom (Tagline)

Time: 0.3 ms / 275.3 ms Memory: 0.007 MB / 30.88 MB Application: afterRenderModule mod_custom (Tagline)

Time: 5.0 ms / 280.3 ms Memory: 0.251 MB / 31.13 MB Application: afterRender

Database queries total: 29.3 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_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_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	fly9i_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

EXPLAIN not possible on query: UPDATE `fly9i_extensions` SET `params` = '{\"mediaversion\":\"9917355fb75c7bf439f10c68e3224f07\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.0 ms
Updating	0.1 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.2 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/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.63 ms After last query: 9.05 ms Query memory: 0.028 MB Memory before query: 8.674 MB Rows returned: 3

Duplicate queries: #27

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.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
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.1 ms
Reset for next command	0.0 ms

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: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/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.20 ms After last query: 0.56 ms Query memory: 0.044 MB Memory before query: 8.733 MB Rows returned: 1

Duplicate queries: #23 #64

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.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_adsused/lib/core.php:94

JROOT/components/com_adsused/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/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.51 ms After last query: 3.50 ms Query memory: 0.015 MB Memory before query: 8.918 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

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.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.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/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.15 ms After last query: 0.43 ms Query memory: 0.013 MB Memory before query: 8.944 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

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/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: 8.87 ms Query memory: 0.037 MB Memory before query: 10.097 MB Rows returned: 1

Duplicate queries: #20 #64

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.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_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.14 ms After last query: 0.79 ms Query memory: 0.020 MB Memory before query: 10.177 MB Rows returned: 1

Duplicate queries: #56 #65 #101

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

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_adsused/helpers/usergroups.php:19

JROOT/components/com_adsused/lib/tpermissions.php:21

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

JROOT/components/com_adsused/views/question/view.html.php:32

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

JROOT/components/com_adsused/controller.php:149

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.08 ms Query memory: 0.025 MB Memory before query: 10.198 MB Rows returned: 27

Duplicate queries: #66

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

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_adsused/models/category.php:69

JROOT/components/com_adsused/lib/tpermissions.php:26

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

JROOT/components/com_adsused/views/question/view.html.php:32

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

JROOT/components/com_adsused/controller.php:149

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: 1.14 ms After last query: 0.66 ms Query memory: 0.031 MB Memory before query: 10.257 MB Rows returned: 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_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  
  WHERE a.id = 1345 
  AND adcat.catid IN (33,10,25,26,28,5,6,7,8,34,35,30,18,19,29,37,14,15,17,12,13,21,20,31,3,24)

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

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.1 ms
Optimizing	0.0 ms
Statistics	0.2 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.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.2 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

JROOT/components/com_adsused/views/question/view.html.php:32

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

JROOT/components/com_adsused/controller.php:149

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.25 ms After last query: 20.80 ms Query memory: 0.025 MB Memory before query: 13.085 MB Rows returned: 3

Duplicate queries: #19

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.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/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.66 ms After last query: 13.75 ms Query memory: 0.024 MB Memory before query: 13.878 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 <= '2024-04-20 11:35:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 11:35:13') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 471 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.0 ms
init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.1 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.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.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.23 ms After last query: 9.56 ms Query memory: 0.024 MB Memory before query: 14.781 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 = 471 
  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.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: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: 0.12 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 14.803 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	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/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.21 ms After last query: 5.59 ms Query memory: 0.056 MB Memory before query: 15.459 MB Rows returned: 1

Duplicate queries: #55 #100

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.27 ms After last query: 23.07 ms Query memory: 0.025 MB Memory before query: 16.630 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.20 ms After last query: 2.82 ms Query memory: 0.022 MB Memory before query: 17.108 MB Rows returned: 1

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.15 ms After last query: 1.41 ms Query memory: 0.026 MB Memory before query: 17.040 MB Rows returned: 0

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 23

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.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/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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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: 0.31 ms Query memory: 0.025 MB Memory before query: 17.067 MB Rows returned: 0

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 1

Explain

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

Profile

Status	Duration
Starting	0.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_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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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: 0.22 ms Query memory: 0.025 MB Memory before query: 17.093 MB Rows returned: 1

Duplicate queries: #85

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 5

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

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_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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.10 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 17.119 MB Rows returned: 1

Duplicate queries: #86

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 6

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

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_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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.10 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 17.145 MB Rows returned: 1

Duplicate queries: #87

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

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_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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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: 0.23 ms Query memory: 0.025 MB Memory before query: 17.171 MB Rows returned: 0

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 22

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.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/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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.10 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 17.197 MB Rows returned: 1

Duplicate queries: #88

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 8

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

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_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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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: 0.19 ms Query memory: 0.025 MB Memory before query: 17.223 MB Rows returned: 0

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 9

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.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/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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.13 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 17.249 MB Rows returned: 1

Duplicate queries: #81

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 10

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

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_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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.15 ms After last query: 1.81 ms Query memory: 0.025 MB Memory before query: 17.283 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsnew_categories 
  WHERE id = 18

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsnew_categories	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/components/com_adsnew/router.php:20

JROOT/components/com_adsnew/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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.13 ms After last query: 0.25 ms Query memory: 0.025 MB Memory before query: 17.309 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsnew_categories 
  WHERE id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsnew_categories	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/components/com_adsnew/router.php:20

JROOT/components/com_adsnew/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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.12 ms After last query: 0.24 ms Query memory: 0.025 MB Memory before query: 17.335 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsnew_categories 
  WHERE id = 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsnew_categories	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/components/com_adsnew/router.php:20

JROOT/components/com_adsnew/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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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: 0.24 ms Query memory: 0.025 MB Memory before query: 17.361 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsnew_categories 
  WHERE id = 29

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsnew_categories	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/components/com_adsnew/router.php:20

JROOT/components/com_adsnew/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/modules/mod_menu/helper.php:120

JROOT/modules/mod_menu/mod_menu.php:15

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.25 ms After last query: 17.72 ms Query memory: 0.036 MB Memory before query: 19.976 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

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: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/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/modules/mod_cblogin/mod_cblogin.php:17

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: 1.17 ms After last query: 13.22 ms Query memory: 0.033 MB Memory before query: 22.161 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.4 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Filling schema table	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
checking permissions	0.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/libraries/CBLib/CB/Legacy/CBuser.php:194

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:68

JROOT/modules/mod_cblogin/mod_cblogin.php:33

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.19 ms After last query: 3.17 ms Query memory: 0.038 MB Memory before query: 22.625 MB Rows returned: 30

SELECT f.* 
  FROM fly9i_comprofiler_fields f
 
  INNER JOIN fly9i_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1
 
  ORDER BY 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	NO INDEX KEY COULD BE USED	NULL	NULL	36	Using where; Using temporary; Using filesort
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.f.tabid	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/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/CBuser.php:332

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1075

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1125

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:640

JROOT/modules/mod_cblogin/mod_cblogin.php:93

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.18 ms After last query: 0.99 ms Query memory: 0.031 MB Memory before query: 22.854 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/libraries/CBLib/CB/Legacy/cbTabs.php:1004

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1075

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1125

JROOT/libraries/CBLib/CB/Legacy/CBuser.php:640

JROOT/modules/mod_cblogin/mod_cblogin.php:93

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.24 ms After last query: 24.56 ms Query memory: 0.021 MB Memory before query: 28.681 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.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/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:345

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

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

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

JROOT/modules/mod_cblogin/mod_cblogin.php:157

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.22 ms After last query: 4.12 ms Query memory: 0.021 MB Memory before query: 29.167 MB Rows returned: 1

SELECT `id`
 
  FROM `fly9i_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
 
  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 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:222

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

JROOT/modules/mod_cblogin/tmpl/bootstrap.php:15

JROOT/modules/mod_cblogin/mod_cblogin.php:178

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.13 ms After last query: 0.47 ms Query memory: 0.021 MB Memory before query: 29.188 MB Rows returned: 1

SELECT `id`
 
  FROM `fly9i_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
 
  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 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:222

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

JROOT/modules/mod_cblogin/tmpl/bootstrap.php:151

JROOT/modules/mod_cblogin/mod_cblogin.php:178

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.13 ms After last query: 0.33 ms Query memory: 0.021 MB Memory before query: 29.209 MB Rows returned: 1

SELECT `id`
 
  FROM `fly9i_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
 
  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 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:222

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

JROOT/modules/mod_cblogin/tmpl/bootstrap.php:165

JROOT/modules/mod_cblogin/mod_cblogin.php:178

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.19 ms After last query: 4.97 ms Query memory: 0.039 MB Memory before query: 29.666 MB Rows returned: 1

Duplicate queries: #31 #100

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/administrator/components/com_adsnew/models/configuration.php:27

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:80

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.13 ms After last query: 0.13 ms Query memory: 0.020 MB Memory before query: 29.704 MB Rows returned: 1

Duplicate queries: #24 #65 #101

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

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/helpers/usergroups.php:19

JROOT/components/com_adsnew/lib/tpermissions.php:21

JROOT/administrator/components/com_adsnew/models/content.php:452

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:84

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.12 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 29.725 MB Rows returned: 22

Duplicate queries: #102

SELECT c.* 
  FROM fly9i_adsnew_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	22	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.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_adsnew/models/category.php:69

JROOT/components/com_adsnew/lib/tpermissions.php:26

JROOT/administrator/components/com_adsnew/models/content.php:452

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:84

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: 0.28 ms Query memory: 0.025 MB Memory before query: 29.744 MB Rows returned: 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  
  WHERE 1  
  AND  c.published = 1 
  and a.published = 1 
  GROUP BY a.id 
  ORDER BY a.ad_featureditem DESC, a.id DESC  
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	PRIMARY	PRIMARY	4	NULL	323	Using where; Using temporary; Using filesort
1	SIMPLE	adcat	ref	PRIMARY	PRIMARY	4	broadcas_2015.a.id	1	Using index
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.adcat.catid	1	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.c.parent	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.a.userid	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.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_adsnew/models/content.php:523

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:84

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.15 ms After last query: 0.78 ms Query memory: 0.020 MB Memory before query: 29.810 MB Rows returned: 0

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsnew&view=details%' 
  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

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/route.php:257

JROOT/components/com_adsnew/lib/route.php:92

JROOT/modules/mod_adsnew_ads/tmpl/vertical.php:21

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:128

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: 0.06 ms Query memory: 0.020 MB Memory before query: 29.830 MB Rows returned: 0

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsnew&view=list%' 
  AND link LIKE '%catid=24%' 
  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

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/route.php:281

JROOT/components/com_adsnew/lib/route.php:92

JROOT/modules/mod_adsnew_ads/tmpl/vertical.php:21

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:128

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: 0.05 ms Query memory: 0.020 MB Memory before query: 29.849 MB Rows returned: 1

SELECT id 
  FROM fly9i_menu 
  WHERE link = 'index.php?option=com_adsnew&view=front' 
  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

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/route.php:321

JROOT/components/com_adsnew/lib/route.php:117

JROOT/modules/mod_adsnew_ads/tmpl/vertical.php:21

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:128

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.10 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 29.873 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsnew_categories 
  WHERE id = 24

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsnew_categories	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/components/com_adsnew/router.php:20

JROOT/components/com_adsnew/router.php:76

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_adsnew/lib/route.php:176

JROOT/modules/mod_adsnew_ads/tmpl/vertical.php:21

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:128

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.10 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 29.899 MB Rows returned: 1

SELECT ad_headline 
  FROM fly9i_adsnew_ads 
  WHERE id = 471

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsnew_ads	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/components/com_adsnew/router.php:31

JROOT/components/com_adsnew/router.php:77

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_adsnew/lib/route.php:176

JROOT/modules/mod_adsnew_ads/tmpl/vertical.php:21

JROOT/modules/mod_adsnew_ads/mod_adsnew_ads.php:128

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.22 ms After last query: 1.93 ms Query memory: 0.039 MB Memory before query: 29.873 MB Rows returned: 1

Duplicate queries: #20 #23

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.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_adsused/models/configuration.php:27

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:80

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.13 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 29.916 MB Rows returned: 1

Duplicate queries: #24 #56 #101

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

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_adsused/helpers/usergroups.php:19

JROOT/components/com_adsused/lib/tpermissions.php:21

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

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:84

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.12 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 29.937 MB Rows returned: 27

Duplicate queries: #25

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

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_adsused/models/category.php:69

JROOT/components/com_adsused/lib/tpermissions.php:26

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

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:84

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: 0.28 ms Query memory: 0.039 MB Memory before query: 29.956 MB Rows returned: 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  
  WHERE 1  
  AND  c.published = 1 
  and a.published = 1 
  GROUP BY a.id 
  ORDER BY a.ad_featureditem DESC, a.id DESC  
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	adcat	index	PRIMARY	PRIMARY	8	NULL	1302	Using index; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.adcat.catid	1	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.c.parent	1	Using where
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.adcat.adid	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.a.userid	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.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_adsused/models/content.php:555

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:84

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.14 ms After last query: 0.45 ms Query memory: 0.021 MB Memory before query: 30.028 MB Rows returned: 0

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsused&view=details%' 
  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

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_adsused/lib/route.php:257

JROOT/components/com_adsused/lib/route.php:92

JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133

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.10 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 30.047 MB Rows returned: 0

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsused&view=list%' 
  AND link LIKE '%catid=13%' 
  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

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_adsused/lib/route.php:281

JROOT/components/com_adsused/lib/route.php:92

JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133

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: 0.04 ms Query memory: 0.020 MB Memory before query: 30.067 MB Rows returned: 1

SELECT id 
  FROM fly9i_menu 
  WHERE link = 'index.php?option=com_adsused&view=front' 
  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

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_adsused/lib/route.php:321

JROOT/components/com_adsused/lib/route.php:117

JROOT/modules/mod_adsused_ads/tmpl/horizontal.php:29

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133

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.10 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 30.091 MB Rows returned: 1

Duplicate queries: #99

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 13

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

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_adsused/router.php:20

JROOT/components/com_adsused/router.php:76

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/modules/mod_adsused_ads/tmpl/horizontal.php:29

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133

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.10 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 30.117 MB Rows returned: 1

SELECT ad_headline 
  FROM fly9i_adsused_ads 
  WHERE id = 1799

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_adsused_ads	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/components/com_adsused/router.php:31

JROOT/components/com_adsused/router.php:77

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/modules/mod_adsused_ads/tmpl/horizontal.php:29

JROOT/modules/mod_adsused_ads/mod_adsused_ads.php:133

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.16 ms After last query: 1.77 ms Query memory: 0.023 MB Memory before query: 30.072 MB Rows returned: 27

SELECT c.* 
  FROM fly9i_adsused_categories as c 
  WHERE  c.published = 1    
  ORDER BY c.parent,c.ordering,c.id

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

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_adsused/models/category.php:233

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:64

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.26 ms After last query: 0.13 ms Query memory: 0.040 MB Memory before query: 30.151 MB Rows returned: 954

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ac	index	PRIMARY	PRIMARY	8	NULL	1302	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	broadcas_2015.ac.adid	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.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_adsused/models/category.php:242

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:64

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: 2.21 ms Query memory: 0.023 MB Memory before query: 30.236 MB Rows returned: 27

SELECT c.* 
  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

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_adsused/models/category.php:69

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:76

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.14 ms After last query: 0.55 ms Query memory: 0.019 MB Memory before query: 30.321 MB Rows returned: 1

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsused&view=front%' 
  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

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_adsused/lib/route.php:210

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

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:100

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.13 ms After last query: 0.19 ms Query memory: 0.019 MB Memory before query: 30.340 MB Rows returned: 1

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsused&view=edit%' 
  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

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_adsused/lib/route.php:210

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

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:101

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.12 ms After last query: 0.22 ms Query memory: 0.019 MB Memory before query: 30.358 MB Rows returned: 2

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsused&view=rules%' 
  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

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_adsused/lib/route.php:210

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

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:102

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: 0.19 ms Query memory: 0.019 MB Memory before query: 30.377 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

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_adsused/lib/route.php:210

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

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:103

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.14 ms After last query: 0.41 ms Query memory: 0.028 MB Memory before query: 30.410 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 33

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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: 0.19 ms Query memory: 0.028 MB Memory before query: 30.437 MB Rows returned: 1

Duplicate queries: #42

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 10

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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: 0.19 ms Query memory: 0.028 MB Memory before query: 30.464 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 25

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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: 0.20 ms Query memory: 0.027 MB Memory before query: 30.490 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 26

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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: 0.17 ms Query memory: 0.027 MB Memory before query: 30.516 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 28

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.10 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 30.543 MB Rows returned: 1

Duplicate queries: #36

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 5

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.09 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 30.569 MB Rows returned: 1

Duplicate queries: #37

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 6

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.09 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 30.596 MB Rows returned: 1

Duplicate queries: #38

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.10 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 30.622 MB Rows returned: 1

Duplicate queries: #40

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 8

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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: 0.20 ms Query memory: 0.028 MB Memory before query: 30.649 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 34

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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: 0.25 ms Query memory: 0.027 MB Memory before query: 30.675 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 35

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.12 ms After last query: 0.20 ms Query memory: 0.027 MB Memory before query: 30.702 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 30

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.10 ms After last query: 0.19 ms Query memory: 0.027 MB Memory before query: 30.728 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 16

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.68 ms After last query: 0.16 ms Query memory: 0.028 MB Memory before query: 30.756 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 29

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

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.2 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:46

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.51 ms After last query: 0.21 ms Query memory: 0.028 MB Memory before query: 30.783 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 37

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

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:46

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.48 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 30.811 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 14

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

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:46

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.43 ms After last query: 0.23 ms Query memory: 0.028 MB Memory before query: 30.838 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 15

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

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:46

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.39 ms After last query: 0.20 ms Query memory: 0.028 MB Memory before query: 30.865 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 17

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

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.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/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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:46

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.36 ms After last query: 0.17 ms Query memory: 0.028 MB Memory before query: 30.893 MB Rows returned: 1

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 12

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

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.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/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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:46

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.12 ms After last query: 0.16 ms Query memory: 0.028 MB Memory before query: 30.920 MB Rows returned: 1

Duplicate queries: #71

SELECT name 
  FROM fly9i_adsused_categories 
  WHERE id = 13

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

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_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/modules/mod_adsused_menu/mod_adsused_menu.php:34

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:46

JROOT/modules/mod_adsused_menu/tmpl/default.php:48

JROOT/modules/mod_adsused_menu/mod_adsused_menu.php:105

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.20 ms After last query: 1.96 ms Query memory: 0.039 MB Memory before query: 30.817 MB Rows returned: 1

Duplicate queries: #31 #55

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/administrator/components/com_adsnew/models/configuration.php:27

JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:66

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.13 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 30.855 MB Rows returned: 1

Duplicate queries: #24 #56 #65

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

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/helpers/usergroups.php:19

JROOT/components/com_adsnew/lib/tpermissions.php:21

JROOT/administrator/components/com_adsnew/models/category.php:220

JROOT/administrator/components/com_adsnew/models/category.php:194

JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:75

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.12 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 30.877 MB Rows returned: 22

Duplicate queries: #57

SELECT c.* 
  FROM fly9i_adsnew_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	22	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.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_adsnew/models/category.php:69

JROOT/components/com_adsnew/lib/tpermissions.php:26

JROOT/administrator/components/com_adsnew/models/category.php:220

JROOT/administrator/components/com_adsnew/models/category.php:194

JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:75

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: 0.19 ms Query memory: 0.023 MB Memory before query: 30.897 MB Rows returned: 22

SELECT c.* 
  FROM fly9i_adsnew_categories as c 
  WHERE  c.published = 1   
  AND c.id IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)   
  ORDER BY c.parent,c.ordering,c.id

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	22	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.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_adsnew/models/category.php:233

JROOT/administrator/components/com_adsnew/models/category.php:194

JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:75

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.13 ms After last query: 0.46 ms Query memory: 0.020 MB Memory before query: 30.992 MB Rows returned: 0

SELECT id,language 
  FROM fly9i_menu 
  WHERE link LIKE '%option=com_adsnew&view=result%' 
  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

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/route.php:210

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

JROOT/modules/mod_adsnew_search/tmpl/default.php:30

JROOT/modules/mod_adsnew_search/mod_adsnew_search.php:88

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.95 ms After last query: 1.38 ms Query memory: 0.031 MB Memory before query: 30.964 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `fly9i_template_styles`

Explain

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

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
closing tables	0.0 ms
Opening tables	0.4 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Filling schema table	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
checking permissions	0.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/administrator/components/com_templates/tables/style.php:30

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

JROOT/plugins/system/gantry/gantry.php:194

JROOT/plugins/system/gantry/gantry.php:165

JROOT/plugins/system/gantry/gantry.php:234

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

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

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

JROOT/libraries/joomla/document/html/renderer/head.php:64

JROOT/libraries/joomla/document/html/renderer/head.php:37

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.13 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 31.008 MB Rows returned: 1

SELECT *

  FROM fly9i_template_styles

  WHERE `id` = '10'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fly9i_template_styles	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/table/table.php:705

JROOT/plugins/system/gantry/gantry.php:168

JROOT/plugins/system/gantry/gantry.php:234

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

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

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

JROOT/libraries/joomla/document/html/renderer/head.php:64

JROOT/libraries/joomla/document/html/renderer/head.php:37

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.93 ms After last query: 3.28 ms Query memory: 0.003 MB Memory before query: 31.124 MB

UPDATE `fly9i_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713612913;s:18:\"session.timer.last\";i:1713612913;s:17:\"session.timer.now\";i:1713612913;s:24:\"session.client.forwarded\";s:14:\"18.118.210.213\";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` = '1713612913'

  WHERE `session_id` = 'htqqbt9viobt8nf1aiq2m1crf5'

Explain

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:1713612913;s:18:\"session.timer.last\";i:1713612913;s:17:\"session.timer.now\";i:1713612913;s:24:\"session.client.forwarded\";s:14:\"18.118.210.213\";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` = '1713612913' WHERE `session_id` = 'htqqbt9viobt8nf1aiq2m1crf5'

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.1 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]

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

30 × SELECT name 
  FROM fly9i_adsused_categories

9 × SELECT id,language 
  FROM fly9i_menu

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

5 × SELECT name 
  FROM fly9i_adsnew_categories

4 × SELECT group_id 
  FROM fly9i_user_usergroup_map

4 × SELECT c.* 
  FROM fly9i_adsused_categories as c

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

3 × SELECT * 
  FROM fly9i_adsnew_confi

3 × SELECT c.* 
  FROM fly9i_adsnew_categories as c

3 × SELECT * 
  FROM fly9i_adsused_confi

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

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

1 × SELECT * 
  FROM fly9i_template_styles

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 `params`  
  FROM `fly9i_comprofiler_plugin`

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

1 × SELECT ad_headline 
  FROM fly9i_adsused_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 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_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 *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `fly9i_comprofiler_plugin`

1 × SELECT template 
  FROM fly9i_template_styles

1 × SELECT * 
  FROM `fly9i_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `fly9i_admintools_storage`

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 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 * 
  FROM fly9i_languages
```

1 × SELECT `data` 
  FROM `fly9i_session`

1 × SELECT * 
  FROM fly9i_acymailing_confi

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

1 × SELECT * 
  FROM fly9i_acymailing_list

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:1713612913;s:18:\"session.timer.last\";i:1713612913;s:17:\"session.timer.now\";i:1713612913;s:24:\"session.client.forwarded\";s:14:\"18.118.210.213\";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` = '1713612913'

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

1 × SHOW FULL COLUMNS 
  FROM `fly9i_content

1 × INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('htqqbt9viobt8nf1aiq2m1crf5', 0, '1713612913'

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM fly9i_acymailing_actio

```
1 × DELETE  
  FROM `fly9i_session`
```

Description :	Zeiss MK2 Super Speeds, 18mm, 25mm, 35mm, 50mm, 85mm (all T1.3)
Manufacturer :	Zeiss
Model :	MK2 Super Speeds
*First & Last Name :**
*Your Phone Number :**
*Your E-Mail :**
Ask A Question :

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

Ask A Question

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

107 Queries Logged 29.3 ms

28 duplicate found!

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: