https://dev.spa.biz/fiche-produit/portail-3-4-%C3%A9toiles/20

Query Metrics

4 Database Queries
4 Different statements
1.03 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.28 ms
(27.43%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM produit_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  20
]
0.27 ms
(26.27%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.descriptions AS descriptions_2, c0_.image AS image_3, c0_.name_fr AS name_fr_4, c0_.descriptions_fr AS descriptions_fr_5, c0_.name_es AS name_es_6, c0_.descriptions_es AS descriptions_es_7, c0_.sous_categorie_id AS sous_categorie_id_8 FROM categorie c0_ WHERE c0_.sous_categorie_id IS NULL ORDER BY c0_.id ASC
Parameters:
[]
0.26 ms
(25.49%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.image_produits_principale AS image_produits_principale_3, t0.stock AS stock_4, t0.price_ttc AS price_ttc_5, t0.price_ht AS price_ht_6, t0.tax_rate AS tax_rate_7, t0.ref AS ref_8, t0.is_selection AS is_selection_9, t0.price_product_ttc AS price_product_ttc_10, t0.price_product_ht AS price_product_ht_11, t0.tax_rate_product_ht AS tax_rate_product_ht_12, t0.price_service_ttc AS price_service_ttc_13, t0.price_service_ht AS price_service_ht_14, t0.tax_rate_service_ttc AS tax_rate_service_ttc_15, t0.is_coup_coeur AS is_coup_coeur_16, t0.template_pdf AS template_pdf_17, t0.finition_id AS finition_id_18, t0.produit_parent_id AS produit_parent_id_19 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  "20"
]
0.21 ms
(20.82%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.produit_image_id AS produit_image_id_3, t0.color_id AS color_id_4 FROM image_produit t0 WHERE t0.produit_image_id = ?
Parameters:
[
  20
]

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\Produit\Produit
  • The field App\Entity\Produit\Produit#orderLinesProduit is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order\OrderLine#produit does not contain the required 'inversedBy="orderLinesProduit"' attribute.
App\Entity\Produit\Finition No errors.
App\Entity\Produit\ImageProduit No errors.
App\Entity\Categorie No errors.
App\Entity\ProduitRelatedVersion No errors.
App\Entity\Produit\Garantie No errors.
App\Entity\Produit\Option No errors.
App\Entity\AvisClient No errors.
App\Entity\Produit\Couleur
  • The mappings App\Entity\Produit\Couleur#produits and App\Entity\Produit\Produit#colors are inconsistent with each other.
App\Entity\ProduitCarrier No errors.
App\Entity\Order\OrderLine No errors.
App\Entity\Produit\ProduitTranslation No errors.