Total processing time: 210 ms; Peak memory: 9.815 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
13:43:48.692 | 4.1 ms | yii\db\Command::query | →SELECT * FROM `classify` |
13:43:48.599 | 2.5 ms | yii\db\Connection::open | Opening DB connection: mysql:host=mysql-teach;dbname=teach_exam |
13:43:48.602 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `exam` |
13:43:48.700 | 1.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='31' ORDER BY `sort` |
13:43:48.621 | 1.5 ms | yii\db\Command::query | SELECT * FROM `paper` ORDER BY `updated_at` DESC |
13:43:48.633 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `paper` |
13:43:48.615 | 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' |
13:43:48.708 | 0.8 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='28' |
13:43:48.701 | 0.8 ms | yii\db\Command::query | →SHOW FULL COLUMNS FROM `paper_question` |
13:43:48.706 | 0.8 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='29' ORDER BY `sort` |
13:43:48.737 | 0.8 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='3' ORDER BY `sort` |
13:43:48.713 | 0.8 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='24' ORDER BY `sort` |
13:43:48.710 | 0.8 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='26' ORDER BY `sort` |
13:43:48.707 | 0.8 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='28' ORDER BY `sort` |
13:43:48.702 | 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_question' AND `kcu`.`TABLE_NAME` = 'paper_question' |
13:43:48.697 | 0.7 ms | yii\db\Command::query | →SHOW FULL COLUMNS FROM `classify` |
13:43:48.715 | 0.7 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='23' ORDER BY `sort` |
13:43:48.716 | 0.7 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='22' ORDER BY `sort` |
13:43:48.718 | 0.7 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='19' ORDER BY `sort` |
13:43:48.709 | 0.7 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='27' ORDER BY `sort` |
13:43:48.705 | 0.7 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='30' |
13:43:48.710 | 0.7 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='27' |
13:43:48.717 | 0.7 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='22' |
13:43:48.736 | 0.7 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='4' |
13:43:48.634 | 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' |
13:43:48.703 | 0.7 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='31' |
13:43:48.732 | 0.7 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='8' |
13:43:48.714 | 0.6 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='24' |
13:43:48.711 | 0.6 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='26' |
13:43:48.727 | 0.6 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='13' |
13:43:48.697 | 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` = 'classify' AND `kcu`.`TABLE_NAME` = 'classify' |
13:43:48.620 | 0.6 ms | yii\db\Command::query | SELECT * FROM `exam` WHERE `id`=0 |
13:43:48.704 | 0.6 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='30' ORDER BY `sort` |
13:43:48.712 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='25' ORDER BY `sort` |
13:43:48.741 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `classify` WHERE `user_id`='78' |
13:43:48.732 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='7' ORDER BY `sort` |
13:43:48.727 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='12' ORDER BY `sort` |
13:43:48.733 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='6' ORDER BY `sort` |
13:43:48.721 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='18' ORDER BY `sort` |
13:43:48.723 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='17' ORDER BY `sort` |
13:43:48.735 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='4' ORDER BY `sort` |
13:43:48.725 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='14' ORDER BY `sort` |
13:43:48.720 | 0.5 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='20' ORDER BY `sort` |
13:43:48.719 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='21' ORDER BY `sort` |
13:43:48.738 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='3' |
13:43:48.739 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='1' ORDER BY `sort` |
13:43:48.722 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='16' ORDER BY `sort` |
13:43:48.724 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='15' ORDER BY `sort` |
13:43:48.734 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='5' ORDER BY `sort` |
13:43:48.728 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='11' ORDER BY `sort` |
13:43:48.718 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='19' |
13:43:48.738 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='2' ORDER BY `sort` |
13:43:48.729 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='10' ORDER BY `sort` |
13:43:48.726 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='13' ORDER BY `sort` |
13:43:48.716 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='23' |
13:43:48.731 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='8' ORDER BY `sort` |
13:43:48.707 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='29' |
13:43:48.724 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='17' |
13:43:48.730 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `paper_question` WHERE `paper_id`='9' ORDER BY `sort` |
13:43:48.713 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='25' |
13:43:48.728 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='12' |
13:43:48.739 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='2' |
13:43:48.725 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='15' |
13:43:48.730 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='10' |
13:43:48.733 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='7' |
13:43:48.734 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='6' |
13:43:48.720 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='21' |
13:43:48.722 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='18' |
13:43:48.726 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='14' |
13:43:48.740 | 0.4 ms | yii\db\Command::query | →SELECT * FROM `classify` |
13:43:48.740 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='1' |
13:43:48.729 | 0.4 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='11' |
13:43:48.735 | 0.3 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='5' |
13:43:48.721 | 0.3 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='20' |
13:43:48.723 | 0.3 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='16' |
13:43:48.731 | 0.3 ms | yii\db\Command::query | →SELECT SUM(score) FROM `paper_question` WHERE `paper_id`='9' |