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

Сессия

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1765499481,
                "last": 1765499481,
                "now": 1765499483
            },
            "token": "mSUzXxU2sI0UnKf8cGb6KgNMsjH5op8f"
        },
        "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
        }
    },
    "__jbzoo": {
        "viewed": {
            "4837": {
                "type": "maslo",
                "appId": "2"
            },
            "6566": {
                "type": "maslo",
                "appId": "2"
            }
        }
    }
}

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

Время

Память

Время: 51.38 ms / 51.38 ms Память: 0.412 MB / 0.75 MB Application: afterLoad

Время: 736.09 ms / 787.47 ms Память: 2.222 MB / 2.97 MB Application: afterInitialise

Время: 97.32 ms / 884.79 ms Память: 0.533 MB / 3.50 MB Application: Before Access::preloadComponents (all components)

Время: 1.20 ms / 885.99 ms Память: 0.059 MB / 3.56 MB Application: After Access::preloadComponents (all components)

Время: 0.03 ms / 886.02 ms Память: -0.004 MB / 3.56 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Время: 0.74 ms / 886.76 ms Память: 0.008 MB / 3.56 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Время: 92.95 ms / 979.71 ms Память: 0.805 MB / 4.37 MB Application: afterRoute

Время: 15.00 ms / 994.71 ms Память: 0.013 MB / 4.38 MB Application: beforeRenderComponent com_zoo

Время: 120.24 ms / 1114.95 ms Память: 0.293 MB / 4.68 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.05 ms / 1114.99 ms Память: 0.007 MB / 4.68 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 111.45 ms / 1226.44 ms Память: 0.761 MB / 5.44 MB Application: Before Access::preloadPermissions (com_zoo)

Время: 1.54 ms / 1227.98 ms Память: 0.019 MB / 5.46 MB Application: After Access::preloadPermissions (com_zoo)

Время: 0.02 ms / 1228.00 ms Память: 0.000 MB / 5.46 MB Application: Before Access::getAssetRules (id:120 name:com_zoo.application.2.maslo)

Время: 0.04 ms / 1228.04 ms Память: 0.007 MB / 5.47 MB Application: After Access::getAssetRules (id:120 name:com_zoo.application.2.maslo)

Время: 546.80 ms / 1774.83 ms Память: 1.309 MB / 6.78 MB Application: beforeRenderModule mod_custom (Оферта)

Время: 21.56 ms / 1796.40 ms Память: 0.189 MB / 6.97 MB Application: afterRenderModule mod_custom (Оферта)

Время: 8.33 ms / 1804.73 ms Память: -0.031 MB / 6.94 MB Application: afterRenderComponent com_zoo

Время: 23.34 ms / 1828.07 ms Память: 0.010 MB / 6.95 MB Application: afterDispatch

Время: 105.45 ms / 1933.52 ms Память: 1.754 MB / 8.70 MB Application: beforeRenderModule mod_jbzoo_item (Просмотренные товары)

Время: 100.78 ms / 2034.30 ms Память: 0.244 MB / 8.95 MB Application: beforeRenderModule mod_custom (Кнопка Купить в карточке товара)

Время: 21.88 ms / 2056.18 ms Память: -0.005 MB / 8.94 MB Application: afterRenderModule mod_custom (Кнопка Купить в карточке товара)

Время: 0.29 ms / 2056.47 ms Память: -0.085 MB / 8.86 MB Application: afterRenderModule mod_jbzoo_item (Просмотренные товары)

Время: 0.18 ms / 2056.65 ms Память: -0.007 MB / 8.85 MB Application: beforeRenderModule mod_jbzoo_category (Категории)

Время: 89.04 ms / 2145.69 ms Память: 0.332 MB / 9.18 MB Application: afterRenderModule mod_jbzoo_category (Категории)

Время: 0.07 ms / 2145.76 ms Память: -0.004 MB / 9.18 MB Application: beforeRenderModule mod_jbzoo_search (Подобрать масло (моторное))

Время: 108.43 ms / 2254.19 ms Память: 0.211 MB / 9.39 MB Application: afterRenderModule mod_jbzoo_search (Подобрать масло (моторное))

Время: 12.18 ms / 2266.37 ms Память: 0.021 MB / 9.41 MB Application: beforeRenderModule mod_breadcrumbs (Хлебные крошки)

