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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1779650304,
                "last": 1779650304,
                "now": 1779650304
            },
            "token": "1Nckd4WV2lflY34Wl4SOb5yO04Qkshze"
        },
        "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
        },
        "js_id_currency_orig": "1",
        "js_id_currency": "1"
    },
    "__sige": {
        "sigcount": 0,
        "sigcountarticles": 0
    },
    "__jbzoo": {
        "viewed": {
            "5613": {
                "type": "articles",
                "appId": "2"
            }
        }
    }
}

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

Время

Память

Время: 14.60 ms / 14.60 ms Память: 0.201 MB / 0.43 MB Application: afterLoad

Время: 126.89 ms / 141.49 ms Память: 4.639 MB / 5.06 MB Application: afterInitialise

Время: 39.89 ms / 181.38 ms Память: 3.308 MB / 8.37 MB Application: afterRoute

Время: 4.69 ms / 186.07 ms Память: 0.145 MB / 8.52 MB Application: beforeRenderComponent com_zoo

Время: 293.53 ms / 479.60 ms Память: 2.723 MB / 11.24 MB Application: Before JAccess::preloadComponents (all components)

Время: 1.62 ms / 481.23 ms Память: 0.106 MB / 11.35 MB Application: After JAccess::preloadComponents (all components)

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

Время: 0.86 ms / 482.13 ms Память: 0.019 MB / 11.36 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Время: 20.10 ms / 502.23 ms Память: 1.225 MB / 12.58 MB Application: Before JAccess::preloadPermissions (com_zoo)

Время: 1.45 ms / 503.69 ms Память: 0.052 MB / 12.64 MB Application: After JAccess::preloadPermissions (com_zoo)

Время: 4.25 ms / 507.93 ms Память: 0.170 MB / 12.81 MB Application: Before JAccess::getAssetRules (id:55 name:com_zoo)

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

Время: 18.52 ms / 526.67 ms Память: 0.486 MB / 13.30 MB Application: afterRenderComponent com_zoo

Время: 8.50 ms / 535.17 ms Память: 0.060 MB / 13.36 MB Application: afterDispatch

Время: 143.43 ms / 678.60 ms Память: 5.379 MB / 18.74 MB Application: beforeRenderModule mod_jbzoo_basket (Корзина (внизу плавающая))

Время: 222.74 ms / 901.35 ms Память: 0.624 MB / 19.37 MB Application: afterRenderModule mod_jbzoo_basket (Корзина (внизу плавающая))

Время: 19.82 ms / 921.16 ms Память: 0.018 MB / 19.38 MB Application: beforeRenderModule mod_zoocategory (пример)

Время: 10.24 ms / 931.40 ms Память: 0.162 MB / 19.55 MB Application: afterRenderModule mod_zoocategory (пример)

Время: 0.82 ms / 932.22 ms Память: 0.000 MB / 19.54 MB Application: beforeRenderModule mod_jshopping_filters (Фільтр )

Время: 3.52 ms / 935.74 ms Память: 0.012 MB / 19.55 MB Application: afterRenderModule mod_jshopping_filters (Фільтр )

Время: 793.70 ms / 1729.44 ms Память: 0.000 MB / 15.77 MB Application: afterRender

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

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

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

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Так же, как вызов в строке ниже.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
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	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.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.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.63 ms После последнего запроса: 0.79 ms Память запроса: 0.030 MB Память до запроса: 4.510 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.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.39 ms После последнего запроса: 9.17 ms Память запроса: 0.025 MB Память до запроса: 4.877 MB

UPDATE `yra1u_extensions`

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

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

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

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

Профилирование 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 for update	0.07 ms
Updating	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.05 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.24 ms После последнего запроса: 3.76 ms Память запроса: 0.013 MB Память до запроса: 5.011 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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.03 ms
Updating	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.23 ms После последнего запроса: 0.15 ms Память запроса: 0.016 MB Память до запроса: 5.029 MB Выбрано строк: 0

