Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.46 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
0.91 ms (61.90%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 INNER JOIN car_etablissement ON t0.id = car_etablissement.etablissement_id WHERE car_etablissement.car_id = ? Parameters: [`3516`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 INNER JOIN car_etablissement ON t0.id = car_etablissement.etablissement_id WHERE car_etablissement.car_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 INNER JOIN car_etablissement ON t0.id = car_etablissement.etablissement_id WHERE car_etablissement.car_id = 3516;
0.56 ms (38.10%)	1	SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.user_id AS user_id_59 FROM car t0 WHERE t0.id = ? Parameters: [`"3516,"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.user_id AS user_id_59 FROM car t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.user_id AS user_id_59 FROM car t0 WHERE t0.id = '3516,';

Time▼

Count

Info

0.91 ms
(61.90%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 INNER JOIN car_etablissement ON t0.id = car_etablissement.etablissement_id WHERE car_etablissement.car_id = ?

Parameters:

[
  3516
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.adresse AS adresse_4,
  t0.postal_code AS postal_code_5,
  t0.telephone AS telephone_6,
  t0.contact_nom AS contact_nom_7,
  t0.photos AS photos_8,
  t0.fax AS fax_9,
  t0.state AS state_10,
  t0.count_car AS count_car_11,
  t0.ville AS ville_12,
  t0.latitude AS latitude_13,
  t0.longtitude AS longtitude_14,
  t0.description AS description_15,
  t0.cgi_code AS cgi_code_16,
  t0.time_week_morning_start AS time_week_morning_start_17,
  t0.time_week_morning_end AS time_week_morning_end_18,
  t0.time_week_afternoon_start AS time_week_afternoon_start_19,
  t0.time_week_afternoon_end AS time_week_afternoon_end_20,
  t0.time_we_morning_start AS time_we_morning_start_21,
  t0.time_we_morning_end AS time_we_morning_end_22,
  t0.time_we_afternoon_start AS time_we_afternoon_start_23,
  t0.time_we_afternoon_end AS time_we_afternoon_end_24,
  t0.autolink_id AS autolink_id_25,
  t0.email AS email_26,
  t0.image AS image_27,
  t0.siren AS siren_28,
  t0.autodiscount_name AS autodiscount_name_29,
  t0.autodiscount_email AS autodiscount_email_30,
  t0.autodiscount_phone AS autodiscount_phone_31,
  t0.concession_email AS concession_email_32,
  t0.concession_telephone AS concession_telephone_33,
  t0.virtuel AS virtuel_34,
  t0.id_base_tressol AS id_base_tressol_35,
  t0.id_google AS id_google_36,
  t0.affaire AS affaire_37,
  t0.siret AS siret_38,
  t0.garage_auto AS garage_auto_39,
  t0.garage_moto AS garage_moto_40,
  t0.occasion_pro AS occasion_pro_41,
  t0.publie AS publie_42,
  t0.experts AS experts_43,
  t0.total_review AS total_review_44,
  t0.average_review_rating AS average_review_rating_45,
  t0.seo_description AS seo_description_46,
  t0.opening_hours_text AS opening_hours_text_47,
  t0.opening_hours_periods AS opening_hours_periods_48,
  t0.raison_sociale AS raison_sociale_49,
  t0.detail_stockage AS detail_stockage_50,
  t0.street_number AS street_number_51,
  t0.route AS route_52,
  t0.bigquery AS bigquery_53,
  t0.email_lead_vo AS email_lead_vo_54,
  t0.disabled_google AS disabled_google_55,
  t0.enable_json_lead AS enable_json_lead_56,
  t0.show_if_no_stock AS show_if_no_stock_57,
  t0.mecaplanning_ent_id AS mecaplanning_ent_id_58,
  t0.mecaplanning_ent_key AS mecaplanning_ent_key_59,
  t0.mecaplanning_dms_id AS mecaplanning_dms_id_60,
  t0.mecaplanning_site_code AS mecaplanning_site_code_61,
  t0.mecaplanning_site_id AS mecaplanning_site_id_62,
  t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63,
  t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64,
  t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65
FROM
  etablissement t0
  INNER JOIN car_etablissement ON t0.id = car_etablissement.etablissement_id
WHERE
  car_etablissement.car_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.adresse AS adresse_4, t0.postal_code AS postal_code_5, t0.telephone AS telephone_6, t0.contact_nom AS contact_nom_7, t0.photos AS photos_8, t0.fax AS fax_9, t0.state AS state_10, t0.count_car AS count_car_11, t0.ville AS ville_12, t0.latitude AS latitude_13, t0.longtitude AS longtitude_14, t0.description AS description_15, t0.cgi_code AS cgi_code_16, t0.time_week_morning_start AS time_week_morning_start_17, t0.time_week_morning_end AS time_week_morning_end_18, t0.time_week_afternoon_start AS time_week_afternoon_start_19, t0.time_week_afternoon_end AS time_week_afternoon_end_20, t0.time_we_morning_start AS time_we_morning_start_21, t0.time_we_morning_end AS time_we_morning_end_22, t0.time_we_afternoon_start AS time_we_afternoon_start_23, t0.time_we_afternoon_end AS time_we_afternoon_end_24, t0.autolink_id AS autolink_id_25, t0.email AS email_26, t0.image AS image_27, t0.siren AS siren_28, t0.autodiscount_name AS autodiscount_name_29, t0.autodiscount_email AS autodiscount_email_30, t0.autodiscount_phone AS autodiscount_phone_31, t0.concession_email AS concession_email_32, t0.concession_telephone AS concession_telephone_33, t0.virtuel AS virtuel_34, t0.id_base_tressol AS id_base_tressol_35, t0.id_google AS id_google_36, t0.affaire AS affaire_37, t0.siret AS siret_38, t0.garage_auto AS garage_auto_39, t0.garage_moto AS garage_moto_40, t0.occasion_pro AS occasion_pro_41, t0.publie AS publie_42, t0.experts AS experts_43, t0.total_review AS total_review_44, t0.average_review_rating AS average_review_rating_45, t0.seo_description AS seo_description_46, t0.opening_hours_text AS opening_hours_text_47, t0.opening_hours_periods AS opening_hours_periods_48, t0.raison_sociale AS raison_sociale_49, t0.detail_stockage AS detail_stockage_50, t0.street_number AS street_number_51, t0.route AS route_52, t0.bigquery AS bigquery_53, t0.email_lead_vo AS email_lead_vo_54, t0.disabled_google AS disabled_google_55, t0.enable_json_lead AS enable_json_lead_56, t0.show_if_no_stock AS show_if_no_stock_57, t0.mecaplanning_ent_id AS mecaplanning_ent_id_58, t0.mecaplanning_ent_key AS mecaplanning_ent_key_59, t0.mecaplanning_dms_id AS mecaplanning_dms_id_60, t0.mecaplanning_site_code AS mecaplanning_site_code_61, t0.mecaplanning_site_id AS mecaplanning_site_id_62, t0.mecaplanning_workshop_code AS mecaplanning_workshop_code_63, t0.mecaplanning_workshop_id AS mecaplanning_workshop_id_64, t0.mecaplanning_porovider_name AS mecaplanning_porovider_name_65 FROM etablissement t0 INNER JOIN car_etablissement ON t0.id = car_etablissement.etablissement_id WHERE car_etablissement.car_id = 3516;

0.56 ms
(38.10%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.user_id AS user_id_59 FROM car t0 WHERE t0.id = ?

Parameters:

[
  "3516,"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.marque AS marque_3,
  t0.modele AS modele_4,
  t0.version AS version_5,
  t0.family AS family_6,
  t0.puissance AS puissance_7,
  t0.puissance_fiscale AS puissance_fiscale_8,
  t0.millesime AS millesime_9,
  t0.mise_en_circulation AS mise_en_circulation_10,
  t0.kilometrage AS kilometrage_11,
  t0.kilometrage_garanti AS kilometrage_garanti_12,
  t0.emission_co2 AS emission_co2_13,
  t0.premiere_main AS premiere_main_14,
  t0.nb_portes AS nb_portes_15,
  t0.nb_places AS nb_places_16,
  t0.eurotax_version AS eurotax_version_17,
  t0.label AS label_18,
  t0.lieu_stockage AS lieu_stockage_19,
  t0.detail_stockage AS detail_stockage_20,
  t0.immatriculation AS immatriculation_21,
  t0.vp_vu AS vp_vu_22,
  t0.offre_type AS offre_type_23,
  t0.prix AS prix_24,
  t0.garantie AS garantie_25,
  t0.eligible_prime_gouv AS eligible_prime_gouv_26,
  t0.tva_recuperable AS tva_recuperable_27,
  t0.tva_montant AS tva_montant_28,
  t0.categorie AS categorie_29,
  t0.couleur AS couleur_30,
  t0.photos AS photos_31,
  t0.carrosserie AS carrosserie_32,
  t0.energie_type AS energie_type_33,
  t0.contact_afficher AS contact_afficher_34,
  t0.telephone_afficher AS telephone_afficher_35,
  t0.email_afficher AS email_afficher_36,
  t0.boite_de_vitesse_type AS boite_de_vitesse_type_37,
  t0.url360 AS url360_38,
  t0.options AS options_39,
  t0.equipements AS equipements_40,
  t0.mensualise AS mensualise_41,
  t0.critair AS critair_42,
  t0.essai AS essai_43,
  t0.cgi_prix AS cgi_prix_44,
  t0.cgi_details AS cgi_details_45,
  t0.vin AS vin_46,
  t0.eligible_contrat_entretien AS eligible_contrat_entretien_47,
  t0.usage_principale AS usage_principale_48,
  t0.loi_de_roulage AS loi_de_roulage_49,
  t0.avantage_principal AS avantage_principal_50,
  t0.usage_principal AS usage_principal_51,
  t0.type AS type_52,
  t0.car_type AS car_type_53,
  t0.natcode AS natcode_54,
  t0.media_natcode AS media_natcode_55,
  t0.published AS published_56,
  t0.created_at AS created_at_57,
  t0.updated_at AS updated_at_58,
  t0.user_id AS user_id_59
FROM
  car t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.marque AS marque_3, t0.modele AS modele_4, t0.version AS version_5, t0.family AS family_6, t0.puissance AS puissance_7, t0.puissance_fiscale AS puissance_fiscale_8, t0.millesime AS millesime_9, t0.mise_en_circulation AS mise_en_circulation_10, t0.kilometrage AS kilometrage_11, t0.kilometrage_garanti AS kilometrage_garanti_12, t0.emission_co2 AS emission_co2_13, t0.premiere_main AS premiere_main_14, t0.nb_portes AS nb_portes_15, t0.nb_places AS nb_places_16, t0.eurotax_version AS eurotax_version_17, t0.label AS label_18, t0.lieu_stockage AS lieu_stockage_19, t0.detail_stockage AS detail_stockage_20, t0.immatriculation AS immatriculation_21, t0.vp_vu AS vp_vu_22, t0.offre_type AS offre_type_23, t0.prix AS prix_24, t0.garantie AS garantie_25, t0.eligible_prime_gouv AS eligible_prime_gouv_26, t0.tva_recuperable AS tva_recuperable_27, t0.tva_montant AS tva_montant_28, t0.categorie AS categorie_29, t0.couleur AS couleur_30, t0.photos AS photos_31, t0.carrosserie AS carrosserie_32, t0.energie_type AS energie_type_33, t0.contact_afficher AS contact_afficher_34, t0.telephone_afficher AS telephone_afficher_35, t0.email_afficher AS email_afficher_36, t0.boite_de_vitesse_type AS boite_de_vitesse_type_37, t0.url360 AS url360_38, t0.options AS options_39, t0.equipements AS equipements_40, t0.mensualise AS mensualise_41, t0.critair AS critair_42, t0.essai AS essai_43, t0.cgi_prix AS cgi_prix_44, t0.cgi_details AS cgi_details_45, t0.vin AS vin_46, t0.eligible_contrat_entretien AS eligible_contrat_entretien_47, t0.usage_principale AS usage_principale_48, t0.loi_de_roulage AS loi_de_roulage_49, t0.avantage_principal AS avantage_principal_50, t0.usage_principal AS usage_principal_51, t0.type AS type_52, t0.car_type AS car_type_53, t0.natcode AS natcode_54, t0.media_natcode AS media_natcode_55, t0.published AS published_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.user_id AS user_id_59 FROM car t0 WHERE t0.id = '3516,';

Database Connections

Name	Service
default	doctrine.dbal.default_connection
internal	doctrine.dbal.internal_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
internal	doctrine.orm.internal_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Car	No errors.
App\Entity\User	No errors.
App\Entity\CarMedia	No errors.
App\Entity\CarAddition	No errors.
App\Entity\Etablissement	No errors.
App\Entity\CarEntretien	No errors.
App\Entity\Favorite	No errors.
App\Entity\MyBuyProject	No errors.
App\Entity\Meeting	No errors.
App\Entity\Lead	No errors.
App\Entity\CarMarque	No errors.
App\Entity\EtablissementService	No errors.
App\Entity\ReviewDetail	No errors.
App\Entity\ExpertContact	No errors.
App\Entity\LeadEstimate	No errors.
App\Entity\PrendreRdv	No errors.
App\Entity\ClientRequest	No errors.
App\Entity\GroupEtablissement	No errors.

internal entity manager

No loaded entities.