Время: 2.70 ms / 2269.06 ms Память: 0.016 MB / 9.42 MB Application: afterRenderModule mod_breadcrumbs (Хлебные крошки)

Время: 134.45 ms / 2403.51 ms Память: 0.420 MB / 9.84 MB Application: afterRender

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

EXPLAIN недоступен для: CREATE TABLE IF NOT EXISTS `xsd8v_zoo_jbzoo_config` (`group` VARCHAR(150) NULL DEFAULT NULL, `key` VARCHAR(100) NULL DEFAULT NULL, `value` TEXT NULL, `type` VARCHAR(10) NULL DEFAULT 'string', UNIQUE INDEX `group_key` (`group`, `key`), INDEX `group` (`group`), INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM;

Профиль

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:376
15	JBTablesHelper->createTable()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:184
14	JBTablesHelper->checkConfig()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:56
13	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:43
12	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:54
11	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:42
10	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:96
9	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:170
8	plgSystemJBZoo->onAfterInitialise()	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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.66 ms После последнего запроса: 0.45 ms Память запроса: 0.049 MB. Память перед запросом: 2.738 MB Возвращено строк: 111

SELECT CONCAT_WS(".", `
  group`, `key`) as group_key, 
	`value`, 
	`type`

  FROM xsd8v_zoo_jbzoo_config

  LIMIT 1000

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:156
16	JBModel->_query()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:108
15	JBModel->fetchAll()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:235
14	JBModelConfig->_init()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:57
13	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:43
12	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:54
11	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:42
10	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:96
9	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:170
8	plgSystemJBZoo->onAfterInitialise()	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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.91 ms После последнего запроса: 43.29 ms Память запроса: 0.009 MB. Память перед запросом: 2.929 MB

UPDATE `xsd8v_extensions`

  SET `params` = '{\"mediaversion\":\"544a80b7878d741d52a9dca417107305\"}'

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

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

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

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.09 ms
Updating	0.07 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.50 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
19	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
18	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
17	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
16	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
15	Joomla\CMS\Factory::getDocument()	JROOT/administrator/components/com_zoo/framework/helpers/system.php:76
14	SystemHelper->__get()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbsef.php:114
13	JBSefHelper->__construct()	JROOT/administrator/components/com_zoo/framework/classes/app.php:162
12	App->loadHelper()	JROOT/administrator/components/com_zoo/framework/classes/app.php:109
11	App->getHelper()	JROOT/administrator/components/com_zoo/framework/classes/app.php:177
10	App->__get()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:68
9	JBZooSystemPlugin->onAfterInitialise()	JROOT/plugins/system/jbzoo/jbzoo.php:171
8	plgSystemJBZoo->onAfterInitialise()	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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.90 ms После последнего запроса: 98.72 ms Память запроса: 0.024 MB. Память перед запросом: 3.460 MB Возвращено строк: 1

SELECT id 
  FROM xsd8v_zoo_item 
  WHERE alias = 'motornoe-maslo-total-classic-9-s2-5w-30' 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_zoo_item	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1	Using index

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
15	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:119
14	AppAlias->translateAliasToID()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbsef.php:486
13	JBSefHelper->_parseItemUrl()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbsef.php:176
12	JBSefHelper->sefParseRoute()	JROOT/administrator/components/com_zoo/framework/classes/event.php:275
11	AppEventDispatcher->notify()	JROOT/components/com_zoo/router.php:354
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.90 ms После последнего запроса: 0.20 ms Память запроса: 0.021 MB. Память перед запросом: 3.469 MB Возвращено строк: 4

SELECT *

  FROM xsd8v_rsfirewall_hashes

  WHERE (`type`='3.10.12' OR `type`='protect') 
  AND (`flag`!='C' OR `flag` IS NULL)

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1069
8	plgSystemRsfirewall->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.86 ms После последнего запроса: 7.81 ms Память запроса: 0.021 MB. Память перед запросом: 3.478 MB Возвращено строк: 0

SELECT *

  FROM xsd8v_rsfirewall_snapshots

  WHERE `type`='protect'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:49
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1092
8	plgSystemRsfirewall->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.96 ms После последнего запроса: 0.12 ms Память запроса: 0.021 MB. Память перед запросом: 3.485 MB Возвращено строк: 0

SELECT `ip`,`reason`

  FROM xsd8v_rsfirewall_lists

  WHERE (`ip`='216.73.216.96' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_rsfirewall_lists	ref	published,type,ip	type	1	const	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:172
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:151
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1128
8	plgSystemRsfirewall->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 для получения ссылок на файлы]

Время запроса: 1.01 ms После последнего запроса: 0.09 ms Память запроса: 0.021 MB. Память перед запросом: 3.490 MB Возвращено строк: 0

SELECT `ip`,`reason`

  FROM xsd8v_rsfirewall_lists

  WHERE (`ip`='216.73.216.96' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_rsfirewall_lists	ALL	published,type,ip	INDEX KEY не используется	NULL	NULL	5	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:172
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:141
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1132
8	plgSystemRsfirewall->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 для получения ссылок на файлы]

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

SELECT *

  FROM xsd8v_rsfirewall_exceptions

  WHERE `published`='1'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:720
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1263
8	plgSystemRsfirewall->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.99 ms После последнего запроса: 5.67 ms Память запроса: 0.028 MB. Память перед запросом: 3.505 MB Возвращено строк: 42

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

  FROM `xsd8v_assets`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_assets	range	idx_asset_name	idx_asset_name	202	NULL	43	Using index condition

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.01 ms
Statistics	0.12 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.22 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.03 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/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:33
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Такой же, как вызов в строке ниже
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:106
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:62
8	PlgSystemAdvancedModules->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.82 ms После последнего запроса: 150.82 ms Память запроса: 0.022 MB. Память перед запросом: 4.408 MB Возвращено строк: 1

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4837

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_zoo_item	const	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1

Профиль

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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:75
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.65 ms После последнего запроса: 2.81 ms Память запроса: 0.022 MB. Память перед запросом: 4.494 MB Возвращено строк: 1

SELECT * 
  FROM xsd8v_zoo_application 
  WHERE id = 2

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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/item.php:326
8	Item->getApplication()	JROOT/administrator/components/com_zoo/helpers/zoo.php:76
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 для получения ссылок на файлы]

Время запроса: 1.76 ms После последнего запроса: 97.71 ms Память запроса: 0.123 MB. Память перед запросом: 4.707 MB Возвращено строк: 26

SELECT * 
  FROM xsd8v_zoo_category 
  WHERE application_id = 2 
  AND published = 1 
  ORDER BY ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_zoo_category	ALL	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	INDEX KEY не используется	NULL	NULL	52	Using where; Используется сортировка файлов

Профиль

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 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.85 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
18	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
17	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
16	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:230
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
13	Application->getCategoryTree()	JROOT/administrator/components/com_zoo/helpers/route.php:295
12	RouteHelper->item()	JROOT/components/com_zoo/controllers/default.php:131
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 1.35 ms После последнего запроса: 4.72 ms Память запроса: 0.007 MB. Память перед запросом: 4.843 MB

UPDATE xsd8v_zoo_item 
  SET hits = (hits + 1) 
  WHERE id = 4837

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

EXPLAIN недоступен для: UPDATE xsd8v_zoo_item SET hits = (hits + 1) WHERE id = 4837

Профиль

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.08 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.50 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:178
13	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:674
12	Item->hit()	JROOT/components/com_zoo/controllers/default.php:167
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 1.37 ms После последнего запроса: 80.01 ms Память запроса: 0.028 MB. Память перед запросом: 5.448 MB Возвращено строк: 6

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

  FROM `xsd8v_assets`

  WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_assets	ALL	idx_asset_name,idx_parent_id	INDEX KEY не используется	NULL	NULL	271	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
24	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
23	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
22	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
21	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
20	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
19	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
18	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
17	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
16	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
15	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:26
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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.67 ms После последнего запроса: 70.49 ms Память запроса: 0.029 MB. Память перед запросом: 5.695 MB Возвращено строк: 1

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4838

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_zoo_item	const	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
26	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
25	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
24	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
23	AppTable->get()	JROOT/media/zoo/applications/jbuniversal/elements/schema/schema.php:189
22	ElementSchema->render()	JROOT/components/com_zoo/renderer/element/default.php:19
21	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php:32
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:251
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:41
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 4.16 ms После последнего запроса: 0.19 ms Память запроса: 0.030 MB. Память перед запросом: 5.717 MB Возвращено строк: 1

