Новини

Україна вже не отримає два транші МВФ до кінця року — Сологуб

Четвер, 24 вересня 2020 14:17

Автор Фінансовий клуб

Україна втратила можливість отримати від МВФ два транші до кінця 2020 року, тому треба постаратися отримати хоча б один за новою програмою stand-by.

Про це заявив заступник голови Національного банку Дмитро Сологуб у інтерв'ю ІФ.

За його словами, при цьому треба розуміти, що новий транш МВФ прив'язаний до схвалення держбюджету-2021.

«Те, на що наразі ми можемо орієнтуватися і намагатися зробити - це до кінця року отримати транш МВФ. Найімовірніше, як і у 2018 році, він буде прив'язаний до ухвалення бюджету. Тобто ми вже говоримо, умовно, про листопад», - наголосив Сологуб.

За його словами, Нацбанк пропонував уряду сформувати проєкт держбюджету-2021 на більш консервативному прогнозі, ніж зокрема інфляція 7,3% і середньорічний курс 29,1 грн/$.

Сологуб зауважив, що закладений Кабміном дефіцит держбюджету 6% ВВП суперечить принципу контрциклічності, закладеному в програмі з МВФ, і є сумніви стосовно можливості його фінансування.

«З макроекономічної точки зору тут має йтися про помірне зниження дефіциту. Я не кажу про 2% ВВП, але точно менше закладених 6%. Крім того, є ще один фактор - можливість фінансування цього дефіциту. Ми бачили, що в бюджеті закладені випуски внутрішніх позик на 549 млрд грн», - пояснив він.

Сологуб також нагадав, що інші програми міжнародної допомоги Україні прив'язані до програми МВФ.

За його словами, затримка із міжнародним фінансуванням пов'язана зі зміною на початку липня глави НБУ Якова Смолія, який подав у відставку через політичний тиск.

«Нацбанк фактично повернувся у ситуацію 2015 року, в якій він вже був, коли кредит довіри від МВФ потрібно здобувати практично з нуля. І, як показує практика, на це йде приблизно 6-9 місяців. І причому під час цих 6-9 місяців має бути clean track record», - вважає Сологуб.

Голова НБУ Кирило Шевченко раніше зазначав, що наступний транш від МВФ надійде до кінця року.

9 червня МВФ затвердив нову 18-місячну програму кредитування України на $5 млрд із негайним виділенням $2,1 млрд першого траншу.

Мінфін очікував прибуття місії МВФ щодо першого перегляду програми ще в липні-серпні, однак цього не сталося. Тепер Марченко запевняє, що місія прибуде до зими.

У вересні МВФ планував провести перший огляд виконання Україною програми stand-by, після чого ухвалить рішення про наступний транш.

Наразі МВФ не може назвати точної дати надання нового траншу. Водночас там нагадали Україні про незалежність антикорупційних органів.

Україна звернулася до МВФ із пропозицією розпочати роботу місії в Україні в онлайн-режимі.

Підписуйтесь на новини FinClub в Telegram, Viber, Twitter, Facebook

теги #МВФ #транш #затримка #сологуб #нацбанк #держбюджет

Схожі матеріали (за тегом)

Держбюджет отримав 2,3 трлн грн до загального фонду за вісім місяців

Релізи

Користувачі OTP Bank UA можуть виграти 10 000 грн на пальне

Більше можливостей для міжнародних платежів: ПУМБ розширив можливості SWIFT переказів у застосунку

Кредити готівкою, карткові кредити, позики для ФОПів: як Ідея Банк нарощує обсяги кредитування в 2026 році

Акордбанк допомагає укомплектувати підрозділ ЗСУ

«Південний» вкотре підтримав ветеранську спільноту: спорт як шлях до відновлення

ТАСКОМБАНК почав кредитувати девелоперів під майбутні об’єкти нерухомості

ТОП-новини

Відео/Фото

Онлайн-платежі без ілюзій

Кредитування енергообладнання в Україні: як стати енергонезалежним

Кредити для агробізнесу: посівна-2026 та нові інструменти

Х Церемонія нагородження «Банки року – 2026» (онлайн-трансляція)

Преміальний банкінг у 2026 році: цифрова еволюція та персоналізований підхід

Банківський сектор України: здобутки 2025 року та очікування від 2026-го (онлайн-трансляція)

FINANCIAL CLUB AWARDS – 2025 (онлайн-трансляція)

Інфографіка

Що відбулось з Україною за два роки війни. Фінансовий вимір

Як війна змінила бюджет України

Рік повномасштабного вторгнення у фінансових графіках

Бюджет війни. На що витратять 2,5 трильйона гривень

Інфляція стала головною економічною проблемою світу

Консоль налагодження Joomla

Сесія

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1789970653,
                "last": 1789970653,
                "now": 1789970653
            },
            "token": "bnXYuoA9c86dyNPI2wPIhsOFWWGmhDGW"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "uk-UA"
        },
        "com_mailto": {
            "links": {
                "dd9b05651c7c1895303f533a4a11320143822967": {
                    "link": "https://www.finclub.net/news/ukraina-vzhe-ne-otrymaie-dva-transhi-mvf-do-kintsia-roku-solohub.html",
                    "expiry": 1789970654
                }
            }
        }
    }
}

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

13 дублікат(-ів) знайдено!

3 дублікатів: #7 #8 #9

5 дублікатів: #27 #31 #33 #35 #37

5 дублікатів: #28 #32 #34 #36 #38

Витрачений час на запит: 2.49 ms

SHOW VARIABLES LIKE 'query_cache_type'

Роз'яснення

EXPLAIN не можливий для запиту: SHOW VARIABLES LIKE 'query_cache_type'

Профіль

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

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

#	Виклик	Номер файлу та рядка
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:604
10	JDatabaseDriverPdomysql->hasQueryCacheEnabled()	JROOT/libraries/joomla/database/driver/pdomysql.php:160
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:188

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

Витрачений час на запит: 0.38 ms Після останнього запиту: 0.05 ms

SHOW VARIABLES LIKE 'have_profiling'

Роз'яснення

EXPLAIN не можливий для запиту: SHOW VARIABLES LIKE 'have_profiling'

Профіль

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

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

#	Виклик	Номер файлу та рядка
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:590
10	JDatabaseDriverPdomysql->hasProfiling()	JROOT/libraries/joomla/database/driver/pdomysql.php:165
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:188

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

Витрачений час на запит: 1.85 ms Після останнього запиту: 23.04 ms

SELECT `session_id`

  FROM `js937_session`

  WHERE `session_id` = X'656b3231656c6c7376346e6b6b6968666e67336d676f62653372' 
  LIMIT 1

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:188

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

Витрачений час на запит: 2.66 ms Після останнього запиту: 16.19 ms

SELECT id, rules

  FROM `js937_viewlevels`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverPdo->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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.20 ms Після останнього запиту: 0.08 ms

