Query Metrics
2
Database Queries
2
Different statements
7.67 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.27 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:
[
294
]
|
2 | 7.40 ms |
SELECT s0_.rank AS rank_0, s0_.score AS score_1, s0_.suggestion AS suggestion_2, s0_.done AS done_3, s0_.id AS id_4, r1_.project_code AS project_code_5, r1_.category_name AS category_name_6, r1_.level_name AS level_name_7, r1_.rank_name AS rank_name_8, r1_.user_name AS user_name_9, r1_.year_name AS year_name_10, r1_.college_name AS college_name_11, r1_.property_name AS property_name_12, r1_.group_ AS group__13, r1_.sort AS sort_14, r1_.id AS id_15, r1_.name AS name_16, s0_.reviewer_id AS reviewer_id_17, s0_.review_id AS review_id_18, r1_.review_batch_id AS review_batch_id_19, r1_.project_id AS project_id_20 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:
[
294
]
|
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. |