SELECT `state`,`rule_type`

  FROM `yra1u_jhackguard_ip_filters`

  WHERE `ip` = '216.73.217.14' 
  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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.79 ms После последнего запроса: 56.29 ms Память запроса: 0.023 MB Память до запроса: 8.597 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.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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:399
11	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
10	AppTable->find()	JROOT/administrator/components/com_zoo/tables/application.php:131
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/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.99 ms После последнего запроса: 281.03 ms Память запроса: 0.042 MB Память до запроса: 11.181 MB Выбрано строк: 1

SELECT * 
  FROM yra1u_zoo_item 
  WHERE id = 5613

План 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.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.00 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:399
16	AppTable->_queryObject()	JROOT/administrator/components/com_zoo/framework/classes/table.php:189
15	AppTable->find()	JROOT/administrator/components/com_zoo/framework/classes/table.php:136
14	AppTable->get()	JROOT/components/com_zoo/controllers/default.php:103
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.16 ms После последнего запроса: 0.89 ms Память запроса: 0.031 MB Память до запроса: 11.245 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.14 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.09 ms
Optimizing	0.04 ms
Statistics	0.32 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
20	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
19	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
18	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
16	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:222
15	UserAppHelper->isJoomlaSuperAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:54
14	UserAppHelper->get()	JROOT/components/com_zoo/controllers/default.php:106
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.96 ms После последнего запроса: 10.76 ms Память запроса: 0.022 MB Память до запроса: 12.210 MB

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_zoo/framework/helpers/database.php:64
16	DatabaseHelper->query()	JROOT/administrator/components/com_zoo/tables/item.php:178
15	ItemTable->hit()	JROOT/administrator/components/com_zoo/classes/item.php:670
14	Item->hit()	JROOT/components/com_zoo/controllers/default.php:167
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.39 ms После последнего запроса: 0.75 ms Память запроса: 0.024 MB Память до запроса: 12.236 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.05 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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/framework/helpers/user.php:44
15	UserAppHelper->get()	JROOT/administrator/components/com_zoo/classes/item.php:358
14	Item->getAuthor()	JROOT/components/com_zoo/controllers/default.php:181
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.17 ms После последнего запроса: 8.57 ms Память запроса: 0.037 MB Память до запроса: 12.589 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.09 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.27 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.04 ms
Query end	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
26	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
25	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
24	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
23	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
22	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
21	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
20	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
19	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
18	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
17	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
16	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
15	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
14	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.77 ms После последнего запроса: 1.12 ms Память запроса: 0.043 MB Память до запроса: 12.708 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `yra1u_assets`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
29	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
28	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
27	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:311
26	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:781
25	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
24	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
23	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
22	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
21	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
20	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
19	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
18	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
17	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
16	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
15	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
14	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.64 ms После последнего запроса: 1.40 ms Память запроса: 0.038 MB Память до запроса: 12.783 MB Выбрано строк: 0

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

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.07 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.04 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
26	JTable->load()	JROOT/libraries/joomla/access/access.php:782
25	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
24	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
23	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
22	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
21	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:360
20	UserAppHelper->isAdmin()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
19	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
18	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
17	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
16	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
15	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
14	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.63 ms После последнего запроса: 0.81 ms Память запроса: 0.037 MB Память до запроса: 12.830 MB Выбрано строк: 0

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:458
20	UserAppHelper->authorise()	JROOT/administrator/components/com_zoo/framework/helpers/user.php:290
19	UserAppHelper->canEdit()	JROOT/administrator/components/com_zoo/classes/type.php:102
18	Type->canEdit()	JROOT/administrator/components/com_zoo/classes/item.php:250
17	Item->canEdit()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:23
16	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
15	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
14	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.02 ms После последнего запроса: 12.86 ms Память запроса: 0.055 MB Память до запроса: 13.309 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.23 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.05 ms
table lock	0.02 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
37	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
36	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
35	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
34	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
33	PlgSystemFields->onContentPrepare()	Так же, как вызов в строке ниже.
32	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
31	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
30	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
29	JHtmlContent::prepare()	Так же, как вызов в строке ниже.
28	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
27	JHtml::call()	JROOT/libraries/cms/html/html.php:140
26	JHtml::_()	JROOT/administrator/components/com_zoo/helpers/zoo.php:181
25	ZooHelper->triggerContentPlugins()	JROOT/media/zoo/elements/textarea/textarea.php:146
24	ElementTextarea->render()	JROOT/components/com_zoo/renderer/element/block.php:25
23	include JROOT/components/com_zoo/renderer/element/block.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
22	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:186
21	ItemRenderer->renderPosition()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/articles/full.php:48
20	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/renderer/item/articles/full.php	JROOT/administrator/components/com_zoo/helpers/renderer.php:155
19	AppRenderer->render()	JROOT/administrator/components/com_zoo/classes/renderer/item.php:65
18	ItemRenderer->render()	JROOT/media/zoo/applications/jbuniversal/framework/helpers/jblayout.php:248
17	JBLayoutHelper->renderItem()	JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php:38
16	include JROOT/media/zoo/applications/jbuniversal/templates/bootstrap/item.php	JROOT/libraries/legacy/view/legacy.php:694
15	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
14	JViewLegacy->display()	JROOT/components/com_zoo/controllers/default.php:199
13	DefaultController->item()	JROOT/libraries/legacy/controller/legacy.php:709
12	JControllerLegacy->execute()	JROOT/components/com_zoo/controllers/default.php:57
11	DefaultController->display()	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.38 ms После последнего запроса: 38.37 ms Память запроса: 0.050 MB Память до запроса: 13.623 MB Выбрано строк: 140

