Kapcsolat

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733338010,
                "last": 1733338010,
                "now": 1733338010
            },
            "token": "4JAMPbjSsXv5OJUHdvRhrv1oRTTpnH0M"
        },
        "registry": {
            "com_quix": {
                "edit": {
                    "page": {
                        "id": "6"
                    }
                }
            }
        },
        "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ő: 6.66 ms / 6.66 ms Memória: 0.762 MB / 0.97 MB Application: afterLoad

Idő: 28.90 ms / 35.57 ms Memória: 1.710 MB / 2.68 MB Application: afterInitialise

Idő: 15.89 ms / 51.46 ms Memória: 0.723 MB / 3.40 MB Application: afterRoute

Idő: 1.54 ms / 53.00 ms Memória: 0.088 MB / 3.49 MB Application: beforeRenderComponent com_quix

Idő: 137.61 ms / 190.61 ms Memória: 12.960 MB / 16.45 MB Application: beforeRenderModule mod_articles_news (Google maps)

Idő: 5.58 ms / 196.19 ms Memória: 0.110 MB / 16.56 MB Application: Before Access::preloadComponents (all components)

Idő: 1.04 ms / 197.22 ms Memória: 0.136 MB / 16.70 MB Application: After Access::preloadComponents (all components)

Idő: 0.05 ms / 197.27 ms Memória: 0.000 MB / 16.69 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Idő: 0.30 ms / 197.58 ms Memória: 0.019 MB / 16.71 MB Application: After Access::getAssetRules (id:8 name:com_content)

Idő: 14.43 ms / 212.01 ms Memória: 0.476 MB / 17.19 MB Application: afterRenderModule mod_articles_news (Google maps)

Idő: 1.21 ms / 213.22 ms Memória: 0.000 MB / 16.83 MB Application: afterRenderComponent com_quix

Idő: 1.42 ms / 214.64 ms Memória: 0.012 MB / 16.84 MB Application: afterDispatch

Idő: 41.94 ms / 256.58 ms Memória: 0.618 MB / 17.46 MB Application: beforeRenderModule mod_search (Keresés)

Idő: 1.31 ms / 257.89 ms Memória: 0.026 MB / 17.48 MB Application: afterRenderModule mod_search (Keresés)

Idő: 0.06 ms / 257.95 ms Memória: 0.000 MB / 17.47 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Idő: 2.70 ms / 260.65 ms Memória: 0.052 MB / 17.52 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Idő: 0.12 ms / 260.78 ms Memória: 0.000 MB / 17.51 MB Application: beforeRenderModule mod_currentmoon (MOD_CURRENTMOON_XML_LABEL)

Idő: 0.69 ms / 261.47 ms Memória: 0.015 MB / 17.52 MB Application: afterRenderModule mod_currentmoon (MOD_CURRENTMOON_XML_LABEL)

