https://portal.kre.hu/

A magyar kultúra napja

A kézirat szerint Kölcsey Ferenc 1823-ban ezen a napon – január 22-én – fejezte be a Himnusz megírását. Erre az eseményre emlékezve 1989 óta január 22-én ünnepeljük a magyar kultúra napját. A Himnuszt Erkel Ferenc zenésítette meg 1844-ben.

A Károli idén is jelen lesz az Educatio Kiállításon!

2021. január 21-23. között rendhagyó módon, online formában rendezik meg az ország legnagyobb oktatási szakkiállítását, ahol a felsőoktatással kapcsolatos kérdésekre kaphatnak választ a középiskolás diákok, a mesterképzést kereső hallgatók, illetve a szülők, pedagógusok, intézményvezetők.

Emlékezés a doni hősökre

A 78 évvel ezelőtt a Don-kanyarban vívott harcok a magyar hadtörténelem legszomorúbb fejezetei közé tartoznak. A frontra vezényelt 2. magyar hadsereg a Don melletti hídfőcsatákban vett részt 1942 nyarától.

Visszanézhető a BTK online nyílt napja

Egyetemünk Bölcsészet- és Társadalomtudományi Kara 2021. január 12-én rendezte meg az alapképzési és mesterképzési szakok iránt érdeklődők számára nyílt napját – a vírushelyzetre való tekintettel élő bejelentkezéssel, online formában.

Nyílt napot tart a KRE BTK

Egyetemünk Bölcsészet- és Társadalomtudományi Kara várja január 12-i online nyílt napjára az érdeklődőket.

Tanszéki ügyintéző

A Károli Gáspár Református Egyetem
Állam- és Jogtudományi Kara
munkatársat keres

TANSZÉKI ÜGYINTÉZŐ

munkakörbe

Feladatok:
•   Oktatásszervezésben történő részvétel, együttműködés tanszékvezetőkkel, oktatókkal
•   A NEPTUN 2000 Egységes Tanulmányi Rendszer tanszéki ügyintézői moduljának gondozása
•   Közreműködés az órarend elkészítésében, a vizsgaidőpontok kialakításában és meghirdetésében, valamint a tanegységek és tanórák meghirdetésében
•   Megbízott és főállású oktatókkal kapcsolatos ügykezelés
•   A szervezeti egységhez tartozó nyilvántartások naprakész vezetése
•   Együttműködés a tanulmányi ügyintézőkkel/tanszéki ügyintézőkkel
•   Folyamatos kapcsolattartás az Egyetem más szervezeti egységeivel
•   A kari adminisztratív ügyek, feladatok ellátása
•   Hallgatói ügyek intézése

Elvárások:

•   Középfokú végzettség
•   Minimum 1-3 éves munkatapasztalat
•   Számítógépes ismeret (word, excel, outlook)
•   Önálló feladatmegoldási-készség
•   Precizitás, megbízhatóság, terhelhetőség, csapatjátékos szellem
•   Kiváló rendszerezőkészség, hatékonyság, logikus gondolkodás
•   Jó szervezőkészség

Előny:

• NEPTUN-program ismerete

• Hasonló munkakörben szerzett tapasztalat

Munkavégzés helye:
Budapest, 4. kerület

Jelentkezés módja:
A fényképes önéletrajzokat a Ez az e-mail-cím a szpemrobotok elleni védelem alatt áll. Megtekintéséhez engedélyeznie kell a JavaScript használatát. e-mail címre bruttó fizetési igény, valamint a levél tárgyában a pályázó nevével és a megpályázott pozíció megjelölésével várjuk.

Educatio Kiállítás 2020-ban is

Az Educatio Nemzetközi Oktatási Szakkiállítás 2020-ban 20. évfordulóját ünnepelve segíti a diákokat a továbbtanulással és egyéb képzési lehetőségekkel kapcsolatos kérdésekben. 2020. január 9-11. között kerül megrendezésre a hazai oktatási piac legnagyobb seregszemléje, a Hungexpo „A” csarnokában (1101 Budapest, Albertirsai út 10.).

Japán küldöttség látogatott a Károlira

A 2018 decemberében aláírt együttműködési megállapodást követően idén január 29-én személyesen is ellátogatott hozzánk a japán Kaichi Nemzetközi Egyetem rektorasszonya Prof. Hideko Kitagaki, akit az intézmény nemzetközi tanácsadója Prof. Takao Otsuka kísért el a budapesti látogatásra.

Kollégiumtűz – információk (Frissítve)

