Joomla! Debug Console

Session

joomla ⇒ TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjE6e3M6OToiX19kZWZhdWx0IjtPOjg6InN0ZENsYXNzIjozOntzOjc6InNlc3Npb24iO086ODoic3RkQ2xhc3MiOjM6e3M6NzoiY291bnRlciI7aToxO3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTYxMTIwOTQ0MDtzOjQ6Imxhc3QiO2k6MTYxMTIwOTQ0MDtzOjM6Im5vdyI7aToxNjExMjA5NDQwO31zOjU6InRva2VuIjtzOjMyOiIzYjA1YTM1Y2U5N2I5NTA3MzE0ZTQxNDdkMTVjM2ViNSI7fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6MTp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9fXM6NDoidXNlciI7Tzo1OiJKVXNlciI6MjU6e3M6OToiACoAaXNSb290IjtOO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjU6ImJsb2NrIjtOO3M6OToic2VuZEVtYWlsIjtpOjA7czoxMjoicmVnaXN0ZXJEYXRlIjtOO3M6MTM6Imxhc3R2aXNpdERhdGUiO047czoxMDoiYWN0aXZhdGlvbiI7TjtzOjY6InBhcmFtcyI7TjtzOjY6Imdyb3VwcyI7YToxOntpOjA7czoxOiIxIjt9czo1OiJndWVzdCI7aToxO3M6MTM6Imxhc3RSZXNldFRpbWUiO047czoxMDoicmVzZXRDb3VudCI7TjtzOjEyOiJyZXF1aXJlUmVzZXQiO047czoxMDoiACoAX3BhcmFtcyI7TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO047czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fX19fQ==

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.594 MB / 0.59 MB Application: afterLoad

Time: 48.9 ms / 48.9 ms Memory: 4.360 MB / 4.95 MB Application: afterInitialise

Time: 19.3 ms / 68.2 ms Memory: 1.651 MB / 6.60 MB Application: afterRoute

Time: 88.4 ms / 156.7 ms Memory: 3.444 MB / 10.05 MB Application: afterDispatch

Time: 20.4 ms / 177.0 ms Memory: 1.136 MB / 11.18 MB Application: beforeRenderModule mod_login (Login Form)

Time: 6.4 ms / 183.4 ms Memory: 0.374 MB / 11.56 MB Application: afterRenderModule mod_login (Login Form)

Time: 0.1 ms / 183.6 ms Memory: 0.000 MB / 11.56 MB Application: beforeRenderModule mod_menu (Legal Menu)

Time: 3.2 ms / 186.8 ms Memory: 0.062 MB / 11.62 MB Application: afterRenderModule mod_menu (Legal Menu)

Time: 0.1 ms / 186.9 ms Memory: 0.000 MB / 11.61 MB Application: beforeRenderModule mod_k2_tools_extended (Restaurant lunch list)

Time: 98.8 ms / 285.7 ms Memory: 0.649 MB / 12.26 MB Application: afterRenderModule mod_k2_tools_extended (Restaurant lunch list)

Time: 0.1 ms / 285.8 ms Memory: 0.020 MB / 12.28 MB Application: beforeRenderModule mod_ijoomla_adagency_zone (Premium Rt Col Advertisement)

Time: 12.6 ms / 298.4 ms Memory: 1.124 MB / 13.40 MB Application: afterRenderModule mod_ijoomla_adagency_zone (Premium Rt Col Advertisement)

Time: 0.1 ms / 298.5 ms Memory: 0.000 MB / 13.40 MB Application: beforeRenderModule mod_custom (Lunch By Location)

Time: 1.9 ms / 300.4 ms Memory: 0.009 MB / 13.41 MB Application: afterRenderModule mod_custom (Lunch By Location)

Time: 0.1 ms / 300.5 ms Memory: 0.000 MB / 13.40 MB Application: beforeRenderModule mod_ijoomla_adagency_zone (Rt Col Advertisement)

Time: 2.3 ms / 302.8 ms Memory: 0.147 MB / 13.55 MB Application: afterRenderModule mod_ijoomla_adagency_zone (Rt Col Advertisement)

Time: 0.1 ms / 302.9 ms Memory: 0.000 MB / 13.55 MB Application: beforeRenderModule mod_k2_comments (Latest Comments)

Time: 16.6 ms / 319.6 ms Memory: 0.918 MB / 14.46 MB Application: afterRenderModule mod_k2_comments (Latest Comments)

