Performance Profiling

Total processing time: 13 ms; Peak memory: 2.225 MB. Show Profiling Timeline

Всего 39 записей.

Time	Duration	Category	Info

18:42:03.816	0.5 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=mobileapi
18:42:03.817	0.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `league`
18:42:03.819	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `season`
18:42:03.819	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tournament`
18:42:03.821	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tournamentTeamPosition`
18:42:03.823	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `team`
18:42:03.818	0.3 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'league' AND kcu.table_name = 'league'
18:42:03.820	0.2 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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' AND kcu.table_name = 'tournament'
18:42:03.819	0.2 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'season' AND kcu.table_name = 'season'
18:42:03.821	0.2 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'tournamentTeamPosition' AND kcu.table_name = 'tournamentTeamPosition'
18:42:03.823	0.2 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.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 = 'team' AND kcu.table_name = 'team'
18:42:03.822	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=2
18:42:03.822	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=1
18:42:03.823	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=5
18:42:03.821	0.1 ms	yii\db\Command::query	SELECT * FROM `league`
18:42:03.818	0.1 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1
18:42:03.818	0.1 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1
18:42:03.820	0.1 ms	yii\db\Command::query	SELECT DISTINCT * FROM `tournamentTeamPosition` WHERE `tournamentTeamPosition`.`tournamentId`=43 ORDER BY `tournamentTeamPosition`.`winCount` DESC, `tournamentTeamPosition`.`scores` DESC, `tournamentTeamPosition`.`kf1` DESC, `tournamentTeamPosition`.`kf2` DESC
18:42:03.818	0.1 ms	yii\db\Command::query	SELECT * FROM `season` ORDER BY `createdAt` DESC
18:42:03.822	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=3
18:42:03.822	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=4
18:42:03.823	0.1 ms	yii\db\Command::query	SELECT * FROM `season` ORDER BY `createdAt` DESC
18:42:03.819	0.0 ms	yii\db\Command::query	SELECT `tournament`.* FROM `tournament` LEFT JOIN `league` ON `tournament`.`leagueId` = `league`.`leagueId` WHERE (`tournament`.`leagueId`=1) AND (`tournament`.`type`=1) AND (`tournament`.`seasonId`=10) ORDER BY `tournamentId` DESC
18:42:03.820	0.0 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `leagueId`=1
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=10
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=13
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=38
18:42:03.825	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=7
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=9
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=17
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=12
18:42:03.825	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=57
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=1
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=6
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=14
18:42:03.825	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=15
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=43
18:42:03.824	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=8
18:42:03.825	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=11