Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.57 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.41 ms (71.39%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.nombre_de_produit AS nombre_de_produit_3, t0.reference AS reference_4, t0.caracteristique AS caracteristique_5, t0.couleurs AS couleurs_6, t0.images AS images_7, t0.slug AS slug_8, t0.prix AS prix_9, t0.offres AS offres_10, t0.description_detailler AS description_detailler_11, t0.image_une AS image_une_12, t0.image_deux AS image_deux_13, t0.image_trois AS image_trois_14, t0.image_quatre AS image_quatre_15, t0.image_cinq AS image_cinq_16, t0.type_de_produit AS type_de_produit_17, t0.taille AS taille_18, t0.garantie AS garantie_19, t0.etat AS etat_20, t0.tdptexte_un AS tdptexte_un_21, t0.tdptexte_deux AS tdptexte_deux_22, t0.tdpimage_un AS tdpimage_un_23, t0.tdpimage_deux AS tdpimage_deux_24, t0.is_best AS is_best_25, t0.marque_id AS marque_id_26, t0.modele_id AS modele_id_27, t0.type_de_piece_id AS type_de_piece_id_28, t0.support_id AS support_id_29 FROM piece t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"batterie-iphone-15"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.nombre_de_produit AS nombre_de_produit_3, t0.reference AS reference_4, t0.caracteristique AS caracteristique_5, t0.couleurs AS couleurs_6, t0.images AS images_7, t0.slug AS slug_8, t0.prix AS prix_9, t0.offres AS offres_10, t0.description_detailler AS description_detailler_11, t0.image_une AS image_une_12, t0.image_deux AS image_deux_13, t0.image_trois AS image_trois_14, t0.image_quatre AS image_quatre_15, t0.image_cinq AS image_cinq_16, t0.type_de_produit AS type_de_produit_17, t0.taille AS taille_18, t0.garantie AS garantie_19, t0.etat AS etat_20, t0.tdptexte_un AS tdptexte_un_21, t0.tdptexte_deux AS tdptexte_deux_22, t0.tdpimage_un AS tdpimage_un_23, t0.tdpimage_deux AS tdpimage_deux_24, t0.is_best AS is_best_25, t0.marque_id AS marque_id_26, t0.modele_id AS modele_id_27, t0.type_de_piece_id AS type_de_piece_id_28, t0.support_id AS support_id_29 FROM piece t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.nombre_de_produit AS nombre_de_produit_3, t0.reference AS reference_4, t0.caracteristique AS caracteristique_5, t0.couleurs AS couleurs_6, t0.images AS images_7, t0.slug AS slug_8, t0.prix AS prix_9, t0.offres AS offres_10, t0.description_detailler AS description_detailler_11, t0.image_une AS image_une_12, t0.image_deux AS image_deux_13, t0.image_trois AS image_trois_14, t0.image_quatre AS image_quatre_15, t0.image_cinq AS image_cinq_16, t0.type_de_produit AS type_de_produit_17, t0.taille AS taille_18, t0.garantie AS garantie_19, t0.etat AS etat_20, t0.tdptexte_un AS tdptexte_un_21, t0.tdptexte_deux AS tdptexte_deux_22, t0.tdpimage_un AS tdpimage_un_23, t0.tdpimage_deux AS tdpimage_deux_24, t0.is_best AS is_best_25, t0.marque_id AS marque_id_26, t0.modele_id AS modele_id_27, t0.type_de_piece_id AS type_de_piece_id_28, t0.support_id AS support_id_29 FROM piece t0 WHERE t0.slug = 'batterie-iphone-15' LIMIT 1;
0.16 ms (28.61%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.marque_id AS marque_id_3 FROM modele t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.marque_id AS marque_id_3 FROM modele t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.marque_id AS marque_id_3 FROM modele t0 WHERE t0.id = 1;

Time▼

Count

Info

0.41 ms
(71.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.nombre_de_produit AS nombre_de_produit_3, t0.reference AS reference_4, t0.caracteristique AS caracteristique_5, t0.couleurs AS couleurs_6, t0.images AS images_7, t0.slug AS slug_8, t0.prix AS prix_9, t0.offres AS offres_10, t0.description_detailler AS description_detailler_11, t0.image_une AS image_une_12, t0.image_deux AS image_deux_13, t0.image_trois AS image_trois_14, t0.image_quatre AS image_quatre_15, t0.image_cinq AS image_cinq_16, t0.type_de_produit AS type_de_produit_17, t0.taille AS taille_18, t0.garantie AS garantie_19, t0.etat AS etat_20, t0.tdptexte_un AS tdptexte_un_21, t0.tdptexte_deux AS tdptexte_deux_22, t0.tdpimage_un AS tdpimage_un_23, t0.tdpimage_deux AS tdpimage_deux_24, t0.is_best AS is_best_25, t0.marque_id AS marque_id_26, t0.modele_id AS modele_id_27, t0.type_de_piece_id AS type_de_piece_id_28, t0.support_id AS support_id_29 FROM piece t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "batterie-iphone-15"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.nombre_de_produit AS nombre_de_produit_3,
  t0.reference AS reference_4,
  t0.caracteristique AS caracteristique_5,
  t0.couleurs AS couleurs_6,
  t0.images AS images_7,
  t0.slug AS slug_8,
  t0.prix AS prix_9,
  t0.offres AS offres_10,
  t0.description_detailler AS description_detailler_11,
  t0.image_une AS image_une_12,
  t0.image_deux AS image_deux_13,
  t0.image_trois AS image_trois_14,
  t0.image_quatre AS image_quatre_15,
  t0.image_cinq AS image_cinq_16,
  t0.type_de_produit AS type_de_produit_17,
  t0.taille AS taille_18,
  t0.garantie AS garantie_19,
  t0.etat AS etat_20,
  t0.tdptexte_un AS tdptexte_un_21,
  t0.tdptexte_deux AS tdptexte_deux_22,
  t0.tdpimage_un AS tdpimage_un_23,
  t0.tdpimage_deux AS tdpimage_deux_24,
  t0.is_best AS is_best_25,
  t0.marque_id AS marque_id_26,
  t0.modele_id AS modele_id_27,
  t0.type_de_piece_id AS type_de_piece_id_28,
  t0.support_id AS support_id_29
FROM
  piece t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.nombre_de_produit AS nombre_de_produit_3, t0.reference AS reference_4, t0.caracteristique AS caracteristique_5, t0.couleurs AS couleurs_6, t0.images AS images_7, t0.slug AS slug_8, t0.prix AS prix_9, t0.offres AS offres_10, t0.description_detailler AS description_detailler_11, t0.image_une AS image_une_12, t0.image_deux AS image_deux_13, t0.image_trois AS image_trois_14, t0.image_quatre AS image_quatre_15, t0.image_cinq AS image_cinq_16, t0.type_de_produit AS type_de_produit_17, t0.taille AS taille_18, t0.garantie AS garantie_19, t0.etat AS etat_20, t0.tdptexte_un AS tdptexte_un_21, t0.tdptexte_deux AS tdptexte_deux_22, t0.tdpimage_un AS tdpimage_un_23, t0.tdpimage_deux AS tdpimage_deux_24, t0.is_best AS is_best_25, t0.marque_id AS marque_id_26, t0.modele_id AS modele_id_27, t0.type_de_piece_id AS type_de_piece_id_28, t0.support_id AS support_id_29 FROM piece t0 WHERE t0.slug = 'batterie-iphone-15' LIMIT 1;

0.16 ms
(28.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.marque_id AS marque_id_3 FROM modele t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.marque_id AS marque_id_3
FROM
  modele t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.marque_id AS marque_id_3 FROM modele t0 WHERE t0.id = 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\Piece	No errors.
App\Entity\Marque	The field App\Entity\Marque#tarifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Tarification#marque does not contain the required 'inversedBy="tarifications"' attribute.
App\Entity\Modele	The field App\Entity\Modele#tarifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Tarification#modele does not contain the required 'inversedBy="tarifications"' attribute.
App\Entity\TypeDePiece	The association App\Entity\TypeDePiece#tarifications refers to the owning side field App\Entity\Tarification#TypeDePiece which does not exist.
App\Entity\Support	No errors.
App\Entity\Tarification	No errors.

Symfony Profiler

GET https://nouveau.lacassedugsm.fr/catalogue/batterie-iphone-15

Configuration Settings

Theme