Time: 0.1 ms / 319.6 ms Memory: 0.000 MB / 14.43 MB Application: beforeRenderModule mod_ijoomla_adagency_zone (Mast Teaser)

Time: 2.5 ms / 322.1 ms Memory: 0.147 MB / 14.57 MB Application: afterRenderModule mod_ijoomla_adagency_zone (Mast Teaser)

Time: 0.1 ms / 322.2 ms Memory: 0.000 MB / 14.57 MB Application: beforeRenderModule mod_acymailing (Subscribe!)

Time: 7.1 ms / 329.3 ms Memory: 0.721 MB / 15.29 MB Application: afterRenderModule mod_acymailing (Subscribe!)

Time: 0.1 ms / 329.4 ms Memory: 0.000 MB / 15.23 MB Application: beforeRenderModule mod_weather_gk4 (Weather)

Time: 5.9 ms / 335.2 ms Memory: 0.326 MB / 15.56 MB Application: afterRenderModule mod_weather_gk4 (Weather)

Time: 0.3 ms / 335.5 ms Memory: 0.000 MB / 15.50 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 3.0 ms / 338.5 ms Memory: 0.026 MB / 15.53 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.1 ms / 338.6 ms Memory: 0.000 MB / 15.53 MB Application: beforeRenderModule mod_search (Search Over 240 Restaurants, 1700 pages)

Time: 2.9 ms / 341.5 ms Memory: 0.034 MB / 15.56 MB Application: afterRenderModule mod_search (Search Over 240 Restaurants, 1700 pages)

Time: 0.2 ms / 341.7 ms Memory: 0.000 MB / 15.55 MB Application: beforeRenderModule mod_custom (Follow us on)

Time: 0.5 ms / 342.1 ms Memory: 0.007 MB / 15.56 MB Application: afterRenderModule mod_custom (Follow us on)

Time: 0.2 ms / 342.3 ms Memory: 0.006 MB / 15.56 MB Application: beforeRenderModule mod_highlighter_gk5 (Restaurant Highlighter)

Time: 70.8 ms / 413.1 ms Memory: 0.983 MB / 16.55 MB Application: afterRenderModule mod_highlighter_gk5 (Restaurant Highlighter)

Time: 0.6 ms / 413.7 ms Memory: 0.000 MB / 15.96 MB Application: beforeRenderModule mod_news_pro_gk4 (News For Your Eatification)

Time: 53.5 ms / 467.2 ms Memory: 1.203 MB / 17.17 MB Application: afterRenderModule mod_news_pro_gk4 (News For Your Eatification)

Time: 0.3 ms / 467.6 ms Memory: 0.000 MB / 17.07 MB Application: beforeRenderModule mod_ijoomla_adagency_zone (Banner Ad )

Time: 4.1 ms / 471.7 ms Memory: 0.148 MB / 17.22 MB Application: afterRenderModule mod_ijoomla_adagency_zone (Banner Ad )

Time: 132.9 ms / 604.6 ms Memory: 0.272 MB / 17.49 MB Application: afterRender

Database queries total: 150.8 ms

Memory Usage

Database Queries

66 Queries Logged 150.8 ms

32 duplicate found!

8 duplicates: #24 #25 #32 #33 #42 #43 #58 #59

4 duplicates: #26 #34 #44 #60

4 duplicates: #27 #35 #45 #61

2 duplicates: #28 #31

8 duplicates: #29 #30 #37 #38 #47 #48 #63 #64

2 duplicates: #36 #39

2 duplicates: #46 #49

2 duplicates: #62 #65

Query Time: 0.20 ms Query memory: 0.015 MB Memory before query: 2.280 MB Rows returned: 0

SELECT `data`

  FROM `j3_session`

  WHERE `session_id` = '93cscdc6u00d1ka7d7cn4a8di1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	NULL

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:42

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

Query Time: 0.26 ms After last query: 1.75 ms Query memory: 0.012 MB Memory before query: 2.426 MB Rows returned: 0

SELECT `session_id`

  FROM `j3_session`

  WHERE `session_id` = '93cscdc6u00d1ka7d7cn4a8di1' 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:42

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

Query Time: 0.25 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 2.439 MB

