http://pms.cmet.ustc.edu.cn/applicant/project/new/36 Return to referer URL

Query Metrics

9 Database Queries
9 Different statements
2.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.31 ms
SELECT t0.role AS role_1, t0.name AS name_2, t0.id AS id_3, t0.username AS username_4, t0.admin_college_id AS admin_college_id_5, t0.user_info_id AS user_info_id_6 FROM users t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "05548"
]
2 0.18 ms
SELECT t0.type AS type_1, t0.apply_deadline AS apply_deadline_2, t0.college_deadline AS college_deadline_3, t0.id AS id_4, t0.name AS name_5, t0.open AS open_6 FROM batch t0 WHERE t0.id = ?
Parameters:
[
  "36"
]
3 0.24 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valid AS valid_2 FROM college c0_ WHERE c0_.valid = 1 AND c0_.id IN (?)
Parameters:
[
  "3"
]
4 0.18 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.valid AS valid_2 FROM property p0_ WHERE p0_.name IN (?) AND p0_.id IN (?)
Parameters:
[
  "任务书"
  "6"
]
5 0.16 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.orders AS orders_2, c0_.batch_id AS batch_id_3 FROM category c0_ WHERE c0_.batch_id = ? AND c0_.id IN (?) ORDER BY c0_.orders ASC
Parameters:
[
  36
  "441"
]
6 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.category_id AS category_id_3 FROM LEVEL t0 WHERE t0.category_id = ?
Parameters:
[
  441
]
7 0.14 ms
"START TRANSACTION"
Parameters:
[]
8 0.49 ms
INSERT INTO project (number, school_project_number, STATUS, college_sort, school_sort, doc_name, college_doc_name, name, updated_at, batch_id, user_id, subject_id, college_id, category_id, level_id, year_id, property_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2024syyj004"
  null
  "新申请"
  0
  0
  "6859f7562b27e897492125.doc"
  null
  "量子信息科学虚拟仿真实验课程体系建设研究"
  "2025-06-24 08:54:46"
  36
  277
  null
  3
  441
  487
  null
  6
]
9 0.50 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\College No errors.
App\Entity\UserInfo No errors.
App\Entity\Batch No errors.
App\Entity\Notice No errors.
App\Entity\BatchCollegeAttachment No errors.
App\Entity\Category No errors.
App\Entity\Project No errors.
App\Entity\Property No errors.
App\Entity\Level No errors.
App\Entity\ProjectAttachment No errors.
App\Entity\Subject No errors.
App\Entity\Year No errors.