Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.finish AS finish_2,
  t0.mileage AS mileage_3,
  t0.in_service_date AS in_service_date_4,
  t0.power AS power_5,
  t0.power_din AS power_din_6,
  t0.nb_door AS nb_door_7,
  t0.nb_seat AS nb_seat_8,
  t0.co2 AS co2_9,
  t0.eloa_ref AS eloa_ref_10,
  t0.eloa_statut AS eloa_statut_11,
  t0.eloa_date_migration AS eloa_date_migration_12,
  t0.active AS active_13,
  t0.archive AS archive_14,
  t0.archive_custom_reason AS archive_custom_reason_15,
  t0.archived_at AS archived_at_16,
  t0.brand_warranty_end_date AS brand_warranty_end_date_17,
  t0.cantonal_annotation AS cantonal_annotation_18,
  t0.chassis_number AS chassis_number_19,
  t0.commission AS commission_20,
  t0.created AS created_21,
  t0.damaged AS damaged_22,
  t0.damaged_description AS damaged_description_23,
  t0.date_certificate_number_plate AS date_certificate_number_plate_24,
  t0.description AS description_25,
  t0.dual_key AS dual_key_26,
  t0.engine_size AS engine_size_27,
  t0.exclusive_sale AS exclusive_sale_28,
  t0.financing_default_price AS financing_default_price_29,
  t0.finish_leocare AS finish_leocare_30,
  t0.formula_number_number_plate AS formula_number_number_plate_31,
  t0.good_deal AS good_deal_32,
  t0.horse_power AS horse_power_33,
  t0.id_leocare AS id_leocare_34,
  t0.interior AS interior_35,
  t0.is_first_hand AS is_first_hand_36,
  t0.is_leasing AS is_leasing_37,
  t0.is_vat_recoverable AS is_vat_recoverable_38,
  t0.is_yescar_repossession AS is_yescar_repossession_39,
  t0.kw_power AS kw_power_40,
  t0.last_revision_date AS last_revision_date_41,
  t0.last_revision_description AS last_revision_description_42,
  t0.last_revision_mileage AS last_revision_mileage_43,
  t0.mileage_timing_belt AS mileage_timing_belt_44,
  t0.min_price AS min_price_45,
  t0.multicasted_elsewhere AS multicasted_elsewhere_46,
  t0.multicasted_elsewhere_description AS multicasted_elsewhere_description_47,
  t0.number_plate AS number_plate_48,
  t0.original_price AS original_price_49,
  t0.prestige AS prestige_50,
  t0.price AS price_51,
  t0.private_comment AS private_comment_52,
  t0.reception_by_type AS reception_by_type_53,
  t0.registration_number AS registration_number_54,
  t0.seller_price AS seller_price_55,
  t0.service_manual AS service_manual_56,
  t0.size_rim AS size_rim_57,
  t0.slug AS slug_58,
  t0.technical_check_date AS technical_check_date_59,
  t0.technical_check_description AS technical_check_description_60,
  t0.timing_belt_description AS timing_belt_description_61,
  t0.tire_back_left_description AS tire_back_left_description_62,
  t0.tire_back_right_description AS tire_back_right_description_63,
  t0.tire_front_left_description AS tire_front_left_description_64,
  t0.tire_front_right_description AS tire_front_right_description_65,
  t0.type_variant_version AS type_variant_version_66,
  t0.under_sale_agreement AS under_sale_agreement_67,
  t0.updated AS updated_68,
  t0.use_as_security AS use_as_security_69,
  t0.user_manual AS user_manual_70,
  t0.warranty_duration AS warranty_duration_71,
  t0.warranty_price AS warranty_price_72,
  t0.workflow AS workflow_73,
  t0.zip_archive AS zip_archive_74,
  t0.has_lead_eloa AS has_lead_eloa_75,
  t0.vehicle_migrated AS vehicle_migrated_76,
  t0.eloa_updated_at AS eloa_updated_at_77,
  t0.created_at AS created_at_78,
  t0.updated_at AS updated_at_79,
  t0.agency_id AS agency_id_80,
  t0.transmission_id AS transmission_id_81,
  t0.vehicle_type_id AS vehicle_type_id_82,
  t0.critair_id AS critair_id_83,
  t0.fuel_id AS fuel_id_84,
  t0.model_id AS model_id_85,
  t0.document_id AS document_id_86,
  t0.user_id AS user_id_87,
  t0.ambassador_id AS ambassador_id_88,
  t0.archive_type_id AS archive_type_id_89,
  t0.bodywork_id AS bodywork_id_90,
  t0.buyer_id AS buyer_id_91,
  t0.color_id AS color_id_92,
  t0.euro_norm_id AS euro_norm_id_93,
  t0.origin_id AS origin_id_94,
  t0.workmate_registered_id AS workmate_registered_id_95,
  t0.workmate_sold_id AS workmate_sold_id_96,
  t0.vehicle_eloa_id AS vehicle_eloa_id_97
FROM
  vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.finish AS finish_2, t0.mileage AS mileage_3, t0.in_service_date AS in_service_date_4, t0.power AS power_5, t0.power_din AS power_din_6, t0.nb_door AS nb_door_7, t0.nb_seat AS nb_seat_8, t0.co2 AS co2_9, t0.eloa_ref AS eloa_ref_10, t0.eloa_statut AS eloa_statut_11, t0.eloa_date_migration AS eloa_date_migration_12, t0.active AS active_13, t0.archive AS archive_14, t0.archive_custom_reason AS archive_custom_reason_15, t0.archived_at AS archived_at_16, t0.brand_warranty_end_date AS brand_warranty_end_date_17, t0.cantonal_annotation AS cantonal_annotation_18, t0.chassis_number AS chassis_number_19, t0.commission AS commission_20, t0.created AS created_21, t0.damaged AS damaged_22, t0.damaged_description AS damaged_description_23, t0.date_certificate_number_plate AS date_certificate_number_plate_24, t0.description AS description_25, t0.dual_key AS dual_key_26, t0.engine_size AS engine_size_27, t0.exclusive_sale AS exclusive_sale_28, t0.financing_default_price AS financing_default_price_29, t0.finish_leocare AS finish_leocare_30, t0.formula_number_number_plate AS formula_number_number_plate_31, t0.good_deal AS good_deal_32, t0.horse_power AS horse_power_33, t0.id_leocare AS id_leocare_34, t0.interior AS interior_35, t0.is_first_hand AS is_first_hand_36, t0.is_leasing AS is_leasing_37, t0.is_vat_recoverable AS is_vat_recoverable_38, t0.is_yescar_repossession AS is_yescar_repossession_39, t0.kw_power AS kw_power_40, t0.last_revision_date AS last_revision_date_41, t0.last_revision_description AS last_revision_description_42, t0.last_revision_mileage AS last_revision_mileage_43, t0.mileage_timing_belt AS mileage_timing_belt_44, t0.min_price AS min_price_45, t0.multicasted_elsewhere AS multicasted_elsewhere_46, t0.multicasted_elsewhere_description AS multicasted_elsewhere_description_47, t0.number_plate AS number_plate_48, t0.original_price AS original_price_49, t0.prestige AS prestige_50, t0.price AS price_51, t0.private_comment AS private_comment_52, t0.reception_by_type AS reception_by_type_53, t0.registration_number AS registration_number_54, t0.seller_price AS seller_price_55, t0.service_manual AS service_manual_56, t0.size_rim AS size_rim_57, t0.slug AS slug_58, t0.technical_check_date AS technical_check_date_59, t0.technical_check_description AS technical_check_description_60, t0.timing_belt_description AS timing_belt_description_61, t0.tire_back_left_description AS tire_back_left_description_62, t0.tire_back_right_description AS tire_back_right_description_63, t0.tire_front_left_description AS tire_front_left_description_64, t0.tire_front_right_description AS tire_front_right_description_65, t0.type_variant_version AS type_variant_version_66, t0.under_sale_agreement AS under_sale_agreement_67, t0.updated AS updated_68, t0.use_as_security AS use_as_security_69, t0.user_manual AS user_manual_70, t0.warranty_duration AS warranty_duration_71, t0.warranty_price AS warranty_price_72, t0.workflow AS workflow_73, t0.zip_archive AS zip_archive_74, t0.has_lead_eloa AS has_lead_eloa_75, t0.vehicle_migrated AS vehicle_migrated_76, t0.eloa_updated_at AS eloa_updated_at_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79, t0.agency_id AS agency_id_80, t0.transmission_id AS transmission_id_81, t0.vehicle_type_id AS vehicle_type_id_82, t0.critair_id AS critair_id_83, t0.fuel_id AS fuel_id_84, t0.model_id AS model_id_85, t0.document_id AS document_id_86, t0.user_id AS user_id_87, t0.ambassador_id AS ambassador_id_88, t0.archive_type_id AS archive_type_id_89, t0.bodywork_id AS bodywork_id_90, t0.buyer_id AS buyer_id_91, t0.color_id AS color_id_92, t0.euro_norm_id AS euro_norm_id_93, t0.origin_id AS origin_id_94, t0.workmate_registered_id AS workmate_registered_id_95, t0.workmate_sold_id AS workmate_sold_id_96, t0.vehicle_eloa_id AS vehicle_eloa_id_97 FROM vehicle t0 WHERE t0.id = '173504';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.multi_caster_id AS multi_caster_id_4,
  t0.telephone AS telephone_5,
  t0.siret AS siret_6,
  t0.is_active AS is_active_7,
  t0.eloa_ref AS eloa_ref_8,
  t0.eloa_last_check AS eloa_last_check_9,
  t0.eloa_statut AS eloa_statut_10,
  t0.libelle AS libelle_11,
  t0.reference_entite AS reference_entite_12,
  t0.raison_sociale AS raison_sociale_13,
  t0.ref_type_reseau AS ref_type_reseau_14,
  t0.orias AS orias_15,
  t0.description AS description_16,
  t0.has_grey_card_service AS has_grey_card_service_17,
  t0.slug AS slug_18,
  t0.has_loyalty_program AS has_loyalty_program_19,
  t0.has_up_my_shop AS has_up_my_shop_20,
  t0.latitude AS latitude_21,
  t0.longitude AS longitude_22,
  t0.royalty_network_date AS royalty_network_date_23,
  t0.royalty_remainder AS royalty_remainder_24,
  t0.fiscal_code_it AS fiscal_code_it_25,
  t0.leocare_id AS leocare_id_26,
  t0.autoscout24_api_id AS autoscout24_api_id_27,
  t0.up_my_shop_url AS up_my_shop_url_28,
  t0.lacentrale_id AS lacentrale_id_29,
  t0.has_annoncesautomobile AS has_annoncesautomobile_30,
  t0.definitively_inactive AS definitively_inactive_31,
  t0.first_contract_date AS first_contract_date_32,
  t0.opening_date AS opening_date_33,
  t0.vosfactures_id AS vosfactures_id_34,
  t0.vosfactures_client_id AS vosfactures_client_id_35,
  t0.grey_card_website AS grey_card_website_36,
  t0.has_cps AS has_cps_37,
  t0.contract_date AS contract_date_38,
  t0.autoscout24_id AS autoscout24_id_39,
  t0.paruvendu_id AS paruvendu_id_40,
  t0.ouestfrance_id AS ouestfrance_id_41,
  t0.atoutcoin_id AS atoutcoin_id_42,
  t0.royalty_variable_date AS royalty_variable_date_43,
  t0.royalty_communication_date AS royalty_communication_date_44,
  t0.agency_migrated AS agency_migrated_45,
  t0.facturation_id AS facturation_id_46,
  t0.invoice_number AS invoice_number_47,
  t0.address_number AS address_number_48,
  t0.address_extension AS address_extension_49,
  t0.address_street AS address_street_50,
  t0.address AS address_51,
  t0.created_at AS created_at_52,
  t0.updated_at AS updated_at_53,
  t0.city_id AS city_id_54,
  t0.company_id AS company_id_55,
  t0.royalty_network_id AS royalty_network_id_56,
  t0.royalty_communication_id AS royalty_communication_id_57,
  t0.royalty_variable_id AS royalty_variable_id_58,
  t0.close_reason_id AS close_reason_id_59
