Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1566605635,
                "last": 1566605635,
                "now": 1566605635
            },
            "token": "TJBPDXD8jqk8il270FKIHKvvAA3j277E"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profilinformációk

Idő

Memória

Idő: 95.51 ms / 95.51 ms Memória: 0.203 MB / 0.43 MB Application: afterLoad

Idő: 202.70 ms / 298.21 ms Memória: 1.957 MB / 2.39 MB Application: afterInitialise

Idő: 65.64 ms / 363.85 ms Memória: 0.660 MB / 3.05 MB Application: afterRoute

Idő: 0.98 ms / 364.83 ms Memória: 0.042 MB / 3.09 MB Application: beforeRenderComponent com_tags

Idő: 101.26 ms / 466.09 ms Memória: 0.798 MB / 3.89 MB Application: Before JAccess::preloadComponents (all components)

Idő: 1.20 ms / 467.29 ms Memória: 0.086 MB / 3.97 MB Application: After JAccess::preloadComponents (all components)

Idő: 0.05 ms / 467.34 ms Memória: 0.000 MB / 3.97 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Idő: 2.23 ms / 469.57 ms Memória: 0.018 MB / 3.98 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Idő: 73.22 ms / 542.79 ms Memória: 0.941 MB / 4.92 MB Application: Before JAccess::getAssetRules (id:175 name:com_tags)

Idő: 0.23 ms / 543.02 ms Memória: 0.009 MB / 4.93 MB Application: After JAccess::getAssetRules (id:175 name:com_tags)

Idő: 25.27 ms / 568.29 ms Memória: 0.295 MB / 5.23 MB Application: afterRenderComponent com_tags

Idő: 4.90 ms / 573.19 ms Memória: 0.022 MB / 5.25 MB Application: afterDispatch

Idő: 42.88 ms / 616.07 ms Memória: 0.301 MB / 5.55 MB Application: beforeRenderModule mod_custom (Footer Social)

Idő: 5.81 ms / 621.87 ms Memória: 0.015 MB / 5.57 MB Application: afterRenderModule mod_custom (Footer Social)

Idő: 0.10 ms / 621.98 ms Memória: 0.000 MB / 5.56 MB Application: beforeRenderModule mod_custom (debug_error)

Idő: 0.26 ms / 622.24 ms Memória: 0.007 MB / 5.57 MB Application: afterRenderModule mod_custom (debug_error)

Idő: 0.09 ms / 622.33 ms Memória: 0.000 MB / 5.57 MB Application: beforeRenderModule mod_custom (NYITVATARTÁS)

Idő: 0.39 ms / 622.72 ms Memória: 0.008 MB / 5.57 MB Application: afterRenderModule mod_custom (NYITVATARTÁS)

Idő: 0.00 ms / 622.72 ms Memória: 0.000 MB / 5.57 MB Application: beforeRenderModule mod_custom (LÁNCHÍD GALÉRIA)

Idő: 0.26 ms / 622.98 ms Memória: 0.007 MB / 5.58 MB Application: afterRenderModule mod_custom (LÁNCHÍD GALÉRIA)

Idő: 0.08 ms / 623.06 ms Memória: 0.000 MB / 5.58 MB Application: beforeRenderModule mod_custom (antik régiségek)

Idő: 0.25 ms / 623.32 ms Memória: 0.007 MB / 5.58 MB Application: afterRenderModule mod_custom (antik régiségek)

Idő: 0.08 ms / 623.40 ms Memória: 0.000 MB / 5.58 MB Application: beforeRenderModule mod_custom (RÓLUNK)

Idő: 0.32 ms / 623.71 ms Memória: 0.007 MB / 5.59 MB Application: afterRenderModule mod_custom (RÓLUNK)

Idő: 0.15 ms / 623.86 ms Memória: 0.004 MB / 5.59 MB Application: beforeRenderModule mod_foxcontact (Lépjen velünk kapcsolatba)

Idő: 60.44 ms / 684.30 ms Memória: 0.465 MB / 6.06 MB Application: afterRenderModule mod_foxcontact (Lépjen velünk kapcsolatba)

Idő: 0.13 ms / 684.43 ms Memória: 0.000 MB / 6.06 MB Application: beforeRenderModule mod_search (Search)

Idő: 3.60 ms / 688.03 ms Memória: 0.029 MB / 6.09 MB Application: afterRenderModule mod_search (Search)

Idő: 19.39 ms / 707.42 ms Memória: 0.732 MB / 6.82 MB Application: afterRender

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	ukn4s_session	NULL	range	time	time	59	const	1	100.00	Using where

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.12 ms
updating	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.02 ms