SELECT * 
  FROM xsd8v_zoo_application 
  WHERE id = 1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
30	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
29	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
28	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
27	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
26	AppTable->get()	JROOT/administrator/components/com_zoo/classes/item.php:326
25	Item->getApplication()	JROOT/administrator/components/com_zoo/classes/item.php:339
24	Item->getType()	JROOT/administrator/components/com_zoo/classes/item.php:459
23	Item->getElement()	JROOT/media/zoo/applications/jbuniversal/elements/schema/schema.php:190
22	ElementSchema->render()	JROOT/components/com_zoo/renderer/element/default.php:19
21	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php:32
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:251
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:41
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 1.66 ms После последнего запроса: 111.42 ms Память запроса: 0.029 MB. Память перед запросом: 6.405 MB Возвращено строк: 1

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4839

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_zoo_item	const	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
26	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
25	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
24	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
23	AppTable->get()	JROOT/media/zoo/applications/jbuniversal/elements/schema/schema.php:189
22	ElementSchema->render()	JROOT/components/com_zoo/renderer/element/default.php:19
21	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php:32
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:251
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:41
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 4.28 ms После последнего запроса: 76.75 ms Память запроса: 0.201 MB. Память перед запросом: 6.437 MB Возвращено строк: 122

SELECT id, title, module, position, content, showtitle, params, published 
  FROM xsd8v_modules AS m 
  LEFT JOIN xsd8v_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.access IN (1,5) 
  AND published = 1 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-12-12 00:31:23') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-12-12 00:31:23') 
  AND m.client_id = 0 
  ORDER BY position, ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published	published	1	const	53	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	user_sply.m.id	1	Using index

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
23	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:355
22	DatabaseHelper->__call()	JROOT/administrator/components/com_zoo/helpers/module.php:57
21	ModuleHelper->load()	JROOT/media/zoo/elements/joomlamodule/joomlamodule.php:27
20	ElementJoomlamodule->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:170
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php:96
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:251
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:41
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 1.51 ms После последнего запроса: 290.47 ms Память запроса: 0.034 MB. Память перед запросом: 6.846 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 xsd8v_fields AS a

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

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

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

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

  LEFT JOIN xsd8v_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	user_sply.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.group_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
35	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
34	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
33	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
32	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
31	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
30	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
29	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
28	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
27	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
26	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
25	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
24	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
23	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/media/zoo/elements/joomlamodule/joomlamodule.php:54
22	ElementJoomlamodule->render()	JROOT/components/com_zoo/renderer/element/block.php:25
21	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php:96
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:251
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:41
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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.79 ms После последнего запроса: 1.97 ms Память запроса: 0.030 MB. Память перед запросом: 6.912 MB Возвращено строк: 1

SELECT a.params

  FROM xsd8v_advancedmodules AS a

  WHERE a.moduleid = 153

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
31	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:683
30	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:666
29	PlgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:287
28	PlgSystemAdvancedModuleHelper->setAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:66
27	PlgSystemAdvancedModuleHelper->isEmpty()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:48
26	PlgSystemAdvancedModuleHelper->onRenderModule()	JROOT/libraries/joomla/event/dispatcher.php:165
25	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
24	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:245
23	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/media/zoo/elements/joomlamodule/joomlamodule.php:54
22	ElementJoomlamodule->render()	JROOT/components/com_zoo/renderer/element/block.php:25
21	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php:96
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:251
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:41
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 5.13 ms После последнего запроса: 2.91 ms Память запроса: 0.033 MB. Память перед запросом: 6.964 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 xsd8v_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_zoo.element.textarea' 
  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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	user_sply.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	user_sply.a.group_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
35	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
34	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
33	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
32	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
31	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
30	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
28	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
27	JHtmlContent::prepare()	Такой же, как вызов в строке ниже
26	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
25	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
24	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
23	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
22	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
21	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php:104
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/maslo/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:251
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:41
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.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/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
10	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php:122
7	JBUniversalApplication->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 для получения ссылок на файлы]

Время запроса: 5.76 ms После последнего запроса: 26.40 ms Память запроса: 0.238 MB. Память перед запросом: 6.973 MB Возвращено строк: 46

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM xsd8v_modules AS m

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

  LEFT JOIN xsd8v_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds	published	1	const	53	Using index condition; Using where; Используется сортировка файлов
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	user_sply.m.module,const	1	Using index condition; Using where
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	user_sply.m.id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:599
14	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:159
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/supplym/index.php:20
7	require JROOT/templates/supplym/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 для получения ссылок на файлы]

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

SELECT t.parent_id

  FROM xsd8v_menu as t

  WHERE t.id = 113

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:150
18	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:70
17	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:53
16	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:777
15	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:200
14	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:222
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/supplym/index.php:20
7	require JROOT/templates/supplym/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 для получения ссылок на файлы]

Время запроса: 7.36 ms После последнего запроса: 0.10 ms Память запроса: 0.026 MB. Память перед запросом: 7.594 MB Возвращено строк: 1

SELECT t.parent_id

  FROM xsd8v_menu as t

  WHERE t.id = 106

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:150
18	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:70
17	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:53
16	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:777
15	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:200
14	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:222
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/supplym/index.php:20
7	require JROOT/templates/supplym/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 для получения ссылок на файлы]

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

SELECT t.parent_id

  FROM xsd8v_menu as t

  WHERE t.id = 1

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:150
18	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:70
17	RegularLabs\Library\Condition\Menu->getMenuParentIds()	JROOT/libraries/regularlabs/src/Condition/Menu.php:53
16	RegularLabs\Library\Condition\Menu->pass()	JROOT/libraries/regularlabs/src/Conditions.php:777
15	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:200
14	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:222
13	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/supplym/index.php:20
7	require JROOT/templates/supplym/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 для получения ссылок на файлы]

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

SELECT tItem.id

  FROM xsd8v_zoo_item AS tItem

  WHERE tItem.type IN ("maslo", "smazka", "sozh")
 
  AND tItem.application_id IN (2)
 
  AND tItem.id IN (6566)
 
  AND tItem.state = '1'
 
  AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2025-12-12 00:31:23')
 
  AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2025-12-12 00:31:23')


  ORDER BY tItem.id ASC

  LIMIT 20

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tItem	const	PRIMARY,PUBLISH_INDEX,STATE_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:156
17	JBModel->_query()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.item.php:144
16	JBModelItem->getList()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbviewed.php:122
15	JBViewedHelper->getList()	JROOT/modules/mod_jbzoo_item/types/viewed.php:33
14	JBZooModItemViewed->getItems()	JROOT/modules/mod_jbzoo_item/helper.php:109
13	JBModuleHelperItem->getItems()	JROOT/modules/mod_jbzoo_item/helper.php:150
12	JBModuleHelperItem->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_item/mod_jbzoo_item.php:27
10	include JROOT/modules/mod_jbzoo_item/mod_jbzoo_item.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 для получения ссылок на файлы]

Время запроса: 8.19 ms После последнего запроса: 0.28 ms Память запроса: 0.026 MB. Память перед запросом: 8.832 MB Возвращено строк: 1

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id IN (6566) 
  ORDER BY id ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xsd8v_zoo_item	const	PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	const	1

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
21	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
20	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
19	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
18	AppTable->all()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:224
17	JBModel->getZooItemsByIds()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.item.php:149
16	JBModelItem->getList()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbviewed.php:122
15	JBViewedHelper->getList()	JROOT/modules/mod_jbzoo_item/types/viewed.php:33
14	JBZooModItemViewed->getItems()	JROOT/modules/mod_jbzoo_item/helper.php:109
13	JBModuleHelperItem->getItems()	JROOT/modules/mod_jbzoo_item/helper.php:150
12	JBModuleHelperItem->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_item/mod_jbzoo_item.php:27
10	include JROOT/modules/mod_jbzoo_item/mod_jbzoo_item.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 для получения ссылок на файлы]

Время запроса: 6.09 ms После последнего запроса: 44.34 ms Память запроса: 0.030 MB. Память перед запросом: 8.926 MB Возвращено строк: 1

