Cannot get Kecel location id in module mod_sp_weather. Please also make sure that you have inserted city name.

Current

Főmenü

Partnereink:

Friss pályázatok

Pályázatok

Jogpont

Kecel Városi TV

Keceli programajánló

ÁLLÁS KERES-KÍNÁL

Vidéki programajánló

Facebook ajánlók

Ki olvas minket

Oldalainkat 59 vendég és 0 tag böngészi

Statisztika

2014.07.26-tól

Jogi nyilatkozat

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Idő: 0.0 ms / 0.0 ms Memória: 1.203 MB / 1.20 MB Application: afterLoad

Idő: 26.8 ms / 26.9 ms Memória: 5.649 MB / 6.85 MB Application: afterInitialise

Idő: 14.2 ms / 41.1 ms Memória: 2.738 MB / 9.59 MB Application: afterRoute

Idő: 56.1 ms / 97.2 ms Memória: 6.397 MB / 15.99 MB Application: afterDispatch

Idő: 5.0 ms / 102.2 ms Memória: 0.711 MB / 16.70 MB Application: beforeRenderModule mod_je_facebookfanbox (Gyepmestertelep Facebook Like Box)

Idő: 0.6 ms / 102.8 ms Memória: 0.077 MB / 16.77 MB Application: afterRenderModule mod_je_facebookfanbox (Gyepmestertelep Facebook Like Box)

Idő: 0.2 ms / 103.0 ms Memória: 0.000 MB / 16.77 MB Application: beforeRenderModule mod_je_facebookfanbox (Facebook ajánlók)

Idő: 0.3 ms / 103.2 ms Memória: 0.013 MB / 16.78 MB Application: afterRenderModule mod_je_facebookfanbox (Facebook ajánlók)

Idő: 0.0 ms / 103.3 ms Memória: 0.000 MB / 16.77 MB Application: beforeRenderModule mod_je_facebookfanbox (FLORA Facebook Like Box)

Idő: 0.3 ms / 103.5 ms Memória: 0.013 MB / 16.78 MB Application: afterRenderModule mod_je_facebookfanbox (FLORA Facebook Like Box)

Idő: 0.0 ms / 103.6 ms Memória: 0.000 MB / 16.78 MB Application: beforeRenderModule mod_whosonline (Ki olvas minket)

Idő: 1.4 ms / 105.0 ms Memória: 0.051 MB / 16.83 MB Application: afterRenderModule mod_whosonline (Ki olvas minket)

Idő: 0.9 ms / 105.9 ms Memória: 0.051 MB / 16.88 MB Application: beforeRenderModule mod_menu (Főmenü)

Idő: 14.2 ms / 120.1 ms Memória: 0.291 MB / 17.17 MB Application: afterRenderModule mod_menu (Főmenü)

Idő: 1.3 ms / 121.4 ms Memória: 0.004 MB / 17.17 MB Application: beforeRenderModule mod_search (Keresés)

Idő: 1.5 ms / 122.9 ms Memória: 0.048 MB / 17.22 MB Application: afterRenderModule mod_search (Keresés)

Idő: 0.7 ms / 123.6 ms Memória: 0.000 MB / 17.21 MB Application: beforeRenderModule mod_menu (Felső menü)

Idő: 3.7 ms / 127.3 ms Memória: 0.047 MB / 17.26 MB Application: afterRenderModule mod_menu (Felső menü)

Idő: 0.2 ms / 127.5 ms Memória: 0.000 MB / 17.21 MB Application: beforeRenderModule mod_sp_weather (Időjárás modul fejlécben (SP Weather))

Idő: 10.8 ms / 138.3 ms Memória: 0.373 MB / 17.58 MB Application: afterRenderModule mod_sp_weather (Időjárás modul fejlécben (SP Weather))

Idő: 0.3 ms / 138.6 ms Memória: 0.000 MB / 17.57 MB Application: beforeRenderModule mod_je_thumbslideshow (Felső képváltó Slide (JE Thumbnail SlideShow))

Idő: 0.4 ms / 139.0 ms Memória: 0.023 MB / 17.60 MB Application: afterRenderModule mod_je_thumbslideshow (Felső képváltó Slide (JE Thumbnail SlideShow))

