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

Партнёры

Наши команды

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

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1540221242,
                "last": 1540221242,
                "now": 1540221242
            },
            "token": "fueN6631oXuCiXje3Jsjf13kanDYa7ht"
        },
        "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.50 ms / 10.50 ms Память: 0.067 MB / 0.41 MB Application: afterLoad

Время: 60.81 ms / 71.31 ms Память: 2.775 MB / 3.18 MB Application: afterInitialise

Время: 40.73 ms / 112.04 ms Память: 3.105 MB / 6.28 MB Application: Before JAccess::preloadComponents (all components)

Время: 0.79 ms / 112.84 ms Память: 0.057 MB / 6.34 MB Application: After JAccess::preloadComponents (all components)

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

Время: 0.85 ms / 113.72 ms Память: 0.027 MB / 6.37 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Время: 16.33 ms / 130.05 ms Память: 0.514 MB / 6.88 MB Application: afterRoute

Время: 1.59 ms / 131.64 ms Память: 0.013 MB / 6.89 MB Application: beforeRenderComponent com_joomleague

Время: 78.62 ms / 210.26 ms Память: 2.810 MB / 9.70 MB Application: afterRenderComponent com_joomleague

Время: 2.82 ms / 213.08 ms Память: 0.122 MB / 9.82 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

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

Время: 6.82 ms / 219.96 ms Память: 0.159 MB / 9.99 MB Application: afterDispatch

Время: 119.14 ms / 339.10 ms Память: 2.035 MB / 12.02 MB Application: beforeRenderModule mod_breadcrumbs (Навигатор по сайту)

Время: 18.04 ms / 357.14 ms Память: 0.904 MB / 12.93 MB Application: afterRenderModule mod_breadcrumbs (Навигатор по сайту)

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

Время: 8.52 ms / 365.77 ms Память: 0.039 MB / 12.97 MB Application: afterRenderModule mod_stcarousel (Наши команды)

Время: 1.50 ms / 367.27 ms Память: 0.017 MB / 12.99 MB Application: beforeRenderModule mod_joomleague_birthday (ДНИ РОЖДЕНИЯ)

Время: 212.39 ms / 579.66 ms Память: 0.324 MB / 13.31 MB Application: afterRenderModule mod_joomleague_birthday (ДНИ РОЖДЕНИЯ)

Время: 19.97 ms / 599.63 ms Память: 0.292 MB / 13.60 MB Application: afterRender

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

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

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

51 SQL-запросов зафиксировано 223.35 ms

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

11 повторов: #2 #42 #43 #44 #45 #46 #47 #48 #49 #50 #51

11 повторов: #10 #11 #12 #13 #14 #15 #16 #19 #22 #34 #35

2 повторов: #28 #30

2 повторов: #29 #31

Время запроса: 0.41 ms Память запроса: 0.025 MB Память до запроса: 0.741 MB Выбрано строк: 0

SELECT `data`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2'

План 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.03 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.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.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.25 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.87 ms Память запроса: 0.021 MB Память до запроса: 0.757 MB Выбрано строк: 0

Повторяющиеся запросы: #42 #43 #44 #45 #46 #47 #48 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.01 ms
init	0.01 ms
checking query cache for query	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.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	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.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.07 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.66 ms После последнего запроса: 0.11 ms Память запроса: 0.003 MB Память до запроса: 0.762 MB

INSERT INTO `p0b48_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('082b2cda628bb533842470d0bb0adec2', 1, '1540221242', 0, '', 0)

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

EXPLAIN не доступен для запроса: INSERT INTO `p0b48_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('082b2cda628bb533842470d0bb0adec2', 1, '1540221242', 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.00 ms
Table lock	0.00 ms
init	0.01 ms
update	0.07 ms
Waiting for query cache lock	0.01 ms
update	0.27 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.29 ms После последнего запроса: 4.87 ms Память запроса: 0.023 MB Память до запроса: 0.929 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.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.05 ms
sending cached result to clien	0.02 ms
updating status	0.00 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.19 ms После последнего запроса: 0.10 ms Память запроса: 0.023 MB Память до запроса: 0.942 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.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.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 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 для получения ссылок на файлы]

