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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1765416661,
                "last": 1765416661,
                "now": 1765416661
            },
            "token": "5zS7QGEx55YKGftpWtAjRuIUFJX9hSfQ"
        },
        "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": {
            "1535": {
                "type": "maslo",
                "appId": "2"
            }
        }
    }
}

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

Время

Память

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

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

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

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

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

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

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

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

Время: 221.58 ms / 1287.74 ms Память: 0.294 MB / 4.67 MB Application: Before Access::getAssetRules (id:1 name:root.1)

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

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

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

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

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

Время: 1110.77 ms / 2497.58 ms Память: 1.603 MB / 7.07 MB Application: beforeRenderModule mod_custom (Оферта)

Время: 96.99 ms / 2594.56 ms Память: 0.189 MB / 7.26 MB Application: afterRenderModule mod_custom (Оферта)

Время: 23.01 ms / 2617.58 ms Память: -0.015 MB / 7.25 MB Application: afterRenderComponent com_zoo

Время: 56.50 ms / 2674.08 ms Память: 0.010 MB / 7.26 MB Application: afterDispatch

Время: 365.05 ms / 3039.14 ms Память: 1.746 MB / 9.00 MB Application: beforeRenderModule mod_jbzoo_item (Просмотренные товары)

Время: 26.19 ms / 3065.32 ms Память: 0.033 MB / 9.04 MB Application: afterRenderModule mod_jbzoo_item (Просмотренные товары)

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

Время: 151.15 ms / 3216.62 ms Память: 0.396 MB / 9.42 MB Application: afterRenderModule mod_jbzoo_category (Категории)

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

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

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

Время: 8.67 ms / 3306.14 ms Память: 0.015 MB / 9.67 MB Application: afterRenderModule mod_breadcrumbs (Хлебные крошки)

Время: 217.48 ms / 3523.62 ms Память: 0.463 MB / 10.13 MB Application: afterRender

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

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

Профиль

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 for update	0.03 ms
Update	0.10 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.59 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 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.01 ms

Стек вызовов

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

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

Время запроса: 0.57 ms После последнего запроса: 10.13 ms Память запроса: 0.021 MB. Память перед запросом: 1.110 MB Возвращено строк: 5

SELECT id, rules

  FROM `xsd8v_viewlevels`

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

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

Профиль

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.02 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.45 ms После последнего запроса: 0.10 ms Память запроса: 0.021 MB. Память перед запросом: 1.122 MB Возвращено строк: 2

SELECT b.id

  FROM xsd8v_usergroups AS a

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

  WHERE a.id = 9

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

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

Профиль

Status	Duration
Starting	0.06 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.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 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.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `path`

  FROM xsd8v_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

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

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

Профиль

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 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.00 ms

Стек вызовов

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

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

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

SELECT `file`

  FROM xsd8v_rsfirewall_hashes

  WHERE `type`='protect'

План запросов (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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.19 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.04 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: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

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

Время запроса: 1.04 ms После последнего запроса: 0.11 ms Память запроса: 0.025 MB. Память перед запросом: 1.479 MB Возвращено строк: 64

SELECT *

  FROM xsd8v_rsfirewall_configuration

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

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

Профиль

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.04 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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:71
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

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

Время запроса: 0.94 ms После последнего запроса: 16.20 ms Память запроса: 0.024 MB. Память перед запросом: 1.701 MB Возвращено строк: 10

SHOW FULL COLUMNS 
  FROM `xsd8v_rsfirewall_logs`

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

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

Профиль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.00 ms
checking permissions	0.01 ms
Opening tables	0.37 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.06 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.09 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:38
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:31
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:84
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:63
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

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

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

SELECT `params`

  FROM `xsd8v_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_jchoptimize'

План запросов (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.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.02 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 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.06 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof40/Params/Params.php:55
12	FOF40\Params\Params->reload()	JROOT/libraries/fof40/Params/Params.php:40
11	FOF40\Params\Params->__construct()	JROOT/libraries/fof40/Container/Container.php:281
10	FOF40\Container\Container->FOF40\Container\{closure}()	JROOT/libraries/fof40/Pimple/Container.php:115
9	FOF40\Pimple\Container->offsetGet()	JROOT/libraries/fof40/Container/ContainerBase.php:27
8	FOF40\Container\ContainerBase->__get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:123
7	plgSystemJchoptimize->__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

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

Время запроса: 7.55 ms После последнего запроса: 330.93 ms Память запроса: 0.008 MB. Память перед запросом: 2.728 MB

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;

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

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.18 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
closing tables	0.01 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.03 ms
Reset for next command	0.00 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.99 ms После последнего запроса: 0.69 ms Память запроса: 0.049 MB. Память перед запросом: 2.737 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.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.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.27 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.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.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 для получения ссылок на файлы]

Время запроса: 6.43 ms После последнего запроса: 50.09 ms Память запроса: 0.009 MB. Память перед запросом: 2.928 MB

UPDATE `xsd8v_extensions`

  SET `params` = '{\"mediaversion\":\"3d09aaf7834ade352c787890a943a392\"}'

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

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

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

Профиль

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.00 ms
table lock	0.01 ms
init for update	0.13 ms
Updating	0.05 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.04 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

Стек вызовов

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

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

SELECT id 
  FROM xsd8v_zoo_item 
  WHERE alias = 'motornoe-maslo-m-10dm' 
  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.09 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.03 ms
Optimizing	0.01 ms
Statistics	0.08 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.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 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 для получения ссылок на файлы]

Время запроса: 1.02 ms После последнего запроса: 0.28 ms Память запроса: 0.021 MB. Память перед запросом: 3.468 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.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.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.39 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.03 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

Стек вызовов

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

Время запроса: 10.27 ms После последнего запроса: 2.02 ms Память запроса: 0.021 MB. Память перед запросом: 3.477 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.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.04 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 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.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 для получения ссылок на файлы]

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

SELECT `ip`,`reason`

  FROM xsd8v_rsfirewall_lists

  WHERE (`ip`='216.73.216.6' 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.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.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.03 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.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

Стек вызовов

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

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

SELECT `ip`,`reason`

  FROM xsd8v_rsfirewall_lists

  WHERE (`ip`='216.73.216.6' 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.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.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 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.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

Стек вызовов

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

Время запроса: 3.74 ms После последнего запроса: 0.27 ms Память запроса: 0.021 MB. Память перед запросом: 3.497 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.09 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.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.94 ms После последнего запроса: 1.43 ms Память запроса: 0.028 MB. Память перед запросом: 3.504 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.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.32 ms
End of update loop	0.01 ms
Query end	0.02 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.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/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 для получения ссылок на файлы]

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 1535

План запросов (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.06 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 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.03 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

Стек вызовов

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

Время запроса: 6.72 ms После последнего запроса: 1.74 ms Память запроса: 0.022 MB. Память перед запросом: 4.493 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.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.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.00 ms
Unlocking tables	0.01 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.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.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 для получения ссылок на файлы]

Время запроса: 2.48 ms После последнего запроса: 139.67 ms Память запроса: 0.123 MB. Память перед запросом: 4.706 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.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.10 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.86 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.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.01 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 для получения ссылок на файлы]

Время запроса: 3.61 ms После последнего запроса: 5.07 ms Память запроса: 0.007 MB. Память перед запросом: 4.842 MB

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

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

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

Профиль

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.00 ms
table lock	0.01 ms
init for update	0.10 ms
Updating	0.10 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.01 ms
Commit	0.49 ms
Query end	0.01 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.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 для получения ссылок на файлы]

Время запроса: 0.88 ms После последнего запроса: 66.81 ms Память запроса: 0.028 MB. Память перед запросом: 5.447 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.07 ms
checking permissions	0.01 ms
Opening tables	0.04 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.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.15 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

Стек вызовов

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

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 411

План запросов (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.04 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.09 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.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.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 для получения ссылок на файлы]

Время запроса: 2.64 ms После последнего запроса: 0.27 ms Память запроса: 0.030 MB. Память перед запросом: 5.719 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.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.03 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.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.76 ms После последнего запроса: 77.14 ms Память запроса: 0.029 MB. Память перед запросом: 6.407 MB Возвращено строк: 1

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 412

План запросов (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.13 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.04 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.03 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 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 для получения ссылок на файлы]

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 413

План запросов (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.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.04 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 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.03 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 для получения ссылок на файлы]

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4263

План запросов (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.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.10 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 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

Стек вызовов

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

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4264

План запросов (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.03 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.06 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 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 для получения ссылок на файлы]

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4265

План запросов (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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 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.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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 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 для получения ссылок на файлы]

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4407

План запросов (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.03 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.06 ms
Preparing	0.01 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.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 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 для получения ссылок на файлы]

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

SELECT * 
  FROM xsd8v_zoo_item 
  WHERE id = 4408

План запросов (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.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.04 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.01 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

Стек вызовов

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

Время запроса: 3.49 ms После последнего запроса: 56.80 ms Память запроса: 0.201 MB. Память перед запросом: 6.599 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-11 01:31:01') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-12-11 01:31:01') 
  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.14 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.90 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 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.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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 для получения ссылок на файлы]

Время запроса: 2.29 ms После последнего запроса: 978.38 ms Память запроса: 0.034 MB. Память перед запросом: 7.202 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.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.02 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.16 ms
Preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.64 ms
Creating sort index	0.12 ms
Removing tmp table	0.21 ms
Creating sort index	0.02 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.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.03 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 для получения ссылок на файлы]

Время запроса: 6.99 ms После последнего запроса: 14.90 ms Память запроса: 0.030 MB. Память перед запросом: 7.206 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.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.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

Стек вызовов

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

Время запроса: 2.40 ms После последнего запроса: 22.09 ms Память запроса: 0.033 MB. Память перед запросом: 7.250 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.18 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.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.62 ms
Creating sort index	0.07 ms
Removing tmp table	0.12 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.01 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.52 ms После последнего запроса: 72.24 ms Память запроса: 0.238 MB. Память перед запросом: 7.283 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.08 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.77 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

Стек вызовов

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

Время запроса: 0.54 ms После последнего запроса: 116.42 ms Память запроса: 0.025 MB. Память перед запросом: 7.888 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.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.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 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.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 для получения ссылок на файлы]

Время запроса: 1.53 ms После последнего запроса: 0.13 ms Память запроса: 0.025 MB. Память перед запросом: 7.898 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.04 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.02 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 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.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 для получения ссылок на файлы]

Время запроса: 0.34 ms После последнего запроса: 0.12 ms Память запроса: 0.025 MB. Память перед запросом: 7.907 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.05 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.04 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.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
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.87 ms После последнего запроса: 280.33 ms Память запроса: 0.026 MB. Память перед запросом: 9.143 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.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.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 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.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.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.65 ms После последнего запроса: 0.20 ms Память запроса: 0.124 MB. Память перед запросом: 9.167 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.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.02 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.79 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.22 ms После последнего запроса: 11.53 ms Память запроса: 0.025 MB. Память перед запросом: 9.272 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.04 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.18 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 для получения ссылок на файлы]

Время запроса: 1.96 ms После последнего запроса: 0.47 ms Память запроса: 0.025 MB. Память перед запросом: 9.283 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.12 ms
checking permissions	0.05 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.05 ms
Statistics	0.29 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.17 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 для получения ссылок на файлы]

Время запроса: 2.09 ms После последнего запроса: 1.26 ms Память запроса: 0.025 MB. Память перед запросом: 9.293 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.12 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.15 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.03 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.21 ms После последнего запроса: 0.40 ms Память запроса: 0.024 MB. Память перед запросом: 9.303 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.26 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.02 ms
Sending data	0.07 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 для получения ссылок на файлы]

Время запроса: 2.02 ms После последнего запроса: 1.75 ms Память запроса: 0.024 MB. Память перед запросом: 9.313 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.06 ms
Statistics	0.24 ms
Preparing	0.05 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.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.13 ms После последнего запроса: 0.51 ms Память запроса: 0.024 MB. Память перед запросом: 9.323 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.03 ms
Optimizing	0.03 ms
Statistics	0.22 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.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.51 ms После последнего запроса: 5.58 ms Память запроса: 0.040 MB. Память перед запросом: 9.334 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.14 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.31 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	1.53 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 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.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.19 ms После последнего запроса: 4.20 ms Память запроса: 0.025 MB. Память перед запросом: 9.344 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.05 ms
Optimizing	0.03 ms
Statistics	0.39 ms
Preparing	0.05 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.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 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 для получения ссылок на файлы]

Время запроса: 4.64 ms После последнего запроса: 1.98 ms Память запроса: 0.040 MB. Память перед запросом: 9.354 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.20 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	2.42 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.03 ms
Query end	0.01 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.04 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.17 ms После последнего запроса: 1.48 ms Память запроса: 0.029 MB. Память перед запросом: 9.365 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.03 ms
Statistics	0.20 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.89 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 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 для получения ссылок на файлы]

Время запроса: 1.20 ms После последнего запроса: 1.75 ms Память запроса: 0.024 MB. Память перед запросом: 9.375 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.18 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.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.37 ms После последнего запроса: 1.26 ms Память запроса: 0.024 MB. Память перед запросом: 9.385 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.05 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.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.34 ms После последнего запроса: 1.93 ms Память запроса: 0.048 MB. Память перед запросом: 9.395 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.56 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	3.00 ms
End of update loop	0.04 ms
Query end	0.01 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.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 для получения ссылок на файлы]

Время запроса: 1.53 ms После последнего запроса: 10.01 ms Память запроса: 0.029 MB. Память перед запросом: 9.406 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.23 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.66 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.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 для получения ссылок на файлы]

Время запроса: 3.23 ms После последнего запроса: 0.40 ms Память запроса: 0.040 MB. Память перед запросом: 9.416 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.21 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	1.40 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 для получения ссылок на файлы]

Время запроса: 4.84 ms После последнего запроса: 0.38 ms Память запроса: 0.025 MB. Память перед запросом: 9.427 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.25 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.10 ms
End of update loop	0.59 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 для получения ссылок на файлы]

Время запроса: 1.52 ms После последнего запроса: 0.34 ms Память запроса: 0.025 MB. Память перед запросом: 9.437 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.22 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.00 ms
Sending data	0.08 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.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.45 ms После последнего запроса: 11.46 ms Память запроса: 0.024 MB. Память перед запросом: 9.448 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.11 ms
checking permissions	0.02 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.21 ms
Preparing	0.03 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.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.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.60 ms После последнего запроса: 0.37 ms Память запроса: 0.028 MB. Память перед запросом: 9.458 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.04 ms
Optimizing	0.04 ms
Statistics	0.23 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.37 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.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 для получения ссылок на файлы]

Время запроса: 7.88 ms После последнего запроса: 0.52 ms Память запроса: 0.025 MB. Память перед запросом: 9.468 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.05 ms
Optimizing	0.04 ms
Statistics	0.28 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.25 ms
End of update loop	0.02 ms
Query end	0.01 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 для получения ссылок на файлы]

Время запроса: 4.38 ms После последнего запроса: 0.47 ms Память запроса: 0.025 MB. Память перед запросом: 9.478 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.14 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.05 ms
Statistics	0.25 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.12 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.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 для получения ссылок на файлы]

Время запроса: 6.57 ms После последнего запроса: 0.49 ms Память запроса: 0.045 MB. Память перед запросом: 9.498 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.05 ms
Optimizing	0.05 ms
Statistics	0.28 ms
Preparing	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	1.41 ms
End of update loop	0.06 ms
Query end	0.01 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.02 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.78 ms После последнего запроса: 0.45 ms Память запроса: 0.024 MB. Память перед запросом: 9.513 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.12 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.05 ms
Optimizing	0.04 ms
Statistics	0.23 ms
Preparing	0.04 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.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.68 ms После последнего запроса: 0.36 ms Память запроса: 0.026 MB. Память перед запросом: 9.524 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.15 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.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.99 ms После последнего запроса: 0.30 ms Память запроса: 0.025 MB. Память перед запросом: 9.534 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.17 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.87 ms После последнего запроса: 0.25 ms Память запроса: 0.024 MB. Память перед запросом: 9.544 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-11 01:31:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-11 01:31:01') 
  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.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.02 ms
Optimizing	0.02 ms
Statistics	0.16 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.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.83 ms После последнего запроса: 216.19 ms Память запроса: 0.021 MB. Память перед запросом: 10.024 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.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.09 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.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

Стек вызовов

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

Время запроса: 8.24 ms После последнего запроса: 0.65 ms Память запроса: 0.021 MB. Память перед запросом: 10.031 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.05 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.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.04 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

```
9 × 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 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 * 
  FROM xsd8v_zoo_category

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

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 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 a.params 
  FROM xsd8v_advancedmodules AS a

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 × INSERT INTO `xsd8v_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'61647166707571646833366a706f6a6936386166333070307374', 1, 1765416661, 0, '', 0

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\":\"3d09aaf7834ade352c787890a943a392\"}'

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

Категории

Моторное масло М-10ДМ