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

Query Metrics

113 Database Queries
5 Different statements
44.58 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.27 ms
(36.49%)
61
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:
[
  3387
]
9.20 ms
(20.63%)
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:
[
  3387
  1074
  1075
  1076
  1447
  286
  3563
  287
  387
  388
  389
  1306
  1201
  3091
  3087
  3088
  3089
  3090
  1692
  1693
  3042
  2640
  2311
  2637
  2638
  2639
  2641
  3270
  3031
  3017
  3018
  3019
  3020
  3021
  3022
  3023
  3024
  3025
  3026
  3027
  3028
  3030
  3032
  3033
  3034
  3036
  3037
  3039
  3029
  3035
  3038
  3040
  3041
  1842
  1843
  1844
  1694
  3329
  390
  1109
  3172
]
8.89 ms
(19.93%)
39
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 WHERE t0.id = ?
Parameters:
[
  56123
]
7.85 ms
(17.61%)
1
SELECT l.id, l.titre
        FROM livre l
         Order By l.titre ASC
Parameters:
[]
2.38 ms
(5.34%)
11
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.