https://bdd-books-dev.eric-lefebvre.ovh/livre/1512

Query Metrics

8 Database Queries
8 Different statements
2.95 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.61 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.isbn AS isbn_3, t0.numero AS numero_4, t0.annee AS annee_5, t0.cycle AS cycle_6, t0.tome AS tome_7, t0.pages AS pages_8, t0.prixBase AS prixBase_9, t0.cote AS cote_10, t0.amazon AS amazon_11, t0.poids AS poids_12, t0.resume AS resume_13, t0.image AS image_14, t0.image_2 AS image_2_15, t0.category_id AS category_id_16, t0.collection_id AS collection_id_17, t0.edition_id AS edition_id_18, t0.monnaie_id AS monnaie_id_19 FROM livre t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1512"
]
2 0.42 ms
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:
[
  1512
]
3 0.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 WHERE t0.id = ?
Parameters:
[
  16792
]
4 0.33 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters:
[
  455
]
5 0.30 ms
SELECT t0.id AS id_1, t0.symbole AS symbole_2, t0.libelle AS libelle_3, t0.diminutif AS diminutif_4, t0.parDefault AS parDefault_5, t0.valeur AS valeur_6 FROM monnaie t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  9
]
7 0.31 ms
SELECT t0.id AS id_1, t0.note AS note_2, t0.dateAchat AS dateAchat_3, t0.prix_achat AS prix_achat_4, t0.commentaire AS commentaire_5, t0.particularite AS particularite_6, t0.seq_access AS seq_access_7, t0.user_id AS user_id_8, t0.livre_id AS livre_id_9, t0.monnaie_id AS monnaie_id_10 FROM lien_user_livre t0 WHERE t0.livre_id = ?
Parameters:
[
  1512
]
8 0.36 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.logo AS logo_6, t0.name AS name_7, t0.lastname AS lastname_8, t0.id_access AS id_access_9 FROM user 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.
App\Entity\User No errors.