SHOW FULL COLUMNS 
  FROM `yra1u_jshopping_config`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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/components/com_jshopping/tables/config.php:14
25	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
24	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
23	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
22	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
21	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
20	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/shaper_helix3/features/menu.php:34
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
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 для получения ссылок на файлы]

Время запроса: 1.14 ms После последнего запроса: 1.29 ms Память запроса: 0.073 MB Память до запроса: 14.082 MB Выбрано строк: 1

SELECT *

  FROM yra1u_jshopping_config

  WHERE `id` = '1'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/components/com_jshopping/lib/factory.php:30
24	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
23	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
22	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
21	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
20	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/shaper_helix3/features/menu.php:34
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
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.81 ms После последнего запроса: 1.54 ms Память запроса: 0.045 MB Память до запроса: 14.106 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `yra1u_jshopping_currencies`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
31	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
30	JTable->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
29	jshopCurrency->__construct()	JROOT/libraries/joomla/table/table.php:311
28	JTable::getInstance()	JROOT/components/com_jshopping/lib/factory.php:600
27	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:548
26	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
25	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
24	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
23	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
22	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
21	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
20	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/shaper_helix3/features/menu.php:34
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
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.85 ms После последнего запроса: 0.17 ms Память запроса: 0.038 MB Память до запроса: 14.164 MB Выбрано строк: 2

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `yra1u_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	yra1u_jshopping_currencies	ref	currency_publish	currency_publish	1	const	2	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
28	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
27	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:549
26	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
25	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
24	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
23	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
22	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1560
21	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:14
20	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/shaper_helix3/features/menu.php:34
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
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.89 ms После последнего запроса: 0.21 ms Память запроса: 0.033 MB Память до запроса: 14.166 MB Выбрано строк: 4

select id,link 
  from yra1u_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='ru-RU') 
  and access IN (1,1,5)

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:136
23	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:46
22	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:39
21	shopItemMenu::getInstance()	JROOT/components/com_jshopping/router.php:15
20	jshoppingBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/plugins/system/helix3/core/classes/menu.php:112
13	Helix3Menu->initMenu()	JROOT/plugins/system/helix3/core/classes/menu.php:31
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/shaper_helix3/features/menu.php:34
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
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 для получения ссылок на файлы]

Время запроса: 1.45 ms После последнего запроса: 3.54 ms Память запроса: 0.030 MB Память до запроса: 14.284 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.15 ms
checking permissions	0.04 ms
Opening tables	0.10 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.08 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Preparing	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.46 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.82 ms После последнего запроса: 348.07 ms Память запроса: 0.023 MB Память до запроса: 19.408 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.09 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 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.61 ms После последнего запроса: 5.86 ms Память запроса: 0.028 MB Память до запроса: 19.457 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.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.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.16 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.46 ms После последнего запроса: 786.84 ms Память запроса: 0.021 MB Память до запроса: 15.662 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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 После последнего запроса: 10.65 ms Память запроса: 0.014 MB Память до запроса: 15.790 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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Стек вызовов

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

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

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

2 × SELECT * 
  FROM yra1u_zoo_application

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

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

1 × SELECT * 
  FROM yra1u_jshopping_config

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 currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `yra1u_jshopping_currencies`

```
1 × select id,link 
  from yra1u_menu
```

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

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

1 × SELECT * 
  FROM yra1u_zoo_category

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 id 
  FROM yra1u_users
```
```
1 × SELECT * 
  FROM yra1u_zoo_item
```

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 `value` 
  FROM `yra1u_admintools_storage`

1 × SELECT * 
  FROM `yra1u_admintools_wafexceptions`

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 `source`,`keepurlparams` 
  FROM `yra1u_admintools_redirects`

1 × SELECT `data` 
  FROM `yra1u_session`

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

1 × SHOW FULL COLUMNS 
  FROM `yra1u_assets

1 × SHOW FULL COLUMNS 
  FROM `yra1u_jshopping_config

1 × SHOW FULL COLUMNS 
  FROM `yra1u_jshopping_currencies

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

1 × DELETE  
  FROM `yra1u_jhackguard_ip_filters`

1 × SHOW VARIABLES LIKE "collation_database

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 × UPDATE `yra1u_extensions` 
  SET `params` = '{\"mediaversion\":\"d77bf963cb1aef7bc6ab70108b5c2838\"}'

1 × INSERT INTO `yra1u_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('gngcc5c93hsfrpk4jh8b3h9l75', 1, '1779650304', 0, '', 0

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

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

Виробництво меблів, міжкімнатні двері, вхідні двері, Вікна, балкони, Ремонт квартир, Меблі, продаж, купити, замовити меблі в Києві. Якісно, недорого

Напрямком роботи фірми «ДІС»- Дизайн Інтер'єр Стиль є:

1.Виготовлення корпусних меблів та диванів за індивідуальними розмірами. Меблевої фабрики у Києві.

2.Вхідні двері, міжкімнатні двері. Стандартні та на замовлення.

3.Металопластикові вікна. Скління балконів та лоджій, внутрішня та зовнішня обшивка.

4. Ремонт квартир "Під ключ" та окремі ремонтні роботи

Двері

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

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

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

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

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

Сессия

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

Время

Память

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

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

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

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

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

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

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

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

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

Виробництво меблів, міжкімнатні двері, вхідні двері, Вікна, балкони, Ремонт квартир, Меблі, продаж, купити, замовити меблі в Києві. Якісно, ​​недорого

Напрямком роботи фірми «ДІС»- Дизайн Інтер'єр Стиль є:

1.Виготовлення корпусних меблів та диванів за індивідуальними розмірами. Меблевої фабрики у Києві.

2.Вхідні двері, міжкімнатні двері. Стандартні та на замовлення.

3.Металопластикові вікна. Скління балконів та лоджій, внутрішня та зовнішня обшивка.

4. Ремонт квартир "Під ключ" та окремі ремонтні роботи

Двері

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

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

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

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

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

Сессия

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

Время

Память

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

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

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

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

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

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

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

Виробництво меблів, міжкімнатні двері, вхідні двері, Вікна, балкони, Ремонт квартир, Меблі, продаж, купити, замовити меблі в Києві. Якісно, недорого