Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.99 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
0.51 ms (51.04%)	1	SELECT c0_.id AS id_0, c0_.photos AS photos_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.millesime AS millesime_5, c0_.carrosserie AS carrosserie_6, c0_.prix AS prix_7, c0_.type AS type_8 FROM car c0_ WHERE c0_.id IN (?) AND c0_.published = 1 Parameters: [`2332`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.photos AS photos_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.millesime AS millesime_5, c0_.carrosserie AS carrosserie_6, c0_.prix AS prix_7, c0_.type AS type_8 FROM car c0_ WHERE c0_.id IN (?) AND c0_.published = 1 SELECT c0_.id AS id_0, c0_.photos AS photos_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.millesime AS millesime_5, c0_.carrosserie AS carrosserie_6, c0_.prix AS prix_7, c0_.type AS type_8 FROM car c0_ WHERE c0_.id IN (2332) AND c0_.published = 1;
0.49 ms (48.96%)	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 = ? LIMIT 1 Parameters: [`2332`] 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 = ? LIMIT 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 = 2332 LIMIT 1;

Time▼

Count

Info

0.51 ms
(51.04%)

SELECT c0_.id AS id_0, c0_.photos AS photos_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.millesime AS millesime_5, c0_.carrosserie AS carrosserie_6, c0_.prix AS prix_7, c0_.type AS type_8 FROM car c0_ WHERE c0_.id IN (?) AND c0_.published = 1

Parameters:

[
  2332
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.photos AS photos_1,
  c0_.marque AS marque_2,
  c0_.modele AS modele_3,
  c0_.version AS version_4,
  c0_.millesime AS millesime_5,
  c0_.carrosserie AS carrosserie_6,
  c0_.prix AS prix_7,
  c0_.type AS type_8
FROM
  car c0_
WHERE
  c0_.id IN (?)
  AND c0_.published = 1

SELECT c0_.id AS id_0, c0_.photos AS photos_1, c0_.marque AS marque_2, c0_.modele AS modele_3, c0_.version AS version_4, c0_.millesime AS millesime_5, c0_.carrosserie AS carrosserie_6, c0_.prix AS prix_7, c0_.type AS type_8 FROM car c0_ WHERE c0_.id IN (2332) AND c0_.published = 1;

0.49 ms
(48.96%)

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 = ? LIMIT 1

Parameters:

[
  2332
]

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 = ?
LIMIT
  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 = 2332 LIMIT 1;

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.

internal entity manager

No loaded entities.