Проектируемый проезд № 253, к610, Видное, Ленинский городской округ, Московская область, 142700

Запчасти для американских грузовиков Volvo

База соленоидов Volvo

TDA R955324 / 85104906 / 20408923 / S472 998 101 2

Бачок расширительный VOLVO (с датчиком и крышками)

20519037

Блок управления светом фар VOLVO

20953575 / 20942847 / 20466305 / 20455305 / 3198083

Защелка капота верхняя VOLVO (на капоте)

8081394 / 8089035 / 8081359 / 8089034 / 20498998

Клапан воздушный распределитель тормозов

TDA S934 899 074 0 / 20469219 / 20560013 / 20815953

Клапан пневмомуфты вентилятора VOLVO

20807261 / 20858976 / 20408595 / KYS 10560828703

Контактная группа замка зажигания Volvo

8159904

Кран уровня задней подвески VOLVO

S464 008 115 0 / 464 008 011 0 / 20526793 / 85108667 / 85112623

Кран уровня задней подвески VOLVO (без кронштейна)

S464 008 115 0 / 464 008 011 0 / 20734923 / 20733026 / 20467882

[1] 2 3 4 > >>

Мы лучшие

Мы много лет на рынке автозапчастей для американских и европейских грузовиков и тягачей и спецтехники.

Любые запчасти в наличии для ремонта двигателей.

В наличии всегда много запчастей для автомобилей Freighliner, Volvo, International, Kenworth, Peterbilt, Mack и Sterling.

Detroit Diesel,

Cummins,

Caterpillar,

International DT-466

Осуществляем доставку любых запчастей из США и Канады.

Работаем строго с НДС и 50% предоплатой на заказные товары.

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714053710,
                "last": 1714053710,
                "now": 1714053710
            },
            "token": "44AHHYHXzn3RY8J4LHayz2sNCd37oA22"
        },
        "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
        }
    }
}

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

Время

Память

Время: 20.77 ms / 20.77 ms Память: 2.027 MB / 2.41 MB Application: afterLoad

Время: 57.51 ms / 78.28 ms Память: 4.944 MB / 7.36 MB Application: afterInitialise

Время: 23.47 ms / 101.75 ms Память: 1.984 MB / 9.34 MB Application: afterRoute

Время: 0.17 ms / 101.92 ms Память: 0.004 MB / 9.35 MB Application: beforeRenderComponent com_zoo

Время: 8.06 ms / 109.98 ms Память: 0.667 MB / 10.01 MB Application: Before Access::preloadComponents (all components)

Время: 1.13 ms / 111.11 ms Память: 0.039 MB / 10.05 MB Application: After Access::preloadComponents (all components)

Время: 0.04 ms / 111.15 ms Память: -0.003 MB / 10.05 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.43 ms / 111.58 ms Память: 0.026 MB / 10.08 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 76.06 ms / 187.63 ms Память: 2.183 MB / 12.26 MB Application: afterRenderComponent com_zoo

Время: 1.47 ms / 189.11 ms Память: 0.098 MB / 12.36 MB Application: afterDispatch

Время: 7.13 ms / 196.24 ms Память: 0.352 MB / 12.71 MB Application: beforeRenderModule mod_menu ()

Время: 10.47 ms / 206.71 ms Память: 0.331 MB / 13.04 MB Application: afterRenderModule mod_menu ()

Время: 0.09 ms / 206.80 ms Память: -0.022 MB / 13.02 MB Application: beforeRenderModule mod_menu ()

Время: 6.61 ms / 213.41 ms Память: 0.024 MB / 13.04 MB Application: afterRenderModule mod_menu ()

Время: 0.10 ms / 213.51 ms Память: -0.011 MB / 13.03 MB Application: beforeRenderModule mod_menu ()

Время: 6.55 ms / 220.06 ms Память: 0.024 MB / 13.06 MB Application: afterRenderModule mod_menu ()

Время: 0.09 ms / 220.15 ms Память: -0.022 MB / 13.03 MB Application: beforeRenderModule mod_menu ()

Время: 6.44 ms / 226.59 ms Память: 0.025 MB / 13.06 MB Application: afterRenderModule mod_menu ()