Idő: 4.0 ms / 143.0 ms Memória: 0.201 MB / 17.80 MB Application: afterRender

Adatbázislekérdezés összesen: 29.3 ms

Memóriahasználat

Adatbázis lekérdezések

20 naplózott lekérdezés 29.3 ms

Lekérdezés ideje: 0.13 ms Memória lekérdezése: 0.014 MB memória a lekérdezés előtt: 3.920 MB Visszaadott sorok: 0

SELECT `data`

  FROM `rqhib_session`

  WHERE `session_id` = 'ofalb1l652rr7m6bpjkg67nb75'

Magyarázat

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

Profil

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

Hívási verem

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

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

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.11 ms Utolsó lekérdezés után: 0.91 ms Memória lekérdezése: 0.008 MB memória a lekérdezés előtt: 4.147 MB

DELETE 

  FROM `rqhib_session`

  WHERE `time` < '1571832445'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqhib_session	range	time	time	45	const	1	100.00	Using where

Profil

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

Hívási verem

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.11 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.011 MB memória a lekérdezés előtt: 4.162 MB Visszaadott sorok: 0

SELECT `session_id`

  FROM `rqhib_session`

  WHERE `session_id` = 'ofalb1l652rr7m6bpjkg67nb75' 
  LIMIT 0, 1

Magyarázat

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

Profil

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

Hívási verem

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.90 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 4.173 MB

INSERT INTO `rqhib_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('ofalb1l652rr7m6bpjkg67nb75', 0, '1571833645')

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `rqhib_session` (`session_id`, `client_id`, `time`) VALUES ('ofalb1l652rr7m6bpjkg67nb75', 0, '1571833645')

Profil

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.0 ms
end	0.0 ms
query end	0.8 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.16 ms Utolsó lekérdezés után: 2.77 ms Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 4.936 MB Visszaadott sorok: 2

SELECT b.id

  FROM rqhib_usergroups AS a

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

  WHERE a.id = 9

Magyarázat

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

Profil

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

Hívási verem

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.10 ms Utolsó lekérdezés után: 0.38 ms Memória lekérdezése: 0.012 MB memória a lekérdezés előtt: 5.044 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `rqhib_viewlevels`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqhib_viewlevels	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	5	100.00	NULL

Profil

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

Hívási verem

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.10 ms Utolsó lekérdezés után: 6.27 ms Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 6.332 MB

DELETE 

  FROM `rqhib_jhackguard_ip_filters`

  WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) 
  AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqhib_jhackguard_ip_filters	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	5	100.00	Using where

Profil

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

Hívási verem

JROOT/plugins/system/jhackguard/jhackguard.php:156

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 6.353 MB Visszaadott sorok: 0

SELECT `state`,`rule_type`

  FROM `rqhib_jhackguard_ip_filters`

  WHERE `ip` = '18.208.187.169' 
  AND `state` = 1

  ORDER BY ordering ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqhib_jhackguard_ip_filters	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	5	100.00	Using where; Fájlrendezés használata

Profil

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

Hívási verem

JROOT/plugins/system/jhackguard/jhackguard.php:358

JROOT/plugins/system/jhackguard/jhackguard.php:174

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.76 ms Utolsó lekérdezés után: 6.92 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 7.415 MB Visszaadott sorok: 145

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

  LEFT JOIN rqhib_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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	285	81.75	Using where; Fájlrendezés használata
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	kecelkon_kecel.m.component_id	1	100.00	Using where

Profil

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

Hívási verem

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

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.79 ms Utolsó lekérdezés után: 6.77 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 9.038 MB

UPDATE `rqhib_extensions`

  SET `params` = '{\"mediaversion\":\"4f5b0cc53e4ac22c731decaadbd5c762\"}'

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqhib_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profil

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.0 ms
end	0.0 ms
query end	1.6 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

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/jcktypography/jcktypography.php:48

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 18.71 ms Utolsó lekérdezés után: 11.24 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 11.117 MB Visszaadott sorok: 32

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

  FROM rqhib_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN `rqhib_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	ALL	cat_idx,idx_access	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	53	64.15	Using where; Using temporary; Fájlrendezés használata
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	kecelkon_kecel.c.id	10	100.00	Using where; Not exists; Using index
1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	kecelkon_kecel.c.id	15	100.00	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Fájlrendezés használata
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	53	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.2 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.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	17.8 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/models/categories.php:109

