Performance Profiling

Total processing time: 163 ms; Peak memory: 9.814 MB. Show Profiling Timeline

总计76条数据。

Time	Duration	Category	Info

10:18:04.773	2.7 ms	yii\db\Command::query	→SELECT * FROM `classify`
10:18:04.702	2.2 ms	yii\db\Connection::open	Opening DB connection: mysql:host=mysql-teach;dbname=teach_exam
10:18:04.710	1.7 ms	yii\db\Command::query	SELECT * FROM `paper` ORDER BY `updated_at` DESC
10:18:04.780	1.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='31' ORDER BY `sort`
10:18:04.704	1.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `exam`
10:18:04.713	1.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `paper`
10:18:04.790	1.0 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='26' ORDER BY `sort`
10:18:04.706	0.9 ms	yii\db\Command::query	SELECT `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` = 'exam' AND `kcu`.`TABLE_NAME` = 'exam'
10:18:04.781	0.8 ms	yii\db\Command::query	→SHOW FULL COLUMNS FROM `paper_question`
10:18:04.793	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='24' ORDER BY `sort`
10:18:04.776	0.8 ms	yii\db\Command::query	→SHOW FULL COLUMNS FROM `classify`
10:18:04.825	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='4' ORDER BY `sort`
10:18:04.821	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='6' ORDER BY `sort`
10:18:04.795	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='23' ORDER BY `sort`
10:18:04.812	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='12' ORDER BY `sort`
10:18:04.815	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='10' ORDER BY `sort`
10:18:04.798	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='19' ORDER BY `sort`
10:18:04.818	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='8' ORDER BY `sort`
10:18:04.804	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='16' ORDER BY `sort`
10:18:04.811	0.8 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='13' ORDER BY `sort`
10:18:04.823	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='5' ORDER BY `sort`
10:18:04.809	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='14' ORDER BY `sort`
10:18:04.788	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='27' ORDER BY `sort`
10:18:04.807	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='15' ORDER BY `sort`
10:18:04.829	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='1' ORDER BY `sort`
10:18:04.784	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='30' ORDER BY `sort`
10:18:04.800	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='21' ORDER BY `sort`
10:18:04.797	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='22' ORDER BY `sort`
10:18:04.801	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='20' ORDER BY `sort`
10:18:04.792	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='25' ORDER BY `sort`
10:18:04.814	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='11' ORDER BY `sort`
10:18:04.806	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='17' ORDER BY `sort`
10:18:04.820	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='7' ORDER BY `sort`
10:18:04.815	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='11'
10:18:04.828	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='2' ORDER BY `sort`
10:18:04.789	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='27'
10:18:04.817	0.7 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='9' ORDER BY `sort`
10:18:04.794	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='24'
10:18:04.715	0.7 ms	yii\db\Command::query	SELECT `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` = 'paper' AND `kcu`.`TABLE_NAME` = 'paper'
10:18:04.828	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='2'
10:18:04.805	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='16'
10:18:04.776	0.7 ms	yii\db\Command::query	→SELECT `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` = 'classify' AND `kcu`.`TABLE_NAME` = 'classify'
10:18:04.808	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='15'
10:18:04.822	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='6'
10:18:04.791	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='26'
10:18:04.819	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='8'
10:18:04.811	0.7 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='13'
10:18:04.803	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='18'
10:18:04.813	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='12'
10:18:04.800	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='21'
10:18:04.793	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='25'
10:18:04.816	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='10'
10:18:04.821	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='7'
10:18:04.831	0.6 ms	yii\db\Command::query	→SELECT * FROM `classify`
10:18:04.786	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='29'
10:18:04.796	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='23'
10:18:04.782	0.6 ms	yii\db\Command::query	→SELECT `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` = 'paper_question' AND `kcu`.`TABLE_NAME` = 'paper_question'
10:18:04.807	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='17'
10:18:04.799	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='19'
10:18:04.826	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='4'
10:18:04.810	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='14'
10:18:04.802	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='20'
10:18:04.824	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='5'
10:18:04.803	0.6 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='18' ORDER BY `sort`
10:18:04.818	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='9'
10:18:04.830	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='1'
10:18:04.787	0.6 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='28' ORDER BY `sort`
10:18:04.832	0.6 ms	yii\db\Command::query	→SELECT * FROM `classify` WHERE `user_id`='79'
10:18:04.788	0.6 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='28'
10:18:04.826	0.5 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='3' ORDER BY `sort`
10:18:04.786	0.5 ms	yii\db\Command::query	→SELECT * FROM `paper_question` WHERE `paper_id`='29' ORDER BY `sort`
10:18:04.709	0.5 ms	yii\db\Command::query	SELECT * FROM `exam` WHERE `id`=0
10:18:04.783	0.5 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='31'
10:18:04.785	0.5 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='30'
10:18:04.798	0.4 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='22'
10:18:04.827	0.4 ms	yii\db\Command::query	→SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='3'