Symfony Profiler

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
  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_.active AS active_12,
          v0_.archive AS archive_13,
          v0_.archive_custom_reason AS archive_custom_reason_14,
          v0_.archived_at AS archived_at_15,
          v0_.brand_warranty_end_date AS brand_warranty_end_date_16,
          v0_.cantonal_annotation AS cantonal_annotation_17,
          v0_.chassis_number AS chassis_number_18,
          v0_.commission AS commission_19,
          v0_.created AS created_20,
          v0_.damaged AS damaged_21,
          v0_.damaged_description AS damaged_description_22,
          v0_.date_certificate_number_plate AS date_certificate_number_plate_23,
          v0_.description AS description_24,
          v0_.dual_key AS dual_key_25,
          v0_.engine_size AS engine_size_26,
          v0_.exclusive_sale AS exclusive_sale_27,
          v0_.financing_default_price AS financing_default_price_28,
          v0_.finish_leocare AS finish_leocare_29,
          v0_.formula_number_number_plate AS formula_number_number_plate_30,
          v0_.good_deal AS good_deal_31,
          v0_.horse_power AS horse_power_32,
          v0_.id_leocare AS id_leocare_33,
          v0_.interior AS interior_34,
          v0_.is_first_hand AS is_first_hand_35,
          v0_.is_leasing AS is_leasing_36,
          v0_.is_vat_recoverable AS is_vat_recoverable_37,
          v0_.is_yescar_repossession AS is_yescar_repossession_38,
          v0_.kw_power AS kw_power_39,
          v0_.last_revision_date AS last_revision_date_40,
          v0_.last_revision_description AS last_revision_description_41,
          v0_.last_revision_mileage AS last_revision_mileage_42,
          v0_.mileage_timing_belt AS mileage_timing_belt_43,
          v0_.min_price AS min_price_44,
          v0_.multicasted_elsewhere AS multicasted_elsewhere_45,
          v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_46,
          v0_.number_plate AS number_plate_47,
          v0_.original_price AS original_price_48,
          v0_.prestige AS prestige_49,
          v0_.price AS price_50,
          v0_.private_comment AS private_comment_51,
          v0_.reception_by_type AS reception_by_type_52,
          v0_.registration_number AS registration_number_53,
          v0_.seller_price AS seller_price_54,
          v0_.service_manual AS service_manual_55,
          v0_.size_rim AS size_rim_56,
          v0_.slug AS slug_57,
          v0_.technical_check_date AS technical_check_date_58,
          v0_.technical_check_description AS technical_check_description_59,
          v0_.timing_belt_description AS timing_belt_description_60,
          v0_.tire_back_left_description AS tire_back_left_description_61,
          v0_.tire_back_right_description AS tire_back_right_description_62,
          v0_.tire_front_left_description AS tire_front_left_description_63,
          v0_.tire_front_right_description AS tire_front_right_description_64,
          v0_.type_variant_version AS type_variant_version_65,
          v0_.under_sale_agreement AS under_sale_agreement_66,
          v0_.updated AS updated_67,
          v0_.use_as_security AS use_as_security_68,
          v0_.user_manual AS user_manual_69,
          v0_.warranty_duration AS warranty_duration_70,
          v0_.warranty_price AS warranty_price_71,
          v0_.workflow AS workflow_72,
          v0_.zip_archive AS zip_archive_73,
          v0_.has_lead_eloa AS has_lead_eloa_74,
          v0_.vehicle_migrated AS vehicle_migrated_75,
          v0_.eloa_updated_at AS eloa_updated_at_76,
          v0_.created_at AS created_at_77,
          v0_.updated_at AS updated_at_78
        FROM
          vehicle v0_
          INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id
          INNER JOIN model m2_ ON v0_.model_id = m2_.id
          INNER JOIN fuel f3_ ON v0_.fuel_id = f3_.id
        WHERE
          v0_.active IN (?)
          AND m2_.id IN (?)
        ORDER BY
          RAND() ASC
      ) 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_.active AS active_12, v0_.archive AS archive_13, v0_.archive_custom_reason AS archive_custom_reason_14, v0_.archived_at AS archived_at_15, v0_.brand_warranty_end_date AS brand_warranty_end_date_16, v0_.cantonal_annotation AS cantonal_annotation_17, v0_.chassis_number AS chassis_number_18, v0_.commission AS commission_19, v0_.created AS created_20, v0_.damaged AS damaged_21, v0_.damaged_description AS damaged_description_22, v0_.date_certificate_number_plate AS date_certificate_number_plate_23, v0_.description AS description_24, v0_.dual_key AS dual_key_25, v0_.engine_size AS engine_size_26, v0_.exclusive_sale AS exclusive_sale_27, v0_.financing_default_price AS financing_default_price_28, v0_.finish_leocare AS finish_leocare_29, v0_.formula_number_number_plate AS formula_number_number_plate_30, v0_.good_deal AS good_deal_31, v0_.horse_power AS horse_power_32, v0_.id_leocare AS id_leocare_33, v0_.interior AS interior_34, v0_.is_first_hand AS is_first_hand_35, v0_.is_leasing AS is_leasing_36, v0_.is_vat_recoverable AS is_vat_recoverable_37, v0_.is_yescar_repossession AS is_yescar_repossession_38, v0_.kw_power AS kw_power_39, v0_.last_revision_date AS last_revision_date_40, v0_.last_revision_description AS last_revision_description_41, v0_.last_revision_mileage AS last_revision_mileage_42, v0_.mileage_timing_belt AS mileage_timing_belt_43, v0_.min_price AS min_price_44, v0_.multicasted_elsewhere AS multicasted_elsewhere_45, v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_46, v0_.number_plate AS number_plate_47, v0_.original_price AS original_price_48, v0_.prestige AS prestige_49, v0_.price AS price_50, v0_.private_comment AS private_comment_51, v0_.reception_by_type AS reception_by_type_52, v0_.registration_number AS registration_number_53, v0_.seller_price AS seller_price_54, v0_.service_manual AS service_manual_55, v0_.size_rim AS size_rim_56, v0_.slug AS slug_57, v0_.technical_check_date AS technical_check_date_58, v0_.technical_check_description AS technical_check_description_59, v0_.timing_belt_description AS timing_belt_description_60, v0_.tire_back_left_description AS tire_back_left_description_61, v0_.tire_back_right_description AS tire_back_right_description_62, v0_.tire_front_left_description AS tire_front_left_description_63, v0_.tire_front_right_description AS tire_front_right_description_64, v0_.type_variant_version AS type_variant_version_65, v0_.under_sale_agreement AS under_sale_agreement_66, v0_.updated AS updated_67, v0_.use_as_security AS use_as_security_68, v0_.user_manual AS user_manual_69, v0_.warranty_duration AS warranty_duration_70, v0_.warranty_price AS warranty_price_71, v0_.workflow AS workflow_72, v0_.zip_archive AS zip_archive_73, v0_.has_lead_eloa AS has_lead_eloa_74, v0_.vehicle_migrated AS vehicle_migrated_75, v0_.eloa_updated_at AS eloa_updated_at_76, v0_.created_at AS created_at_77, v0_.updated_at AS updated_at_78 FROM vehicle v0_ INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id INNER JOIN model m2_ ON v0_.model_id = m2_.id INNER JOIN fuel f3_ ON v0_.fuel_id = f3_.id WHERE v0_.active IN (1) AND m2_.id IN ('548') ORDER BY RAND() ASC) dctrn_result) dctrn_table;

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_.active AS active_12,
  v0_.archive AS archive_13,
  v0_.archive_custom_reason AS archive_custom_reason_14,
  v0_.archived_at AS archived_at_15,
  v0_.brand_warranty_end_date AS brand_warranty_end_date_16,
  v0_.cantonal_annotation AS cantonal_annotation_17,
  v0_.chassis_number AS chassis_number_18,
  v0_.commission AS commission_19,
  v0_.created AS created_20,
  v0_.damaged AS damaged_21,
  v0_.damaged_description AS damaged_description_22,
  v0_.date_certificate_number_plate AS date_certificate_number_plate_23,
  v0_.description AS description_24,
  v0_.dual_key AS dual_key_25,
  v0_.engine_size AS engine_size_26,
  v0_.exclusive_sale AS exclusive_sale_27,
  v0_.financing_default_price AS financing_default_price_28,
  v0_.finish_leocare AS finish_leocare_29,
  v0_.formula_number_number_plate AS formula_number_number_plate_30,
  v0_.good_deal AS good_deal_31,
  v0_.horse_power AS horse_power_32,
  v0_.id_leocare AS id_leocare_33,
  v0_.interior AS interior_34,
  v0_.is_first_hand AS is_first_hand_35,
  v0_.is_leasing AS is_leasing_36,
  v0_.is_vat_recoverable AS is_vat_recoverable_37,
  v0_.is_yescar_repossession AS is_yescar_repossession_38,
  v0_.kw_power AS kw_power_39,
  v0_.last_revision_date AS last_revision_date_40,
  v0_.last_revision_description AS last_revision_description_41,
  v0_.last_revision_mileage AS last_revision_mileage_42,
  v0_.mileage_timing_belt AS mileage_timing_belt_43,
  v0_.min_price AS min_price_44,
  v0_.multicasted_elsewhere AS multicasted_elsewhere_45,
  v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_46,
  v0_.number_plate AS number_plate_47,
  v0_.original_price AS original_price_48,
  v0_.prestige AS prestige_49,
  v0_.price AS price_50,
  v0_.private_comment AS private_comment_51,
  v0_.reception_by_type AS reception_by_type_52,
  v0_.registration_number AS registration_number_53,
  v0_.seller_price AS seller_price_54,
  v0_.service_manual AS service_manual_55,
  v0_.size_rim AS size_rim_56,
  v0_.slug AS slug_57,
  v0_.technical_check_date AS technical_check_date_58,
  v0_.technical_check_description AS technical_check_description_59,
  v0_.timing_belt_description AS timing_belt_description_60,
  v0_.tire_back_left_description AS tire_back_left_description_61,
  v0_.tire_back_right_description AS tire_back_right_description_62,
  v0_.tire_front_left_description AS tire_front_left_description_63,
  v0_.tire_front_right_description AS tire_front_right_description_64,
  v0_.type_variant_version AS type_variant_version_65,
  v0_.under_sale_agreement AS under_sale_agreement_66,
  v0_.updated AS updated_67,
  v0_.use_as_security AS use_as_security_68,
  v0_.user_manual AS user_manual_69,
  v0_.warranty_duration AS warranty_duration_70,
  v0_.warranty_price AS warranty_price_71,
  v0_.workflow AS workflow_72,
  v0_.zip_archive AS zip_archive_73,
  v0_.has_lead_eloa AS has_lead_eloa_74,
  v0_.vehicle_migrated AS vehicle_migrated_75,
  v0_.eloa_updated_at AS eloa_updated_at_76,
  v0_.created_at AS created_at_77,
  v0_.updated_at AS updated_at_78,
  v0_.agency_id AS agency_id_79,
  v0_.transmission_id AS transmission_id_80,
  v0_.vehicle_type_id AS vehicle_type_id_81,
  v0_.critair_id AS critair_id_82,
  v0_.fuel_id AS fuel_id_83,
  v0_.model_id AS model_id_84,
  v0_.document_id AS document_id_85,
  v0_.user_id AS user_id_86,
  v0_.ambassador_id AS ambassador_id_87,
  v0_.archive_type_id AS archive_type_id_88,
  v0_.bodywork_id AS bodywork_id_89,
  v0_.buyer_id AS buyer_id_90,
  v0_.color_id AS color_id_91,
  v0_.euro_norm_id AS euro_norm_id_92,
  v0_.origin_id AS origin_id_93,
  v0_.workmate_registered_id AS workmate_registered_id_94,
  v0_.workmate_sold_id AS workmate_sold_id_95,
  v0_.vehicle_eloa_id AS vehicle_eloa_id_96