SELECT a.params

  FROM xsd8v_advancedmodules AS a

  WHERE a.moduleid = 116

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
30	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:683
29	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:666
28	PlgSystemAdvancedModuleHelper->getAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:287
27	PlgSystemAdvancedModuleHelper->setAdvancedParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:66
26	PlgSystemAdvancedModuleHelper->isEmpty()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:48
25	PlgSystemAdvancedModuleHelper->onRenderModule()	JROOT/libraries/joomla/event/dispatcher.php:165
24	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
23	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:245
22	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/media/zoo/elements/joomlamodule/joomlamodule.php:54
21	ElementJoomlamodule->render()	JROOT/components/com_zoo/renderer/element/block.php:25
20	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
18	ItemRenderer->renderPosition()	JROOT/modules/mod_jbzoo_item/renderer/item/bootstrap.php:39
17	include JROOT/modules/mod_jbzoo_item/renderer/item/bootstrap.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
16	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
15	ItemRenderer->render()	JROOT/templates/supplym/html/mod_jbzoo_item/bootstrap.php:71
14	include JROOT/templates/supplym/html/mod_jbzoo_item/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
13	JBModuleHelper->partial()	JROOT/modules/mod_jbzoo_item/helper.php:151
12	JBModuleHelperItem->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_item/mod_jbzoo_item.php:27
10	include JROOT/modules/mod_jbzoo_item/mod_jbzoo_item.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.97 ms После последнего запроса: 38.30 ms Память запроса: 0.026 MB. Память перед запросом: 8.898 MB Возвращено строк: 26

SELECT tCategory.id

  FROM xsd8v_zoo_category AS tCategory

  WHERE tCategory.application_id = '2'
 
  AND tCategory.parent = 0
 
  AND tCategory.published = '1'


  ORDER BY tCategory.ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tCategory	ALL	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	INDEX KEY не используется	NULL	NULL	52	Using where; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:156
17	JBModel->_query()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.category.php:140
16	JBModelCategory->getList()	JROOT/modules/mod_jbzoo_category/helper.php:146
15	JBModuleHelperCategory->_getCategories()	JROOT/modules/mod_jbzoo_category/helper.php:58
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 1.55 ms После последнего запроса: 0.19 ms Память запроса: 0.124 MB. Память перед запросом: 8.922 MB Возвращено строк: 26

