Közösségi konzultáció

Az elmúlt egy évben szakemberek bevonásával a nem jogi elismerése (hivatalosan és a köznyelvben: nemváltás, nemváltoztatás), valamint a transz embereket érintő egészségügyi kérdések vonatkozásában azon dolgoztunk, hogy felmérjük, és egy-egy tanulmányban összefoglaljuk a hazai helyzetet, a jogi szabályozást, valamint a kialakult gyakorlatot. A hazai helyzetet mindkét téma vonatkozásában a nemzetközi ajánlások és az alapvető emberi jogi mércék (önrendelkezéshez való jog, tisztességes eljáráshoz való jog stb.) tükrében mutatjuk be. Célunk, hogy szakpolitikai, valamint jogalkalmazói szinten változás, előrelépés történjen ezekben a kérdésekben és fontosnak tartjuk, hogy ezekben a témákban, konzultáljunk veletek is.

Most készült el a nem jogi elismerésére vonatkozó anyag munkaverziója és azt tervezzük, hogy ezt az anyagot a belső csatornáinkon keresztül vitatjuk meg először transz emberekkel, hogy megtaláljuk azokat a problémákat, amelyekben változást szeretnénk elérni, és amelyekben ajánlásokat fogalmazhatnánk meg. Arra kérünk mivel ez egy munkaanyag, hogy ne terjesszétek vagy idézzétek nyilvánosan!

Azt szeretnénk tőletek kérni, hogy olvassátok el, véleményezzétek az anyagot és jelezzétek azokat a pontokat, amelyekkel kapcsolatban esetleg eltérő tapasztalatotok van, vagy máshogy látjátok szeptember 20-ig a Ez az e-mail-cím a szpemrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát. email címen! Köszönjük.

Az anyag az alábbi linken érhető el: A NEM JOGI ELISMERÉSE MAGYARORSZÁGON_2015.09.04._munkaanyag.pdf

Utoljára frissítve: szombat, 12 szeptember 2015 21:26

Kategória: Általános

Tovább a kategóriában: « Nemi kategóriák, transz identitások Transz fogalmak, meghatározások »

Vissza a tetejére

ENGLISH - #LGRforHungary - Call to action page

Transvanilla hírlevél

Nem jogi elismerése

Nem- és névváltoztatás feltételei

COVID-19

Jelentsd a transzfóbiát!

Nemi identitás, nemi önkifejezés miatti erőszak, diszkrimináció? Jelentsd!

Friss (ített) tartalom

Facebook

Transvanilla

Transvanilla - Adó 1% - Adószám: 18288786-1-43

Partnereink, támogatóink

Tagjai vagyunk: TGEU, ILGA, ILGA-EUROPE

Látható transzok

Írj nekünk

E-mail: Ez az e-mail-cím a szpemrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát.

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1615248757,
                "last": 1615248757,
                "now": 1615248757
            },
            "token": "jl4vBrKxFwhJ30pMy0s01vF7bclFOS4M"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            },
            "plg_system_eprivacy_non_eu": false
        },
        "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
        },
        "com_mailto": {
            "links": {
                "fc59243dcde26aca4c724711f15d3abbc7213931": {
                    "link": "https:\/\/transvanilla.hu\/informaciok\/informaciok\/altalanos\/kozossegi-konzultacio",
                    "expiry": 1615248757
                }
            }
        }
    }
}

Profilinformációk

Idő

Memória

Idő: 4.88 ms / 4.88 ms Memória: 0.515 MB / 0.88 MB Application: afterLoad

Idő: 61.48 ms / 66.36 ms Memória: 1.241 MB / 2.12 MB Application: afterInitialise

Idő: 39.32 ms / 105.68 ms Memória: 0.859 MB / 2.98 MB Application: afterRoute

Idő: 0.62 ms / 106.30 ms Memória: 0.024 MB / 3.00 MB Application: beforeRenderComponent com_k2

Idő: 0.51 ms / 106.80 ms Memória: 0.018 MB / 3.02 MB Application: Before Access::preloadComponents (all components)

Idő: 3.96 ms / 110.76 ms Memória: 0.056 MB / 3.08 MB Application: After Access::preloadComponents (all components)

