Lengyelország

https://portal.kre.hu/

KRE aranyérem az országos és a budapesti Strandkézilabda Bajnokságon

2020. augusztus 25-én került sor a Károli Gáspár Református Egyetem és a Magyar Egyetemi - Főiskolai Sportszövetség rendezésében a 2019/2020. évi Magyar Egyetemi - Főiskolai Országos Strandkézilabda Bajnokságra, a budakalászi Lupa tónál.

Ünnepélyes tanévnyitó

frissítve: 2020. szeptember 3.
A Károli Gáspár Református Egyetem 2020. szeptember 7-én (hétfőn) 10 órakor, istentisztelet keretében tartja ünnepélyes tanévnyitóját, melynek helyszíne a Pozsonyi Úti Református Egyházközség Hálaadás Temploma lesz (1133 Budapest, Pozsonyi út 58.).

3./2020. (VIII.12.)/R-GI számú utasítás

4./2020. (VIII.12.)/R-GI számú utasítás

Pótfelvételi a Károlin!

A 2020. évi általános felsőoktatási felvételi eljárás eredményeképpen közel 2300-an kezdhetik meg világi képzésben a tanévet 2020. szeptemberben, ám akik eddig nem jutottak be, azoknak most újabb esély nyílik a 2020. évi felsőoktatási pótfelvételi eljárás (2020P) keretein belül.

Károli Gólyanap, másképp

A Károli Gáspár Református Egyetem a szenátus által is elfogadott 76/2020. (V.29.) határozat értelmében úgy tervezte, hogy a Gólyákat Gólyatábor keretében köszönti szeptember 2-4 közötti időszakban. Sajnos a jelenlegi járványügyi veszélyeztetettség és a nagy létszámú rendezvények korlátozására vonatkozó szabályozás a felsőoktatási intézmények rendezvényeit is érinti.

Csadi Zoltánt Magyar Ezüst Érdemkereszttel tüntették ki

Áder János köztársasági elnök Csadi Zoltán színművésznek, Egyetemünk frissen diplomázott mesterszakos hallgatójának, a Bartók Kamaraszínház igazgatóhelyettesének a Magyar Ezüst Érdemkereszt polgári tagozat kitüntetést adományozta az augusztus 20-i nemzeti ünnepünk alkalmából.

Kihirdetésre került az Új Nemzeti Kiválóság Program eredménye

Kihirdetésre került az Új Nemzeti Kiválóság Program eredménye, amely itt olvasható.

Együttműködés a Ljubljanai Egyetemmel

Prof. Dr. Balla Péter rektor a Ljubljanai Egyetemre látogatott, ahol az egyetemeink közötti együttműködés bővítéséről tárgyalt Katja Cerjakkal (képünkön), a Nemzetközi Kapcsolatok Hivatala vezetőjével, valamint találkozott a Teológiai Fakultás dékánjával és több professzorával is.

Ahol a szívben van a hit

Családos, sportos, ugyanakkor lelkiekben, imákban gazdag biciklitúrán járták végig a fasori reformátusok a reformáció fontos helyszíneit, így emlékezve a reformátor ősökre.

1. oldal / 5

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686359176,
                "last": 1686359176,
                "now": 1686359176
            },
            "client": {
                "forwarded": "44.192.79.149"
            },
            "token": "x3MwUoCesRn6XkOku6gXDNgHTfAJ0bGz"
        },
        "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ő: 17.28 ms / 17.28 ms Memória: 0.407 MB / 0.74 MB Application: afterLoad

Idő: 83.55 ms / 100.84 ms Memória: 1.029 MB / 1.77 MB Application: afterInitialise

Idő: 61.47 ms / 162.30 ms Memória: 2.707 MB / 4.48 MB Application: afterRoute

Idő: 1.19 ms / 163.49 ms Memória: 0.016 MB / 4.49 MB Application: beforeRenderComponent com_content

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

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

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

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

Idő: 60.75 ms / 233.86 ms Memória: 0.644 MB / 5.29 MB Application: afterRenderComponent com_content

Idő: 9.01 ms / 242.87 ms Memória: 0.009 MB / 5.30 MB Application: afterDispatch

Idő: 15.87 ms / 258.74 ms Memória: 0.158 MB / 5.45 MB Application: beforeRenderModule mod_menu (Hasznos Linkek)

Idő: 14.22 ms / 272.97 ms Memória: 0.049 MB / 5.50 MB Application: afterRenderModule mod_menu (Hasznos Linkek)

Idő: 4.58 ms / 277.55 ms Memória: 0.003 MB / 5.51 MB Application: beforeRenderModule mod_breadcrumbs (Ön itt van)

Idő: 2.34 ms / 279.88 ms Memória: 0.010 MB / 5.52 MB Application: afterRenderModule mod_breadcrumbs (Ön itt van)

Idő: 16.53 ms / 296.41 ms Memória: 0.018 MB / 5.53 MB Application: beforeRenderModule mod_menu (Main Menu)

Idő: 226.65 ms / 523.06 ms Memória: 1.613 MB / 7.15 MB Application: afterRenderModule mod_menu (Main Menu)

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

Idő: 1.96 ms / 528.87 ms Memória: 0.092 MB / 7.22 MB Application: afterRenderModule mod_search (Search)

