http://pms.cmet.ustc.edu.cn/

Query Metrics

4 Database Queries
4 Different statements
1.22 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.44 ms
(35.96%)
1
SELECT b0_.type AS type_0, b0_.apply_deadline AS apply_deadline_1, b0_.college_deadline AS college_deadline_2, b0_.id AS id_3, b0_.name AS name_4, b0_.open AS open_5 FROM batch b0_ WHERE b0_.open <= ? AND b0_.apply_deadline >= ? ORDER BY b0_.open DESC
Parameters:
[
  "2025-06-27 00:00:00"
  "2025-06-27 00:00:00"
]
0.36 ms
(29.15%)
1
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.content AS content_2, a0_.published_at AS published_at_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.valid AS valid_6 FROM announcement a0_ WHERE a0_.valid = 1 ORDER BY a0_.published_at DESC LIMIT 10
Parameters:
[]
0.23 ms
(18.84%)
1
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:
[
  "05824"
]
0.20 ms
(16.05%)
1
SELECT t0.current AS current_1, t0.id AS id_2, t0.name AS name_3 FROM review_batch t0 WHERE t0.current = ? LIMIT 1
Parameters:
[
  1
]

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\Batch No errors.
App\Entity\Announcement No errors.
App\Entity\AnnouncementAttachment No errors.
App\Entity\ReviewBatch No errors.
App\Entity\User No errors.
App\Entity\College No errors.
App\Entity\UserInfo No errors.