FROM
  agency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.multi_caster_id AS multi_caster_id_4, t0.telephone AS telephone_5, t0.siret AS siret_6, t0.is_active AS is_active_7, t0.eloa_ref AS eloa_ref_8, t0.eloa_last_check AS eloa_last_check_9, t0.eloa_statut AS eloa_statut_10, t0.libelle AS libelle_11, t0.reference_entite AS reference_entite_12, t0.raison_sociale AS raison_sociale_13, t0.ref_type_reseau AS ref_type_reseau_14, t0.orias AS orias_15, t0.description AS description_16, t0.has_grey_card_service AS has_grey_card_service_17, t0.slug AS slug_18, t0.has_loyalty_program AS has_loyalty_program_19, t0.has_up_my_shop AS has_up_my_shop_20, t0.latitude AS latitude_21, t0.longitude AS longitude_22, t0.royalty_network_date AS royalty_network_date_23, t0.royalty_remainder AS royalty_remainder_24, t0.fiscal_code_it AS fiscal_code_it_25, t0.leocare_id AS leocare_id_26, t0.autoscout24_api_id AS autoscout24_api_id_27, t0.up_my_shop_url AS up_my_shop_url_28, t0.lacentrale_id AS lacentrale_id_29, t0.has_annoncesautomobile AS has_annoncesautomobile_30, t0.definitively_inactive AS definitively_inactive_31, t0.first_contract_date AS first_contract_date_32, t0.opening_date AS opening_date_33, t0.vosfactures_id AS vosfactures_id_34, t0.vosfactures_client_id AS vosfactures_client_id_35, t0.grey_card_website AS grey_card_website_36, t0.has_cps AS has_cps_37, t0.contract_date AS contract_date_38, t0.autoscout24_id AS autoscout24_id_39, t0.paruvendu_id AS paruvendu_id_40, t0.ouestfrance_id AS ouestfrance_id_41, t0.atoutcoin_id AS atoutcoin_id_42, t0.royalty_variable_date AS royalty_variable_date_43, t0.royalty_communication_date AS royalty_communication_date_44, t0.agency_migrated AS agency_migrated_45, t0.facturation_id AS facturation_id_46, t0.invoice_number AS invoice_number_47, t0.address_number AS address_number_48, t0.address_extension AS address_extension_49, t0.address_street AS address_street_50, t0.address AS address_51, t0.created_at AS created_at_52, t0.updated_at AS updated_at_53, t0.city_id AS city_id_54, t0.company_id AS company_id_55, t0.royalty_network_id AS royalty_network_id_56, t0.royalty_communication_id AS royalty_communication_id_57, t0.royalty_variable_id AS royalty_variable_id_58, t0.close_reason_id AS close_reason_id_59 FROM agency t0 WHERE t0.id = 182;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = 'it' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.position AS position_3,
  t0.eloa_url AS eloa_url_4,
  t0.eloa_order AS eloa_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agency_id AS agency_id_8,
  t0.vehicle_id AS vehicle_id_9
