Новини

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1752393287,
                "last": 1752393287,
                "now": 1752393287
            },
            "token": "9AlFOcYVFjMuwLebzw9UW9FvvUvOuUBc"
        },
        "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
        }
    }
}

Час

Пам'ять

16 запитів для зареєстрованих користувачів 40.28 ms

1. Витрачений час на запит: 0.36 ms Запит пам'яті: 0.005 MB пам'ять до запиту: 1.199 MB Повернуто рядків: 0

   SELECT `session_id`
   
     FROM `sowc4_session`
   
     WHERE `session_id` = '471c874b291495738bbd273280378a7b' 
     LIMIT 1

   Роз'яснення

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sowc4_session	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Профіль

   Status	Duration
   Starting	0.05 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.00 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   Optimizing	0.00 ms
   Statistics	0.04 ms
   Preparing	0.00 ms
   Executing	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.02 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.15 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

2. Витрачений час на запит: 0.17 ms Після останнього запиту: 0.03 ms Запит пам'яті: 0.004 MB пам'ять до запиту: 1.205 MB

   INSERT INTO `sowc4_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('471c874b291495738bbd273280378a7b', 1, '1752393287', 0, '', 0)

   Роз'яснення

   EXPLAIN не можливий для запиту: INSERT INTO `sowc4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('471c874b291495738bbd273280378a7b', 1, '1752393287', 0, '', 0)

   Профіль

   Status	Duration
   Starting	0.03 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.01 ms
   Update	0.04 ms
   Waiting for query cache lock	0.00 ms
   Update	0.00 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.02 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

3. Витрачений час на запит: 0.05 ms Після останнього запиту: 0.71 ms Запит пам'яті: 0.005 MB пам'ять до запиту: 1.289 MB Повернуто рядків: 5

   SELECT id, rules
   
     FROM `sowc4_viewlevels`

   Роз'яснення

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sowc4_viewlevels	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	5	100.00

   Профіль

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   Sending cached result to clien	0.02 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   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: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: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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

4. Витрачений час на запит: 0.04 ms Після останнього запиту: 0.03 ms Запит пам'яті: 0.005 MB пам'ять до запиту: 1.301 MB Повернуто рядків: 2

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

   Роз'яснення

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

   Профіль

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   Sending cached result to clien	0.02 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   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: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: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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

5. Витрачений час на запит: 0.19 ms Після останнього запиту: 4.00 ms Запит пам'яті: 0.005 MB пам'ять до запиту: 2.091 MB

   UPDATE `sowc4_extensions`
   
     SET `params` = '{\"mediaversion\":\"c7aa6c3d96d619e1c815395e991dbfa7\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Роз'яснення

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sowc4_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

   Профіль

   Status	Duration
   Starting	0.03 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.03 ms
   End of update loop	0.00 ms
   Waiting for query cache lock	0.00 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.02 ms
   Updating status	0.00 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

6. Витрачений час на запит: 0.58 ms Після останнього запиту: 3.11 ms Запит пам'яті: 0.010 MB пам'ять до запиту: 2.322 MB Повернуто рядків: 34

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `sowc4_assets`
   
     WHERE `name` IN ('root.1','com_admin','com_ajax','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_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper','com_yendifvideoshare')

   Роз'яснення

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

   Профіль

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.19 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.01 ms
   table lock	0.03 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.04 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.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
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.02 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
   14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
   12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
   11	ContentViewCategory->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: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: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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

7. Витрачений час на запит: 3.29 ms Після останнього запиту: 0.05 ms Запит пам'яті: 0.010 MB пам'ять до запиту: 2.374 MB Повернуто рядків: 9094

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

   Роз'яснення

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	sowc4_assets	ALL	idx_asset_name,idx_parent_id	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	8988	100.00	Using where

   Профіль

   Status	Duration
   Sending data	0.05 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.05 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.05 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.05 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.04 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.04 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.04 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.03 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.09 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.13 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.12 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.08 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
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
   19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
   18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
   17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
   14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
   12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
   11	ContentViewCategory->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: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: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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

