Wywiadówka 30.11.2023

{
    "__default": {
        "session": {
            "counter": 8,
            "timer": {
                "start": 1715912130,
                "last": 1715912138,
                "now": 1715912138
            },
            "client": {
                "forwarded": "18.117.100.129"
            },
            "token": "Mkwc8moFWuADFAamuRB82UGAm6oohcKx"
        },
        "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
        }
    }
}

Czas

Pamięć

14 zapytań zarejestrowanych 16.29 ms

1. Czas zapytania: 0.55 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 3.704 MB Zwróconych wierszy: 1

   SELECT `data`
   
     FROM `zsip_session`
   
     WHERE `session_id` = X'3166636533386231353666313230626163643130623266363539626661366162'

   Objaśnienie

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

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   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:758
   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

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

2. Czas zapytania: 0.37 ms Po ostatnim zapytaniu: 3.67 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.422 MB Zwróconych wierszy: 5

   SELECT id, rules
   
     FROM `zsip_viewlevels`

   Objaśnienie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zsip_viewlevels	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	5	100.00	NULL

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   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

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

3. Czas zapytania: 0.48 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.434 MB Zwróconych wierszy: 2

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

   Objaśnienie

   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

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   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

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

4. Czas zapytania: 1.00 ms Po ostatnim zapytaniu: 15.46 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 7.045 MB Zwróconych wierszy: 0

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

   Objaśnienie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	no matching row in const table

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
   12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
   11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
   10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
   9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

5. Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 7.050 MB Zwróconych wierszy: 1

   SELECT `alias`,`catid`
   
     FROM `zsip_content`
   
     WHERE `id` = 1309

   Objaśnienie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zsip_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
   10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
   9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
   8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
   7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
   6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

6. Czas zapytania: 2.38 ms Po ostatnim zapytaniu: 0.33 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 7.139 MB

   UPDATE `zsip_extensions`
   
     SET `params` = '{\"mediaversion\":\"8011ec030615a2c78a84351f8847ea3f\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Objaśnienie

   Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `zsip_extensions` SET `params` = '{\"mediaversion\":\"8011ec030615a2c78a84351f8847ea3f\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   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/jqueryeasy/helper.php:13
   9	plgJQueryEasyHelper::isEnabledOnPage()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73
   8	plgSystemJqueryeasy->onAfterRoute()	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:1122
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

7. Czas zapytania: 1.17 ms Po ostatnim zapytaniu: 4.67 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 7.884 MB Zwróconych wierszy: 36

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `zsip_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_admin','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_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

   Objaśnienie

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

   Profile

   Status	Duration
   starting	0.14 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.08 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.14 ms
   preparing	0.03 ms
   executing	0.45 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.03 ms

   Stos wywołania

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
   11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
   10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

8. Czas zapytania: 2.06 ms Po ostatnim zapytaniu: 0.11 ms Pamięć zapytania: 0.196 MB Pamięć przed zapytaniem: 7.930 MB Zwróconych wierszy: 1372

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `zsip_assets`
   
     WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

   Objaśnienie

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zsip_assets	NULL	ALL	idx_asset_name,idx_parent_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1430	21.40	Using where

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
   16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
   15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
   14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
   11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
   10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

9. Czas zapytania: 2.93 ms Po ostatnim zapytaniu: 1.36 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 9.068 MB Zwróconych wierszy: 31

   SHOW FULL COLUMNS 
     FROM `zsip_content`

   Objaśnienie

   Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `zsip_content`

   Profile

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

   Stos wywołania

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
   11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
   10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

10. Czas zapytania: 1.16 ms Po ostatnim zapytaniu: 1.62 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 9.331 MB

    UPDATE zsip_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '1309'

    Objaśnienie

    Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE zsip_content SET `hits` = (`hits` + 1) WHERE `id` = '1309'

    Profile

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.08 ms
    updating	0.15 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.52 ms
    closing tables	0.06 ms
    freeing items	0.04 ms
    cleaning up	0.00 ms

    Stos wywołania

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

11. Czas zapytania: 0.92 ms Po ostatnim zapytaniu: 1.29 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 9.504 MB Zwróconych wierszy: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM zsip_content AS a
    
      INNER JOIN zsip_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN zsip_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN zsip_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN zsip_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 1309 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 02:15:39') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 02:15:39') 
      AND (a.state = 1 OR a.state =2)

    Objaśnienie

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

    Profile

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

    Stos wywołania

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
    13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->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

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

12. Czas zapytania: 1.30 ms Po ostatnim zapytaniu: 1.02 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 9.685 MB Zwróconych wierszy: 27

    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 `zsip_categories` AS `s`
    
      INNER JOIN `zsip_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 = 14
    
      ORDER BY c.lft

    Objaśnienie

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Uruchomiono metodę filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	60	60.67	Using where

    Profile

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 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.05 ms
    executing	0.42 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Stos wywołania

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->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

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

13. Czas zapytania: 0.54 ms Po ostatnim zapytaniu: 0.56 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 9.847 MB Zwróconych wierszy: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `zsip_contentitem_tag_map` AS m 
    
      INNER JOIN `zsip_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1309 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Objaśnienie

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	baza23164_2030.m.tag_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.03 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.03 ms

    Stos wywołania

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    11	ContentViewArticle->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

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

14. Czas zapytania: 1.09 ms Po ostatnim zapytaniu: 3.64 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 10.428 MB Zwróconych wierszy: 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 zsip_fields AS a
    
      LEFT JOIN `zsip_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN zsip_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN zsip_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN zsip_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN zsip_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `zsip_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 (14,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Objaśnienie

    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; Uruchomiono metodę filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	baza23164_2030.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	baza23164_2030.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	baza23164_2030.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	baza23164_2030.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	baza23164_2030.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	baza23164_2030.a.id	1	100.00	Using where; Using index; Distinct

    Profile

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

    Stos wywołania

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

12 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

1. 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 `zsip_categories` AS `s` 
     INNER JOIN `zsip_categories` AS `c` 
     ON (s.lft <= c.lft 
     AND c.lft < s.rgt) OR (c.lft < s.lft 
     AND s.rgt < c.rgt)

2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `zsip_assets`

3. 1 × SELECT `data` 
     FROM `zsip_session`

4. 1 × SELECT id, rules 
     FROM `zsip_viewlevels

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

6. 1 × SELECT `alias`,`catid` 
     FROM `zsip_content`

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

8. 1 × SELECT `m`.`tag_id`,`t`.* 
     FROM `zsip_contentitem_tag_map` AS m  
     INNER JOIN `zsip_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

9. 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 zsip_fields AS a 
     LEFT JOIN `zsip_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN zsip_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN zsip_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN zsip_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN zsip_fields_groups AS g 
     ON g.id = a.group_id 
     LEFT JOIN `zsip_fields_categories` AS fc 
     ON fc.field_id = a.id

INNE tabele:

1. 1 × UPDATE `zsip_extensions` 
     SET `params` = '{\"mediaversion\":\"8011ec030615a2c78a84351f8847ea3f\"}'

2. 1 × SHOW FULL COLUMNS 
     FROM `zsip_content

3. 1 × UPDATE zsip_content 
     SET `hits` = (`hits` + 1)