#	Hívó	Fájl és sorok száma
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Ugyanaz a hívás, mint egy sorral lejjebb.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `ukn4s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('gd8dblhfn0tqpvm3qg9f7iak24', 1, '1566605635', 0, '', 0)

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.64 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.00 ms
query end	1.23 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[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.09 ms Utolsó lekérdezés után: 6.84 ms Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 1.072 MB Visszaadott sorok: 39

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

  FROM `ukn4s_extensions`

  WHERE `type` = 'component'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ukn4s_extensions	NULL	ref	extension	extension	82	const	39	100.00	NULL

Profil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.18 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
9	JComponentHelper::{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.22 ms Utolsó lekérdezés után: 8.01 ms Memória lekérdezése: 0.014 MB memória a lekérdezés előtt: 1.164 MB Visszaadott sorok: 1

SELECT b.id

  FROM ukn4s_usergroups AS a

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

  WHERE a.id = 1

Magyarázat

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	1	100.00	Using where; Using index

Profil

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.00 ms
starting	0.01 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.00 ms
cleaning up	0.05 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.19 ms Utolsó lekérdezés után: 1.61 ms Memória lekérdezése: 0.012 MB memória a lekérdezés előtt: 1.185 MB Visszaadott sorok: 6

SELECT id, rules

  FROM `ukn4s_viewlevels`

Magyarázat

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

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 2.84 ms Utolsó lekérdezés után: 0.29 ms Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 1.225 MB Visszaadott sorok: 82

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM ukn4s_extensions

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

  ORDER BY ordering

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ukn4s_extensions	NULL	ref	extension	extension	82	const	105	0.46	Using index condition; Using where; Fájlrendezés használata

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.02 ms
checking query cache for query	0.19 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.91 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.14 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
9	JPluginHelper::{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.71 ms Utolsó lekérdezés után: 53.73 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 1.723 MB Visszaadott sorok: 24

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

  LEFT JOIN ukn4s_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	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	44	3.33	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.00 ms
starting	0.01 ms
checking query cache for query	0.31 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.43 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.28 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
26	JMenuSite->{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
25	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
24	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
23	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
22	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
21	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
20	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
19	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
18	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:433
17	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
16	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
15	JHtml::script()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Ugyanaz a hívás, mint egy sorral lejjebb.
10	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
9	JHtml::call()	JROOT/libraries/cms/html/html.php:140
8	JHtml::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 1.66 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 1.906 MB Visszaadott sorok: 6

SELECT id, home, template, s.params

  FROM ukn4s_template_styles as s

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

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	keszpenz_new.e.element	1	12.50	Using index condition; Using where

Profil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.00 ms
starting	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.80 ms
Waiting for query cache lock	0.01 ms
Sending data	0.11 ms
Waiting for query cache lock	0.01 ms
Sending data	0.02 ms
Waiting for query cache lock	0.00 ms
Sending data	0.09 ms
Waiting for query cache lock	0.01 ms
Sending data	0.01 ms
Waiting for query cache lock	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
17	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
16	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
15	JHtml::script()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Ugyanaz a hívás, mint egy sorral lejjebb.
10	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
9	JHtml::call()	JROOT/libraries/cms/html/html.php:140
8	JHtml::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.82 ms Utolsó lekérdezés után: 7.76 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 2.108 MB Visszaadott sorok: 1

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

  FROM `ukn4s_extensions`

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

Magyarázat

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

Profil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.00 ms
starting	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.11 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.00 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.07 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
25	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
24	JLibraryHelper::{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
23	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
22	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
21	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
20	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
19	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
18	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
17	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
16	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:725
15	JHtml::script()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Ugyanaz a hívás, mint egy sorral lejjebb.
10	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
9	JHtml::call()	JROOT/libraries/cms/html/html.php:140
8	JHtml::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.50 ms Utolsó lekérdezés után: 0.31 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 2.121 MB

UPDATE `ukn4s_extensions`

  SET `params` = '{\"mediaversion\":\"52a00f8551505bd78edc0f8c92708a6a\"}'

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

Magyarázat

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

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.08 ms
updating	0.14 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.42 ms
query end	0.57 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
20	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
19	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
18	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
17	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
16	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:725
15	JHtml::script()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
13	JHtml::call()	JROOT/libraries/cms/html/html.php:140
12	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
11	JHtmlJquery::framework()	Ugyanaz a hívás, mint egy sorral lejjebb.
10	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
9	JHtml::call()	JROOT/libraries/cms/html/html.php:140
8	JHtml::_()	JROOT/plugins/system/ztshortcodes/ztshortcodes.php:46
7	plgSystemZtShortcodes->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 2.47 ms Utolsó lekérdezés után: 63.25 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 2.618 MB Visszaadott sorok: 1

SELECT id

  FROM `ukn4s_tags`

  WHERE `alias` = 'festmeny-felvasarlas'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ukn4s_tags	NULL	ref	idx_alias	idx_alias	402	const	1	100.00	Using where

Profil

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	1.23 ms
preparing	0.12 ms
executing	0.00 ms
Sending data	0.41 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.05 ms
cleaning up	0.12 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/components/com_tags/router.php:179
10	TagsRouter->fixSegment()	JROOT/components/com_tags/router.php:147
9	TagsRouter->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.35 ms Utolsó lekérdezés után: 30.69 ms Memória lekérdezése: 0.009 MB memória a lekérdezés előtt: 3.064 MB Visszaadott sorok: 3

SELECT *

  FROM ukn4s_languages

  WHERE published=1

  ORDER BY ordering ASC

Magyarázat

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

Profil

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.14 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 7.94 ms Utolsó lekérdezés után: 28.01 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.320 MB Visszaadott sorok: 13

SELECT *

  FROM `ukn4s_content_types`

Magyarázat

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

Profil

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.14 ms
checking permissions	0.02 ms
Opening tables	5.40 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.12 ms
executing	0.00 ms
Sending data	1.46 ms
Waiting for query cache lock	0.00 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.04 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/cms/helper/tags.php:790
17	JHelperTags::getTypes()	JROOT/libraries/cms/helper/tags.php:624
16	JHelperTags->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:148
15	TagsModelTag->getListQuery()	JROOT/libraries/legacy/model/list.php:132
14	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.82 ms Utolsó lekérdezés után: 0.46 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 3.346 MB Visszaadott sorok: 10

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM ukn4s_contentitem_tag_map AS m

  INNER JOIN ukn4s_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2019-08-24 00:13:55')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2019-08-24 00:13:55')

  INNER JOIN ukn4s_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN ukn4s_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN ukn4s_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (2) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC 
  LIMIT 20

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	10	50.00	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	ct	NULL	ref	idx_alias	idx_alias	402	keszpenz_new.m.type_alias	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	keszpenz_new.m.core_content_id	1	5.00	Using where
1	SIMPLE	tc	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.c.core_catid	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.c.core_created_user_id	1	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.41 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	7.59 ms
init	0.16 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.05 ms
optimizing	0.03 ms
statistics	2.62 ms
preparing	0.06 ms
Creating tmp table	0.10 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	6.41 ms
Creating sort index	0.59 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.17 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.19 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.04 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.49 ms Utolsó lekérdezés után: 7.28 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.513 MB Visszaadott sorok: 30

SHOW FULL COLUMNS 
  FROM `ukn4s_tags`

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `ukn4s_tags`

Profil

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
Opening tables	0.03 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.15 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
14	TagsTableTag->__construct()	JROOT/libraries/joomla/table/table.php:311
13	JTable::getInstance()	JROOT/components/com_tags/models/tag.php:271
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.03 ms Utolsó lekérdezés után: 7.28 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 3.638 MB Visszaadott sorok: 1

Duplikált lekérdezések: #22

SELECT *

  FROM ukn4s_tags

  WHERE `id` = '2'

Magyarázat

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

Profil

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.17 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.13 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.10 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.05 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
13	JTable->load()	JROOT/components/com_tags/models/tag.php:280
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 4.48 ms Utolsó lekérdezés után: 2.69 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 3.692 MB Visszaadott sorok: 10

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM ukn4s_contentitem_tag_map AS m

  INNER JOIN ukn4s_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2019-08-24 00:13:55')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2019-08-24 00:13:55')

  INNER JOIN ukn4s_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN ukn4s_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN ukn4s_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (2) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	10	50.00	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	ct	NULL	ref	idx_alias	idx_alias	402	keszpenz_new.m.type_alias	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	keszpenz_new.m.core_content_id	1	5.00	Using where
1	SIMPLE	tc	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.c.core_catid	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.c.core_created_user_id	1	100.00	Using where

Profil

Status	Duration
starting	0.10 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.57 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.32 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.08 ms
optimizing	0.05 ms
statistics	0.26 ms
preparing	0.07 ms
Creating tmp table	0.10 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	1.77 ms
Creating sort index	0.26 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.36 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.14 ms
Waiting for query cache lock	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/legacy/model/legacy.php:347
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:55
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.54 ms Utolsó lekérdezés után: 22.46 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 3.878 MB Visszaadott sorok: 38

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `ukn4s_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_foxcontact','com_installer','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper','com_zt_layerslider','com_ztportfolio') OR `parent_id` = 0

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ukn4s_assets	NULL	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	39	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