SELECT * 
  FROM xsd8v_zoo_category 
  WHERE id IN (26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,51,42,43,44,45,46,47,48,49,50) 
  ORDER BY ordering ASC

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
21	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
20	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
19	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
18	AppTable->all()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.category.php:169
17	JBModelCategory->getZooCatsByIds()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.category.php:145
16	JBModelCategory->getList()	JROOT/modules/mod_jbzoo_category/helper.php:146
15	JBModuleHelperCategory->_getCategories()	JROOT/modules/mod_jbzoo_category/helper.php:58
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 2.28 ms После последнего запроса: 1.19 ms Память запроса: 0.025 MB. Память перед запросом: 9.027 MB Возвращено строк: 21

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 26 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	22	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 2.40 ms После последнего запроса: 0.40 ms Память запроса: 0.025 MB. Память перед запросом: 9.038 MB Возвращено строк: 22

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 27 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	22	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.93 ms После последнего запроса: 0.43 ms Память запроса: 0.025 MB. Память перед запросом: 9.048 MB Возвращено строк: 24

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 28 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	24	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.65 ms После последнего запроса: 0.35 ms Память запроса: 0.024 MB. Память перед запросом: 9.058 MB Возвращено строк: 6

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 29 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	6	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 4.43 ms После последнего запроса: 0.28 ms Память запроса: 0.024 MB. Память перед запросом: 9.068 MB Возвращено строк: 8

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 30 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	8	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.75 ms После последнего запроса: 0.38 ms Память запроса: 0.024 MB. Память перед запросом: 9.079 MB Возвращено строк: 4

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 31 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	4	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 2.12 ms После последнего запроса: 0.33 ms Память запроса: 0.040 MB. Память перед запросом: 9.089 MB Возвращено строк: 288

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 32 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	290	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.54 ms После последнего запроса: 0.26 ms Память запроса: 0.025 MB. Память перед запросом: 9.099 MB Возвращено строк: 9

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 33 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	9	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 2.99 ms После последнего запроса: 0.27 ms Память запроса: 0.040 MB. Память перед запросом: 9.109 MB Возвращено строк: 456

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 34 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	456	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 1.28 ms После последнего запроса: 0.32 ms Память запроса: 0.029 MB. Память перед запросом: 9.120 MB Возвращено строк: 131

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 35 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	132	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 1.30 ms После последнего запроса: 0.32 ms Память запроса: 0.024 MB. Память перед запросом: 9.130 MB Возвращено строк: 2

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 36 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	2	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.56 ms После последнего запроса: 0.22 ms Память запроса: 0.024 MB. Память перед запросом: 9.140 MB Возвращено строк: 5

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 37 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	5	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 3.71 ms После последнего запроса: 0.25 ms Память запроса: 0.048 MB. Память перед запросом: 9.151 MB Возвращено строк: 557

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 38 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	558	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 5.07 ms После последнего запроса: 0.33 ms Память запроса: 0.029 MB. Память перед запросом: 9.161 MB Возвращено строк: 153

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 39 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	153	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 3.08 ms После последнего запроса: 0.47 ms Память запроса: 0.040 MB. Память перед запросом: 9.172 MB Возвращено строк: 426

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 40 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	426	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.84 ms После последнего запроса: 0.39 ms Память запроса: 0.025 MB. Память перед запросом: 9.182 MB Возвращено строк: 12

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 41 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	12	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.63 ms После последнего запроса: 0.31 ms Память запроса: 0.025 MB. Память перед запросом: 9.192 MB Возвращено строк: 10

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 51 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	10	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.56 ms После последнего запроса: 0.26 ms Память запроса: 0.024 MB. Память перед запросом: 9.203 MB Возвращено строк: 5

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 42 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	5	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 1.03 ms После последнего запроса: 0.23 ms Память запроса: 0.028 MB. Память перед запросом: 9.213 MB Возвращено строк: 111

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 43 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	111	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.73 ms После последнего запроса: 0.28 ms Память запроса: 0.025 MB. Память перед запросом: 9.223 MB Возвращено строк: 31

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 44 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	31	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.56 ms После последнего запроса: 0.23 ms Память запроса: 0.025 MB. Память перед запросом: 9.233 MB Возвращено строк: 11

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 45 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	11	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 2.02 ms После последнего запроса: 0.23 ms Память запроса: 0.040 MB. Память перед запросом: 9.244 MB Возвращено строк: 279

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 46 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	280	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 3.84 ms После последнего запроса: 0.26 ms Память запроса: 0.024 MB. Память перед запросом: 9.254 MB Возвращено строк: 7

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 47 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	7	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.98 ms После последнего запроса: 0.29 ms Память запроса: 0.026 MB. Память перед запросом: 9.264 MB Возвращено строк: 55

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 48 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	55	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.81 ms После последнего запроса: 0.28 ms Память запроса: 0.025 MB. Память перед запросом: 9.274 MB Возвращено строк: 38

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 49 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	38	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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.56 ms После последнего запроса: 0.24 ms Память запроса: 0.030 MB. Память перед запросом: 9.294 MB Возвращено строк: 7

SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 50 
  AND a.access IN (1,5) 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-12 00:31:23') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-12 00:31:23') 
  GROUP BY a.id

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	CATEGORYID_INDEX	4	const	7	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX	PRIMARY	4	user_sply.b.item_id	1	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:672
15	ItemTable->getItemCountFromCategory()	JROOT/modules/mod_jbzoo_category/helper.php:82
14	JBModuleHelperCategory->getCategories()	JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php:21
13	include JROOT/templates/supplym/html/mod_jbzoo_category/bootstrap.php	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:256
12	JBModuleHelper->partial()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbmodulehelper.php:225
11	JBModuleHelper->render()	JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.php:28
10	include JROOT/modules/mod_jbzoo_category/mod_jbzoo_category.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 для получения ссылок на файлы]

Время запроса: 7.98 ms После последнего запроса: 189.44 ms Память запроса: 0.021 MB. Память перед запросом: 9.737 MB Возвращено строк: 1

SELECT manifest_cache

  FROM xsd8v_extensions

  WHERE type='component' 
  AND element='com_baforms'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:668
10	baformsHelper::aboutUs()	JROOT/components/com_baforms/helpers/baforms.php:566
9	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:56
8	plgSystemBaforms->setForms()	JROOT/plugins/system/baforms/baforms.php:35
7	plgSystemBaforms->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 для получения ссылок на файлы]

Время запроса: 4.33 ms После последнего запроса: 0.53 ms Память запроса: 0.021 MB. Память перед запросом: 9.744 MB Возвращено строк: 1

SELECT `key`

  FROM xsd8v_baforms_api

  WHERE service = 'balbooa_activation'

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

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

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:653
10	baformsHelper::checkFormsActivation()	JROOT/components/com_baforms/helpers/baforms.php:567
9	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:56
8	plgSystemBaforms->setForms()	JROOT/plugins/system/baforms/baforms.php:35
7	plgSystemBaforms->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 для получения ссылок на файлы]

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

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

26 × SELECT a.id 
  FROM xsd8v_zoo_item AS a 
  LEFT JOIN xsd8v_zoo_category_item AS b 
  ON a.id = b.item_id

```
4 × SELECT * 
  FROM xsd8v_zoo_item
```

3 × SELECT t.parent_id 
  FROM xsd8v_menu as t

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `xsd8v_assets`

2 × SELECT a.params 
  FROM xsd8v_advancedmodules AS a

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 xsd8v_fields AS a 
  LEFT JOIN `xsd8v_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN xsd8v_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN xsd8v_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN xsd8v_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN xsd8v_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT `ip`,`reason` 
  FROM xsd8v_rsfirewall_lists

2 × SELECT * 
  FROM xsd8v_zoo_category

2 × SELECT * 
  FROM xsd8v_zoo_application

1 × SELECT manifest_cache 
  FROM xsd8v_extensions

1 × SELECT tCategory.id 
  FROM xsd8v_zoo_category AS tCategory

1 × SELECT tItem.id 
  FROM xsd8v_zoo_item AS tItem

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM xsd8v_modules AS m 
  LEFT JOIN xsd8v_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN xsd8v_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT id, title, module, position, content, showtitle, params, published 
  FROM xsd8v_modules AS m 
  LEFT JOIN xsd8v_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT `session_id` 
  FROM `xsd8v_session`

1 × SELECT id, rules 
  FROM `xsd8v_viewlevels

1 × SELECT * 
  FROM xsd8v_rsfirewall_exceptions

1 × SELECT * 
  FROM xsd8v_rsfirewall_snapshots

1 × SELECT * 
  FROM xsd8v_rsfirewall_hashes

```
1 × SELECT id 
  FROM xsd8v_zoo_item
```

1 × SELECT CONCAT_WS(".", `
  group`, `key`) as group_key,   `value`,   `type` 
  FROM xsd8v_zoo_jbzoo_config 
  LIMIT 100

1 × SELECT `params` 
  FROM `xsd8v_extensions`

1 × SELECT * 
  FROM xsd8v_rsfirewall_configuratio

1 × SELECT `file` 
  FROM xsd8v_rsfirewall_hashes

1 × SELECT `path` 
  FROM xsd8v_rsfirewall_ignored

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

1 × SELECT `key` 
  FROM xsd8v_baforms_api

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

1 × SHOW FULL COLUMNS 
  FROM `xsd8v_rsfirewall_logs

1 × CREATE TABLE IF NOT EXISTS `xsd8v_zoo_jbzoo_config` (`
  group` VARCHAR(150) NULL DEFAULT NULL,  `key` VARCHAR(100) NULL DEFAULT NULL,  `value` TEXT NULL,  `type` VARCHAR(10) NULL DEFAULT 'string',  UNIQUE INDEX `group_key` (`
  group`, `key`),  INDEX `
  group` (`
  group`),  INDEX `key` (`key`)) COLLATE='utf8_general_ci' ENGINE=MyISAM

1 × UPDATE `xsd8v_extensions` 
  SET `params` = '{\"mediaversion\":\"544a80b7878d741d52a9dca417107305\"}'

1 × UPDATE xsd8v_zoo_item 
  SET hits = (hits + 1)

#	Вызывающий объект	Файл и номер строки
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

#	Вызывающий объект	Файл и номер строки
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

#	Вызывающий объект	Файл и номер строки
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

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:56
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:41
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:63
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:22
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:164
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:41
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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

Категории

Моторное масло Total Classic 9 С2 5W-30