Query Metrics
5
Database Queries
5
Different statements
2.70 ms
Query time
0
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.59 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.token AS token_5, t0.last_login AS last_login_6 FROM fos_user t0 WHERE t0.id = ?
Parameters:
[
21
]
|
| 2 | 0.82 ms |
SELECT q0_.id AS id_0, q0_.label AS label_1, q0_.canonical AS canonical_2, q0_.chapter AS chapter_3, q0_.refImg AS refImg_4, q0_.explaination AS explaination_5, q0_.updated AS updated_6, q0_.topic_id AS topic_id_7 FROM question q0_ LEFT JOIN follow f1_ ON q0_.id = f1_.question_id AND (f1_.user_id = ?) LEFT JOIN focus f2_ ON q0_.id = f2_.question_id AND (f2_.user_id = ?) WHERE q0_.id = ?
Parameters:
[ 21 21 "6180" ] |
| 3 | 0.53 ms |
SELECT t0.care AS care_1, t0.question_id AS question_id_2, t0.user_id AS user_id_3 FROM focus t0 WHERE t0.question_id = ?
Parameters:
[
6180
]
|
| 4 | 0.34 ms |
SELECT t0.good AS good_1, t0.wrong AS wrong_2, t0.total AS total_3, t0.question_id AS question_id_4, t0.user_id AS user_id_5 FROM follow t0 WHERE t0.question_id = ?
Parameters:
[
6180
]
|
| 5 | 0.41 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.good AS good_3, t0.question_id AS question_id_4 FROM answer t0 WHERE t0.question_id = ?
Parameters:
[
6180
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Answer | 4 |
| App\Entity\User | 2 |
| App\Entity\Question | 1 |
| App\Entity\Topic | 1 |
| App\Entity\Follow | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Subject | No errors. |
| App\Entity\Question | No errors. |
| App\Entity\Follow | No errors. |
| App\Entity\Focus | No errors. |
| App\Entity\Topic | No errors. |
| App\Entity\Answer | No errors. |
| App\Entity\Tag | No errors. |