Время: 0.09 ms / 226.68 ms Память: -0.019 MB / 13.04 MB Application: beforeRenderModule mod_menu ()

Время: 6.52 ms / 233.20 ms Память: 0.024 MB / 13.06 MB Application: afterRenderModule mod_menu ()

Время: 0.09 ms / 233.28 ms Память: -0.022 MB / 13.04 MB Application: beforeRenderModule mod_menu ()

Время: 6.45 ms / 239.74 ms Память: 0.024 MB / 13.07 MB Application: afterRenderModule mod_menu ()

Время: 0.09 ms / 239.83 ms Память: -0.022 MB / 13.04 MB Application: beforeRenderModule mod_menu ()

Время: 6.46 ms / 246.28 ms Память: 0.024 MB / 13.07 MB Application: afterRenderModule mod_menu ()

Время: 0.82 ms / 247.10 ms Память: 0.003 MB / 13.07 MB Application: beforeRenderModule mod_pwebcontact (Perfect AJAX Popup Contact Form)

Время: 19.36 ms / 266.45 ms Память: 2.161 MB / 15.23 MB Application: afterRenderModule mod_pwebcontact (Perfect AJAX Popup Contact Form)

Время: 0.04 ms / 266.50 ms Память: -0.037 MB / 15.19 MB Application: beforeRenderModule mod_custom (Yandex counter)

Время: 0.68 ms / 267.18 ms Память: 0.006 MB / 15.20 MB Application: afterRenderModule mod_custom (Yandex counter)

Время: 0.07 ms / 267.25 ms Память: 0.011 MB / 15.21 MB Application: beforeRenderModule mod_custom (копирайт)

Время: 0.16 ms / 267.41 ms Память: 0.003 MB / 15.21 MB Application: afterRenderModule mod_custom (копирайт)

Время: 0.04 ms / 267.45 ms Память: -0.001 MB / 15.21 MB Application: beforeRenderModule mod_custom (Мы лучшие)

Время: 0.14 ms / 267.60 ms Память: 0.003 MB / 15.22 MB Application: afterRenderModule mod_custom (Мы лучшие)

Время: 0.05 ms / 267.64 ms Память: -0.000 MB / 15.22 MB Application: beforeRenderModule mod_breadcrumbs (Путь сайта)

Время: 0.88 ms / 268.52 ms Память: 0.028 MB / 15.25 MB Application: afterRenderModule mod_breadcrumbs (Путь сайта)

Время: 0.03 ms / 268.55 ms Память: -0.003 MB / 15.24 MB Application: beforeRenderModule mod_search (Поиск по сайту)

Время: 0.62 ms / 269.17 ms Память: 0.016 MB / 15.26 MB Application: afterRenderModule mod_search (Поиск по сайту)

Время: 0.05 ms / 269.22 ms Память: -0.003 MB / 15.26 MB Application: beforeRenderModule mod_custom (Вот сюда)

Время: 1.33 ms / 270.56 ms Память: 0.015 MB / 15.27 MB Application: afterRenderModule mod_custom (Вот сюда)

Время: 2.95 ms / 273.51 ms Память: 0.201 MB / 15.47 MB Application: afterRender