Idő: 0.05 ms / 110.81 ms Memória: -0.003 MB / 3.07 MB Application: Before Access::getAssetRules (id:120 name:com_k2)

Idő: 1.50 ms / 112.31 ms Memória: 0.009 MB / 3.08 MB Application: After Access::getAssetRules (id:120 name:com_k2)

Idő: 579.27 ms / 691.58 ms Memória: 1.168 MB / 4.25 MB Application: afterRenderComponent com_k2

Idő: 5.78 ms / 697.36 ms Memória: 0.014 MB / 4.26 MB Application: afterDispatch

Idő: 22.28 ms / 719.64 ms Memória: 0.261 MB / 4.53 MB Application: beforeRenderModule mod_eprivacy (cookiek)

Idő: 3.24 ms / 722.88 ms Memória: 0.033 MB / 4.56 MB Application: afterRenderModule mod_eprivacy (cookiek)

Idő: 0.12 ms / 723.00 ms Memória: -0.002 MB / 4.56 MB Application: beforeRenderModule mod_k2_content (Friss (ített) tartalom)

Idő: 4224.78 ms / 4947.78 ms Memória: 0.658 MB / 5.21 MB Application: afterRenderModule mod_k2_content (Friss (ített) tartalom)

Idő: 0.12 ms / 4947.90 ms Memória: -0.102 MB / 5.11 MB Application: beforeRenderModule mod_itpfblikebox (Facebook)

Idő: 2.05 ms / 4949.95 ms Memória: 0.025 MB / 5.14 MB Application: afterRenderModule mod_itpfblikebox (Facebook)

Idő: 0.07 ms / 4950.02 ms Memória: 0.009 MB / 5.15 MB Application: beforeRenderModule mod_sp_simple_youtube (Transvanilla - Adó 1% - Adószám: 18288786-1-43)

Idő: 1.36 ms / 4951.38 ms Memória: 0.008 MB / 5.16 MB Application: afterRenderModule mod_sp_simple_youtube (Transvanilla - Adó 1% - Adószám: 18288786-1-43)

Idő: 0.06 ms / 4951.43 ms Memória: -0.003 MB / 5.15 MB Application: beforeRenderModule mod_custom (Partnereink, támogatóink)

Idő: 395.39 ms / 5346.82 ms Memória: 0.019 MB / 5.17 MB Application: afterRenderModule mod_custom (Partnereink, támogatóink)

Idő: 0.07 ms / 5346.89 ms Memória: -0.003 MB / 5.17 MB Application: beforeRenderModule mod_custom (Látható transzok)

Idő: 386.03 ms / 5732.91 ms Memória: 0.003 MB / 5.17 MB Application: afterRenderModule mod_custom (Látható transzok)

Idő: 0.09 ms / 5733.01 ms Memória: -0.000 MB / 5.17 MB Application: beforeRenderModule mod_custom (Írj nekünk)

Idő: 388.93 ms / 6121.93 ms Memória: 0.004 MB / 5.18 MB Application: afterRenderModule mod_custom (Írj nekünk)