SELECT b.id

  FROM js937_usergroups AS a

  LEFT JOIN js937_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	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverPdo->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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 1.27 ms Після останнього запиту: 115.34 ms

SELECT id, alias, parent 
  FROM js937_k2_categories 
  WHERE published = 1 
  AND alias = 'ukraina-vzhe-ne-otrymaie-dva-transhi-mvf-do-kintsia-roku-solohub'

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_categories	ALL	category,published,idx_category	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	88	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	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	100.69 ms
End of update loop	5.44 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:509
11	getCategoryProps()	JROOT/components/com_k2/router.php:326
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->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:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 100.99 ms Після останнього запиту: 0.05 ms

Дублі запитів: #8 #9

SELECT id, alias 
  FROM js937_k2_items 
  WHERE published = 1 
  AND alias = 'ukraina-vzhe-ne-otrymaie-dva-transhi-mvf-do-kintsia-roku-solohub'

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:486
11	getItemProps()	JROOT/components/com_k2/router.php:355
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->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:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 107.69 ms Після останнього запиту: 0.23 ms

Дублі запитів: #7 #9

SELECT id, alias 
  FROM js937_k2_items 
  WHERE published = 1 
  AND alias = 'ukraina-vzhe-ne-otrymaie-dva-transhi-mvf-do-kintsia-roku-solohub'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
checking permissions	0.00 ms
After opening tables	0.00 ms
init for update	0.00 ms
init	0.01 ms
Updating main table	0.01 ms
init	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
init for update	0.34 ms
Updating	0.04 ms
End of update loop	0.01 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:486
11	getItemProps()	JROOT/components/com_k2/router.php:355
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->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:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 97.92 ms Після останнього запиту: 0.09 ms

Дублі запитів: #7 #8

SELECT id, alias 
  FROM js937_k2_items 
  WHERE published = 1 
  AND alias = 'ukraina-vzhe-ne-otrymaie-dva-transhi-mvf-do-kintsia-roku-solohub'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.10 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.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_k2/router.php:486
11	getItemProps()	JROOT/components/com_k2/router.php:355
10	k2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->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:1142
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.47 ms Після останнього запиту: 1.06 ms

UPDATE `js937_extensions`

  SET `params` = '{\"mediaversion\":\"2345f0986819f33684ad3b213c3414f9\"}'

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

Роз'яснення

EXPLAIN не можливий для запиту: UPDATE `js937_extensions` SET `params` = '{\"mediaversion\":\"2345f0986819f33684ad3b213c3414f9\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профіль

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

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

#	Виклик	Номер файлу та рядка
14	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->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:1190
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 4.06 ms Після останнього запиту: 45.31 ms

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

  FROM `js937_assets`

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

Роз'яснення

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

Профіль

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.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.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:15
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 6.25 ms Після останнього запиту: 19.05 ms

SELECT id 
  FROM js937_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_categories	range	category,published,access,trash,idx_category	category	8	NULL	88	Using where; Using index

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
13	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.32 ms Після останнього запиту: 0.15 ms

SELECT * 
  FROM js937_k2_items 
  WHERE id=45105 
  AND language IN ('uk-UA', '*') 
  LIMIT 1

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
13	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.64 ms Після останнього запиту: 0.51 ms

SHOW FULL COLUMNS 
  FROM `js937_k2_categories`

Роз'яснення

EXPLAIN не можливий для запиту: SHOW FULL COLUMNS FROM `js937_k2_categories`

Профіль

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

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

#	Виклик	Номер файлу та рядка
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
18	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
15	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.07 ms Після останнього запиту: 5.36 ms

SELECT * 
  FROM js937_k2_categories 
  WHERE id = '278'

Роз'яснення

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

Профіль

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	0.01 ms
Optimizing	0.01 ms
Statistics	0.06 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.03 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 1.86 ms Після останнього запиту: 7.04 ms

SELECT tag.*
            
  FROM js937_k2_tags AS tag
            JOIN js937_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 45105
            
  ORDER BY xref.id ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	itemID	4	const	6	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	finclub_j201803.xref.tagID	1	Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 1.34 ms Після останнього запиту: 0.50 ms

SELECT * 
  FROM js937_k2_attachments 
  WHERE itemID=45105

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_attachments	ref	itemID	itemID	4	const	1

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1450
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 1.91 ms Після останнього запиту: 3.13 ms

SHOW FULL COLUMNS 
  FROM `js937_users`

Роз'яснення

EXPLAIN не можливий для запиту: SHOW FULL COLUMNS FROM `js937_users`

Профіль

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	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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
23	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.17 ms Після останнього запиту: 0.11 ms

SELECT *

  FROM `js937_users`

  WHERE `id` = 267

Роз'яснення

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

Профіль

Status	Duration
Starting	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
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.88 ms Після останнього запиту: 0.79 ms

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

  FROM `js937_usergroups` AS g

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

  WHERE `m`.`user_id` = 267

Роз'яснення

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

Профіль

Status	Duration
Starting	0.10 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.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	6.34 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.04 ms
Removing tmp table	0.10 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:210
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 4.30 ms Після останнього запиту: 0.71 ms

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM js937_k2_users 
  WHERE userID=267

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_users	ref	userID	userID	4	const	1

Профіль

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.28 ms
Creating sort index	0.04 ms
Removing tmp table	0.09 ms
Creating sort index	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.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1702
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:46
14	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:213
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 11.59 ms Після останнього запиту: 11.45 ms

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 js937_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  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	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	finclub_j201803.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.group_id	1	Using where

Профіль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.01 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.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:599
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 3.31 ms Після останнього запиту: 1.81 ms

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 js937_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (278,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) 
  AND a.language in ('*','uk-UA')

  ORDER BY a.ordering ASC

Роз'яснення

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

Профіль

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	0.02 ms
Optimizing	0.01 ms
Statistics	0.18 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	1.28 ms
Creating sort index	6.80 ms
Removing tmp table	0.01 ms
Creating sort index	0.00 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:670
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 5.84 ms Після останнього запиту: 9.02 ms

SELECT * 
  FROM js937_k2_comments 
  WHERE itemID=45105 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 10

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_comments	range	itemID,published,latestComments,countComments	latestComments	4	NULL	1	Using where

Профіль

Status	Duration
Starting	0.77 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.37 ms
Optimizing	0.33 ms
Statistics	3.70 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.56 ms
Removing tmp table	0.00 ms
Sending data	0.00 ms
Creating sort index	0.36 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
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1471
13	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:227
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 8.67 ms Після останнього запиту: 1.08 ms

SELECT itemID
            
  FROM js937_k2_tags_xref
            
  WHERE tagID IN(4411,8993,9681,9786,9795,14397)
                
  AND itemID != 45105
            
  GROUP BY itemID

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_tags_xref	range	tagID,itemID,idx_tags_xref_common	idx_tags_xref_common	8	NULL	3998	Using where; Using index; Using temporary; Використовуючи filesort