Всего запросов к базе данных: 31.55 ms

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

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Профиль

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.11 ms
Waiting for query cache lock	0.00 ms
update	0.00 ms
end	0.00 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.52 ms После последнего запроса: 2.34 ms Память запроса: 0.040 MB. Память перед запросом: 4.475 MB Возвращено строк: 38

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `parttorg_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	parttorg_extensions	NULL	ref	extension	extension	82	const	40	1.00	Using where

Профиль

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.22 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Такой же, как вызов в строке ниже
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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.18 ms После последнего запроса: 2.32 ms Память запроса: 0.021 MB. Память перед запросом: 4.740 MB Возвращено строк: 5

SELECT id, rules

  FROM `parttorg_viewlevels`

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.26 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB. Память перед запросом: 4.752 MB Возвращено строк: 2

SELECT b.id

  FROM parttorg_usergroups AS a

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

  WHERE a.id = 9

План запросов (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	2	100.00	Using where; Using index

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.74 ms После последнего запроса: 0.66 ms Память запроса: 0.030 MB. Память перед запросом: 4.820 MB Возвращено строк: 80

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM parttorg_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	parttorg_extensions	NULL	ref	extension	extension	82	const	116	0.60	Using index condition; Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.51 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
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 для получения ссылок на файлы]

Время запроса: 1.23 ms После последнего запроса: 32.03 ms Память запроса: 0.100 MB. Память перед запросом: 7.545 MB Возвращено строк: 92

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM parttorg_menu AS m

  LEFT JOIN parttorg_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	INDEX KEY не используется	NULL	NULL	190	7.95	Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.m.component_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.79 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Такой же, как вызов в строке ниже
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.29 ms После последнего запроса: 10.44 ms Память запроса: 0.022 MB. Память перед запросом: 8.636 MB Возвращено строк: 1

SELECT id 
  FROM parttorg_zoo_category 
  WHERE alias = 'zapchasti-volvo' 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	parttorg_zoo_category	NULL	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1	100.00	NULL

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
12	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:119
11	AppAlias->translateAliasToID()	JROOT/components/com_zoo/router.php:194
10	ZooParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.31 ms После последнего запроса: 0.64 ms Память запроса: 0.024 MB. Память перед запросом: 8.693 MB Возвращено строк: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `parttorg_extensions`

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

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Такой же, как вызов в строке ниже
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.24 ms После последнего запроса: 0.15 ms Память запроса: 0.006 MB. Память перед запросом: 8.686 MB

UPDATE `parttorg_extensions`

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

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	parttorg_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Профиль

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.04 ms
updating	0.06 ms
end	0.00 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.33 ms После последнего запроса: 3.82 ms Память запроса: 0.022 MB. Память перед запросом: 9.085 MB Возвращено строк: 2

SELECT *

  FROM parttorg_languages

  WHERE published=1

  ORDER BY ordering ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	parttorg_languages	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	50.00	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:248
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.43 ms После последнего запроса: 2.85 ms Память запроса: 0.025 MB. Память перед запросом: 9.325 MB Возвращено строк: 1

SELECT id, home, template, s.params

  FROM parttorg_template_styles as s

  LEFT JOIN parttorg_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1	100.00	NULL
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	a0415639_parttorg.s.template,const	1	4.50	Using index condition; Using where

Профиль

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Такой же, как вызов в строке ниже
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.22 ms После последнего запроса: 2.68 ms Память запроса: 0.022 MB. Память перед запросом: 9.552 MB Возвращено строк: 1

SELECT * 
  FROM parttorg_zoo_category 
  WHERE id = 192

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
11	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
10	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
9	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:77
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.19 ms После последнего запроса: 0.93 ms Память запроса: 0.022 MB. Память перед запросом: 9.608 MB Возвращено строк: 1

SELECT * 
  FROM parttorg_zoo_application 
  WHERE id = 4

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

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

Профиль

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	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.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
12	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
11	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
10	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
9	AppTable->get()	JROOT/administrator/components/com_zoo/classes/category.php:186
8	Category->getApplication()	JROOT/administrator/components/com_zoo/helpers/zoo.php:78
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.87 ms После последнего запроса: 4.97 ms Память запроса: 0.028 MB. Память перед запросом: 10.001 MB Возвращено строк: 38

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

  FROM `parttorg_assets`

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

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

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

Профиль

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.42 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->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:222
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:257
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.07 ms После последнего запроса: 0.63 ms Память запроса: 0.007 MB. Память перед запросом: 10.075 MB


  SET SESSION group_concat_max_len = 1048576

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

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

Профиль

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.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->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:446
12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:470
11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:222
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:257
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 для получения ссылок на файлы]

Время запроса: 3.13 ms После последнего запроса: 0.42 ms Память запроса: 0.044 MB. Память перед запросом: 10.111 MB Возвращено строк: 23

SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM parttorg_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN parttorg_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN parttorg_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1,5) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-25 14:01:50') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-25 14:01:50') 
  WHERE c.application_id = 4 
  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	PRIMARY,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX	5	const,const	22	100.00	Using index condition
1	SIMPLE	ci	NULL	ref	PRIMARY,CATEGORYID_INDEX	PRIMARY	4	a0415639_parttorg.c.id	34	100.00	Using index
1	SIMPLE	i	NULL	ref	MULTI_INDEX2	MULTI_INDEX2	4	a0415639_parttorg.ci.item_id	1	100.00	Using where; Using index

Профиль

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.31 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	2.14 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.22 ms
closing tables	0.07 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->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:446
12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:470
11	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:222
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:257
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 для получения ссылок на файлы]

Время запроса: 8.29 ms После последнего запроса: 2.44 ms Память запроса: 0.046 MB. Память перед запросом: 10.400 MB Возвращено строк: 20

SELECT a.* 
  FROM parttorg_zoo_item AS a 
  LEFT JOIN parttorg_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 4 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-25 14:01:50') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 14:01:50') 
  AND b.category_id  = 192 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.name ASC 
  LIMIT 0,20

План запросов (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	62	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	a0415639_parttorg.b.item_id	1	39.69	Using where

Профиль

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	1.00 ms
Creating sort index	0.25 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	6.53 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->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:469
11	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:245
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:257
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 для получения ссылок на файлы]

Время запроса: 2.73 ms После последнего запроса: 10.36 ms Память запроса: 0.031 MB. Память перед запросом: 11.832 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1394 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1394 
  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	a0415639_parttorg.a.category_id	1	95.65	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.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	1.80 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Sending data	0.05 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.47 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.35 ms После последнего запроса: 6.45 ms Память запроса: 0.031 MB. Память перед запросом: 11.995 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1396 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1396 
  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	a0415639_parttorg.a.category_id	1	95.65	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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.30 ms После последнего запроса: 2.65 ms Память запроса: 0.031 MB. Память перед запросом: 12.013 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1401 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1401 
  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	a0415639_parttorg.a.category_id	1	95.65	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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.35 ms После последнего запроса: 4.26 ms Память запроса: 0.031 MB. Память перед запросом: 12.031 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1411 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1411 
  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	a0415639_parttorg.a.category_id	1	95.65	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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.41 ms Память запроса: 0.031 MB. Память перед запросом: 12.049 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1429 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1429 
  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	a0415639_parttorg.a.category_id	1	95.65	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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.38 ms Память запроса: 0.031 MB. Память перед запросом: 12.067 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1437 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1437 
  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	a0415639_parttorg.a.category_id	1	95.65	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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.36 ms Память запроса: 0.031 MB. Память перед запросом: 12.084 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1438 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1438 
  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	a0415639_parttorg.a.category_id	1	95.65	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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.21 ms После последнего запроса: 1.35 ms Память запроса: 0.031 MB. Память перед запросом: 12.102 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1469 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1469 
  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	a0415639_parttorg.a.category_id	1	95.65	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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.27 ms После последнего запроса: 2.38 ms Память запроса: 0.031 MB. Память перед запросом: 12.126 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1470 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1470 
  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	a0415639_parttorg.a.category_id	1	95.65	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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.34 ms Память запроса: 0.031 MB. Память перед запросом: 12.144 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1502 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1502 
  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	a0415639_parttorg.a.category_id	1	95.65	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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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 После последнего запроса: 1.35 ms Память запроса: 0.031 MB. Память перед запросом: 12.162 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1504 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1504 
  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	a0415639_parttorg.a.category_id	1	95.65	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
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.40 ms Память запроса: 0.031 MB. Память перед запросом: 12.179 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1505 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1505 
  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	a0415639_parttorg.a.category_id	1	95.65	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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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 После последнего запроса: 1.34 ms Память запроса: 0.031 MB. Память перед запросом: 12.197 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1508 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1508 
  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	a0415639_parttorg.a.category_id	1	95.65	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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.32 ms После последнего запроса: 1.42 ms Память запроса: 0.032 MB. Память перед запросом: 12.222 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1509 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1509 
  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	a0415639_parttorg.a.category_id	1	95.65	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.05 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.27 ms После последнего запроса: 1.32 ms Память запроса: 0.031 MB. Память перед запросом: 12.241 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1516 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1516 
  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	a0415639_parttorg.a.category_id	1	95.65	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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.00 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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.33 ms После последнего запроса: 1.24 ms Память запроса: 0.031 MB. Память перед запросом: 12.259 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1523 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1523 
  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	a0415639_parttorg.a.category_id	1	95.65	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.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.66 ms После последнего запроса: 1.39 ms Память запроса: 0.031 MB. Память перед запросом: 12.277 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1566 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1566 
  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	a0415639_parttorg.a.category_id	1	95.65	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.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.62 ms После последнего запроса: 1.58 ms Память запроса: 0.031 MB. Память перед запросом: 12.295 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1574 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1574 
  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	a0415639_parttorg.a.category_id	1	95.65	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.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
optimizing	0.02 ms
statistics	0.01 ms
optimizing	0.01 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.35 ms Память запроса: 0.031 MB. Память перед запросом: 12.313 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1582 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1582 
  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	a0415639_parttorg.a.category_id	1	95.65	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.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 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.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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.34 ms После последнего запроса: 1.39 ms Память запроса: 0.031 MB. Память перед запросом: 12.346 MB Возвращено строк: 1

SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=1583 
  AND b.published = 1 UNION SELECT 0 
  FROM parttorg_zoo_category_item AS a 
  WHERE a.item_id=1583 
  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	a0415639_parttorg.a.category_id	1	95.65	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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
30	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
29	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
28	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:565
27	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:296
26	RouteHelper->item()	JROOT/media/zoo/elements/image/image.php:82
25	ElementImage->render()	JROOT/components/com_zoo/renderer/element/default.php:19
24	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
23	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
22	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php:16
21	include JROOT/media/zoo/applications/product/templates/default/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
19	ItemRenderer->render()	JROOT/media/zoo/applications/product/templates/default/_item.php:17
18	include JROOT/media/zoo/applications/product/templates/default/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
17	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/_items.php:37
16	include JROOT/media/zoo/applications/product/templates/default/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:100
15	AppView->partial()	JROOT/media/zoo/applications/product/templates/default/category.php:89
14	include JROOT/media/zoo/applications/product/templates/default/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_zoo/framework/classes/view.php:65
11	AppView->display()	JROOT/components/com_zoo/controllers/default.php:342
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:257
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 для получения ссылок на файлы]

Время запроса: 2.15 ms После последнего запроса: 9.70 ms Память запроса: 0.026 MB. Память перед запросом: 12.526 MB Возвращено строк: 7

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM parttorg_modules AS m

  LEFT JOIN parttorg_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN parttorg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-25 14:01:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 14:01:50') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 551 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	INDEX KEY не используется	NULL	NULL	86	1.16	Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	a0415639_parttorg.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	a0415639_parttorg.m.id	6	40.00	Using where; Using index

Профиль

Status	Duration
starting	0.13 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.55 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	Такой же, как вызов в строке ниже
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:614
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/vt_trucking/vtemtools/switcher.php:35
9	require_once JROOT/templates/vt_trucking/vtemtools/switcher.php	JROOT/templates/vt_trucking/vtemtools/default.php:124
8	include_once JROOT/templates/vt_trucking/vtemtools/default.php	JROOT/templates/vt_trucking/index.php:8
7	require JROOT/templates/vt_trucking/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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.30 ms После последнего запроса: 71.53 ms Память запроса: 0.027 MB. Память перед запросом: 15.334 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM parttorg_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_pwebcontact.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

План запросов (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 index condition; Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	a0415639_parttorg.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.group_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.17 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.10 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.03 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.12 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
15	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_pwebcontact/tmpl/default.php:88
11	require JROOT/modules/mod_pwebcontact/tmpl/default.php	JROOT/modules/mod_pwebcontact/mod_pwebcontact.php:221
10	include JROOT/modules/mod_pwebcontact/mod_pwebcontact.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.83 ms После последнего запроса: 3.43 ms Память запроса: 0.026 MB. Память перед запросом: 15.280 MB Возвращено строк: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM parttorg_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

План запросов (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 index condition; Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	a0415639_parttorg.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	a0415639_parttorg.a.group_id	1	100.00	Using where

Профиль

Status	Duration
starting	0.11 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.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.22 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.93 ms Память запроса: 0.022 MB. Память перед запросом: 15.306 MB Возвращено строк: 0

SELECT *
 
  FROM parttorg_jmap_metainfo
 
  WHERE `linkurl` = 'http://part-torg.ru/gruzoviki-truck/volvo-truck/category/zapchasti-volvo.html'
 
  AND `published` = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	parttorg_jmap_metainfo	NULL	ref	published	published	1	const	1	100.00	Using where

Профиль

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	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.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:413
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.16 ms После последнего запроса: 0.04 ms Память запроса: 0.022 MB. Память перед запросом: 15.312 MB Возвращено строк: 0

SELECT *
 
  FROM parttorg_jmap_canonicals
 
  WHERE `linkurl` = 'http://part-torg.ru/gruzoviki-truck/volvo-truck/category/zapchasti-volvo.html'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:491
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.14 ms После последнего запроса: 1.21 ms Память запроса: 0.020 MB. Память перед запросом: 15.468 MB Возвращено строк: 0

SELECT *
 
  FROM parttorg_jmap_headings
 
  WHERE `linkurl` = 'http://part-torg.ru/gruzoviki-truck/volvo-truck/category/zapchasti-volvo.html'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:800
7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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 для получения ссылок на файлы]

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

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

20 × SELECT b.id 
  FROM parttorg_zoo_category_item AS a JOIN parttorg_zoo_category AS b 
  ON a.category_id = b.id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `parttorg_extensions`

2 × 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 parttorg_fields AS a 
  LEFT JOIN `parttorg_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN parttorg_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN parttorg_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN parttorg_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN parttorg_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `data` 
  FROM `parttorg_session`

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

1 × SELECT *  
  FROM parttorg_jmap_canonicals

1 × SELECT *  
  FROM parttorg_jmap_metainfo

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM parttorg_modules AS m 
  LEFT JOIN parttorg_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN parttorg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.* 
  FROM parttorg_zoo_item AS a 
  LEFT JOIN parttorg_zoo_category_item AS b 
  ON a.id = b.item_id

1 × SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
  FROM parttorg_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
  LEFT JOIN parttorg_zoo_category_item as ci 
  ON ci.category_id = c.id 
  LEFT JOIN parttorg_zoo_item AS i USE INDEX (MULTI_INDEX2) 
  ON ci.item_id = i.id 
  AND i.access IN (1,5) 
  AND i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-25 14:01:50') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-25 14:01:50')

1 × SELECT * 
  FROM parttorg_zoo_category

1 × SELECT * 
  FROM parttorg_zoo_application

1 × SELECT `session_id` 
  FROM `parttorg_session`

1 × SELECT id, home, template, s.params 
  FROM parttorg_template_styles as s 
  LEFT JOIN parttorg_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM parttorg_languages

1 × SELECT id 
  FROM parttorg_zoo_category

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM parttorg_menu AS m 
  LEFT JOIN parttorg_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM parttorg_extensions

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

1 × SELECT id, rules 
  FROM `parttorg_viewlevels

1 × SELECT *  
  FROM parttorg_jmap_headings

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

1 × INSERT INTO `parttorg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6262353938633833623530386631353639613537663137363132643661393933', 1, 1714053710, 0, '', 0

