И - Количество сыгранных игр, шт; ПШ - Количество пропущенных шайб, шт; П - Количество результативных передач, шт; Ш - Количество штрафного времени (удаления), мин.; Ио - Количество сыгранных матчей на "0",шт; Кн - Коффицент надёжности (Взято из расчёта Кн = Количество пропущенных шайб / Количество сыгранных игр),ед.; О - Количество очков набранных за игру (О = Количество заброшенных шайб + Количество результативных передач), шт; Вр - Количество общего времени проведённого на площадке, мин.; Кср - Коэффицент средних очков набранных за игру (Кср = (Количество заброшенных шайб + Количество результативных передач) / Количество сыгранных игр).

Партнёры

Найти сайт где скачать шаблоны Joomla 3.4.

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

Сессия

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

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

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

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

45 SQL-запросов зафиксировано 31.33 ms

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

3 повторов: #9 #13 #45

11 повторов: #15 #16 #17 #18 #19 #20 #21 #24 #27 #39 #40

2 повторов: #33 #35

2 повторов: #34 #36

Время запроса: 0.48 ms Память запроса: 0.003 MB Память до запроса: 2.652 MB

DELETE 

  FROM `p0b48_session`

  WHERE `time` < '1550419111'

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

EXPLAIN не доступен для запроса: DELETE FROM `p0b48_session` WHERE `time` < '1550419111'

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

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
updating	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
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:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

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

SELECT `data`

  FROM `p0b48_session`

  WHERE `session_id` = '54a904281708dfada933abfd977a7189'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_session	const	PRIMARY	PRIMARY	766	const	1

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 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:829
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:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.84 ms После последнего запроса: 2.71 ms Память запроса: 0.021 MB Память до запроса: 2.770 MB Выбрано строк: 0

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '54a904281708dfada933abfd977a7189' 
  LIMIT 1

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.18 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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:831
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:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.68 ms После последнего запроса: 0.15 ms Память запроса: 0.003 MB Память до запроса: 2.774 MB

INSERT INTO `p0b48_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('54a904281708dfada933abfd977a7189', 1, '1550422711', 0, '', 0)

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

EXPLAIN не доступен для запроса: INSERT INTO `p0b48_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('54a904281708dfada933abfd977a7189', 1, '1550422711', 0, '', 0)

Профилирование 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
update	0.41 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
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:413
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.21 ms После последнего запроса: 14.13 ms Память запроса: 0.023 MB Память до запроса: 3.358 MB Выбрано строк: 6

SELECT id, rules

  FROM `p0b48_viewlevels`

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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:49

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

Время запроса: 0.12 ms После последнего запроса: 0.19 ms Память запроса: 0.022 MB Память до запроса: 3.370 MB Выбрано строк: 2

SELECT b.id

  FROM p0b48_usergroups AS a

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

  WHERE a.id = 13

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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:49

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

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

SELECT `enabled`

  FROM `p0b48_extensions`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:252
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
5	JPluginHelper::importPlugin()	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:49

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

Время запроса: 0.63 ms После последнего запроса: 37.10 ms Память запроса: 0.024 MB Память до запроса: 6.911 MB Выбрано строк: 1

SELECT COUNT(`extension_id`)

  FROM `p0b48_extensions`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	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
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:95
14	JComponentHelper::isInstalled()	JROOT/libraries/regularlabs/src/Parameters.php:136
13	RegularLabs\Library\Parameters->getComponentParams()	JROOT/plugins/system/advancedmodules/src/Params.php:29
12	RegularLabs\Plugin\System\AdvancedModules\Params::get()	JROOT/plugins/system/advancedmodules/src/Helper.php:22
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterInitialise()	Так же, как вызов в строке ниже.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:59
8	PlgSystemAdvancedModules->onAfterInitialise()	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:684
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:49

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

Время запроса: 2.02 ms После последнего запроса: 3.87 ms Память запроса: 0.033 MB Память до запроса: 6.979 MB Выбрано строк: 213

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

SHOW TABLES

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

EXPLAIN не доступен для запроса: SHOW TABLES

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.99 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
8	plgSystemjdownloads->onAfterInitialise()	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:684
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:49

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

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

SELECT file_id 
  from p0b48_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2019-02-17 19:58:31'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
8	plgSystemjdownloads->onAfterInitialise()	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:684
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:49

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

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

SELECT file_id 
  from p0b48_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2019-02-17 19:58:31'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_jdownloads_files	ref	idx_published	idx_published	1	const	1	Using where

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	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.02 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
8	plgSystemjdownloads->onAfterInitialise()	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:684
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:49

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

Время запроса: 0.30 ms После последнего запроса: 53.48 ms Память запроса: 0.031 MB Память до запроса: 10.893 MB Выбрано строк: 37

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

  FROM `p0b48_assets`

  WHERE `name` IN ('root.1','com_admin','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_datsogallery','com_fields','com_finder','com_installer','com_jdownloads','com_joomlaupdate','com_joomleague','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_assets	range	idx_asset_name	idx_asset_name	202	NULL	40	Using index condition

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
15	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
14	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
13	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Так же, как вызов в строке ниже.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
8	PlgSystemAdvancedModules->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.63 ms После последнего запроса: 2.36 ms Память запроса: 0.033 MB Память до запроса: 11.022 MB Выбрано строк: 213

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

SHOW TABLES

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

EXPLAIN не доступен для запроса: SHOW TABLES

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

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	1.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
8	plgSystemjdownloads->onAfterRoute()	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:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.08 ms После последнего запроса: 3.07 ms Память запроса: 0.006 MB Память до запроса: 11.244 MB

UPDATE `p0b48_extensions`

  SET `params` = '{\"mediaversion\":\"21fe1fb5ef4044405655bfa8365635be\"}'

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

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
init	0.11 ms
updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.50 ms
query end	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84
8	plgSystemSL_ScrollToTop->onAfterRoute()	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:1155
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Повторяющиеся запросы: #16 #17 #18 #19 #20 #21 #24 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	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
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.18 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
10	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:42
9	JoomleagueHelperExtensioncontroller->getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:53
8	JoomleagueHelperExtensioncontroller->initExtensions()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:93
7	JLGController::getInstance()	JROOT/components/com_joomleague/joomleague.php:28
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

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

Повторяющиеся запросы: #15 #17 #18 #19 #20 #21 #24 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
10	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:42
9	JoomleagueHelperExtensioncontroller->getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:77
8	JoomleagueHelperExtensioncontroller->addModelPaths()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:104
7	JLGController::getInstance()	JROOT/components/com_joomleague/joomleague.php:28
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.14 ms После последнего запроса: 0.40 ms Память запроса: 0.024 MB Память до запроса: 12.852 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #18 #19 #20 #21 #24 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
10	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:42
9	JoomleagueHelperExtensioncontroller->getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:94
8	JoomleagueHelperExtensioncontroller->addViewPaths()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:105
7	JLGController::getInstance()	JROOT/components/com_joomleague/joomleague.php:28
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.15 ms После последнего запроса: 0.42 ms Память запроса: 0.024 MB Память до запроса: 12.859 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #19 #20 #21 #24 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:41
12	JLGController->createView()	JROOT/libraries/legacy/controller/legacy.php:843
11	JControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.23 ms После последнего запроса: 3.01 ms Память запроса: 0.026 MB Память до запроса: 13.112 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #18 #20 #21 #24 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
17	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgview.php:56
16	JLGView->_setPath()	JROOT/libraries/legacy/view/legacy.php:190
15	JViewLegacy->__construct()	JROOT/components/com_joomleague/assets/classes/jlgview.php:24
14	JLGView->__construct()	JROOT/libraries/legacy/controller/legacy.php:597
13	JControllerLegacy->createView()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:82
12	JLGController->createView()	JROOT/libraries/legacy/controller/legacy.php:843
11	JControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.22 ms После последнего запроса: 0.46 ms Память запроса: 0.026 MB Память до запроса: 13.122 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #18 #19 #21 #24 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
17	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgview.php:56
16	JLGView->_setPath()	JROOT/libraries/legacy/view/legacy.php:201
15	JViewLegacy->__construct()	JROOT/components/com_joomleague/assets/classes/jlgview.php:24
14	JLGView->__construct()	JROOT/libraries/legacy/controller/legacy.php:597
13	JControllerLegacy->createView()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:82
12	JLGController->createView()	JROOT/libraries/legacy/controller/legacy.php:843
11	JControllerLegacy->getView()	JROOT/libraries/legacy/controller/legacy.php:620
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.16 ms После последнего запроса: 0.45 ms Память запроса: 0.025 MB Память до запроса: 13.133 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #18 #19 #20 #24 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
14	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgmodel.php:22
13	JLGModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:31
12	JLGController->createModel()	JROOT/libraries/legacy/controller/legacy.php:735
11	JControllerLegacy->getModel()	JROOT/libraries/legacy/controller/legacy.php:623
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.64 ms После последнего запроса: 2.54 ms Память запроса: 0.026 MB Память до запроса: 13.345 MB Выбрано строк: 1

SELECT	pt.id
							
  FROM p0b48_joomleague_project_team AS pt
							
  WHERE pt.team_id='148'
							  
  AND pt.project_id='31'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	const	combi,project_id,team_id	combi	8	const,const	1

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	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
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.16 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/roster.php:81
16	JoomleagueModelRoster->getProjectTeam()	JROOT/components/com_joomleague/models/roster.php:49
15	JoomleagueModelRoster->__construct()	JROOT/libraries/legacy/model/legacy.php:201
14	JModelLegacy::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgmodel.php:62
13	JLGModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:31
12	JLGController->createModel()	JROOT/libraries/legacy/controller/legacy.php:735
11	JControllerLegacy->getModel()	JROOT/libraries/legacy/controller/legacy.php:623
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

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

SELECT t.*, pt.division_id, t.id as team_id,
				pt.picture AS projectteam_picture,
				pt.notes AS projectteam_notes,
				t.picture as team_picture,
				c.logo_small,
				c.logo_middle,
				c.logo_big,
				c.country,
				IF((ISNULL(pt.picture) OR (pt.picture="")),
					(IF((ISNULL(t.picture) OR (t.picture="")), c.logo_big , t.picture)) , pt.picture) as picture,
				t.extended as teamextended, pt.project_id AS project_id, pt.id AS ptid
				
  FROM p0b48_joomleague_project_team AS pt
				
  INNER JOIN p0b48_joomleague_team AS t 
  ON pt.team_id=t.id
				
  LEFT JOIN p0b48_joomleague_club AS c 
  ON t.club_id=c.id
				
  WHERE pt.id='476'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	pt	const	PRIMARY,team_id	PRIMARY	4	const	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.26 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
18	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:433
17	JoomleagueModelProject->getTeaminfo()	JROOT/components/com_joomleague/models/roster.php:82
16	JoomleagueModelRoster->getProjectTeam()	JROOT/components/com_joomleague/models/roster.php:49
15	JoomleagueModelRoster->__construct()	JROOT/libraries/legacy/model/legacy.php:201
14	JModelLegacy::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgmodel.php:62
13	JLGModel::getInstance()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:31
12	JLGController->createModel()	JROOT/libraries/legacy/controller/legacy.php:735
11	JControllerLegacy->getModel()	JROOT/libraries/legacy/controller/legacy.php:623
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.18 ms После последнего запроса: 12.47 ms Память запроса: 0.024 MB Память до запроса: 13.754 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #18 #19 #20 #21 #27 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/models/project.php:699
12	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/views/roster/view.html.php:17
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.85 ms После последнего запроса: 0.40 ms Память запроса: 0.025 MB Память до запроса: 13.759 MB Выбрано строк: 1

SELECT t.params
				   
  FROM p0b48_joomleague_template_config AS t
				   
  INNER JOIN p0b48_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='roster'
				   
  AND p.id='31'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	25	Using index condition; Using where

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.27 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
12	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/views/roster/view.html.php:17
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.82 ms После последнего запроса: 0.64 ms Память запроса: 0.039 MB Память до запроса: 13.766 MB Выбрано строк: 1

SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,
					LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,
					
  CASE WHEN CHAR_LENGTH( p.alias )
					THEN CONCAT_WS( ':', p.id, p.alias )
					ELSE p.id
					END AS slug,
					l.name AS league_name,
					s.name AS season_name
					
  FROM p0b48_joomleague_project AS p
					
  INNER JOIN p0b48_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id
					
  LEFT JOIN p0b48_joomleague_league AS l 
  ON p.league_id = l.id
					
  LEFT JOIN p0b48_joomleague_season AS s 
  ON p.season_id = s.id
					
  WHERE p.id='31' 
  LIMIT 0, 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	p	const	PRIMARY,sports_type_id	PRIMARY	4	const	1
1	SIMPLE	st	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.08 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/project.php:99
12	JoomleagueModelProject->getProject()	JROOT/components/com_joomleague/views/roster/view.html.php:19
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.22 ms После последнего запроса: 4.84 ms Память запроса: 0.025 MB Память до запроса: 13.840 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #18 #19 #20 #21 #24 #39 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
14	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/models/project.php:699
13	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/models/project.php:763
12	JoomleagueModelProject->getOverallConfig()	JROOT/components/com_joomleague/views/roster/view.html.php:20
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.64 ms После последнего запроса: 0.40 ms Память запроса: 0.024 MB Память до запроса: 13.845 MB Выбрано строк: 1

SELECT t.params
				   
  FROM p0b48_joomleague_template_config AS t
				   
  INNER JOIN p0b48_joomleague_project AS p 
  ON p.id=t.project_id
				   
  WHERE t.template='overall'
				   
  AND p.id='31'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	t	ref	project_id	project_id	4	const	25	Using index condition; Using where

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/components/com_joomleague/models/project.php:724
13	JoomleagueModelProject->getTemplateConfig()	JROOT/components/com_joomleague/models/project.php:763
12	JoomleagueModelProject->getOverallConfig()	JROOT/components/com_joomleague/views/roster/view.html.php:20
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.45 ms После последнего запроса: 0.21 ms Память запроса: 0.029 MB Память до запроса: 13.851 MB Выбрано строк: 1

SELECT	t.*,
								
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS slug
						
  FROM p0b48_joomleague_team AS t
						
  WHERE t.id='148'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.04 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
Waiting for query cache lock	0.01 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_joomleague/models/roster.php:112
12	JoomleagueModelRoster->getTeam()	JROOT/components/com_joomleague/views/roster/view.html.php:39
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 1.24 ms После последнего запроса: 0.08 ms Память запроса: 0.029 MB Память до запроса: 13.864 MB Выбрано строк: 0

SELECT	pr.firstname,
								pr.nickname,
								pr.lastname,
								pr.country,
								pr.birthday,
								pr.deathday,
								tp.id AS playerid,
								pr.id AS pid,
								pr.picture AS ppic,
								tp.jerseynumber AS position_number,
								tp.notes AS description,
								tp.injury AS injury,
								tp.suspension AS suspension,
								pt.team_id,
								tp.away AS away,tp.picture,
								pos.name AS position,
								ppos.position_id,
								ppos.id as pposid,
								
  CASE WHEN CHAR_LENGTH(pr.alias) THEN CONCAT_WS(':',pr.id,pr.alias) ELSE pr.id END AS slug
						
  FROM p0b48_joomleague_team_player tp
						
  INNER JOIN p0b48_joomleague_project_team AS pt 
  ON pt.id=tp.projectteam_id
						
  INNER JOIN p0b48_joomleague_person AS pr 
  ON tp.person_id=pr.id
						
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.id=tp.project_position_id
						
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ppos.position_id
						
  WHERE tp.projectteam_id='476'
						
  AND pr.published = 1
						
  AND tp.published = 1
						
  ORDER BY pos.ordering, ppos.position_id, tp.jerseynumber, pr.lastname, pr.firstname

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tp	ref	projectteam_id,person_id,project_position_id	projectteam_id	5	const	1	Using index condition; Using where; Using temporary; Используется filesort
1	SIMPLE	ppos	eq_ref	PRIMARY,pos_proj,position_id	PRIMARY	4	u230557_rhlnn.tp.project_position_id	1
1	SIMPLE	pos	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ppos.position_id	1
1	SIMPLE	pt	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.tp.projectteam_id	1
1	SIMPLE	pr	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.tp.person_id	1	Using where

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.01 ms
Creating tmp table	0.33 ms
Copying to tmp table	0.03 ms
Sorting result	0.04 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.13 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/roster.php:155
12	JoomleagueModelRoster->getTeamPlayers()	JROOT/components/com_joomleague/views/roster/view.html.php:41
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.55 ms После последнего запроса: 0.09 ms Память запроса: 0.027 MB Память до запроса: 13.870 MB Выбрано строк: 0

SELECT	pet.*,
							ppos.id AS pposid,
							ppos.position_id,
							et.name AS name,
							et.icon AS icon
					
  FROM p0b48_joomleague_position_eventtype AS pet
					
  INNER JOIN p0b48_joomleague_eventtype AS et 
  ON et.id=pet.eventtype_id
					
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.position_id=pet.position_id
					
  WHERE ppos.project_id=31 
  AND et.published=1  
  ORDER BY pet.ordering, et.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ppos	ref	pos_proj,project_id,position_id	project_id	4	const	1	Using temporary; Используется filesort
1	SIMPLE	pet	ref	pos_et,position_id,eventtype_id	pos_et	4	u230557_rhlnn.ppos.position_id	1
1	SIMPLE	et	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.pet.eventtype_id	1	Using where

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.02 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/roster.php:227
12	JoomleagueModelRoster->getPositionEventTypes()	JROOT/components/com_joomleague/views/roster/view.html.php:46
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.44 ms После последнего запроса: 0.09 ms Память запроса: 0.024 MB Память до запроса: 13.876 MB Выбрано строк: 0

SELECT ppos.id AS project_position_id, pet.eventtype_id AS event_type_id 
  FROM       p0b48_joomleague_project_position AS ppos 
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ppos.position_id 
  INNER JOIN p0b48_joomleague_position_eventtype AS pet 
  ON pet.position_id=pos.id 
  WHERE ppos.project_id='31'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ppos	ref	pos_proj,project_id,position_id	project_id	4	const	1
1	SIMPLE	pos	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ppos.position_id	1	Using index
1	SIMPLE	pet	ref	pos_et,position_id	pos_et	4	u230557_rhlnn.ppos.position_id	1	Using index

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/roster.php:272
13	JoomleagueModelRoster->getProjectPositionEventTypes()	JROOT/components/com_joomleague/models/roster.php:250
12	JoomleagueModelRoster->getPlayerEventStats()	JROOT/components/com_joomleague/views/roster/view.html.php:47
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.97 ms После последнего запроса: 2.45 ms Память запроса: 0.028 MB Память до запроса: 14.101 MB Выбрано строк: 0

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

SELECT	stat.id,
								stat.name,
								stat.short,
								stat.class,
								stat.icon,
								stat.calculated,
								ppos.id as pposid,
								ppos.position_id AS position_id,
								stat.params, stat.baseparams
						
  FROM p0b48_joomleague_statistic AS stat
						
  INNER JOIN p0b48_joomleague_position_statistic AS ps 
  ON ps.statistic_id=stat.id
						
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.position_id=ps.position_id
						  
  AND ppos.project_id=31
						
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ps.position_id
						
  WHERE stat.published=1
						  
  AND pos.published =1
						   
  ORDER BY pos.ordering,ps.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ppos	ref	pos_proj,project_id,position_id	project_id	4	const	1	Using temporary; Используется filesort
1	SIMPLE	ps	ref	pos_et,position_id,statistic_id	pos_et	4	u230557_rhlnn.ppos.position_id	1
1	SIMPLE	stat	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ps.statistic_id	1	Using where
1	SIMPLE	pos	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ppos.position_id	1	Using where

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.29 ms
Copying to tmp table	0.03 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:844
12	JoomleagueModelProject->getProjectStats()	JROOT/components/com_joomleague/views/roster/view.html.php:52
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

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

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

SELECT	pos.id,
								pos.persontype,
								pos.name,
								pos.ordering,
								pos.published,
								ppos.id AS pposid
						
  FROM p0b48_joomleague_project_position AS ppos
						
  INNER JOIN p0b48_joomleague_position AS pos 
  ON ppos.position_id=pos.id
						
  WHERE ppos.project_id='31'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ppos	ref	pos_proj,project_id,position_id	project_id	4	const	1
1	SIMPLE	pos	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ppos.position_id	1

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:896
13	JoomleagueModelProject->getProjectPositions()	JROOT/components/com_joomleague/models/project.php:848
12	JoomleagueModelProject->getProjectStats()	JROOT/components/com_joomleague/views/roster/view.html.php:52
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.19 ms После последнего запроса: 0.09 ms Память запроса: 0.027 MB Память до запроса: 14.116 MB Выбрано строк: 0

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

SELECT	stat.id,
								stat.name,
								stat.short,
								stat.class,
								stat.icon,
								stat.calculated,
								ppos.id as pposid,
								ppos.position_id AS position_id,
								stat.params, stat.baseparams
						
  FROM p0b48_joomleague_statistic AS stat
						
  INNER JOIN p0b48_joomleague_position_statistic AS ps 
  ON ps.statistic_id=stat.id
						
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.position_id=ps.position_id
						  
  AND ppos.project_id=31
						
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ps.position_id
						
  WHERE stat.published=1
						  
  AND pos.published =1
						   
  ORDER BY pos.ordering,ps.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ppos	ref	pos_proj,project_id,position_id	project_id	4	const	1	Using temporary; Используется filesort
1	SIMPLE	ps	ref	pos_et,position_id,statistic_id	pos_et	4	u230557_rhlnn.ppos.position_id	1
1	SIMPLE	stat	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ps.statistic_id	1	Using where
1	SIMPLE	pos	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ppos.position_id	1	Using where

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:844
13	JoomleagueModelProject->getProjectStats()	JROOT/components/com_joomleague/models/roster.php:529
12	JoomleagueModelRoster->getRosterStats()	JROOT/components/com_joomleague/views/roster/view.html.php:53
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.15 ms После последнего запроса: 0.07 ms Память запроса: 0.026 MB Память до запроса: 14.123 MB Выбрано строк: 0

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

SELECT	pos.id,
								pos.persontype,
								pos.name,
								pos.ordering,
								pos.published,
								ppos.id AS pposid
						
  FROM p0b48_joomleague_project_position AS ppos
						
  INNER JOIN p0b48_joomleague_position AS pos 
  ON ppos.position_id=pos.id
						
  WHERE ppos.project_id='31'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ppos	ref	pos_proj,project_id,position_id	project_id	4	const	1
1	SIMPLE	pos	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ppos.position_id	1

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/project.php:896
14	JoomleagueModelProject->getProjectPositions()	JROOT/components/com_joomleague/models/project.php:848
13	JoomleagueModelProject->getProjectStats()	JROOT/components/com_joomleague/models/roster.php:529
12	JoomleagueModelRoster->getRosterStats()	JROOT/components/com_joomleague/views/roster/view.html.php:53
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.99 ms После последнего запроса: 0.09 ms Память запроса: 0.029 MB Память до запроса: 14.132 MB Выбрано строк: 0

SELECT	pr.firstname,
							pr.nickname,
							pr.lastname,
							pr.country,
							pr.birthday,
							pr.deathday,
							ts.id AS ptid,
							ppos.position_id,
							ppos.id AS pposid,
							pr.id AS pid,
							pr.picture AS ppic,
							pos.name AS position,
							ts.picture,
							ts.notes AS description,
							ts.injury AS injury,
							ts.suspension AS suspension,
							ts.away AS away,
							pos.parent_id,
							posparent.name AS parentname,
							
  CASE WHEN CHAR_LENGTH(pr.alias) THEN CONCAT_WS(':',pr.id,pr.alias) ELSE pr.id END AS slug
					
  FROM p0b48_joomleague_team_staff ts
					
  INNER JOIN p0b48_joomleague_person AS pr 
  ON ts.person_id=pr.id
					
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.id=ts.project_position_id
					
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ppos.position_id
					
  LEFT JOIN p0b48_joomleague_position AS posparent 
  ON pos.parent_id=posparent.id
					
  WHERE ts.projectteam_id='476'
					  
  AND pr.published = 1
					  
  AND ts.published = 1
					
  ORDER BY pos.parent_id, pos.ordering

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ts	ref	projectteam_id,person_id,project_position_id	projectteam_id	5	const	1	Using where; Using temporary; Используется filesort
1	SIMPLE	ppos	eq_ref	PRIMARY,pos_proj,position_id	PRIMARY	4	u230557_rhlnn.ts.project_position_id	1
1	SIMPLE	pos	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ppos.position_id	1
1	SIMPLE	posparent	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.pos.parent_id	1
1	SIMPLE	pr	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ts.person_id	1	Using where

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.10 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.25 ms
Copying to tmp table	0.03 ms
Sorting result	0.03 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomleague/models/roster.php:205
12	JoomleagueModelRoster->getStaffList()	JROOT/components/com_joomleague/views/roster/view.html.php:55
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.17 ms После последнего запроса: 1.05 ms Память запроса: 0.024 MB Память до запроса: 14.175 MB Выбрано строк: 0

SELECT CONCAT(major,".",minor,".",build,".",revision) AS version

  FROM p0b48_joomleague_version

  ORDER BY date DESC 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_joomleague_version	system	NULL	Индекс не используется	NULL	NULL	0	const row not found

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:1179
13	JoomleagueHelper::getVersion()	JROOT/components/com_joomleague/assets/classes/jlgview.php:100
12	JLGView->display()	JROOT/components/com_joomleague/views/roster/view.html.php:89
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.22 ms После последнего запроса: 16.43 ms Память запроса: 0.024 MB Память до запроса: 14.389 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #18 #19 #20 #21 #24 #27 #40

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
13	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/assets/classes/jlgview.php:158
12	JLGView->display()	JROOT/components/com_joomleague/views/roster/view.html.php:89
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.11 ms После последнего запроса: 1.64 ms Память запроса: 0.027 MB Память до запроса: 14.427 MB Выбрано строк: 1

Повторяющиеся запросы: #15 #16 #17 #18 #19 #20 #21 #24 #27 #39

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
17	JoomleagueHelper::getExtensions()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:731
16	JoomleagueHelper::addTemplatePaths()	JROOT/templates/fitness_center/html/com_joomleague/roster/default.php:6
15	include JROOT/templates/fitness_center/html/com_joomleague/roster/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/components/com_joomleague/assets/classes/jlgview.php:215
12	JLGView->display()	JROOT/components/com_joomleague/views/roster/view.html.php:89
11	JoomleagueViewRoster->display()	JROOT/libraries/legacy/controller/legacy.php:671
10	JControllerLegacy->display()	JROOT/components/com_joomleague/controller.php:23
9	JoomleagueController->showprojectheading()	JROOT/components/com_joomleague/controller.php:18
8	JoomleagueController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_joomleague/joomleague.php:32
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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:49

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

Время запроса: 0.23 ms После последнего запроса: 20.57 ms Память запроса: 0.025 MB Память до запроса: 14.862 MB Выбрано строк: 1

SELECT * 
  FROM p0b48_template_styles 
  WHERE template = 'fitness_center';

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_template_styles	ref	idx_template	idx_template	202	const	1	Using index condition

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/fitness_center/vertex/parameters.php:19
9	getTemplateName()	JROOT/templates/fitness_center/vertex/parameters.php:167
8	require_once JROOT/templates/fitness_center/vertex/parameters.php	JROOT/templates/fitness_center/index.php:21
7	require JROOT/templates/fitness_center/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:1102
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:49

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

Время запроса: 0.16 ms После последнего запроса: 0.12 ms Память запроса: 0.029 MB Память до запроса: 14.871 MB Выбрано строк: 0

SELECT * 
  FROM p0b48_menu 
  WHERE template_style_id IN (31) 
  AND alias = ''

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p0b48_menu	ref	idx_alias	idx_alias	402	const	1	Using where

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/fitness_center/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/fitness_center/vertex/parameters.php:167
8	require_once JROOT/templates/fitness_center/vertex/parameters.php	JROOT/templates/fitness_center/index.php:21
7	require JROOT/templates/fitness_center/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:1102
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:49

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

Время запроса: 7.17 ms После последнего запроса: 8.91 ms Память запроса: 0.343 MB Память до запроса: 15.166 MB Выбрано строк: 123

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 p0b48_modules AS m

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

  LEFT JOIN p0b48_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	127	Using index condition; Using where; Используется filesort
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	u230557_rhlnn.m.module,const	1	Using index condition; Using where

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.07 ms
executing	0.01 ms
Sorting result	1.26 ms
Sending data	0.39 ms
Waiting for query cache lock	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.22 ms
Waiting for query cache lock	0.01 ms
Sending data	0.65 ms
Waiting for query cache lock	0.02 ms
Sending data	0.32 ms
Waiting for query cache lock	0.01 ms
Sending data	0.31 ms
Waiting for query cache lock	0.01 ms
Sending data	0.34 ms
Waiting for query cache lock	0.01 ms
Sending data	0.44 ms
Waiting for query cache lock	0.01 ms
Sending data	0.26 ms
Waiting for query cache lock	0.01 ms
Sending data	0.21 ms
Waiting for query cache lock	0.01 ms
Sending data	0.21 ms
Waiting for query cache lock	0.01 ms
Sending data	0.24 ms
Waiting for query cache lock	0.01 ms
Sending data	0.11 ms
Waiting for query cache lock	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:406
15	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
14	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
13	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
12	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
9	JDocumentHtml->countModules()	JROOT/templates/fitness_center/vertex/module_calcs.php:15
8	require_once JROOT/templates/fitness_center/vertex/module_calcs.php	JROOT/templates/fitness_center/index.php:23
7	require JROOT/templates/fitness_center/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:1102
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:49

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

Время запроса: 0.24 ms После последнего запроса: 77.30 ms Память запроса: 0.036 MB Память до запроса: 17.506 MB Выбрано строк: 118

SELECT *

  FROM p0b48_datsogallery_settings

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_datsogallery/helpers/config.php:44
21	DatsogalleryConfig->load()	JROOT/administrator/components/com_datsogallery/helpers/config.php:17
20	DatsogalleryConfig->__construct()	JROOT/administrator/components/com_datsogallery/helpers/config.php:89
19	DatsogalleryConfig::getInstance()	JROOT/administrator/components/com_datsogallery/helpers/datsogallery.php:88
18	DatsogalleryHelper::getConfig()	JROOT/components/com_datsogallery/router.php:12
17	DatsoGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/templates/fitness_center/vertex/s5flex_menu/helpers.php:103
10	S5modMainMenuHelper::getList()	JROOT/templates/fitness_center/vertex/s5flex_menu/helpers.php:141
9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/fitness_center/vertex/s5flex_menu/default.php:54
8	include JROOT/templates/fitness_center/vertex/s5flex_menu/default.php	JROOT/templates/fitness_center/index.php:176
7	require JROOT/templates/fitness_center/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:1102
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:49

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

Время запроса: 1.53 ms После последнего запроса: 16.07 ms Память запроса: 0.033 MB Память до запроса: 16.824 MB Выбрано строк: 213

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

SHOW TABLES

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

EXPLAIN не доступен для запроса: SHOW TABLES

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.98 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:253
7	plgSystemjdownloads->onAfterRender()	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:1122
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:49

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

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

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

11 × SELECT extension 
  FROM p0b48_joomleague_project

2 × SELECT file_id 
  from p0b48_jdownloads_files

2 × SELECT pos.id,         pos.persontype,         pos.name,         pos.ordering,         pos.published,         ppos.id AS pposid       
  FROM p0b48_joomleague_project_position AS ppos       
  INNER JOIN p0b48_joomleague_position AS pos 
  ON ppos.position_id=pos.id

2 × SELECT stat.id,         stat.name,         stat.short,         stat.class,         stat.icon,         stat.calculated,         ppos.id as pposid,         ppos.position_id AS position_id,         stat.params, stat.baseparams       
  FROM p0b48_joomleague_statistic AS stat       
  INNER JOIN p0b48_joomleague_position_statistic AS ps 
  ON ps.statistic_id=stat.id       
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.position_id=ps.position_id         
  AND ppos.project_id=31       
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ps.position_id

2 × SELECT t.params        
  FROM p0b48_joomleague_template_config AS t        
  INNER JOIN p0b48_joomleague_project AS p 
  ON p.id=t.project_id

1 × SELECT `data` 
  FROM `p0b48_session`

1 × SELECT pet.*,        ppos.id AS pposid,        ppos.position_id,        et.name AS name,        et.icon AS icon      
  FROM p0b48_joomleague_position_eventtype AS pet      
  INNER JOIN p0b48_joomleague_eventtype AS et 
  ON et.id=pet.eventtype_id      
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.position_id=pet.position_id

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 p0b48_modules AS m 
  LEFT JOIN p0b48_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN p0b48_advancedmodules as am 
  ON am.moduleid = m.id

```
1 × SELECT * 
  FROM p0b48_menu
```

1 × SELECT * 
  FROM p0b48_template_styles

1 × SELECT CONCAT(major,".",minor,".",build,".",revision) AS version 
  FROM p0b48_joomleague_version

1 × SELECT pr.firstname,        pr.nickname,        pr.lastname,        pr.country,        pr.birthday,        pr.deathday,        ts.id AS ptid,        ppos.position_id,        ppos.id AS pposid,        pr.id AS pid,        pr.picture AS ppic,        pos.name AS position,        ts.picture,        ts.notes AS description,        ts.injury AS injury,        ts.suspension AS suspension,        ts.away AS away,        pos.parent_id,        posparent.name AS parentname,        
  CASE WHEN CHAR_LENGTH(pr.alias) THEN CONCAT_WS(':',pr.id,pr.alias) ELSE pr.id END AS slug      
  FROM p0b48_joomleague_team_staff ts      
  INNER JOIN p0b48_joomleague_person AS pr 
  ON ts.person_id=pr.id      
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.id=ts.project_position_id      
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ppos.position_id      
  LEFT JOIN p0b48_joomleague_position AS posparent 
  ON pos.parent_id=posparent.id

1 × SELECT ppos.id AS project_position_id, pet.eventtype_id AS event_type_id 
  FROM       p0b48_joomleague_project_position AS ppos 
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ppos.position_id 
  INNER JOIN p0b48_joomleague_position_eventtype AS pet 
  ON pet.position_id=pos.id

1 × SELECT p.*, l.country, st.id AS sport_type_id, st.name AS sport_type_name,      LOWER(SUBSTR(st.name, CHAR_LENGTH( "COM_JOOMLEAGUE_ST_")+1)) AS fs_sport_type_name,      
  CASE WHEN CHAR_LENGTH( p.alias )      THEN CONCAT_WS( ':', p.id, p.alias )      ELSE p.id      END AS slug,      l.name AS league_name,      s.name AS season_name      
  FROM p0b48_joomleague_project AS p      
  INNER JOIN p0b48_joomleague_sports_type AS st 
  ON p.sports_type_id = st.id      
  LEFT JOIN p0b48_joomleague_league AS l 
  ON p.league_id = l.id      
  LEFT JOIN p0b48_joomleague_season AS s 
  ON p.season_id = s.id

1 × SELECT pr.firstname,         pr.nickname,         pr.lastname,         pr.country,         pr.birthday,         pr.deathday,         tp.id AS playerid,         pr.id AS pid,         pr.picture AS ppic,         tp.jerseynumber AS position_number,         tp.notes AS description,         tp.injury AS injury,         tp.suspension AS suspension,         pt.team_id,         tp.away AS away,tp.picture,         pos.name AS position,         ppos.position_id,         ppos.id as pposid,         
  CASE WHEN CHAR_LENGTH(pr.alias) THEN CONCAT_WS(':',pr.id,pr.alias) ELSE pr.id END AS slug       
  FROM p0b48_joomleague_team_player tp       
  INNER JOIN p0b48_joomleague_project_team AS pt 
  ON pt.id=tp.projectteam_id       
  INNER JOIN p0b48_joomleague_person AS pr 
  ON tp.person_id=pr.id       
  INNER JOIN p0b48_joomleague_project_position AS ppos 
  ON ppos.id=tp.project_position_id       
  INNER JOIN p0b48_joomleague_position AS pos 
  ON pos.id=ppos.position_id

1 × SELECT t.*,         
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS slug       
  FROM p0b48_joomleague_team AS t

1 × SELECT `session_id` 
  FROM `p0b48_session`

1 × SELECT t.*, pt.division_id, t.id as team_id,     pt.picture AS projectteam_picture,     pt.notes AS projectteam_notes,     t.picture as team_picture,     c.logo_small,     c.logo_middle,     c.logo_big,     c.country,     IF((ISNULL(pt.picture) OR (pt.picture="")),      (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_big , t.picture)) , pt.picture) as picture,     t.extended as teamextended, pt.project_id AS project_id, pt.id AS ptid     
  FROM p0b48_joomleague_project_team AS pt     
  INNER JOIN p0b48_joomleague_team AS t 
  ON pt.team_id=t.id     
  LEFT JOIN p0b48_joomleague_club AS c 
  ON t.club_id=c.id

1 × SELECT pt.id        
  FROM p0b48_joomleague_project_team AS pt

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `p0b48_assets`

1 × SELECT COUNT(`extension_id`) 
  FROM `p0b48_extensions`

1 × SELECT `enabled` 
  FROM `p0b48_extensions`

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

1 × SELECT id, rules 
  FROM `p0b48_viewlevels

1 × SELECT * 
  FROM p0b48_datsogallery_setting

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

```
3 × SHOW TABLE
```
```
1 × DELETE  
  FROM `p0b48_session`
```

1 × INSERT INTO `p0b48_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('54a904281708dfada933abfd977a7189', 1, '1550422711', 0, '', 0

1 × UPDATE `p0b48_extensions` 
  SET `params` = '{\"mediaversion\":\"21fe1fb5ef4044405655bfa8365635be\"}'

ЛИГА

РХЛ

КАЛЕНДАРЬ

ДИВИЗИОНЫ

МЕДИА

ЭКСКЛЮЗИВ

УЧАСТНИКИ

ТУРНИРЫ

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

Сессия

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

Время

Память

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

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

45 SQL-запросов зафиксировано 31.33 ms

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

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

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

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