Query Metrics
245
Database Queries
5
Different statements
99.00 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
36.73 ms (37.11%) |
100 |
SELECT t0.id AS id_1, t0.livre_id AS livre_id_2, t0.auteur_id AS auteur_id_3 FROM lien_auteur_livre t0 WHERE t0.livre_id = ?
Parameters:
[
2817
]
|
|
28.64 ms (28.93%) |
105 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 WHERE t0.id = ?
Parameters:
[
13804
]
|
|
14.10 ms (14.24%) |
1 |
SELECT l0_.id AS id_0, l0_.titre AS titre_1, l0_.isbn AS isbn_2, l0_.numero AS numero_3, l0_.annee AS annee_4, l0_.cycle AS cycle_5, l0_.tome AS tome_6, l0_.pages AS pages_7, l0_.prixBase AS prixBase_8, l0_.cote AS cote_9, l0_.amazon AS amazon_10, l0_.poids AS poids_11, l0_.resume AS resume_12, l0_.image AS image_13, l0_.image_2 AS image_2_14, l0_.category_id AS category_id_15, l0_.collection_id AS collection_id_16, l0_.edition_id AS edition_id_17, l0_.monnaie_id AS monnaie_id_18 FROM livre l0_ WHERE l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY l0_.titre ASC
Parameters:
[ 2817 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 1 2 1210 3324 3 4 3043 2225 5 6 7 8 1968 2367 3245 1969 1970 2118 2384 9 3348 3349 3412 1400 1416 10 11 2454 2374 2912 2913 2914 2659 2660 1704 1214 1377 2447 3235 3255 12 13 3374 2334 2333 2336 2337 2335 14 15 2668 16 17 18 19 1406 20 21 22 1545 1637 1831 1438 2338 2339 2340 2565 2940 23 2199 1687 1646 557 2071 2799 1990 25 24 1168 1169 26 27 28 1511 1512 29 2341 2342 2343 ] |
|
10.02 ms (10.12%) |
38 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters:
[
169
]
|
|
9.51 ms (9.61%) |
1 |
SELECT l.id, l.titre FROM livre l Order By l.titre ASC
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\Livre |
|
| App\Entity\Category | No errors. |
| App\Entity\Collection | No errors. |
| App\Entity\Edition | No errors. |
| App\Entity\Monnaie | No errors. |
| App\Entity\LienAuteurLivre | No errors. |
| App\Entity\LienUserLivre | No errors. |
| App\Entity\Auteur | No errors. |