Symfony Profiler

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 = 'fr' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          v0_.id AS id_0,
          v0_.finish AS finish_1,
          v0_.mileage AS mileage_2,
          v0_.in_service_date AS in_service_date_3,
          v0_.power AS power_4,
          v0_.power_din AS power_din_5,
          v0_.nb_door AS nb_door_6,
          v0_.nb_seat AS nb_seat_7,
          v0_.co2 AS co2_8,
          v0_.eloa_ref AS eloa_ref_9,
          v0_.eloa_statut AS eloa_statut_10,
          v0_.eloa_date_migration AS eloa_date_migration_11,
          v0_.lbc_date_publish AS lbc_date_publish_12,
          v0_.lbc_date_unpublish AS lbc_date_unpublish_13,
          v0_.lbc_date_update AS lbc_date_update_14,
          v0_.autoscout_date_publish AS autoscout_date_publish_15,
          v0_.autoscout_date_unpublish AS autoscout_date_unpublish_16,
          v0_.autoscout_date_update AS autoscout_date_update_17,
          v0_.active AS active_18,
          v0_.archive AS archive_19,
          v0_.archive_custom_reason AS archive_custom_reason_20,
          v0_.archived_at AS archived_at_21,
          v0_.brand_warranty_end_date AS brand_warranty_end_date_22,
          v0_.cantonal_annotation AS cantonal_annotation_23,
          v0_.chassis_number AS chassis_number_24,
          v0_.commission AS commission_25,
          v0_.created AS created_26,
          v0_.damaged AS damaged_27,
          v0_.damaged_description AS damaged_description_28,
          v0_.date_certificate_number_plate AS date_certificate_number_plate_29,
          v0_.description AS description_30,
          v0_.dual_key AS dual_key_31,
          v0_.engine_size AS engine_size_32,
          v0_.exclusive_sale AS exclusive_sale_33,
          v0_.financing_default_price AS financing_default_price_34,
          v0_.finish_leocare AS finish_leocare_35,
          v0_.formula_number_number_plate AS formula_number_number_plate_36,
          v0_.good_deal AS good_deal_37,
          v0_.horse_power AS horse_power_38,
          v0_.id_leocare AS id_leocare_39,
          v0_.interior AS interior_40,
          v0_.is_first_hand AS is_first_hand_41,
          v0_.is_leasing AS is_leasing_42,
          v0_.is_vat_recoverable AS is_vat_recoverable_43,
          v0_.is_yescar_repossession AS is_yescar_repossession_44,
          v0_.kw_power AS kw_power_45,
          v0_.last_revision_date AS last_revision_date_46,
          v0_.last_revision_description AS last_revision_description_47,
          v0_.last_revision_mileage AS last_revision_mileage_48,
          v0_.mileage_timing_belt AS mileage_timing_belt_49,
          v0_.min_price AS min_price_50,
          v0_.multicasted_elsewhere AS multicasted_elsewhere_51,
          v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_52,
          v0_.number_plate AS number_plate_53,
          v0_.original_price AS original_price_54,
          v0_.prestige AS prestige_55,
          v0_.price AS price_56,
          v0_.private_comment AS private_comment_57,
          v0_.reception_by_type AS reception_by_type_58,
          v0_.registration_number AS registration_number_59,
          v0_.seller_price AS seller_price_60,
          v0_.service_manual AS service_manual_61,
          v0_.size_rim AS size_rim_62,
          v0_.slug AS slug_63,
          v0_.technical_check_date AS technical_check_date_64,
          v0_.technical_check_description AS technical_check_description_65,
          v0_.timing_belt_description AS timing_belt_description_66,
          v0_.tire_back_left_description AS tire_back_left_description_67,
          v0_.tire_back_right_description AS tire_back_right_description_68,
          v0_.tire_front_left_description AS tire_front_left_description_69,
          v0_.tire_front_right_description AS tire_front_right_description_70,
          v0_.type_variant_version AS type_variant_version_71,
          v0_.under_sale_agreement AS under_sale_agreement_72,
          v0_.updated AS updated_73,
          v0_.use_as_security AS use_as_security_74,
          v0_.user_manual AS user_manual_75,
          v0_.warranty_duration AS warranty_duration_76,
          v0_.warranty_price AS warranty_price_77,
          v0_.workflow AS workflow_78,
          v0_.zip_archive AS zip_archive_79,
          v0_.has_lead_eloa AS has_lead_eloa_80,
          v0_.vehicle_migrated AS vehicle_migrated_81,
          v0_.eloa_updated_at AS eloa_updated_at_82,
          v0_.autoscout_id AS autoscout_id_83,
          v0_.created_at AS created_at_84,
          v0_.updated_at AS updated_at_85
        FROM
          vehicle v0_
          INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id
          INNER JOIN fuel f2_ ON v0_.fuel_id = f2_.id
        WHERE
          v0_.active IN (?)
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.finish AS finish_1, v0_.mileage AS mileage_2, v0_.in_service_date AS in_service_date_3, v0_.power AS power_4, v0_.power_din AS power_din_5, v0_.nb_door AS nb_door_6, v0_.nb_seat AS nb_seat_7, v0_.co2 AS co2_8, v0_.eloa_ref AS eloa_ref_9, v0_.eloa_statut AS eloa_statut_10, v0_.eloa_date_migration AS eloa_date_migration_11, v0_.lbc_date_publish AS lbc_date_publish_12, v0_.lbc_date_unpublish AS lbc_date_unpublish_13, v0_.lbc_date_update AS lbc_date_update_14, v0_.autoscout_date_publish AS autoscout_date_publish_15, v0_.autoscout_date_unpublish AS autoscout_date_unpublish_16, v0_.autoscout_date_update AS autoscout_date_update_17, v0_.active AS active_18, v0_.archive AS archive_19, v0_.archive_custom_reason AS archive_custom_reason_20, v0_.archived_at AS archived_at_21, v0_.brand_warranty_end_date AS brand_warranty_end_date_22, v0_.cantonal_annotation AS cantonal_annotation_23, v0_.chassis_number AS chassis_number_24, v0_.commission AS commission_25, v0_.created AS created_26, v0_.damaged AS damaged_27, v0_.damaged_description AS damaged_description_28, v0_.date_certificate_number_plate AS date_certificate_number_plate_29, v0_.description AS description_30, v0_.dual_key AS dual_key_31, v0_.engine_size AS engine_size_32, v0_.exclusive_sale AS exclusive_sale_33, v0_.financing_default_price AS financing_default_price_34, v0_.finish_leocare AS finish_leocare_35, v0_.formula_number_number_plate AS formula_number_number_plate_36, v0_.good_deal AS good_deal_37, v0_.horse_power AS horse_power_38, v0_.id_leocare AS id_leocare_39, v0_.interior AS interior_40, v0_.is_first_hand AS is_first_hand_41, v0_.is_leasing AS is_leasing_42, v0_.is_vat_recoverable AS is_vat_recoverable_43, v0_.is_yescar_repossession AS is_yescar_repossession_44, v0_.kw_power AS kw_power_45, v0_.last_revision_date AS last_revision_date_46, v0_.last_revision_description AS last_revision_description_47, v0_.last_revision_mileage AS last_revision_mileage_48, v0_.mileage_timing_belt AS mileage_timing_belt_49, v0_.min_price AS min_price_50, v0_.multicasted_elsewhere AS multicasted_elsewhere_51, v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_52, v0_.number_plate AS number_plate_53, v0_.original_price AS original_price_54, v0_.prestige AS prestige_55, v0_.price AS price_56, v0_.private_comment AS private_comment_57, v0_.reception_by_type AS reception_by_type_58, v0_.registration_number AS registration_number_59, v0_.seller_price AS seller_price_60, v0_.service_manual AS service_manual_61, v0_.size_rim AS size_rim_62, v0_.slug AS slug_63, v0_.technical_check_date AS technical_check_date_64, v0_.technical_check_description AS technical_check_description_65, v0_.timing_belt_description AS timing_belt_description_66, v0_.tire_back_left_description AS tire_back_left_description_67, v0_.tire_back_right_description AS tire_back_right_description_68, v0_.tire_front_left_description AS tire_front_left_description_69, v0_.tire_front_right_description AS tire_front_right_description_70, v0_.type_variant_version AS type_variant_version_71, v0_.under_sale_agreement AS under_sale_agreement_72, v0_.updated AS updated_73, v0_.use_as_security AS use_as_security_74, v0_.user_manual AS user_manual_75, v0_.warranty_duration AS warranty_duration_76, v0_.warranty_price AS warranty_price_77, v0_.workflow AS workflow_78, v0_.zip_archive AS zip_archive_79, v0_.has_lead_eloa AS has_lead_eloa_80, v0_.vehicle_migrated AS vehicle_migrated_81, v0_.eloa_updated_at AS eloa_updated_at_82, v0_.autoscout_id AS autoscout_id_83, v0_.created_at AS created_at_84, v0_.updated_at AS updated_at_85 FROM vehicle v0_ INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id INNER JOIN fuel f2_ ON v0_.fuel_id = f2_.id WHERE v0_.active IN (1)) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      v0_.id AS id_0,
      v0_.finish AS finish_1,
      v0_.mileage AS mileage_2,
      v0_.in_service_date AS in_service_date_3,
      v0_.power AS power_4,
      v0_.power_din AS power_din_5,
      v0_.nb_door AS nb_door_6,
      v0_.nb_seat AS nb_seat_7,
      v0_.co2 AS co2_8,
      v0_.eloa_ref AS eloa_ref_9,
      v0_.eloa_statut AS eloa_statut_10,
      v0_.eloa_date_migration AS eloa_date_migration_11,
      v0_.lbc_date_publish AS lbc_date_publish_12,
      v0_.lbc_date_unpublish AS lbc_date_unpublish_13,
      v0_.lbc_date_update AS lbc_date_update_14,
      v0_.autoscout_date_publish AS autoscout_date_publish_15,
      v0_.autoscout_date_unpublish AS autoscout_date_unpublish_16,
      v0_.autoscout_date_update AS autoscout_date_update_17,
      v0_.active AS active_18,
      v0_.archive AS archive_19,
      v0_.archive_custom_reason AS archive_custom_reason_20,
      v0_.archived_at AS archived_at_21,
      v0_.brand_warranty_end_date AS brand_warranty_end_date_22,
      v0_.cantonal_annotation AS cantonal_annotation_23,
      v0_.chassis_number AS chassis_number_24,
      v0_.commission AS commission_25,
      v0_.created AS created_26,
      v0_.damaged AS damaged_27,
      v0_.damaged_description AS damaged_description_28,
      v0_.date_certificate_number_plate AS date_certificate_number_plate_29,
      v0_.description AS description_30,
      v0_.dual_key AS dual_key_31,
      v0_.engine_size AS engine_size_32,
      v0_.exclusive_sale AS exclusive_sale_33,
      v0_.financing_default_price AS financing_default_price_34,
      v0_.finish_leocare AS finish_leocare_35,
      v0_.formula_number_number_plate AS formula_number_number_plate_36,
      v0_.good_deal AS good_deal_37,
      v0_.horse_power AS horse_power_38,
      v0_.id_leocare AS id_leocare_39,
      v0_.interior AS interior_40,
      v0_.is_first_hand AS is_first_hand_41,
      v0_.is_leasing AS is_leasing_42,
      v0_.is_vat_recoverable AS is_vat_recoverable_43,
      v0_.is_yescar_repossession AS is_yescar_repossession_44,
      v0_.kw_power AS kw_power_45,
      v0_.last_revision_date AS last_revision_date_46,
      v0_.last_revision_description AS last_revision_description_47,
      v0_.last_revision_mileage AS last_revision_mileage_48,
      v0_.mileage_timing_belt AS mileage_timing_belt_49,
      v0_.min_price AS min_price_50,
      v0_.multicasted_elsewhere AS multicasted_elsewhere_51,
      v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_52,
      v0_.number_plate AS number_plate_53,
      v0_.original_price AS original_price_54,
      v0_.prestige AS prestige_55,
      v0_.price AS price_56,
      v0_.private_comment AS private_comment_57,
      v0_.reception_by_type AS reception_by_type_58,
      v0_.registration_number AS registration_number_59,
      v0_.seller_price AS seller_price_60,
      v0_.service_manual AS service_manual_61,
      v0_.size_rim AS size_rim_62,
      v0_.slug AS slug_63,
      v0_.technical_check_date AS technical_check_date_64,
      v0_.technical_check_description AS technical_check_description_65,
      v0_.timing_belt_description AS timing_belt_description_66,
      v0_.tire_back_left_description AS tire_back_left_description_67,
      v0_.tire_back_right_description AS tire_back_right_description_68,
      v0_.tire_front_left_description AS tire_front_left_description_69,
      v0_.tire_front_right_description AS tire_front_right_description_70,
      v0_.type_variant_version AS type_variant_version_71,
      v0_.under_sale_agreement AS under_sale_agreement_72,
      v0_.updated AS updated_73,
      v0_.use_as_security AS use_as_security_74,
      v0_.user_manual AS user_manual_75,
      v0_.warranty_duration AS warranty_duration_76,
      v0_.warranty_price AS warranty_price_77,
      v0_.workflow AS workflow_78,
      v0_.zip_archive AS zip_archive_79,
      v0_.has_lead_eloa AS has_lead_eloa_80,
      v0_.vehicle_migrated AS vehicle_migrated_81,
      v0_.eloa_updated_at AS eloa_updated_at_82,
      v0_.autoscout_id AS autoscout_id_83,
      v0_.created_at AS created_at_84,
      v0_.updated_at AS updated_at_85
    FROM
      vehicle v0_
      INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id
      INNER JOIN fuel f2_ ON v0_.fuel_id = f2_.id
    WHERE
      v0_.active IN (?)
  ) dctrn_result
