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

Query Metrics

2 Database Queries
2 Different statements
1.85 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.38 ms
SELECT t0.password AS password_1, t0.name AS name_2, t0.id AS id_3, t0.username AS username_4, t0.review_batch_id AS review_batch_id_5 FROM reviewer t0 WHERE t0.id = ?
Parameters:
[
  302
]
2 1.47 ms
SELECT s0_.score AS score_0, s0_.suggestion AS suggestion_1, s0_.done AS done_2, s0_.id AS id_3, r1_.project_code AS project_code_4, r1_.category_name AS category_name_5, r1_.level_name AS level_name_6, r1_.rank_name AS rank_name_7, r1_.user_name AS user_name_8, r1_.year_name AS year_name_9, r1_.college_name AS college_name_10, r1_.property_name AS property_name_11, r1_.group_ AS group__12, r1_.sort AS sort_13, r1_.id AS id_14, r1_.name AS name_15, s0_.reviewer_id AS reviewer_id_16, s0_.review_id AS review_id_17, r1_.review_batch_id AS review_batch_id_18, r1_.project_id AS project_id_19 FROM score s0_ LEFT JOIN review r1_ ON s0_.review_id = r1_.id LEFT JOIN review_batch r2_ ON r1_.review_batch_id = r2_.id WHERE s0_.reviewer_id = ? AND r2_.current = 1 ORDER BY r1_.sort ASC
Parameters:
[
  302
]

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\Reviewer No errors.
App\Entity\ReviewBatch No errors.
App\Entity\Score No errors.
App\Entity\Review No errors.
App\Entity\Project No errors.