Query Metrics
14
Database Queries
11
Different statements
16.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.84 ms (23.25%) |
1 |
SELECT c0_.id AS id_0, c0_.task AS task_1, c0_.solution AS solution_2, c0_.correct AS correct_3, c0_.correct2 AS correct2_4, c0_.skilled AS skilled_5, c0_.classification_id AS classification_id_6, u1_.name AS name_7 FROM card c0_ INNER JOIN user_classification u1_ ON (u1_.id = c0_.classification_id) WHERE c0_.pool_id = ? AND c0_.delflag = 0
Parameters:
[
5
]
|
|
2.14 ms (12.95%) |
1 |
SELECT u0_.name AS name_0 FROM user_library_pool u0_ WHERE u0_.id = ?
Parameters:
[
5
]
|
|
1.70 ms (10.28%) |
2 |
SELECT c0_.task AS task_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
"1131"
]
|
|
1.60 ms (9.69%) |
2 |
SELECT c0_.classification_id AS classification_id_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
"1131"
]
|
|
1.58 ms (9.55%) |
2 |
SELECT c0_.solution AS solution_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
"1131"
]
|
|
1.30 ms (7.89%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ WHERE c0_.pool_id = ? AND c0_.delflag = 0
Parameters:
[
"5"
]
|
|
1.00 ms (6.03%) |
1 |
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
]
|
|
0.86 ms (5.24%) |
1 |
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
]
|
|
0.86 ms (5.22%) |
1 |
SELECT u0_.name AS name_0 FROM user_library u0_ WHERE u0_.id = ?
Parameters:
[
1
]
|
|
0.86 ms (5.20%) |
1 |
SELECT u0_.type AS type_0 FROM user_library_pool u0_ WHERE u0_.id = ?
Parameters:
[
"5"
]
|
|
0.78 ms (4.70%) |
1 |
SELECT c0_.pool_id AS pool_id_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
"1131"
]
|
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\UserClassification | No errors. |
| App\Entity\Card | No errors. |