Query Metrics

26 Database Queries
13 Different statements
10.63 ms Query time
1 Invalid entities
74 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.91 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.prix AS prix_2, p0_.description AS description_3, p0_.nouveaute AS nouveaute_4, p0_.promotion AS promotion_5, p0_.actif AS actif_6, p0_.banniere AS banniere_7, p0_.slug AS slug_8, p0_.meta_titre AS meta_titre_9, p0_.meta_description AS meta_description_10, p0_.prix_ttc AS prix_ttc_11, p0_.cout_fournisseur AS cout_fournisseur_12, p0_.quantite AS quantite_13, p0_.reference AS reference_14, p0_.resume AS resume_15, p0_.caracteristiques AS caracteristiques_16, p0_.aliexpress_product_id AS aliexpress_product_id_17, p0_.aliexpress_product_url AS aliexpress_product_url_18, p0_.aliexpress_imported_at AS aliexpress_imported_at_19, p0_.updated_at AS updated_at_20, p0_.created_at AS created_at_21, i1_.id AS id_22, i1_.name AS name_23, i1_.updated_at AS updated_at_24, i1_.created_at AS created_at_25, p2_.id AS id_26, p2_.couleur AS couleur_27, p2_.couleur_hex AS couleur_hex_28, p2_.taille AS taille_29, p2_.reference AS reference_30, p2_.prix AS prix_31, p2_.prix_ttc AS prix_ttc_32, p2_.promotion AS promotion_33, p2_.quantite AS quantite_34, p2_.actif AS actif_35, p2_.difference_prix AS difference_prix_36, p2_.sku AS sku_37, p2_.code_barre AS code_barre_38, p2_.poids AS poids_39, p2_.image_name AS image_name_40, p2_.updated_at AS updated_at_41, p2_.created_at AS created_at_42, p0_.marque_id AS marque_id_43, p0_.fournisseur_id AS fournisseur_id_44, i1_.produit_id AS produit_id_45, p2_.produit_id AS produit_id_46 FROM produit p0_ LEFT JOIN produit_categorie p4_ ON p0_.id = p4_.produit_id LEFT JOIN categorie c3_ ON c3_.id = p4_.categorie_id LEFT JOIN image_produit i1_ ON p0_.id = i1_.produit_id LEFT JOIN produit_declinaison p2_ ON p0_.id = p2_.produit_id WHERE p0_.actif = 1 AND ((p0_.quantite >= 1 OR (p2_.actif = 1 AND p2_.quantite >= 1)))
Parameters:
[]
2 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.categorie_id WHERE produit_categorie.produit_id = ?
Parameters:
[
  1
]
3 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.categorie_id WHERE produit_categorie.produit_id = ?
Parameters:
[
  2
]
4 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 INNER JOIN produit_categorie ON t0.id = produit_categorie.categorie_id WHERE produit_categorie.produit_id = ?
Parameters:
[
  4
]
5 0.56 ms
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.button_contact AS button_contact_4, t0.ville_opti AS ville_opti_5, t0.meta_titre_produit AS meta_titre_produit_6, t0.meta_desc_produit AS meta_desc_produit_7, t0.meta_titre_vehicule AS meta_titre_vehicule_8, t0.meta_desc_vehicule AS meta_desc_vehicule_9, t0.noindex AS noindex_10, t0.redirections AS redirections_11, t0.banniere_accueil AS banniere_accueil_12, t0.banniere_interieur AS banniere_interieur_13, t0.stripe_secrete_dev AS stripe_secrete_dev_14, t0.stripe_live_dev AS stripe_live_dev_15, t0.stripe_secrete_prod AS stripe_secrete_prod_16, t0.stripe_live_prod AS stripe_live_prod_17, t0.paypal_client_id AS paypal_client_id_18, t0.paypal_secret_key AS paypal_secret_key_19, t0.paypal_test_mod AS paypal_test_mod_20, t0.paiement AS paiement_21, t0.paypal AS paypal_22, t0.stripe AS stripe_23, t0.aliexpress_enabled AS aliexpress_enabled_24, t0.aliexpress_api_base_url AS aliexpress_api_base_url_25, t0.aliexpress_app_key AS aliexpress_app_key_26, t0.aliexpress_app_secret AS aliexpress_app_secret_27, t0.aliexpress_access_token AS aliexpress_access_token_28, t0.aliexpress_tracking_id AS aliexpress_tracking_id_29 FROM config t0
Parameters:
[]
6 0.40 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
7 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.30 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
10 0.26 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
11 0.27 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
12 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 WHERE t0.url = ?
Parameters:
[
  "app_produits"
]
13 0.45 ms
SELECT t0.id AS id_1, t0.name_company AS name_company_2, t0.tel1 AS tel1_3, t0.tel2 AS tel2_4, t0.fax AS fax_5, t0.email AS email_6, t0.adresse AS adresse_7, t0.comp_adresse AS comp_adresse_8, t0.cp AS cp_9, t0.ville AS ville_10, t0.facebook AS facebook_11, t0.instagram AS instagram_12, t0.twitter AS twitter_13, t0.linkedin AS linkedin_14, t0.youtube AS youtube_15, t0.snapchat AS snapchat_16, t0.map_url AS map_url_17, t0.iframe AS iframe_18, t0.horaires AS horaires_19, t0.afficher AS afficher_20, t0.image_name AS image_name_21, t0.updated_at AS updated_at_22, t0.created_at AS created_at_23 FROM coordonnees t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.43 ms
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.button_contact AS button_contact_4, t0.ville_opti AS ville_opti_5, t0.meta_titre_produit AS meta_titre_produit_6, t0.meta_desc_produit AS meta_desc_produit_7, t0.meta_titre_vehicule AS meta_titre_vehicule_8, t0.meta_desc_vehicule AS meta_desc_vehicule_9, t0.noindex AS noindex_10, t0.redirections AS redirections_11, t0.banniere_accueil AS banniere_accueil_12, t0.banniere_interieur AS banniere_interieur_13, t0.stripe_secrete_dev AS stripe_secrete_dev_14, t0.stripe_live_dev AS stripe_live_dev_15, t0.stripe_secrete_prod AS stripe_secrete_prod_16, t0.stripe_live_prod AS stripe_live_prod_17, t0.paypal_client_id AS paypal_client_id_18, t0.paypal_secret_key AS paypal_secret_key_19, t0.paypal_test_mod AS paypal_test_mod_20, t0.paiement AS paiement_21, t0.paypal AS paypal_22, t0.stripe AS stripe_23, t0.aliexpress_enabled AS aliexpress_enabled_24, t0.aliexpress_api_base_url AS aliexpress_api_base_url_25, t0.aliexpress_app_key AS aliexpress_app_key_26, t0.aliexpress_app_secret AS aliexpress_app_secret_27, t0.aliexpress_access_token AS aliexpress_access_token_28, t0.aliexpress_tracking_id AS aliexpress_tracking_id_29 FROM config t0 LIMIT 1
Parameters:
[]
15 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 WHERE t0.url = ?
Parameters:
[
  "app_produits"
]
16 0.34 ms
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.siret AS siret_3, t0.button_contact AS button_contact_4, t0.ville_opti AS ville_opti_5, t0.meta_titre_produit AS meta_titre_produit_6, t0.meta_desc_produit AS meta_desc_produit_7, t0.meta_titre_vehicule AS meta_titre_vehicule_8, t0.meta_desc_vehicule AS meta_desc_vehicule_9, t0.noindex AS noindex_10, t0.redirections AS redirections_11, t0.banniere_accueil AS banniere_accueil_12, t0.banniere_interieur AS banniere_interieur_13, t0.stripe_secrete_dev AS stripe_secrete_dev_14, t0.stripe_live_dev AS stripe_live_dev_15, t0.stripe_secrete_prod AS stripe_secrete_prod_16, t0.stripe_live_prod AS stripe_live_prod_17, t0.paypal_client_id AS paypal_client_id_18, t0.paypal_secret_key AS paypal_secret_key_19, t0.paypal_test_mod AS paypal_test_mod_20, t0.paiement AS paiement_21, t0.paypal AS paypal_22, t0.stripe AS stripe_23, t0.aliexpress_enabled AS aliexpress_enabled_24, t0.aliexpress_api_base_url AS aliexpress_api_base_url_25, t0.aliexpress_app_key AS aliexpress_app_key_26, t0.aliexpress_app_secret AS aliexpress_app_secret_27, t0.aliexpress_access_token AS aliexpress_access_token_28, t0.aliexpress_tracking_id AS aliexpress_tracking_id_29 FROM config t0 LIMIT 1
Parameters:
[]
17 0.26 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
18 0.31 ms
SELECT t0.id AS id_1, t0.ip AS ip_2, t0.content AS content_3, t0.valid AS valid_4 FROM maintenance t0 LIMIT 1
Parameters:
[]
19 0.67 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.lft AS lft_2, c0_.lvl AS lvl_3, c0_.rgt AS rgt_4, c0_.ordre AS ordre_5, c0_.afficher AS afficher_6, c0_.meta_titre AS meta_titre_7, c0_.meta_description AS meta_description_8, c0_.url AS url_9, c0_.slug AS slug_10, c0_.menu AS menu_11, c0_.updated_at AS updated_at_12, c0_.created_at AS created_at_13, c1_.id AS id_14, c1_.name AS name_15, c1_.meta_titre AS meta_titre_16, c1_.meta_description AS meta_description_17, c1_.url AS url_18, c1_.locale AS locale_19 FROM categorie c0_ LEFT JOIN categorie_translation c1_ ON c0_.id = c1_.translatable_id WHERE c0_.afficher = 1 AND c1_.locale = ? ORDER BY c0_.tree_root ASC, c0_.lft ASC
Parameters:
[
  "fr"
]
20 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.lft AS lft_3, t0.lvl AS lvl_4, t0.rgt AS rgt_5, t0.ordre AS ordre_6, t0.afficher AS afficher_7, t0.meta_titre AS meta_titre_8, t0.meta_description AS meta_description_9, t0.url AS url_10, t0.slug AS slug_11, t0.menu AS menu_12, t0.updated_at AS updated_at_13, t0.created_at AS created_at_14, t0.tree_root AS tree_root_15, t0.parent_id AS parent_id_16 FROM categorie t0 WHERE t0.afficher = ?
Parameters:
[
  1
]
21 0.32 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
22 0.26 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
23 0.25 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
24 0.33 ms
SELECT t0.id AS id_1, t0.nom_image AS nom_image_2, t0.actif AS actif_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.section_id AS section_id_7 FROM image t0
Parameters:
[]
25 0.60 ms
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.afficher AS afficher_2, m0_.icon AS icon_3, m0_.section AS section_4, m0_.module_name AS module_name_5, m0_.see AS see_6, m0_.new AS new_7, m0_.edit AS edit_8, m0_.remove AS remove_9, m0_.parent AS parent_10 FROM module m0_ ORDER BY m0_.section ASC
Parameters:
[]
26 0.37 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.actif AS actif_3 FROM lang t0 WHERE t0.actif = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection
customer doctrine.dbal.customer_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
customer doctrine.orm.customer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Module 48
App\Entity\Image 11
App\Entity\Produit 3
App\Entity\ImageProduit 3
App\Entity\Categorie 2
App\Entity\SectionImage 2
App\Entity\Marque 1
App\Entity\Fournisseur 1
App\Entity\Config 1
App\Entity\Coordonnees 1
App\Entity\Lang 1

customer entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Produit No errors.
App\Entity\Categorie No errors.
App\Entity\ImageProduit No errors.
App\Entity\ProduitDeclinaison No errors.
App\Entity\Marque No errors.
App\Entity\Fournisseur No errors.
App\Entity\ReviewsProduct No errors.
App\Entity\CartDetails No errors.
App\Entity\OrderDetails No errors.
App\Entity\Client No errors.
App\Entity\Translation\ProduitTranslation No errors.
App\Entity\Article No errors.
App\Entity\Sommaires No errors.
App\Entity\Sommaire No errors.
App\Entity\GaleriePhoto No errors.
App\Entity\CategorieAlbum No errors.
App\Entity\ProduitVehicule No errors.
App\Entity\VilleRef No errors.
App\Entity\Banniere
  • The field 'App\Entity\Banniere#y' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Equipe No errors.
App\Entity\Carte No errors.
App\Entity\Translation\CategorieTranslation No errors.
App\Entity\Config No errors.
App\Entity\Image No errors.
App\Entity\SectionImage No errors.
App\Entity\Coordonnees No errors.
App\Entity\Maintenance No errors.
App\Entity\Module No errors.
App\Entity\Lang No errors.

customer entity manager

No loaded entities.