LIMIT
  4

SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.finish AS finish_1, v0_.mileage AS mileage_2, v0_.in_service_date AS in_service_date_3, v0_.power AS power_4, v0_.power_din AS power_din_5, v0_.nb_door AS nb_door_6, v0_.nb_seat AS nb_seat_7, v0_.co2 AS co2_8, v0_.eloa_ref AS eloa_ref_9, v0_.eloa_statut AS eloa_statut_10, v0_.eloa_date_migration AS eloa_date_migration_11, v0_.lbc_date_publish AS lbc_date_publish_12, v0_.lbc_date_unpublish AS lbc_date_unpublish_13, v0_.lbc_date_update AS lbc_date_update_14, v0_.autoscout_date_publish AS autoscout_date_publish_15, v0_.autoscout_date_unpublish AS autoscout_date_unpublish_16, v0_.autoscout_date_update AS autoscout_date_update_17, v0_.active AS active_18, v0_.archive AS archive_19, v0_.archive_custom_reason AS archive_custom_reason_20, v0_.archived_at AS archived_at_21, v0_.brand_warranty_end_date AS brand_warranty_end_date_22, v0_.cantonal_annotation AS cantonal_annotation_23, v0_.chassis_number AS chassis_number_24, v0_.commission AS commission_25, v0_.created AS created_26, v0_.damaged AS damaged_27, v0_.damaged_description AS damaged_description_28, v0_.date_certificate_number_plate AS date_certificate_number_plate_29, v0_.description AS description_30, v0_.dual_key AS dual_key_31, v0_.engine_size AS engine_size_32, v0_.exclusive_sale AS exclusive_sale_33, v0_.financing_default_price AS financing_default_price_34, v0_.finish_leocare AS finish_leocare_35, v0_.formula_number_number_plate AS formula_number_number_plate_36, v0_.good_deal AS good_deal_37, v0_.horse_power AS horse_power_38, v0_.id_leocare AS id_leocare_39, v0_.interior AS interior_40, v0_.is_first_hand AS is_first_hand_41, v0_.is_leasing AS is_leasing_42, v0_.is_vat_recoverable AS is_vat_recoverable_43, v0_.is_yescar_repossession AS is_yescar_repossession_44, v0_.kw_power AS kw_power_45, v0_.last_revision_date AS last_revision_date_46, v0_.last_revision_description AS last_revision_description_47, v0_.last_revision_mileage AS last_revision_mileage_48, v0_.mileage_timing_belt AS mileage_timing_belt_49, v0_.min_price AS min_price_50, v0_.multicasted_elsewhere AS multicasted_elsewhere_51, v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_52, v0_.number_plate AS number_plate_53, v0_.original_price AS original_price_54, v0_.prestige AS prestige_55, v0_.price AS price_56, v0_.private_comment AS private_comment_57, v0_.reception_by_type AS reception_by_type_58, v0_.registration_number AS registration_number_59, v0_.seller_price AS seller_price_60, v0_.service_manual AS service_manual_61, v0_.size_rim AS size_rim_62, v0_.slug AS slug_63, v0_.technical_check_date AS technical_check_date_64, v0_.technical_check_description AS technical_check_description_65, v0_.timing_belt_description AS timing_belt_description_66, v0_.tire_back_left_description AS tire_back_left_description_67, v0_.tire_back_right_description AS tire_back_right_description_68, v0_.tire_front_left_description AS tire_front_left_description_69, v0_.tire_front_right_description AS tire_front_right_description_70, v0_.type_variant_version AS type_variant_version_71, v0_.under_sale_agreement AS under_sale_agreement_72, v0_.updated AS updated_73, v0_.use_as_security AS use_as_security_74, v0_.user_manual AS user_manual_75, v0_.warranty_duration AS warranty_duration_76, v0_.warranty_price AS warranty_price_77, v0_.workflow AS workflow_78, v0_.zip_archive AS zip_archive_79, v0_.has_lead_eloa AS has_lead_eloa_80, v0_.vehicle_migrated AS vehicle_migrated_81, v0_.eloa_updated_at AS eloa_updated_at_82, v0_.autoscout_id AS autoscout_id_83, v0_.created_at AS created_at_84, v0_.updated_at AS updated_at_85 FROM vehicle v0_ INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id INNER JOIN fuel f2_ ON v0_.fuel_id = f2_.id WHERE v0_.active IN (1)) dctrn_result LIMIT 4;

