Query Metrics
9
Database Queries
9
Different statements
23.22 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.49 ms |
SELECT u0_.name AS name_0 FROM user_library_pool u0_ WHERE u0_.id = ?
Parameters:
[
2
]
|
2 | 0.65 ms |
SELECT u0_.type AS type_0 FROM user_library_pool u0_ WHERE u0_.id = ?
Parameters:
[
"2"
]
|
3 | 1.58 ms |
SELECT u0_.name AS name_0 FROM user_library u0_ WHERE u0_.id = ?
Parameters:
[
1
]
|
4 | 5.86 ms |
SELECT u0_.id AS id_0, u0_.name AS name_1 FROM user_library_pool u1_ LEFT JOIN user_classification u0_ ON (u0_.library_id = u1_.id) WHERE u1_.id = ?
Parameters:
[
1
]
|
5 | 1.03 ms |
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2, u0_.type AS type_3, u0_.deletable AS deletable_4, u0_.mon AS mon_5, u0_.tue AS tue_6, u0_.wed AS wed_7, u0_.thu AS thu_8, u0_.fri AS fri_9, u0_.sat AS sat_10, u0_.sun AS sun_11 FROM user_library_pool u0_ WHERE u0_.library_id = ?
Parameters:
[
1
]
|
6 | 3.24 ms |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.pool_id AS pool_id_3, t0.reference_id AS reference_id_4, t0.reference_version AS reference_version_5, t0.copy_id AS copy_id_6, t0.copy_version AS copy_version_7, t0.task AS task_8, t0.solution AS solution_9, t0.classification_id AS classification_id_10, t0.version AS version_11, t0.correct AS correct_12, t0.correct2 AS correct2_13, t0.skilled AS skilled_14, t0.delflag AS delflag_15, t0.created_date AS created_date_16, t0.modify_date AS modify_date_17 FROM card t0 WHERE t0.id = ?
Parameters:
[
"4505"
]
|
7 | 0.39 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 1.10 ms |
UPDATE card SET correct = ?, correct2 = ? WHERE id = ?
Parameters:
[ 2 2 4505 ] |
9 | 4.87 ms |
"COMMIT"
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\UserLibraryPool | No errors. |
App\Entity\UserLibrary | No errors. |
App\Entity\Card | No errors. |
App\Entity\UserProperties | No errors. |
App\Entity\UserClassification | No errors. |