Németország

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

Idő

Memória

11 naplózott lekérdezés 18.60 ms

1. Lekérdezés ideje: 0.38 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 1.028 MB Visszaadott sorok: 0

   SELECT `session_id`
   
     FROM `ast_session`
   
     WHERE `session_id` = X'75326535326a6a656c68716a3473393374396b71766a706e7635' 
     LIMIT 1

   Magyarázat

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

   Profil

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

   Hívási verem

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

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

   ---

2. Lekérdezés ideje: 5.16 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.004 MB memória a lekérdezés előtt: 1.034 MB

   INSERT INTO `ast_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'75326535326a6a656c68716a3473393374396b71766a706e7635', 1, 1680154222, 0, '', 0)

   Magyarázat

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

   Profil

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

   Hívási verem

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

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

   ---

3. Lekérdezés ideje: 0.21 ms Utolsó lekérdezés után: 7.36 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.138 MB Visszaadott sorok: 5

   SELECT id, rules
   
     FROM `ast_viewlevels`

   Magyarázat

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

   Profil

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

   Hívási verem

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

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

   ---

4. Lekérdezés ideje: 0.28 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 1.150 MB Visszaadott sorok: 2

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

   Magyarázat

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

   Profil

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

   Hívási verem

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

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

   ---

5. Lekérdezés ideje: 5.68 ms Utolsó lekérdezés után: 36.66 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 1.724 MB

   UPDATE `ast_extensions`
   
     SET `params` = '{\"mediaversion\":\"4ec44ad80118265b3f8b5a9c5a52a9a2\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Magyarázat

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

   Profil

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

   Hívási verem

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

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

   ---

6. Lekérdezés ideje: 0.88 ms Utolsó lekérdezés után: 81.02 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 4.592 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,(
   SELECT COUNT(i.`id`)
   
     FROM `ast_content` AS `i`
   
     WHERE i.`catid` = c.id 
     AND i.state = 1) AS numitems
   
     FROM `ast_categories` AS `s`
   
     INNER JOIN `ast_categories` AS `c` 
     ON (s.lft <= c.lft 
     AND c.lft < s.rgt) OR (c.lft < s.lft 
     AND s.rgt < c.rgt)
   
     WHERE (c.extension='com_content' OR c.extension='system') 
     AND c.access IN (1,1,5) 
     AND c.published = 1 
     AND s.id = 227
   
     ORDER BY c.lft

   Magyarázat

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
   1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	248	97.61	Using index condition; Using where
   2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	portal_krehu_site.c.id	49	46.45	Using index condition; Using where

   Profil

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

   Hívási verem

   #	Hívó	Fájl és sorok száma
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
   15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
   14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
   13	ContentModelCategories->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
   12	JViewLegacy->get()	JROOT/libraries/src/MVC/View/CategoriesView.php:56
   11	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
   10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Lekérdezés ideje: 0.61 ms Utolsó lekérdezés után: 10.91 ms Memória lekérdezése: 0.028 MB memória a lekérdezés előtt: 4.729 MB Visszaadott sorok: 0

   SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
   
     FROM ast_fields AS a
   
     LEFT JOIN `ast_languages` AS l 
     ON l.lang_code = a.language
   
     LEFT JOIN ast_users AS uc 
     ON uc.id=a.checked_out
   
     LEFT JOIN ast_viewlevels AS ag 
     ON ag.id = a.access
   
     LEFT JOIN ast_users AS ua 
     ON ua.id = a.created_user_id
   
     LEFT JOIN ast_fields_groups AS g 
     ON g.id = a.group_id
   
     WHERE a.context = 'com_content.categories' 
     AND a.access IN (1,1,5) 
     AND (a.group_id = 0 OR g.access IN (1,1,5)) 
     AND a.state = 1 
     AND (a.group_id = 0 OR g.state = 1)
   
     ORDER BY a.ordering ASC

   Magyarázat

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

   Profil

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

   Hívási verem

   #	Hívó	Fájl és sorok száma
   27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
   24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
   22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
   21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
   20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
   18	JHtmlContent::prepare()	Ugyanaz a hívás, mint egy sorral lejjebb.
   17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/bt_education/html/com_content/categories/default.php:31
   14	include JROOT/templates/bt_education/html/com_content/categories/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
   13	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
   12	JViewLegacy->display()	JROOT/libraries/src/MVC/View/CategoriesView.php:97
   11	Joomla\CMS\MVC\View\CategoriesView->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
   10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Lekérdezés ideje: 0.93 ms Utolsó lekérdezés után: 19.10 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 4.758 MB Visszaadott sorok: 29

   SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
   
     FROM ast_modules AS m
   
     LEFT JOIN ast_modules_menu AS mm 
     ON mm.moduleid = m.id
   
     LEFT JOIN ast_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id
   
     WHERE m.published = 1 
     AND e.enabled = 1 
     AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-30 05:30:22') 
     AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-30 05:30:22') 
     AND m.access IN (1,1,5) 
     AND m.client_id = 0 
     AND (mm.menuid = 455 OR mm.menuid <= 0)
   
     ORDER BY m.position, m.ordering

   Magyarázat

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

   Profil

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

   Hívási verem

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

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

   ---

9. Lekérdezés ideje: 0.70 ms Utolsó lekérdezés után: 40.42 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 5.161 MB Visszaadott sorok: 41

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

   Magyarázat

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

   Profil

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

   Hívási verem

   #	Hívó	Fájl és sorok száma
   26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   24	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   23	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   22	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   21	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   20	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:442
   19	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
   18	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
   16	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentshowcase/classes/content.php:159
   15	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentshowcase/helpers/helper.php:71
   14	modBtContentShowcaseHelper::getList()	JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php:21
   13	include JROOT/modules/mod_bt_contentshowcase/mod_bt_contentshowcase.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
   12	JModuleHelper::renderModule()	Ugyanaz a hívás, mint egy sorral lejjebb.
   11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:609
   9	JModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
   8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
   7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
   6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
   5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
   4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
   3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
   2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Lekérdezés ideje: 3.19 ms Utolsó lekérdezés után: 1.08 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 5.222 MB Visszaadott sorok: 0

    SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM ast_content AS a
    
      LEFT JOIN ast_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ast_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ast_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ast_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ast_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (138) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-30 05:30:22') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-30 05:30:22')
    
      ORDER BY a.created asc 
      LIMIT 5

    Magyarázat

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

    Profil

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.03 ms
    Creating tmp table	0.14 ms
    executing	2.33 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.08 ms
    closing tables	0.05 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Hívási verem

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

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

    ---

11. Lekérdezés ideje: 0.57 ms Utolsó lekérdezés után: 346.66 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 7.143 MB Visszaadott sorok: 0

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

    Magyarázat

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

    Profil

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

    Hívási verem

    #	Hívó	Fájl és sorok száma
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:488
    8	plgSystemBt_socialconnect_system::getSocialID()	JROOT/plugins/system/bt_socialconnect_system/bt_socialconnect_system.php:148
    7	plgSystemBt_socialconnect_system->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

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

SELECT táblák:

1. 1 × SELECT `session_id` 
     FROM `ast_session`

2. 1 × SELECT id, rules 
     FROM `ast_viewlevels

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

4. 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,( SELECT COUNT(i.`id`) 
     FROM `ast_content` AS `i`

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

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

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

8. 1 × SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
     FROM ast_content AS a 
     LEFT JOIN ast_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN ast_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN ast_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN ast_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN ast_content_rating AS v 
     ON a.id = v.content_id

9. 1 × SELECT social_id 
     FROM ast_bt_connections

EGYÉB táblák:

1. 1 × INSERT INTO `ast_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'75326535326a6a656c68716a3473393374396b71766a706e7635', 1, 1680154222, 0, '', 0

2. 1 × UPDATE `ast_extensions` 
     SET `params` = '{\"mediaversion\":\"4ec44ad80118265b3f8b5a9c5a52a9a2\"}'