1 × UPDATE `parttorg_extensions` 
  SET `params` = '{\"mediaversion\":\"f0e32f62421cad24bb76d56f70b0769d\"}'

1 × 
  SET SESSION group_concat_max_len = 104857

Запчасти для американских грузовиков Volvo

Амортизатор кабины VOLVO

Амортизатор капота Volvo

База соленоидов Volvo

Бачок расширительный VOLVO (с датчиком и крышками)

Блок управления светом фар VOLVO

Вилка сцепления VOLVO

Вилка сцепления Volvo

Гофра глушителя Volvo D13

Датчик ABS задний Volvo

Замок зажигания в сборе Volvo

Замок капота VOLVO

Защелка капота верхняя VOLVO (на капоте)

Зеркало основное левое VOLVO

Зеркало основное левое VOLVO

Клапан воздушный распределитель тормозов

Клапан пневмомуфты вентилятора VOLVO

Контактная группа замка зажигания Volvo

Кран главный тормозной VOLVO

Кран уровня задней подвески VOLVO

Кран уровня задней подвески VOLVO (без кронштейна)

Мы лучшие

Detroit Diesel,

Cummins,

Caterpillar,

International DT-466

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

Сессия

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

Время

Память

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

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

45 запросов зарегистрировано 31.55 ms

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

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

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