http://pms.cmet.ustc.edu.cn/super/batch-college-attachment/list/30

Query Metrics

7 Database Queries
6 Different statements
64.84 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 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:
[
  "10116"
]
2 0.43 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:
[
  "30"
]
3 62.65 ms
SELECT b0_.attachment_name AS attachment_name_0, b0_.id AS id_1, b0_.name AS name_2, c1_.id AS id_3, c1_.name AS name_4, c1_.valid AS valid_5, b0_.batch_id AS batch_id_6, b0_.college_id AS college_id_7 FROM batch_college_attachment b0_ LEFT JOIN college c1_ ON b0_.college_id = c1_.id WHERE b0_.batch_id = ? ORDER BY c1_.id ASC, b0_.name ASC
Parameters:
[
  30
]
4 0.26 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.valid AS valid_2 FROM college c0_
Parameters:
[]
5 0.12 ms
SELECT DATABASE()
Parameters:
[]
6 0.96 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "pms"
]
7 0.09 ms
SELECT DATABASE()
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.