A Magyarországi Református Egyház Kommunikációs Szolgálatának sajtóanyaga.

Tragikus tűz volt a Ráday Kollégiumban

Kiégett a Dunamelléki Református Egyházkerület Ráday utcai kollégiumának épülete január 23-án. A tűzoltók emberfeletti erőfeszítéseinek köszönhetően a tüzet sikerült megfékezni, a hallgatók közül senki nem sérült meg. A tűzben elhunyt egy 47 éves veszprémi férfi, aki vendégként tartózkodott az épületben.

1. oldal / 6

Joomla! hibakereső konzol

Munkamenet

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

Profilinformációk

Idő

Memória

Idő: 18.69 ms / 18.69 ms Memória: 0.407 MB / 0.74 MB Application: afterLoad

Idő: 79.05 ms / 97.74 ms Memória: 1.029 MB / 1.77 MB Application: afterInitialise

Idő: 58.59 ms / 156.32 ms Memória: 2.707 MB / 4.48 MB Application: afterRoute

Idő: 1.17 ms / 157.50 ms Memória: 0.016 MB / 4.49 MB Application: beforeRenderComponent com_content

Idő: 7.48 ms / 164.98 ms Memória: 0.085 MB / 4.58 MB Application: Before Access::preloadComponents (all components)

Idő: 0.84 ms / 165.82 ms Memória: 0.061 MB / 4.64 MB Application: After Access::preloadComponents (all components)

Idő: 0.02 ms / 165.84 ms Memória: -0.004 MB / 4.63 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Idő: 0.88 ms / 166.72 ms Memória: 0.008 MB / 4.64 MB Application: After Access::getAssetRules (id:8 name:com_content)

Idő: 69.43 ms / 236.15 ms Memória: 0.760 MB / 5.40 MB Application: afterRenderComponent com_content

Idő: 11.01 ms / 247.16 ms Memória: 0.009 MB / 5.41 MB Application: afterDispatch

Idő: 18.76 ms / 265.92 ms Memória: 0.158 MB / 5.57 MB Application: beforeRenderModule mod_menu (Hasznos Linkek)

Idő: 18.46 ms / 284.38 ms Memória: 0.049 MB / 5.62 MB Application: afterRenderModule mod_menu (Hasznos Linkek)

Idő: 5.65 ms / 290.03 ms Memória: 0.003 MB / 5.62 MB Application: beforeRenderModule mod_breadcrumbs (Ön itt van)

Idő: 2.76 ms / 292.79 ms Memória: 0.010 MB / 5.63 MB Application: afterRenderModule mod_breadcrumbs (Ön itt van)

Idő: 2.60 ms / 295.39 ms Memória: 0.012 MB / 5.64 MB Application: beforeRenderModule mod_bt_contentshowcase (Következő események)

Idő: 17.10 ms / 312.49 ms Memória: 0.146 MB / 5.79 MB Application: afterRenderModule mod_bt_contentshowcase (Következő események)

Idő: 14.47 ms / 326.96 ms Memória: -0.017 MB / 5.77 MB Application: beforeRenderModule mod_menu (Main Menu)

Idő: 218.07 ms / 545.03 ms Memória: 1.615 MB / 7.39 MB Application: afterRenderModule mod_menu (Main Menu)

Idő: 3.86 ms / 548.89 ms Memória: -0.015 MB / 7.37 MB Application: beforeRenderModule mod_search (Search)

Idő: 2.02 ms / 550.91 ms Memória: 0.013 MB / 7.38 MB Application: afterRenderModule mod_search (Search)

Idő: 2.21 ms / 553.12 ms Memória: -0.004 MB / 7.38 MB Application: beforeRenderModule mod_menu (Menu)

Idő: 13.74 ms / 566.87 ms Memória: 0.081 MB / 7.46 MB Application: afterRenderModule mod_menu (Menu)

Idő: 20.99 ms / 587.85 ms Memória: 0.208 MB / 7.67 MB Application: afterRender

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

Memóriahasználat

Adatbázis lekérdezések

33 naplózott lekérdezés 38.26 ms

6 duplikátum található!

6 duplikátum: #24 #26 #27 #28 #29 #30

Lekérdezés ideje: 0.31 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.030 MB Visszaadott sorok: 0

SELECT `session_id`

  FROM `ast_session`

  WHERE `session_id` = X'726e39336f39686e343637656674746e6e61726a72326830696c' 
  LIMIT 1

Magyarázat

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

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Lekérdezés ideje: 5.43 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 1.036 MB