FROM
  image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.vehicle_id = 173504 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  equipment t0
  INNER JOIN vehicle_equipment ON t0.id = vehicle_equipment.equipment_id
WHERE
  vehicle_equipment.vehicle_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM equipment t0 INNER JOIN vehicle_equipment ON t0.id = vehicle_equipment.equipment_id WHERE vehicle_equipment.vehicle_id = 173504;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.insee_code AS insee_code_6,
  t0.department_id AS department_id_7
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.insee_code AS insee_code_6, t0.department_id AS department_id_7 FROM city t0 WHERE t0.id = 32882;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.ubiflow_id AS ubiflow_id_4,
  t0.paruvendu_id AS paruvendu_id_5,
  t0.lacentrale_id AS lacentrale_id_6
FROM
  fuel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ubiflow_id AS ubiflow_id_4, t0.paruvendu_id AS paruvendu_id_5, t0.lacentrale_id AS lacentrale_id_6 FROM fuel t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.postal_code AS postal_code_3,
  t0.country_id AS country_id_4
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.country_id AS country_id_4 FROM department t0 WHERE t0.id = 94;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.make_id AS make_id_3
FROM
  model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.make_id AS make_id_3 FROM model t0 WHERE t0.id = 548;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  make t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM make t0 WHERE t0.id = 70;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.id = 75;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  vehicle_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_type t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  transmission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM transmission t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.vehicle_id AS vehicle_id_3
FROM
  equipment_extra t0
WHERE
  t0.vehicle_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.vehicle_id AS vehicle_id_3 FROM equipment_extra t0 WHERE t0.vehicle_id = 173504;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  color t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM color t0 WHERE t0.id = 1;