FROM
  vehicle v0_
  INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id
  INNER JOIN model m2_ ON v0_.model_id = m2_.id
  INNER JOIN fuel f3_ ON v0_.fuel_id = f3_.id
WHERE
  v0_.active IN (?)
  AND m2_.id IN (?)
  AND v0_.id IN (?, ?, ?)
ORDER BY
  RAND() ASC

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_.active AS active_12, v0_.archive AS archive_13, v0_.archive_custom_reason AS archive_custom_reason_14, v0_.archived_at AS archived_at_15, v0_.brand_warranty_end_date AS brand_warranty_end_date_16, v0_.cantonal_annotation AS cantonal_annotation_17, v0_.chassis_number AS chassis_number_18, v0_.commission AS commission_19, v0_.created AS created_20, v0_.damaged AS damaged_21, v0_.damaged_description AS damaged_description_22, v0_.date_certificate_number_plate AS date_certificate_number_plate_23, v0_.description AS description_24, v0_.dual_key AS dual_key_25, v0_.engine_size AS engine_size_26, v0_.exclusive_sale AS exclusive_sale_27, v0_.financing_default_price AS financing_default_price_28, v0_.finish_leocare AS finish_leocare_29, v0_.formula_number_number_plate AS formula_number_number_plate_30, v0_.good_deal AS good_deal_31, v0_.horse_power AS horse_power_32, v0_.id_leocare AS id_leocare_33, v0_.interior AS interior_34, v0_.is_first_hand AS is_first_hand_35, v0_.is_leasing AS is_leasing_36, v0_.is_vat_recoverable AS is_vat_recoverable_37, v0_.is_yescar_repossession AS is_yescar_repossession_38, v0_.kw_power AS kw_power_39, v0_.last_revision_date AS last_revision_date_40, v0_.last_revision_description AS last_revision_description_41, v0_.last_revision_mileage AS last_revision_mileage_42, v0_.mileage_timing_belt AS mileage_timing_belt_43, v0_.min_price AS min_price_44, v0_.multicasted_elsewhere AS multicasted_elsewhere_45, v0_.multicasted_elsewhere_description AS multicasted_elsewhere_description_46, v0_.number_plate AS number_plate_47, v0_.original_price AS original_price_48, v0_.prestige AS prestige_49, v0_.price AS price_50, v0_.private_comment AS private_comment_51, v0_.reception_by_type AS reception_by_type_52, v0_.registration_number AS registration_number_53, v0_.seller_price AS seller_price_54, v0_.service_manual AS service_manual_55, v0_.size_rim AS size_rim_56, v0_.slug AS slug_57, v0_.technical_check_date AS technical_check_date_58, v0_.technical_check_description AS technical_check_description_59, v0_.timing_belt_description AS timing_belt_description_60, v0_.tire_back_left_description AS tire_back_left_description_61, v0_.tire_back_right_description AS tire_back_right_description_62, v0_.tire_front_left_description AS tire_front_left_description_63, v0_.tire_front_right_description AS tire_front_right_description_64, v0_.type_variant_version AS type_variant_version_65, v0_.under_sale_agreement AS under_sale_agreement_66, v0_.updated AS updated_67, v0_.use_as_security AS use_as_security_68, v0_.user_manual AS user_manual_69, v0_.warranty_duration AS warranty_duration_70, v0_.warranty_price AS warranty_price_71, v0_.workflow AS workflow_72, v0_.zip_archive AS zip_archive_73, v0_.has_lead_eloa AS has_lead_eloa_74, v0_.vehicle_migrated AS vehicle_migrated_75, v0_.eloa_updated_at AS eloa_updated_at_76, v0_.created_at AS created_at_77, v0_.updated_at AS updated_at_78, v0_.agency_id AS agency_id_79, v0_.transmission_id AS transmission_id_80, v0_.vehicle_type_id AS vehicle_type_id_81, v0_.critair_id AS critair_id_82, v0_.fuel_id AS fuel_id_83, v0_.model_id AS model_id_84, v0_.document_id AS document_id_85, v0_.user_id AS user_id_86, v0_.ambassador_id AS ambassador_id_87, v0_.archive_type_id AS archive_type_id_88, v0_.bodywork_id AS bodywork_id_89, v0_.buyer_id AS buyer_id_90, v0_.color_id AS color_id_91, v0_.euro_norm_id AS euro_norm_id_92, v0_.origin_id AS origin_id_93, v0_.workmate_registered_id AS workmate_registered_id_94, v0_.workmate_sold_id AS workmate_sold_id_95, v0_.vehicle_eloa_id AS vehicle_eloa_id_96 FROM vehicle v0_ INNER JOIN image i1_ ON v0_.id = i1_.vehicle_id INNER JOIN model m2_ ON v0_.model_id = m2_.id INNER JOIN fuel f3_ ON v0_.fuel_id = f3_.id WHERE v0_.active IN (1) AND m2_.id IN ('548') AND v0_.id IN (187371, 173504, 188395) ORDER BY RAND() ASC;

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.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.user_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.user_id = 290710;

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

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.active AS active_5,
  t0.ntfy_id AS ntfy_id_6,
  t0.birthdate AS birthdate_7,
  t0.mobile_phone AS mobile_phone_8,
  t0.enabled AS enabled_9,
  t0.confirmation_token AS confirmation_token_10,
  t0.password_requested_at AS password_requested_at_11,
  t0.is_male AS is_male_12,
  t0.first_name AS first_name_13,
  t0.last_name AS last_name_14,
  t0.birth_name AS birth_name_15,
  t0.address_number AS address_number_16,
  t0.address_extension AS address_extension_17,
  t0.address_street AS address_street_18,
  t0.address AS address_19,
  t0.fixed_phone AS fixed_phone_20,
  t0.comment AS comment_21,
  t0.blacklist_mail AS blacklist_mail_22,
  t0.tax_number AS tax_number_23,
  t0.cps_id AS cps_id_24,
  t0.vosfactures_id AS vosfactures_id_25,
  t0.show_phone_multicaster AS show_phone_multicaster_26,
  t0.calendar_color AS calendar_color_27,
  t0.super_admin_confirmation AS super_admin_confirmation_28,
  t0.fiscal_code_it AS fiscal_code_it_29,
  t0.identity_card_number AS identity_card_number_30,
  t0.identity_card_date AS identity_card_date_31,
  t0.cps_form_token AS cps_form_token_32,
  t0.rsac AS rsac_33,
  t0.loyalty_card_number AS loyalty_card_number_34,
  t0.reset_token AS reset_token_35,
  t0.reset_token_created_at AS reset_token_created_at_36,
  t0.relaunch_date AS relaunch_date_37,
  t0.created_at AS created_at_38,
  t0.updated_at AS updated_at_39,
  t0.reference_utilisateur AS reference_utilisateur_40,
  t0.reference_client AS reference_client_41,
  t0.reference_dosier AS reference_dosier_42,
  t0.id_dossier AS id_dossier_43,
  t0.date_accord_recueil_donnees_gerer_demande AS date_accord_recueil_donnees_gerer_demande_44,
  t0.date_accord_offres_commerciales_completer_demande AS date_accord_offres_commerciales_completer_demande_45,
  t0.date_accord_cession_coordonnees_partenaires_externes AS date_accord_cession_coordonnees_partenaires_externes_46,
  t0.date_sync AS date_sync_47,
  t0.ref_type_civilite AS ref_type_civilite_48,
  t0.ref_type_statut_utilisateur AS ref_type_statut_utilisateur_49,
  t0.image_id AS image_id_50,
  t0.document_id AS document_id_51,
  t0.city_id AS city_id_52,
  t0.birthplace_id AS birthplace_id_53,
  t0.confidential_document_id AS confidential_document_id_54,
  t0.identity_card_id AS identity_card_id_55,
  t0.company_id AS company_id_56,
  t0.entry_point_id AS entry_point_id_57,
  t0.relaunch_id AS relaunch_id_58