Idő: 0.18 ms / 6122.11 ms Memória: 0.003 MB / 5.18 MB Application: beforeRenderModule mod_custom (ENGLISH - #LGRforHungary - Call to action page)

Idő: 0.33 ms / 6122.45 ms Memória: 0.003 MB / 5.18 MB Application: afterRenderModule mod_custom (ENGLISH - #LGRforHungary - Call to action page)

Idő: 0.07 ms / 6122.52 ms Memória: 0.003 MB / 5.19 MB Application: beforeRenderModule mod_acymailing (Transvanilla hírlevél)

Idő: 51.83 ms / 6174.35 ms Memória: 0.476 MB / 5.66 MB Application: afterRenderModule mod_acymailing (Transvanilla hírlevél)

Idő: 0.06 ms / 6174.41 ms Memória: -0.034 MB / 5.63 MB Application: beforeRenderModule mod_custom (Nem jogi elismerése)

Idő: 392.14 ms / 6566.55 ms Memória: 0.003 MB / 5.63 MB Application: afterRenderModule mod_custom (Nem jogi elismerése)

Idő: 0.07 ms / 6566.62 ms Memória: -0.001 MB / 5.63 MB Application: beforeRenderModule mod_custom (COVID-19)

Idő: 0.36 ms / 6566.98 ms Memória: 0.004 MB / 5.63 MB Application: afterRenderModule mod_custom (COVID-19)

Idő: 0.05 ms / 6567.03 ms Memória: 0.002 MB / 5.64 MB Application: beforeRenderModule mod_custom (Jelentsd a transzfóbiát!)

Idő: 0.31 ms / 6567.34 ms Memória: 0.005 MB / 5.64 MB Application: afterRenderModule mod_custom (Jelentsd a transzfóbiát!)

Idő: 5.95 ms / 6573.29 ms Memória: 0.008 MB / 5.65 MB Application: beforeRenderModule mod_custom (Social)

Idő: 0.35 ms / 6573.64 ms Memória: 0.003 MB / 5.65 MB Application: afterRenderModule mod_custom (Social)

Idő: 0.15 ms / 6573.79 ms Memória: -0.001 MB / 5.65 MB Application: beforeRenderModule mod_search (Keresés)

Idő: 2.22 ms / 6576.01 ms Memória: 0.013 MB / 5.66 MB Application: afterRenderModule mod_search (Keresés)

Idő: 21.50 ms / 6597.51 ms Memória: 0.279 MB / 5.94 MB Application: afterRender

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

Memóriahasználat

Adatbázis lekérdezések

94 naplózott lekérdezés 182.61 ms

53 duplikátum található!

2 duplikátum: #8 #9

8 duplikátum: #17 #22 #27 #42 #48 #71 #76 #89

24 duplikátum: #18 #19 #23 #24 #28 #29 #43 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

2 duplikátum: #20 #25

7 duplikátum: #21 #26 #41 #47 #70 #75 #88

2 duplikátum: #34 #35

2 duplikátum: #54 #57

2 duplikátum: #61 #64

2 duplikátum: #62 #65

2 duplikátum: #81 #84

Lekérdezés ideje: 1.51 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.241 MB Visszaadott sorok: 0

SELECT `data`

  FROM `j25_session`

  WHERE `session_id` = X'6534383362656237623431643234383462333738353137623332633266666361'

Magyarázat

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.05 ms
Opening tables	0.12 ms
init	0.06 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.12 ms
executing	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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.70 ms Utolsó lekérdezés után: 0.72 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.256 MB Visszaadott sorok: 0

SELECT `session_id`

  FROM `j25_session`

  WHERE `session_id` = X'6534383362656237623431643234383462333738353137623332633266666361' 
  LIMIT 1

Magyarázat

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
executing	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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: 5.54 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 1.261 MB

INSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6534383362656237623431643234383462333738353137623332633266666361', 1, 1615248757, 0, '', 0)

Magyarázat

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.10 ms
System lock	0.03 ms
update	0.35 ms
Waiting for query cache lock	0.03 ms
update	0.03 ms
end	0.02 ms
query end	4.01 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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.33 ms Utolsó lekérdezés után: 2.05 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.358 MB Visszaadott sorok: 8

SELECT id, rules

  FROM `j25_viewlevels`

Magyarázat

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.11 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.15 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.66 ms Utolsó lekérdezés után: 0.19 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.372 MB Visszaadott sorok: 1

SELECT b.id

  FROM j25_usergroups AS a

  LEFT JOIN j25_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.18 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 6.16 ms Utolsó lekérdezés után: 17.71 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 2.003 MB

UPDATE `j25_extensions`

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

  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	j25_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.19 ms
updating	0.36 ms
end	0.03 ms
Waiting for query cache lock	0.02 ms
end	0.03 ms
query end	4.15 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.95 ms Utolsó lekérdezés után: 10.66 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 2.475 MB Visszaadott sorok: 1

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND alias = 'informaciok'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	ref	category,published	category	2	const	23	10.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.41 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
11	getCategoryProps()	JROOT/components/com_k2/router.php:292
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.34 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.481 MB Visszaadott sorok: 1

Duplikált lekérdezések: #9

SELECT id, alias 
  FROM j25_k2_items 
  WHERE published = 1 
  AND alias = 'kozossegi-konzultacio'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_items	NULL	ref	item	item	2	const	219	10.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	2.94 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:445
11	getItemProps()	JROOT/components/com_k2/router.php:293
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.07 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 2.488 MB Visszaadott sorok: 1

Duplikált lekérdezések: #8

SELECT id, alias 
  FROM j25_k2_items 
  WHERE published = 1 
  AND alias = 'kozossegi-konzultacio'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_items	NULL	ref	item	item	2	const	219	10.00	Using where

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	2.64 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.08 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:445
11	getItemProps()	JROOT/components/com_k2/router.php:316
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.40 ms Utolsó lekérdezés után: 18.23 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 2.965 MB Visszaadott sorok: 20

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

  FROM j25_modules AS m

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

  LEFT JOIN j25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-03-09 00:12:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-09 00:12:37') 
  AND m.access IN (1,1,6) 
  AND m.client_id = 0 
  AND (mm.menuid = 7 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	32	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	tranahu1_transvanilla.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	tranahu1_transvanilla.m.id	2	40.00	Using where; Using index

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.25 ms
preparing	0.16 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	1.65 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.20 ms
cleaning up	0.04 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	Ugyanaz a hívás, mint egy sorral lejjebb.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
14	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:1213
13	T3Template->countModules()	JROOT/plugins/system/jat3/jat3/core/template.php:710
12	T3Template->hasBlock()	JROOT/plugins/system/jat3/jat3/core/template.php:1081
11	T3Template->parseLayout()	JROOT/plugins/system/jat3/jat3/core/template.php:727
10	T3Template->loadLayout()	JROOT/plugins/system/jat3/jat3/core/framework.php:153
9	T3Framework::init_layout()	JROOT/plugins/system/jat3/jat3.php:276
8	plgSystemJAT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.68 ms Utolsó lekérdezés után: 1.87 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.024 MB Visszaadott sorok: 42

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

  FROM `j25_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acym','com_acymailing','com_admin','com_aimysitemap','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_k2','com_kdglossary','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	Using index condition

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.12 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.57 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	1.69 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.08 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.91 ms Utolsó lekérdezés után: 33.98 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.248 MB Visszaadott sorok: 24

SELECT id 
  FROM j25_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,6)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	ref	category,published,access,trash	published	2	const	23	96.00	Using where

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.33 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.17 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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: 0.12 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.255 MB Visszaadott sorok: 1

SELECT * 
  FROM j25_k2_items 
  WHERE id=232 
  LIMIT 0, 1

Magyarázat

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.13 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.12 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.77 ms Utolsó lekérdezés után: 1.59 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.278 MB Visszaadott sorok: 14

SHOW FULL COLUMNS 
  FROM `j25_k2_categories`

Magyarázat

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.32 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.04 ms
Opening tables	0.06 ms
checking permissions	0.16 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
Sending data	0.14 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.10 ms
closing tables	0.03 ms
freeing items	0.16 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
14	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.51 ms Utolsó lekérdezés után: 1.22 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.302 MB Visszaadott sorok: 1

SELECT * 
  FROM j25_k2_categories 
  WHERE id = '1'

Magyarázat

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

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.00 ms Utolsó lekérdezés után: 3.11 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.319 MB Visszaadott sorok: 24

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

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	ref	category,published,access,trash	published	2	const	23	96.00	Using index condition; Using where; Fájlrendezés használata

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.06 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.39 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:897
15	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:252
14	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:54
13	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:68
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.55 ms Utolsó lekérdezés után: 0.31 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.346 MB Visszaadott sorok: 1

Duplikált lekérdezések: #22 #27 #42 #48 #71 #76 #89

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
22	getCategoryProps()	JROOT/components/com_k2/router.php:476
21	getCategoryPath()	JROOT/components/com_k2/router.php:199
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:68
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.45 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.358 MB Visszaadott sorok: 1

Duplikált lekérdezések: #19 #23 #24 #28 #29 #43 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.09 ms
Sending data	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
23	getCategoryProps()	JROOT/components/com_k2/router.php:476
22	getCategoryPath()	JROOT/components/com_k2/router.php:479
21	getCategoryPath()	JROOT/components/com_k2/router.php:199
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:68
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.34 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.369 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #23 #24 #28 #29 #43 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
21	getCategoryProps()	JROOT/components/com_k2/router.php:203
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:68
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.52 ms Utolsó lekérdezés után: 0.33 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.381 MB Visszaadott sorok: 1

Duplikált lekérdezések: #25

SELECT i.id AS id, i.alias AS alias, c.id AS catid, c.alias AS slug
                    
  FROM j25_k2_items AS i
                    
  INNER JOIN j25_k2_categories AS c
                        
  ON i.catid = c.id
                    
  WHERE i.id = 232 
  AND i.published = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	const	PRIMARY,item,catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:445
21	getItemProps()	JROOT/components/com_k2/router.php:126
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.69 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.391 MB Visszaadott sorok: 1

Duplikált lekérdezések: #26 #41 #47 #70 #75 #88

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND alias = 'altalanos'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	ref	category,published	category	2	const	23	10.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.38 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
21	getCategoryProps()	JROOT/components/com_k2/router.php:130
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.32 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.401 MB Visszaadott sorok: 1

Duplikált lekérdezések: #17 #27 #42 #48 #71 #76 #89

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
22	getCategoryProps()	JROOT/components/com_k2/router.php:476
21	getCategoryPath()	JROOT/components/com_k2/router.php:130
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.28 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.412 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #19 #24 #28 #29 #43 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.16 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
23	getCategoryProps()	JROOT/components/com_k2/router.php:476
22	getCategoryPath()	JROOT/components/com_k2/router.php:479
21	getCategoryPath()	JROOT/components/com_k2/router.php:130
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.28 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.424 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #19 #23 #28 #29 #43 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.10 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
21	getCategoryProps()	JROOT/components/com_k2/router.php:134
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:72
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.22 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.435 MB Visszaadott sorok: 1

Duplikált lekérdezések: #20

SELECT i.id AS id, i.alias AS alias, c.id AS catid, c.alias AS slug
                    
  FROM j25_k2_items AS i
                    
  INNER JOIN j25_k2_categories AS c
                        
  ON i.catid = c.id
                    
  WHERE i.id = 232 
  AND i.published = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	const	PRIMARY,item,catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:445
21	getItemProps()	JROOT/components/com_k2/router.php:126
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.45 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.445 MB Visszaadott sorok: 1

Duplikált lekérdezések: #21 #41 #47 #70 #75 #88

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND alias = 'altalanos'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	ref	category,published	category	2	const	23	10.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.36 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
21	getCategoryProps()	JROOT/components/com_k2/router.php:130
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.17 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.455 MB Visszaadott sorok: 1

Duplikált lekérdezések: #17 #22 #42 #48 #71 #76 #89

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.04 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
22	getCategoryProps()	JROOT/components/com_k2/router.php:476
21	getCategoryPath()	JROOT/components/com_k2/router.php:130
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.12 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.466 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #19 #23 #24 #29 #43 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
23	getCategoryProps()	JROOT/components/com_k2/router.php:476
22	getCategoryPath()	JROOT/components/com_k2/router.php:479
21	getCategoryPath()	JROOT/components/com_k2/router.php:130
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.15 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.478 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #19 #23 #24 #28 #43 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
21	getCategoryProps()	JROOT/components/com_k2/router.php:134
20	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/models/item.php:75
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.42 ms Utolsó lekérdezés után: 0.55 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.541 MB Visszaadott sorok: 0

SELECT tag.*
            
  FROM j25_k2_tags AS tag
            JOIN j25_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 232
            
  ORDER BY xref.id ASC

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	tagID,itemID	itemID	4	const	1	100.00	Using index condition; Fájlrendezés használata
1	SIMPLE	tag	NULL	eq_ref	PRIMARY,published	PRIMARY	4	tranahu1_transvanilla.xref.tagID	1	99.54	Using where

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.06 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.06 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.15 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1190
13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:104
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.53 ms Utolsó lekérdezés után: 2.20 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 3.555 MB Visszaadott sorok: 16

SHOW FULL COLUMNS 
  FROM `j25_users`

Magyarázat

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.09 ms
checking permissions	0.02 ms
Opening tables	0.27 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.04 ms
Opening tables	0.06 ms
checking permissions	0.08 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.10 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
Sending data	0.14 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.08 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.40 ms Utolsó lekérdezés után: 0.16 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.584 MB Visszaadott sorok: 1

SELECT *

  FROM `j25_users`

  WHERE `id` = 62

Magyarázat

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.11 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.67 ms Utolsó lekérdezés után: 8.90 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.668 MB Visszaadott sorok: 2

SELECT `g`.`id`,`g`.`title`

  FROM `j25_usergroups` AS g

  INNER JOIN `j25_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 62

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	2	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	tranahu1_transvanilla.m.group_id	1	100.00	NULL

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.26 ms Utolsó lekérdezés után: 0.61 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.678 MB Visszaadott sorok: 0

Duplikált lekérdezések: #35

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM j25_k2_users 
  WHERE userID=62

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
executing	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1668
14	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
13	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:204
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.30 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.685 MB Visszaadott sorok: 0

Duplikált lekérdezések: #34

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM j25_k2_users 
  WHERE userID=62

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
executing	0.04 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.17 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1668
13	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:205
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.21 ms Utolsó lekérdezés után: 29.59 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.825 MB Visszaadott sorok: 0

SELECT DISTINCT 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, g.note as group_note

  FROM j25_fields AS a

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

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

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

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

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

  LEFT JOIN `j25_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (1,0)) 
  AND a.access IN (1,1,6) 
  AND (a.group_id = 0 OR g.access IN (1,1,6)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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; Using temporary; Fájlrendezés használata
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	tranahu1_transvanilla.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	tranahu1_transvanilla.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	tranahu1_transvanilla.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	tranahu1_transvanilla.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	tranahu1_transvanilla.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	tranahu1_transvanilla.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.27 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.17 ms
init	0.15 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.31 ms
preparing	0.10 ms
Creating tmp table	0.14 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.44 ms
Creating sort index	0.11 ms
end	0.03 ms
query end	0.03 ms
removing tmp table	0.09 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.13 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:650
12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.76 ms Utolsó lekérdezés után: 417.42 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.055 MB Visszaadott sorok: 36

SHOW FULL COLUMNS 
  FROM `j25_k2_items`

Magyarázat

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.30 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.04 ms
Opening tables	0.14 ms
checking permissions	0.10 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.10 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
Sending data	0.23 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.09 ms
closing tables	0.03 ms
freeing items	0.17 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
14	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:812
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.78 ms Utolsó lekérdezés után: 0.41 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 4.100 MB

UPDATE j25_k2_items

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

  WHERE `id` = '232'

Magyarázat

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

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.09 ms
updating	0.36 ms
end	0.03 ms
Waiting for query cache lock	0.02 ms
end	0.04 ms
query end	2.81 ms
closing tables	0.17 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:813
12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.52 ms Utolsó lekérdezés után: 0.22 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 4.105 MB Visszaadott sorok: 1

SELECT *
                
  FROM j25_k2_items
                
  WHERE id != 232
                    
  AND catid = 1
                    
  AND ordering > 2
                    
  AND published = 1
                    
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-03-09 00:12:37')
                    
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-03-09 00:12:37')
                    
  AND access IN (1,1,6)
                    
  AND trash = 0
                    
                
  ORDER BY ordering ASC 
  LIMIT 0, 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_items	NULL	range	PRIMARY,item,catid,ordering	ordering	4	NULL	219	0.39	Using index condition; Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.05 ms
statistics	0.22 ms
preparing	0.18 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.50 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1650
12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:305
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.52 ms Utolsó lekérdezés után: 0.42 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.131 MB Visszaadott sorok: 1

SELECT i.id AS id, i.alias AS alias, c.id AS catid, c.alias AS slug
                    
  FROM j25_k2_items AS i
                    
  INNER JOIN j25_k2_categories AS c
                        
  ON i.catid = c.id
                    
  WHERE i.id = 2 
  AND i.published = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	const	PRIMARY,item,catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:445
20	getItemProps()	JROOT/components/com_k2/router.php:126
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:307
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.68 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.141 MB Visszaadott sorok: 1

Duplikált lekérdezések: #21 #26 #47 #70 #75 #88

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND alias = 'altalanos'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	ref	category,published	category	2	const	23	10.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.10 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.32 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
20	getCategoryProps()	JROOT/components/com_k2/router.php:130
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:307
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.40 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.151 MB Visszaadott sorok: 1

Duplikált lekérdezések: #17 #22 #27 #48 #71 #76 #89

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.10 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
21	getCategoryProps()	JROOT/components/com_k2/router.php:476
20	getCategoryPath()	JROOT/components/com_k2/router.php:130
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:307
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.36 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.161 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #19 #23 #24 #28 #29 #44 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
22	getCategoryProps()	JROOT/components/com_k2/router.php:476
21	getCategoryPath()	JROOT/components/com_k2/router.php:479
20	getCategoryPath()	JROOT/components/com_k2/router.php:130
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:307
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.39 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.172 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #19 #23 #24 #28 #29 #43 #49 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.09 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
20	getCategoryProps()	JROOT/components/com_k2/router.php:134
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:307
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.03 ms Utolsó lekérdezés után: 0.35 ms Memória lekérdezése: 0.039 MB memória a lekérdezés előtt: 4.182 MB Visszaadott sorok: 1

SELECT *
                
  FROM j25_k2_items
                
  WHERE id != 232
                    
  AND catid = 1
                    
  AND ordering < 2
                    
  AND published = 1
                    
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-03-09 00:12:37')
                    
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-03-09 00:12:37')
                    
  AND access IN (1,1,6)
                    
  AND trash = 0
                    
                
  ORDER BY ordering DESC 
  LIMIT 0, 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_items	NULL	range	PRIMARY,item,catid,ordering	ordering	4	NULL	20	0.39	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.10 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.10 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.43 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1592
12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:341
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.43 ms Utolsó lekérdezés után: 0.34 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.204 MB Visszaadott sorok: 1

SELECT i.id AS id, i.alias AS alias, c.id AS catid, c.alias AS slug
                    
  FROM j25_k2_items AS i
                    
  INNER JOIN j25_k2_categories AS c
                        
  ON i.catid = c.id
                    
  WHERE i.id = 151 
  AND i.published = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	const	PRIMARY,item,catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:445
20	getItemProps()	JROOT/components/com_k2/router.php:126
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:343
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.61 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.214 MB Visszaadott sorok: 1

Duplikált lekérdezések: #21 #26 #41 #70 #75 #88

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND alias = 'altalanos'

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	ref	category,published	category	2	const	23	10.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.30 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.16 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
20	getCategoryProps()	JROOT/components/com_k2/router.php:130
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:343
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.21 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.224 MB Visszaadott sorok: 1

Duplikált lekérdezések: #17 #22 #27 #42 #71 #76 #89

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

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

Hívási verem

#	Hívó	Fájl és sorok száma
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
21	getCategoryProps()	JROOT/components/com_k2/router.php:476
20	getCategoryPath()	JROOT/components/com_k2/router.php:130
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:343
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.15 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.235 MB Visszaadott sorok: 1

Duplikált lekérdezések: #18 #19 #23 #24 #28 #29 #43 #44 #50 #55 #56 #58 #59 #72 #73 #77 #78 #82 #83 #85 #86 #90 #91

SELECT id, alias, parent 
  FROM j25_k2_categories 
  WHERE published = 1 
  AND id = 2

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_k2_categories	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:468
22	getCategoryProps()	JROOT/components/com_k2/router.php:476
21	getCategoryPath()	JROOT/components/com_k2/router.php:479
20	getCategoryPath()	JROOT/components/com_k2/router.php:130
19	k2BuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_k2/views/item/view.html.php:343
11	K2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:19
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->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.14 ms Utolsó lekérdezés után: 0.11 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.246 MB Visszaadott sorok: 1