Performance Profiling

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

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

Time	Duration	Category	Info

08:53:52.506	0.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `league`
08:53:52.505	0.5 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=mobileapi
08:53:52.509	0.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tournamentTeamPosition`
08:53:52.512	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `team`
08:53:52.508	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `tournament`
08:53:52.507	0.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `season`
08:53:52.509	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 = 'tournament' AND kcu.table_name = 'tournament'
08:53:52.510	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 = 'tournamentTeamPosition' AND kcu.table_name = 'tournamentTeamPosition'
08:53:52.506	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 = 'league' AND kcu.table_name = 'league'
08:53:52.512	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'
08:53:52.508	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'
08:53:52.507	0.1 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1
08:53:52.513	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=14
08:53:52.507	0.1 ms	yii\db\Command::query	SELECT * FROM `season` ORDER BY `createdAt` DESC
08:53:52.510	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=1
08:53:52.511	0.1 ms	yii\db\Command::query	SELECT * FROM `season` ORDER BY `createdAt` DESC
08:53:52.512	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=5
08:53:52.507	0.1 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1
08:53:52.510	0.1 ms	yii\db\Command::query	SELECT * FROM `league`
08:53:52.509	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
08:53:52.509	0.1 ms	yii\db\Command::query	SELECT * FROM `league` WHERE `leagueId`=1
08:53:52.511	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=3
08:53:52.512	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=10
08:53:52.513	0.1 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=6
08:53:52.511	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=4
08:53:52.511	0.1 ms	yii\db\Command::query	SELECT * FROM `tournament` WHERE `leagueId`=2
08:53:52.508	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
08:53:52.513	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=38
08:53:52.513	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=17
08:53:52.513	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=13
08:53:52.514	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=7
08:53:52.514	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=12
08:53:52.513	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=9
08:53:52.514	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=57
08:53:52.513	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=8
08:53:52.513	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=43
08:53:52.513	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=1
08:53:52.514	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=11
08:53:52.514	0.0 ms	yii\db\Command::query	SELECT * FROM `team` WHERE `teamId`=15