FROM
  user t0
  INNER JOIN agency_workmate ON t0.id = agency_workmate.user_id
WHERE
  agency_workmate.agency_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.ntfy_id AS ntfy_id_6, t0.birthdate AS birthdate_7, t0.mobile_phone AS mobile_phone_8, t0.enabled AS enabled_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.is_male AS is_male_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.birth_name AS birth_name_15, t0.address_number AS address_number_16, t0.address_extension AS address_extension_17, t0.address_street AS address_street_18, t0.address AS address_19, t0.fixed_phone AS fixed_phone_20, t0.comment AS comment_21, t0.blacklist_mail AS blacklist_mail_22, t0.tax_number AS tax_number_23, t0.cps_id AS cps_id_24, t0.vosfactures_id AS vosfactures_id_25, t0.show_phone_multicaster AS show_phone_multicaster_26, t0.calendar_color AS calendar_color_27, t0.super_admin_confirmation AS super_admin_confirmation_28, t0.fiscal_code_it AS fiscal_code_it_29, t0.identity_card_number AS identity_card_number_30, t0.identity_card_date AS identity_card_date_31, t0.cps_form_token AS cps_form_token_32, t0.rsac AS rsac_33, t0.loyalty_card_number AS loyalty_card_number_34, t0.reset_token AS reset_token_35, t0.reset_token_created_at AS reset_token_created_at_36, t0.relaunch_date AS relaunch_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.reference_utilisateur AS reference_utilisateur_40, t0.reference_client AS reference_client_41, t0.reference_dosier AS reference_dosier_42, t0.id_dossier AS id_dossier_43, t0.date_accord_recueil_donnees_gerer_demande AS date_accord_recueil_donnees_gerer_demande_44, t0.date_accord_offres_commerciales_completer_demande AS date_accord_offres_commerciales_completer_demande_45, t0.date_accord_cession_coordonnees_partenaires_externes AS date_accord_cession_coordonnees_partenaires_externes_46, t0.date_sync AS date_sync_47, t0.ref_type_civilite AS ref_type_civilite_48, t0.ref_type_statut_utilisateur AS ref_type_statut_utilisateur_49, t0.image_id AS image_id_50, t0.document_id AS document_id_51, t0.city_id AS city_id_52, t0.birthplace_id AS birthplace_id_53, t0.confidential_document_id AS confidential_document_id_54, t0.identity_card_id AS identity_card_id_55, t0.company_id AS company_id_56, t0.entry_point_id AS entry_point_id_57, t0.relaunch_id AS relaunch_id_58 FROM user t0 INNER JOIN agency_workmate ON t0.id = agency_workmate.user_id WHERE agency_workmate.agency_id = 149;