https://bdd-books-dev.eric-lefebvre.ovh/auteur/14996

Method
GET
HTTP Status
200
IP
192.168.5.70
Profiled on
Token
5bc8be

Query Metrics

28 Database Queries
4 Different statements
12.56 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.37 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM auteur t0 WHERE t0.id = ?
Parameters: 
[
  14996
]
View formatted query    View runnable query    Explain query
2 0.35 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.auteur_id = ?
Parameters: 
[
  14996
]
View formatted query    View runnable query    Explain query
3 0.57 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 = ?
Parameters: 
[
  2475
]
View formatted query    View runnable query    Explain query
4 0.56 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 = ?
Parameters: 
[
  2476
]
View formatted query    View runnable query    Explain query
5 0.42 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 = ?
Parameters: 
[
  2477
]
View formatted query    View runnable query    Explain query
6 0.39 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 = ?
Parameters: 
[
  2478
]
View formatted query    View runnable query    Explain query
7 0.44 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 = ?
Parameters: 
[
  2542
]
View formatted query    View runnable query    Explain query
8 0.38 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 = ?
Parameters: 
[
  2544
]
View formatted query    View runnable query    Explain query
9 0.53 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 = ?
Parameters: 
[
  2545
]
View formatted query    View runnable query    Explain query
10 0.49 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 = ?
Parameters: 
[
  2546
]
View formatted query    View runnable query    Explain query
11 0.43 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 = ?
Parameters: 
[
  2547
]
View formatted query    View runnable query    Explain query
12 0.40 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 = ?
Parameters: 
[
  2548
]
View formatted query    View runnable query    Explain query
13 0.41 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 = ?
Parameters: 
[
  2549
]
View formatted query    View runnable query    Explain query
14 0.40 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 = ?
Parameters: 
[
  2550
]
View formatted query    View runnable query    Explain query
15 0.43 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 = ?
Parameters: 
[
  2555
]
View formatted query    View runnable query    Explain query
16 0.52 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 = ?
Parameters: 
[
  2556
]
View formatted query    View runnable query    Explain query
17 0.43 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 = ?
Parameters: 
[
  2557
]
View formatted query    View runnable query    Explain query
18 0.43 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 = ?
Parameters: 
[
  2642
]
View formatted query    View runnable query    Explain query
19 0.47 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 = ?
Parameters: 
[
  3089
]
View formatted query    View runnable query    Explain query
20 0.58 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 = ?
Parameters: 
[
  3287
]
View formatted query    View runnable query    Explain query
21 0.50 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 = ?
Parameters: 
[
  3288
]
View formatted query    View runnable query    Explain query
22 0.50 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 = ?
Parameters: 
[
  3293
]
View formatted query    View runnable query    Explain query
23 0.52 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 = ?
Parameters: 
[
  3308
]
View formatted query    View runnable query    Explain query
24 0.43 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 = ?
Parameters: 
[
  3358
]
View formatted query    View runnable query    Explain query
25 0.51 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 = ?
Parameters: 
[
  3448
]
View formatted query    View runnable query    Explain query
26 0.35 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters: 
[
  42
]
View formatted query    View runnable query    Explain query
27 0.45 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
28 0.29 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM edition t0 WHERE t0.id = ?
Parameters: 
[
  219
]
View formatted query    View runnable query    Explain query

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\Auteur No errors.
App\Entity\LienAuteurLivre No 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\LienUserLivre No errors.