SELECT
  v0_.id AS id_0,
  v0_.finish AS finish_1,
  v0_.mileage AS mileage_2,
  v0_.in_service_date AS in_service_date_3,
  v0_.power AS power_4,
  v0_.power_din AS power_din_5,
  v0_.nb_door AS nb_door_6,
  v0_.nb_seat AS nb_seat_7,
  v0_.co2 AS co2_8,
  v0_.eloa_ref AS eloa_ref_9,
  v0_.eloa_statut AS eloa_statut_10,
  v0_.eloa_date_migration AS eloa_date_migration_11,
  v0_.lbc_date_publish AS lbc_date_publish_12,
  v0_.lbc_date_unpublish AS lbc_date_unpublish_13,
  v0_.lbc_date_update AS lbc_date_update_14,
  v0_.autoscout_date_publish AS autoscout_date_publish_15,
  v0_.autoscout_date_unpublish AS autoscout_date_unpublish_16,
  v0_.autoscout_date_update AS autoscout_date_update_17,
  v0_.active AS active_18,
  v0_.archive AS archive_19,
  v0_.archive_custom_reason AS archive_custom_reason_20,
  v0_.archived_at AS archived_at_21,
  v0_.brand_warranty_end_date AS brand_warranty_end_date_22,
  v0_.cantonal_annotation AS cantonal_annotation_23,
  v0_.chassis_number AS chassis_number_24,
  v0_.commission AS commission_25,
  v0_.created AS created_26,
  v0_.damaged AS damaged_27,
  v0_.damaged_description AS damaged_description_28,
  v0_.date_certificate_number_plate AS date_certificate_number_plate_29,
  v0_.description AS description_30,
  v0_.dual_key AS dual_key_31,
  v0_.engine_size AS engine_size_32,
  v0_.exclusive_sale AS exclusive_sale_33,
  v0_.financing_default_price AS financing_default_price_34,
  v0_.finish_leocare AS finish_leocare_35,
  v0_.formula_number_number_plate AS formula_number_number_plate_36,
  v0_.good_deal AS good_deal_37,
  v0_.horse_power AS horse_power_38,
  v0_.id_leocare AS id_leocare_39,
  v0_.interior AS interior_40,
  v0_.is_first_hand AS is_first_hand_41,
  v0_.is_leasing AS is_leasing_42,
  v0_.is_vat_recoverable AS is_vat_recoverable_43,
  v0_.is_yescar_repossession AS is_yescar_repossession_44,
  v0_.kw_power AS kw_power_45,
  v0_.last_revision_date AS last_revision_date_46,
  v0_.last_revision_description AS last_revision_description_47,
  v0_.last_revision_mileage AS last_revision_mileage_48,
  v0_.mileage_timing_belt AS mileage_timing_belt_49,
  v0_.min_price AS min_price_50,
  v0_.multicasted_elsewhere AS multicasted_elsewhere_51,
  v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_52,
  v0_.number_plate AS number_plate_53,
  v0_.original_price AS original_price_54,
  v0_.prestige AS prestige_55,
  v0_.price AS price_56,
  v0_.private_comment AS private_comment_57,
  v0_.reception_by_type AS reception_by_type_58,
  v0_.registration_number AS registration_number_59,
  v0_.seller_price AS seller_price_60,
  v0_.service_manual AS service_manual_61,
  v0_.size_rim AS size_rim_62,
  v0_.slug AS slug_63,
  v0_.technical_check_date AS technical_check_date_64,
  v0_.technical_check_description AS technical_check_description_65,
  v0_.timing_belt_description AS timing_belt_description_66,
  v0_.tire_back_left_description AS tire_back_left_description_67,
  v0_.tire_back_right_description AS tire_back_right_description_68,
  v0_.tire_front_left_description AS tire_front_left_description_69,
  v0_.tire_front_right_description AS tire_front_right_description_70,
  v0_.type_variant_version AS type_variant_version_71,
  v0_.under_sale_agreement AS under_sale_agreement_72,
  v0_.updated AS updated_73,
  v0_.use_as_security AS use_as_security_74,
  v0_.user_manual AS user_manual_75,
  v0_.warranty_duration AS warranty_duration_76,
  v0_.warranty_price AS warranty_price_77,
  v0_.workflow AS workflow_78,
  v0_.zip_archive AS zip_archive_79,
  v0_.has_lead_eloa AS has_lead_eloa_80,
  v0_.vehicle_migrated AS vehicle_migrated_81,
  v0_.eloa_updated_at AS eloa_updated_at_82,
  v0_.autoscout_id AS autoscout_id_83,
  v0_.created_at AS created_at_84,
  v0_.updated_at AS updated_at_85,
  v0_.agency_id AS agency_id_86,
  v0_.transmission_id AS transmission_id_87,
  v0_.vehicle_type_id AS vehicle_type_id_88,
  v0_.critair_id AS critair_id_89,
  v0_.fuel_id AS fuel_id_90,
  v0_.model_id AS model_id_91,
  v0_.document_id AS document_id_92,
  v0_.user_id AS user_id_93,
  v0_.ambassador_id AS ambassador_id_94,
  v0_.archive_type_id AS archive_type_id_95,
  v0_.bodywork_id AS bodywork_id_96,
  v0_.buyer_id AS buyer_id_97,
  v0_.color_id AS color_id_98,
  v0_.euro_norm_id AS euro_norm_id_99,
  v0_.origin_id AS origin_id_100,
  v0_.workmate_registered_id AS workmate_registered_id_101,
  v0_.workmate_sold_id AS workmate_sold_id_102,
  v0_.vehicle_eloa_id AS vehicle_eloa_id_103
