новости

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

Время

Память

34 SQL-запросов зафиксировано 69.11 ms

1. Время запроса: 0.69 ms Память запроса: 0.014 MB Память до запроса: 2.275 MB Выбрано строк: 0

   SELECT `session_id`
   
     FROM `dpt6b_session`
   
     WHERE `session_id` = X'6163743472737538676f366c6b743370626a336e647232356c31' 
     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'6163743472737538' 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.13 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.12 ms
   executing	0.03 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.05 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 для получения ссылок на файлы]

   ---

2. Время запроса: 2.18 ms После последнего запроса: 0.36 ms Память запроса: 0.010 MB Память до запроса: 2.291 MB

   INSERT INTO `dpt6b_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6163743472737538676f366c6b743370626a336e647232356c31', 1, 1761794445, 0, '', 0)

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

   EXPLAIN не доступен для запроса: INSERT INTO `dpt6b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6163743472737538676f366c6b743370626a336e647232356c31', 1, 1761794445, 0, '', 0)

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

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.26 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	1.61 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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 для получения ссылок на файлы]

   ---

3. Время запроса: 1.37 ms После последнего запроса: 2.82 ms Память запроса: 0.021 MB Память до запроса: 2.397 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.15 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.14 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.14 ms
   preparing	0.05 ms
   executing	0.41 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.03 ms
   freeing items	0.05 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 для получения ссылок на файлы]

   ---

4. Время запроса: 0.75 ms После последнего запроса: 2.34 ms Память запроса: 0.015 MB Память до запроса: 2.471 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.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.01 ms
   statistics	0.02 ms
   preparing	0.10 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.04 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 для получения ссылок на файлы]

   ---

5. Время запроса: 0.77 ms После последнего запроса: 0.38 ms Память запроса: 0.016 MB Память до запроса: 2.500 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.06 ms
   Opening tables	0.10 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.12 ms
   preparing	0.07 ms
   executing	0.06 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

   Стек вызовов

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

   ---

6. Время запроса: 1.64 ms После последнего запроса: 0.71 ms Память запроса: 0.019 MB Память до запроса: 2.560 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.11 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.02 ms
   statistics	0.08 ms
   preparing	0.07 ms
   executing	1.00 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

   Стек вызовов

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

   ---

7. Время запроса: 2.03 ms После последнего запроса: 45.14 ms Память запроса: 0.037 MB Память до запроса: 3.345 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.17 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.16 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.20 ms
   preparing	0.07 ms
   executing	0.97 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.02 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.02 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 для получения ссылок на файлы]

   ---

8. Время запроса: 0.92 ms После последнего запроса: 20.15 ms Память запроса: 0.020 MB Память до запроса: 4.087 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.15 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.18 ms
   preparing	0.04 ms
   executing	0.09 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.03 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 для получения ссылок на файлы]

   ---

9. Время запроса: 2.19 ms После последнего запроса: 0.60 ms Память запроса: 0.013 MB Память до запроса: 4.064 MB

   UPDATE `dpt6b_extensions`
   
     SET `params` = '{\"mediaversion\":\"a1ccef4185f3b28bce13ea3c15902309\"}'
   
     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\":\"a1ccef4185f3b28bce' at line 1

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

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.11 ms
   updating	0.18 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	1.55 ms
   closing tables	0.06 ms
   freeing items	0.07 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 для получения ссылок на файлы]

   ---

10. Время запроса: 0.94 ms После последнего запроса: 1.54 ms Память запроса: 0.015 MB Память до запроса: 4.157 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.11 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.07 ms
    executing	0.17 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

    Стек вызовов

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

    ---

11. Время запроса: 1.00 ms После последнего запроса: 1.00 ms Память запроса: 0.011 MB Память до запроса: 4.184 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.11 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.11 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.20 ms
    preparing	0.05 ms
    executing	0.21 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.05 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 для получения ссылок на файлы]

    ---

12. Время запроса: 0.86 ms После последнего запроса: 9.45 ms Память запроса: 0.020 MB Память до запроса: 4.531 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.17 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.14 ms
    init	0.03 ms
    System lock	0.02 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.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    13	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    12	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:397
    11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
    10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:141
    9	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
    8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:83
    7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
    6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Время запроса: 1.56 ms После последнего запроса: 8.87 ms Память запроса: 0.030 MB Память до запроса: 4.857 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.26 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.27 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.16 ms
    preparing	0.05 ms
    executing	0.27 ms
    end	0.02 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
    14	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
    13	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:214
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

14. Время запроса: 0.28 ms После последнего запроса: 2.05 ms Память запроса: 0.021 MB Память до запроса: 5.004 MB

    
      SET SESSION group_concat_max_len = 1048576

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

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

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

    Status	Duration
    starting	0.13 ms
    Opening tables	0.03 ms
    query end	0.01 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	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/category.php:193
    15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
    14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
    13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

15. Время запроса: 4.46 ms После последнего запроса: 0.93 ms Память запроса: 0.033 MB Память до запроса: 5.041 MB Выбрано строк: 2

    SELECT c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids 
      FROM dpt6b_zoo_category as c  USE INDEX (APPLICATIONID_ID_INDEX) 
      LEFT JOIN dpt6b_zoo_category_item as ci 
      ON ci.category_id = c.id 
      LEFT JOIN dpt6b_zoo_item AS i USE INDEX (MULTI_INDEX2) 
      ON ci.item_id = i.id 
      AND i.access IN (1,5) 
      AND i.state = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-30 03:20:45') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-30 03:20:45') 
      WHERE c.application_id = 2 
      AND c.published = 1 
      GROUP BY c.id

    План 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 c.*, GROUP_CONCAT(DISTINCT i.id) as item_ids FROM #__zoo_category as c' 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.00 ms
    checking permissions	0.00 ms
    Opening tables	0.16 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.20 ms
    preparing	0.19 ms
    executing	3.40 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.09 ms
    cleaning up	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:423
    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:219
    15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:432
    14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:456
    13	Application->getCategoryTree()	JROOT/components/com_zoo/controllers/default.php:214
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

16. Время запроса: 27.91 ms После последнего запроса: 2.60 ms Память запроса: 0.038 MB Память до запроса: 5.353 MB Выбрано строк: 15

    SELECT a.* 
      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 a.access IN (1,5) 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-10-30 03:20:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-10-30 03:20:45') 
      AND b.category_id  = 3 
      GROUP BY a.id 
      ORDER BY a.priority DESC, a.created DESC 
      LIMIT 0,15

    План 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 a.* FROM #__zoo_item AS a LEFT JOIN #__zoo_category_item AS b ON a.' at line 1

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

    Status	Duration
    starting	0.17 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.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.04 ms
    Creating tmp table	0.08 ms
    executing	26.58 ms
    end	0.03 ms
    query end	0.45 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
    15	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:423
    14	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/tables/item.php:484
    13	ItemTable->getByCategory()	JROOT/components/com_zoo/controllers/default.php:234
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

17. Время запроса: 1.75 ms После последнего запроса: 23.28 ms Память запроса: 0.041 MB Память до запроса: 6.167 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.category.description' 
      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.23 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.22 ms
    init	0.03 ms
    System lock	0.03 ms
    optimizing	0.06 ms
    statistics	0.34 ms
    preparing	0.05 ms
    Creating tmp table	0.21 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.05 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    21	PlgSystemFields->onContentPrepare()	Так же, как вызов в строке ниже.
    20	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
    17	ZooHelper->triggerContentPlugins()	JROOT/administrator/components/com_zoo/classes/category.php:534
    16	Category->getText()	JROOT/media/zoo/applications/blog/templates/news/category.php:58
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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. Время запроса: 1.52 ms После последнего запроса: 35.67 ms Память запроса: 0.042 MB Память до запроса: 7.514 MB Выбрано строк: 3

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1361 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1361 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' at line 1

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

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

19. Время запроса: 1.32 ms После последнего запроса: 5.63 ms Память запроса: 0.054 MB Память до запроса: 7.626 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.21 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.13 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.37 ms
    preparing	0.05 ms
    Creating tmp table	0.09 ms
    executing	0.10 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    36	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    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:187
    33	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    32	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    31	PlgSystemFields->onContentPrepare()	Так же, как вызов в строке ниже.
    30	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    29	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    28	JEventDispatcher->trigger()	JROOT/administrator/components/com_zoo/helpers/zoo.php:197
    27	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
    26	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:39
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

20. Время запроса: 0.89 ms После последнего запроса: 4.03 ms Память запроса: 0.042 MB Память до запроса: 7.670 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1360 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1360 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.11 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

21. Время запроса: 0.74 ms После последнего запроса: 4.81 ms Память запроса: 0.042 MB Память до запроса: 7.720 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1359 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1359 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

22. Время запроса: 0.64 ms После последнего запроса: 4.77 ms Память запроса: 0.042 MB Память до запроса: 7.769 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1358 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1358 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

23. Время запроса: 0.94 ms После последнего запроса: 6.25 ms Память запроса: 0.042 MB Память до запроса: 7.819 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1357 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1357 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.22 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.10 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

24. Время запроса: 0.78 ms После последнего запроса: 6.40 ms Память запроса: 0.042 MB Память до запроса: 7.872 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1356 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1356 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	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.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

25. Время запроса: 1.02 ms После последнего запроса: 6.08 ms Память запроса: 0.042 MB Память до запроса: 7.922 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1353 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1353 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.15 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.06 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

26. Время запроса: 0.81 ms После последнего запроса: 6.52 ms Память запроса: 0.042 MB Память до запроса: 7.972 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1352 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1352 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.00 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.08 ms
    preparing	0.05 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.06 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

27. Время запроса: 0.84 ms После последнего запроса: 6.05 ms Память запроса: 0.042 MB Память до запроса: 8.022 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1351 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1351 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.13 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

28. Время запроса: 0.81 ms После последнего запроса: 4.35 ms Память запроса: 0.042 MB Память до запроса: 8.072 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1350 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1350 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.06 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.05 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

29. Время запроса: 1.53 ms После последнего запроса: 4.64 ms Память запроса: 0.042 MB Память до запроса: 8.122 MB Выбрано строк: 3

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1349 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1349 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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.00 ms
    checking permissions	0.01 ms
    Opening tables	0.19 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.17 ms
    preparing	0.10 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.03 ms
    executing	0.11 ms
    end	0.02 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

30. Время запроса: 0.91 ms После последнего запроса: 4.47 ms Память запроса: 0.042 MB Память до запроса: 8.171 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1348 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1348 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' at line 1

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

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

31. Время запроса: 1.00 ms После последнего запроса: 4.30 ms Память запроса: 0.042 MB Память до запроса: 8.221 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1347 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1347 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' 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.00 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.04 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.03 ms
    executing	0.09 ms
    end	0.07 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

32. Время запроса: 1.02 ms После последнего запроса: 4.37 ms Память запроса: 0.042 MB Память до запроса: 8.272 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1346 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1346 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' at line 1

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

    Status	Duration
    starting	0.15 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.01 ms
    Opening tables	0.19 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.04 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.10 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

33. Время запроса: 0.94 ms После последнего запроса: 4.21 ms Память запроса: 0.042 MB Память до запроса: 8.322 MB Выбрано строк: 2

    SELECT b.id 
      FROM dpt6b_zoo_category_item AS a JOIN dpt6b_zoo_category AS b 
      ON a.category_id = b.id 
      WHERE a.item_id=1345 
      AND b.published = 1 UNION SELECT 0 
      FROM dpt6b_zoo_category_item AS a 
      WHERE a.item_id=1345 
      AND a.category_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 b.id FROM #__zoo_category_item AS a JOIN #__zoo_category AS b ON a.' at line 1

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

    Status	Duration
    starting	0.21 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.01 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.04 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.06 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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    31	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
    30	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
    29	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:566
    28	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:298
    27	RouteHelper->item()	JROOT/media/zoo/elements/itemname/itemname.php:57
    26	ElementItemName->render()	JROOT/components/com_zoo/renderer/element/default.php:19
    25	include JROOT/components/com_zoo/renderer/element/default.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    24	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:150
    23	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php:33
    22	include JROOT/media/zoo/applications/blog/templates/news/renderer/item/teaser.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
    21	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:50
    20	ItemRenderer->render()	JROOT/media/zoo/applications/blog/templates/news/_item.php:18
    19	include JROOT/media/zoo/applications/blog/templates/news/_item.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    18	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/_items.php:40
    17	include JROOT/media/zoo/applications/blog/templates/news/_items.php	JROOT/administrator/components/com_zoo/framework/classes/view.php:81
    16	AppView->partial()	JROOT/media/zoo/applications/blog/templates/news/category.php:69
    15	include JROOT/media/zoo/applications/blog/templates/news/category.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_zoo/controllers/default.php:321
    12	DefaultController->category()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    11	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_zoo/controllers/default.php:57
    10	DefaultController->display()	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 для получения ссылок на файлы]

    ---

34. Время запроса: 2.11 ms После последнего запроса: 8.96 ms Память запроса: 0.022 MB Память до запроса: 8.274 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-10-30 03:20:45') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-10-30 03:20:45') 
      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.33 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.41 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.05 ms
    statistics	0.18 ms
    preparing	0.08 ms
    executing	0.68 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 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 для получения ссылок на файлы]

    ---