2021. április 22. 8:00 - 2021. május 2. 23:59
11. Frankofón Filmnapok - Online - FB esemény
2021. április 22. 8:00 - 2021. május 2. 23:59
11. Frankofón Filmnapok - Online - FB esemény
--------------- ONLINE ---------------
2021. árilis 28, szerda, 20:15
Rendező : Damien O'Donnell (1999)
„Ez a felhős bolygó a Föld. Az otthonunk.” – hangzik el a film talán legfeszültebb pillanatában. Ám hogyan lehet otthon az, ahová egyszer, sok évtizeddel ezelőtt menekültek, s ahonnan a menekültek utódai elmenekülnek. Ahol szokások, hagyományok, kényszerek ütköznek az új otthon szokásaival, az új generáció igényeivel? Ebből az 1999-ben bemutatott filmből, amelynek helyszíne véletlenül ugyanaz a Salford, mint az Egy csepp mézé volt, hiányzik minden, ami dögössé tesz egy mozit manapság. Se szürreális víziók, se lassított ugrások, high-tech pörgés vagy fekete utópia. A történet egy vegyes – pakisztáni és angol – házaspárról és gyerekeiről szól, köznapi emberek vívódásairól. Ha akarod komoly, ha akarod vidám. Igaz, hogy emiatt nem is fog elévülni egyhamar. Már csak azért sem, mert a Magyarországról külföldre mentek közül egyre többen alakítanak kint családot, és a gyerekeik már nem fognak kötődni az óhazához.
a film bármikor megtekinthető előtte itt:
Join Zoom Meeting
Moderátor: Cs. Kádár Péter
Várunk szeretettel a MagyarDipló szerkesztősége és a MÚOSZ Kulturális Szakosztálya nevében
Morva Judit és Vámos Éva
akinek még nincs letöltve a zoom, itt letölthető:
https://hu.wizcase.com/download/zoom/
- CINEMA CLUB ONLINE avec Magyardipló et UPF-Hongrie -
Invitation pour le mercredi 5 mai, à 20h15
Les Harmonies Werckmeister
Béla Tarr (2001)
Les Harmonies Werckmeister (Werckmeister harmóniák) est le neuvième long métrage (sorti en 2001) du réalisateur Béla Tarr, l'un des plus grands cinéastes de notre époque et figure de proue du cinéma hongrois. Ce film (en noir et blanc) s'inspire d'un roman, publié en 1989, de son collaborateur permanent László Krasznahorkai: La Mélancolie de la résistance (Az ellenállás melankóliája, traduction française: Gallimard, 2006). La production tournée dans une petite ville hongroise de la Grande Plaine (Baja), a été réalisée en collaboration internationale (dont des acteurs de renommée mondiale comme Hanna Schygulla, Lars Rudolph et Peter Fritz).
L'action se déroulant dans un bourg obscur, est pourtant conçue dans plusieurs dimensions, elle est située dans un contexte universel, le mécanisme des astres. Elle évoque, entre autres, un fait intéressant: la tournée européenne (en 1961) d'une baleine gigantesque qu'on avait promenée en Hongrie aussi et qui a suscité un grand intérêt et a engendré des rumeurs étranges dans toute l'Europe.
Le titre du film fait référence à un théoricien allemand de la musique baroque peu connue de notre temps, Andreas Werckmeister (1645-1706) qui a élaboré une thèse des principes d'harmonie sur les modalités de l'accordage des instruments à cordes frappées (dont le clavecin et le piano). Le problème qu'un personnage central, György Eszter expose dans le film a été traité par Bach aussi qui l'a illustré par le Clavier bien tempéré (Das Wohltemperiertes Klavier I-II, 1722, 1744), mais sa conception dépasse largement le cadre musical. Il en fait la source de tous les maux du monde et se propose de constituer une nouvelle théorie et pratique de l'accord et de l'harmonie, valable pour tout le cosmos.
A voir le film sur ce lien:
https://www.youtube.com/watch?v=gMGUWl7HP5Y&t=5892s
sous-titrage en anglais avec possibilité de sous-titrage automatique en français
Participer à la réunion Zoom
Le film sera présenté par
Ilona Kovács
Vous êtes cordialement invités par Éva Vámos
MagyarDipló et UPF-Hongrie
pour ceux qui n’ont pas encore le zoom:
https://hu.wizcase.com/download/zoom/
Tweet |
A magyar változat
szerkesztőségének
e-mail címe:
info@magyardiplo.hu
A rendszer használata közben bizonyos esetekben Önnel kapcsolatos adatokat kezelünk és adatokat (cookie -kat) tárolunk az Ön gépén. Erreől itt olvashat részletesebben. A vonatkozó rendelkezések értemében (lásd itt) mindehez az Ön hozzájárulása szükséges. Hozzájárulok
{ "__default": { "session": { "counter": 1, "timer": { "start": 1619162070, "last": 1619162070, "now": 1619162070 }, "token": "U5zZ8FFGwoMPMCW1Jzo2XZz5nvlelPYW" }, "registry": { "plg_system_eprivacy_non_eu": false }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "com_mailto": { "links": { "4a56ca98bc99967af167f566966719cbe4635b79": { "link": "http:\/\/www.magyardiplo.hu\/2013-februar\/125-le-monde-diplomatique\/kulturalis-programajanlo\/2990-11-frankofon-filmnapok-iv-22-v-2.html", "expiry": 1619162071 }, "1131d00cb89d1ac4ba4b630dc4a28c17ebe8f3e2": { "link": "http:\/\/www.magyardiplo.hu\/2013-februar\/125-le-monde-diplomatique\/kulturalis-programajanlo\/2989-filmklub-2021-aprilis-28-a-kelet-az-kelet-1999.html", "expiry": 1619162071 }, "4e08fe9b5f769dcafec142b0ea425b3e27b3529b": { "link": "http:\/\/www.magyardiplo.hu\/2013-februar\/125-le-monde-diplomatique\/kulturalis-programajanlo\/2988-cinema-club-online-les-harmonies-werckmeister-5-mai-2021.html", "expiry": 1619162071 } } } } }
DELETE
FROM `j3_session`
WHERE `time` < '1619161167'
Status | Duration |
---|---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
init | 0.07 ms |
updating | 1483.16 ms |
end | 0.04 ms |
Waiting for query cache lock | 1.50 ms |
end | 0.05 ms |
query end | 1831.92 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.01 ms |
logging slow query | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Application/CMSApplication.php:824 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
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:415 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:48 |
SELECT `data`
FROM `j3_session`
WHERE `session_id` = 'ngi6964lvq75lk1suc8c9gp641'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_session | const | PRIMARY | PRIMARY | 766 | const | 1 |
Status | Duration |
---|---|
starting | 0.03 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
freeing items | 0.00 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Same as call in the line below. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:831 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
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:415 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:48 |
SELECT `session_id`
FROM `j3_session`
WHERE `session_id` = 'ngi6964lvq75lk1suc8c9gp641'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 2.16 ms |
init | 0.01 ms |
checking query cache for query | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.00 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.00 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
7 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Application/CMSApplication.php:178 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:833 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
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:415 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:48 |
INSERT INTO `j3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('ngi6964lvq75lk1suc8c9gp641', 1, '1619162070', 0, '', 0)
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
Table lock | 0.00 ms |
init | 0.01 ms |
update | 0.04 ms |
Waiting for query cache lock | 0.60 ms |
update | 0.30 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.00 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Application/CMSApplication.php:218 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:833 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:133 |
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:415 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:48 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j3_extensions`
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_extensions | ref | extension | extension | 82 | const | 40 | Using index condition |
Status | Duration |
---|---|
starting | 0.03 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.16 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.00 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:422 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
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:430 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:496 |
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:596 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT id, rules
FROM `j3_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_viewlevels | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 5 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 1.00 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
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:310 |
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:606 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT b.id
FROM j3_usergroups AS a
LEFT JOIN j3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 3 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.23 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
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:310 |
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:606 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM j3_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 | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_extensions | ref | extension | extension | 82 | const | 117 | Using index condition; Using where; Fájlrendezés használata |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 1.20 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
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:348 |
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:606 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `j3_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.58 ms |
init | 0.01 ms |
checking query cache for query | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.00 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.05 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.00 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.07 ms |
updating status | 0.01 ms |
storing result in query cache | 0.75 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
17 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
16 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
13 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
12 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
11 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/eprivacy/eprivacy.php:60 |
7 | plgSystemePrivacy->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
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:685 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"93daa829487f2e6881e8a9f13f42f576\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
init | 0.64 ms |
updating | 471.50 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.02 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
12 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
11 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/eprivacy/eprivacy.php:60 |
7 | plgSystemePrivacy->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:272 |
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:685 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `component`
FROM `j3_tortags_components`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 |
Status | Duration |
---|---|
starting | 0.03 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
11 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/tortags/tortags.php:386 |
10 | plgSystemtortags->getAlloweComponents() | JROOT/plugins/system/tortags/tortags.php:159 |
9 | plgSystemtortags->onAfterInitialise() | Same as call in the line below. |
8 | call_user_func_array() | 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:686 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM j3_menu AS m
LEFT JOIN j3_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 185 | Using index condition; Using where; Fájlrendezés használata |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.m.component_id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.00 ms |
checking query cache for query | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.04 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sorting result | 0.66 ms |
Sending data | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.08 ms |
Waiting for query cache lock | 0.00 ms |
Sending data | 1.09 ms |
Waiting for query cache lock | 0.02 ms |
Sending data | 0.27 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.09 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.09 ms |
Waiting for query cache lock | 0.00 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.44 ms |
Waiting for query cache lock | 0.01 ms |
updating status | 0.00 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
22 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
21 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
20 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
19 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
18 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
17 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
16 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:446 |
15 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
14 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
13 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
12 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:551 |
11 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
10 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/jumirouter/jumirouter.php:36 |
9 | plgSystemJumiRouter->onAfterInitialise() | Same as call in the line below. |
8 | call_user_func_array() | 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:686 |
4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
select id, title, alias
from j3_jumi
where published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_jumi | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 6 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1801 |
12 | JDatabaseDriver->loadRowList() | JROOT/plugins/system/jumirouter/jumirouter.php:57 |
11 | parseJumiRouter() | Same as call in the line below. |
10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:593 |
8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1147 |
4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM j3_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_languages | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 1 | Using where; Fájlrendezés használata |
Status | Duration |
---|---|
starting | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT id, home, template, s.params
FROM j3_template_styles as s
LEFT JOIN j3_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | ALL | idx_template | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 6 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | diplohu_j25.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j3_assets`
WHERE `name` IN ('root.1','com_acymailing','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_joomlaupdate','com_jumi','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_securitycheck','com_tags','com_templates','com_tortags','com_users','com_wrapper')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 40 | Using index condition |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `id`,`name`,`rules`,`parent_id`
FROM `j3_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_assets | ALL | idx_asset_name,idx_parent_id | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 1984 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.02 ms |
sending cached result to clien | 0.06 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SHOW FULL COLUMNS
FROM `j3_assets`
Status | Duration |
---|---|
starting | 0.05 ms |
checking permissions | 0.00 ms |
closing tables | 0.00 ms |
Opening tables | 0.21 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.00 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.05 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
freeing items | 0.01 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:430 |
21 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
20 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
19 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Asset.php:61 |
18 | Joomla\CMS\Table\Asset->__construct() | JROOT/libraries/src/Access/Access.php:783 |
17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM j3_assets
WHERE `name` = 'com_content.category.125'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM j3_assets
WHERE `name` = 'com_content.category.125'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.00 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM j3_categories as c
LEFT JOIN j3_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `j3_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id=125
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; Fájlrendezés használata |
1 | SIMPLE | c | ALL | cat_idx,idx_left_right | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 233 | Using where |
1 | SIMPLE | i | ref | idx_state,idx_catid | idx_catid | 4 | diplohu_j25.c.id | 5 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.11 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.04 ms |
init | 0.06 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.00 ms |
Unlocking tables | 0.03 ms |
executing | 0.00 ms |
Creating tmp table | 0.30 ms |
Copying to tmp table | 1.39 ms |
Sorting result | 0.04 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
removing tmp table | 0.07 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.00 ms |
storing result in query cache | 0.02 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM j3_assets
WHERE `name` = 'com_content.category.125'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1455 |
19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:730 |
18 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Access/Access.php:784 |
17 | Joomla\CMS\Access\Access::getAssetId() | JROOT/libraries/src/Access/Access.php:544 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:364 |
13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 125
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-23 07:14:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-23 07:14:31')
ORDER BY a.ordering, a.created
LIMIT 101
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using temporary; Fájlrendezés használata |
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 434 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.created_by | 1 | Using where |
1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.modified_by | 1 | Using where |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.14 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.05 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.04 ms |
init | 0.06 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.00 ms |
Unlocking tables | 0.04 ms |
executing | 0.00 ms |
Creating tmp table | 0.30 ms |
Copying to tmp table | 2.18 ms |
Sorting result | 0.04 ms |
Sending data | 0.06 ms |
Waiting for query cache lock | 0.00 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
removing tmp table | 0.09 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.84 ms |
Waiting for query cache lock | 0.01 ms |
updating status | 0.00 ms |
storing result in query cache | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:556 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `m`.`tag_id`,`t`.*
FROM `j3_contentitem_tag_map` AS m
INNER JOIN `j3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 2990
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 138 | Using where |
1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | diplohu_j25.t.id | 7 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:682 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `m`.`tag_id`,`t`.*
FROM `j3_contentitem_tag_map` AS m
INNER JOIN `j3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 2989
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 138 | Using where |
1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | diplohu_j25.t.id | 7 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:682 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `m`.`tag_id`,`t`.*
FROM `j3_contentitem_tag_map` AS m
INNER JOIN `j3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 2988
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 138 | Using where |
1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | diplohu_j25.t.id | 7 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:682 |
14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT COUNT(*)
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 125
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-23 07:14:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-23 07:14:31')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 434 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.08 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.06 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.04 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.00 ms |
Unlocking tables | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.98 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.01 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.00 ms |
storing result in query cache | 1.42 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 |
16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 |
13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `m`.`tag_id`,`t`.*
FROM `j3_contentitem_tag_map` AS m
INNER JOIN `j3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 125
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 138 | Using where |
1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | diplohu_j25.t.id | 7 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:226 |
11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
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 j3_categories as c
LEFT JOIN j3_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=125
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Fájlrendezés használata |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 233 | Using where |
Status | Duration |
---|---|
starting | 0.03 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
20 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
19 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
18 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
17 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:400 |
14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM j3_fields AS a
LEFT JOIN `j3_languages` AS l
ON l.lang_code = a.language
LEFT JOIN j3_users AS uc
ON uc.id=a.checked_out
LEFT JOIN j3_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN j3_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN j3_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `j3_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 (125,0,141))
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)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Fájlrendezés használata |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | diplohu_j25.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.id | 1 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
18 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
17 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
15 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:400 |
14 | PlgSystemFields->onContentPrepare() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `component`
FROM `j3_tortags_components`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.28 ms |
init | 0.01 ms |
checking query cache for query | 0.00 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
16 | JDatabaseDriver->loadColumn() | JROOT/plugins/content/tortags/tortags.php:229 |
15 | plgContentTorTags->getAlloweComponents() | JROOT/plugins/content/tortags/tortags.php:181 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `id`
FROM `j3_tortags_components`
WHERE `component`='com_content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.00 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/content/tortags/tortags.php:278 |
15 | plgContentTorTags->getOidByOption() | JROOT/plugins/content/tortags/tortags.php:187 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=2990
AND `m`.`oid`=1
AND `t`.`published`=1
ORDER BY `t`.`title` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2446 | Using where; Using temporary; Fájlrendezés használata |
1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.m.tid | 1 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.05 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Creating tmp table | 0.02 ms |
Copying to tmp table | 0.15 ms |
Sorting result | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
removing tmp table | 0.00 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.37 ms |
Waiting for query cache lock | 0.01 ms |
updating status | 0.00 ms |
storing result in query cache | 1.08 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/tortags/tortags.php:267 |
15 | plgContentTorTags->getTags() | JROOT/plugins/content/tortags/tortags.php:188 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `component`
FROM `j3_tortags_components`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.11 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
16 | JDatabaseDriver->loadColumn() | JROOT/plugins/content/tortags/tortags.php:229 |
15 | plgContentTorTags->getAlloweComponents() | JROOT/plugins/content/tortags/tortags.php:181 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `id`
FROM `j3_tortags_components`
WHERE `component`='com_content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.29 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/content/tortags/tortags.php:278 |
15 | plgContentTorTags->getOidByOption() | JROOT/plugins/content/tortags/tortags.php:187 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=2989
AND `m`.`oid`=1
AND `t`.`published`=1
ORDER BY `t`.`title` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2446 | Using where; Using temporary; Fájlrendezés használata |
1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.m.tid | 1 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.04 ms |
init | 0.00 ms |
checking query cache for query | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.01 ms |
Table lock | 0.00 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.00 ms |
Creating tmp table | 0.02 ms |
Copying to tmp table | 0.16 ms |
Sorting result | 0.01 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
removing tmp table | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.00 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.00 ms |
storing result in query cache | 0.11 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/tortags/tortags.php:267 |
15 | plgContentTorTags->getTags() | JROOT/plugins/content/tortags/tortags.php:188 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `component`
FROM `j3_tortags_components`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.00 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.00 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
16 | JDatabaseDriver->loadColumn() | JROOT/plugins/content/tortags/tortags.php:229 |
15 | plgContentTorTags->getAlloweComponents() | JROOT/plugins/content/tortags/tortags.php:181 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `id`
FROM `j3_tortags_components`
WHERE `component`='com_content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.00 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
16 | JDatabaseDriver->loadResult() | JROOT/plugins/content/tortags/tortags.php:278 |
15 | plgContentTorTags->getOidByOption() | JROOT/plugins/content/tortags/tortags.php:187 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=2988
AND `m`.`oid`=1
AND `t`.`published`=1
ORDER BY `t`.`title` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2446 | Using where; Using temporary; Fájlrendezés használata |
1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.m.tid | 1 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.00 ms |
System lock | 0.00 ms |
Table lock | 0.00 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Creating tmp table | 0.01 ms |
Copying to tmp table | 0.19 ms |
Sorting result | 0.01 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
removing tmp table | 0.00 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
updating status | 0.00 ms |
storing result in query cache | 0.22 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/tortags/tortags.php:267 |
15 | plgContentTorTags->getTags() | JROOT/plugins/content/tortags/tortags.php:188 |
14 | plgContentTorTags->onContentBeforeDisplay() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:116 |
10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:42 |
6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:381 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:356 |
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:267 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM j3_modules AS m
LEFT JOIN j3_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN j3_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-23 07:14:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-23 07:14:31')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 504 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 22 | Using index condition; Using where; Fájlrendezés használata |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | diplohu_j25.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | diplohu_j25.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.04 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.05 ms |
preparing | 0.03 ms |
executing | 0.00 ms |
Sorting result | 0.23 ms |
Sending data | 0.17 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.90 ms |
Waiting for query cache lock | 0.01 ms |
updating status | 0.00 ms |
storing result in query cache | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
14 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
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:433 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
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:581 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/transform/index.php:95 |
7 | require JROOT/templates/transform/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1103 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
select link
from j3_menu
where title="Kezdőlap"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_menu | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 251 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
8 | JDatabaseDriver->loadObject() | JROOT/templates/transform/index.php:268 |
7 | require JROOT/templates/transform/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1103 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
select title
from j3_categories
where id=275
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.01 ms |
checking query cache for query | 0.00 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
8 | JDatabaseDriver->loadObject() | JROOT/templates/transform/index.php:277 |
7 | require JROOT/templates/transform/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1103 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT '' AS `slug`, t.`title`, COUNT(x.`tid`) `frequency`
FROM j3_tortags x, j3_tortags_tags t
WHERE t.`id`=x.`tid`
AND `t`.`published`=1
GROUP BY t.`id`
ORDER BY t.`title` DESC
LIMIT 200
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | x | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2446 | Using temporary; Fájlrendezés használata |
1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.x.tid | 1 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_tortags_often_clouds/helper.php:32 |
11 | modTorTagsOftenCloudsHelper::getList() | JROOT/modules/mod_tortags_often_clouds/mod_tortags_often_clouds.php:16 |
10 | include JROOT/modules/mod_tortags_often_clouds/mod_tortags_often_clouds.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM j3_banners
WHERE '2021-04-23 07:14:31' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | NULL | Impossible WHERE |
Status | Duration |
---|---|
starting | 0.03 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.04 ms |
optimizing | 0.02 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.00 ms |
storing result in query cache | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
11 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM j3_banners as a
LEFT JOIN j3_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-23 07:14:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-23 07:14:31')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid IN (246)
ORDER BY a.sticky DESC, RAND()
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cl | const | PRIMARY | PRIMARY | 4 | const | 1 | Using temporary; Fájlrendezés használata |
1 | SIMPLE | a | index_merge | idx_state,idx_banner_catid | idx_banner_catid,idx_state | 4,1 | NULL | 7 | Using intersect(idx_banner_catid,idx_state); Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.00 ms |
checking query cache for query | 0.07 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.07 ms |
preparing | 0.00 ms |
Unlocking tables | 0.04 ms |
executing | 0.00 ms |
Creating tmp table | 0.20 ms |
Copying to tmp table | 0.23 ms |
Sorting result | 0.03 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
removing tmp table | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.01 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:205 |
12 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:44 |
11 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
UPDATE j3_banners
SET impmade = (impmade + 1)
WHERE id IN (109)
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.01 ms |
init | 0.04 ms |
updating | 0.05 ms |
end | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
end | 0.11 ms |
query end | 0.04 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:249 |
12 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:48 |
11 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
10 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
select title
from j3_categories
where id="125"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_jumi/files/tartalom.php:46 |
12 | include JROOT/components/com_jumi/files/tartalom.php | JROOT/modules/mod_jumi/tmpl/default.php:24 |
11 | require JROOT/modules/mod_jumi/tmpl/default.php | JROOT/modules/mod_jumi/mod_jumi.php:23 |
10 | include JROOT/modules/mod_jumi/mod_jumi.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
select `id`,`title`
from j3_content
where catid="125"
and state=1
order by `ordering`
limit 20
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_content | ref | idx_state,idx_catid | idx_catid | 4 | const | 434 | Using where; Fájlrendezés használata |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jumi/files/tartalom.php:54 |
12 | include JROOT/components/com_jumi/files/tartalom.php | JROOT/modules/mod_jumi/tmpl/default.php:24 |
11 | require JROOT/modules/mod_jumi/tmpl/default.php | JROOT/modules/mod_jumi/mod_jumi.php:23 |
10 | include JROOT/modules/mod_jumi/mod_jumi.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (68)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-23 07:14:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-23 07:14:31')
ORDER BY a.title ASC
LIMIT 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using temporary; Fájlrendezés használata |
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 785 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.created_by | 1 | Using where |
1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.modified_by | 1 | Using where |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:556 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_category/helper.php:229 |
14 | ModArticlesCategoryHelper::getList() | Same as call in the line below. |
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:560 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
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 j3_categories as c
LEFT JOIN j3_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=68
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Fájlrendezés használata |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 233 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.01 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
25 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
24 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
23 | ContentRouter->getCategorySegment() | Same as call in the line below. |
22 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:669 |
18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
15 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_category/helper.php:265 |
14 | ModArticlesCategoryHelper::getList() | Same as call in the line below. |
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:560 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (125)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-23 07:14:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-23 07:14:31')
ORDER BY a.created DESC
LIMIT 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Using temporary; Fájlrendezés használata |
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 434 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.created_by | 1 | Using where |
1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.modified_by | 1 | Using where |
1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.a.id | 1 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:556 |
15 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_category/helper.php:229 |
14 | ModArticlesCategoryHelper::getList() | Same as call in the line below. |
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:560 |
11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM j3_acymailing_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_acymailing_config | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 171 |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:450 |
15 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
14 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:434 |
13 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:789 |
12 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:21 |
11 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/modules/mod_acymailing/mod_acymailing.php:13 |
10 | include JROOT/modules/mod_acymailing/mod_acymailing.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM j3_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_acymailing_list | ref | typeorderingindex,typeuseridindex | typeorderingindex | 1 | const | 2 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:450 |
12 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/list.php:30 |
11 | listClass->getLists() | JROOT/modules/mod_acymailing/mod_acymailing.php:105 |
10 | include JROOT/modules/mod_acymailing/mod_acymailing.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:782 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1117 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `component`
FROM `j3_tortags_components`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
10 | JDatabaseDriver->loadColumn() | JROOT/plugins/system/tortags/tortags.php:386 |
9 | plgSystemtortags->getAlloweComponents() | JROOT/plugins/system/tortags/tortags.php:183 |
8 | plgSystemtortags->onAfterRender() | Same as call in the line below. |
7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1123 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT *
FROM `j3_tortags_components`
WHERE `component`='com_content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.12 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
10 | JDatabaseDriver->loadObject() | JROOT/plugins/system/tortags/tortags.php:398 |
9 | plgSystemtortags->getCompDetails() | JROOT/plugins/system/tortags/tortags.php:191 |
8 | plgSystemtortags->onAfterRender() | Same as call in the line below. |
7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1123 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `id`
FROM `j3_tortags_components`
WHERE `component`='com_content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | j3_tortags_components | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2 | Using where |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
10 | JDatabaseDriver->loadResult() | JROOT/plugins/system/tortags/tortags.php:412 |
9 | plgSystemtortags->getTags() | JROOT/plugins/system/tortags/tortags.php:249 |
8 | plgSystemtortags->onAfterRender() | Same as call in the line below. |
7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1123 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
WHERE `m`.`item_id`=125
AND `m`.`oid`=1
AND `t`.`published`=1
ORDER BY `t`.`title` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | NULL | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 2446 | Using where; Using temporary; Fájlrendezés használata |
1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | diplohu_j25.m.tid | 1 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.04 ms |
checking permissions | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.02 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Creating tmp table | 0.02 ms |
Copying to tmp table | 0.24 ms |
Sorting result | 0.01 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
removing tmp table | 0.08 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.00 ms |
storing result in query cache | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
10 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/tortags/tortags.php:423 |
9 | plgSystemtortags->getTags() | JROOT/plugins/system/tortags/tortags.php:249 |
8 | plgSystemtortags->onAfterRender() | Same as call in the line below. |
7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1123 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
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 j3_categories as c
LEFT JOIN j3_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=39
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Fájlrendezés használata |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 233 | Using where |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
updating status | 0.00 ms |
cleaning up | 0.00 ms |
# | Caller | File and line number |
---|---|---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:305 |
17 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
16 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:173 |
15 | ContentRouterRulesLegacy->build() | JROOT/libraries/src/Component/Router/RouterView.php:244 |
14 | Joomla\CMS\Component\Router\RouterView->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
13 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
12 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
9 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 |
8 | PlgSystemSef->onAfterRender() | Same as call in the line below. |
7 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1123 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:273 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:51 |
5 × SELECT `component`
FROM `j3_tortags_components
4 × SELECT `id`
FROM `j3_tortags_components`
4 × SELECT `t`.*
FROM `j3_tortags_tags` AS `t`
INNER JOIN `j3_tortags` AS `m`
ON `m`.`tid`=`t`.`id`
4 × SELECT `m`.`tag_id`,`t`.*
FROM `j3_contentitem_tag_map` AS m
INNER JOIN `j3_tags` AS t
ON `m`.`tag_id` = `t`.`id`
3 × SELECT DISTINCT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM j3_content AS a
LEFT JOIN j3_categories AS c
ON c.id = a.catid
LEFT JOIN j3_users AS ua
ON ua.id = a.created_by
LEFT JOIN j3_users AS uam
ON uam.id = a.modified_by
LEFT JOIN j3_categories as parent
ON parent.id = c.parent_id
LEFT JOIN j3_content_rating AS v
ON a.id = v.content_id
3 × SELECT