Profil

Status	Duration
starting	0.17 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.10 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
23	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
22	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
21	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
19	JUser->authorise()	JROOT/administrator/components/com_fields/models/fields.php:231
18	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
17	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Ugyanaz a hívás, mint egy sorral lejjebb.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 2.48 ms Utolsó lekérdezés után: 2.78 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.984 MB Visszaadott sorok: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM ukn4s_fields AS a

  LEFT JOIN `ukn4s_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ukn4s_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ukn4s_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ukn4s_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ukn4s_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_tags.tag' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	keszpenz_new.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.48 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.34 ms
init	0.10 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.07 ms
optimizing	0.05 ms
statistics	0.40 ms
preparing	0.02 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
Waiting for query cache lock	0.02 ms
freeing items	0.32 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Ugyanaz a hívás, mint egy sorral lejjebb.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.48 ms Utolsó lekérdezés után: 41.40 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 4.791 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18

SELECT *

  FROM ukn4s_tags

  WHERE `id` = '2'

Magyarázat

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

Profil

Status	Duration
starting	0.19 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.76 ms
cleaning up	0.04 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_tags/models/tag.php:335
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:198
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 3.06 ms Utolsó lekérdezés után: 0.97 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 4.806 MB

UPDATE ukn4s_tags

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	ukn4s_tags	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.32 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.08 ms
updating	0.23 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	1.18 ms
query end	0.82 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
12	JTable->hit()	JROOT/components/com_tags/models/tag.php:336
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:198
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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.56 ms Utolsó lekérdezés után: 41.06 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 5.005 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 ukn4s_categories as c

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=80

  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	65	23.08	Using where

Profil

Status	Duration
starting	0.15 ms
Waiting for query cache lock	0.07 ms
starting	0.00 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.09 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
26	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
25	JCategories->get()	JROOT/components/com_content/router.php:70
24	ContentRouter->getCategorySegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
23	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:83
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:51
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:202
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 1.41 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 5.058 MB Visszaadott sorok: 24

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 ukn4s_categories as c

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=14

  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Fájlrendezés használata
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	65	23.08	Using where

Profil

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.14 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
26	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
25	JCategories->get()	JROOT/components/com_content/router.php:70
24	ContentRouter->getCategorySegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
23	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:83
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:51
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:202
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 4.70 ms Utolsó lekérdezés után: 21.40 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 5.360 MB Visszaadott sorok: 8

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

  FROM ukn4s_modules AS m

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

  LEFT JOIN ukn4s_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-08-24 00:13:55') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-24 00:13:55') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

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	35	1.60	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	keszpenz_new.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	keszpenz_new.m.id	3	40.00	Using where; Using index

Profil

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	3.65 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	Ugyanaz a hívás, mint egy sorral lejjebb.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
13	JModuleHelper::getModules()	JROOT/plugins/system/zo2/framework/layout.php:60
12	Zo2Layout->reSortRow()	JROOT/plugins/system/zo2/framework/layout.php:109
11	Zo2Layout->getHtml()	Ugyanaz a hívás, mint egy sorral lejjebb.
10	call_user_func()	JROOT/plugins/system/zo2/framework/cache.php:124
9	Zo2Cache->get()	JROOT/plugins/system/zo2/framework/layout.php:38
8	Zo2Layout->render()	JROOT/templates/zo2_explorer/index.php:37
7	require JROOT/templates/zo2_explorer/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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.48 ms Utolsó lekérdezés után: 9.97 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 5.454 MB Visszaadott sorok: 24

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

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

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  AND m.access IN ( 1,1 ) 
  AND m.menutype = 'mainmenu'

  ORDER BY m.lft

Magyarázat

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_menutype	idx_menutype	98	const	37	1.12	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	keszpenz_new.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.38 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.26 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.07 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.16 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/zo2/framework/model/joomla.php:75
19	Zo2ModelJoomla->getMenuItemsByType()	JROOT/plugins/system/zo2/framework/megamenu.php:47
18	Zo2Megamenu->loadMegaMenu()	JROOT/plugins/system/zo2/framework/megamenu.php:39
17	Zo2Megamenu->__construct()	JROOT/plugins/system/zo2/framework/includes/framework.php:539
16	Zo2Framework->displayMegaMenu()	JROOT/plugins/system/zo2/framework/layout.php:572
15	Zo2Layout->_generateColumn()	JROOT/plugins/system/zo2/framework/layout.php:141
14	Zo2Layout->_buildItem()	JROOT/plugins/system/zo2/framework/layout.php:360
13	Zo2Layout->_generateRow()	JROOT/plugins/system/zo2/framework/layout.php:139
12	Zo2Layout->_buildItem()	JROOT/plugins/system/zo2/framework/layout.php:113
11	Zo2Layout->getHtml()	Ugyanaz a hívás, mint egy sorral lejjebb.
10	call_user_func()	JROOT/plugins/system/zo2/framework/cache.php:124
9	Zo2Cache->get()	JROOT/plugins/system/zo2/framework/layout.php:38
8	Zo2Layout->render()	JROOT/templates/zo2_explorer/index.php:37
7	require JROOT/templates/zo2_explorer/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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.27 ms Utolsó lekérdezés után: 105.05 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 6.818 MB Visszaadott sorok: 1

SELECT `alias`

  FROM `ukn4s_content`

  WHERE id = '10'

Magyarázat

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

Profil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking privileges on cached	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:123
17	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Ugyanaz a hívás, mint egy sorral lejjebb.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[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: 0.28 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 6.839 MB Visszaadott sorok: 1

SELECT alias

  FROM ukn4s_content

  WHERE id=10

Magyarázat

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

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/cms/component/router/view.php:241
14	JComponentRouterView->build()	JROOT/libraries/cms/router/site.php:519
13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Ugyanaz a hívás, mint egy sorral lejjebb.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT táblák:

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM ukn4s_contentitem_tag_map AS m 
  INNER JOIN ukn4s_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2019-08-24 00:13:55')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2019-08-24 00:13:55') 
  INNER JOIN ukn4s_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  LEFT JOIN ukn4s_categories AS tc 
  ON tc.id = c.core_catid 
  LEFT JOIN ukn4s_users AS ua 
  ON ua.id = c.core_created_user_id

2 × 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 ukn4s_menu AS m 
  LEFT JOIN ukn4s_extensions AS e 
  ON m.component_id = e.extension_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `ukn4s_extensions`

```
2 × SELECT * 
  FROM ukn4s_tags