Профіль

Status	Duration
Starting	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
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:611
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 14.43 ms Після останнього запиту: 0.86 ms

SELECT i.*, c.alias AS categoryalias
            
  FROM js937_k2_items AS i
            
  LEFT JOIN js937_k2_categories AS c 
  ON c.id = i.catid
            
  WHERE i.published = 1
                
  AND i.trash = 0
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-09-21 06:04:13')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-09-21 06:04:13') 
  AND i.access IN(1,1,5) 
  AND i.language IN('uk-UA', '*') 
  AND c.access IN(1,1,5) 
  AND c.language IN('uk-UA', '*') 
  AND c.published = 1 
  AND c.trash = 0 
  AND i.id IN(193,217,335,385,644,739,828,915,970,1011,1054,1112,1134,1181,1193,1240,1267,1301,1347,1367,1469,1510,11308,11362,11788,11866,11873,11934,11984,12034,12070,12101,12107,12114,12153,12166,12197,12227,12307,12331,12351,12406,12413,12424,12494,12512,12556,12614,12626,12689,12692,12740,12747,12824,12830,12837,12872,12915,12934,12956,12968,13003,13007,13020,13066,13083,13128,13143,13151,13192,13278,13346,13412,13416,13422,13472,13513,13527,13538,13545,13546,13554,13602,13623,13669,13680,13714,13718,13723,13726,13749,13750,13755,13770,13771,13853,13857,13858,13859,13866,13956,13958,13977,13978,14090,14142,14144,14177,14181,14211,14212,14251,14252,14291,14292,14316,14317,14345,14346,14347,14351,14352,14357,14358,14359,14360,14361,14362,14363,14367,14369,14385,14386,14389,14392,14398,14399,14428,14429,14531,14537,14604,14605,14692,14720,14728,14730,14739,14740,14803,14805,14806,14807,14829,14899,14908,14909,14924,14927,14948,14949,15000,15003,15018,15026,15032,15036,15048,15050,15051,15053,15059,15067,15068,15072,15076,15086,15091,15092,15095,15102,15106,15111,15114,15116,15129,15154,15208,15212,15249,15250,15285,15302,15438,15672,15778,15791,15792,15794,15812,15813,15820,15834,15843,15880,15903,15905,15927,15952,16004,16009,16047,16138,16142,16212,16247,16248,16258,16298,16315,16316,16321,16378,16409,16451,16505,16523,16620,16636,16655,16688,16735,16738,16875,16883,16884,16906,16913,16914,16951,16984,16994,16998,16999,17031,17032,17041,17044,17070,17102,17111,17135,17153,17189,17202,17287,17345,17355,17359,17433,17583,17637,17686,17702,17733,17734,17735,17736,17737,17738,17753,17756,17759,17767,17795,17843,17852,17892,17911,17916,18106,18128,18149,18209,18235,18367,18368,18369,18431,18433,18441,18468,18470,18484,18622,18628,18630,18653,18718,18762,18790,18854,18874,18887,18896,18917,19013,19019,19022,19025,19058,19081,19094,19142,19153,19197,19214,19381,19450,19542,19551,19561,19598,19650,19656,19690,19743,19762,19845,19945,19956,19965,19966,19979,19982,19991,20021,20102,20151,20170,20212,20220,20274,20307,20308,20317,20385,20386,20391,20398,20445,20458,20469,20503,20519,20533,20538,20547,20550,20569,20573,20616,20633,20656,20665,20691,20836,20890,20897,20900,20939,20952,20958,20959,20960,20969,20976,20989,20994,21105,21169,21176,21241,21253,21364,21439,21442,21458,21474,21477,21513,21611,21730,21866,21900,22030,22053,22110,22127,22132,22137,22140,22160,22179,22195,22217,22222,22253,22273,22274,22365,22449,22451,22477,22498,22508,22512,22524,22550,22581,22597,22655,22669,22673,22676,22725,22727,22732,22745,22750,22751,22752,22848,22872,22893,22898,22956,22963,23050,23061,23071,23073,23081,23086,23099,23186,23218,23225,23278,23292,23315,23351,23370,23387,23427,23430,23490,23500,23539,23593,23647,23649,23672,23684,23694,23700,23714,23720,23775,23777,23793,23830,23842,23875,23899,23920,23939,23957,23971,24007,24025,24141,24237,24276,24398,24440,24474,24536,24547,24603,24610,24615,24646,24648,24652,24661,24668,24687,24688,24696,24697,24699,24700,24741,24742,24756,24764,24876,24902,24926,24928,24976,24979,25035,25058,25100,25164,25165,25185,25220,25237,25307,25316,25381,25412,25425,25515,25541,25621,25642,25680,25684,25719,25752,25783,25788,25815,25821,25830,25905,25928,25972,25973,26040,26171,26279,26307,26356,26362,26458,26470,26560,26687,26722,26731,26742,26866,26903,26907,26916,27073,27076,27168,27227,27240,27313,27322,27330,27334,27341,27343,27417,27424,27449,27455,27473,27508,27528,27533,27560,27577,27637,27668,27682,27722,27727,27765,27772,27801,27812,27870,27906,27915,27967,28005,28020,28044,28083,28087,28102,28116,28118,28125,28126,28131,28132,28136,28139,28142,28147,28149,28217,28229,28281,28338,28343,28379,28387,28431,28442,28444,28445,28450,28453,28527,28571,28574,28576,28633,28648,28649,28650,28651,28683,28715,28745,28801,28814,28892,28904,28956,28970,29035,29042,29117,29166,29189,29260,29313,29323,29335,29400,29485,29558,29637,29667,29673,29706,29744,29752,29813,29821,29935,29967,29969,29979,30321,30328,30474,30489,30502,30525,30534,30599,30631,30709,30733,30737,30738,30740,30748,30760,30761,30855,30867,30868,30905,30939,30947,30971,31065,31108,31169,31238,31242,31247,31252,31254,31277,31301,31361,31368,31411,31478,31638,31646,31672,31686,31761,31860,31892,31899,31910,31926,31945,31946,31960,32048,32209,32216,32301,32318,32324,32331,32357,32368,32370,32373,32399,32415,32418,32419,32421,32431,32437,32440,32457,32487,32540,32558,32610,32668,32709,32799,32828,32846,32862,32899,32981,33000,33014,33019,33027,33064,33118,33179,33234,33338,33567,33604,33624,33629,33693,33711,33722,33748,33761,33774,33878,33908,33975,34047,34156,34158,34159,34208,34242,34267,34295,34323,34325,34358,34360,34362,34366,34373,34387,34399,34420,34487,34557,34572,34584,34650,34899,35068,35075,35078,35144,35145,35214,35217,35238,35291,35307,35311,35355,35382,35392,35407,35412,35437,35450,35470,35509,35545,35560,35571,35577,35594,35607,35612,35712,35715,35755,35780,35868,35874,35878,35899,35934,36009,36065,36074,36092,36103,36105,36166,36182,36202,36328,36340,36381,36446,36474,36496,36515,36563,36649,36656,36693,36703,36724,36754,36757,36767,36786,36789,36812,36822,36833,36845,36848,36849,36859,36861,36868,36949,36965,36992,37016,37036,37037,37129,37137,37164,37264,37314,37399,37400,37405,37406,37407,37408,37409,37410,37416,37508,37516,37564,37620,37653,37666,37762,37797,37813,37846,37868,38021,38059,38061,38082,38091,38104,38109,38235,38259,38315,38363,38433,38485,38499,38517,38529,38541,38548,38596,38605,38606,38624,38652,38716,38730,38736,38761,38771,38774,38793,38816,38855,38870,38874,38917,38918,39050,39061,39066,39067,39091,39094,39141,39168,39180,39294,39317,39318,39324,39325,39349,39416,39444,39461,39484,39518,39522,39551,39563,39578,39584,39588,39603,39611,39619,39623,39624,39627,39632,39633,39637,39640,39645,39661,39667,39670,39675,39680,39692,39694,39696,39707,39715,39720,39730,39733,39746,39752,39769,39778,39798,39803,39805,39829,39834,39847,39863,39913,39941,39942,39946,39949,39950,39952,39967,39968,39973,39981,39982,39987,39991,39996,40000,40009,40029,40030,40043,40047,40050,40055,40058,40065,40066,40074,40081,40084,40090,40104,40105,40112,40113,40114,40122,40124,40135,40136,40141,40148,40152,40162,40228,40256,40265,40270,40272,40279,40285,40291,40303,40305,40342,40346,40348,40356,40360,40363,40371,40380,40382,40386,40388,40393,40396,40397,40407,40408,40410,40411,40423,40430,40446,40447,40455,40457,40465,40473,40474,40482,40490,40504,40524,40542,40546,40582,40590,40595,40614,40616,40619,40620,40626,40627,40634,40635,40650,40667,40680,40683,40692,40697,40709,40710,40714,40723,40726,40731,40734,40737,40739,40743,40747,40763,40767,40777,40779,40786,40801,40808,40809,40811,40814,40815,40826,40847,40852,40871,40877,40897,40898,40905,40906,40919,40920,40925,40928,40932,40934,40937,40939,40940,40944,40946,40947,40949,40952,40953,40961,40962,40963,40968,40972,40983,41000,41003,41008,41009,41022,41024,41036,41037,41041,41044,41046,41049,41050,41058,41060,41062,41085,41092,41098,41104,41112,41113,41116,41118,41124,41136,41138,41143,41144,41150,41151,41152,41157,41172,41178,41251,41259,41299,41300,41313,41323,41324,41336,41361,41362,41363,41383,41386,41428,41437,41440,41456,41469,41473,41480,41487,41494,41495,41533,41534,41549,41556,41557,41560,41578,41592,41593,41596,41600,41601,41609,41612,41614,41615,41616,41617,41618,41619,41640,41641,41643,41655,41657,41661,41668,41669,41670,41688,41689,41789,41821,41823,41840,41851,41858,41861,41874,41908,41909,41910,41966,41972,41975,42020,42039,42041,42052,42053,42054,42073,42078,42110,42114,42175,42186,42200,42208,42211,42217,42219,42264,42271,42275,42290,42293,42298,42302,42320,42323,42325,42326,42340,42363,42365,42366,42367,42384,42386,42400,42416,42425,42431,42441,42445,42446,42451,42454,42464,42472,42476,42480,42483,42511,42520,42534,42542,42543,42544,42552,42555,42559,42592,42598,42611,42621,42626,42628,42640,42642,42643,42653,42663,42668,42678,42684,42696,42702,42711,42716,42718,42731,42732,42733,42748,42762,42763,42771,42777,42794,42803,42807,42813,42814,42815,42820,42822,42823,42835,42838,42848,42857,42858,42862,42865,42883,42884,42902,42946,42949,42959,42970,42973,42978,42980,42985,42987,42989,43008,43014,43028,43029,43038,43039,43040,43043,43045,43059,43063,43068,43076,43077,43082,43086,43088,43089,43090,43101,43106,43112,43114,43118,43119,43122,43130,43132,43134,43142,43148,43174,43177,43179,43181,43184,43194,43204,43210,43215,43217,43240,43269,43282,43283,43286,43287,43288,43298,43303,43310,43318,43320,43336,43345,43349,43351,43355,43358,43359,43361,43363,43366,43368,43373,43391,43392,43401,43411,43421,43429,43435,43447,43453,43478,43479,43483,43489,43495,43498,43499,43500,43512,43519,43520,43529,43532,43534,43539,43541,43557,43569,43573,43576,43577,43578,43595,43596,43599,43601,43603,43607,43613,43649,43655,43660,43680,43687,43689,43699,43718,43720,43721,43722,43730,43736,43763,43772,43780,43782,43802,43806,43816,43821,43822,43824,43836,43845,43850,43858,43868,43880,43885,43886,43888,43889,43894,43895,43898,43900,43901,43903,43906,43928,43930,43933,43935,43939,43940,43948,43949,43952,43953,43954,43955,43956,43957,43962,43982,43983,43989,43991,43992,43999,44004,44005,44007,44009,44017,44019,44025,44027,44033,44035,44044,44050,44052,44053,44054,44059,44093,44098,44101,44113,44115,44120,44127,44134,44138,44139,44157,44161,44162,44164,44174,44180,44181,44188,44190,44201,44208,44210,44215,44219,44233,44237,44240,44254,44270,44297,44298,44306,44317,44328,44329,44335,44344,44345,44349,44351,44352,44371,44385,44391,44396,44415,44417,44446,44449,44452,44453,44467,44469,44481,44489,44495,44512,44521,44556,44557,44558,44563,44572,44574,44578,44585,44587,44592,44596,44610,44637,44649,44653,44659,44662,44669,44677,44684,44689,44694,44701,44702,44704,44711,44733,44734,44738,44745,44751,44758,44777,44781,44783,44803,44807,44809,44812,44820,44826,44835,44841,44844,44852,44859,44863,44869,44870,44873,44875,44880,44889,44900,44904,44911,44920,44922,44930,44931,44939,44942,44944,44949,44950,44953,44955,44960,44961,44967,44973,44977,44982,45025,45031,45036,45043,45047,45051,45052,45056,45060,45061,45066,45070,45071,45084,45099,45115,45122,45124,45134,45141,45145,45150,45156,45164,45198,45203,45213,45221,45227,45231,45246,45247,45249,45250,45252,45255,45257,45261,45262,45298,45299,45301,45302,45306,45310,45320,45322,45324,45330,45366,45376,45391,45392,45415,45416,45429,45430,45431,45433,45434,45439,45441,45442,45445,45451,45452,45464,45482,45483,45500,45506,45518,45522,45529,45530,45542,45543,45544,45561,45570,45579,45583,45585,45593,45595,45599,45613,45618,45625,45628,45629,45634,45635,45639,45647,45653,45661,45663,45668,45669,45671,45674,45682,45683,45687,45688,45693,45694,45697,45701,45703,45710,45713,45715,45720,45721,45722,45723,45756,45757,45760,45770,45777,45778,45784,45793,45804,45812,45815,45817,45823,45824,45828,45829,45852,45854,45856,45862,45867,45869,45888,45890,45892,45898,45899,45900,45906,45909,45910,45921,45923,45934,45935,45937,45938,45940,45943,45946,45960,45965,45967,45972,45976,45979,45995,45996,45998,46007,46014,46017,46020,46025,46039,46043,46046,46068,46083,46084,46086,46087,46089,46091,46096,46104,46108,46111,46112,46115,46122,46129,46138,46142,46144,46150,46157,46158,46159,46161,46170,46171,46177,46195,46196,46199,46200,46205,46208,46280,46281,46283,46292,46293,46296,46302,46303,46305,46313,46331,46333,46339,46352,46358,46363,46368,46370,46374,46378,46379,46382,46392,46405,46414,46430,46434,46444,46449,46459,46467,46471,46473,46484,46485,46488,46498,46501,46511,46512,46518,46522,46536,46537,46540,46541,46549,46552,46554,46571,46579,46587,46588,46589,46591,46603,46620,46621,46625,46629,46636,46652,46657,46658,46659,46661,46665,46679,46696,46698,46706,46712,46718,46726,46729,46731,46733,46735,46737,46739,46758,46760,46772,46785,46790,46797,46798,46801,46811,46816,46824,46829,46860,46863,46865,46866,46868,46869,46871,46877,46883,46887,46888,46890,46894,46896,46898,46908,46910,46915,46922,46923,46925,46932,46934,46940,46942,46947,46954,46956,46974,46976,46978,46980,47002,47009,47011,47019,47020,47024,47028,47030,47032,47039,47048,47051,47056,47062,47063,47064,47066,47078,47083,47089,47090,47093,47096,47099,47103,47104,47106,47107,47110,47111,47115,47126,47129,47130,47132,47133,47140,47141,47142,47143,47145,47148,47160,47161,47164,47167,47169,47175,47183,47184,47187,47199,47200,47201,47204,47227,47228,47239,47247,47249,47255,47265,47269,47276,47278,47280,47314,47315,47335,47338,47345,47347,47348,47352,47361,47364,47365,47380,47384,47388,47390,47393,47394,47404,47418,47423,47429,47432,47439,47441,47445,47448,47458,47460,47464,47466,47472,47476,47480,47508,47511,47513,47514,47516,47519,47525,47526,47528,47533,47534,47539,47540,47543,47546,47557,47558,47562,47566,47567,47570,47574,47576,47577,47578,47592,47599,47600,47608,47617,47626,47632,47633,47643,47663,47664,47674,47679,47680,47681,47687,47688,47701,47702,47726,47728,47731,47733,47737,47740,47745,47756,47760,47762,47765,47781,47783,47784,47789,47801,47809,47811,47813,47816,47820,47826,47830,47831,47832,47837,47839,47846,47849,47858,47881,47887,47888,47895,47901,47907,47912,47946,47954,47957,47962,47963,47965,47966,47968,47971,47972,47974,47983,47988,47989,47992,47994,47997,48000,48011,48021,48022,48034,48039,48048,48051,48054,48057,48060,48064,48066,48067,48080,48087,48094,48097,48103,48130,48141,48142,48146,48148,48155,48157,48159,48160,48175,48176,48177,48187,48189,48198,48200,48203,48205,48212,48216,48234,48240,48263,48264,48265,48274,48278,48279,48288,48291,48296,48303,48306,48318,48319,48323,48327,48349,48352,48354,48355,48357,48376,48386,48389,48394,48396,48401,48404,48407,48409,48411,48417,48420,48432,48435,48436,48438,48441,48442,48443,48445,48451,48455,48461,48468,48469,48475,48480,48483,48492,48495,48501,48502,48505,48507,48508,48512,48514,48517,48522,48537,48539,48540,48546,48550,48560,48564,48565,48569,48572,48574,48575,48585,48589,48590,48592,48596,48599,48602,48604,48608,48609,48611,48620,48622,48624,48637,48638,48644,48648,48649,48651,48653,48656,48657,48660,48661,48664,48665,48668,48673,48674,48686,48688,48693,48696,48698,48699,48700,48703,48704,48710,48712,48714,48716,48717,48719,48727,48730,48732,48733,48743,48744,48747,48764,48766,48774,48776,48777,48785,48786,48791,48795,48798,48800,48804,48806,48807,48815,48821,48822,48823,48824,48825,48831,48835,48836,48840,48851,48855,48858,48859,48866,48871,48872,48884,48885,48890,48891,48892,48893,48897,48911,48912,48915,48917,48920,48923,48926,48927,48928,48934,48935,48937,48939,48943,48946,48948,48949,48950,48954,48959,48961,48964,48967,48972,48974,48975,48984,48988,48993,48997,49006,49010,49012,49033,49053,49054,49055,49089,49090,49091,49094,49097,49099,49116,49137,49139,49147,49148,49149,49152,49169,49193,49209,49221,49241,49242,49246,49250,49252,49254,49259,49260,49266,49273,49275,49278,49287,49290,49302,49303,49313,49314,49316,49324,49330,49337,49338,49339,49344,49346,49348,49351,49364,49384,49399,49401,49413,49414,49417,49427,49430,49434,49443,49446,49447,49448,49452,49453,49454,49462,49464,49468,49482,49484,49495,49502,49504,49505,49531,49533,49535,49541,49543,49544,49548,49555,49560,49592,49594,49597,49598,49606,49608,49613,49615,49616,49617,49622,49624,49633,49634,49638,49640,49642,49648,49652,49654,49658,49659,49663,49665,49677,49686,49692,49695,49697,49700,49704,49710,49716,49717,49718,49720,49722,49729,49732,49736,49747,49779,49784,49788,49791,49793,49794,49795,49796,49813,49817,49818,49825,49832,49839,49841,49843,49846,49854,49860,49861,49863,49867,49868,49869,49873,49876,49878,49880,49883,49893,49905,49913,49915,49917,49918,49949,49962,49963,49964,49966,49972,49974,49977,49978,49991,49993,49994,49996,50026,50029,50030,50031,50033,50047,50049,50051,50067,50071,50073,50074,50077,50078,50080,50081,50089,50094,50100,50101,50105,50124,50125,50130,50132,50134,50136,50142,50151,50152,50154,50165,50173,50201,50204,50206,50207,50213,50214,50218,50221,50233,50238,50241,50257,50280,50283,50297,50300,50305,50306,50315,50318,50323,50324,50325,50330,50332,50343,50344,50345,50347,50351,50352,50355,50359,50360,50367,50381,50390,50393,50394,50398,50400,50419,50447,50449,50457,50464,50467,50473,50482,50485,50491,50495,50501,50502,50512,50523,50524,50526,50529,50531,50547,50550,50559,50560,50564,50574,50575,50577,50579,50584,50589,50590,50594,50596,50600,50618,50645,50646,50650,50653,50656,50658,50666,50667,50669,50671,50672,50683,50686,50688,50697,50698,50699,50704,50712,50719,50735,50738,50739,50740,50741,50742,50745,50751,50752,50755,50758,50767,50774,50777,50778,50779,50780,50789,50792,50793,50794,50796,50808,50810,50813,50818,50819,50823,50824,50830,50833,50834,50835,50837,50845,50850,50851,50858,50861,50862,50863,50866,50867,50868,50879,50880,50886,50887,50892,50899,50904,50906,50918,50922,50931,50947,50948,50950,50960,50969,50973,50975,50976,50979,50984,50996,51009,51023,51026,51035,51038,51040,51048,51050,51052,51061,51071,51072,51079,51090,51092,51096,51104,51128,51132,51133,51139,51141,51143,51153,51157,51166,51167,51171,51172,51175,51181,51187,51188,51200,51201,51202,51203,51207,51213,51215,51217,51218,51225,51227,51234,51236,51240,51241,51248,51249,51252,51268,51275,51280,51288,51290,51296,51298,51310,51314,51323,51324,51334,51337,51347,51349,51358,51360,51376,51378,51383,51384,51395,51402,51405,51406,51412,51416,51419,51431,51435,51443,51458,51467,51473,51477,51481,51485,51489,51490,51492,51495,51505,51508,51510,51515,51520,51530,51531,51539,51541,51548,51560,51569,51572,51577,51578,51579,51582,51583,51588,51595,51599,51604,51613,51635,51640,51643,51648,51651,51654,51660,51676,51677,51684,51699,51720,51721,51724,51741,51747,51754,51757,51762,51768,51780,51795,51804,51807,51811,51812,51813,51817,51840,51857,51858,51886,51897,51935,52056,52100,52135,52222,52283,52287,52292,52302,52305,52327,52456,52457,52459,52499,52553,52573,52608,52615,52663,52745,52748,52763,52823,52853,52900,53038,53358,53411,53414,53484,53498,53529,53577,53647,53704,53714,53779,53784,53811,53863,53866,53896,53976,54180,54225,54243,54254,54320,54326,54357,54371,54375,54380,54418,54447,54462,54556,54558,54571,54603,54605,54630,54642,54666,54668,54681,54707,54711,54730,54732,54733,54738,54745,54749,54764,54785,54796,54800,54827,54876,54882,54888,54973,54986,55022,55028,55061,55081,55120,55151,55163,55172,55185,55229,55357,55362,55364,55414,55429,55468,55473,55484,55493,55515,55522,55544,55563,55569,55577,55584,55613,55638,55672,55755,55852,55867,55880,55884,55934,56020,56057,56064,56099,56106,56111,56112,56147,56151,56176,56179,56198,56216,56235,56254,56317,56319,56335,56339,56352,56365,56372,56393,56403,56473,56528,56549,56561,56654,56681,56689,56764,56788,56816,56828,56879,56880,56914,56915,56924,56929,56938,56940,56949,56954,56994,56997,57001,57013,57016,57064,57065,57068,57114,57125,57150,57260,57261,57372,57399,57406,57479,57501,57529,57538,57543,57668,57670,57680,57688,57793,57794,57800,57848,57876,57935,58029,58054,58086,58111,58232,58252,58254,58255,58258,58295,58367,58437,58459,58494,58509,58540,58597,58602,58609,58642,58648,58960,58964,58997,59011,59062,59074,59077,59093,59127,59149,59150,59171,59222,59244,59279,59299,59365,59380,59419,59454,59483,59498,59541,59550,59554,59606,59647,59663,59693,59701,59784,59910,59927,59951,59959,59978,59993,60014,60044,60046,60054,60287,60325,60363,60378,60383,60395,60405,60414,60444,60453,60454,60458,60462,60473,60493,60510,60530,60615,60637,60639,60641,60698,60702,60732,60758,60893,61031,61106,61133,61167,61183,61214,61267,61290,61304,61356,61407,61428,61447,61494,61516,61541,61558,61599,61605,61639,61643,61779,61786,61791,61792,61828,61847,61849,61934,61959,61990,61991,61992,62061,62071,62105,62123,62126,62129,62133,62135,62208,62249,62278,62338,62342,62501,62562,62580,62583,62638,62676,62682,62709,62761,62783,62843,62859,62942,62951,63021,63041,63042,63053,63060,63065,63086,63114,63124,63131,63207,63229,63246,63289,63299,63311,63342,63353,63401,63407,63436,63452,63470,63588,63616,63629,63635,63639,63668,63671,63727,63744,63761,63783,63815,63831,63839,63846,63857,63869,63872,63877,63879,63897,63933,63938,63957,63960,63963,63966,63970,63985,63996,63999,64001,64010,64024,64033,64053,64086,64141,64194,64204,64206,64235,64328,64339,64374,64378,64379,64397,64417,64421,64428,64429,64460,64477,64544,64580,64584,64595,64614,64661,64708,64727,64758,64775,64809,64820,64866,64884,64900,64936,64965,64980,64991,65157,65159,65162,65218,65251,65267,65296,65337,65432,65485,65547,65647,65657,65658,65661,65687,65714,65791,65824,65865,65920,65936,65954,65999,66014,66048,66070,66092,66161,66171,66179,66199,66205,66221,66224,66225,66228,66242,66248,66310,66324,66351,66391,66408,66440,66442,66455,66464,66466,66468,66478,66482,66493,66497,66518,66536,66572,66612,66711,66713,66770,66779,66853,66873,66890,66893,66949,66959,66969,66973,66981,66987,67027,67062,67068,67080,67108,67120,67124,67144,67149,67156,67159,67171,67178,67216,67217,67232,67236,67240,67248,67279,67308,67309,67329,67357,67380,67409,67434,67460,67488,67498,67503,67527,67549,67632,67666,67692,67698,67773,67818,67822,67826,67865,67870,67878,67880,67909,67942,67951,67959,67964,67979,67986,68004,68010,68013,68037,68051,68055,68071,68107,68119,68152,68172,68184,68190,68225,68235,68285,68295,68417,68426,68429,68450,68490,68496,68540,68548,68555,68561,68579,68638,68640,68644,68667,68685,68701,68708,68742,68779,68937,68944,69002,69066,69122,69140,69141,69145,69165,69204,69237,69260,69268,69299,69349,69374,69384,69386,69389,69394,69412,69421,69465,69472,69483,69543,69547,69570,69581,69582,69586,69587,69596,69622,69623,69712,69769,69811,69844,69846,69862,69869,69907,69909,69913,69923,69957,69990,69996,69997,70001,70016,70027,70063,70064,70075,70077,70095,70105,70120,70121,70130,70133,70141,70168,70169,70207,70276,70277,70346,70393,70443,70447,70462,70505,70548,70595,70609,70613,70625,70626,70628,70710,70737,70746,70854,70885,70886,70917,71005,71006,71028,71032,71034,71035,71039,71048,71074,71116,71119,71134,71174,71241,71327,71331,71337,71384,71398,71399,71407,71422,71430,71447,71460,71500) 
  ORDER BY i.id DESC 
  LIMIT 5

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived3>	ALL	distinct_key	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	3673	Використовуючи filesort
1	PRIMARY	i	eq_ref	PRIMARY,catid,language,idx_items_common,idx_items_common_backend	PRIMARY	4	tvc_0._col_1	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,category,published,access,trash,language,idx_category	PRIMARY	4	finclub_j201803.i.catid	1	Using where
3	DERIVED	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	No tables used

Профіль

Status	Duration
Starting	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
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.00 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:648
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 3.36 ms Після останнього запиту: 1.72 ms

Дублі запитів: #31 #33 #35 #37

SELECT extraFieldsGroup 
  FROM js937_k2_categories 
  WHERE id=278

Роз'яснення

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

Профіль

Status	Duration
Starting	0.07 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
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.24 ms
Creating sort index	0.03 ms
Removing tmp table	0.11 ms
Creating sort index	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.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1258
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.23 ms Після останнього запиту: 0.05 ms

Дублі запитів: #32 #34 #36 #38

SELECT * 
  FROM js937_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1) OR `type` = 'header') 
  ORDER BY ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_extra_fields	ref	PRIMARY,group,published	group	4	const	1	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.08 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
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.25 ms
Creating sort index	0.02 ms
Removing tmp table	0.07 ms
Creating sort index	0.00 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.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1262
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 5.55 ms Після останнього запиту: 1.07 ms

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 js937_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.relatedByTag-media' 
  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) 
  AND a.language in ('*','uk-UA')

  ORDER BY a.ordering ASC

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:599
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:659
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.77 ms Після останнього запиту: 0.58 ms

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 js937_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (278,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) 
  AND a.language in ('*','uk-UA')

  ORDER BY a.ordering ASC

Роз'яснення

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

Профіль

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	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.00 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:670
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:659
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.74 ms Після останнього запиту: 5.29 ms

Дублі запитів: #27 #33 #35 #37

SELECT extraFieldsGroup 
  FROM js937_k2_categories 
  WHERE id=278

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1258
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.28 ms Після останнього запиту: 0.05 ms

Дублі запитів: #28 #34 #36 #38

SELECT * 
  FROM js937_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1) OR `type` = 'header') 
  ORDER BY ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_extra_fields	ref	PRIMARY,group,published	group	4	const	1	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 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.00 ms
Updating status	1.81 ms
Reset for next command	0.01 ms

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1262
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.12 ms Після останнього запиту: 5.01 ms

Дублі запитів: #27 #31 #35 #37

SELECT extraFieldsGroup 
  FROM js937_k2_categories 
  WHERE id=278

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1258
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.28 ms Після останнього запиту: 0.05 ms

Дублі запитів: #28 #32 #36 #38

SELECT * 
  FROM js937_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1) OR `type` = 'header') 
  ORDER BY ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_extra_fields	ref	PRIMARY,group,published	group	4	const	1	Using where; Використовуючи filesort

Профіль

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	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.00 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1262
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.20 ms Після останнього запиту: 4.90 ms

Дублі запитів: #27 #31 #33 #37

SELECT extraFieldsGroup 
  FROM js937_k2_categories 
  WHERE id=278

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1258
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.25 ms Після останнього запиту: 0.04 ms

Дублі запитів: #28 #32 #34 #38

SELECT * 
  FROM js937_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1) OR `type` = 'header') 
  ORDER BY ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_extra_fields	ref	PRIMARY,group,published	group	4	const	1	Using where; Використовуючи filesort

Профіль

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

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1262
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.00 ms Після останнього запиту: 8.91 ms

Дублі запитів: #27 #31 #33 #35

SELECT extraFieldsGroup 
  FROM js937_k2_categories 
  WHERE id=278

Роз'яснення

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

Профіль

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.14 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.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.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1258
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.27 ms Після останнього запиту: 0.05 ms

Дублі запитів: #28 #32 #34 #36

SELECT * 
  FROM js937_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1) OR `type` = 'header') 
  ORDER BY ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_extra_fields	ref	PRIMARY,group,published	group	4	const	1	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Sorting result	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.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1262
15	K2ModelItem->getItemExtraFields()	JROOT/components/com_k2/models/item.php:156
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:658
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:281
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 4.68 ms Після останнього запиту: 1.53 ms

SELECT *
            
  FROM js937_k2_items
            
  WHERE id < 45105
                
  AND catid = 278
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-21 06:04:13')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-21 06:04:13')
                
  AND access IN (1,1,5)
                
  AND language IN ('uk-UA', '*')
            
  ORDER BY id DESC 
  LIMIT 1

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_items	range	PRIMARY,catid,language,idx_items_common,idx_items_common_backend	catid	8	NULL	2925	Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1625
13	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:293
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 4.58 ms Після останнього запиту: 1.41 ms

SELECT tag.*
            
  FROM js937_k2_tags AS tag
            JOIN js937_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 45104
            
  ORDER BY xref.id ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	itemID	4	const	2	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	finclub_j201803.xref.tagID	1	Using where

Профіль

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.02 ms
Removing tmp table	0.06 ms
Creating sort index	0.00 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.03 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.18 ms Після останнього запиту: 0.32 ms

SELECT * 
  FROM js937_k2_attachments 
  WHERE itemID=45104

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_attachments	ref	itemID	itemID	4	const	1

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1450
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:295
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.68 ms Після останнього запиту: 0.83 ms

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 js937_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_k2.item-media' 
  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) 
  AND a.language in ('*','uk-UA')

  ORDER BY a.ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_language,idx_context	idx_state	1	const	1	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	finclub_j201803.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a.group_id	1	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	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.07 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:599
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:296
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.84 ms Після останнього запиту: 0.62 ms

SELECT *
            
  FROM js937_k2_items
            
  WHERE id > 45105
                
  AND catid = 278
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-21 06:04:13')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-21 06:04:13')
                
  AND access IN (1,1,5)
                
  AND language IN ('uk-UA', '*')
            
  ORDER BY id ASC 
  LIMIT 1

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_items	range	PRIMARY,catid,language,idx_items_common,idx_items_common_backend	PRIMARY	4	NULL	38266	Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1684
13	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:334
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 4.22 ms Після останнього запиту: 1.31 ms