Idő: 7.66 ms / 269.12 ms Memória: 0.614 MB / 18.14 MB Application: afterRender

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	qsv3t_session	const	PRIMARY	PRIMARY	766	const	1

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Ugyanaz a hívás, mint egy sorral lejjebb.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php: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:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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	qsv3t_session	const	PRIMARY	PRIMARY	766	const	1	Using index

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `qsv3t_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('v7nccqh1vgm4klga0utrbkd8t4', 1, '1733338010', 0, '', 0)

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.01 ms
Update	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.03 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 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:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.34 ms Utolsó lekérdezés után: 0.63 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 1.645 MB Visszaadott sorok: 38

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

  FROM `qsv3t_extensions`

  WHERE `type` = 'component'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	qsv3t_extensions	ref	extension	extension	82	const	38	Using index condition

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.19 ms Utolsó lekérdezés után: 0.86 ms Memória lekérdezése: 0.015 MB memória a lekérdezés előtt: 1.754 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `qsv3t_viewlevels`

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

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

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

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

SELECT b.id

  FROM qsv3t_usergroups AS a

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

  WHERE a.id = 1

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	1	Using where; Using index

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
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: 0.18 ms Memória lekérdezése: 0.019 MB memória a lekérdezés előtt: 1.816 MB Visszaadott sorok: 98

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

  FROM qsv3t_extensions

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

  ORDER BY ordering

Magyarázat

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
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.96 ms Utolsó lekérdezés után: 19.54 ms Memória lekérdezése: 0.032 MB memória a lekérdezés előtt: 2.755 MB Visszaadott sorok: 27

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 qsv3t_menu AS m

  LEFT JOIN qsv3t_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	84	Using index condition; Using where; Fájlrendezés használata
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 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
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.44 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.47 ms Utolsó lekérdezés után: 4.84 ms Memória lekérdezése: 0.026 MB memória a lekérdezés előtt: 3.106 MB Visszaadott sorok: 1

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

  FROM `qsv3t_extensions`

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

Magyarázat

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

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:460
9	plgSystemK2->onAfterRoute()	Ugyanaz a hívás, mint egy sorral lejjebb.
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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.23 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.018 MB memória a lekérdezés előtt: 3.113 MB

UPDATE `qsv3t_extensions`

  SET `params` = '{\"mediaversion\":\"f3682eac29d942279bfaaf6a718fb78c\"}'

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

Magyarázat

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.05 ms
Updating	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:460
9	plgSystemK2->onAfterRoute()	Ugyanaz a hívás, mint egy sorral lejjebb.
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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
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: 2.34 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 3.279 MB Visszaadott sorok: 1

SELECT *

  FROM qsv3t_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	qsv3t_languages	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	2	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
13	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
12	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:274
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:55
10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:478
9	plgSystemK2->onAfterRoute()	Ugyanaz a hívás, mint egy sorral lejjebb.
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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
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.44 ms Memória lekérdezése: 0.018 MB memória a lekérdezés előtt: 3.316 MB Visszaadott sorok: 4

SELECT id, home, template, s.params

  FROM qsv3t_template_styles as s

  LEFT JOIN qsv3t_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_k2/helpers/html.php:290
10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:478
9	plgSystemK2->onAfterRoute()	Ugyanaz a hívás, mint egy sorral lejjebb.
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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
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.70 ms Utolsó lekérdezés után: 9.85 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 3.669 MB Visszaadott sorok: 18

SHOW FULL COLUMNS 
  FROM `qsv3t_extensions`

Magyarázat

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

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
After opening tables	0.00 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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.08 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
13	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
12	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
11	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:159
10	qxGetComponentInfo()	JROOT/libraries/quix/app/bootstrap.php:67
9	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
8	JLoader::import()	JROOT/libraries/loader.php:833
7	jimport()	JROOT/components/com_quix/quix.php:28
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.70 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 3.741 MB Visszaadott sorok: 1

SELECT `extension_id`

  FROM `qsv3t_extensions`

  WHERE element = 'com_quix'

Magyarázat

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
12	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
11	Joomla\CMS\Table\Extension->find()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:160
10	qxGetComponentInfo()	JROOT/libraries/quix/app/bootstrap.php:67
9	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
8	JLoader::import()	JROOT/libraries/loader.php:833
7	jimport()	JROOT/components/com_quix/quix.php:28
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.21 ms Utolsó lekérdezés után: 0.18 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 3.761 MB Visszaadott sorok: 1

SELECT *

  FROM qsv3t_extensions

  WHERE `extension_id` = '10014'

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
11	Joomla\CMS\Table\Table->load()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:161
10	qxGetComponentInfo()	JROOT/libraries/quix/app/bootstrap.php:67
9	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
8	JLoader::import()	JROOT/libraries/loader.php:833
7	jimport()	JROOT/components/com_quix/quix.php:28
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.21 ms Utolsó lekérdezés után: 0.30 ms Memória lekérdezése: 0.016 MB memória a lekérdezés előtt: 3.785 MB Visszaadott sorok: 1

SELECT template 
  FROM qsv3t_template_styles 
  WHERE client_id = 0 
  AND home = 1

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:123
10	quix_default_template()	JROOT/libraries/quix/app/bootstrap.php:100
9	include_once JROOT/libraries/quix/app/bootstrap.php	JROOT/libraries/loader.php:226
8	JLoader::import()	JROOT/libraries/loader.php:833
7	jimport()	JROOT/components/com_quix/quix.php:28
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.12 ms Utolsó lekérdezés után: 15.55 ms Memória lekérdezése: 0.030 MB memória a lekérdezés előtt: 4.267 MB Visszaadott sorok: 20

SHOW FULL COLUMNS 
  FROM `qsv3t_quix`

Magyarázat

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

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.26 ms
After opening tables	0.00 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.29 ms
After opening tables	0.01 ms
checking permissions	0.11 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.11 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_quix/tables/page.php:28
15	QuixTablePage->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_quix/models/page.php:139
13	QuixModelPage->getTable()	JROOT/components/com_quix/models/page.php:70
12	QuixModelPage->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:48
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.83 ms Utolsó lekérdezés után: 0.32 ms Memória lekérdezése: 0.037 MB memória a lekérdezés előtt: 4.339 MB Visszaadott sorok: 1

SELECT *

  FROM qsv3t_quix

  WHERE `id` = '6'

Magyarázat

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.04 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.37 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_quix/models/page.php:73
12	QuixModelPage->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:48
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.28 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 4.388 MB Visszaadott sorok: 1

SELECT title

  FROM qsv3t_usergroups

  WHERE id = 1

Magyarázat

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/components/com_quix/helpers/quix.php:34
13	QuixFrontendHelper::getGroupNameByGroupId()	JROOT/components/com_quix/models/page.php:114
12	QuixModelPage->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:48
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.66 ms Utolsó lekérdezés után: 0.37 ms Memória lekérdezése: 0.034 MB memória a lekérdezés előtt: 4.431 MB Visszaadott sorok: 16

SHOW FULL COLUMNS 
  FROM `qsv3t_users`

Magyarázat

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
After opening tables	0.00 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.01 ms
After opening tables	0.00 ms
checking permissions	0.09 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_quix/models/page.php:120
12	QuixModelPage->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:48
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.23 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 4.497 MB Visszaadott sorok: 1

SELECT *

  FROM `qsv3t_users`

  WHERE `id` = 579

Magyarázat

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_quix/models/page.php:120
12	QuixModelPage->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:48
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 1.22 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 5.258 MB Visszaadott sorok: 1

SELECT `g`.`id`,`g`.`title`

  FROM `qsv3t_usergroups` AS g

  INNER JOIN `qsv3t_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 579

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.m.group_id	1

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_quix/models/page.php:120
12	QuixModelPage->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:48
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.33 ms Utolsó lekérdezés után: 0.26 ms Memória lekérdezése: 0.017 MB memória a lekérdezés előtt: 5.279 MB

