https://bdd-books-dev.eric-lefebvre.ovh/listelivreUser/3?page=3

Query Metrics

232 Database Queries
5 Different statements
89.99 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
33.37 ms
(37.09%)
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:
[
  2832
]
23.55 ms
(26.17%)
84
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 WHERE t0.id = ?
Parameters:
[
  15311
]
11.66 ms
(12.96%)
45
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters:
[
  275
]
10.95 ms
(12.17%)
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:
[
  2832
  2831
  3188
  3190
  3225
  2835
  2431
  2390
  3417
  2615
  3443
  3444
  3445
  3446
  3447
  3441
  3442
  3549
  3548
  3230
  2415
  2416
  3247
  2972
  2495
  2970
  2971
  2492
  2968
  2969
  2493
  2494
  2967
  2966
  2797
  2353
  2405
  3520
  3279
  2514
  2513
  3419
  2480
  3360
  3248
  2413
  2414
  3168
  2995
  3010
  2673
  2672
  2671
  2736
  2751
  2602
  2603
  2613
  2802
  2761
  3222
  2664
  3249
  2877
  2924
  2872
  2837
  2869
  3187
  3157
  3158
  3193
  2468
  2370
  2699
  2927
  2862
  2936
  2434
  2432
  2612
  2609
  2610
  2611
  2786
  2519
  2317
  2290
  2354
  2309
  2352
  2308
  2445
  2443
  2442
  2321
  3263
  2648
  2410
  2823
]
10.46 ms
(11.62%)
2
SELECT  l.id, l.titre
        FROM    livre l, lien_user_livre lul
        WHERE   l.id = lul.livre_id
        AND     lul.user_id = 3  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
  • The field App\Entity\Livre#listeAuteur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LienAuteurLivre#livre does not contain the required 'inversedBy="listeAuteur"' attribute.
  • The field App\Entity\Livre#listeUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LienUserLivre#livre does not contain the required 'inversedBy="listeUser"' attribute.
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.