Время запроса: 1.06 ms После последнего запроса: 10.42 ms Память запроса: 0.022 MB Память до запроса: 1.392 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.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.45 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.19 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.66 ms После последнего запроса: 18.32 ms Память запроса: 0.024 MB Память до запроса: 2.369 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.03 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.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 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.10 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:95
14	JComponentHelper::isInstalled()	JROOT/libraries/regularlabs/src/Parameters.php:136
13	RegularLabs\Library\Parameters->getComponentParams()	JROOT/plugins/system/advancedmodules/src/Params.php:29
12	RegularLabs\Plugin\System\AdvancedModules\Params::get()	JROOT/plugins/system/advancedmodules/src/Helper.php:22
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterInitialise()	Так же, как вызов в строке ниже.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:59
8	PlgSystemAdvancedModules->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.50 ms После последнего запроса: 50.33 ms Память запроса: 0.031 MB Память до запроса: 6.289 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_dropfiles','com_fields','com_finder','com_installer','com_joomlaupdate','com_joomleague','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.14 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

Стек вызовов

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

UPDATE `p0b48_extensions`

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

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

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

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

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

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

Стек вызовов

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

Повторяющиеся запросы: #11 #12 #13 #14 #15 #16 #19 #22 #34 #35

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.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.37 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_joomleague/helpers/joomleaguehelper.php:310
10	JoomleagueHelper::getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:42
9	JoomleagueHelperExtensioncontroller->getExtensions()	JROOT/components/com_joomleague/helpers/extensioncontroller.php:53
8	JoomleagueHelperExtensioncontroller->initExtensions()	JROOT/components/com_joomleague/assets/classes/jlgcontroller.php:93
7	JLGController::getInstance()	JROOT/components/com_joomleague/joomleague.php:28
6	require_once JROOT/components/com_joomleague/joomleague.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Повторяющиеся запросы: #10 #12 #13 #14 #15 #16 #19 #22 #34 #35

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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

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

Повторяющиеся запросы: #10 #11 #13 #14 #15 #16 #19 #22 #34 #35

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.00 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: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.19 ms После последнего запроса: 0.43 ms Память запроса: 0.024 MB Память до запроса: 8.184 MB Выбрано строк: 1

Повторяющиеся запросы: #10 #11 #12 #14 #15 #16 #19 #22 #34 #35

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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.19 ms После последнего запроса: 2.99 ms Память запроса: 0.026 MB Память до запроса: 8.438 MB Выбрано строк: 1

Повторяющиеся запросы: #10 #11 #12 #13 #15 #16 #19 #22 #34 #35

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.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

Стек вызовов

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

Повторяющиеся запросы: #10 #11 #12 #13 #14 #16 #19 #22 #34 #35

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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

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

Повторяющиеся запросы: #10 #11 #12 #13 #14 #15 #19 #22 #34 #35

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.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/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.55 ms После последнего запроса: 2.76 ms Память запроса: 0.027 MB Память до запроса: 8.700 MB Выбрано строк: 1

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

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.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.02 ms
init	0.03 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.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.01 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.40 ms
cleaning up	0.01 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.79 ms После последнего запроса: 0.07 ms Память запроса: 0.038 MB Память до запроса: 8.711 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.08 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.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Стек вызовов

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

Повторяющиеся запросы: #10 #11 #12 #13 #14 #15 #16 #22 #34 #35

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

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

Стек вызовов

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

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

Время запроса: 0.72 ms После последнего запроса: 0.48 ms Память запроса: 0.025 MB Память до запроса: 9.122 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.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.21 ms
cleaning up	0.01 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.63 ms После последнего запроса: 0.20 ms Память запроса: 0.039 MB Память до запроса: 9.129 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.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
Unlocking tables	0.01 ms
executing	0.00 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.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.16 ms После последнего запроса: 4.70 ms Память запроса: 0.025 MB Память до запроса: 9.203 MB Выбрано строк: 1

Повторяющиеся запросы: #10 #11 #12 #13 #14 #15 #16 #19 #34 #35

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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.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.54 ms После последнего запроса: 0.39 ms Память запроса: 0.024 MB Память до запроса: 9.208 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.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.00 ms
Waiting for query cache lock	0.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.21 ms
cleaning up	0.01 ms

Стек вызовов

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

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

Время запроса: 0.46 ms После последнего запроса: 0.18 ms Память запроса: 0.029 MB Память до запроса: 9.214 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.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Unlocking tables	0.01 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.01 ms
updating status	0.00 ms
storing result in query cache	0.19 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.41 ms После последнего запроса: 0.08 ms Память запроса: 0.029 MB Память до запроса: 9.227 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.00 ms
init	0.00 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.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.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.44 ms
Copying to tmp table	0.04 ms
Sorting result	0.07 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.10 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.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.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.63 ms После последнего запроса: 0.07 ms Память запроса: 0.027 MB Память до запроса: 9.233 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.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.03 ms
Copying to tmp table	0.02 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.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: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.48 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 9.239 MB Выбрано строк: 0

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

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 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.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.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
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.09 ms
cleaning up	0.01 ms

Стек вызовов

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

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

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

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

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

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.01 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.04 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.28 ms
Copying to tmp table	0.03 ms
Sorting result	0.05 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.08 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.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/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.46 ms После последнего запроса: 0.08 ms Память запроса: 0.026 MB Память до запроса: 9.464 MB Выбрано строк: 0

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

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

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.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.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.21 ms После последнего запроса: 0.11 ms Память запроса: 0.027 MB Память до запроса: 9.471 MB Выбрано строк: 0

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

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

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.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.00 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.26 ms После последнего запроса: 0.08 ms Память запроса: 0.026 MB Память до запроса: 9.479 MB Выбрано строк: 0

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

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

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.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.02 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.25 ms После последнего запроса: 0.08 ms Память запроса: 0.029 MB Память до запроса: 9.487 MB Выбрано строк: 0

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

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

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

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.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.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.40 ms
Copying to tmp table	0.03 ms
Sorting result	0.05 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.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.21 ms После последнего запроса: 0.76 ms Память запроса: 0.025 MB Память до запроса: 9.537 MB Выбрано строк: 0

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

  FROM p0b48_joomleague_version

  ORDER BY date DESC 
  LIMIT 1

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

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

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

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.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.24 ms После последнего запроса: 14.69 ms Память запроса: 0.024 MB Память до запроса: 9.752 MB Выбрано строк: 1

Повторяющиеся запросы: #10 #11 #12 #13 #14 #15 #16 #19 #22 #35

SELECT extension

  FROM p0b48_joomleague_project

  WHERE id='31'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.60 ms После последнего запроса: 1.15 ms Память запроса: 0.027 MB Память до запроса: 9.791 MB Выбрано строк: 1

Повторяющиеся запросы: #10 #11 #12 #13 #14 #15 #16 #19 #22 #34

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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
updating status	0.00 ms
cleaning up	0.00 ms

Стек вызовов

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

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

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

SELECT * 
  FROM p0b48_template_styles 
  WHERE template = 'fitness_center';

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

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

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

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
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.22 ms После последнего запроса: 0.13 ms Память запроса: 0.029 MB Память до запроса: 10.238 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.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
10	JDatabaseDriver->loadAssocList()	JROOT/templates/fitness_center/vertex/parameters.php:40
9	getTemplateName()	JROOT/templates/fitness_center/vertex/parameters.php:167
8	require_once JROOT/templates/fitness_center/vertex/parameters.php	JROOT/templates/fitness_center/index.php:21
7	require JROOT/templates/fitness_center/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 5.91 ms После последнего запроса: 8.90 ms Память запроса: 0.301 MB Память до запроса: 10.533 MB Выбрано строк: 103

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	107	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.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.06 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	1.10 ms
Sending data	0.33 ms
Waiting for query cache lock	0.01 ms
Sending data	0.32 ms
Waiting for query cache lock	0.01 ms
Sending data	0.17 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.34 ms
Waiting for query cache lock	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.30 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.14 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.20 ms
Waiting for query cache lock	0.01 ms
Sending data	0.10 ms
Waiting for query cache lock	0.01 ms
Sending data	0.79 ms
Waiting for query cache lock	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.04 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.01 ms
cleaning up	0.01 ms

Стек вызовов

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

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

Время запроса: 0.26 ms После последнего запроса: 89.63 ms Память запроса: 0.036 MB Память до запроса: 12.963 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.05 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.02 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 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 для получения ссылок на файлы]

Время запроса: 194.79 ms После последнего запроса: 40.41 ms Память запроса: 0.033 MB Память до запроса: 13.047 MB Выбрано строк: 10

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,38,37,36,35,34,33,31,29,28,27,26,25,22,21,20,17,16,15,14,13,12,10,9,7,6,4,3,2,1)  
  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	p	ALL	PRIMARY	Индекс не используется	NULL	NULL	3136	Using where; Using temporary; Используется filesort
1	SIMPLE	tp	ref	projectteam_id,person_id	person_id	5	u230557_rhlnn.p.id	1	Using where
1	SIMPLE	pt	eq_ref	PRIMARY,combi,project_id	PRIMARY	4	u230557_rhlnn.tp.projectteam_id	1	Using where

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

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.29 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.14 ms
optimizing	0.06 ms
statistics	0.40 ms
preparing	0.08 ms
executing	0.01 ms
Creating tmp table	0.05 ms
Copying to tmp table	192.02 ms
Sorting result	0.74 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.51 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 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.94 ms После последнего запроса: 0.22 ms Память запроса: 0.028 MB Память до запроса: 13.088 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,376,477,2604,303,1180,2517,1466,1418,114,704)  
  AND pt.project_id IN (44,43,42,41,38,37,36,35,34,33,31,29,28,27,26,25,22,21,20,17,16,15,14,13,12,10,9,7,6,4,3,2,1)  
  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	32	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.01 ms
init	0.01 ms
checking query cache for query	0.17 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.00 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.03 ms
statistics	0.29 ms
preparing	0.11 ms
executing	0.01 ms
Creating tmp table	0.04 ms
Copying to tmp table	0.78 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 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.02 ms
cleaning up	0.00 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.53 ms После последнего запроса: 1.90 ms Память запроса: 0.027 MB Память до запроса: 13.127 MB Выбрано строк: 1

Повторяющиеся запросы: #2 #43 #44 #45 #46 #47 #48 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 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.11 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

Стек вызовов

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

Повторяющиеся запросы: #2 #42 #44 #45 #46 #47 #48 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.08 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.02 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.17 ms После последнего запроса: 0.71 ms Память запроса: 0.027 MB Память до запроса: 13.174 MB Выбрано строк: 1

Повторяющиеся запросы: #2 #42 #43 #45 #46 #47 #48 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

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

Повторяющиеся запросы: #2 #42 #43 #44 #46 #47 #48 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.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.02 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.13 ms После последнего запроса: 0.70 ms Память запроса: 0.027 MB Память до запроса: 13.218 MB Выбрано строк: 1

Повторяющиеся запросы: #2 #42 #43 #44 #45 #47 #48 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 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.14 ms После последнего запроса: 0.77 ms Память запроса: 0.027 MB Память до запроса: 13.242 MB Выбрано строк: 1

Повторяющиеся запросы: #2 #42 #43 #44 #45 #46 #48 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Стек вызовов

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

Повторяющиеся запросы: #2 #42 #43 #44 #45 #46 #47 #49 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.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.12 ms После последнего запроса: 0.93 ms Память запроса: 0.027 MB Память до запроса: 13.287 MB Выбрано строк: 1

Повторяющиеся запросы: #2 #42 #43 #44 #45 #46 #47 #48 #50 #51

SELECT `session_id`

  FROM `p0b48_session`

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

Стек вызовов

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

Повторяющиеся запросы: #2 #42 #43 #44 #45 #46 #47 #48 #49 #51

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  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.01 ms
init	0.07 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

Стек вызовов

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

Повторяющиеся запросы: #2 #42 #43 #44 #45 #46 #47 #48 #49 #50

SELECT `session_id`

  FROM `p0b48_session`

  WHERE `session_id` = '082b2cda628bb533842470d0bb0adec2' 
  LIMIT 1

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

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

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

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

Стек вызовов

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

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

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

11 × SELECT extension 
  FROM p0b48_joomleague_project

11 × SELECT `session_id` 
  FROM `p0b48_session`

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

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

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

1 × SELECT `data` 
  FROM `p0b48_session`

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

1 × SELECT p.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

1 × SELECT * 
  FROM p0b48_datsogallery_setting

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

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

1 × SELECT * 
  FROM p0b48_template_styles

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

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

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

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

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

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

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

1 × SELECT pt.id        
  FROM p0b48_joomleague_project_team AS pt

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

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

1 × SELECT `enabled` 
  FROM `p0b48_extensions`

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

1 × SELECT id, rules 
  FROM `p0b48_viewlevels

1 × SELECT 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

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

1 × INSERT INTO `p0b48_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('082b2cda628bb533842470d0bb0adec2', 1, '1540221242', 0, '', 0

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

	Александр Пахомов 22 октября 2018
	Максим Щербаков 22 октября 2018
	Александр Макеев 22 октября 2018
	Александр Щербаков 22 октября 2018
	Борис Сиднев 23 октября 2018
	Борис Сиднев 23 октября 2018
	Николай Кондалов 23 октября 2018
	Алексей Бурин 23 октября 2018
	Орест Шевченко 23 октября 2018
	Андрей Новичков 23 октября 2018

ЛИГА

РХЛ

ТАБЛИЦЫ

КАЛЕНДАРЬ

ДИВИЗИОНЫ

МЕДИА

ЭКСКЛЮЗИВ

УЧАСТНИКИ

ТУРНИРЫ

Партнёры

ДНИ РОЖДЕНИЯ

Наши команды

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

Сессия

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

Время

Память

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

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

51 SQL-запросов зафиксировано 223.35 ms

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

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

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

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