UPDATE qsv3t_quix

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

  WHERE `id` = '6'

Magyarázat

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.04 ms
Updating	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.03 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
13	Joomla\CMS\Table\Table->hit()	JROOT/components/com_quix/models/page.php:303
12	QuixModelPage->getHit()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_quix/views/page/view.html.php:70
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 107.57 ms Memória lekérdezése: 0.059 MB memória a lekérdezés előtt: 16.282 MB Visszaadott sorok: 1

SELECT *

  FROM qsv3t_modules

  WHERE published = 1 
  AND id = 133

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	qsv3t_modules	const	PRIMARY,published	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.09 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.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
46	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
45	JDatabaseDriver->loadObject()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:17
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:27
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:78
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/template.php:245
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:79
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 0.62 ms Memória lekérdezése: 0.064 MB memória a lekérdezés előtt: 16.380 MB Visszaadott sorok: 10

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

  FROM qsv3t_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-04 18:46:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-04 18:46:50') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 664 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	52	Using where; Fájlrendezés használata
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	kamarasomogy_2.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	kamarasomogy_2.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
51	JDatabaseDriver->loadObjectList()	Ugyanaz a hívás, mint egy sorral lejjebb.
50	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
49	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
48	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
47	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
46	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/libraries/src/Helper/ModuleHelper.php:127
45	Joomla\CMS\Helper\ModuleHelper::isEnabled()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:24
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:27
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:78
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/template.php:245
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:79
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 6.06 ms Memória lekérdezése: 0.072 MB memória a lekérdezés előtt: 16.564 MB Visszaadott sorok: 38

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

  FROM `qsv3t_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_advportfoliopro','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_quix','com_redirect','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Magyarázat

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

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.16 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
57	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
56	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
55	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
54	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
53	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
52	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:440
51	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
50	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
49	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
48	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:97
47	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
46	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
45	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:28
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:27
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:78
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/template.php:245
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:79
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.36 ms Utolsó lekérdezés után: 0.79 ms Memória lekérdezése: 0.073 MB memória a lekérdezés előtt: 16.710 MB Visszaadott sorok: 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

  FROM qsv3t_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (88) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-04 18:46:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-04 18:46:50')

  ORDER BY a.publish_up DESC 
  LIMIT 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	Using where; Fájlrendezés használata
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.a.id	1	Using where

Profil

Status	Duration
Starting	0.17 ms
checking permissions	0.00 ms
Opening tables	0.73 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.12 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.64 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.28 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.06 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
51	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
50	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
49	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
48	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:97
47	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
46	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
45	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:28
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:27
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:78
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/template.php:245
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:79
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.07 ms Utolsó lekérdezés után: 2.07 ms Memória lekérdezése: 0.078 MB memória a lekérdezés előtt: 16.823 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 `qsv3t_categories` AS `s`

  INNER JOIN `qsv3t_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) 
  AND c.published = 1 
  AND s.id = 88

  ORDER BY c.lft

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	11	Using index condition; Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.61 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
60	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
59	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
58	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
57	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
56	ContentRouter->getCategorySegment()	Ugyanaz a hívás, mint egy sorral lejjebb.
55	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
54	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
53	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
52	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:670
51	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
50	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
49	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
48	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:110
47	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
46	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
45	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:28
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:27
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:78
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/template.php:245
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:79
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 2.45 ms Memória lekérdezése: 0.078 MB memória a lekérdezés előtt: 16.978 MB Visszaadott sorok: 0

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

  FROM qsv3t_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_articles_news.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Fájlrendezés használata
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	kamarasomogy_2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	kamarasomogy_2.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
61	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
60	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
59	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
58	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
57	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
56	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
55	PlgSystemFields->onContentPrepare()	Ugyanaz a hívás, mint egy sorral lejjebb.
54	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
53	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
52	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
51	JHtmlContent::prepare()	Ugyanaz a hívás, mint egy sorral lejjebb.
50	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
49	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
48	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news/helper.php:120
47	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
46	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
45	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:28
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:27
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:78
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/template.php:245
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:79
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.51 ms Utolsó lekérdezés után: 3.26 ms Memória lekérdezése: 0.075 MB memória a lekérdezés előtt: 17.067 MB Visszaadott sorok: 0

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

  FROM qsv3t_fields AS a

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

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Magyarázat

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

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
57	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
56	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
55	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
54	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
53	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
52	PlgSystemFields->onContentPrepare()	Ugyanaz a hívás, mint egy sorral lejjebb.
51	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
50	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
49	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
48	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:130
47	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
46	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
45	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/quix/app/drivers/joomla/joomla.php:28
44	qxModuleById()	JROOT/libraries/quix/app/elements/joomla-module/view.php:16
43	include JROOT/libraries/quix/app/elements/joomla-module/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
42	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
41	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
40	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
39	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
38	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
37	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
36	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/column/view.php:27
35	include JROOT/libraries/quix/app/nodes/column/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
34	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
33	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
32	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
31	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
30	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
29	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
28	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/row/view.php:50
27	include JROOT/libraries/quix/app/nodes/row/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
26	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
25	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
24	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
23	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
22	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
21	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
20	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/nodes/section/view.php:78
19	include JROOT/libraries/quix/app/nodes/section/view.php	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:42
18	ThemeXpert\View\Engines\PhpEngine->evaluatePath()	JROOT/libraries/quix/src/View/Engines/PhpEngine.php:19
17	ThemeXpert\View\Engines\PhpEngine->get()	JROOT/libraries/quix/src/View/View.php:58
16	ThemeXpert\View\View->make()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:129
15	ThemeXpert\Quix\Renderers\NodeRenderer->renderNode()	Ugyanaz a hívás, mint egy sorral lejjebb.
14	array_map()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:205
13	ThemeXpert\Quix\Renderers\NodeRenderer->renderNodes()	JROOT/libraries/quix/src/Quix/Renderers/NodeRenderer.php:193
12	ThemeXpert\Quix\Renderers\NodeRenderer->render()	JROOT/libraries/quix/app/drivers/joomla/template.php:245
11	quixRenderItem()	JROOT/components/com_quix/views/page/view.html.php:79
10	QuixViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_quix/controller.php:41
8	QuixController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_quix/quix.php:35
6	require_once JROOT/components/com_quix/quix.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 53.58 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 17.650 MB Visszaadott sorok: 142

