https://clainservice.madaprogiciel.com/frais/livraison/precommande/80

Query Metrics

3 Database Queries
2 Different statements
9.30 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 4.95 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_name AS image_name_3 FROM categori_product t0
Parameters:
[]
2 3.71 ms
SELECT t0.id AS id_1, t0.idproduct AS idproduct_2, t0.quantity AS quantity_3, t0.state AS state_4, t0.motif AS motif_5, t0.prix_unitaire AS prix_unitaire_6, t0.pic_url AS pic_url_7, t0.title AS title_8, t0.descri AS descri_9, t0.specifi AS specifi_10, t0.ref AS ref_11, t0.prix_livraison AS prix_livraison_12, t0.prix_total_livraison AS prix_total_livraison_13, t0.idorder_id AS idorder_id_14 FROM order_api_details t0 WHERE t0.id = ?
Parameters:
[
  "80"
]
3 0.64 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image_name AS image_name_3 FROM categori_product t0
Parameters:
[]

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\CategoriProduct No errors.
App\Entity\OrderApiDetails No errors.
App\Entity\OrderApi
  • The mappings App\Entity\OrderApi#admin and App\Entity\UserPlatform#listOrders are inconsistent with each other.
  • The association App\Entity\OrderApi#adresseLiv refers to the inverse side field App\Entity\AdresseLivraison#adresse which is not defined as association.
  • The association App\Entity\OrderApi#adresseLiv refers to the inverse side field App\Entity\AdresseLivraison#adresse which does not exist.
App\Entity\UserPlatform No errors.
App\Entity\AdresseLivraison
  • The mappings App\Entity\AdresseLivraison#orders and App\Entity\OrderApi#adresseLiv are inconsistent with each other.
App\Entity\Order No errors.
App\Entity\FraisLivraison No errors.
App\Entity\CoursDeChange No errors.
App\Entity\ProductList No errors.
App\Entity\HsitoricTransact No errors.
App\Entity\Stock No errors.
App\Entity\Product No errors.
App\Entity\Commission No errors.
App\Entity\RouteArticle No errors.
App\Entity\Coordonne No errors.
App\Entity\Finance No errors.
App\Entity\Shop No errors.
App\Entity\MotRechercher No errors.
App\Entity\DetailsOrders No errors.
App\Entity\StateDeliveryOrder No errors.
App\Entity\PriceProduct No errors.
App\Entity\SousCategorie No errors.
App\Entity\Devise No errors.
Vich\UploaderBundle\Entity\File No errors.