8. Витрачений час на запит: 17.72 ms Після останнього запиту: 7.73 ms Запит пам'яті: 0.009 MB пам'ять до запиту: 11.426 MB Повернуто рядків: 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 `sowc4_content` AS `i`
   
     WHERE i.`catid` = c.id 
     AND i.state = 1) AS numitems
   
     FROM `sowc4_categories` AS `s`
   
     INNER JOIN `sowc4_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.published = 1 
     AND s.id = 8
   
     ORDER BY c.lft

   Роз'яснення

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
   1	PRIMARY	c	range|filter	cat_idx,idx_left_right	idx_left_right|cat_idx	4|203	NULL	8 (68%)	68.18	Using index condition; Using where; Using rowid filter
   2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	gxyiwmbj_oldugcciforg.c.id	243	100.00	Using index condition; Using where

   Профіль

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.06 ms
   checking permissions	0.00 ms
   Opening tables	0.05 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   Waiting for query cache lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Sorting result	0.00 ms
   Executing	0.00 ms
   Sending data	0.07 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   Executing	0.00 ms
   Sending data	17.11 ms
   End of update loop	0.03 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.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Removing tmp table	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.02 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
   16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
   15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
   14	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:423
   13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
   12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
   11	ContentViewCategory->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: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: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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

9. Витрачений час на запит: 9.64 ms Після останнього запиту: 1.92 ms Запит пам'яті: 0.009 MB пам'ять до запиту: 11.468 MB Повернуто рядків: 10

   SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
     CASE WHEN c.published = 2 
     AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
     CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
     CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
   							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
   
     FROM sowc4_content AS a
   
     LEFT JOIN sowc4_categories AS c 
     ON c.id = a.catid
   
     LEFT JOIN sowc4_users AS ua 
     ON ua.id = a.created_by
   
     LEFT JOIN sowc4_users AS uam 
     ON uam.id = a.modified_by
   
     LEFT JOIN sowc4_categories as parent 
     ON parent.id = c.parent_id
   
     LEFT JOIN sowc4_content_rating AS v 
     ON a.id = v.content_id
   
     WHERE c.published = 1 
     AND a.state = 1 
     AND a.catid = 8 
     AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-13 07:54:47') 
     AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-13 07:54:47')
   
     ORDER BY  c.lft,   
     CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
     LIMIT 50, 10

   Роз'яснення

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
   1	SIMPLE	a	ALL	idx_state,idx_catid	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	6338	100.00	Using where; Використовуючи filesort
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.created_by	1	100.00	Using where
   1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.modified_by	1	100.00	Using where
   1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	100.00	Using where
   1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.id	1	100.00	Using where

   Профіль

   Status	Duration
   Starting	0.02 ms
   Waiting for query cache lock	0.00 ms
   starting	0.00 ms
   Checking query cache for query	0.09 ms
   checking permissions	0.00 ms
   Opening tables	0.67 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.02 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.05 ms
   Optimizing	0.02 ms
   Statistics	0.07 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	8.23 ms
   Waiting for query cache lock	0.03 ms
   Creating sort index	0.16 ms
   Waiting for query cache lock	0.00 ms
   Creating sort index	0.02 ms
   Waiting for query cache lock	0.00 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.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.04 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Стек викликів

   #	Виклик	Номер файлу і рядка
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
   15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
   14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
   13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
   12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
   11	ContentViewCategory->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: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: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

   [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

   ---

10. Витрачений час на запит: 5.90 ms Після останнього запиту: 1.66 ms Запит пам'яті: 0.009 MB пам'ять до запиту: 11.790 MB Повернуто рядків: 1

    SELECT COUNT(*)
    
      FROM sowc4_content AS a
    
      LEFT JOIN sowc4_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN sowc4_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN sowc4_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN sowc4_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN sowc4_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE c.published = 1 
      AND a.state = 1 
      AND a.catid = 8 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-13 07:54:47') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-13 07:54:47')

    Роз'яснення

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	a	ALL	idx_state,idx_catid	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	6338	100.00	Using where

    Профіль

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	5.52 ms
    End of update loop	0.03 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.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.03 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Стек викликів

    #	Виклик	Номер файлу і рядка
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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: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: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

    [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

    ---

11. Витрачений час на запит: 0.73 ms Після останнього запиту: 1.52 ms Запит пам'яті: 0.007 MB пам'ять до запиту: 11.800 MB Повернуто рядків: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `sowc4_contentitem_tag_map` AS m 
    
      INNER JOIN `sowc4_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 8 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Роз'яснення

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	3	100.00	Using where
    1	SIMPLE	m	ALL	idx_tag_type	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	9	100.00	Using where; Using join buffer (flat, BNL join)

    Профіль

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.39 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.03 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.04 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
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Стек викликів

    #	Виклик	Номер файлу і рядка
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    11	ContentViewCategory->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: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: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

    [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

    ---

12. Витрачений час на запит: 0.22 ms Після останнього запиту: 13.27 ms Запит пам'яті: 0.011 MB пам'ять до запиту: 12.121 MB Повернуто рядків: 1

    SELECT `extension_id`,`name`,`enabled`,`params`
    
      FROM sowc4_extensions
    
      WHERE `type` = 'plugin' 
      AND `element` = 'osembed' 
      AND `folder` = 'content'

    Роз'яснення

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

    Профіль

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.02 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
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 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.02 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Стек викликів

    #	Виклик	Номер файлу і рядка
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    22	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:152
    21	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:122
    20	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:51
    19	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:38
    18	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:148
    17	Alledia\Framework\Joomla\Extension\Helper::getExtensionForElement()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:109
    16	Alledia\Framework\Joomla\Extension\Helper::loadLibrary()	JROOT/plugins/content/osembed/include.php:33
    15	include_once JROOT/plugins/content/osembed/include.php	JROOT/plugins/content/osembed/osembed.php:14
    14	require_once JROOT/plugins/content/osembed/osembed.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
    13	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    12	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/category/view.html.php:82
    11	ContentViewCategory->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: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: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

    [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

    ---

13. Витрачений час на запит: 0.36 ms Після останнього запиту: 3.89 ms Запит пам'яті: 0.010 MB пам'ять до запиту: 12.234 MB Повернуто рядків: 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 `sowc4_categories` AS `s`
    
      INNER JOIN `sowc4_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 = 8
    
      ORDER BY c.lft

    Роз'яснення

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	8	77.27	Using index condition; Using where

    Профіль

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	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
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.03 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
    Waiting for query cache lock	0.00 ms
    Updating status	0.04 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Стек викликів

    #	Виклик	Номер файлу і рядка
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    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/category/view.html.php:108
    11	ContentViewCategory->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: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: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

    [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

    ---

14. Витрачений час на запит: 0.84 ms Після останнього запиту: 0.04 ms Запит пам'яті: 0.009 MB пам'ять до запиту: 12.252 MB Повернуто рядків: 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, g.note as group_note
    
      FROM sowc4_fields AS a
    
      LEFT JOIN `sowc4_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN sowc4_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN sowc4_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN sowc4_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN sowc4_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `sowc4_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 (8,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

    Роз'яснення

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Використовуючи filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	gxyiwmbj_oldugcciforg.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.checked_out	1	100.00
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	gxyiwmbj_oldugcciforg.a.id	1	100.00	Using where; Using index

    Профіль

    Status	Duration
    Starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.46 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 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.03 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 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
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.16 ms
    Reset for next command	0.00 ms

    Стек викликів

    #	Виклик	Номер файлу і рядка
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    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:327
    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:479
    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/category/view.html.php:108
    11	ContentViewCategory->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: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: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

    [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

    ---

15. Витрачений час на запит: 0.12 ms Після останнього запиту: 136.74 ms Запит пам'яті: 0.007 MB пам'ять до запиту: 12.842 MB Повернуто рядків: 7

    SELECT a.id, a.title, a.alias, a.catid AS category_id, a.access, a.created AS date, a.introtext, a.fulltext, a.images
    
      FROM sowc4_content AS a
    
      LEFT JOIN sowc4_categories AS c 
      ON c.id = a.catid
    
      WHERE a.catid = 10 
      AND c.published = 1 
      AND a.state = 1 
      AND a.publish_up <= '2025-07-13 07:50' 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-13 07:50')
    
      ORDER BY date DESC 
      LIMIT 10

    Роз'яснення

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
    1	SIMPLE	a	ref	idx_state,idx_catid	idx_catid	4	const	7	100.00	Using where; Використовуючи filesort

    Профіль

    Status	Duration
    Starting	0.07 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Стек викликів

    #	Виклик	Номер файлу і рядка
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_raxo_allmode/helper.php:374
    14	ModRAXO_Allmode_PRO::getList()	Такий самий, як і виклик у нижньому рядку.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:38
    10	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    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

    [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

    ---

16. Витрачений час на запит: 0.07 ms Після останнього запиту: 0.07 ms Запит пам'яті: 0.012 MB пам'ять до запиту: 12.888 MB Повернуто рядків: 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 `sowc4_categories` AS `s`
    
      INNER JOIN `sowc4_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 = 10
    
      ORDER BY c.lft

    Роз'яснення

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	10	77.27	Using index condition; Using where

    Профіль

    Status	Duration
    Starting	0.03 ms
    Waiting for query cache lock	0.00 ms
    starting	0.00 ms
    Checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    Sending cached result to clien	0.02 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Стек викликів

    #	Виклик	Номер файлу і рядка
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
    25	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    24	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    23	ContentRouter->getCategorySegment()	Такий самий, як і виклик у нижньому рядку.
    22	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    21	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    20	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    19	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    18	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_raxo_allmode/helper.php:437
    14	ModRAXO_Allmode_PRO::getList()	Такий самий, як і виклик у нижньому рядку.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php:38
    10	include JROOT/modules/mod_raxo_allmode/mod_raxo_allmode.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    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

    [Додати директиву xdebug.file_link_format для вашого файлу php.ini для посилання файлів]

    ---

14 типи запитів: зареєстрований, відсортований за знайденим

Вибірка таблиць:

1. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `sowc4_assets`

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

3. 1 × SELECT `session_id` 
     FROM `sowc4_session`

4. 1 × SELECT id, rules 
     FROM `sowc4_viewlevels

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

6. 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 `sowc4_content` AS `i`

7. 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 sowc4_content AS a 
     LEFT JOIN sowc4_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN sowc4_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN sowc4_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN sowc4_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN sowc4_content_rating AS v 
     ON a.id = v.content_id

8. 1 × SELECT COUNT(*) 
     FROM sowc4_content AS a 
     LEFT JOIN sowc4_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN sowc4_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN sowc4_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN sowc4_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN sowc4_content_rating AS v 
     ON a.id = v.content_id

9. 1 × SELECT `m`.`tag_id`,`t`.* 
     FROM `sowc4_contentitem_tag_map` AS m  
     INNER JOIN `sowc4_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

10. 1 × SELECT `extension_id`,`name`,`enabled`,`params` 
      FROM sowc4_extensions

11. 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, g.note as group_note 
      FROM sowc4_fields AS a 
      LEFT JOIN `sowc4_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN sowc4_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN sowc4_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN sowc4_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN sowc4_fields_groups AS g 
      ON g.id = a.group_id 
      LEFT JOIN `sowc4_fields_categories` AS fc 
      ON fc.field_id = a.id

12. 1 × SELECT a.id, a.title, a.alias, a.catid AS category_id, a.access, a.created AS date, a.introtext, a.fulltext, a.images 
      FROM sowc4_content AS a 
      LEFT JOIN sowc4_categories AS c 
      ON c.id = a.catid

Інші таблиці:

1. 1 × INSERT INTO `sowc4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('471c874b291495738bbd273280378a7b', 1, '1752393287', 0, '', 0

2. 1 × UPDATE `sowc4_extensions` 
     SET `params` = '{\"mediaversion\":\"c7aa6c3d96d619e1c815395e991dbfa7\"}'