INSERT INTO `j3_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('93cscdc6u00d1ka7d7cn4a8di1', 0, '1611209440')

Explain

EXPLAIN not possible on query: INSERT INTO `j3_session` (`session_id`, `client_id`, `time`) VALUES ('93cscdc6u00d1ka7d7cn4a8di1', 0, '1611209440')

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
update	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:42

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

Query Time: 0.39 ms After last query: 3.62 ms Query memory: 0.014 MB Memory before query: 2.800 MB Rows returned: 1

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

  FROM j3_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	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:570

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

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

JROOT/index.php:45

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

Query Time: 0.28 ms After last query: 1.36 ms Query memory: 0.014 MB Memory before query: 2.904 MB Rows returned: 1

SELECT b.id

  FROM j3_usergroups AS a

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

  WHERE a.id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.22 ms After last query: 0.68 ms Query memory: 0.013 MB Memory before query: 2.967 MB Rows returned: 3

SELECT id, rules

  FROM `j3_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 1.03 ms After last query: 0.19 ms Query memory: 0.015 MB Memory before query: 2.985 MB Rows returned: 80

SELECT folder AS type, element AS name, params

  FROM j3_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_extensions	NULL	ref	extension	extension	62	const	120	2.22	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.7 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.33 ms After last query: 0.61 ms Query memory: 0.014 MB Memory before query: 3.086 MB Rows returned: 1

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

  FROM j3_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	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:628

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

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

JROOT/index.php:45

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

Query Time: 0.46 ms After last query: 15.87 ms Query memory: 0.028 MB Memory before query: 4.562 MB Rows returned: 1

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

  FROM j3_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	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/plugins/system/k2/k2.php:435

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

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

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

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

JROOT/index.php:45

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

Query Time: 1.00 ms After last query: 6.02 ms Query memory: 0.031 MB Memory before query: 5.163 MB Rows returned: 49

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

  LEFT JOIN j3_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	gator_joomla3.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.6 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.35 ms After last query: 4.23 ms Query memory: 0.024 MB Memory before query: 5.682 MB Rows returned: 1

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

  FROM j3_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/k2/k2.php:52

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.30 ms After last query: 0.27 ms Query memory: 0.017 MB Memory before query: 5.690 MB

UPDATE `j3_extensions`

  SET `params` = '{\"mediaversion\":\"fd3639e5d34a6bab004b6b7756cda91f\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	j3_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	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/k2/k2.php:52

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.24 ms After last query: 3.14 ms Query memory: 0.022 MB Memory before query: 6.068 MB Rows returned: 1

SELECT *

  FROM j3_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_languages	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

JROOT/components/com_k2/helpers/utilities.php:315

JROOT/administrator/components/com_k2/helpers/html.php:56

JROOT/plugins/system/k2/k2.php:55

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.42 ms After last query: 2.62 ms Query memory: 0.027 MB Memory before query: 6.352 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM j3_template_styles as s

  LEFT JOIN j3_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	gator_joomla3.s.template,const	1	5.00	Using index condition; Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

JROOT/libraries/cms/html/html.php:336

JROOT/libraries/cms/html/html.php:682

JROOT/libraries/cms/html/html.php:238

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

JROOT/libraries/cms/html/behavior.php:63

JROOT/libraries/cms/html/html.php:238

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

JROOT/administrator/components/com_k2/helpers/html.php:76

JROOT/plugins/system/k2/k2.php:55

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.28 ms After last query: 4.93 ms Query memory: 0.015 MB Memory before query: 6.624 MB Rows returned: 1

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

  FROM j3_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	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:328

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

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

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

JROOT/index.php:45

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

Query Time: 0.48 ms After last query: 10.11 ms Query memory: 0.020 MB Memory before query: 7.526 MB Rows returned: 203

SELECT * 
  FROM j3_acymailing_config

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_acymailing_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	203	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

JROOT/components/com_acymailing/acymailing.php:14

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.32 ms After last query: 7.28 ms Query memory: 0.023 MB Memory before query: 8.395 MB Rows returned: 1

SELECT a.*, b.name as creatorname, b.username, b.email 
  FROM j3_acymailing_list as a 
  LEFT JOIN j3_users as b 
  on a.userid = b.id 
  WHERE listid = 1 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	2	const	1	100.00	NULL
1	SIMPLE	b	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

JROOT/components/com_acymailing/views/archive/view.html.php:176

JROOT/components/com_acymailing/views/archive/view.html.php:18

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

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

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

JROOT/components/com_acymailing/acymailing.php:56

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 26.11 ms After last query: 0.72 ms Query memory: 0.023 MB Memory before query: 8.429 MB Rows returned: 20

SELECT "" AS body, "" AS altbody, html AS sendHTML, a.mailid,a.subject,a.alias,a.senddate,a.created,a.visible,a.published,a.fromname,a.fromemail,a.replyname,a.replyemail,a.userid 
  FROM j3_acymailing_listmail as c JOIN j3_acymailing_mail as a 
  on a.mailid = c.mailid  
  WHERE (a.type = 'news') 
  AND (a.published = 1) 
  AND (a.visible = 1) 
  AND (c.listid = 1) 
  ORDER BY a.senddate desc, c.mailid DESC 
  LIMIT 0, 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10043	10.00	Using where; Using temporary; Using filesort
1	SIMPLE	a	NULL	eq_ref	PRIMARY,typemailidindex	PRIMARY	3	gator_joomla3.c.mailid	1	5.00	Using index condition; Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	24.0 ms
Creating sort index	1.6 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_acymailing/views/archive/view.html.php:285

JROOT/components/com_acymailing/views/archive/view.html.php:18

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

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

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

JROOT/components/com_acymailing/acymailing.php:56

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 20.17 ms After last query: 0.42 ms Query memory: 0.018 MB Memory before query: 8.513 MB Rows returned: 1

SELECT COUNT(c.mailid) 
  FROM j3_acymailing_listmail as c JOIN j3_acymailing_mail as a 
  on a.mailid = c.mailid  
  WHERE (a.type = 'news') 
  AND (a.published = 1) 
  AND (a.visible = 1) 
  AND (c.listid = 1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10043	10.00	Using where
1	SIMPLE	a	NULL	eq_ref	PRIMARY,typemailidindex	PRIMARY	3	gator_joomla3.c.mailid	1	5.00	Using index condition; Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	19.7 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_acymailing/views/archive/view.html.php:295

JROOT/components/com_acymailing/views/archive/view.html.php:18

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

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

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

JROOT/components/com_acymailing/acymailing.php:56

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 1.26 ms After last query: 30.66 ms Query memory: 0.023 MB Memory before query: 10.862 MB Rows returned: 41

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

  FROM j3_modules AS m

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

  LEFT JOIN j3_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 <= '2021-01-21 06:10:40') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-21 06:10:40') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 194 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	34	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	gator_joomla3.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	gator_joomla3.m.id	2	40.00	Using where; Using index

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.7 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

JROOT/templates/gk_news/layouts/default.php:32

JROOT/templates/gk_news/lib/gk.framework.php:150

JROOT/templates/gk_news/lib/gk.framework.php:95

JROOT/templates/gk_news/index.php:28

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

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.35 ms After last query: 2.60 ms Query memory: 0.031 MB Memory before query: 11.034 MB Rows returned: 1

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

  FROM j3_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	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/components/com_content/router.php:37

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

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

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

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

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

JROOT/templates/gk_news/lib/menu/GKHandheld.php:94

JROOT/templates/gk_news/layouts/default.php:90

JROOT/templates/gk_news/lib/gk.framework.php:150

JROOT/templates/gk_news/lib/gk.framework.php:95

JROOT/templates/gk_news/index.php:28

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

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.33 ms After last query: 19.10 ms Query memory: 0.022 MB Memory before query: 11.778 MB Rows returned: 0

SELECT * 
  FROM j3_k2_categories 
  WHERE parent=53 
  AND published=1 
  AND trash=0 
  AND access<=0 
  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_k2_tools_extended/helper.php:388

JROOT/modules/mod_k2_tools_extended/helper.php:198

JROOT/modules/mod_k2_tools_extended/mod_k2_tools_extended.php:48

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 14.79 ms After last query: 0.10 ms Query memory: 0.028 MB Memory before query: 11.797 MB Rows returned: 310

SELECT DISTINCT title, id, alias 
  FROM j3_k2_items 
  WHERE catid IN (53 ) 
  AND published=1 
  AND trash=0 
  GROUP BY title 
  ORDER BY title

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_k2_items	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7550	0.10	Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	14.0 ms
Creating sort index	0.4 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_k2_tools_extended/helper.php:207

JROOT/modules/mod_k2_tools_extended/mod_k2_tools_extended.php:48

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.38 ms After last query: 87.73 ms Query memory: 0.017 MB Memory before query: 12.695 MB Rows returned: 1

Duplicate queries: #25 #32 #33 #42 #43 #58 #59

select `blacklist` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1750

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:16

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

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

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

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

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

JROOT/index.php:45

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

Duplicate queries: #24 #32 #33 #42 #43 #58 #59

select `blacklist` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1751

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:16

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.16 ms After last query: 0.24 ms Query memory: 0.018 MB Memory before query: 12.742 MB Rows returned: 1

Duplicate queries: #34 #44 #60

select `params` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:52

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.29 ms After last query: 4.45 ms Query memory: 0.036 MB Memory before query: 13.341 MB Rows returned: 1

Duplicate queries: #35 #45 #61

SELECT * 
  FROM j3_ad_agency_settings 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:78

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.22 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 13.378 MB Rows returned: 1

Duplicate queries: #31

SELECT * 
  FROM j3_ad_agency_zone 
  WHERE zoneid=149 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_zone	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:82

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.13 ms Query memory: 0.018 MB Memory before query: 13.403 MB Rows returned: 0

Duplicate queries: #30 #37 #38 #47 #48 #63 #64

select `approved` 
  from j3_ad_agency_banners 
  where `id`=0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:99

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.018 MB Memory before query: 13.420 MB Rows returned: 0

Duplicate queries: #29 #37 #38 #47 #48 #63 #64

select `approved` 
  from j3_ad_agency_banners 
  where `id`=0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:100

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.16 ms After last query: 0.38 ms Query memory: 0.024 MB Memory before query: 13.408 MB Rows returned: 1

Duplicate queries: #28

SELECT * 
  FROM j3_ad_agency_zone 
  WHERE zoneid=149 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_zone	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/tmpl/default.php:14

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:27

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.15 ms After last query: 2.37 ms Query memory: 0.017 MB Memory before query: 13.427 MB Rows returned: 1

Duplicate queries: #24 #25 #33 #42 #43 #58 #59

select `blacklist` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1750

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:16

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

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

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

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

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

JROOT/index.php:45