FROM
  vehicle v0_
  INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id
  INNER JOIN fuel f2_ ON v0_.fuel_id = f2_.id
WHERE
  v0_.active IN (?)
  AND v0_.id IN (?, ?, ?, ?)

SELECT v0_.id AS id_0, v0_.finish AS finish_1, v0_.mileage AS mileage_2, v0_.in_service_date AS in_service_date_3, v0_.power AS power_4, v0_.power_din AS power_din_5, v0_.nb_door AS nb_door_6, v0_.nb_seat AS nb_seat_7, v0_.co2 AS co2_8, v0_.eloa_ref AS eloa_ref_9, v0_.eloa_statut AS eloa_statut_10, v0_.eloa_date_migration AS eloa_date_migration_11, v0_.lbc_date_publish AS lbc_date_publish_12, v0_.lbc_date_unpublish AS lbc_date_unpublish_13, v0_.lbc_date_update AS lbc_date_update_14, v0_.autoscout_date_publish AS autoscout_date_publish_15, v0_.autoscout_date_unpublish AS autoscout_date_unpublish_16, v0_.autoscout_date_update AS autoscout_date_update_17, v0_.active AS active_18, v0_.archive AS archive_19, v0_.archive_custom_reason AS archive_custom_reason_20, v0_.archived_at AS archived_at_21, v0_.brand_warranty_end_date AS brand_warranty_end_date_22, v0_.cantonal_annotation AS cantonal_annotation_23, v0_.chassis_number AS chassis_number_24, v0_.commission AS commission_25, v0_.created AS created_26, v0_.damaged AS damaged_27, v0_.damaged_description AS damaged_description_28, v0_.date_certificate_number_plate AS date_certificate_number_plate_29, v0_.description AS description_30, v0_.dual_key AS dual_key_31, v0_.engine_size AS engine_size_32, v0_.exclusive_sale AS exclusive_sale_33, v0_.financing_default_price AS financing_default_price_34, v0_.finish_leocare AS finish_leocare_35, v0_.formula_number_number_plate AS formula_number_number_plate_36, v0_.good_deal AS good_deal_37, v0_.horse_power AS horse_power_38, v0_.id_leocare AS id_leocare_39, v0_.interior AS interior_40, v0_.is_first_hand AS is_first_hand_41, v0_.is_leasing AS is_leasing_42, v0_.is_vat_recoverable AS is_vat_recoverable_43, v0_.is_yescar_repossession AS is_yescar_repossession_44, v0_.kw_power AS kw_power_45, v0_.last_revision_date AS last_revision_date_46, v0_.last_revision_description AS last_revision_description_47, v0_.last_revision_mileage AS last_revision_mileage_48, v0_.mileage_timing_belt AS mileage_timing_belt_49, v0_.min_price AS min_price_50, v0_.multicasted_elsewhere AS multicasted_elsewhere_51, v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_52, v0_.number_plate AS number_plate_53, v0_.original_price AS original_price_54, v0_.prestige AS prestige_55, v0_.price AS price_56, v0_.private_comment AS private_comment_57, v0_.reception_by_type AS reception_by_type_58, v0_.registration_number AS registration_number_59, v0_.seller_price AS seller_price_60, v0_.service_manual AS service_manual_61, v0_.size_rim AS size_rim_62, v0_.slug AS slug_63, v0_.technical_check_date AS technical_check_date_64, v0_.technical_check_description AS technical_check_description_65, v0_.timing_belt_description AS timing_belt_description_66, v0_.tire_back_left_description AS tire_back_left_description_67, v0_.tire_back_right_description AS tire_back_right_description_68, v0_.tire_front_left_description AS tire_front_left_description_69, v0_.tire_front_right_description AS tire_front_right_description_70, v0_.type_variant_version AS type_variant_version_71, v0_.under_sale_agreement AS under_sale_agreement_72, v0_.updated AS updated_73, v0_.use_as_security AS use_as_security_74, v0_.user_manual AS user_manual_75, v0_.warranty_duration AS warranty_duration_76, v0_.warranty_price AS warranty_price_77, v0_.workflow AS workflow_78, v0_.zip_archive AS zip_archive_79, v0_.has_lead_eloa AS has_lead_eloa_80, v0_.vehicle_migrated AS vehicle_migrated_81, v0_.eloa_updated_at AS eloa_updated_at_82, v0_.autoscout_id AS autoscout_id_83, v0_.created_at AS created_at_84, v0_.updated_at AS updated_at_85, v0_.agency_id AS agency_id_86, v0_.transmission_id AS transmission_id_87, v0_.vehicle_type_id AS vehicle_type_id_88, v0_.critair_id AS critair_id_89, v0_.fuel_id AS fuel_id_90, v0_.model_id AS model_id_91, v0_.document_id AS document_id_92, v0_.user_id AS user_id_93, v0_.ambassador_id AS ambassador_id_94, v0_.archive_type_id AS archive_type_id_95, v0_.bodywork_id AS bodywork_id_96, v0_.buyer_id AS buyer_id_97, v0_.color_id AS color_id_98, v0_.euro_norm_id AS euro_norm_id_99, v0_.origin_id AS origin_id_100, v0_.workmate_registered_id AS workmate_registered_id_101, v0_.workmate_sold_id AS workmate_sold_id_102, v0_.vehicle_eloa_id AS vehicle_eloa_id_103 FROM vehicle v0_ INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id INNER JOIN fuel f2_ ON v0_.fuel_id = f2_.id WHERE v0_.active IN (1) AND v0_.id IN (155673, 170829, 179987, 181199);

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.lbc_user_id AS lbc_user_id_5,
  t0.lbc_user_id_motorbikes AS lbc_user_id_motorbikes_6,
  t0.telephone AS telephone_7,
  t0.siret AS siret_8,
  t0.is_active AS is_active_9,
  t0.eloa_ref AS eloa_ref_10,
  t0.eloa_last_check AS eloa_last_check_11,
  t0.eloa_statut AS eloa_statut_12,
  t0.libelle AS libelle_13,
  t0.reference_entite AS reference_entite_14,
  t0.raison_sociale AS raison_sociale_15,
  t0.ref_type_reseau AS ref_type_reseau_16,
  t0.orias AS orias_17,
  t0.description AS description_18,
  t0.eloa_description AS eloa_description_19,
  t0.has_grey_card_service AS has_grey_card_service_20,
  t0.slug AS slug_21,
  t0.has_loyalty_program AS has_loyalty_program_22,
  t0.has_up_my_shop AS has_up_my_shop_23,
  t0.latitude AS latitude_24,
  t0.longitude AS longitude_25,
  t0.royalty_network_date AS royalty_network_date_26,
  t0.royalty_remainder AS royalty_remainder_27,
  t0.fiscal_code_it AS fiscal_code_it_28,
  t0.leocare_id AS leocare_id_29,
  t0.autoscout24_api_id AS autoscout24_api_id_30,
  t0.up_my_shop_url AS up_my_shop_url_31,
  t0.lacentrale_id AS lacentrale_id_32,
  t0.has_annoncesautomobile AS has_annoncesautomobile_33,
  t0.definitively_inactive AS definitively_inactive_34,
  t0.first_contract_date AS first_contract_date_35,
  t0.opening_date AS opening_date_36,
  t0.vosfactures_id AS vosfactures_id_37,
  t0.vosfactures_client_id AS vosfactures_client_id_38,
  t0.grey_card_website AS grey_card_website_39,
  t0.has_cps AS has_cps_40,
  t0.contract_date AS contract_date_41,
  t0.autoscout24_id AS autoscout24_id_42,
  t0.paruvendu_id AS paruvendu_id_43,
  t0.ouestfrance_id AS ouestfrance_id_44,
  t0.atoutcoin_id AS atoutcoin_id_45,
  t0.royalty_variable_date AS royalty_variable_date_46,
  t0.royalty_communication_date AS royalty_communication_date_47,
  t0.agency_migrated AS agency_migrated_48,
  t0.facturation_id AS facturation_id_49,
  t0.invoice_number AS invoice_number_50,
  t0.picture AS picture_51,
  t0.address_number AS address_number_52,
  t0.address_extension AS address_extension_53,
  t0.address_street AS address_street_54,
  t0.address AS address_55,
  t0.created_at AS created_at_56,
  t0.updated_at AS updated_at_57,
  t0.city_id AS city_id_58,
  t0.company_id AS company_id_59,
  t0.royalty_network_id AS royalty_network_id_60,
  t0.royalty_communication_id AS royalty_communication_id_61,
  t0.royalty_variable_id AS royalty_variable_id_62,
  t0.close_reason_id AS close_reason_id_63
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.lbc_user_id AS lbc_user_id_5, t0.lbc_user_id_motorbikes AS lbc_user_id_motorbikes_6, t0.telephone AS telephone_7, t0.siret AS siret_8, t0.is_active AS is_active_9, t0.eloa_ref AS eloa_ref_10, t0.eloa_last_check AS eloa_last_check_11, t0.eloa_statut AS eloa_statut_12, t0.libelle AS libelle_13, t0.reference_entite AS reference_entite_14, t0.raison_sociale AS raison_sociale_15, t0.ref_type_reseau AS ref_type_reseau_16, t0.orias AS orias_17, t0.description AS description_18, t0.eloa_description AS eloa_description_19, t0.has_grey_card_service AS has_grey_card_service_20, t0.slug AS slug_21, t0.has_loyalty_program AS has_loyalty_program_22, t0.has_up_my_shop AS has_up_my_shop_23, t0.latitude AS latitude_24, t0.longitude AS longitude_25, t0.royalty_network_date AS royalty_network_date_26, t0.royalty_remainder AS royalty_remainder_27, t0.fiscal_code_it AS fiscal_code_it_28, t0.leocare_id AS leocare_id_29, t0.autoscout24_api_id AS autoscout24_api_id_30, t0.up_my_shop_url AS up_my_shop_url_31, t0.lacentrale_id AS lacentrale_id_32, t0.has_annoncesautomobile AS has_annoncesautomobile_33, t0.definitively_inactive AS definitively_inactive_34, t0.first_contract_date AS first_contract_date_35, t0.opening_date AS opening_date_36, t0.vosfactures_id AS vosfactures_id_37, t0.vosfactures_client_id AS vosfactures_client_id_38, t0.grey_card_website AS grey_card_website_39, t0.has_cps AS has_cps_40, t0.contract_date AS contract_date_41, t0.autoscout24_id AS autoscout24_id_42, t0.paruvendu_id AS paruvendu_id_43, t0.ouestfrance_id AS ouestfrance_id_44, t0.atoutcoin_id AS atoutcoin_id_45, t0.royalty_variable_date AS royalty_variable_date_46, t0.royalty_communication_date AS royalty_communication_date_47, t0.agency_migrated AS agency_migrated_48, t0.facturation_id AS facturation_id_49, t0.invoice_number AS invoice_number_50, t0.picture AS picture_51, t0.address_number AS address_number_52, t0.address_extension AS address_extension_53, t0.address_street AS address_street_54, t0.address AS address_55, t0.created_at AS created_at_56, t0.updated_at AS updated_at_57, t0.city_id AS city_id_58, t0.company_id AS company_id_59, t0.royalty_network_id AS royalty_network_id_60, t0.royalty_communication_id AS royalty_communication_id_61, t0.royalty_variable_id AS royalty_variable_id_62, t0.close_reason_id AS close_reason_id_63 FROM agency t0 WHERE t0.id = 104;

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

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 = 155673;