INSERT INTO `ast_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'726e39336f39686e343637656674746e6e61726a72326830696c', 1, 1686355157, 0, '', 0)

Magyarázat

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.15 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	5.14 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Lekérdezés ideje: 0.23 ms Utolsó lekérdezés után: 6.90 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.140 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `ast_viewlevels`

Magyarázat

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.30 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.152 MB Visszaadott sorok: 2

SELECT b.id

  FROM ast_usergroups AS a

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

  WHERE a.id = 9

Magyarázat

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

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 5.17 ms Utolsó lekérdezés után: 33.65 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 1.727 MB

UPDATE `ast_extensions`

  SET `params` = '{\"mediaversion\":\"34965a9b19fd3664cad5b34091c7d760\"}'

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

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE `ast_extensions` SET `params` = '{\"mediaversion\":\"34965a9b19fd3664cad5b34091c7d760\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.10 ms
updating	0.11 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	4.80 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:228
8	plgSystemBt_socialconnect_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.71 ms Utolsó lekérdezés után: 74.73 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 4.582 MB Visszaadott sorok: 41

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

  FROM `ast_assets`

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

Magyarázat

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

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.38 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/archive.php:44
14	ContentModelArchive->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:39
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 8.90 ms Utolsó lekérdezés után: 1.86 ms Memória lekérdezése: 0.134 MB memória a lekérdezés előtt: 4.652 MB Visszaadott sorok: 10

SELECT 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, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug

  FROM ast_content AS a

  LEFT JOIN ast_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ast_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ast_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ast_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ast_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 = 2 
  AND a.state > 0) OR (c.published = 1 
  AND a.state = 2)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-09 23:59:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-09 23:59:17') 
  AND MONTH( 
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END ) = 1

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 10

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idx_access,idx_state,idx_catid	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1324	16.00	Using where; Using temporary; Fájlrendezés használata
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	portal_krehu_site.a.catid	1	19.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.c.parent_id	1	100.00	Using where
1	SIMPLE	v	NULL	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)

Profil

Status	Duration
starting	0.16 ms
Executing hook on transaction	0.00 ms
starting	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
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.03 ms
Creating tmp table	0.20 ms
executing	8.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_content/models/archive.php:180
15	ContentModelArchive->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 1.93 ms Utolsó lekérdezés után: 1.38 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.846 MB Visszaadott sorok: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1573 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.60 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.864 MB Visszaadott sorok: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1572 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1571 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1567 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1565 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1369 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1365 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1173 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.23 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.986 MB Visszaadott sorok: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1172 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `ast_contentitem_tag_map` AS m 

  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1171 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	portal_krehu_site.m.tag_id	1	75.00	Using where

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:40
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 2.25 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 5.021 MB Visszaadott sorok: 1

SELECT COUNT(*)

  FROM ast_content AS a

  LEFT JOIN ast_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ast_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ast_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ast_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ast_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 = 2 
  AND a.state > 0) OR (c.published = 1 
  AND a.state = 2)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-09 23:59:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-09 23:59:17') 
  AND MONTH( 
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END ) = 1

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	idx_access,idx_state,idx_catid	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1324	16.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	portal_krehu_site.a.catid	1	19.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.c.parent_id	1	100.00	Using where; Using index
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.a.id	1	100.00	Using where; Using index

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	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
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	1.78 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_content/views/archive/view.html.php:41
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `ast_categories` AS `s`

  INNER JOIN `ast_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	6	97.61	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
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:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/archive/view.html.php:72
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 2.00 ms Utolsó lekérdezés után: 0.73 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 5.103 MB Visszaadott sorok: 0

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

  FROM ast_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.archive' 
  AND (fc.category_id IS NULL OR fc.category_id IN (9,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Magyarázat

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

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	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.00 ms
Opening tables	1.49 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:333
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:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/archive/view.html.php:72
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.59 ms Utolsó lekérdezés után: 10.71 ms Memória lekérdezése: 0.045 MB memória a lekérdezés előtt: 5.143 MB Visszaadott sorok: 7

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 `ast_categories` AS `s`

  INNER JOIN `ast_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	140	97.61	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.23 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
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:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/archive/view.html.php:72
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM ast_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.archive' 
  AND (fc.category_id IS NULL OR fc.category_id IN (88,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Magyarázat

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

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	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.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:333
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:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/archive/view.html.php:72
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 2.28 ms Utolsó lekérdezés után: 10.89 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 5.223 MB Visszaadott sorok: 12

SELECT DISTINCT (YEAR(`created`))

  FROM `ast_content`

  WHERE `state`= 2 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-06-09 23:59:17') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-09 23:59:17')

  ORDER BY 1 ASC

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ast_content	NULL	ref	idx_state	idx_state	1	const	817	16.00	Using where; Using temporary; Fájlrendezés használata

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	2.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_content/models/archive.php:217
12	ContentModelArchive->getYears()	JROOT/components/com_content/views/archive/view.html.php:117
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.19 ms Utolsó lekérdezés után: 10.76 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 5.356 MB Visszaadott sorok: 0

Duplikált lekérdezések: #26 #27 #28 #29 #30

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2021'

Magyarázat

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
28	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:773
18	JPagination->_buildDataObject()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:309
17	JPagination->getPagesLinks()	JROOT/templates/bt_education/html/com_content/archive/default_items.php:121
16	include JROOT/templates/bt_education/html/com_content/archive/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/bt_education/html/com_content/archive/default.php:44
14	include JROOT/templates/bt_education/html/com_content/archive/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_content/views/archive/view.html.php:148
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.32 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 5.373 MB Visszaadott sorok: 0

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 `ast_categories` AS `s`

  INNER JOIN `ast_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Magyarázat

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

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.09 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
30	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
29	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
28	ContentRouter->getCategorySegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:124
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:773
18	JPagination->_buildDataObject()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:309
17	JPagination->getPagesLinks()	JROOT/templates/bt_education/html/com_content/archive/default_items.php:121
16	include JROOT/templates/bt_education/html/com_content/archive/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/bt_education/html/com_content/archive/default.php:44
14	include JROOT/templates/bt_education/html/com_content/archive/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_content/views/archive/view.html.php:148
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.15 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 5.387 MB Visszaadott sorok: 0

Duplikált lekérdezések: #24 #27 #28 #29 #30

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2021'

Magyarázat

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

Profil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
28	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:803
18	JPagination->_buildDataObject()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:309
17	JPagination->getPagesLinks()	JROOT/templates/bt_education/html/com_content/archive/default_items.php:121
16	include JROOT/templates/bt_education/html/com_content/archive/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/bt_education/html/com_content/archive/default.php:44
14	include JROOT/templates/bt_education/html/com_content/archive/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_content/views/archive/view.html.php:148
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplikált lekérdezések: #24 #26 #28 #29 #30

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2021'

Magyarázat

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

Profil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
28	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:805
18	JPagination->_buildDataObject()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:309
17	JPagination->getPagesLinks()	JROOT/templates/bt_education/html/com_content/archive/default_items.php:121
16	include JROOT/templates/bt_education/html/com_content/archive/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/bt_education/html/com_content/archive/default.php:44
14	include JROOT/templates/bt_education/html/com_content/archive/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_content/views/archive/view.html.php:148
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplikált lekérdezések: #24 #26 #27 #29 #30

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2021'

Magyarázat

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

Profil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
28	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:820
18	JPagination->_buildDataObject()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:309
17	JPagination->getPagesLinks()	JROOT/templates/bt_education/html/com_content/archive/default_items.php:121
16	include JROOT/templates/bt_education/html/com_content/archive/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/bt_education/html/com_content/archive/default.php:44
14	include JROOT/templates/bt_education/html/com_content/archive/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_content/views/archive/view.html.php:148
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplikált lekérdezések: #24 #26 #27 #28 #30

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2021'

Magyarázat

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

Profil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
28	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:820
18	JPagination->_buildDataObject()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:309
17	JPagination->getPagesLinks()	JROOT/templates/bt_education/html/com_content/archive/default_items.php:121
16	include JROOT/templates/bt_education/html/com_content/archive/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/bt_education/html/com_content/archive/default.php:44
14	include JROOT/templates/bt_education/html/com_content/archive/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_content/views/archive/view.html.php:148
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplikált lekérdezések: #24 #26 #27 #28 #29

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2021'

Magyarázat

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

Profil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
29	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
28	ContentRouter->getArticleSegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
27	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
26	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
25	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
24	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
23	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:820
18	JPagination->_buildDataObject()	JROOT/plugins/system/t3/includes/joomla30/pagination.php:309
17	JPagination->getPagesLinks()	JROOT/templates/bt_education/html/com_content/archive/default_items.php:121
16	include JROOT/templates/bt_education/html/com_content/archive/default_items.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
15	JViewLegacy->loadTemplate()	JROOT/templates/bt_education/html/com_content/archive/default.php:44
14	include JROOT/templates/bt_education/html/com_content/archive/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_content/views/archive/view.html.php:148
11	ContentViewArchive->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 1.09 ms Utolsó lekérdezés után: 20.65 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 5.479 MB Visszaadott sorok: 29

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

  FROM ast_modules AS m

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

  LEFT JOIN ast_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 <= '2023-06-09 23:59:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-09 23:59:17') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 446 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	29	1.60	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	portal_krehu_site.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	portal_krehu_site.m.module,const	1	10.00	Using index condition; Using where

Profil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.58 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
15	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
14	JModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:604
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
12	T3Template->countModules()	JROOT/templates/bt_education/tpls/blocks/header.php:65
11	include JROOT/templates/bt_education/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/bt_education/tpls/default.php:29
9	include JROOT/templates/bt_education/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/bt_education/index.php:34
7	require JROOT/templates/bt_education/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 2.01 ms Utolsó lekérdezés után: 42.94 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 5.788 MB Visszaadott sorok: 0

SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 ast_content AS a

  LEFT JOIN ast_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ast_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ast_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN ast_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ast_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 (138) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-09 23:59:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-09 23:59:17')

  ORDER BY a.created asc 
  LIMIT 5

Magyarázat

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Fájlrendezés használata
1	SIMPLE	a	NULL	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	116	15.92	Using intersect(idx_catid,idx_state); Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	portal_krehu_site.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	ALL	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.00 ms
starting	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
Opening tables	0.16 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.03 ms
Creating tmp table	0.14 ms
executing	1.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.03 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
16	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentshowcase/classes/content.php:159
15	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentshowcase/helpers/helper.php:71
14	modBtContentShowcaseHelper::getList()	JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php:21
13	include JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
12	JModuleHelper::renderModule()	Ugyanaz a hívás, mint egy sorral lejjebb.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:609
9	JModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.46 ms Utolsó lekérdezés után: 276.95 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 7.761 MB Visszaadott sorok: 0

SELECT social_id 
  FROM ast_bt_connections 
  WHERE social_type ="facebook" 
  AND  user_id ="0"

Magyarázat

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

Profil

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:488
8	plgSystemBt_socialconnect_system::getSocialID()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:148
7	plgSystemBt_socialconnect_system->onAfterRender()	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:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT táblák:

10 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ast_contentitem_tag_map` AS m  
  INNER JOIN `ast_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

6 × SELECT `alias` 
  FROM `ast_content`

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

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM ast_fields AS a 
  LEFT JOIN `ast_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ast_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ast_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ast_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ast_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ast_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `session_id` 
  FROM `ast_session`

1 × SELECT id, rules 
  FROM `ast_viewlevels

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

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

1 × SELECT 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, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug 
  FROM ast_content AS a 
  LEFT JOIN ast_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ast_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ast_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ast_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ast_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT COUNT(*) 
  FROM ast_content AS a 
  LEFT JOIN ast_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ast_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ast_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ast_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ast_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT DISTINCT (YEAR(`created`)) 
  FROM `ast_content`

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ast_modules AS m 
  LEFT JOIN ast_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ast_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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 ast_content AS a 
  LEFT JOIN ast_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ast_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ast_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ast_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ast_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT social_id 
  FROM ast_bt_connections

EGYÉB táblák:

1 × INSERT INTO `ast_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'726e39336f39686e343637656674746e6e61726a72326830696c', 1, 1686355157, 0, '', 0

1 × UPDATE `ast_extensions` 
  SET `params` = '{\"mediaversion\":\"34965a9b19fd3664cad5b34091c7d760\"}'

A magyar kultúra napja

A Károli idén is jelen lesz az Educatio Kiállításon!

Emlékezés a doni hősökre

Visszanézhető a BTK online nyílt napja

Nyílt napot tart a KRE BTK

Tanszéki ügyintéző

TANSZÉKI ÜGYINTÉZŐ

Educatio Kiállítás 2020-ban is

Japán küldöttség látogatott a Károlira

Kollégiumtűz – információk (Frissítve)

Tragikus tűz volt a Ráday Kollégiumban

Következő események

Galéria

Tudomány, kutatás

Névjegy

Napi biztatás

Blog

Sport a Károlin

Szakirányú továbbképzések

Youtube

Archívum

Károli magazin

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

33 naplózott lekérdezés 38.26 ms

6 duplikátum található!

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

SELECT táblák:

EGYÉB táblák: