Каталоги, руководства и инструкции к технике GREAT PLAINS

Каталог запасных частей для механической сеялки Great Plains 1006NT

Сеялка 1006NT является зерновой сеялкой с транспортно-приводными колесами, которые соединяют пружинный режущий диск Great Plains и сошник с прямым рычагом крепления, что обеспечивает возможность высева в условиях нулевой обработки почвы. Колеса, расположенные по бокам сеялки, находятся на одной линии с рабочими деталями сеялки, что позволяет сохранять глубину работы режущих дисков, точно вносить семена на неровной поверхности и повторять все изгибы поля, снимая боковую нагрузку с сошников.

Каталог запасных частей для механической сеялки Great Plains 1205NT

Сеялка 1205NT с шириной захвата 3,6 м является зерновой сеялкой с задним расположением колес, на которой установлен подпружиненный колтерный диск и сошник с жестким креплением, что позволяет работать в условиях нулевой почвообработки. Заднее расположение колес обеспечивает равномерную глубину обработки колтерными дисками и равномерную глубину высева даже в условиях неровной почвы - таким образом сошник преодолевает неровности почвы без боковой нагрузки.

Каталог запасных частей для механической сеялки Great Plains 2S-2600HD

2S-2600HD является прицепной механической сеялкой. Данная 2-секционная сеялка имеют ширину захвата в 8м. Она имеет прямое дышло и сошники повышенной надежности с двойными дисками.

Каталог запасных частей для механической сеялки Great Plains 2SF24 & 2SF30

2SF24 и 2SF30 Механическая двухсекционная складывающаяся рядовая сеялка предназначена для многолетней надёжной эксплуатации.

Каталог запасных частей для механической сеялки Great Plains 3S-3000HD

3S-3000HD является прицепной механической сеялкой. Данная 3-секционная сеялка имеют ширину захвата в 10м. Она имеет прямое дышло и сошники повышенной надежности с двойными дисками.

Каталог запасных частей для механической сеялки Great Plains 3S-4000

3S-4000 является прицепной сеялкой. Данная 3-секционная сеялка имеют ширину захвата в 12,2м. Она имеет прямое дышло и сошники повышенной надежности с двойными дисками.

Каталог запасных частей для механической сеялки Great Plains 3S-4000HD

3S-4000HD является прицепной механической сеялкой. Данная 3-секционная сеялка имеют ширину захвата в 12,2м. Она имеет прямое дышло и сошники повышенной надежности с двойными дисками.

Каталог запасных частей для механической сеялки Great Plains 3S-4010HDF

3S-4010HD/HDF – это прицепная 3-секционная складывающаяся сеялка с катушечным высевающим аппаратом, рабочая ширина 40 футов (12.2 м), усиленные сошники серии 10HD с двойными дисками и параллельными рычагами.

Каталог запасных частей для механической сеялки Great Plains 605NT

3P605NT и 3P606NT являются 1,8 метровыми сеялками с 3-точечной навеской. 605NT и 606NT являются 1,8 метровыми прицепными сеялками. Все модели предназначены для работы в условиях нулевой почвообработки. Дисковые ножи разрезают пожнивные остатки, диски сошников открывают борозду. Семенные трубки между дисками сошников вносят семена в борозду, прикатывающие колеса закрывают ее и уплотняют почву над семенами. Кроме того, прикатывающие колеса регулируют глубину сошника.

Каталог запасных частей для механической сеялки Great Plains CPH-2000

CPH-2000 Механические сеялки с трехточечной навеской являются навесными посевными машинами, которые крепятся к трактору с помощью сцепного устройства с трехточечной навеской. Эти сеялки могут быть преобразованы в машины прицепного типа посредством сцепного устройства с центральным шарниром, стандартного сцепного устройства или прицепного блока от компании Great Plains.

Каталог запасных частей для механической сеялки Great Plains PFH-2000

PFH-2000 Механические сеялки с трехточечной навеской являются навесными посевными машинами, которые крепятся к трактору с помощью сцепного устройства с трехточечной навеской. Эти сеялки могут быть преобразованы в машины прицепного типа посредством сцепного устройства с центральным шарниром, стандартного сцепного устройства или прицепного блока от компании Great Plains.

Каталог запасных частей для пневматической сеялки Great Plains NTA-3510 и NTA-3010

NTA3010 и NTA3510 прицепные пневматические сеялки производства компании Great Plains. Рабочая ширина - 9 или 10 метров (30 или 35 футов). Эти орудия предназначены для почвы с нулевой обработкой.

Каталог запасных частей для сцепки Great Plains CPH-12-15-20

CPH-12-15-20 Сцепка со шкворнем является прицепным почвообрабатывающим оборудованием, разработанным для буксировки трехрядной сеялки производства Great Plains. На сцепке установлены ножи для нулевой обработки почвы.

Каталог запасных частей тележки Great Plains ADC-2350 и ADC-2350B

ADC2350 и ADC2350B являются прицепными приспособлениями для сплошного высева. Гидравлический вентилятор создает воздушный поток для подачи высевного материала и сухих удобрений в совместимую прицепную(спереди или сзади от тележки) сеялку GreatPlains.

Справочник по нормам высева и внесения удобрений для механической сеялки Great Plains 3S-4000

<< < 1 [2] 3 > >>

Консоль отладки Joomla

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1642391358,
                "last": 1642391358,
                "now": 1642391358
            },
            "token": "27bL5IPd6p9KiIJYfSZJL7T6UL4P2FgB"
        },
        "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
        }
    }
}

Профилирование

Использование памяти

Запросы к базе данных

49 запросов зарегистрировано 28.86 ms

Время запроса: 0.78 ms

SHOW VARIABLES LIKE 'query_cache_type'

План запросов (Explain)

EXPLAIN недоступен для: SHOW VARIABLES LIKE 'query_cache_type'

Профиль

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.59 ms После последнего запроса: 0.07 ms

SHOW VARIABLES LIKE 'have_profiling'

План запросов (Explain)

EXPLAIN недоступен для: SHOW VARIABLES LIKE 'have_profiling'

Профиль

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 3.48 ms

SELECT `data`

  FROM `wc6hn_session`

  WHERE `session_id` = X'6561716f37346532306d6b6f326e396f6535333872326b753437'

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Такой же, как вызов в строке ниже
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.14 ms После последнего запроса: 0.83 ms

SELECT `session_id`

  FROM `wc6hn_session`

  WHERE `session_id` = X'6561716f37346532306d6b6f326e396f6535333872326b753437' 
  LIMIT 1

План запросов (Explain)

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

Профиль

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.02 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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:856
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 8.42 ms После последнего запроса: 0.13 ms

INSERT INTO `wc6hn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6561716f37346532306d6b6f326e396f6535333872326b753437', 1, 1642391358, 0, '', 0)

План запросов (Explain)

EXPLAIN недоступен для: INSERT INTO `wc6hn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6561716f37346532306d6b6f326e396f6535333872326b753437', 1, 1642391358, 0, '', 0)

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
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:856
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.25 ms После последнего запроса: 3.36 ms

SELECT id, rules

  FROM `wc6hn_viewlevels`

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wc6hn_viewlevels	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	3	100.00	NULL

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.07 ms
updating	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	7.03 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.12 ms

SELECT b.id

  FROM wc6hn_usergroups AS a

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

  WHERE a.id = 1

План запросов (Explain)

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

Профиль

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 7.37 ms После последнего запроса: 29.91 ms

UPDATE `wc6hn_extensions`

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

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

План запросов (Explain)

EXPLAIN недоступен для: UPDATE `wc6hn_extensions` SET `params` = '{\"mediaversion\":\"a86dd27b17b4c765c8e2851540b31b88\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 8.27 ms

SELECT * 
  FROM wc6hn_zoo_application 
  WHERE id = 3

План запросов (Explain)

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

Профиль

Status	Duration
starting	0.02 ms
Opening tables	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
9	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.34 ms После последнего запроса: 5.04 ms

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

  FROM `wc6hn_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper','com_zoo')

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wc6hn_assets	NULL	ALL	idx_asset_name	INDEX KEY не используется	NULL	NULL	76	53.95	Using where

Профиль

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.54 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
12	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
11	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:217
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.08 ms После последнего запроса: 0.78 ms


  SET SESSION group_concat_max_len = 1048576

План запросов (Explain)

EXPLAIN недоступен для: SET SESSION group_concat_max_len = 1048576

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	0.40 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/category.php:191
13	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.86 ms После последнего запроса: 0.29 ms

SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM wc6hn_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN wc6hn_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN wc6hn_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-17 03:49:18') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-17 03:49:18') 
  WHERE c.application_id = 3 
  AND c.published = 1 
  GROUP BY c.id

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	APPLICATIONID_ID_INDEX	APPLICATIONID_ID_INDEX	5	const,const	32	100.00	NULL
1	SIMPLE	ci	NULL	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	udb.c.id	7	100.00	Using index
1	SIMPLE	i	NULL	ref	MULTI_INDEX2	MULTI_INDEX2	9	udb.ci.item_id,const,const	1	100.00	Using where; Using index

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
17	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
16	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
15	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
14	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:217
13	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:217
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.69 ms После последнего запроса: 1.66 ms

SELECT a.* 
  FROM wc6hn_zoo_item AS a 
  LEFT JOIN wc6hn_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 3 
  AND a.access IN (1) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-17 03:49:18') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-17 03:49:18') 
  AND b.category_id  = 16 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.name 
  LIMIT 15,15

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	PRIMARY	4	const	33	100.00	Using where; Using index; Using temporary; Используется сортировка файлов
1	SIMPLE	a	NULL	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	udb.b.item_id	1	7.10	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
12	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:467
11	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:238
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.39 ms После последнего запроса: 10.61 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=195 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=195 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.46 ms После последнего запроса: 5.64 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 wc6hn_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_zoo.element.textarea' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	udb.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	udb.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	udb.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	udb.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	udb.a.group_id	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
39	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
37	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
36	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
35	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
34	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
33	PlgSystemFields->onContentPrepare()	Такой же, как вызов в строке ниже
32	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
31	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
30	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
29	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
28	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
27	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
26	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
25	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
24	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
23	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:22
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.14 ms После последнего запроса: 0.98 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 195 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.25 ms После последнего запроса: 0.44 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=197 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=197 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.26 ms После последнего запроса: 1.50 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 197 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.25 ms После последнего запроса: 0.44 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=177 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=177 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 1.27 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 177 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.24 ms После последнего запроса: 0.43 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=179 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=179 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.20 ms После последнего запроса: 1.23 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 179 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.23 ms После последнего запроса: 0.49 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=175 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=175 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.14 ms После последнего запроса: 1.41 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 175 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.39 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=169 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=169 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.14 ms После последнего запроса: 1.56 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 169 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.41 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=172 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=172 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.24 ms После последнего запроса: 1.27 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 172 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.49 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=166 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=166 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.12 ms После последнего запроса: 1.50 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 166 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.26 ms После последнего запроса: 0.39 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=199 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=199 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.26 ms После последнего запроса: 1.25 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 199 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.43 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=181 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=181 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.13 ms После последнего запроса: 1.54 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 181 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.42 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=193 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=193 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.24 ms После последнего запроса: 1.26 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 193 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.24 ms После последнего запроса: 0.47 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=201 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=201 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.12 ms После последнего запроса: 1.59 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 201 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.40 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=184 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=184 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.25 ms После последнего запроса: 1.26 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 184 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.43 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=204 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=204 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.12 ms После последнего запроса: 1.48 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 204 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.22 ms После последнего запроса: 0.39 ms

SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=170 
  AND b.published = 1 UNION SELECT 0 
  FROM wc6hn_zoo_category_item AS a 
  WHERE a.item_id=170 
  AND a.category_id = 0

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1	100.00	NULL
1	PRIMARY	b	NULL	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	udb.a.category_id	1	98.15	Using where
2	UNION	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table
NULL	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
29	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
28	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
27	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
26	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
25	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
24	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
23	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:16
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.14 ms После последнего запроса: 1.64 ms

SELECT id 
  FROM wc6hn_zoo_comment 
  WHERE item_id = 170 
  AND state = 1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	no matching row in const table

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverPdo->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
25	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:211
24	AppTable->count()	JROOT/administrator/components/com_zoo/classes/item.php:709
23	Item->getCommentsCount()	JROOT/media/zoo/elements/itemcommentslink/itemcommentslink.php:26
22	ElementItemCommentsLink->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:95
21	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php:26
20	include JROOT/media/zoo/applications/documentation/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/documentation/templates/default/_item.php:17
17	include JROOT/media/zoo/applications/documentation/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
16	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/_items.php:27
15	include JROOT/media/zoo/applications/documentation/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
14	AppView->partial()	JROOT/media/zoo/applications/documentation/templates/default/category.php:68
13	include JROOT/media/zoo/applications/documentation/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:328
10	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.19 ms После последнего запроса: 1.36 ms

SELECT params 
  FROM wc6hn_extensions AS e 
  WHERE e.element='com_widgetkit'

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
14	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
13	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
12	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
11	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
10	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
8	plgSystemWidgetkit_System->onAfterDispatch()	Такой же, как вызов в строке ниже
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.18 ms После последнего запроса: 0.59 ms

SELECT id,template 
  FROM wc6hn_template_styles 
  WHERE client_id=0 
  AND home=1

План запросов (Explain)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wc6hn_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	11.11	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
10	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
8	plgSystemWidgetkit_System->onAfterDispatch()	Такой же, как вызов в строке ниже
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.25 ms После последнего запроса: 51.12 ms

SELECT * 
  FROM wc6hn_widgetkit_widget 
  WHERE id=79

План запросов (Explain)

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:42
18	WidgetWidgetkitHelper->get()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:160
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_infinite/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_infinite/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_infinite/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_infinite/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_infinite/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_infinite/layouts/template.php:112
9	include JROOT/templates/yoo_infinite/layouts/template.php	JROOT/templates/yoo_infinite/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_infinite/index.php:19
7	require JROOT/templates/yoo_infinite/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 1.13 ms После последнего запроса: 9.74 ms

SHOW FULL COLUMNS 
  FROM `wc6hn_content`

План запросов (Explain)

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `wc6hn_content`

Профиль

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.57 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
26	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
23	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:320
22	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:101
21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_infinite/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_infinite/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_infinite/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_infinite/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_infinite/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_infinite/layouts/template.php:112
9	include JROOT/templates/yoo_infinite/layouts/template.php	JROOT/templates/yoo_infinite/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_infinite/index.php:19
7	require JROOT/templates/yoo_infinite/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

Время запроса: 0.16 ms После последнего запроса: 2.77 ms

SELECT * 
  FROM wc6hn_widgetkit_widget 
  WHERE id=78

План запросов (Explain)

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

Профиль

Нет SHOW PROFILE (возможно, потому что более 100 запросов)

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:42
18	WidgetWidgetkitHelper->get()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:160
17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_infinite/warp/systems/joomla/helpers/modules.php:86
13	ModulesWarpHelper->load()	JROOT/templates/yoo_infinite/warp/systems/joomla/layouts/modules.php:10
12	include JROOT/templates/yoo_infinite/warp/systems/joomla/layouts/modules.php	JROOT/templates/yoo_infinite/warp/helpers/template.php:49
11	TemplateWarpHelper->render()	JROOT/templates/yoo_infinite/warp/systems/joomla/helpers/modules.php:64
10	ModulesWarpHelper->render()	JROOT/templates/yoo_infinite/layouts/template.php:112
9	include JROOT/templates/yoo_infinite/layouts/template.php	JROOT/templates/yoo_infinite/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/yoo_infinite/index.php:19
7	require JROOT/templates/yoo_infinite/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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:49

[Добавьте директиву xdebug.file_link_format в файл php.ini для получения ссылок на файлы]

20 типов запросов зарегистрировано (отсортировано по вхождениям)

Запросы типа SELECT:

15 × SELECT id 
  FROM wc6hn_zoo_comment

15 × SELECT b.id 
  FROM wc6hn_zoo_category_item AS a JOIN wc6hn_zoo_category AS b 
  ON a.category_id = b.id

2 × SELECT * 
  FROM wc6hn_widgetkit_widget

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

1 × SELECT params 
  FROM wc6hn_extensions AS e

1 × SELECT id,template 
  FROM wc6hn_template_styles

1 × SELECT a.* 
  FROM wc6hn_zoo_item AS a 
  LEFT JOIN wc6hn_zoo_category_item AS b 
  ON a.id = b.item_id

1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM wc6hn_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN wc6hn_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN wc6hn_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-01-17 03:49:18') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-01-17 03:49:18')

1 × SELECT id, rules 
  FROM `wc6hn_viewlevels

1 × SELECT `session_id` 
  FROM `wc6hn_session`

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

1 × SELECT * 
  FROM wc6hn_zoo_application

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

1 × SELECT `data` 
  FROM `wc6hn_session`

Запросы типа OTHER:

1 × 
  SET SESSION group_concat_max_len = 104857

1 × SHOW FULL COLUMNS 
  FROM `wc6hn_content

1 × UPDATE `wc6hn_extensions` 
  SET `params` = '{\"mediaversion\":\"a86dd27b17b4c765c8e2851540b31b88\"}'

1 × INSERT INTO `wc6hn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6561716f37346532306d6b6f326e396f6535333872326b753437', 1, 1642391358, 0, '', 0

1 × SHOW VARIABLES LIKE 'have_profiling

1 × SHOW VARIABLES LIKE 'query_cache_type

Каталоги, руководства и инструкции к технике GREAT PLAINS

Консоль отладки Joomla

Сессия

Профилирование

Время

Память

Использование памяти

Запросы к базе данных

49 запросов зарегистрировано 28.86 ms

20 типов запросов зарегистрировано (отсортировано по вхождениям)

Запросы типа SELECT:

Запросы типа OTHER: