Query Metrics

22 Database Queries
12 Different statements
11.74 ms Query time
1 Invalid entities
70 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.prix AS prix_3, t0.description AS description_4, t0.nouveaute AS nouveaute_5, t0.promotion AS promotion_6, t0.actif AS actif_7, t0.banniere AS banniere_8, t0.slug AS slug_9, t0.meta_titre AS meta_titre_10, t0.meta_description AS meta_description_11, t0.prix_ttc AS prix_ttc_12, t0.cout_fournisseur AS cout_fournisseur_13, t0.quantite AS quantite_14, t0.reference AS reference_15, t0.resume AS resume_16, t0.caracteristiques AS caracteristiques_17, t0.aliexpress_product_id AS aliexpress_product_id_18, t0.aliexpress_product_url AS aliexpress_product_url_19, t0.aliexpress_imported_at AS aliexpress_imported_at_20, t0.updated_at AS updated_at_21, t0.created_at AS created_at_22, t0.marque_id AS marque_id_23, t0.fournisseur_id AS fournisseur_id_24 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
2 0.67 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:
[]
3 0.51 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:
[]
4 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM section_image t0 WHERE t0.id = ?
Parameters:
[
  2
]
6 0.38 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.35 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:
[]
8 0.41 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:
[]
9 0.62 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
]
10 0.51 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:
[]
11 0.46 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:
[]
12 0.46 ms
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:
[
  4
]
13 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:
[]
14 0.40 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:
[]
15 0.82 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"
]
16 0.73 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
]
17 0.65 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.45 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:
[]
19 0.42 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:
[]
20 0.45 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:
[]
21 0.98 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:
[]
22 0.49 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\SectionImage 2
App\Entity\Categorie 2
App\Entity\Produit 1
App\Entity\Marque 1
App\Entity\Fournisseur 1
App\Entity\Config 1
App\Entity\Coordonnees 1
App\Entity\Translation\ProduitTranslation 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\Marque No errors.
App\Entity\Fournisseur No errors.
App\Entity\Categorie No errors.
App\Entity\ImageProduit No errors.
App\Entity\ReviewsProduct No errors.
App\Entity\CartDetails No errors.
App\Entity\OrderDetails No errors.
App\Entity\ProduitDeclinaison No errors.
App\Entity\Client No errors.
App\Entity\Translation\ProduitTranslation 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\Translation\CategorieTranslation 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\Module No errors.
App\Entity\Lang No errors.

customer entity manager

No loaded entities.