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

Партнёры

ДНИ РОЖДЕНИЯ

	Андрей Мищенко 19 декабря 2018
	Сергей Вороненко 20 декабря 2018
	Владимир Ромадов 21 декабря 2018
	Олег Карпов 21 декабря 2018
	Виктор Шорников 21 декабря 2018
	Иван Зайцев 21 декабря 2018
	Артем Ларин 21 декабря 2018

Наши команды

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

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

Сессия

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

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

Время

Память

Время: 10.25 ms / 10.25 ms Память: 0.067 MB / 0.40 MB Application: afterLoad

Время: 53.50 ms / 63.75 ms Память: 1.398 MB / 1.80 MB Application: afterInitialise

Время: 14.34 ms / 78.09 ms Память: 0.807 MB / 2.61 MB Application: Before JAccess::preloadComponents (all components)

Время: 0.53 ms / 78.62 ms Память: 0.059 MB / 2.67 MB Application: After JAccess::preloadComponents (all components)

Время: 0.04 ms / 78.66 ms Память: 0.000 MB / 2.66 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

Время: 0.61 ms / 79.26 ms Память: 0.009 MB / 2.67 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Время: 14.56 ms / 93.83 ms Память: 0.069 MB / 2.74 MB Application: afterRoute

Время: 1.70 ms / 95.53 ms Память: 0.013 MB / 2.75 MB Application: beforeRenderComponent com_joomleague

Время: 58.27 ms / 153.80 ms Память: 1.326 MB / 4.08 MB Application: afterRenderComponent com_joomleague

Время: 2.73 ms / 156.53 ms Память: 0.012 MB / 4.09 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Время: 0.08 ms / 156.61 ms Память: 0.006 MB / 4.10 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Время: 7.99 ms / 164.60 ms Память: 0.027 MB / 4.13 MB Application: afterDispatch

Время: 83.70 ms / 248.30 ms Память: 1.209 MB / 5.33 MB Application: beforeRenderModule mod_breadcrumbs (Навигатор по сайту)

Время: 6.85 ms / 255.15 ms Память: 0.112 MB / 5.45 MB Application: afterRenderModule mod_breadcrumbs (Навигатор по сайту)

Время: 0.08 ms / 255.23 ms Память: 0.001 MB / 5.45 MB Application: beforeRenderModule mod_stcarousel (Наши команды)

Время: 7.93 ms / 263.15 ms Память: 0.031 MB / 5.48 MB Application: afterRenderModule mod_stcarousel (Наши команды)

Время: 1.22 ms / 264.37 ms Память: 0.000 MB / 5.48 MB Application: beforeRenderModule mod_joomleague_birthday (ДНИ РОЖДЕНИЯ)

Время: 42.07 ms / 306.44 ms Память: 0.300 MB / 5.78 MB Application: afterRenderModule mod_joomleague_birthday (ДНИ РОЖДЕНИЯ)

Время: 13.73 ms / 320.17 ms Память: 0.240 MB / 6.02 MB Application: afterRender

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

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

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

61 SQL-запросов зафиксировано 57.12 ms

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

8 повторов: #1 #47 #49 #51 #53 #55 #57 #59

8 повторов: #3 #48 #50 #52 #54 #56 #58 #60

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

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

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

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

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

Повторяющиеся запросы: #47 #49 #51 #53 #55 #57 #59

DELETE 

  FROM `p0b48_session`

  WHERE `time` < '1545167935'

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.08 ms
updating	0.05 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.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.35 ms После последнего запроса: 0.45 ms Память запроса: 0.024 MB Память до запроса: 0.743 MB Выбрано строк: 0

SELECT `data`

  FROM `p0b48_session`

  WHERE `session_id` = 'c7ad7a249538f45ded1f37edd1ad5361'

План 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.01 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.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.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.01 ms
updating status	0.00 ms
storing result in query cache	0.14 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Так же, как вызов в строке ниже.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php: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.35 ms После последнего запроса: 0.89 ms Память запроса: 0.021 MB Память до запроса: 0.759 MB Выбрано строк: 0

Повторяющиеся запросы: #48 #50 #52 #54 #56 #58 #60

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = 'c7ad7a249538f45ded1f37edd1ad5361' 
  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.01 ms
Waiting for query cache lock	0.00 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.01 ms
optimizing	0.01 ms
statistics	0.03 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.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.04 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.38 ms После последнего запроса: 0.10 ms Память запроса: 0.003 MB Память до запроса: 0.764 MB

INSERT INTO `p0b48_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('c7ad7a249538f45ded1f37edd1ad5361', 1, '1545171535', 0, '', 0)

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

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

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

Status	Duration
starting	0.04 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
init	0.01 ms
update	0.08 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 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.18 ms После последнего запроса: 4.73 ms Память запроса: 0.023 MB Память до запроса: 0.906 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.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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.17 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB Память до запроса: 0.918 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.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
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.54 ms После последнего запроса: 10.51 ms Память запроса: 0.022 MB Память до запроса: 1.363 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.01 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.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.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 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.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 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.57 ms После последнего запроса: 14.53 ms Память запроса: 0.024 MB Память до запроса: 1.762 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.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.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.02 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.10 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.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.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.07 ms
cleaning up	0.01 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.48 ms После последнего запроса: 1.43 ms Память запроса: 0.033 MB Память до запроса: 1.777 MB Выбрано строк: 213

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

SHOW TABLES

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
checking permissions	1.72 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 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.48 ms После последнего запроса: 0.27 ms Память запроса: 0.022 MB Память до запроса: 1.808 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 <= '2018-12-19 01:18:55'

План 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.01 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
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.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 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.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 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.41 ms После последнего запроса: 0.06 ms Память запроса: 0.022 MB Память до запроса: 1.813 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 <= '2018-12-19 01:18:55'

План 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.00 ms
init	0.00 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.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.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 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.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 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.26 ms После последнего запроса: 15.08 ms Память запроса: 0.031 MB Память до запроса: 2.614 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.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.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

Стек вызовов

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

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

SHOW TABLES

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.00 ms
checking permissions	0.96 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 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 для получения ссылок на файлы]

Время запроса: 0.82 ms После последнего запроса: 1.64 ms Память запроса: 0.006 MB Память до запроса: 2.699 MB

UPDATE `p0b48_extensions`

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

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

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

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

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

Status	Duration
starting	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
init	0.12 ms
updating	0.12 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.31 ms
query end	0.09 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.18 ms После последнего запроса: 18.74 ms Память запроса: 0.023 MB Память до запроса: 3.664 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.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: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.13 ms После последнего запроса: 0.61 ms Память запроса: 0.023 MB Память до запроса: 3.675 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.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.00 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 Память до запроса: 3.682 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.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: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.13 ms После последнего запроса: 0.42 ms Память запроса: 0.024 MB Память до запроса: 3.689 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.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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.15 ms После последнего запроса: 0.96 ms Память запроса: 0.026 MB Память до запроса: 3.708 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.13 ms После последнего запроса: 0.48 ms Память запроса: 0.026 MB Память до запроса: 3.718 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.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.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.13 ms После последнего запроса: 0.44 ms Память запроса: 0.025 MB Память до запроса: 3.730 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.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.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.42 ms После последнего запроса: 0.82 ms Память запроса: 0.026 MB Память до запроса: 3.756 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.01 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
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.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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.81 ms После последнего запроса: 0.07 ms Память запроса: 0.038 MB Память до запроса: 3.766 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.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 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.06 ms
optimizing	0.03 ms
statistics	0.29 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.05 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.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.18 ms
cleaning up	0.01 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.13 ms После последнего запроса: 9.44 ms Память запроса: 0.024 MB Память до запроса: 3.903 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.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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.12 ms После последнего запроса: 0.39 ms Память запроса: 0.025 MB Память до запроса: 3.908 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	10	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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	0.00 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.14 ms После последнего запроса: 0.16 ms Память запроса: 0.039 MB Память до запроса: 3.915 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.01 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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	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/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.11 ms После последнего запроса: 4.11 ms Память запроса: 0.025 MB Память до запроса: 3.951 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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.10 ms После последнего запроса: 0.38 ms Память запроса: 0.024 MB Память до запроса: 3.956 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	10	Using index condition; Using where

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

Status	Duration
starting	0.01 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
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 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.15 ms Память запроса: 0.029 MB Память до запроса: 3.962 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.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	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.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.03 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.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.15 ms
cleaning up	0.01 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.62 ms После последнего запроса: 0.06 ms Память запроса: 0.029 MB Память до запроса: 3.975 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.12 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.07 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.07 ms
executing	0.01 ms
Creating tmp table	0.57 ms
Copying to tmp table	0.05 ms
Sorting result	0.07 ms
Sending data	0.04 ms
end	0.01 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 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.04 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.16 ms После последнего запроса: 0.06 ms Память запроса: 0.027 MB Память до запроса: 3.981 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.01 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
checking permissions	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

Стек вызовов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.16 ms После последнего запроса: 0.18 ms Память запроса: 0.028 MB Память до запроса: 4.009 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.01 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
checking permissions	0.00 ms
checking permissions	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

Стек вызовов

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.16 ms После последнего запроса: 0.06 ms Память запроса: 0.027 MB Память до запроса: 4.024 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.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
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 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.16 ms После последнего запроса: 0.06 ms Память запроса: 0.026 MB Память до запроса: 4.031 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.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

Стек вызовов

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

Время запроса: 1.32 ms После последнего запроса: 0.06 ms Память запроса: 0.029 MB Память до запроса: 4.040 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.00 ms
checking query cache for query	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.06 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.01 ms
Creating tmp table	0.43 ms
Copying to tmp table	0.03 ms
Sorting result	0.04 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.09 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.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.05 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: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.20 ms После последнего запроса: 0.23 ms Память запроса: 0.024 MB Память до запроса: 4.049 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.09 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.02 ms
updating status	0.01 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.17 ms После последнего запроса: 13.78 ms Память запроса: 0.024 MB Память до запроса: 4.132 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.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.02 ms
updating status	0.01 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/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.53 ms Память запроса: 0.027 MB Память до запроса: 4.155 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.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.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.15 ms После последнего запроса: 20.99 ms Память запроса: 0.025 MB Память до запроса: 4.163 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.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.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: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.12 ms После последнего запроса: 0.10 ms Память запроса: 0.029 MB Память до запроса: 4.171 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.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.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 для получения ссылок на файлы]

Время запроса: 4.65 ms После последнего запроса: 5.44 ms Память запроса: 0.358 MB Память до запроса: 4.250 MB Выбрано строк: 126

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	130	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.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.09 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.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.92 ms
Sending data	0.24 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.18 ms
Waiting for query cache lock	0.01 ms
Sending data	0.19 ms
Waiting for query cache lock	0.01 ms
Sending data	0.15 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.23 ms
Waiting for query cache lock	0.01 ms
Sending data	0.19 ms
Waiting for query cache lock	0.01 ms
Sending data	0.19 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.19 ms
Waiting for query cache lock	0.01 ms
Sending data	0.14 ms
Waiting for query cache lock	0.01 ms
Sending data	0.15 ms
Waiting for query cache lock	0.01 ms
Sending data	0.15 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.09 ms
Waiting for query cache lock	0.01 ms
Sending data	0.06 ms
Waiting for query cache lock	0.01 ms
Sending data	0.08 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.01 ms
updating status	0.00 ms
storing result in query cache	0.11 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.21 ms После последнего запроса: 64.87 ms Память запроса: 0.036 MB Память до запроса: 6.130 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.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.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 для получения ссылок на файлы]

Время запроса: 30.26 ms После последнего запроса: 23.67 ms Память запроса: 0.031 MB Память до запроса: 5.516 MB Выбрано строк: 7

SELECT p.id, p.birthday, p.firstname, p.nickname, p.lastname,
			p.picture AS default_picture, p.country, 
			DATE_FORMAT(p.birthday, '%m-%d')AS daymonth,
			YEAR( CURRENT_DATE( ) ) as year,

			(YEAR( CURRENT_DATE( ) ) - YEAR( p.birthday ) +
			IF(DATE_FORMAT(CURDATE(), '%m.%d') > DATE_FORMAT(p.birthday, '%m.%d'), 1, 0)) AS age,

			DATE_FORMAT(p.birthday,'%Y-%m-%d') AS date_of_birth, tp.picture,

			(TO_DAYS(DATE_ADD(p.birthday, INTERVAL
			(YEAR(CURDATE()) - YEAR(p.birthday) +
			IF(DATE_FORMAT(CURDATE(), '%m.%d') >
			DATE_FORMAT(p.birthday, '%m.%d'), 1, 0))
			YEAR)) - TO_DAYS( CURDATE())+0) AS days_to_birthday,

			'person' AS func_to_call, '' project_id, '' team_id,
			'pid' AS id_to_append, 1 AS type,

			pt.team_id, pt.project_id

			
  FROM p0b48_joomleague_person p 
			
  INNER JOIN p0b48_joomleague_team_player tp 
  ON tp.person_id = p.id 
			
  INNER JOIN p0b48_joomleague_project_team pt 
  ON pt.id = tp.projectteam_id 
			
  WHERE p.published = 1 
  AND p.birthday != '0000-00-00' 
  AND pt.project_id IN (44,43,42,41)  
  GROUP BY p.id  
  HAVING days_to_birthday <= 2 
  ORDER BY days_to_birthday ASC  
  LIMIT 10

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pt	range	PRIMARY,combi,project_id	combi	4	NULL	68	Using index condition; Using temporary; Используется filesort
1	SIMPLE	tp	ref	projectteam_id,person_id	projectteam_id	5	u230557_rhlnn.pt.id	17	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.tp.person_id	1	Using where

Профилирование 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.15 ms
checking permissions	0.01 ms
checking permissions	0.00 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
init	0.08 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.09 ms
executing	0.01 ms
Creating tmp table	0.05 ms
Copying to tmp table	28.93 ms
Sorting result	0.29 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
12	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_joomleague_birthday/helper.php:109
11	require_once JROOT/modules/mod_joomleague_birthday/helper.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:12
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.23 ms После последнего запроса: 0.17 ms Память запроса: 0.028 MB Память до запроса: 5.547 MB Выбрано строк: 0

SELECT p.id, p.birthday, p.firstname, p.nickname, p.lastname,
			p.picture AS default_picture, p.country, 
			DATE_FORMAT(p.birthday, '%m-%d')AS daymonth,
			YEAR( CURRENT_DATE( ) ) as year,

			(YEAR( CURRENT_DATE( ) ) - YEAR( p.birthday ) +
			IF(DATE_FORMAT(CURDATE(), '%m.%d') > DATE_FORMAT(p.birthday, '%m.%d'), 1, 0)) AS age,

			DATE_FORMAT(p.birthday,'%Y-%m-%d') AS date_of_birth, ts.picture,

			(TO_DAYS(DATE_ADD(p.birthday, INTERVAL
			(YEAR(CURDATE()) - YEAR(p.birthday) +
			IF(DATE_FORMAT(CURDATE(), '%m.%d') >
			DATE_FORMAT(p.birthday, '%m.%d'), 1, 0))
			YEAR)) - TO_DAYS( CURDATE())+0) AS days_to_birthday,

			'staff' AS func_to_call, '' project_id, '' team_id,
			'tsid' AS id_to_append, 2 AS type, 

			pt.team_id, pt.project_id

			
  FROM p0b48_joomleague_person p
			
  INNER JOIN p0b48_joomleague_team_staff ts 
  ON ts.person_id = p.id 
			
  INNER JOIN p0b48_joomleague_project_team pt 
  ON pt.id = ts.projectteam_id 
			
  WHERE p.published = 1 
  AND p.birthday != '0000-00-00' 
  AND p.id NOT IN (0,113,1400,2551,1710,1780,1552,2289)  
  AND pt.project_id IN (44,43,42,41)  
  GROUP BY p.id  
  HAVING days_to_birthday <= 2 
  ORDER BY days_to_birthday ASC 
  LIMIT 10

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ts	range	projectteam_id,person_id	projectteam_id	5	NULL	33	Using index condition; Using where; Using temporary; Используется filesort
1	SIMPLE	pt	eq_ref	PRIMARY,combi,project_id	PRIMARY	4	u230557_rhlnn.ts.projectteam_id	1	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	u230557_rhlnn.ts.person_id	1	Using where

Профилирование 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.16 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.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.11 ms
executing	0.01 ms
Creating tmp table	0.04 ms
Copying to tmp table	0.42 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.03 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
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
12	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_joomleague_birthday/helper.php:170
11	require_once JROOT/modules/mod_joomleague_birthday/helper.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:12
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.28 ms После последнего запроса: 1.39 ms Память запроса: 0.009 MB Память до запроса: 5.577 MB

Повторяющиеся запросы: #1 #49 #51 #53 #55 #57 #59

DELETE 

  FROM `p0b48_session`

  WHERE `time` < '1545167935'

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
updating	0.04 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
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.28 ms После последнего запроса: 0.11 ms Память запроса: 0.027 MB Память до запроса: 5.588 MB Выбрано строк: 1

Повторяющиеся запросы: #3 #50 #52 #54 #56 #58 #60

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = 'c7ad7a249538f45ded1f37edd1ad5361' 
  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.01 ms
Waiting for query cache lock	0.00 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.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.03 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 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.01 ms
storing result in query cache	0.13 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
18	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.20 ms После последнего запроса: 0.70 ms Память запроса: 0.009 MB Память до запроса: 5.610 MB

Повторяющиеся запросы: #1 #47 #51 #53 #55 #57 #59

DELETE 

  FROM `p0b48_session`

  WHERE `time` < '1545167935'

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

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

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

Status	Duration
starting	0.03 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.00 ms
init	0.03 ms
updating	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.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.10 ms После последнего запроса: 0.10 ms Память запроса: 0.027 MB Память до запроса: 5.621 MB Выбрано строк: 1

Повторяющиеся запросы: #3 #48 #52 #54 #56 #58 #60

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = 'c7ad7a249538f45ded1f37edd1ad5361' 
  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.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
18	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.21 ms После последнего запроса: 0.56 ms Память запроса: 0.009 MB Память до запроса: 5.642 MB

Повторяющиеся запросы: #1 #47 #49 #53 #55 #57 #59

DELETE 

  FROM `p0b48_session`

  WHERE `time` < '1545167935'

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.04 ms
updating	0.02 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
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.09 ms После последнего запроса: 0.09 ms Память запроса: 0.027 MB Память до запроса: 5.653 MB Выбрано строк: 1

Повторяющиеся запросы: #3 #48 #50 #54 #56 #58 #60

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = 'c7ad7a249538f45ded1f37edd1ad5361' 
  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.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.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
18	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.20 ms После последнего запроса: 0.59 ms Память запроса: 0.009 MB Память до запроса: 5.674 MB

Повторяющиеся запросы: #1 #47 #49 #51 #55 #57 #59

DELETE 

  FROM `p0b48_session`

  WHERE `time` < '1545167935'

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

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

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

Status	Duration
starting	0.03 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.00 ms
init	0.03 ms
updating	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.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.11 ms После последнего запроса: 0.10 ms Память запроса: 0.027 MB Память до запроса: 5.685 MB Выбрано строк: 1

Повторяющиеся запросы: #3 #48 #50 #52 #56 #58 #60

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = 'c7ad7a249538f45ded1f37edd1ad5361' 
  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.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
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
18	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.20 ms После последнего запроса: 0.58 ms Память запроса: 0.009 MB Память до запроса: 5.706 MB

Повторяющиеся запросы: #1 #47 #49 #51 #53 #57 #59

DELETE 

  FROM `p0b48_session`

  WHERE `time` < '1545167935'

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.04 ms
updating	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.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.09 ms После последнего запроса: 0.09 ms Память запроса: 0.027 MB Память до запроса: 5.717 MB Выбрано строк: 1

Повторяющиеся запросы: #3 #48 #50 #52 #54 #58 #60

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = 'c7ad7a249538f45ded1f37edd1ad5361' 
  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.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.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
19	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
18	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
17	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
16	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
15	JApplicationSite->__construct()	JROOT/components/com_joomleague/helpers/route.php:722
14	JoomleagueHelperRoute::_findItem()	JROOT/components/com_joomleague/helpers/route.php:695
13	JoomleagueHelperRoute::buildQuery()	JROOT/components/com_joomleague/helpers/route.php:311
12	JoomleagueHelperRoute::getPlayerRoute()	JROOT/modules/mod_joomleague_birthday/tmpl/default.php:40
11	require JROOT/modules/mod_joomleague_birthday/tmpl/default.php	JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php:18
10	include JROOT/modules/mod_joomleague_birthday/mod_joomleague_birthday.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
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.21 ms После последнего запроса: 0.59 ms Память запроса: 0.009 MB Память до запроса: 5.738 MB

ЛИГА

РХЛ

КАЛЕНДАРЬ

ДИВИЗИОНЫ

МЕДИА

ЭКСКЛЮЗИВ

УЧАСТНИКИ

ТУРНИРЫ

Партнёры

ДНИ РОЖДЕНИЯ

Наши команды

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

Сессия

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

Время

Память

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

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

61 SQL-запросов зафиксировано 57.12 ms

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