р.п. Шилово, ул. Липаткина, дом 41

Профилактика гриппа и ОРВИ

Роспотребнадзор напоминает!

Для профилактики гриппа и ОРВИ необходимо пройти вакцинацию!
Вакцинация - надежная защита от инфекционных заболеваний!

Информационный материал

< Назад Вперёд >

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

Сессия

{"__default":{"session":{"counter":3,"timer":{"start":1757767610,"last":1757767610,"now":1757767611},"token":"14VMhtu6aHazdeBWUiNxBCU0OHONmKMd"},"registry":{"separator":"."},"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}}}

Результаты профилирования

Время

Память

Время: 10.74 ms / 10.74 ms Память: 0.985 MB / 1.60 MB Application: afterLoad

Время: 53.71 ms / 64.45 ms Память: 1.629 MB / 3.22 MB Application: afterInitialise

Время: 21.86 ms / 86.31 ms Память: 0.960 MB / 4.18 MB Application: afterRoute

Время: 8.43 ms / 94.74 ms Память: 0.165 MB / 4.35 MB Application: beforeRenderComponent com_zoo

Время: 15.30 ms / 110.04 ms Память: 0.636 MB / 4.99 MB Application: Before Access::preloadComponents (all components)

Время: 1.84 ms / 111.87 ms Память: 0.094 MB / 5.08 MB Application: After Access::preloadComponents (all components)

Время: 0.11 ms / 111.99 ms Память: 0.000 MB / 5.07 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.66 ms / 112.65 ms Память: 0.022 MB / 5.10 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 22.36 ms / 135.01 ms Память: 1.317 MB / 6.41 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.09 ms / 135.10 ms Память: 0.002 MB / 6.42 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 5.45 ms / 140.55 ms Память: 0.298 MB / 6.71 MB Application: Before Access::preloadPermissions (com_zoo)

Время: 1.57 ms / 142.12 ms Память: 0.070 MB / 6.78 MB Application: After Access::preloadPermissions (com_zoo)

Время: 0.08 ms / 142.20 ms Память: 0.000 MB / 6.78 MB Application: Before Access::getAssetRules (id:76 name:com_zoo.application.2.novost)

Время: 0.26 ms / 142.46 ms Память: 0.014 MB / 6.80 MB Application: After Access::getAssetRules (id:76 name:com_zoo.application.2.novost)

Время: 70.25 ms / 212.71 ms Память: 1.348 MB / 8.14 MB Application: Before Access::getAssetRules (id:74 name:com_zoo.application.2)

Время: 0.32 ms / 213.03 ms Память: 0.013 MB / 8.16 MB Application: After Access::getAssetRules (id:74 name:com_zoo.application.2)

Время: 2.47 ms / 215.50 ms Память: 0.000 MB / 8.13 MB Application: afterRenderComponent com_zoo

Время: 2.08 ms / 217.58 ms Память: 0.025 MB / 8.16 MB Application: afterDispatch

Время: 8.15 ms / 225.74 ms Память: 0.131 MB / 8.29 MB Application: beforeRenderModule mod_custom (Контакты (ФУТЕР))

Время: 2.19 ms / 227.93 ms Память: 0.013 MB / 8.30 MB Application: afterRenderModule mod_custom (Контакты (ФУТЕР))

Время: 0.33 ms / 228.26 ms Память: 0.000 MB / 8.30 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Время: 2.97 ms / 231.23 ms Память: 0.027 MB / 8.32 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Время: 0.22 ms / 231.46 ms Память: 0.000 MB / 8.32 MB Application: beforeRenderModule mod_menu (Main Menu)

Время: 9.19 ms / 240.65 ms Память: 0.113 MB / 8.43 MB Application: afterRenderModule mod_menu (Main Menu)

Время: 0.18 ms / 240.83 ms Память: 0.000 MB / 8.42 MB Application: beforeRenderModule mod_custom (Контакты (шапка))

Время: 0.30 ms / 241.13 ms Память: 0.008 MB / 8.43 MB Application: afterRenderModule mod_custom (Контакты (шапка))

Время: 0.21 ms / 241.34 ms Память: 0.000 MB / 8.42 MB Application: beforeRenderModule mod_custom (Логотип (шапка))

Время: 0.28 ms / 241.61 ms Память: 0.008 MB / 8.43 MB Application: afterRenderModule mod_custom (Логотип (шапка))

Время: 3.30 ms / 244.91 ms Память: 0.063 MB / 8.50 MB Application: afterRender

Всего SQL-запросов: 56.16 ms

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

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

29 SQL-запросов зафиксировано 56.16 ms

Время запроса: 0.68 ms Память запроса: 0.014 MB Память до запроса: 2.278 MB Выбрано строк: 1

SELECT `session_id`

  FROM `dpt6b_session`

  WHERE `session_id` = X'36753032376f6b7139756f686c38326d63756f35727062393332' 
  LIMIT 1

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = X'36753032376f6b71' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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 для получения ссылок на файлы]

Время запроса: 1.01 ms После последнего запроса: 1.99 ms Память запроса: 0.021 MB Память до запроса: 2.389 MB Выбрано строк: 37

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

  FROM `dpt6b_extensions`

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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `dpt' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\{closure}()	Так же, как вызов в строке ниже.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.41 ms После последнего запроса: 1.94 ms Память запроса: 0.015 MB Память до запроса: 2.462 MB Выбрано строк: 5

SELECT id, rules

  FROM `dpt6b_viewlevels`

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.56 ms После последнего запроса: 0.37 ms Память запроса: 0.016 MB Память до запроса: 2.491 MB Выбрано строк: 2

SELECT b.id

  FROM dpt6b_usergroups AS a

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

  WHERE a.id = 9

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft ' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.52 ms После последнего запроса: 0.57 ms Память запроса: 0.019 MB Память до запроса: 2.552 MB Выбрано строк: 85

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

  FROM dpt6b_extensions

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

  ORDER BY ordering

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id' at line 1

Профилирование SQL-запросов

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

Стек вызовов

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

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

Время запроса: 2.07 ms После последнего запроса: 31.48 ms Память запроса: 0.037 MB Память до запроса: 3.337 MB Выбрано строк: 57

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

  FROM dpt6b_menu AS m

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

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

  ORDER BY m.lft

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\{closure}()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.89 ms После последнего запроса: 16.67 ms Память запроса: 0.019 MB Память до запроса: 4.154 MB Выбрано строк: 1

SELECT id 
  FROM dpt6b_zoo_item 
  WHERE alias = 'profilaktika-grippa-i-orvi-2' 
  LIMIT 1

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM #__zoo_item WHERE alias = 'profilaktika-grippa-i-orvi-2' LIMIT' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
12	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:119
11	AppAlias->translateAliasToID()	JROOT/components/com_zoo/router.php:263
10	ZooParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.75 ms После последнего запроса: 1.55 ms Память запроса: 0.020 MB Память до запроса: 4.242 MB Выбрано строк: 1

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

  FROM `dpt6b_extensions`

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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `dpt' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\{closure}()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.23 ms После последнего запроса: 0.63 ms Память запроса: 0.013 MB Память до запроса: 4.220 MB

UPDATE `dpt6b_extensions`

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

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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"c5adf220660c527ec3' at line 1

Профилирование SQL-запросов

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.11 ms
updating	0.57 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	1.11 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Стек вызовов

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

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

Время запроса: 0.56 ms После последнего запроса: 1.27 ms Память запроса: 0.015 MB Память до запроса: 4.312 MB Выбрано строк: 2

SELECT *

  FROM dpt6b_languages

  WHERE published=1

  ORDER BY ordering ASC

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.91 ms После последнего запроса: 0.79 ms Память запроса: 0.011 MB Память до запроса: 4.339 MB Выбрано строк: 4

SELECT id, home, template, s.params

  FROM dpt6b_template_styles as s

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

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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN dp' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.71 ms После последнего запроса: 6.99 ms Память запроса: 0.022 MB Память до запроса: 4.648 MB Выбрано строк: 1

SELECT * 
  FROM dpt6b_zoo_item 
  WHERE id = 974

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__zoo_item WHERE id = 974' at line 1

Профилирование SQL-запросов

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.03 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 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:397
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.48 ms После последнего запроса: 1.46 ms Память запроса: 0.021 MB Память до запроса: 4.749 MB Выбрано строк: 1

SELECT * 
  FROM dpt6b_zoo_application 
  WHERE id = 2

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__zoo_application WHERE id = 2' at line 1

Профилирование SQL-запросов

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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:397
12	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
11	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:141
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.13 ms После последнего запроса: 6.67 ms Память запроса: 0.028 MB Память до запроса: 4.997 MB Выбрано строк: 37

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

  FROM `dpt6b_assets`

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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id`,`name`,`rules`,`parent_id` FROM `#__assets` WHERE `name` IN ('roo' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
12	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
11	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:106
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.81 ms После последнего запроса: 7.58 ms Память запроса: 0.028 MB Память до запроса: 5.354 MB Выбрано строк: 2

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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__zoo_category WHERE application_id = 2 AND published = 1 ORDE' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
18	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
17	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
16	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
15	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:232
14	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
13	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
12	Application->getCategoryTree()	JROOT/administrator/components/com_zoo/helpers/route.php:295
11	RouteHelper->item()	JROOT/components/com_zoo/controllers/default.php:131
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.60 ms После последнего запроса: 1.76 ms Память запроса: 0.017 MB Память до запроса: 5.411 MB

UPDATE dpt6b_zoo_item 
  SET hits = (hits + 1) 
  WHERE id = 974

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE #__zoo_item SET hits = (hits + 1) WHERE id = 974' at line 1

Профилирование SQL-запросов

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.06 ms
updating	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:194
12	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:675
11	Item->hit()	JROOT/components/com_zoo/controllers/default.php:167
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.53 ms После последнего запроса: 0.33 ms Память запроса: 0.021 MB Память до запроса: 5.431 MB Выбрано строк: 1

SELECT id 
  FROM dpt6b_users 
  WHERE id = 450

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM #__users WHERE id = 450' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
13	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:44
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:180
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.88 ms После последнего запроса: 1.42 ms Память запроса: 0.036 MB Память до запроса: 5.520 MB Выбрано строк: 16

SHOW FULL COLUMNS 
  FROM `dpt6b_users`

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

EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `dpt6b_users`

Профилирование SQL-запросов

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	1.19 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.22 ms
preparing	0.07 ms
Creating tmp table	0.12 ms
executing	0.21 ms
checking permissions	0.15 ms
checking permissions	0.14 ms
checking permissions	0.07 ms
checking permissions	0.10 ms
checking permissions	0.07 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.17 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.12 ms
checking permissions	0.11 ms
checking permissions	0.06 ms
checking permissions	0.04 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	Так же, как вызов в строке ниже.
14	call_user_func_array()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:180
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 1.36 ms Память запроса: 0.031 MB Память до запроса: 5.602 MB Выбрано строк: 1

SELECT *

  FROM `dpt6b_users`

  WHERE `id` = 450

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__users` WHERE `id` = 450' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	Так же, как вызов в строке ниже.
14	call_user_func_array()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:180
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.50 ms После последнего запроса: 2.96 ms Память запроса: 0.028 MB Память до запроса: 6.369 MB Выбрано строк: 1

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

  FROM `dpt6b_usergroups` AS g

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

  WHERE `m`.`user_id` = 450

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `g`.`id`,`g`.`title` FROM `#__usergroups` AS g INNER JOIN `#__user_' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	Так же, как вызов в строке ниже.
14	call_user_func_array()	JROOT/administrator/components/com_zoo/framework/classes/helper.php:69
13	AppHelper->_call()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:51
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:180
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.47 ms После последнего запроса: 0.60 ms Память запроса: 0.025 MB Память до запроса: 6.389 MB Выбрано строк: 2

SELECT b.id

  FROM dpt6b_user_usergroup_map AS map

  LEFT JOIN dpt6b_usergroups AS a 
  ON a.id = map.group_id

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

  WHERE map.user_id = 450

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__user_usergroup_map AS map LEFT JOIN #__usergroups AS a' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
16	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/User/User.php:480
15	Joomla\CMS\User\User->getAuthorisedGroups()	JROOT/libraries/src/User/User.php:386
14	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
13	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
12	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
11	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:180
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.93 ms После последнего запроса: 6.10 ms Память запроса: 0.035 MB Память до запроса: 6.713 MB Выбрано строк: 26

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

  FROM `dpt6b_assets`

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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id`,`name`,`rules`,`parent_id` FROM `#__assets` WHERE `name` LIKE 'co' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
23	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
18	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
17	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
16	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
15	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
14	Item->canEdit()	JROOT/media/zoo/applications/blog/templates/news/item.php:23
13	include JROOT/media/zoo/applications/blog/templates/news/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:196
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.49 ms После последнего запроса: 10.22 ms Память запроса: 0.046 MB Память до запроса: 7.210 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 dpt6b_fields AS a

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

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

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

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

  LEFT JOIN dpt6b_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

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
29	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
28	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
27	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
26	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
25	PlgSystemFields->onContentPrepare()	Так же, как вызов в строке ниже.
24	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
21	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
20	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
19	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
18	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
17	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php:58
16	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/item.php:36
13	include JROOT/media/zoo/applications/blog/templates/news/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:196
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 18.73 ms После последнего запроса: 21.05 ms Память запроса: 0.032 MB Память до запроса: 7.944 MB Выбрано строк: 1

SELECT ROWNUM 
  FROM (SELECT @rownum:= @rownum+1 ROWNUM, id 
  FROM (SELECT @rownum:=0) r, (SELECT id 
  FROM dpt6b_zoo_item AS a 
  LEFT JOIN dpt6b_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 3 
  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-09-13 12:46:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-09-13 12:46:51') 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.created DESC) t1) t2 
  WHERE id = 974

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ROWNUM FROM (SELECT @rownum:= @rownum+1 ROWNUM, id FROM (SELECT @rownum:=' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
22	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/classes/table.php:380
21	AppTable->_queryResult()	JROOT/administrator/components/com_zoo/tables/item.php:530
20	ItemTable->getPrevNext()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
19	ElementItemPrevNext->_getAdjacentItems()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:28
18	ElementItemPrevNext->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:80
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php:76
16	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/item.php:36
13	include JROOT/media/zoo/applications/blog/templates/news/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:196
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 10.07 ms После последнего запроса: 0.83 ms Память запроса: 0.031 MB Память до запроса: 7.975 MB Выбрано строк: 2

SELECT ROWNUM, id 
  FROM (SELECT @rownum:= @rownum+1 ROWNUM, id 
  FROM (SELECT @rownum:=0) r, (SELECT id 
  FROM dpt6b_zoo_item AS a 
  LEFT JOIN dpt6b_zoo_category_item AS b 
  ON a.id = b.item_id 
  WHERE a.application_id = 2 
  AND b.category_id  = 3 
  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-09-13 12:46:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-09-13 12:46:51') 
  GROUP BY a.id 
  ORDER BY a.priority DESC, a.created DESC) t1) t2 
  WHERE ROWNUM = 347 OR ROWNUM = 349

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ROWNUM, id FROM (SELECT @rownum:= @rownum+1 ROWNUM, id FROM (SELECT @rown' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:134
21	DatabaseHelper->queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:553
20	ItemTable->getPrevNext()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
19	ElementItemPrevNext->_getAdjacentItems()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:28
18	ElementItemPrevNext->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:80
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php:76
16	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/item.php:36
13	include JROOT/media/zoo/applications/blog/templates/news/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:196
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.50 ms После последнего запроса: 0.62 ms Память запроса: 0.042 MB Память до запроса: 8.007 MB Выбрано строк: 1

SELECT * 
  FROM dpt6b_zoo_item 
  WHERE id = 975

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__zoo_item WHERE id = 975' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
24	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
23	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
22	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
21	AppTable->get()	JROOT/administrator/components/com_zoo/tables/item.php:558
20	ItemTable->getPrevNext()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
19	ElementItemPrevNext->_getAdjacentItems()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:28
18	ElementItemPrevNext->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:80
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php:76
16	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/item.php:36
13	include JROOT/media/zoo/applications/blog/templates/news/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:196
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 0.69 ms Память запроса: 0.038 MB Память до запроса: 8.052 MB Выбрано строк: 1

SELECT * 
  FROM dpt6b_zoo_item 
  WHERE id = 973

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__zoo_item WHERE id = 973' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
24	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
23	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
22	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
21	AppTable->get()	JROOT/administrator/components/com_zoo/tables/item.php:556
20	ItemTable->getPrevNext()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:46
19	ElementItemPrevNext->_getAdjacentItems()	JROOT/media/zoo/elements/itemprevnext/itemprevnext.php:28
18	ElementItemPrevNext->hasValue()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:80
17	ItemRenderer->checkPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php:76
16	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
15	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
14	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/item.php:36
13	include JROOT/media/zoo/applications/blog/templates/news/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:196
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.13 ms После последнего запроса: 7.68 ms Память запроса: 0.032 MB Память до запроса: 8.193 MB Выбрано строк: 0

SELECT * 
  FROM dpt6b_zoo_comment 
  WHERE item_id = 974 
  AND (state = 1 OR (author = '' 
  AND email = '' 
  AND user_id = '' 
  AND user_type = '')) 
  ORDER BY created ASC

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__zoo_comment WHERE item_id = 974 AND (state = 1 OR (author = ' at line 1

Профилирование SQL-запросов

Status	Duration
starting	0.21 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.23 ms
preparing	0.07 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 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:423
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/administrator/components/com_zoo/tables/comment.php:94
17	CommentTable->getCommentsForItem()	JROOT/administrator/components/com_zoo/classes/item.php:686
16	Item->getComments()	JROOT/administrator/components/com_zoo/classes/item.php:697
15	Item->getCommentTree()	JROOT/administrator/components/com_zoo/helpers/comment.php:72
14	CommentHelper->renderComments()	JROOT/media/zoo/applications/blog/templates/news/item.php:37
13	include JROOT/media/zoo/applications/blog/templates/news/item.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:196
10	DefaultController->item()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
8	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
7	Application->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.89 ms После последнего запроса: 3.65 ms Память запроса: 0.022 MB Память до запроса: 8.260 MB Выбрано строк: 9

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

  FROM dpt6b_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-09-13 12:46:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-09-13 12:46:51') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1

Профилирование SQL-запросов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Так же, как вызов в строке ниже.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
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:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/tmpl_btsrt_4/index.php:54
7	require JROOT/templates/tmpl_btsrt_4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

25 типов SQL-запросов зафиксировано, отсортировано по вхождениям

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

```
3 × SELECT * 
  FROM dpt6b_zoo_item
```

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

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

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `dpt6b_usergroups` AS g 
  INNER JOIN `dpt6b_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `dpt6b_users`
```

1 × SELECT b.id 
  FROM dpt6b_user_usergroup_map AS map 
  LEFT JOIN dpt6b_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN dpt6b_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT ROWNUM 
  FROM (SELECT @rownum:= @rownum+1 ROWNUM, id 
  FROM (SELECT @rownum:=0) r, (SELECT id 
  FROM dpt6b_zoo_item AS a 
  LEFT JOIN dpt6b_zoo_category_item AS b 
  ON a.id = b.item_id

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

1 × SELECT * 
  FROM dpt6b_zoo_comment

1 × SELECT ROWNUM, id 
  FROM (SELECT @rownum:= @rownum+1 ROWNUM, id 
  FROM (SELECT @rownum:=0) r, (SELECT id 
  FROM dpt6b_zoo_item AS a 
  LEFT JOIN dpt6b_zoo_category_item AS b 
  ON a.id = b.item_id

```
1 × SELECT id 
  FROM dpt6b_users
```

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

1 × SELECT * 
  FROM dpt6b_zoo_application

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

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

1 × SELECT id, rules 
  FROM `dpt6b_viewlevels

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

```
1 × SELECT id 
  FROM dpt6b_zoo_item
```

1 × SELECT `session_id` 
  FROM `dpt6b_session`

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

```
1 × SELECT * 
  FROM dpt6b_languages
```

1 × SELECT * 
  FROM dpt6b_zoo_category

Прочие SQL-запросы:

1 × SHOW FULL COLUMNS 
  FROM `dpt6b_users

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

1 × UPDATE `dpt6b_extensions` 
  SET `params` = '{\"mediaversion\":\"c5adf220660c527ec3c57847b7cf555a\"}'