Performance Profiling

Total processing time: 39 ms; Peak memory: 2.240 MB. Show Profiling Timeline

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

Time	Duration	Category	Info

08:34:31.108	1.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tournamentTeamPosition`
08:34:31.094	1.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `league`
08:34:31.099	1.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `season`
08:34:31.103	1.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tournament`
08:34:31.092	1.1 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=mobileapi
08:34:31.117	0.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `team`
08:34:31.096	0.9 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'
08:34:31.110	0.9 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'
08:34:31.105	0.9 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'
08:34:31.101	0.8 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'
08:34:31.118	0.6 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'
08:34:31.107	0.5 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
08:34:31.112	0.3 ms	yii\db\Command::query	SELECT * FROM `league`
08:34:31.113	0.3 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=1
08:34:31.115	0.3 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=2
08:34:31.102	0.2 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
08:34:31.097	0.2 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1
08:34:31.106	0.2 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `leagueId`=1
08:34:31.099	0.2 ms	yii\db\Command::query	SELECT * FROM `season` ORDER BY `createdAt` DESC
08:34:31.098	0.2 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1
08:34:31.116	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=3
08:34:31.120	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=38
08:34:31.119	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=5
08:34:31.120	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=10
08:34:31.120	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=6
08:34:31.121	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=14
08:34:31.116	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=4
08:34:31.117	0.1 ms	yii\db\Command::query	SELECT * FROM `season` ORDER BY `createdAt` DESC
08:34:31.123	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=7
08:34:31.122	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=43
08:34:31.122	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=13
08:34:31.121	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=8
08:34:31.122	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=1
08:34:31.123	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=15
08:34:31.123	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=12
08:34:31.121	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=17
08:34:31.121	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=9
08:34:31.124	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=57
08:34:31.123	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=11