SELECT * 
  FROM qsv3t_acymailing_config

Magyarázat

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

Profil

Status	Duration
Starting	0.13 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.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.13 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
14	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
12	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
11	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
8	plgSystemRegacymailing->onAfterRender()	Ugyanaz a hívás, mint egy sorral lejjebb.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1047
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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]

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

SELECT táblák:

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM qsv3t_modules AS m 
  LEFT JOIN qsv3t_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN qsv3t_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM qsv3t_modules
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `qsv3t_usergroups` AS g 
  INNER JOIN `qsv3t_user_usergroup_map` AS m 
  ON m.group_id = g.id

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

```
1 × SELECT * 
  FROM `qsv3t_users`
```

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `qsv3t_categories` AS `s` 
  INNER JOIN `qsv3t_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 * 
  FROM qsv3t_acymailing_confi

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM qsv3t_fields AS a 
  LEFT JOIN `qsv3t_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN qsv3t_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN qsv3t_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN qsv3t_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN qsv3t_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `qsv3t_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM qsv3t_fields AS a 
  LEFT JOIN `qsv3t_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN qsv3t_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN qsv3t_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN qsv3t_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN qsv3t_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT title 
  FROM qsv3t_usergroups

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 
  FROM qsv3t_content AS a 
  LEFT JOIN qsv3t_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN qsv3t_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN qsv3t_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN qsv3t_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN qsv3t_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT template 
  FROM qsv3t_template_styles

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

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

