A személyes adatait a www.vita-musica.com weboldal (a továbbiakban: Weboldal) üzemeltetője a Vita Musica Kft. (a továbbiakban: Üzemeltető) jogosult kezelni.
Székhely: 2600 Vác, Thomas Edison utca 3.
Cg.: 13-09-189085
Adószám: 26123400-1-13;
Értesítési e-mail cím: Ez az e-mail-cím a szpemrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát.
Telefonszám:
Az adatkezelés és adatfeldolgozás fogalmai, elvei
Az Üzemeltető a rögzített személyes adatokat a mindenkor hatályos adatvédelmi jogszabályokkal – így különösen a 679/2016 sz. Általános Adatvédelmi Rendelettel (GDPR), az információs önrendelkezési jogról és az információszabadságról szóló 2011. évi CXII. törvénnyel (Infotv.), valamint az elektronikus kereskedelmi szolgáltatások, valamint az információs társadalommal összefüggő szolgáltatások egyes kérdéseiről szóló 2001. CVIII. törvény (Ektv.) rendelkezéseivel összhangban kezeli.
A jelen Adatkezelési Tájékoztatóban használt kifejezéseket a GDPR értelmező rendelkezései között meghatározott fogalmak szerint kell értelmezni.
Személyes adat az azonosított vagy azonosítható természetes személyre vonatkozó bármely információ. Azonosítható az a természetes személy, aki közvetlen vagy közvetett módon, különösen valamely azonosító, például név, szám, helymeghatározó adat, online azonosító, vagy a természetes személy testi, fiziológiai, genetikai, szellemi, gazdasági, kulturális vagy szociális azonosságára vonatkozó egy, vagy több tényező alapján azonosítható.
A személyes adatok kezelése alatt a személyes adatokon vagy adatállományokon automatizált vagy nem automatizált módon végzett bármely műveletet vagy műveletek összességét értjük. Adatkezelést jelent a személyes adatok gyűjtése, rögzítése, rendszerezése, tagolása, tárolása, átalakítása vagy megváltoztatása, lekérdezése, a beléjük való betekintés, felhasználása, közlése, továbbítása, terjesztése vagy egyéb módon történő hozzáférhetővé tétele, összehangolása vagy összekapcsolása, korlátozása, törlése, illetve megsemmisítése.
Érintettnek azt a természetes személyt tekintjük, akinek a személyes adatait kezeljük. Ilyen tipikusan a webáruház vásárlója, a hírlevél feliratkozója.
A Üzemeltető, mint a webáruházak üzemeltetője) a jelen Tájékoztató szerinti esetekben (I. pont) kezeli az Érintettek természetes adatait, tehát ezekben az esetekben minősül adatkezelőnek.
Az adatfeldolgozók (II. pont) az Üzemeltető megbízása alapján végeznek adatkezelési műveleteket.
Az Üzemeltető az Érintettek által megadott személyes adatokat nem ellenőrzi, kivéve, ha jelen Tájékoztató másként nem rendelkezik, a megadott személyes adatok megfelelőségéért (és így az azok téves, vagy pontatlan voltából eredő minden jogkövetkezményért) kizárólag az azt megadó személy felel.
Azonban az Üzemeltető törekszik az adatok pontos, teljes, tisztességes és naprakész kezelésére (adatminőség elve). Ezért felhívjuk az Érintetteket, hogy az adatok naprakészségében (tehát például az e-mail címük változása esetén azt közöljék), pontosításában (tehát például, ha a hírlevélben a nevükben elírást látnak, pontosítsák) működjenek közre.
Az adatkezelés és adatfeldolgozás az Üzemeltetőnél kizárólag a jelen tájékoztató I-III. pontjában meghatározott célokkal, időtartammal és jogalappal történik.
A Üzemeltető megteszi a szükséges technikai és szervezési intézkedéseket, és megfelelő eljárási szabályokat alakít ki annak érdekében, hogy biztosítsa a személyes adatok biztonságát az adatkezelés és adatfeldolgozás teljes folyamata során.
|
Amennyiben a www.vita-musica.com weboldalt meglátogatja az alábbi adatkezelésekkel találkozhat. |
||
|
LEVELEZÉS |
Kezelt adatok és adatkezelés: |
A weboldalon keresztül e-mailt küldő neve, email címe |
|
Az adatkezelés célja: |
kapcsolattartás |
|
|
Jogalap: |
önkéntes, előzetes hozzájárulás |
|
|
Időtartam: |
a levelezés végével az e-maileket töröljük |
|
|
REKLÁM FOTÓK |
Kezelt adatok és adatkezelés: |
Fényképen megjelenő természetes személy képe (arca) |
|
Az adatkezelés célja: |
marketing |
|
|
Jogalap: |
önkéntes, előzetes hozzájárulás |
|
|
Időtartam: |
az adatokat az érintett kérésére töröljük |
|
|
NAPLÓZÁS |
Kezelt adatok és adatkezelés: |
IP-cím, Kért aloldal címe, Böngésző típusa, |
|
Az adatkezelés célja: |
oldal fejlesztése |
|
|
Jogalap: |
jogos érdek |
|
|
Időtartam: |
6 hónap |
|
|
Adatfeldolgozó |
Adatok, adatfeldolgozás célja |
Adatkezelés jogalapja |
Időtartam |
|
Google Drive - Google cégem |
Név, mailcím |
Szerződés teljesítése |
a szerződés megszűnését vagy teljesítését követően 5 éves elévülési idő lejárta |
|
3in1 hosting Bt. (www.megacp.com, 3in1host.hu) |
tárhely szolgáltatás, a weboldalon át érkező személyes adatok (lásd: levelezés) |
Szerződés teljesítése |
a szerződés megszűnését vagy teljesítését követően 5 éves elévülési idő lejárta |
|
Naplózás |
IP-cím, Kért aloldal címe, Böngésző típusa, oldal fejlesztése |
Jogos érdek |
6 hónap |
Az Üzemeltető a honlap látogatása során úgynevezett cookie-kat (sütiket) használ. A cookie betűből és számokból álló információcsomag, amit honlapunk az Ön böngészőjének küld el azzal a céllal, hogy elmentse bizonyos beállításait, megkönnyítse a honlapunk használatát és közreműködik abban, hogy néhány releváns, statisztikai jellegű információt gyűjtsünk a látogatóinkról. A cookie-k (sütik) nem tartalmaznak személyes információkat, és nem alkalmasak az egyéni felhasználó azonosítására. A cookie-k (sütik) gyakran olyan egyéni azonosítót tartalmaznak - egy titkos, véletlenül generált számsort - amelyet az Ön eszköze tárol. Néhány cookie (süti) a honlap bezárása után megszűnik, néhány pedig hosszabb időre tárolásra kerül számítógépén.
A cookiek-ról további részletes leírást talál itt: https://en.wikipedia.org/wiki/HTTP_cookie. A weboldal az alábbi cookiekat használja:
|
COOKIE ELNEVEZÉSE |
ADATKEZELÉS CÉLJA, A COOKIE FUNKCIÓJA |
IDŐTARTAMA |
|
fmalertcookies |
Tárolja, hogy felhasználó elfogadta a cookie-k használatát |
30 nap |
|
Google Analytics cookie-jai |
||
|
_ga |
Egyedi azonosítót regisztrál, ami statisztikai adatok gyűjtéséhez használos |
2 év |
|
_gat |
Google Analytics használja a lekérdézések rátájanak szabályzásahoz |
1 perc |
|
_gid |
Egyedi azonosítót regisztrál, ami statisztikai adatok gyűjtéséhez használos |
24 óra |
|
collect |
A felhasználó eszközéről és viselkedéséről küld adatokat Google Analyticsnek |
munkamenet |
|
YouTube cookie-jai |
||
|
GPS |
Egyedi azonosítót regisztrál, hogy engedélyeze felhasználó földrajzi követését mobil eszközon. |
munkamenet |
|
VISITOR_INFO1_LIVE |
A felhasználó szávszélességének mérésére szolgál |
179 nap |
|
YSC |
Egyedi azonosítót regisztrál, hogy megállapítsa, milyen videókat látott a felhasználó |
munkamenet |
|
yt-remote-cast-installed |
A beágyazott YouTube videólejátszó beállításait tárolja |
munkamenet |
|
yt-remote-device-id |
A beágyazott YouTube videólejátszó beállításait tárolja |
munkamenet |
|
yt-remote-fast-check-period |
A beágyazott YouTube videólejátszó beállításait tárolja |
munkamenet |
|
yt-remote-session-app |
A beágyazott YouTube videólejátszó beállításait tárolja |
munkamenet |
|
yt-remote-session-name |
A beágyazott YouTube videólejátszó beállításait tárolja |
munkamenet |
A Weboldalt böngésző látogatókról, érdeklődőkről semmilyen személyes adatot nem gyűjtünk. Böngészéskor mindössze anonim információk kerülnek rögzítésre arról, hogy a látogatók mely aloldalakat tekintik meg, milyen funkciókat használnak vagy próbálnak meg használni. Ezen adatok segítséget nyújtanak az oldal üzemeltetéséhez és továbbfejlesztéséhez, valamint a zökkenőmentes működés fenntartásához.
Az adatok kezelését a táblázatok szerint végezzük, a törlést manuálisan végezzük.
A személyes adatok kezeléséről bármikor ingyenes írásbeli tájékoztatást kérhet adatairól, azok forrásáról, az adatkezelés céljáról, jogalapjáról, időtartamáról, az adatfeldolgozó nevéről, címéről és az (esetleges) adatkezeléssel összefüggő tevékenységéről, továbbá - személyes adatainak továbbítása esetén - az adattovábbítás jogalapjáról és címzettjéről a következő elérhetőségeken:
VITA-MUSICA Nonprofit Korlátolt Felelősségű Társaság
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.
Cím: 2600 Vác, Thomas Edison utca 3.
Az adatok törlését/zárolását vagy helyesbítését is a fenti elérhetőségen kérheti, illetve ugyanitt van lehetősége az adatok kezelése ellen kifogást emelni, valamint az adatkezelésről tájékoztatást kérni, továbbá tiltakozni a személyes adatok kezelése ellen.
A Érintett személyes adatait akkor is törli a Adatkezelő, ha kezelése jogellenes; az adatkezelés célja megszűnt; vagy az adatok tárolásának törvényben meghatározott határideje lejárt; azt a bíróság vagy a Nemzeti Adatvédelmi és Információszabadság Hatóság elrendelte; vagy ha az adatkezelés hiányos vagy téves – és ez az állapot jogszerűen nem orvosolható –, feltéve, hogy a törlést törvény nem zárja ki.
Egyes esetekben a személyes adat idő előtti törlése valamely jogosultságtól való elesést eredményezhet.
Az Érintett hozzáférést kérhet a kezelt személyes adatokhoz, amely a másolat készítését is magában foglalja.
A Szolgáltatás megszűnésével – a jogszabályokban előírt (pl. számviteli) kötelezettségek teljesítéséhez szükséges adatok kivételével – a Adatkezelő törli a konkrét Szolgáltatáshoz kapcsolódóan kezelt személyes adatokat. A Szolgáltatás átnevezése, átalakítása, más Szolgáltatással való egyesítése nem jelenti a Szolgáltatás megszűnését.
Törlés helyett az Adatkezelő zárolja a személyes, ha az Érintett ezt kéri, vagy ha a rendelkezésére álló információk alapján feltételezhető, hogy a törlés sértené a Érintett jogos érdekeit. Az így zárolt személyes adatot kizárólag addig kezeli a Adatkezelő, ameddig fennáll az az adatkezelési cél, amely a személyes adat törlését kizárja.
Tájékoztatjuk, hogy tájékoztatási, illetve törlési, zárolási, helyesbítési kérelmét ezen igények beérkezésétől számított legrövidebb időn belül, de legkésőbb 25 napon belül ingyenesen, írásban teljesítjük. Az adatok a rendszerből teljesen 30 munkanapon belül törlődnek.
Tájékoztatjuk továbbá, hogy a személyes adatok védelméhez való jog érvényesülésének ellenőrzése és elősegítése a Nemzeti Adatvédelmi és Információszabadság Hatóság (1125 Budapest, Szilágyi Erzsébet fasor 22/c) mint független, csak a törvénynek alárendelt Hatóság feladata.
A jogai megsértése esetén az Üzemeltető, illetőleg az adatátvevő ellen a Nemzeti Adatvédelmi és Információszabadság Hatósághoz (1125 Budapest, Szilágyi Erzsébet fasor 22/c), illetve bírósághoz fordulhat. Dönthet úgy, hogy a pert a lakóhelye vagy tartózkodási helye szerinti törvényszék előtt indítja meg.
A jelen adatkezelési szabályzat az Üzemeltető által bármikor módosítható, amelyről hírlevélben tájékoztatunk. A szolgáltatás további használatával, mint felhasználó a megváltozott adatkezelési szabályzatot automatikusan tudomásul veszi, ezen túlmenően a beleegyezésedre nincs szükség.
Vác, 2018. május 25.
VITA MUSICA Kft.
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1725764510,
"last": 1725764510,
"now": 1725764510
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"plg_system_languagefilter": {
"language": "hu-HU"
}
}
}
SELECT `data`
FROM `jvm_session`
WHERE `session_id` = X'67313867666d6d6735666f6862363966766a6d36396c766534353175676c766d'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.12 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.06 ms |
| init | 0.04 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| executing | 0.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | 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:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 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:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `jvm_session`
WHERE `session_id` = X'67313867666d6d6735666f6862363966766a6d36396c766534353175676c766d'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|---|
| starting | 0.07 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.05 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.02 ms |
| # | 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:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 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:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
INSERT INTO `jvm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `jvm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'67313867666d6d6735666f6862363966766a6d36396c766534353175676c766d', 1, 1725764510, 0, '', 0)
VALUES (X'67313867666d6d6735666f6862363966766a6d36396c766534353175676c766d', 1, 1725764510, 0, '', 0)
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.03 ms |
| update | 1.74 ms |
| Waiting for query cache lock | 0.03 ms |
| update | 0.03 ms |
| end | 0.02 ms |
| query end | 3.48 ms |
| closing tables | 0.05 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | 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:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 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:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jvm_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | ref | extension | extension | 82 | const | 38 | 1.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.10 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.12 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.35 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.08 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, rules
FROM `jvm_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_viewlevels | NULL | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.03 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.08 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | 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:318 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT b.id
FROM jvm_usergroups AS a
LEFT JOIN jvm_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.10 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| init | 0.05 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.06 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | 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:318 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jvm_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | ref | extension | extension | 82 | const | 96 | 0.60 | Using index condition; Using where; Fájlrendezés használata |
| Status | Duration |
|---|---|
| starting | 0.10 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.09 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.09 ms |
| preparing | 0.05 ms |
| Sorting result | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.91 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jvm_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_languages | NULL | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | 50.00 | Using where; Fájlrendezés használata |
| Status | Duration |
|---|---|
| starting | 0.08 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.03 ms |
| preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.10 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Language/LanguageHelper.php:67 |
| 4 | Joomla\CMS\Language\LanguageHelper::detectLanguage() | JROOT/libraries/src/Application/SiteApplication.php:653 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT template
FROM jvm_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | ALL | idx_client_id,idx_client_id_home | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 7 | 14.29 | Using where |
| 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.09 ms |
| preparing | 0.03 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.09 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT template
FROM jvm_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | ALL | idx_client_id,idx_client_id_home | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 7 | 14.29 | Using where |
| Status | Duration |
|---|---|
| starting | 0.09 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.06 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.13 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT extension, file, type
FROM jvm_rokcommon_configs
ORDER BY priority
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_rokcommon_configs | NULL | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | 100.00 | Fájlrendezés használata |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.03 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.07 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.12 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jvm_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | ref | extension | extension | 82 | const | 4 | 1.25 | Using where |
| Status | Duration |
|---|---|
| starting | 0.09 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.09 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.09 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
| 8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 |
| 7 | PlgSystemLanguageFilter->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:667 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNSAz EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `jvm_extensions`
FROM `jvm_extensions`
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.30 ms |
| init | 0.03 ms |
| System lock | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.03 ms |
| Opening tables | 0.08 ms |
| checking permissions | 0.07 ms |
| checking permissions | 0.03 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.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 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.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending data | 0.14 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| removing tmp table | 0.07 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 11 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Extension.php:32 |
| 10 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 9 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 |
| 8 | plgSystemRokSprocket->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id`
FROM `jvm_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.09 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.14 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.12 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:47 |
| 8 | plgSystemRokSprocket->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jvm_extensions
WHERE `extension_id` = '10004'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 |
| 8 | plgSystemRokSprocket->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id`
FROM `jvm_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.16 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.06 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:70 |
| 8 | plgSystemRokSprocket->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jvm_extensions
WHERE `extension_id` = '10004'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| optimizing | 0.06 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:747 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:76 |
| 8 | plgSystemRokSprocket->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jvm_menu AS m
LEFT JOIN jvm_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 33 | 3.33 | Using index condition; Using where; Fájlrendezés használata |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | vitamusi_db.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.14 ms |
| checking permissions | 0.07 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.11 ms |
| preparing | 0.05 ms |
| Sorting result | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.04 ms |
| Creating sort index | 0.63 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
| 20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 |
| 17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 |
| 15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 |
| 14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 |
| 10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
| 8 | PlgSystemLanguageFilter->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:668 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT *
FROM jvm_rokcandy
WHERE published=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_rokcandy | NULL | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 8 | 12.50 | Using where |
| Status | Duration |
|---|---|
| starting | 0.09 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.04 ms |
| init | 0.05 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.10 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 |
| 13 | RokCandyHelper::getUserMacros() | Ugyanaz a hívás, mint egy sorral lejjebb. |
| 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 10 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 |
| 9 | RokCandyHelper::getMacros() | JROOT/plugins/system/rokcandy/rokcandy.php:28 |
| 8 | plgSystemRokCandy->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:1190 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM jvm_template_styles as s
LEFT JOIN jvm_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | 1.00 | Using index condition; Using where |
| 1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | vitamusi_db.e.element | 1 | 71.43 | Using index condition; Using where |
| Status | Duration |
|---|---|
| starting | 0.11 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.06 ms |
| System lock | 0.03 ms |
| optimizing | 0.10 ms |
| statistics | 0.15 ms |
| preparing | 0.06 ms |
| executing | 0.02 ms |
| Sending data | 0.15 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.13 ms |
| cleaning up | 0.03 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 15 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53 |
| 14 | RokCandyHelper::readIniFile() | Ugyanaz a hívás, mint egy sorral lejjebb. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44 |
| 10 | RokCandyHelper::getTemplateOverrides() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18 |
| 9 | RokCandyHelper::getMacros() | JROOT/plugins/system/rokcandy/rokcandy.php:28 |
| 8 | plgSystemRokCandy->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:1190 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jvm_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
| 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.12 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.07 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Ugyanaz a hívás, mint egy sorral lejjebb. |
| 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE `jvm_extensions`
SET `params` = '{\"mediaversion\":\"0549fa88b0adc3937ddf0e57e57f10ed\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | jvm_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.11 ms |
| updating | 0.15 ms |
| end | 0.02 ms |
| Waiting for query cache lock | 0.02 ms |
| end | 0.03 ms |
| query end | 2.23 ms |
| closing tables | 0.09 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jvm_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rokcandy','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 39 | 100.00 | Using index condition |
| Status | Duration |
|---|---|
| starting | 0.13 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.15 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.26 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.77 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.03 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jvm_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_assets | NULL | ALL | idx_asset_name,idx_parent_id | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 416 | 25.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.10 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.79 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
| 11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 |
| 10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SHOW FULL COLUMNSAz EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `jvm_content`
FROM `jvm_content`
| Status | Duration |
|---|---|
| starting | 0.06 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.21 ms |
| init | 0.03 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.03 ms |
| Opening tables | 0.05 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.09 ms |
| checking permissions | 0.04 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 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.03 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.02 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.03 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| Sending data | 0.18 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| removing tmp table | 0.06 ms |
| closing tables | 0.06 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
| 11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
UPDATE jvm_content
SET `hits` = (`hits` + 1)
WHERE `id` = '136'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UPDATE | jvm_content | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| init | 0.04 ms |
| System lock | 0.07 ms |
| updating | 0.40 ms |
| end | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| end | 0.04 ms |
| query end | 2.48 ms |
| closing tables | 0.04 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.07 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
| 10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
| 9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jvm_content AS a
INNER JOIN jvm_categories AS c
on c.id = a.catid
LEFT JOIN jvm_users AS u
on u.id = a.created_by
LEFT JOIN jvm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jvm_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 136
AND c.published > 0
AND a.language in ('hu-HU','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-08 03:01:50')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-08 03:01:50')
AND (a.state = 1 OR a.state =2)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state,idx_catid,idx_language | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | u | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | v | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|---|
| starting | 0.32 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.08 ms |
| init | 0.14 ms |
| System lock | 0.03 ms |
| optimizing | 0.05 ms |
| statistics | 0.24 ms |
| preparing | 0.05 ms |
| executing | 0.02 ms |
| Sending data | 0.18 ms |
| end | 0.03 ms |
| query end | 0.07 ms |
| closing tables | 0.03 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
| 12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `m`.`tag_id`,`t`.*
FROM `jvm_contentitem_tag_map` AS m
INNER JOIN `jvm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 136
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 1 | 100.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | vitamusi_db.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.11 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| init | 0.07 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| preparing | 0.10 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.09 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jvm_categories` AS `s`
INNER JOIN `jvm_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('hu-HU','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 15
ORDER BY c.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | NULL | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | 100.00 | Fájlrendezés használata |
| 1 | SIMPLE | c | NULL | ALL | cat_idx,idx_access,idx_left_right,idx_language | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 15 | 28.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.24 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.10 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.21 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| Creating sort index | 0.15 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.14 ms |
| cleaning up | 0.03 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
| 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
| 18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:203 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:140 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
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 jvm_fields AS a
LEFT JOIN `jvm_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jvm_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jvm_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jvm_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jvm_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jvm_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (15,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
AND a.language in ('*','hu-HU')
ORDER BY a.ordering ASC
| 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_language,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 | vitamusi_db.a.language | 1 | 100.00 | Using where |
| 1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | vitamusi_db.a.checked_out | 1 | 100.00 | NULL |
| 1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | vitamusi_db.a.access | 1 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | vitamusi_db.a.created_user_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | vitamusi_db.a.group_id | 1 | 100.00 | Using where |
| 1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | vitamusi_db.a.id | 1 | 100.00 | Using where; Using index; Distinct |
| Status | Duration |
|---|---|
| starting | 0.23 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.10 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.12 ms |
| init | 0.14 ms |
| System lock | 0.03 ms |
| optimizing | 0.05 ms |
| statistics | 0.25 ms |
| preparing | 0.07 ms |
| Creating tmp table | 0.09 ms |
| Sorting result | 0.03 ms |
| executing | 0.02 ms |
| Sending data | 0.36 ms |
| Creating sort index | 0.07 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| removing tmp table | 0.07 ms |
| query end | 0.02 ms |
| closing tables | 0.04 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.03 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `jvm_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 639
AND (contact.language in ('hu-HU','*') OR contact.language IS NULL)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | contact | NULL | ref | idx_state,idx_language | idx_state | 1 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|---|
| starting | 0.11 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| init | 0.07 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.09 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.05 ms |
| end | 0.02 ms |
| query end | 0.03 ms |
| closing tables | 0.02 ms |
| freeing items | 0.09 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 15 | JDatabaseDriver->loadObject() | JROOT/plugins/content/contact/contact.php:125 |
| 14 | PlgContentContact->getContactData() | JROOT/plugins/content/contact/contact.php:66 |
| 13 | PlgContentContact->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
| 10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT language,id
FROM `jvm_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | jvm_menu | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 27 | 1.49 | Using where |
| Status | Duration |
|---|---|
| starting | 0.09 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| init | 0.04 ms |
| System lock | 0.09 ms |
| optimizing | 0.03 ms |
| statistics | 0.10 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.18 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
| 8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `c2`.`language`,`c2`.`id`
FROM `jvm_menu` AS `c`
INNER JOIN `jvm_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jvm_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jvm_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 278
| 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 |
| Status | Duration |
|---|---|
| starting | 0.10 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.15 ms |
| init | 0.06 ms |
| System lock | 0.03 ms |
| optimizing | 0.03 ms |
| statistics | 0.13 ms |
| executing | 0.03 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.13 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
| 8 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:768 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jvm_content` AS `c`
INNER JOIN `jvm_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `jvm_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jvm_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jvm_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 136
AND c2.access IN (1,1,5)
AND c2.language != 'hu-HU'
AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-09-08 03:01:50')
AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-09-08 03:01:50')
AND c2.state = 1
| 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 |
| Status | Duration |
|---|---|
| starting | 0.23 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.06 ms |
| init | 0.10 ms |
| System lock | 0.03 ms |
| optimizing | 0.05 ms |
| statistics | 0.24 ms |
| executing | 0.04 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 9 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/components/com_content/helpers/association.php:76 |
| 8 | ContentHelperAssociation::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:783 |
| 7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
| 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:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jvm_modules AS m
LEFT JOIN jvm_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jvm_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-09-08 03:01:50')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-08 03:01:50')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 278 OR mm.menuid <= 0)
AND m.language IN ('hu-HU','*')
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 47 | 1.22 | Using index condition; Using where; Fájlrendezés használata |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | vitamusi_db.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | vitamusi_db.m.id | 1 | 40.00 | Using where; Using index |
| Status | Duration |
|---|---|
| starting | 0.16 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| init | 0.10 ms |
| System lock | 0.03 ms |
| optimizing | 0.04 ms |
| statistics | 0.22 ms |
| preparing | 0.07 ms |
| Sorting result | 0.10 ms |
| executing | 0.02 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.78 ms |
| end | 0.03 ms |
| query end | 0.03 ms |
| closing tables | 0.07 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.02 ms |
| # | Hívó | Fájl és sorok száma |
|---|---|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | Ugyanaz a hívás, mint egy sorral lejjebb. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
| 11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
| 10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 |
| 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/max/index.php:99 |
| 7 | require JROOT/templates/max/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jvm_extensions`
2 × SELECT template
FROM jvm_template_styles as s
2 × SELECT `extension_id`
FROM `jvm_extensions`
2 × SELECT *
FROM jvm_extensions
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jvm_assets`
1 × SELECT `data`
FROM `jvm_session`
1 × SELECT `session_id`
FROM `jvm_session`
1 × SELECT id, rules
FROM `jvm_viewlevels
1 × SELECT b.id
FROM jvm_usergroups AS a
LEFT JOIN jvm_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jvm_extensions
1 × SELECT *
FROM jvm_languages
1 × SELECT extension, file, type
FROM jvm_rokcommon_configs
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jvm_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jvm_menu AS m
LEFT JOIN jvm_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM jvm_rokcandy
1 × SELECT id, home, template, s.params
FROM jvm_template_styles as s
LEFT JOIN jvm_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jvm_content AS a
INNER JOIN jvm_categories AS c
on c.id = a.catid
LEFT JOIN jvm_users AS u
on u.id = a.created_by
LEFT JOIN jvm_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jvm_content_rating AS v
ON a.id = v.content_id
1 × SELECT `m`.`tag_id`,`t`.*
FROM `jvm_contentitem_tag_map` AS m
INNER JOIN `jvm_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jvm_categories` AS `s`
INNER JOIN `jvm_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('hu-HU','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
1 × 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 jvm_fields AS a
LEFT JOIN `jvm_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jvm_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jvm_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jvm_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jvm_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jvm_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `jvm_contact_details` AS `contact`
1 × SELECT language,id
FROM `jvm_menu`
1 × SELECT `c2`.`language`,`c2`.`id`
FROM `jvm_menu` AS `c`
INNER JOIN `jvm_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `jvm_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jvm_menu` AS `c2`
ON a2.id = c2.`id`
1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `jvm_content` AS `c`
INNER JOIN `jvm_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `jvm_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `jvm_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `jvm_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jvm_modules AS m
LEFT JOIN jvm_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jvm_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × INSERT INTO `jvm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'67313867666d6d6735666f6862363966766a6d36396c766534353175676c766d', 1, 1725764510, 0, '', 0
1 × SHOW FULL COLUMNS
FROM `jvm_extensions
1 × UPDATE `jvm_extensions`
SET `params` = '{\"mediaversion\":\"0549fa88b0adc3937ddf0e57e57f10ed\"}'
1 × SHOW FULL COLUMNS
FROM `jvm_content
1 × UPDATE jvm_content
SET `hits` = (`hits` + 1)