Idő: 2.28 ms / 531.15 ms Memória: -0.004 MB / 7.22 MB Application: beforeRenderModule mod_menu (Menu)

Idő: 14.33 ms / 545.48 ms Memória: 0.081 MB / 7.30 MB Application: afterRenderModule mod_menu (Menu)

Idő: 21.58 ms / 567.07 ms Memória: 0.193 MB / 7.49 MB Application: afterRender

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

Memóriahasználat

Adatbázis lekérdezések

29 naplózott lekérdezés 35.68 ms

5 duplikátum található!

5 duplikátum: #22 #24 #25 #26 #27

Lekérdezés ideje: 0.26 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'6d71316b336461326930763770626974696874766e386e337430' 
  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.04 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.07 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: 6.12 ms Utolsó lekérdezés után: 0.06 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'6d71316b336461326930763770626974696874766e386e337430', 1, 1686359176, 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'6d71316b336461326930763770626974696874766e386e337430', 1, 1686359176, 0, '', 0)

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
update	0.15 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	5.81 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.24 ms Utolsó lekérdezés után: 7.08 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.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.07 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
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.31 ms Utolsó lekérdezés után: 0.05 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.04 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: 6.32 ms Utolsó lekérdezés után: 35.78 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\":\"43850ef5e9ef224510b7d6de7ee252a8\"}'

  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\":\"43850ef5e9ef224510b7d6de7ee252a8\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.10 ms
updating	0.11 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	5.93 ms
closing tables	0.01 ms
freeing items	0.01 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.88 ms Utolsó lekérdezés után: 78.19 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.10 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.47 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.02 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.92 ms Utolsó lekérdezés után: 1.95 ms Memória lekérdezése: 0.079 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-10 01:06:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-10 01:06:16') 
  AND MONTH( 
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END ) = 8

  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.20 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.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.20 ms
preparing	0.04 ms
Creating tmp table	0.15 ms
executing	7.98 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.04 ms
cleaning up	0.02 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: 0.40 ms Utolsó lekérdezés után: 1.39 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.821 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` = 1483 
  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.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 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.10 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.25 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.840 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` = 1469 
  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.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: 0.26 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.857 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` = 1474 
  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.06 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.26 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.874 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` = 1475 
  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.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.25 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.892 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` = 1472 
  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.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: 0.27 ms Utolsó lekérdezés után: 0.09 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.909 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` = 1473 
  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.01 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.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.25 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.926 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` = 1108 
  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.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: 0.38 ms Utolsó lekérdezés után: 0.10 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.944 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` = 1079 
  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	0.03 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: 2.01 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.961 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` = 968 
  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.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.01 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.15 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.980 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` = 967 
  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.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.22 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 4.996 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-10 01:06:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-10 01:06:16') 
  AND MONTH( 
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END ) = 8

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.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
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
executing	1.77 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: 7.17 ms Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 5.057 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.08 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.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.06 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
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.67 ms Utolsó lekérdezés után: 0.59 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 5.078 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.08 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.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.03 ms
Creating tmp table	0.05 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.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/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.16 ms Utolsó lekérdezés után: 16.95 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 5.123 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-10 01:06:16') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-10 01:06:16')

  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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	1.89 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.20 ms Utolsó lekérdezés után: 9.08 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 5.256 MB Visszaadott sorok: 0

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

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2020'

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.01 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.07 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 5.273 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 = 2020

  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.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.06 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.16 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.286 MB Visszaadott sorok: 0

Duplikált lekérdezések: #22 #25 #26 #27

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2020'

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.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: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.14 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 5.300 MB Visszaadott sorok: 0

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

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2020'

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.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: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.09 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 5.316 MB Visszaadott sorok: 0

Duplikált lekérdezések: #22 #24 #25 #27

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2020'

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.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: 0.16 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 5.330 MB Visszaadott sorok: 0

Duplikált lekérdezések: #22 #24 #25 #26

SELECT `alias`

  FROM `ast_content`

  WHERE id = '2020'

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.04 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.10 ms Utolsó lekérdezés után: 16.91 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 5.364 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-10 01:06:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-10 01:06:16') 
  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.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
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.65 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: 0.34 ms Utolsó lekérdezés után: 306.26 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 7.584 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.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 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.02 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.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]

15 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`

5 × SELECT `alias` 
  FROM `ast_content`

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)

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 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 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 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'6d71316b336461326930763770626974696874766e386e337430', 1, 1686359176, 0, '', 0

1 × UPDATE `ast_extensions` 
  SET `params` = '{\"mediaversion\":\"43850ef5e9ef224510b7d6de7ee252a8\"}'

KRE aranyérem az országos és a budapesti Strandkézilabda Bajnokságon

Ünnepélyes tanévnyitó

3./2020. (VIII.12.)/R-GI számú utasítás

4./2020. (VIII.12.)/R-GI számú utasítás

Pótfelvételi a Károlin!

Károli Gólyanap, másképp

Csadi Zoltánt Magyar Ezüst Érdemkereszttel tüntették ki

Kihirdetésre került az Új Nemzeti Kiválóság Program eredménye

Együttműködés a Ljubljanai Egyetemmel

Ahol a szívben van a hit

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

29 naplózott lekérdezés 35.68 ms

5 duplikátum található!

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

SELECT táblák:

EGYÉB táblák: