ConfigurationLogsProfilingDatabaseEventsMailTimelineDumpRouterRequestUserAsset Bundles
Prev Next
All Latest
68796f5ea843a: GET https://playtennis.site/tournament/72 at 2025-07-18 12:47:10 am by 213.180.203.15

Log Messages

Всего 192 записи.
#TimeSince previousLevelCategoryMessage
   
100:47:10.685
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
200:47:10.685
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\queue\amqp_interop\Queue::bootstrap()
300:47:10.685
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\queue\amqp_interop\Queue::bootstrap()
400:47:10.685
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
500:47:10.685
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
600:47:10.685
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://10.0.3.77:5379, database=7
700:47:10.685
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
800:47:10.688
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
900:47:10.688
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1000:47:10.688
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
1100:47:10.689
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1200:47:10.689
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
1300:47:10.689
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1400:47:10.689
< 0ms >
traceyii\base\Application::bootstrapBootstrap with common\components\maintenance\Maintenance::bootstrap()
1500:47:10.689
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1600:47:10.689
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'tournament/index'
1700:47:10.689
< 0ms >
traceyii\base\Controller::runActionRoute to run: tournament/index
1800:47:10.690
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `seo`
1900:47:10.690
< 0ms >
infoyii\db\Connection::openOpening DB connection: mysql:host=10.0.3.77;port=3306;dbname=playtennis_dev
2000:47:10.711
< 21ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'seo' AND `kcu`.`TABLE_NAME` = 'seo'
2100:47:10.712
< 1ms >
infoyii\db\Command::querySELECT * FROM `seo` WHERE `page_key`='tournament/72'
2200:47:10.713
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: frontend\controllers\TournamentController::actionIndex()
2300:47:10.713
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE (`id`='72') AND (`tournaments`.`status`=1)
2400:47:10.713
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `tournaments`
2500:47:10.715
< 1ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'tournaments' AND `kcu`.`TABLE_NAME` = 'tournaments'
2600:47:10.716
< 1ms >
infoyii\db\Command::querySELECT * FROM `request_tournament` WHERE `tournament_id`=72 ORDER BY `request_tournament`.`created_at` DESC
2700:47:10.717
< 0ms >
infoyii\db\Command::querySELECT `id` FROM `stage` ORDER BY `priority` DESC, `name`
2800:47:11.201
< 484ms >
traceyii\web\AssetConverter::runCommandConverted scss/main.scss into scss/main.min.css: STDOUT: STDERR:
2900:47:11.202
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments_has_profiles` WHERE (`position`=1) AND (`tournament_id`=72)
3000:47:11.203
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `tournaments_has_profiles`
3100:47:11.204
< 1ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'tournaments_has_profiles' AND `kcu`.`TABLE_NAME` = 'tournaments_has_profiles'
3200:47:11.205
< 1ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=211
3300:47:11.205
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `user`
3400:47:11.207
< 1ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'user' AND `kcu`.`TABLE_NAME` = 'user'
3500:47:11.208
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3600:47:11.209
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_gallery` WHERE `tournament_id`=72 ORDER BY `tournament_gallery`.`order`
3700:47:11.211
< 1ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `tournament_gallery`
3800:47:11.212
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'tournament_gallery' AND `kcu`.`TABLE_NAME` = 'tournament_gallery'
3900:47:11.213
< 1ms >
infoyii\db\Command::querySELECT `player_id`, max(created_at) AS `created_at`, max(id) AS `id` FROM `list_invited_players` WHERE `tournament_id`=72 GROUP BY `player_id`
4000:47:11.213
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments_has_profiles` WHERE `tournament_id`=72
4100:47:11.214
< 0ms >
infoyii\db\Command::querySELECT * FROM `list_invited_players` WHERE (0=1) AND (`player_id` NOT IN (35, 36, 38, 61, 189, 211)) AND (`player_id` NOT IN (SELECT `user_id` FROM `request_tournament` WHERE `tournament_id`=72))
4200:47:11.214
< 0ms >
infoyii\db\Command::querySELECT * FROM `age_category` WHERE `id`=5
4300:47:11.214
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `age_category`
4400:47:11.215
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'age_category' AND `kcu`.`TABLE_NAME` = 'age_category'
4500:47:11.216
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE (`user`.`birth_date` IS NOT NULL) AND (`status`=2) AND (`birth_date` >= '2014-07-18')
4600:47:11.218
< 2ms >
infoyii\db\Command::querySELECT * FROM `age_category` WHERE `id` IN (2, 1, 7, 5, 4, 10)
4700:47:11.219
< 1ms >
infoyii\db\Command::querySELECT EXISTS(SELECT * FROM `tournaments` WHERE (`id`='72') AND (`type`=1))
4800:47:11.219
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4900:47:11.219
< 0ms >
infoyii\db\Command::querySELECT * FROM `key_storage_item` WHERE `key`='group-stage-id'
5000:47:11.220
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `key_storage_item`
5100:47:11.221
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'key_storage_item' AND `kcu`.`TABLE_NAME` = 'key_storage_item'
5200:47:11.221
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
5300:47:11.221
< 0ms >
infoyii\db\Command::querySELECT * FROM `stage` WHERE `scheme_id`='1' ORDER BY `name`
5400:47:11.222
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments_has_profiles` WHERE (`tournament_id`='72') AND (`stage_id`=1) ORDER BY `position_group`
5500:47:11.222
< 0ms >
infoyii\db\Command::querySELECT `id` FROM `user` WHERE `id` IN (38, 61, 35) ORDER BY `first_name`
5600:47:11.222
< 0ms >
infoyii\db\Command::querySELECT `id`, (case when first_player_id != 61 then first_player_id when second_player_id != 61 then second_player_id END) AS `opponentId` FROM `tournament_stage_games` WHERE ((`tournament_id`='72') AND (`use_stage_id`=1)) AND ((`tournament_stage_games`.`first_player_id`=61) OR (`tournament_stage_games`.`second_player_id`=61)) AND (((`result` != '') AND (`result` IS NOT NULL)) OR (`early_result` IS NOT NULL)) ORDER BY field (opponentId,61,35,38)
5700:47:11.223
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=674
5800:47:11.223
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `tournament_stage_games`
5900:47:11.224
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'tournament_stage_games' AND `kcu`.`TABLE_NAME` = 'tournament_stage_games'
6000:47:11.225
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=61
6100:47:11.225
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=35
6200:47:11.225
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
6300:47:11.226
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=672
6400:47:11.226
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=38
6500:47:11.226
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=61
6600:47:11.226
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
6700:47:11.227
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=61
6800:47:11.227
< 0ms >
infoyii\db\Command::querySELECT `id`, (case when first_player_id != 35 then first_player_id when second_player_id != 35 then second_player_id END) AS `opponentId` FROM `tournament_stage_games` WHERE ((`tournament_id`='72') AND (`use_stage_id`=1)) AND ((`tournament_stage_games`.`first_player_id`=35) OR (`tournament_stage_games`.`second_player_id`=35)) AND (((`result` != '') AND (`result` IS NOT NULL)) OR (`early_result` IS NOT NULL)) ORDER BY field (opponentId,61,35,38)
6900:47:11.227
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=674
7000:47:11.227
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=61
7100:47:11.228
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=35
7200:47:11.228
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
7300:47:11.228
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=669
7400:47:11.228
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=35
7500:47:11.229
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=38
7600:47:11.229
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
7700:47:11.229
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=35
7800:47:11.229
< 0ms >
infoyii\db\Command::querySELECT `id`, (case when first_player_id != 38 then first_player_id when second_player_id != 38 then second_player_id END) AS `opponentId` FROM `tournament_stage_games` WHERE ((`tournament_id`='72') AND (`use_stage_id`=1)) AND ((`tournament_stage_games`.`first_player_id`=38) OR (`tournament_stage_games`.`second_player_id`=38)) AND (((`result` != '') AND (`result` IS NOT NULL)) OR (`early_result` IS NOT NULL)) ORDER BY field (opponentId,61,35,38)
7900:47:11.230
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=672
8000:47:11.230
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=38
8100:47:11.230
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=61
8200:47:11.230
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
8300:47:11.231
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=669
8400:47:11.231
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=35
8500:47:11.231
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=38
8600:47:11.231
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
8700:47:11.231
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=38
8800:47:11.232
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments_has_profiles` WHERE (`tournament_id`='72') AND (`stage_id`=2) ORDER BY `position_group`
8900:47:11.232
< 0ms >
infoyii\db\Command::querySELECT `id` FROM `user` WHERE `id` IN (189, 211, 36) ORDER BY `first_name`
9000:47:11.232
< 0ms >
infoyii\db\Command::querySELECT `id`, (case when first_player_id != 211 then first_player_id when second_player_id != 211 then second_player_id END) AS `opponentId` FROM `tournament_stage_games` WHERE ((`tournament_id`='72') AND (`use_stage_id`=2)) AND ((`tournament_stage_games`.`first_player_id`=211) OR (`tournament_stage_games`.`second_player_id`=211)) AND (((`result` != '') AND (`result` IS NOT NULL)) OR (`early_result` IS NOT NULL)) ORDER BY field (opponentId,211,189,36)
9100:47:11.233
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=670
9200:47:11.233
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=211
9300:47:11.233
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=189
9400:47:11.233
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
9500:47:11.234
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=671
9600:47:11.234
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=211
9700:47:11.234
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=36
9800:47:11.234
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
9900:47:11.235
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=211
10000:47:11.235
< 0ms >
infoyii\db\Command::querySELECT `id`, (case when first_player_id != 189 then first_player_id when second_player_id != 189 then second_player_id END) AS `opponentId` FROM `tournament_stage_games` WHERE ((`tournament_id`='72') AND (`use_stage_id`=2)) AND ((`tournament_stage_games`.`first_player_id`=189) OR (`tournament_stage_games`.`second_player_id`=189)) AND (((`result` != '') AND (`result` IS NOT NULL)) OR (`early_result` IS NOT NULL)) ORDER BY field (opponentId,211,189,36)
10100:47:11.235
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=670
10200:47:11.235
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=211
10300:47:11.236
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=189
10400:47:11.236
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
10500:47:11.236
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=673
10600:47:11.236
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=189
10700:47:11.236
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=36
10800:47:11.237
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
10900:47:11.237
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=189
11000:47:11.237
< 0ms >
infoyii\db\Command::querySELECT `id`, (case when first_player_id != 36 then first_player_id when second_player_id != 36 then second_player_id END) AS `opponentId` FROM `tournament_stage_games` WHERE ((`tournament_id`='72') AND (`use_stage_id`=2)) AND ((`tournament_stage_games`.`first_player_id`=36) OR (`tournament_stage_games`.`second_player_id`=36)) AND (((`result` != '') AND (`result` IS NOT NULL)) OR (`early_result` IS NOT NULL)) ORDER BY field (opponentId,211,189,36)
11100:47:11.238
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=671
11200:47:11.238
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=211
11300:47:11.238
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=36
11400:47:11.238
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
11500:47:11.238
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id`=673
11600:47:11.239
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=189
11700:47:11.239
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=36
11800:47:11.239
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments` WHERE `id`=72
11900:47:11.239
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id`=36
12000:47:11.240
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments_has_profiles` WHERE (`tournament_id`='72') AND (`stage_id`=3) ORDER BY `position_group`
12100:47:11.240
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments_has_profiles` WHERE (`tournament_id`='72') AND (`stage_id`=4) ORDER BY `position_group`
12200:47:11.240
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12300:47:11.240
< 0ms >
infoyii\db\Command::querySELECT * FROM `key_storage_item` WHERE `key`='place-3-stage-id'
12400:47:11.240
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
12500:47:11.240
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12600:47:11.241
< 0ms >
infoyii\db\Command::querySELECT * FROM `key_storage_item` WHERE `key`='final-stage-id'
12700:47:11.241
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
12800:47:11.241
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12900:47:11.241
< 0ms >
infoyii\db\Command::querySELECT * FROM `key_storage_item` WHERE `key`='play-off-stage-id'
13000:47:11.241
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
13100:47:11.241
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournaments_playoff` WHERE `tour_id`='72' ORDER BY `ids`
13200:47:11.241
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `tournaments_playoff`
13300:47:11.242
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'tournaments_playoff' AND `kcu`.`TABLE_NAME` = 'tournaments_playoff'
13400:47:11.244
< 1ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE `id` IN (675, 676, 678)
13500:47:11.244
< 0ms >
infoyii\db\Command::querySELECT * FROM `stage` WHERE `id` IN (11, 13)
13600:47:11.244
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `stage`
13700:47:11.245
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'stage' AND `kcu`.`TABLE_NAME` = 'stage'
13800:47:11.246
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE (`tournament_id`='72') AND (`use_stage_id`='12')
13900:47:11.246
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/index.php
14000:47:11.246
< 0ms >
infoyii\db\Command::querySELECT * FROM `sportclub_court` WHERE 0=1
14100:47:11.246
< 0ms >
infoyii\db\Command::querySELECT EXISTS(SELECT * FROM `tournaments_has_profiles` WHERE (`tournament_id`=72) AND (`position` IS NOT NULL))
14200:47:11.247
< 0ms >
infoyii\db\Command::querySELECT EXISTS(SELECT * FROM `tournament_stage_games` WHERE (`tournament_id`=72) AND (`result` IS NOT NULL))
14300:47:11.247
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_info.php
14400:47:11.247
< 0ms >
infoyii\db\Command::querySELECT * FROM `sportclub` WHERE `id`=1
14500:47:11.247
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `sportclub`
14600:47:11.248
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'sportclub' AND `kcu`.`TABLE_NAME` = 'sportclub'
14700:47:11.249
< 1ms >
infoyii\db\Command::querySELECT * FROM `balls` WHERE `id`=3
14800:47:11.249
< 0ms >
infoyii\db\Command::querySHOW FULL COLUMNS FROM `balls`
14900:47:11.250
< 0ms >
infoyii\db\Command::querySELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'balls' AND `kcu`.`TABLE_NAME` = 'balls'
15000:47:11.251
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_has_players_double` WHERE (`position`=1) AND (`tournament_id`=72)
15100:47:11.251
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_reglament.php
15200:47:11.251
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_translation.php
15300:47:11.251
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_users.php
15400:47:11.252
< 0ms >
infoyii\db\Command::querySELECT EXISTS(SELECT * FROM `tournaments_has_profiles` WHERE (`tournament_id`=72) AND (`position` IS NOT NULL))
15500:47:11.252
< 0ms >
infoyii\db\Command::querySELECT `tournament_id`, `profile_id`, `stage_id`, Ifnull(stage_id, 9999) AS `stage_id_feik`, Ifnull(position, 9999) AS `position` FROM `tournaments_has_profiles` WHERE `tournament_id`=72 ORDER BY `position`, field (stage_id_feik, 13,12,11,10,9,8,7,6,15,1,2,3,4,5,14,9999)
15600:47:11.252
< 0ms >
infoyii\db\Command::querySELECT * FROM `user` WHERE `id` IN (211, 189, 61, 35, 38, 36)
15700:47:11.253
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
15800:47:11.253
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
15900:47:11.253
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
16000:47:11.253
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
16100:47:11.253
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
16200:47:11.253
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
16300:47:11.253
< 0ms >
infoyii\db\Command::querySELECT `id` FROM `stage` ORDER BY `priority` DESC, `name`
16400:47:11.253
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_stage_games` WHERE (`tournament_stage_games`.`use_stage_id` IS NOT NULL) AND (`match_id` IS NULL) AND (`result` IS NOT NULL) AND (`tournament_id`=72) ORDER BY field (use_stage_id, 13,12,11,10,9,8,7,6,15,1,2,3,4,5,14)
16500:47:11.254
< 0ms >
infoyii\db\Command::querySELECT * FROM `stage` WHERE `id` IN (13, 12, 11, 1, 2)
16600:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_results_group.php
16700:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_group/_item_single.php
16800:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
16900:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
17000:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
17100:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_group/_item_single_results.php
17200:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_group/_item_single.php
17300:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
17400:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
17500:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/widgets/views/avatar.php
17600:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_group/_item_single_results.php
17700:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_results_play_off.php
17800:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_results_matches_section.php
17900:47:11.254
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_users.php
18000:47:11.254
< 0ms >
infoyii\db\Command::querySELECT EXISTS(SELECT * FROM `tournaments_has_profiles` WHERE (`tournament_id`=72) AND (`position` IS NOT NULL))
18100:47:11.255
< 0ms >
infoyii\db\Command::querySELECT `created_at` FROM `tournament_gallery` WHERE `tournament_id`=72 ORDER BY `created_at` DESC
18200:47:11.255
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_gallery.php
18300:47:11.255
< 0ms >
infoyii\db\Command::querySELECT * FROM `tournament_gallery` WHERE `tournament_id`=72 ORDER BY `tournament_gallery`.`order` DESC
18400:47:11.256
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/tournament/_contacts.php
18500:47:11.256
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/layouts/main.php
18600:47:11.256
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/layouts/base.php
18700:47:11.256
< 0ms >
infoyii\db\Command::querySELECT * FROM `seo` WHERE `page_key`='home'
18800:47:11.256
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/_parts/header.php
18900:47:11.256
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/_parts/footer.php
19000:47:11.256
< 0ms >
traceyii\base\View::renderFileRendering view file: /var/www/playtennis.site/frontend/views/layouts/_clear.php
19100:47:11.256
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19200:47:11.257
< 0ms >
infoyii\web\Session::openSession started