1 × SELECT id, rules 
  FROM `qsv3t_viewlevels

1 × SELECT `session_id` 
  FROM `qsv3t_session`

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 qsv3t_menu AS m 
  LEFT JOIN qsv3t_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM qsv3t_languages
```

1 × SELECT `data` 
  FROM `qsv3t_session`

```
1 × SELECT * 
  FROM qsv3t_extensions
```

1 × SELECT `extension_id` 
  FROM `qsv3t_extensions`

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

```
1 × SELECT * 
  FROM qsv3t_quix
```

EGYÉB táblák:

1 × SHOW FULL COLUMNS 
  FROM `qsv3t_users

1 × UPDATE qsv3t_quix 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `qsv3t_quix

1 × SHOW FULL COLUMNS 
  FROM `qsv3t_extensions

1 × UPDATE `qsv3t_extensions` 
  SET `params` = '{\"mediaversion\":\"f3682eac29d942279bfaaf6a718fb78c\"}'

1 × INSERT INTO `qsv3t_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('v7nccqh1vgm4klga0utrbkd8t4', 1, '1733338010', 0, '', 0

ELÉRHETŐSÉG

OMVK Somogy Megyei Területi Szervezete

Telefonszám

E-mail cím

Keresé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 15.84 ms

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

SELECT táblák:

EGYÉB táblák: