Árak

Szállás árlista 2016. szeptember 1-től (a változtatás jogát fenntartjuk):

Vendégház árak


szoba (maximum 2 fő):	12 000	Ft/éj/szoba
szoba (3 fő):	15 000	Ft/éj/szoba
egész ház (kizárólagossággal, maximum 12 fő):	50 000	Ft/éj/ház

Kiemelt időszak:

Húsvét: 2020. április 10-13.
Május 1.: 2020. április 30-május 4.
2020. május 7-9.
Augusztus 20: 2020.augusztus 19-23.

Kiemelt időszak árak:

szoba (maximum 2 fő):	15 000	Ft/éj/szoba
szoba (3 fő, 1 pótágy):	18 000	Ft/éj/szoba
egész ház (kizárólagossággal, maximum 12 fő):	55 000	Ft/éj/ház

*Elhelyezés 3 ágyas szobában, másokkal közösen

A fenti bruttó árak tartalmazzák a szauna és konyha használatot, továbbá törölközőt, ágyneműt biztosítunk.

A szobákat az érkezés napján 11:00 órakor lehet elfoglalni az elutazás napján a szobát 10:00 óráig kell elhagyni.

Fizetés a helyszínen készpénzzel vagy érkezés előtt átutalással (jelenleg bánkártyás fizetés nem lehetséges).

Kiskakas Vendégház

Bevezető ár: 12 000,- Ft/éj egész ház (4 fő részére)

+36 30 584 5320

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1618747685,
                "last": 1618747685,
                "now": 1618747685
            },
            "token": "Ucjd1ci9O1qpg2YX4XTHP7GW59fhSFV1"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "hu-HU"
        }
    }
}

Profilinformációk

Idő

Memória

**Idő**: 26.18 ms / 26.18 ms **Memória**: 0.880 MB / 1.09 MB Application: afterLoad

**Idő**: 96.06 ms / 122.24 ms **Memória**: 1.937 MB / 3.02 MB Application: afterInitialise

**Idő**: 15.43 ms / 137.68 ms **Memória**: 0.258 MB / 3.28 MB Application: afterRoute

**Idő**: 6.14 ms / 143.81 ms **Memória**: 0.152 MB / 3.43 MB Application: beforeRenderComponent com_content

**Idő**: 8.04 ms / 151.85 ms **Memória**: 0.167 MB / 3.60 MB Application: Before Access::preloadComponents (all components)

**Idő**: 1.26 ms / 153.11 ms **Memória**: 0.094 MB / 3.70 MB Application: After Access::preloadComponents (all components)

**Idő**: 0.04 ms / 153.15 ms **Memória**: -0.005 MB / 3.69 MB Application: Before Access::preloadPermissions (com_content)

**Idő**: 0.78 ms / 153.92 ms **Memória**: 0.051 MB / 3.74 MB Application: After Access::preloadPermissions (com_content)

**Idő**: 0.04 ms / 153.96 ms **Memória**: -0.000 MB / 3.74 MB Application: Before Access::getAssetRules (id:57 name:com_content.article.4)

**Idő**: 0.94 ms / 154.90 ms **Memória**: 0.020 MB / 3.76 MB Application: After Access::getAssetRules (id:57 name:com_content.article.4)

**Idő**: 101.21 ms / 256.10 ms **Memória**: 0.784 MB / 4.55 MB Application: afterRenderComponent com_content

**Idő**: 3.56 ms / 259.67 ms **Memória**: 0.061 MB / 4.61 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Idő**: 0.08 ms / 259.75 ms **Memória**: 0.010 MB / 4.62 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Idő**: 2.71 ms / 262.46 ms **Memória**: 0.032 MB / 4.65 MB Application: afterDispatch

**Idő**: 5.72 ms / 268.18 ms **Memória**: 0.107 MB / 4.76 MB Application: beforeRenderModule mod_custom (Információ)

**Idő**: 1.26 ms / 269.44 ms **Memória**: 0.011 MB / 4.77 MB Application: afterRenderModule mod_custom (Információ)

**Idő**: 0.05 ms / 269.48 ms **Memória**: -0.006 MB / 4.76 MB Application: beforeRenderModule mod_formmaker (Foglalás)

**Idő**: 66.92 ms / 336.41 ms **Memória**: 0.390 MB / 5.15 MB Application: afterRenderModule mod_formmaker (Foglalás)

**Idő**: 0.16 ms / 336.57 ms **Memória**: -0.003 MB / 5.15 MB Application: beforeRenderModule mod_custom (eu)

**Idő**: 0.13 ms / 336.70 ms **Memória**: 0.007 MB / 5.15 MB Application: afterRenderModule mod_custom (eu)

**Idő**: 0.04 ms / 336.74 ms **Memória**: -0.003 MB / 5.15 MB Application: beforeRenderModule mod_custom (gb)

**Idő**: 0.11 ms / 336.85 ms **Memória**: 0.007 MB / 5.16 MB Application: afterRenderModule mod_custom (gb)

**Idő**: 0.06 ms / 336.91 ms **Memória**: -0.003 MB / 5.15 MB Application: beforeRenderModule mod_custom (banner)

**Idő**: 0.10 ms / 337.02 ms **Memória**: 0.007 MB / 5.16 MB Application: afterRenderModule mod_custom (banner)

**Idő**: 0.06 ms / 337.08 ms **Memória**: -0.002 MB / 5.16 MB Application: beforeRenderModule mod_menu (Main Menu)

**Idő**: 4.90 ms / 341.98 ms **Memória**: 0.143 MB / 5.30 MB Application: afterRenderModule mod_menu (Main Menu)

**Idő**: 0.09 ms / 342.07 ms **Memória**: -0.010 MB / 5.29 MB Application: beforeRenderModule mod_custom (Kakasszeki VendégHÁZ)

**Idő**: 0.12 ms / 342.19 ms **Memória**: 0.007 MB / 5.30 MB Application: afterRenderModule mod_custom (Kakasszeki VendégHÁZ)

**Idő**: 11.98 ms / 354.17 ms **Memória**: 0.139 MB / 5.44 MB Application: afterRender

**Adatbázislekérdezés összesen: 16.08 ms**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_session	const	PRIMARY	PRIMARY	194	const	1

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:804
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_session	const	PRIMARY	PRIMARY	194	const	1	Using index

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

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
update	0.08 ms
Waiting for query cache lock	0.01 ms
update	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:364
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.68 ms** **Utolsó lekérdezés után: 5.30 ms** **Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.807 MB** **Visszaadott sorok: 38**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pvw15_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_extensions	ref	extension	extension	82	const	26	Using index condition; Using where

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.29 ms** **Utolsó lekérdezés után: 4.33 ms** **Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 1.901 MB** **Visszaadott sorok: 5**

SELECT id, rules

  FROM `pvw15_viewlevels`

**Magyarázat**

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

**Profil**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
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:203
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.16 ms** **Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 1.926 MB** **Visszaadott sorok: 2**

SELECT b.id

  FROM pvw15_usergroups AS a

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

  WHERE a.id = 9

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Lekérdezés ideje: 1.39 ms** **Utolsó lekérdezés után: 1.28 ms** **Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 1.965 MB** **Visszaadott sorok: 78**

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM pvw15_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_extensions	ref	extension	extension	82	const	76	Using index condition; Using where; Fájlrendezés használata

**Profil**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.66 ms
Sending data	0.33 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
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:203
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: 25.09 ms** **Memória lekérdezése: 0.013 MB memória a lekérdezés előtt: 2.632 MB** **Visszaadott sorok: 1**

SELECT `enabled`

  FROM `pvw15_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	402	const	1	Using index condition; Using where

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
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:203
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.36 ms** **Utolsó lekérdezés után: 4.96 ms** **Memória lekérdezése: 0.018 MB memória a lekérdezés előtt: 2.705 MB** **Visszaadott sorok: 2**

SELECT *

  FROM pvw15_languages

  WHERE published=1

  ORDER BY ordering ASC

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_languages	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	2	Using where; Fájlrendezés használata

**Profil**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
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:203
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: 0.20 ms** **Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 2.728 MB** **Visszaadott sorok: 4**

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `pvw15_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_extensions	ref	extension	extension	82	const	3	Using index condition; Using where

**Profil**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
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:203
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.64 ms** **Utolsó lekérdezés után: 17.27 ms** **Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 2.936 MB** **Visszaadott sorok: 10**

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM pvw15_menu AS m

  LEFT JOIN pvw15_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	15	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	kakasszekivendeg.m.component_id	1	Using where

**Profil**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.10 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:395
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:511
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
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:203
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.44 ms** **Utolsó lekérdezés után: 16.67 ms** **Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.253 MB** **Visszaadott sorok: 0**

select * 
  from pvw15_hotelreservation_offers of
					
  inner join pvw15_hotelreservation_offers_vouchers hov 
  on of.offer_id = hov.offerId  
					
  where REPLACE(hov.voucher,'-',' ') = 'arak' 
					
  group by of.offer_id 
  LIMIT 0, 1

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profil**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:182
10	plgSystemHotelUrlTranslator->getVoucherParams()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:58
9	plgSystemHotelUrlTranslator->onAfterRoute()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.08 ms** **Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 3.268 MB** **Visszaadott sorok: 0**

SELECT * 
  FROM `pvw15_hotelreservation_hotels`  
  WHERE REPLACE(hotel_city,'-',' ') = 'arak'

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:89
10	plgSystemHotelUrlTranslator->getHotelCityParams()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:60
9	plgSystemHotelUrlTranslator->onAfterRoute()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.56 ms** **Utolsó lekérdezés után: 0.84 ms** **Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 3.313 MB** **Visszaadott sorok: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pvw15_extensions`

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

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.52 ms** **Utolsó lekérdezés után: 0.20 ms** **Memória lekérdezése: 0.012 MB memória a lekérdezés előtt: 3.315 MB**

UPDATE `pvw15_extensions`

  SET `params` = '{\"mediaversion\":\"79640c49e86a027c93a9e61dbd850e95\"}'

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

**Magyarázat**

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

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.18 ms
updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.53 ms** **Utolsó lekérdezés után: 3.20 ms** **Memória lekérdezése: 0.010 MB memória a lekérdezés előtt: 3.417 MB** **Visszaadott sorok: 4**

SELECT id, home, template, s.params

  FROM pvw15_template_styles as s

  LEFT JOIN pvw15_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	kakasszekivendeg.s.template,const	1	Using index condition; Using where

**Profil**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.78 ms** **Utolsó lekérdezés után: 8.84 ms** **Memória lekérdezése: 0.027 MB memória a lekérdezés előtt: 3.609 MB** **Visszaadott sorok: 38**

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

  FROM `pvw15_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyfrontendseo','com_finder','com_formmaker','com_installer','com_jhotelreservation','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_assets	ALL	idx_asset_name	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	91	Using where

**Profil**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.25 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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:203
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.50 ms** **Utolsó lekérdezés után: 0.41 ms** **Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.692 MB** **Visszaadott sorok: 18**

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

  FROM `pvw15_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_assets	ALL	idx_asset_name,idx_parent_id	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	91	Using where

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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:203
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.97 ms** **Utolsó lekérdezés után: 2.34 ms** **Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.787 MB** **Visszaadott sorok: 31**

SHOW FULL COLUMNS 
  FROM `pvw15_content`

**Magyarázat**

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

**Profil**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.18 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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:203
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: 5.71 ms** **Memória lekérdezése: 0.014 MB memória a lekérdezés előtt: 3.928 MB**

UPDATE pvw15_content

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

  WHERE `id` = '4'

**Magyarázat**

**Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE pvw15_content SET `hits` = (`hits` + 1) WHERE `id` = '4'**

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.04 ms
updating	0.07 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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:203
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.74 ms** **Utolsó lekérdezés után: 2.97 ms** **Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 3.997 MB** **Visszaadott sorok: 1**

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM pvw15_content AS a

  INNER JOIN pvw15_categories AS c 
  on c.id = a.catid

  LEFT JOIN pvw15_users AS u 
  on u.id = a.created_by

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

  LEFT JOIN pvw15_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 4 
  AND c.published > 0 
  AND a.language in ('hu-HU','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-18 12:08:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-18 12:08:05') 
  AND (a.state = 1 OR a.state =2)

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	0	const row not found
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

**Profil**

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
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:203
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.52 ms** **Utolsó lekérdezés után: 3.63 ms** **Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 4.102 MB** **Visszaadott sorok: 4**

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

  FROM `pvw15_contentitem_tag_map` AS m 

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

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

**Magyarázat**

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

**Profil**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
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:203
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.63 ms** **Utolsó lekérdezés után: 85.48 ms** **Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 4.554 MB** **Visszaadott sorok: 1**

SELECT language,id

  FROM `pvw15_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	16	Using where

**Profil**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
8	PlgSystemLanguageFilter->onAfterDispatch()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.42 ms** **Utolsó lekérdezés után: 1.41 ms** **Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 4.584 MB** **Visszaadott sorok: 0**

SELECT `c2`.`language`,`c2`.`id`

  FROM `pvw15_menu` AS `c`

  INNER JOIN `pvw15_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `pvw15_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `pvw15_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 104

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profil**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
8	PlgSystemLanguageFilter->onAfterDispatch()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.55 ms** **Utolsó lekérdezés után: 1.01 ms** **Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 4.620 MB** **Visszaadott sorok: 0**

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `pvw15_content` AS `c`

  INNER JOIN `pvw15_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `pvw15_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `pvw15_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `pvw15_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 4 
  AND c2.access IN (1,1,5) 
  AND c2.language != 'hu-HU' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2021-04-18 12:08:05') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2021-04-18 12:08:05') 
  AND c2.state = 1

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profil**

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.06 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
11	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
10	ContentHelperAssociation::getAssociations()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:783
8	PlgSystemLanguageFilter->onAfterDispatch()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.98 ms** **Utolsó lekérdezés után: 4.38 ms** **Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 4.708 MB** **Visszaadott sorok: 17**

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

  FROM pvw15_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-18 12:08:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-18 12:08:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 104 OR mm.menuid <= 0) 
  AND m.language IN ('hu-HU','*')

  ORDER BY m.position, m.ordering

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	13	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	kakasszekivendeg.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	kakasszekivendeg.m.id	2	Using where; Using index

**Profil**

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.07 ms
executing	0.01 ms
Sorting result	0.11 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:100
7	require JROOT/templates/protostar/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:1076
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:209
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.53 ms** **Utolsó lekérdezés után: 64.07 ms** **Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 4.784 MB** **Visszaadott sorok: 1**

SELECT * 
  FROM pvw15_formmaker 
  WHERE id=1

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_formmaker	const	PRIMARY	PRIMARY	4	const	1

**Profil**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/modules/mod_formmaker/helper.php:46
12	modFormmaker::showform()	JROOT/modules/mod_formmaker/helper.php:24
11	modFormmaker::load()	JROOT/modules/mod_formmaker/mod_formmaker.php:17
10	include JROOT/modules/mod_formmaker/mod_formmaker.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
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:209
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.29 ms** **Utolsó lekérdezés után: 0.17 ms** **Memória lekérdezése: 0.036 MB memória a lekérdezés előtt: 4.819 MB** **Visszaadott sorok: 1**

SELECT css 
  FROM pvw15_formmaker_themes 
  WHERE id=39

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_formmaker_themes	const	PRIMARY	PRIMARY	4	const	1

**Profil**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_formmaker/helper.php:58
12	modFormmaker::showform()	JROOT/modules/mod_formmaker/helper.php:24
11	modFormmaker::load()	JROOT/modules/mod_formmaker/mod_formmaker.php:17
10	include JROOT/modules/mod_formmaker/mod_formmaker.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Lekérdezés ideje: 0.28 ms** **Utolsó lekérdezés után: 0.18 ms** **Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 4.894 MB** **Visszaadott sorok: 1**

SELECT `views` 
  FROM pvw15_formmaker_views 
  WHERE form_id=1

**Magyarázat**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pvw15_formmaker_views	const	PRIMARY	PRIMARY	4	const	1

**Profil**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/modules/mod_formmaker/helper.php:6945
12	modFormmaker::defaultphp()	JROOT/modules/mod_formmaker/helper.php:33
11	modFormmaker::load()	JROOT/modules/mod_formmaker/mod_formmaker.php:17
10	include JROOT/modules/mod_formmaker/mod_formmaker.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
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:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Lekérdezés ideje: 0.30 ms** **Utolsó lekérdezés után: 0.18 ms** **Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 4.914 MB**

UPDATE pvw15_formmaker_views 
  SET  views=92436 
  where form_id=1

**Magyarázat**

**Az EXPLAIN nem lehetséges a következő lekérdezésen: UPDATE pvw15_formmaker_views SET views=92436 where form_id=1**

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.03 ms
updating	0.05 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
13	JDatabase->query()	JROOT/modules/mod_formmaker/helper.php:6957
12	modFormmaker::defaultphp()	JROOT/modules/mod_formmaker/helper.php:33
11	modFormmaker::load()	JROOT/modules/mod_formmaker/mod_formmaker.php:17
10	include JROOT/modules/mod_formmaker/mod_formmaker.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
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:209
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: 11.47 ms** **Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 5.306 MB** **Visszaadott sorok: 0**

SELECT * 
  FROM `pvw15_plg_easyfrontendseo` 
  WHERE `url` = 'index.php?option=com_content&view=article&id=4&Itemid=104&lang=hu-HU'

**Magyarázat**

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

**Profil**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

**Hívási verem**

#	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:358
13	PlgSystemEasyFrontendSeo->onBeforeCompileHead()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1090
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:209
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**]

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

SELECT táblák:

**2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `pvw15_assets`**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `pvw15_extensions`**

**1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `pvw15_menu` AS `c` 
  INNER JOIN `pvw15_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `pvw15_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `pvw15_menu` AS `c2` 
  ON a2.id = c2.`id`**

**1 × SELECT language,id 
  FROM `pvw15_menu`**

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `pvw15_contentitem_tag_map` AS m  
  INNER JOIN `pvw15_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM pvw15_content AS a 
  INNER JOIN pvw15_categories AS c 
  on c.id = a.catid 
  LEFT JOIN pvw15_users AS u 
  on u.id = a.created_by 
  LEFT JOIN pvw15_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pvw15_content_rating AS v 
  ON a.id = v.content_id**

**1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `pvw15_content` AS `c` 
  INNER JOIN `pvw15_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `pvw15_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `pvw15_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `pvw15_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'**

**1 × SELECT * 
  FROM pvw15_formmaker**

**1 × SELECT * 
  FROM `pvw15_plg_easyfrontendseo`**

**1 × SELECT `views` 
  FROM pvw15_formmaker_views**

**1 × SELECT css 
  FROM pvw15_formmaker_themes**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pvw15_modules AS m 
  LEFT JOIN pvw15_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pvw15_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT * 
  FROM `pvw15_hotelreservation_hotels`**

**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM pvw15_extensions**

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

**1 × SELECT id, rules 
  FROM `pvw15_viewlevels**

**1 × SELECT `session_id` 
  FROM `pvw15_session`**

**1 × SELECT `enabled` 
  FROM `pvw15_extensions`**

**1 × SELECT * 
  FROM pvw15_languages**

**1 × SELECT `data` 
  FROM `pvw15_session`**

**1 × select * 
  from pvw15_hotelreservation_offers of
      
  inner join pvw15_hotelreservation_offers_vouchers hov 
  on of.offer_id = hov.offerId**

**1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM pvw15_menu AS m 
  LEFT JOIN pvw15_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `pvw15_extensions`**

**1 × SELECT id, home, template, s.params 
  FROM pvw15_template_styles as s 
  LEFT JOIN pvw15_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

EGYÉB táblák:

**1 × UPDATE pvw15_formmaker_views 
  SET  views=92436**

**1 × UPDATE pvw15_content 
  SET `hits` = (`hits` + 1)**

**1 × SHOW FULL COLUMNS 
  FROM `pvw15_content**

**1 × UPDATE `pvw15_extensions` 
  SET `params` = '{\"mediaversion\":\"79640c49e86a027c93a9e61dbd850e95\"}'**

**1 × INSERT INTO `pvw15_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'616c66686e6a666663397134623768646d3932396c6b6a376331', 1, 1618747685, 0, '', 0**


# JROOT/libraries/src/Language/Text.php

PLG_DEBUG_CALL_STACK_CALLER="DEBUG CALL STACK CALLER"
PLG_DEBUG_CALL_STACK_FILE_AND_LINE="DEBUG CALL STACK FILE AND LINE"
PLG_DEBUG_CALL_STACK_SAME_FILE="DEBUG CALL STACK SAME FILE"

Kakasszéki Vendégházak

Információ

Foglalás

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

31 naplózott lekérdezés 16.08 ms

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

SELECT táblák:

EGYÉB táblák:

Elemzési hibák a nyelvi fájlokban

Betöltött nyelvi fájlok

Lefordítatlan karakterláncok

Információ

Foglalás

**Joomla! hibakereső konzol**

**Munkamenet**

**Profilinformációk**

**Idő**

**Memória**

**Memóriahasználat**

**Adatbázis lekérdezések**

**31 naplózott lekérdezés** 16.08 ms

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

**SELECT táblák:**

**EGYÉB táblák:**

**Elemzési hibák a nyelvi fájlokban**

**Betöltött nyelvi fájlok**

**Lefordítatlan karakterláncok**

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

31 naplózott lekérdezés 16.08 ms

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

SELECT táblák:

EGYÉB táblák:

Elemzési hibák a nyelvi fájlokban

Betöltött nyelvi fájlok

Lefordítatlan karakterláncok