JROOT/libraries/legacy/view/legacy.php:398

JROOT/libraries/legacy/view/categories.php:57

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.96 ms Utolsó lekérdezés után: 5.98 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 12.512 MB Visszaadott sorok: 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM rqhib_categories as c

  LEFT JOIN rqhib_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=67 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	53	64.15	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	kecelkon_kecel.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Fájlrendezés használata
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	53	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.2 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.0 ms
optimizing	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
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.2 ms
Creating sort index	0.0 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:80

JROOT/components/com_content/views/categories/tmpl/default_items.php:29

JROOT/libraries/legacy/view/legacy.php:663

JROOT/components/com_content/views/categories/tmpl/default.php:15

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/libraries/legacy/view/categories.php:98

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.98 ms Utolsó lekérdezés után: 11.52 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 15.708 MB Visszaadott sorok: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM rqhib_categories as c

  LEFT JOIN rqhib_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=68 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	53	64.15	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	kecelkon_kecel.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Fájlrendezés használata
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	53	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.2 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.0 ms
optimizing	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
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.2 ms
Creating sort index	0.0 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:80

JROOT/components/com_content/views/categories/tmpl/default_items.php:29

JROOT/libraries/legacy/view/legacy.php:663

JROOT/components/com_content/views/categories/tmpl/default.php:15

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/libraries/legacy/view/categories.php:98

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.91 ms Utolsó lekérdezés után: 0.38 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 15.746 MB Visszaadott sorok: 18

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM rqhib_categories as c

  LEFT JOIN rqhib_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=65 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	53	64.15	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	kecelkon_kecel.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Fájlrendezés használata
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	53	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil

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.0 ms
optimizing	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
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.3 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:80

JROOT/components/com_content/views/categories/tmpl/default_items.php:29

JROOT/libraries/legacy/view/legacy.php:663

JROOT/components/com_content/views/categories/tmpl/default.php:15

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/libraries/legacy/view/categories.php:98

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.83 ms Utolsó lekérdezés után: 3.42 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 15.945 MB Visszaadott sorok: 11

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM rqhib_categories as c

  LEFT JOIN rqhib_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=66 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	53	64.15	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	kecelkon_kecel.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Fájlrendezés használata
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	53	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil

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.0 ms
optimizing	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
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.3 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:80

JROOT/components/com_content/views/categories/tmpl/default_items.php:29

JROOT/libraries/legacy/view/legacy.php:663

JROOT/components/com_content/views/categories/tmpl/default.php:15

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/libraries/legacy/view/categories.php:98

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.72 ms Utolsó lekérdezés után: 2.08 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 16.070 MB Visszaadott sorok: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM rqhib_categories as c

  LEFT JOIN rqhib_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=77 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	53	64.15	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	kecelkon_kecel.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Fájlrendezés használata
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	53	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil

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.0 ms
optimizing	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
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.2 ms
Creating sort index	0.0 ms
end	0.0 ms
removing tmp table	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:80

JROOT/components/com_content/views/categories/tmpl/default_items.php:29

JROOT/libraries/legacy/view/legacy.php:663

JROOT/components/com_content/views/categories/tmpl/default.php:15

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/libraries/legacy/view/categories.php:98

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.52 ms Utolsó lekérdezés után: 3.23 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 16.564 MB Visszaadott sorok: 27

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

  FROM rqhib_modules AS m

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

  LEFT JOIN rqhib_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 <= '2019-10-23 12:27:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-23 12:27:25') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 373 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	47	100.00	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	kecelkon_kecel.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	kecelkon_kecel.m.id	3	100.00	Using where; Using index

Profil

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

Hívási verem

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

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

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

JROOT/templates/008/library/Artx/Page.php:43

JROOT/templates/008/index.php:63

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

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.14 ms Utolsó lekérdezés után: 4.57 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 16.854 MB Visszaadott sorok: 59

SELECT guest, client_id

  FROM rqhib_session

  WHERE client_id = 0

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqhib_session	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	59	100.00	Using where