```

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 ukn4s_categories as c 
  LEFT JOIN ukn4s_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ukn4s_assets`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM ukn4s_fields AS a 
  LEFT JOIN `ukn4s_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ukn4s_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ukn4s_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ukn4s_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ukn4s_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT alias 
  FROM ukn4s_content

1 × SELECT `alias` 
  FROM `ukn4s_content`

```
1 × SELECT * 
  FROM ukn4s_languages
```

1 × SELECT id, rules 
  FROM `ukn4s_viewlevels

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

1 × SELECT `session_id` 
  FROM `ukn4s_session`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM ukn4s_extensions

1 × SELECT id, home, template, s.params 
  FROM ukn4s_template_styles as s 
  LEFT JOIN ukn4s_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `data` 
  FROM `ukn4s_session`

```
1 × SELECT id 
  FROM `ukn4s_tags`
```

1 × SELECT * 
  FROM `ukn4s_content_types

EGYÉB táblák:

1 × UPDATE ukn4s_tags 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `ukn4s_tags

1 × UPDATE `ukn4s_extensions` 
  SET `params` = '{\"mediaversion\":\"52a00f8551505bd78edc0f8c92708a6a\"}'

1 × INSERT INTO `ukn4s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('gd8dblhfn0tqpvm3qg9f7iak24', 1, '1566605635', 0, '', 0

```
1 × DELETE  
  FROM `ukn4s_session`
```

Antik olaj festmény felvásárlás a Lánchíd Galériában

AZONNAL FIZETÜNK

Festmény értékbecslés kötöttségek nélkül, INGYEN!

FESTMÉNY FELVÁSÁRLÁS

Hagyatékból megmaradt festmény felvásárlás

HAGYATÉKBÓL MEGMARADT FESTMÉNY, FESTMÉNYEK FELVÁSÁRLÁSA

Kádár Béla festményei – igazi vagy hamisítvány?

Kádár Béla festményeinek felvásárlása azonnal, készpénzben!

Régi festmény felvásárlás készpénzért

Régiségek, antik bútor, olajfestmények, porcelánok online értékbecslése

Ingyenes értékbecslés és ajánlatkérés!

GYORS AJÁNLATKÉRÉSÉRT! HÍVJON TELEFONON!

+36 20 319 0292

RÓLUNK

antik régiségek

LÁNCHÍD GALÉRIA

NYITVATARTÁS

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

29 naplózott lekérdezés 65.32 ms

2 duplikátum található!

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

SELECT táblák:

EGYÉB táblák: