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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1787552439,
                "last": 1787552439,
                "now": 1787552439
            },
            "token": "ild5WkPDIcSZw4DsY0rdQAAPMId6w23O"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__sige": {
        "sigcount": null,
        "sigcountarticles": null
    },
    "__jbzoo": {
        "viewed": {
            "5611": {
                "type": "articles",
                "appId": "2"
            }
        }
    }
}

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

Время

Память

Время: 21.45 ms / 21.45 ms Память: 0.742 MB / 0.98 MB Application: afterLoad

Время: 304.43 ms / 325.88 ms Память: 10.767 MB / 11.75 MB Application: afterInitialise

Время: 78.87 ms / 404.76 ms Память: 5.250 MB / 17.00 MB Application: afterRoute

Время: 4.14 ms / 408.90 ms Память: 0.121 MB / 17.12 MB Application: beforeRenderComponent com_zoo

Время: 195.36 ms / 604.26 ms Память: 2.725 MB / 19.84 MB Application: Before JAccess::preloadComponents (all components)

Время: 1.18 ms / 605.44 ms Память: 0.104 MB / 19.95 MB Application: After JAccess::preloadComponents (all components)

Время: 0.04 ms / 605.48 ms Память: 0.000 MB / 19.94 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Время: 1.00 ms / 606.48 ms Память: 0.043 MB / 19.98 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Время: 62.98 ms / 669.46 ms Память: 2.353 MB / 22.34 MB Application: Before JAccess::preloadPermissions (com_zoo)

Время: 0.82 ms / 670.28 ms Память: 0.049 MB / 22.39 MB Application: After JAccess::preloadPermissions (com_zoo)

Время: 5.69 ms / 675.97 ms Память: 0.453 MB / 22.84 MB Application: Before JAccess::getAssetRules (id:55 name:com_zoo)

Время: 0.09 ms / 676.06 ms Память: 0.011 MB / 22.85 MB Application: After JAccess::getAssetRules (id:55 name:com_zoo)

Время: 26.14 ms / 702.20 ms Память: 1.554 MB / 24.41 MB Application: afterRenderComponent com_zoo

Время: 8.59 ms / 710.78 ms Память: 0.187 MB / 24.59 MB Application: afterDispatch

Время: 156.62 ms / 867.40 ms Память: 2.562 MB / 27.15 MB Application: beforeRenderModule mod_jbzoo_basket (Корзина (внизу плавающая))

Время: 9.17 ms / 876.57 ms Память: 0.573 MB / 27.73 MB Application: afterRenderModule mod_jbzoo_basket (Корзина (внизу плавающая))

Время: 3.29 ms / 879.86 ms Память: 0.020 MB / 27.75 MB Application: beforeRenderModule mod_zoocategory (пример)

Время: 8.04 ms / 887.90 ms Память: 0.155 MB / 27.90 MB Application: afterRenderModule mod_zoocategory (пример)

Время: 0.66 ms / 888.56 ms Память: 0.000 MB / 27.89 MB Application: beforeRenderModule mod_jshopping_filters (Фільтр )

Время: 3.13 ms / 891.69 ms Память: 0.012 MB / 27.91 MB Application: afterRenderModule mod_jshopping_filters (Фільтр )

Время: 36.76 ms / 928.45 ms Память: 0.015 MB / 27.92 MB Application: afterRender

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

#	Вызывающий объект	Файл и номер строки
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:818
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:48

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_session	const	PRIMARY	PRIMARY	194	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:48

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:48

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

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_viewlevels	ALL	NULL	Индекс не используется	NULL	NULL	5

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:118
11	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:48
10	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
9	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:270
8	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:555
9	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:469
8	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:99
7	plgSystemAdmintools->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:337
12	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
11	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
9	plgSystemAdmintools->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_admintools_redirects	ALL	NULL	Индекс не используется	NULL	NULL	1	Using where; Используется filesort

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1753
12	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
11	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:714
10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:127
9	plgSystemAdmintools->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
17	DatabaseHelper->query()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:373
16	JBTablesHelper->createTable()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbtables.php:184
15	JBTablesHelper->checkConfig()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:53
14	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:40
13	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:51
12	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:39
11	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:93
10	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:167
9	plgSystemJBZoo->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.82 ms После последнего запроса: 2.11 ms Память запроса: 0.030 MB Память до запроса: 9.940 MB Выбрано строк: 118

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

  FROM yra1u_zoo_jbzoo_config

  LIMIT 1000

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_zoo_jbzoo_config	ALL	NULL	Индекс не используется	NULL	NULL	118

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:153
17	JBModel->_query()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:105
16	JBModel->fetchAll()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:232
15	JBModelConfig->_init()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:54
14	JBModelConfig->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.config.php:40
13	JBModelConfig::model()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:51
12	JBZooSystemPlugin->__construct()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:39
11	JBZooSystemPlugin::getInstance()	JROOT/plugins/system/jbzoo/jbzoo.php:93
10	plgSystemJBZoo->_initFramework()	JROOT/plugins/system/jbzoo/jbzoo.php:167
9	plgSystemJBZoo->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.74 ms После последнего запроса: 15.69 ms Память запроса: 0.025 MB Память до запроса: 11.099 MB

UPDATE `yra1u_extensions`

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

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

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

EXPLAIN не доступен для запроса: UPDATE `yra1u_extensions` SET `params` = '{\"mediaversion\":\"a229498cdc78e1ceed1e81db644cf175\"}' WHERE `type` = 'library' AND `element` = 'joomla'

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
21	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
20	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
19	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
18	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
17	JFactory::getDocument()	Так же, как вызов в строке ниже.
16	call_user_func()	JROOT/administrator/components/com_zoo/framework/helpers/system.php:76
15	SystemHelper->__get()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbsef.php:112
14	JBSefHelper->__construct()	JROOT/administrator/components/com_zoo/framework/classes/app.php:162
13	App->loadHelper()	JROOT/administrator/components/com_zoo/framework/classes/app.php:109
12	App->getHelper()	JROOT/administrator/components/com_zoo/framework/classes/app.php:177
11	App->__get()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:65
10	JBZooSystemPlugin->onAfterInitialise()	JROOT/plugins/system/jbzoo/jbzoo.php:168
9	plgSystemJBZoo->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.72 ms После последнего запроса: 6.01 ms Память запроса: 0.013 MB Память до запроса: 11.507 MB

DELETE 

  FROM `yra1u_jhackguard_ip_filters`

  WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) 
  AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

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

EXPLAIN не доступен для запроса: DELETE FROM `yra1u_jhackguard_ip_filters` WHERE `expires` BETWEEN DATE_SUB(CURRENT_DATE, INTERVAL 36500 DAY) AND DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)

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

Status	Duration
Starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init for update	0.04 ms
Updating	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/jhackguard/jhackguard.php:156
9	PlgSystemJhackguard->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.76 ms После последнего запроса: 0.48 ms Память запроса: 0.016 MB Память до запроса: 11.525 MB Выбрано строк: 0

SELECT `state`,`rule_type`

  FROM `yra1u_jhackguard_ip_filters`

  WHERE `ip` = '216.73.217.113' 
  AND `state` = 1

  ORDER BY ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/jhackguard/jhackguard.php:358
10	PlgSystemJhackguard->ip_is()	JROOT/plugins/system/jhackguard/jhackguard.php:174
9	PlgSystemJhackguard->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

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

SELECT id 
  FROM yra1u_zoo_item 
  WHERE alias = 'ukraine' 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_zoo_item	const	ALIAS_INDEX	ALIAS_INDEX	767	const	1

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
16	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/helpers/alias.php:119
15	AppAlias->translateAliasToID()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbsef.php:472
14	JBSefHelper->_parseItemUrl()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jbsef.php:174
13	JBSefHelper->sefParseRoute()	Так же, как вызов в строке ниже.
12	call_user_func()	JROOT/administrator/components/com_zoo/framework/classes/event.php:275
11	AppEventDispatcher->notify()	JROOT/components/com_zoo/router.php:354
10	ZooParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.56 ms После последнего запроса: 78.90 ms Память запроса: 0.036 MB Память до запроса: 17.500 MB Выбрано строк: 1