[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.06 ms Query memory: 0.018 MB Memory before query: 13.444 MB Rows returned: 1

Duplicate queries: #24 #25 #32 #42 #43 #58 #59

select `blacklist` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1751

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:16

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

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

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

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

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

JROOT/index.php:45

[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.12 ms Query memory: 0.018 MB Memory before query: 13.463 MB Rows returned: 1

Duplicate queries: #26 #44 #60

select `params` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:52

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.21 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 13.487 MB Rows returned: 1

Duplicate queries: #27 #45 #61

SELECT * 
  FROM j3_ad_agency_settings 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:78

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.10 ms Query memory: 0.024 MB Memory before query: 13.525 MB Rows returned: 1

Duplicate queries: #39

SELECT * 
  FROM j3_ad_agency_zone 
  WHERE zoneid=74 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_zone	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:82

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.11 ms Query memory: 0.018 MB Memory before query: 13.548 MB Rows returned: 0

Duplicate queries: #29 #30 #38 #47 #48 #63 #64

select `approved` 
  from j3_ad_agency_banners 
  where `id`=0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:99

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.018 MB Memory before query: 13.565 MB Rows returned: 0

Duplicate queries: #29 #30 #37 #47 #48 #63 #64

select `approved` 
  from j3_ad_agency_banners 
  where `id`=0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:100

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.29 ms Query memory: 0.024 MB Memory before query: 13.554 MB Rows returned: 1

Duplicate queries: #36

SELECT * 
  FROM j3_ad_agency_zone 
  WHERE zoneid=74 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_zone	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/tmpl/default.php:14

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:27

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 1.26 ms After last query: 8.10 ms Query memory: 0.021 MB Memory before query: 14.076 MB Rows returned: 8

SELECT c.*, i.catid, i.title, i.alias, category.alias as catalias, category.name as categoryname
		
  FROM j3_k2_comments as c
		
  LEFT JOIN j3_k2_items as i 
  ON i.id=c.itemID
		
  LEFT JOIN j3_k2_categories as category 
  ON category.id=i.catid
		
  WHERE i.published=1
		
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-01-21 06:10:40' )
		
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-21 06:10:40' )
		
  AND i.trash=0  
  AND i.access IN(1,1)  
  AND category.published=1 
  AND category.trash=0  
  AND category.access IN(1,1)  
  AND c.published=1  
  ORDER BY c.commentDate DESC 
  LIMIT 0, 8

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	itemId	NO INDEX KEY COULD BE USED	NULL	NULL	1581	10.00	Using where; Using filesort
1	SIMPLE	i	NULL	eq_ref	PRIMARY,id	PRIMARY	4	gator_joomla3.c.itemID	1	5.00	Using where
1	SIMPLE	category	NULL	eq_ref	PRIMARY,id	PRIMARY	4	gator_joomla3.i.catid	1	5.00	Using index condition; Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.9 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_k2_comments/helper.php:92

JROOT/modules/mod_k2_comments/mod_k2_comments.php:57

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.37 ms After last query: 2.82 ms Query memory: 0.023 MB Memory before query: 14.424 MB Rows returned: 37

SELECT id, name,  parent	
  FROM j3_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1) 
  ORDER BY parent

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:1239

JROOT/components/com_k2/helpers/route.php:321

JROOT/components/com_k2/helpers/route.php:58

JROOT/modules/mod_k2_comments/helper.php:151

JROOT/modules/mod_k2_comments/mod_k2_comments.php:57

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

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

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

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

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

JROOT/index.php:45

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

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

Duplicate queries: #24 #25 #32 #33 #43 #58 #59

select `blacklist` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1750

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:16

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

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

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

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

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

JROOT/index.php:45

[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.05 ms Query memory: 0.018 MB Memory before query: 14.467 MB Rows returned: 1

Duplicate queries: #24 #25 #32 #33 #42 #58 #59

select `blacklist` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1751

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:16

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

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

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

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

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

JROOT/index.php:45

[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.11 ms Query memory: 0.018 MB Memory before query: 14.485 MB Rows returned: 1

Duplicate queries: #26 #34 #60

select `params` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:52

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.19 ms After last query: 0.12 ms Query memory: 0.036 MB Memory before query: 14.510 MB Rows returned: 1

Duplicate queries: #27 #35 #61

SELECT * 
  FROM j3_ad_agency_settings 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:78

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.13 ms Query memory: 0.024 MB Memory before query: 14.547 MB Rows returned: 1

Duplicate queries: #49

SELECT * 
  FROM j3_ad_agency_zone 
  WHERE zoneid=76 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_zone	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:82

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.12 ms Query memory: 0.018 MB Memory before query: 14.571 MB Rows returned: 0

Duplicate queries: #29 #30 #37 #38 #48 #63 #64

select `approved` 
  from j3_ad_agency_banners 
  where `id`=0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:99

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.08 ms Query memory: 0.018 MB Memory before query: 14.588 MB Rows returned: 0

Duplicate queries: #29 #30 #37 #38 #47 #63 #64

select `approved` 
  from j3_ad_agency_banners 
  where `id`=0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:100

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:23

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

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

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

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

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

JROOT/index.php:45

[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.33 ms Query memory: 0.025 MB Memory before query: 14.577 MB Rows returned: 1

Duplicate queries: #46

SELECT * 
  FROM j3_ad_agency_zone 
  WHERE zoneid=76 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_zone	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/tmpl/default.php:14

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:27

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.26 ms After last query: 2.77 ms Query memory: 0.022 MB Memory before query: 14.868 MB Rows returned: 5

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_acymailing_list	NULL	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	4	100.00	Using index condition

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

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

JROOT/modules/mod_acymailing/mod_acymailing.php:121

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.21 ms After last query: 3.03 ms Query memory: 0.022 MB Memory before query: 15.373 MB Rows returned: 6

SELECT * 
  FROM `j3_acymailing_fields` as a 
  WHERE a.`published` = 1 
  ORDER BY a.`ordering` ASC

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/fields.php:63

JROOT/modules/mod_acymailing/mod_acymailing.php:206

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 17.40 ms After last query: 18.86 ms Query memory: 0.020 MB Memory before query: 15.785 MB Rows returned: 68

SELECT 
					c.id AS CID
				
  FROM 
					j3_k2_categories AS c
				
  LEFT JOIN 
					j3_k2_items AS content 
					
  ON 
					c.id = content.catid 	
				 
				
  WHERE 
					(  c.id = 67 OR c.id = 68 ) 
					
  AND 
					c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	PRIMARY,id	PRIMARY	4	NULL	2	10.00	Using index condition; Using where
1	SIMPLE	content	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7550	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	16.8 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.k2.php:76

JROOT/modules/mod_highlighter_gk5/helper.php:102

JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 19.37 ms After last query: 0.58 ms Query memory: 0.061 MB Memory before query: 15.806 MB Rows returned: 58

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			j3_k2_items AS content 
			
		
  WHERE 
			content.published = 1
                 
  AND content.access IN (1,1)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2021-01-21 06:10:40' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2021-01-21 06:10:40' )
			 
  AND (  content.catid = 67 OR content.catid = 68 ) 
			
			 
			
		
  ORDER BY 
			 content.title ASC 
		
  LIMIT
			0,100;

Explain

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

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	18.9 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.k2.php:206

JROOT/modules/mod_highlighter_gk5/helper.php:104

JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 2.22 ms After last query: 0.59 ms Query memory: 0.026 MB Memory before query: 16.371 MB Rows returned: 58

SELECT
			content.id AS id,
			content.access AS access,
			content.catid AS cid,
			categories.name AS catname, 
			categories.alias AS cat_alias,
			users.email AS author_email,
			content.created_by_alias AS author_alias,
			content.created_by AS author_id,
			content_rating.rating_sum AS rating_sum,
			content_rating.rating_count AS rating_count		
		
  FROM 
			j3_k2_items AS content 
			
  LEFT JOIN 
				j3_k2_categories AS categories 
				
  ON categories.id = content.catid 
			
  LEFT JOIN 
				j3_users AS users 
				
  ON users.id = content.created_by 			
			
  LEFT JOIN 
				j3_k2_rating AS content_rating 
				
  ON content_rating.itemID = content.id
		
  WHERE 
			 content.id = 4060 OR  content.id = 2258 OR  content.id = 2768 OR  content.id = 2840 OR  content.id = 1463 OR  content.id = 2925 OR  content.id = 3952 OR  content.id = 2325 OR  content.id = 5370 OR  content.id = 3477 OR  content.id = 4689 OR  content.id = 1108 OR  content.id = 1417 OR  content.id = 133 OR  content.id = 3623 OR  content.id = 5751 OR  content.id = 1285 OR  content.id = 2461 OR  content.id = 3186 OR  content.id = 3155 OR  content.id = 3559 OR  content.id = 1773 OR  content.id = 1063 OR  content.id = 1129 OR  content.id = 2912 OR  content.id = 2846 OR  content.id = 2000 OR  content.id = 639 OR  content.id = 1714 OR  content.id = 1715 OR  content.id = 4089 OR  content.id = 4752 OR  content.id = 6711 OR  content.id = 1443 OR  content.id = 945 OR  content.id = 5656 OR  content.id = 829 OR  content.id = 2894 OR  content.id = 4246 OR  content.id = 4223 OR  content.id = 2867 OR  content.id = 2869 OR  content.id = 1253 OR  content.id = 4145 OR  content.id = 4311 OR  content.id = 3811 OR  content.id = 3800 OR  content.id = 448 OR  content.id = 1833 OR  content.id = 1814 OR  content.id = 2910 OR  content.id = 4204 OR  content.id = 2265 OR  content.id = 969 OR  content.id = 7267 OR  content.id = 7154 OR  content.id = 3380 OR  content.id = 5677
		
  ORDER BY 
			 content.title ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	range	PRIMARY,id	PRIMARY	4	NULL	58	100.00	Using index condition; Using filesort
1	SIMPLE	categories	NULL	eq_ref	PRIMARY,id	PRIMARY	4	gator_joomla3.content.catid	1	100.00	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	gator_joomla3.content.created_by	1	100.00	NULL
1	SIMPLE	content_rating	NULL	eq_ref	PRIMARY	PRIMARY	4	gator_joomla3.content.id	1	100.00	NULL

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.1 ms
statistics	0.2 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	1.4 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.k2.php:250

JROOT/modules/mod_highlighter_gk5/helper.php:104

JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 16.47 ms After last query: 37.03 ms Query memory: 0.020 MB Memory before query: 17.064 MB Rows returned: 1

SELECT DISTINCT 
				c.id AS ID,  
				c.name AS name,
				c.alias AS alias 
			
  FROM 
				j3_k2_categories AS c
			
  LEFT JOIN 
				j3_k2_items AS content 
				
  ON 
				c.id = content.catid 
              
			
  WHERE 
				(  c.id = 50 ) 
				
  AND 
				c.published = 1 
				
  AND 
				c.access <= 1;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,id	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	content	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7550	100.00	Using where; Distinct

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
executing	0.0 ms
Sending data	15.8 ms
Removing duplicates	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php:90

JROOT/modules/mod_news_pro_gk4/gk_classes/portal_modes/gk.portal_mode_7.php:178

JROOT/modules/mod_news_pro_gk4/helper.php:281

JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:29

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 15.86 ms After last query: 0.47 ms Query memory: 0.022 MB Memory before query: 17.088 MB Rows returned: 9

SELECT
				content.id AS IID,
				content.catid AS cat_id,
				content.title AS title, 
				content.introtext AS text, 
				content.created AS date, 
				content.publish_up AS date_publish,
				content.alias AS alias,
				content.hits AS hits,
			    content.plugins AS plugins		
			
  FROM 
				j3_k2_items AS content
				 	
			
  WHERE 
				content.trash = 0 
					
  AND content.access <= 1
					
  AND content.published = 1 
			 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2021-01-21 00:00:00' )
					
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2021-01-21 00:00:00' )
				 
  AND (  content.catid = 50 ) 
				 
  AND content.featured = 1  
				
			
  ORDER BY 
				 content.created DESC 
			
  LIMIT
				0,10;

Explain

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

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	15.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php:205

JROOT/modules/mod_news_pro_gk4/gk_classes/portal_modes/gk.portal_mode_7.php:182

JROOT/modules/mod_news_pro_gk4/helper.php:281

JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:29

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.86 ms After last query: 0.50 ms Query memory: 0.022 MB Memory before query: 17.143 MB Rows returned: 9

SELECT
				content.id AS ID,
				cats.name AS cat_name,
				cats.alias AS cat_alias,
				content.catid AS cat_id,
				users.name AS author,
				users.email AS author_email,
				users.id AS author_id,
			    content_rating.rating_sum AS rating_sum,
			    content_rating.rating_count AS rating_count	
			
  FROM 
				j3_k2_items AS content 
				
  LEFT JOIN 
					j3_k2_categories AS cats
					
  ON cats.id = content.catid 
				
  LEFT JOIN 
					j3_users AS users 
					
  ON users.id = content.created_by
			      	
			    
  LEFT JOIN
			        j3_k2_rating AS content_rating
			        
  ON content.id = content_rating.itemID	
			
  WHERE 
				 content.id = 8076 OR  content.id = 8115 OR  content.id = 8118 OR  content.id = 8114 OR  content.id = 8096 OR  content.id = 8078 OR  content.id = 8092 OR  content.id = 8091 OR  content.id = 8064
			
  ORDER BY 
				 content.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	range	PRIMARY,id	PRIMARY	4	NULL	9	100.00	Using index condition; Using filesort
1	SIMPLE	cats	NULL	eq_ref	PRIMARY,id	PRIMARY	4	gator_joomla3.content.catid	1	100.00	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	gator_joomla3.content.created_by	1	100.00	NULL
1	SIMPLE	content_rating	NULL	eq_ref	PRIMARY	PRIMARY	4	gator_joomla3.content.id	1	100.00	NULL

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_news_pro_gk4/gk_classes/gk.source.k2.php:268

JROOT/modules/mod_news_pro_gk4/gk_classes/portal_modes/gk.portal_mode_7.php:182

JROOT/modules/mod_news_pro_gk4/helper.php:281

JROOT/modules/mod_news_pro_gk4/mod_news_pro_gk4.php:29

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.33 ms After last query: 9.44 ms Query memory: 0.017 MB Memory before query: 17.094 MB Rows returned: 1

Duplicate queries: #24 #25 #32 #33 #42 #43 #59

select `blacklist` 
  from j3_ad_agency_settings

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j3_ad_agency_settings	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_ijoomla_adagency_zone/helper.php:1750

JROOT/modules/mod_ijoomla_adagency_zone/mod_ijoomla_adagency_zone.php:16

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

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

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

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

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

JROOT/index.php:45

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

Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.018 MB Memory before query: 17.111 MB Rows returned: 1

Potassium lowers blood pressure

A month ot sandwich recipes

These dishes are BEST served cold

Baking master cakes are too good to…

Popcorn flour makes best cornbread

Ice cold coffee beverages

Building a better taco

French girl's guide to eggs

What chef's cook for their kids

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

66 Queries Logged 150.8 ms

32 duplicate found!