Profil

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

Hívási verem

JROOT/modules/mod_whosonline/helper.php:41

JROOT/modules/mod_whosonline/mod_whosonline.php:19

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

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

JROOT/libraries/joomla/document/html/renderer/modules.php:46

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

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

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

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.13 ms Utolsó lekérdezés után: 35.72 ms Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 17.826 MB Visszaadott sorok: 0

SELECT `name`,`regex`,`replacement`

  FROM `rqhib_jhackguard_output_filters`

  WHERE `state` = 1

  ORDER BY ordering ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

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

Hívási verem

JROOT/plugins/system/jhackguard/jhackguard.php:91

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

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

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

JROOT/index.php:40

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.11 ms Utolsó lekérdezés után: 2.63 ms Memória lekérdezése: 0.003 MB memória a lekérdezés előtt: 17.767 MB

UPDATE `rqhib_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1571833645;s:18:\"session.timer.last\";i:1571833645;s:17:\"session.timer.now\";i:1571833645;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4781136a50c9b9666b138bc89d9bd6c0\";}'
	, `time` = '1571833645'

  WHERE `session_id` = 'ofalb1l652rr7m6bpjkg67nb75'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqhib_session	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

Profil

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
updating	0.0 ms
end	0.0 ms
query end	1.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Hívási verem

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

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

16 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

5 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM rqhib_categories as c 
  LEFT JOIN rqhib_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM rqhib_modules AS m 
  LEFT JOIN rqhib_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN rqhib_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT guest, client_id 
  FROM rqhib_session

1 × SELECT `name`,`regex`,`replacement` 
  FROM `rqhib_jhackguard_output_filters`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM rqhib_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM rqhib_categories AS cat JOIN rqhib_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

1 × SELECT `session_id` 
  FROM `rqhib_session`

1 × SELECT b.id 
  FROM rqhib_usergroups AS a 
  LEFT JOIN rqhib_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `rqhib_viewlevels

1 × SELECT `state`,`rule_type` 
  FROM `rqhib_jhackguard_ip_filters`

1 × SELECT `data` 
  FROM `rqhib_session`

EGYÉB táblák:

1 × UPDATE `rqhib_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1571833645;s:18:\"session.timer.last\";i:1571833645;s:17:\"session.timer.now\";i:1571833645;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4781136a50c9b9666b138bc89d9bd6c0\";}'  , `time` = '1571833645'

1 × UPDATE `rqhib_extensions` 
  SET `params` = '{\"mediaversion\":\"4f5b0cc53e4ac22c731decaadbd5c762\"}'

1 × DELETE  
  FROM `rqhib_jhackguard_ip_filters`

1 × INSERT INTO `rqhib_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('ofalb1l652rr7m6bpjkg67nb75', 0, '1571833645'

```
1 × DELETE  
  FROM `rqhib_session`
```

Főmenü

Partnereink:

Friss pályázatok

Pályázatok

Jogpont

Hirdetések 10

Hirdetések 1

Uncategorised 142

Hírek 222

Keceli értéktár 8

Friss hírek 4

KECELCOM 5

Szennyviz 3

ELBIR 33

Sajtótájékoztató 9

Járási hírek 27

Kecelmédia hírek 2

Gazdasági híreink 4

Szabadidő hírek 30

Civil szervezeteink hírei 12

Önkormányzati hírek 303

Intézményi hírek 20

Sporthírek 5

Hírek röviden 34

Képviselő-testületi ülések 97

Tartalom 2

Statikus civil szervezetek 12

Statikus gazdaság 7

Statikus kultúra 4

Statikus programok 11

Statikus intézmények 17

Statikus önkormányzat 21

Statikus turizmus 9

Statikus sport 14

Statikus tartalom 84

Keceli Hírek 35

Kecel Városi TV

Keceli programajánló

ÁLLÁS KERES-KÍNÁL

Vidéki programajánló

Facebook ajánlók

Ki olvas minket

Statisztika

Jogi nyilatkozat

Joomla! hibakereső konzol

Munkamenet

__default

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

20 naplózott lekérdezés 29.3 ms

16 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

EGYÉB táblák: