https://heylotte.de/library/1/pool/5/del/2238

Query Metrics

14 Database Queries
11 Different statements
24.62 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.68 ms
SELECT u0_.name AS name_0 FROM user_library_pool u0_ WHERE u0_.id = ?
Parameters:
[
  5
]
2 0.99 ms
SELECT u0_.type AS type_0 FROM user_library_pool u0_ WHERE u0_.id = ?
Parameters:
[
  "5"
]
3 1.03 ms
SELECT u0_.name AS name_0 FROM user_library u0_ WHERE u0_.id = ?
Parameters:
[
  1
]
4 1.09 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.00 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 1.07 ms
SELECT c0_.task AS task_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
  "2238"
]
7 1.12 ms
SELECT c0_.solution AS solution_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
  "2238"
]
8 0.97 ms
SELECT c0_.classification_id AS classification_id_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
  "2238"
]
9 0.94 ms
SELECT c0_.pool_id AS pool_id_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
  "2238"
]
10 1.02 ms
SELECT c0_.task AS task_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
  "2238"
]
11 0.90 ms
SELECT c0_.solution AS solution_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
  "2238"
]
12 0.87 ms
SELECT c0_.classification_id AS classification_id_0 FROM card c0_ WHERE c0_.id = ?
Parameters:
[
  "2238"
]
13 6.62 ms
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
]
14 4.31 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ WHERE c0_.pool_id = ? AND c0_.delflag = 0
Parameters:
[
  "5"
]

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.