SELECT * 
  FROM yra1u_zoo_item 
  WHERE id = 5611

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
11	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
10	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
9	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
8	AppTable->get()	JROOT/administrator/components/com_zoo/helpers/zoo.php:75
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

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

SELECT * 
  FROM yra1u_zoo_application 
  WHERE id = 2

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
13	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:399
12	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
11	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
10	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
9	AppTable->get()	JROOT/administrator/components/com_zoo/classes/item.php:326
8	Item->getApplication()	JROOT/administrator/components/com_zoo/helpers/zoo.php:76
7	ZooHelper->getApplication()	JROOT/components/com_zoo/zoo.php:32
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.73 ms После последнего запроса: 134.55 ms Память запроса: 0.029 MB Память до запроса: 19.850 MB Выбрано строк: 43

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

  FROM `yra1u_assets`

  WHERE `name` IN ('com_actionlogs','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','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_jch_optimize','com_jhackguard','com_joomlaupdate','com_jshopping','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_wrapper','com_xmap','com_zoo') OR `parent_id` = 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_assets	ALL	idx_asset_name,idx_parent_id	Индекс не используется	NULL	NULL	138	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
13	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
12	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:106
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.68 ms После последнего запроса: 13.18 ms Память запроса: 0.030 MB Память до запроса: 20.999 MB Выбрано строк: 16

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_zoo_category	ref	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	APPLICATIONID_ID_INDEX2	4	const	16	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
19	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
18	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
17	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
16	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:222
15	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
14	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
13	Application->getCategoryTree()	JROOT/administrator/components/com_zoo/helpers/route.php:295
12	RouteHelper->item()	JROOT/components/com_zoo/controllers/default.php:131
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.65 ms После последнего запроса: 3.96 ms Память запроса: 0.023 MB Память до запроса: 21.399 MB Выбрано строк: 1

SELECT b.id 
  FROM yra1u_zoo_category_item AS a JOIN yra1u_zoo_category AS b 
  ON a.category_id = b.id 
  WHERE a.item_id=5611 
  AND b.published = 1 UNION SELECT 0 
  FROM yra1u_zoo_category_item AS a 
  WHERE a.item_id=5611 
  AND a.category_id = 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX	ITEMID_INDEX	4	const	1
1	PRIMARY	b	eq_ref	PRIMARY,PUBLISHED_INDEX	PRIMARY	4	dissk231_2.a.category_id	1	Using where
2	UNION	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
NULL	UNION RESULT	<union1,2>	ALL	NULL	Индекс не используется	NULL	NULL	NULL

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

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.06 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:157
15	DatabaseHelper->queryResultArray()	JROOT/administrator/components/com_zoo/helpers/category.php:63
14	CategoryHelper->getItemsRelatedCategoryIds()	JROOT/administrator/components/com_zoo/classes/item.php:561
13	Item->getRelatedCategoryIds()	JROOT/administrator/components/com_zoo/helpers/route.php:313
12	RouteHelper->item()	JROOT/components/com_zoo/controllers/default.php:131
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.41 ms После последнего запроса: 2.42 ms Память запроса: 0.019 MB Память до запроса: 21.515 MB

UPDATE yra1u_zoo_item 
  SET hits = (hits + 1) 
  WHERE id = 5611

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

EXPLAIN не доступен для запроса: UPDATE yra1u_zoo_item SET hits = (hits + 1) WHERE id = 5611

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
14	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:178
13	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:670
12	Item->hit()	JROOT/components/com_zoo/controllers/default.php:167
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.37 ms После последнего запроса: 0.29 ms Память запроса: 0.022 MB Память до запроса: 21.540 MB Выбрано строк: 0

SELECT id 
  FROM yra1u_users 
  WHERE id = 501

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:87
14	DatabaseHelper->queryResult()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:44
13	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
12	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.54 ms После последнего запроса: 42.42 ms Память запроса: 0.035 MB Память до запроса: 22.343 MB Выбрано строк: 8

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

  FROM `yra1u_assets`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_assets	ALL	idx_asset_name,idx_parent_id	Индекс не используется	NULL	NULL	138	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
24	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
23	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
22	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
20	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
19	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
18	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
17	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
16	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
15	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.87 ms После последнего запроса: 2.66 ms Память запроса: 0.041 MB Память до запроса: 22.733 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `yra1u_assets`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
27	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
26	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
25	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:311
24	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:781
23	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
22	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
20	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
19	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
18	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
17	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
16	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
15	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.46 ms После последнего запроса: 1.62 ms Память запроса: 0.035 MB Память до запроса: 22.820 MB Выбрано строк: 0

Повторяющиеся запросы: #27

SELECT *

  FROM yra1u_assets

  WHERE `name` = 'com_zoo.application.2.articles'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
24	JTable->load()	JROOT/libraries/joomla/access/access.php:782
23	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
22	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
20	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
19	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
18	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
17	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
16	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
15	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.41 ms После последнего запроса: 0.46 ms Память запроса: 0.034 MB Память до запроса: 22.865 MB Выбрано строк: 0

Повторяющиеся запросы: #26

SELECT *

  FROM yra1u_assets

  WHERE `name` = 'com_zoo.application.2.articles'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
23	JTable->load()	JROOT/libraries/joomla/access/access.php:782
22	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
21	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
19	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
18	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
17	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
16	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
15	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.66 ms После последнего запроса: 21.19 ms Память запроса: 0.052 MB Память до запроса: 24.351 MB Выбрано строк: 0

SELECT 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

  FROM yra1u_fields AS a

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

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

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

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Используется filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	dissk231_2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	dissk231_2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	dissk231_2.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	dissk231_2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	dissk231_2.a.group_id	1	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
36	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
35	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
34	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
33	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
32	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
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/libraries/cms/html/content.php:41
27	JHtmlContent::prepare()	Так же, как вызов в строке ниже.
26	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
25	JHtml::call()	JROOT/libraries/cms/html/html.php:140
24	JHtml::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
23	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
22	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
21	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
20	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
19	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/articles/full.php:48
18	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/articles/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
17	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
16	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:248
15	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:38
14	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
13	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
12	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
11	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
10	JControllerLegacy->execute()	JROOT/administrator/components/com_zoo/framework/classes/app.php:253
9	App->dispatch()	JROOT/administrator/components/com_zoo/classes/application.php:294
8	Application->dispatch()	JROOT/media/zoo/applications/jbuniversal/application.php(1) : eval()'d code:1
7	JBUniversalApplication->dispatch()	JROOT/components/com_zoo/zoo.php:33
6	require_once JROOT/components/com_zoo/zoo.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 1.08 ms После последнего запроса: 66.12 ms Память запроса: 0.030 MB Память до запроса: 25.849 MB Выбрано строк: 24

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

  FROM yra1u_modules AS m

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

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

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

  ORDER BY m.position, m.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	published,newsfeeds	published	1	const	27	Using index condition; Using where; Используется filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	dissk231_2.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	dissk231_2.m.module,const	1	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:402
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
14	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:507
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:454
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:263
8	Helix3::generatelayout()	JROOT/templates/shaper_helix3/index.php:179
7	require JROOT/templates/shaper_helix3/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.55 ms После последнего запроса: 115.39 ms Память запроса: 0.023 MB Память до запроса: 27.778 MB Выбрано строк: 1

SELECT * 
  FROM yra1u_zoo_application 
  WHERE id = 1

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

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

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

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	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:399
14	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
13	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
12	ApplicationTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
11	AppTable->get()	JROOT/modules/mod_zoocategory/mod_zoocategory.php:31
10	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.65 ms После последнего запроса: 4.95 ms Память запроса: 0.028 MB Память до запроса: 27.826 MB Выбрано строк: 20

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_zoo_category	ALL	PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2	Индекс не используется	NULL	NULL	68	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
17	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/framework/classes/table.php:425
16	AppTable->_queryObjectList()	JROOT/administrator/components/com_zoo/framework/classes/table.php:192
15	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:165
14	AppTable->all()	JROOT/administrator/components/com_zoo/tables/category.php:222
13	CategoryTable->getAll()	JROOT/administrator/components/com_zoo/classes/application.php:425
12	Application->getCategories()	JROOT/administrator/components/com_zoo/classes/application.php:449
11	Application->getCategoryTree()	JROOT/modules/mod_zoocategory/mod_zoocategory.php:36
10	include JROOT/modules/mod_zoocategory/mod_zoocategory.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.50 ms После последнего запроса: 28.20 ms Память запроса: 0.021 MB Память до запроса: 27.758 MB Выбрано строк: 3

SELECT id, alias, name, application_group

  FROM yra1u_zoo_application

  ORDER BY name

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_zoo_application	ALL	NULL	Индекс не используется	NULL	NULL	3	Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.php:153
13	JBModel->_query()	JROOT/media/zoo/applications/jbuniversal/framework/models/jbmodel.app.php:55
12	JBModelApp->getSimpleList()	JROOT/media/zoo/applications/jbuniversal/framework/jbzoo.php(1) : eval()'d code:1
11	JBZoo->getAdminMenu()	JROOT/media/zoo/applications/jbuniversal/framework/classes/jbadminmenu.php:31
10	JBAdminMenu::render()	JROOT/media/zoo/applications/jbuniversal/framework/events/jsystem.php:100
9	JBZooSystemPlugin->onAfterRender()	JROOT/plugins/system/jbzoo/jbzoo.php:209
8	plgSystemJBZoo->onAfterRender()	Так же, как вызов в строке ниже.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:51

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

Время запроса: 0.36 ms После последнего запроса: 11.08 ms Память запроса: 0.014 MB Память до запроса: 27.935 MB Выбрано строк: 0

SELECT `name`,`regex`,`replacement`

  FROM `yra1u_jhackguard_output_filters`

  WHERE `state` = 1

  ORDER BY ordering ASC

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jhackguard/jhackguard.php:91
8	PlgSystemJhackguard->onAfterRender()	Так же, как вызов в строке ниже.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:51

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

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

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

```
2 × SELECT * 
  FROM yra1u_assets
```

2 × SELECT * 
  FROM yra1u_zoo_application

2 × SELECT * 
  FROM yra1u_zoo_category

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

```
1 × SELECT id 
  FROM yra1u_users
```

1 × SELECT b.id 
  FROM yra1u_zoo_category_item AS a JOIN yra1u_zoo_category AS b 
  ON a.category_id = b.id

1 × SELECT 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 
  FROM yra1u_fields AS a 
  LEFT JOIN `yra1u_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN yra1u_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN yra1u_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN yra1u_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN yra1u_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `name`,`regex`,`replacement` 
  FROM `yra1u_jhackguard_output_filters`

1 × SELECT id, alias, name, application_group 
  FROM yra1u_zoo_application

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

```
1 × SELECT * 
  FROM yra1u_zoo_item
```

1 × SELECT `value` 
  FROM `yra1u_admintools_storage`

1 × SELECT id, rules 
  FROM `yra1u_viewlevels

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

1 × SELECT `session_id` 
  FROM `yra1u_session`

1 × SELECT * 
  FROM `yra1u_admintools_wafexceptions`

1 × SELECT `source`,`keepurlparams` 
  FROM `yra1u_admintools_redirects`

```
1 × SELECT id 
  FROM yra1u_zoo_item
```

1 × SELECT `state`,`rule_type` 
  FROM `yra1u_jhackguard_ip_filters`

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

1 × SELECT `data` 
  FROM `yra1u_session`

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

1 × DELETE  
  FROM `yra1u_jhackguard_ip_filters`

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

1 × SHOW FULL COLUMNS 
  FROM `yra1u_assets

1 × UPDATE `yra1u_extensions` 
  SET `params` = '{\"mediaversion\":\"a229498cdc78e1ceed1e81db644cf175\"}'

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

1 × INSERT INTO `yra1u_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('56qavqtvia5j7sp903k3tq48b0', 1, '1787552439', 0, '', 0

1 × SHOW VARIABLES LIKE "collation_database

```
1 × DELETE  
  FROM `yra1u_session`
```

Меблі корпусні

Стандартні меблі

Двері

Вікна, Балкони

Дизайн ремонт

Дивани, куточки, крісла

Мобільне меню

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

Сессия

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

Время

Память

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

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

33 SQL-запросов зафиксировано 21.28 ms

2 повторяющийся запрос!

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

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

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