SELECT tag.*
            
  FROM js937_k2_tags AS tag
            JOIN js937_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 45106
            
  ORDER BY xref.id ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID,idx_tags_xref_common	itemID	4	const	6	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	finclub_j201803.xref.tagID	1	Using where

Профіль

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.09 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1222
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:336
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 0.16 ms Після останнього запиту: 0.44 ms

SELECT * 
  FROM js937_k2_attachments 
  WHERE itemID=45106

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_k2_attachments	ref	itemID	itemID	4	const	1

Профіль

Status	Duration
Starting	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
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1450
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:164
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:336
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:58
6	require_once JROOT/components/com_k2/k2.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.20 ms Після останнього запиту: 25.52 ms

SELECT language,id

  FROM `js937_menu`

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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	js937_menu	ALL	idx_client_id_parent_id_alias_language	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	200	Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 2.61 ms Після останнього запиту: 26.35 ms

SELECT params

  FROM js937_extensions

  WHERE `type` = 'plugin' 
  AND `element` = 'jlsitemap_cron' 
  AND `folder` = 'system'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.04 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.32 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.01 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.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:197
8	PlgSystemJLSitemap_Cron->checkCacheTime()	JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:52
7	PlgSystemJLSitemap_Cron->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

Витрачений час на запит: 6.19 ms Після останнього запиту: 22.34 ms

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

  FROM `js937_menu` AS `c`

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

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

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

  WHERE c.id = 154

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	finclub_j201803.a2.id	1

Профіль

Не ПОКАЗУВАТИ профіль (може бути оскільки є більш ніж 100 запити)

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:191

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

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

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

5 &#215; SELECT extraFieldsGroup 
  FROM js937_k2_categories

5 &#215; SELECT * 
  FROM js937_k2_extra_fields

3 &#215; SELECT id, alias 
  FROM js937_k2_items

3 &#215; SELECT tag.*             
  FROM js937_k2_tags AS tag             JOIN js937_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

3 &#215; SELECT * 
  FROM js937_k2_attachments

3 &#215; 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 js937_fields AS a 
  LEFT JOIN `js937_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN js937_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN js937_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN js937_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN js937_fields_groups AS g 
  ON g.id = a.group_id

2 &#215; 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 js937_fields AS a 
  LEFT JOIN `js937_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN js937_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN js937_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN js937_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN js937_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `js937_fields_categories` AS fc 
  ON fc.field_id = a.id

2 &#215; SELECT *             
  FROM js937_k2_items

1 &#215; SELECT `session_id` 
  FROM `js937_session`

1 &#215; SELECT id, rules 
  FROM `js937_viewlevels

1 &#215; SELECT b.id 
  FROM js937_usergroups AS a 
  LEFT JOIN js937_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 &#215; SELECT id, alias, parent 
  FROM js937_k2_categories

1 &#215; SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `js937_assets`

1 &#215; SELECT id 
  FROM js937_k2_categories

1 &#215; SELECT * 
  FROM js937_k2_items

1 &#215; SELECT * 
  FROM js937_k2_categories

1 &#215; SELECT * 
  FROM `js937_users`

1 &#215; SELECT `g`.`id`,`g`.`title` 
  FROM `js937_usergroups` AS g 
  INNER JOIN `js937_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 &#215; SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM js937_k2_users

1 &#215; SELECT * 
  FROM js937_k2_comments

1 &#215; SELECT itemID             
  FROM js937_k2_tags_xref

1 &#215; SELECT i.*, c.alias AS categoryalias             
  FROM js937_k2_items AS i             
  LEFT JOIN js937_k2_categories AS c 
  ON c.id = i.catid

1 &#215; SELECT language,id 
  FROM `js937_menu`

1 &#215; SELECT params 
  FROM js937_extensions

1 &#215; SELECT `c2`.`language`,`c2`.`id` 
  FROM `js937_menu` AS `c` 
  INNER JOIN `js937_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `js937_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `js937_menu` AS `c2` 
  ON a2.id = c2.`id`

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

1 &#215; SHOW VARIABLES LIKE 'query_cache_type

1 &#215; SHOW VARIABLES LIKE 'have_profiling

1 &#215; UPDATE `js937_extensions` 
  SET `params` = '{\"mediaversion\":\"2345f0986819f33684ad3b213c3414f9\"}'

1 &#215; SHOW FULL COLUMNS 
  FROM `js937_k2_categories

1 &#215; SHOW FULL COLUMNS 
  FROM `js937_users

Україна вже не отримає два транші МВФ до кінця року — Сологуб

Схожі матеріали (за тегом)

Держбюджет отримав 2,3 трлн грн до загального фонду за вісім місяців

Нацбанк оштрафував Укргазбанк і чотири небанки на 50,1 млн грн

Нацбанк через технічний збій помилково занизив курс долара та євро

Нацбанк пояснив, як українці отримають нову банкноту 2000 грн

Нацбанк ввів в обіг найбільшу в історії гривні банкноту 2000 грн

Користувачі OTP Bank UA можуть виграти 10 000 грн на пальне

Більше можливостей для міжнародних платежів: ПУМБ розширив можливості SWIFT переказів у застосунку

Кредити готівкою, карткові кредити, позики для ФОПів: як Ідея Банк нарощує обсяги кредитування в 2026 році

Акордбанк допомагає укомплектувати підрозділ ЗСУ

«Південний» вкотре підтримав ветеранську спільноту: спорт як шлях до відновлення

ТАСКОМБАНК почав кредитувати девелоперів під майбутні об’єкти нерухомості

Долучайтесь

Онлайн-платежі без ілюзій

Кредитування енергообладнання в Україні: як стати енергонезалежним

Кредити для агробізнесу: посівна-2026 та нові інструменти

Х Церемонія нагородження «Банки року – 2026» (онлайн-трансляція)

Преміальний банкінг у 2026 році: цифрова еволюція та персоналізований підхід

Банківський сектор України: здобутки 2025 року та очікування від 2026-го (онлайн-трансляція)

FINANCIAL CLUB AWARDS – 2025 (онлайн-трансляція)

Що відбулось з Україною за два роки війни. Фінансовий вимір

Як війна змінила бюджет України

Рік повномасштабного вторгнення у фінансових графіках

Бюджет війни. На що витратять 2,5 трильйона гривень

Інфляція стала головною економічною проблемою світу

Консоль налагодження Joomla

Сесія

Інформація облікового запису

Час

Пам'ять

Використання пам'яті

Запити до бази даних

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

13 дублікат(-ів) знайдено!

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

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

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