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

Query Metrics

233 Database Queries
5 Different statements
96.32 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
33.63 ms
(34.91%)
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:
[
  2677
]
28.97 ms
(30.08%)
109
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 WHERE t0.id = ?
Parameters:
[
  15856
]
16.54 ms
(17.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:
[
  2677
  2678
  2679
  2680
  2681
  3070
  106
  1732
  1733
  107
  2283
  2284
  2192
  1973
  1974
  1975
  1976
  1977
  2193
  2194
  2258
  108
  2916
  2922
  2915
  109
  2510
  555
  556
  149
  3301
  2788
  2782
  110
  111
  3191
  1352
  1353
  1192
  45
  1248
  469
  92
  1211
  93
  1458
  94
  1209
  1487
  112
  1439
  1440
  113
  3414
  114
  115
  116
  117
  118
  119
  1578
  1579
  1475
  3566
  120
  121
  122
  1934
  2667
  1611
  1154
  123
  1613
  1321
  1265
  1266
  1269
  1270
  1741
  124
  1703
  125
  126
  127
  3428
  313
  1776
  314
  315
  320
  321
  3567
  1171
  1635
  1535
  1706
  322
  163
  164
  391
]
11.31 ms
(11.74%)
1
SELECT l.id, l.titre
        FROM livre l
         Order By l.titre ASC
Parameters:
[]
5.88 ms
(6.11%)
22
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters:
[
  28
]

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.