Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.raw_value AS raw_value_4,
  t0.group_name AS group_name_5,
  t0.property_id AS property_id_6,
  t7.id AS id_8,
  t7.created_at AS created_at_9,
  t7.updated_at AS updated_at_10,
  t7.title AS title_11,
  t7.code AS code_12,
  t7.source AS source_13,
  t7.source_code AS source_code_14,
  t7.type AS type_15,
  t0.car_id AS car_id_16,
  t17.id AS id_18,
  t17.mobile_de_id AS mobile_de_id_19,
  t17.slug AS slug_20,
  t17.full_name AS full_name_21,
  t17.price AS price_22,
  t17.power AS power_23,
  t17.mileage AS mileage_24,
  t17.first_registration AS first_registration_25,
  t17.delivery_date AS delivery_date_26,
  t17.cubic_capacity AS cubic_capacity_27,
  t17.num_seats AS num_seats_28,
  t17.previous_owners AS previous_owners_29,
  t17.manufacturer_color_name AS manufacturer_color_name_30,
  t17.fuel_consumption_inner AS fuel_consumption_inner_31,
  t17.fuel_consumption_outer AS fuel_consumption_outer_32,
  t17.fuel_consumption_combined AS fuel_consumption_combined_33,
  t17.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_34,
  t17.co2_emission AS co2_emission_35,
  t17.co2_emission_wltp AS co2_emission_wltp_36,
  t17.emission_class AS emission_class_37,
  t17.energy_efficiency_class AS energy_efficiency_class_38,
  t17.on_home_page AS on_home_page_39,
  t17.creating_method AS creating_method_40,
  t17.full_description AS full_description_41,
  t17.enriched_description AS enriched_description_42,
  t17.financing_example AS financing_example_43,
  t17.update_at AS update_at_44,
  t17.seller_inventory_key AS seller_inventory_key_45,
  t17.price_vatable AS price_vatable_46,
  t17.car_internal_panorama AS car_internal_panorama_47,
  t17.hire_purchase AS hire_purchase_48,
  t17.huau AS huau_49,
  t17.sale_status AS sale_status_50,
  t17.reserved_at AS reserved_at_51,
  t17.order_created_at AS order_created_at_52,
  t17.class_id AS class_id_53,
  t17.cat_id AS cat_id_54,
  t17.maker_id AS maker_id_55,
  t17.model_id AS model_id_56,
  t17.fuel_id AS fuel_id_57,
  t17.gearbox_id AS gearbox_id_58,
  t17.interior_type_id AS interior_type_id_59,
  t17.door_count_id AS door_count_id_60,
  t17.car_condition_id AS car_condition_id_61,
  t17.climatisation_id AS climatisation_id_62,
  t17.exterior_color_id AS exterior_color_id_63,
  t17.filial_id AS filial_id_64,
  t17.api_account_id AS api_account_id_65,
  t0.import_attempt_id AS import_attempt_id_66
FROM
  car_property_value t0
  LEFT JOIN car_property t7 ON t0.property_id = t7.id
  LEFT JOIN ads t17 ON t0.car_id = t17.id
WHERE
  t0.car_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.raw_value AS raw_value_4, t0.group_name AS group_name_5, t0.property_id AS property_id_6, t7.id AS id_8, t7.created_at AS created_at_9, t7.updated_at AS updated_at_10, t7.title AS title_11, t7.code AS code_12, t7.source AS source_13, t7.source_code AS source_code_14, t7.type AS type_15, t0.car_id AS car_id_16, t17.id AS id_18, t17.mobile_de_id AS mobile_de_id_19, t17.slug AS slug_20, t17.full_name AS full_name_21, t17.price AS price_22, t17.power AS power_23, t17.mileage AS mileage_24, t17.first_registration AS first_registration_25, t17.delivery_date AS delivery_date_26, t17.cubic_capacity AS cubic_capacity_27, t17.num_seats AS num_seats_28, t17.previous_owners AS previous_owners_29, t17.manufacturer_color_name AS manufacturer_color_name_30, t17.fuel_consumption_inner AS fuel_consumption_inner_31, t17.fuel_consumption_outer AS fuel_consumption_outer_32, t17.fuel_consumption_combined AS fuel_consumption_combined_33, t17.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_34, t17.co2_emission AS co2_emission_35, t17.co2_emission_wltp AS co2_emission_wltp_36, t17.emission_class AS emission_class_37, t17.energy_efficiency_class AS energy_efficiency_class_38, t17.on_home_page AS on_home_page_39, t17.creating_method AS creating_method_40, t17.full_description AS full_description_41, t17.enriched_description AS enriched_description_42, t17.financing_example AS financing_example_43, t17.update_at AS update_at_44, t17.seller_inventory_key AS seller_inventory_key_45, t17.price_vatable AS price_vatable_46, t17.car_internal_panorama AS car_internal_panorama_47, t17.hire_purchase AS hire_purchase_48, t17.huau AS huau_49, t17.sale_status AS sale_status_50, t17.reserved_at AS reserved_at_51, t17.order_created_at AS order_created_at_52, t17.class_id AS class_id_53, t17.cat_id AS cat_id_54, t17.maker_id AS maker_id_55, t17.model_id AS model_id_56, t17.fuel_id AS fuel_id_57, t17.gearbox_id AS gearbox_id_58, t17.interior_type_id AS interior_type_id_59, t17.door_count_id AS door_count_id_60, t17.car_condition_id AS car_condition_id_61, t17.climatisation_id AS climatisation_id_62, t17.exterior_color_id AS exterior_color_id_63, t17.filial_id AS filial_id_64, t17.api_account_id AS api_account_id_65, t0.import_attempt_id AS import_attempt_id_66 FROM car_property_value t0 LEFT JOIN car_property t7 ON t0.property_id = t7.id LEFT JOIN ads t17 ON t0.car_id = t17.id WHERE t0.car_id = 5127;

SELECT
  DISTINCT r0_.name AS name_0,
  r0_.name_de AS name_de_1
FROM
  ads a1_
  LEFT JOIN ads_ref_vehicle_features a2_ ON a1_.id = a2_.ads_id
  LEFT JOIN ref_vehicle_features r0_ ON r0_.id = a2_.ref_vehicle_features_id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?

SELECT DISTINCT r0_.name AS name_0, r0_.name_de AS name_de_1 FROM ads a1_ LEFT JOIN ads_ref_vehicle_features a2_ ON a1_.id = a2_.ads_id LEFT JOIN ref_vehicle_features r0_ ON r0_.id = a2_.ref_vehicle_features_id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE';

SELECT
  a0_.id AS id_0,
  a0_.mobile_de_id AS mobile_de_id_1,
  a0_.slug AS slug_2,
  a0_.full_name AS full_name_3,
  a0_.price AS price_4,
  a0_.power AS power_5,
  a0_.mileage AS mileage_6,
  a0_.first_registration AS first_registration_7,
  a0_.delivery_date AS delivery_date_8,
  a0_.cubic_capacity AS cubic_capacity_9,
  a0_.num_seats AS num_seats_10,
  a0_.previous_owners AS previous_owners_11,
  a0_.manufacturer_color_name AS manufacturer_color_name_12,
  a0_.fuel_consumption_inner AS fuel_consumption_inner_13,
  a0_.fuel_consumption_outer AS fuel_consumption_outer_14,
  a0_.fuel_consumption_combined AS fuel_consumption_combined_15,
  a0_.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_16,
  a0_.co2_emission AS co2_emission_17,
  a0_.co2_emission_wltp AS co2_emission_wltp_18,
  a0_.emission_class AS emission_class_19,
  a0_.energy_efficiency_class AS energy_efficiency_class_20,
  a0_.on_home_page AS on_home_page_21,
  a0_.creating_method AS creating_method_22,
  a0_.full_description AS full_description_23,
  a0_.enriched_description AS enriched_description_24,
  a0_.financing_example AS financing_example_25,
  a0_.update_at AS update_at_26,
  a0_.seller_inventory_key AS seller_inventory_key_27,
  a0_.price_vatable AS price_vatable_28,
  a0_.car_internal_panorama AS car_internal_panorama_29,
  a0_.hire_purchase AS hire_purchase_30,
  a0_.huau AS huau_31,
  a0_.sale_status AS sale_status_32,
  a0_.reserved_at AS reserved_at_33,
  a0_.order_created_at AS order_created_at_34,
  MAX(
    ABS(
      CAST(a0_.price AS UNSIGNED)
    )
  ) AS sclr_35,
  MIN(
    ABS(
      CAST(a0_.price AS UNSIGNED)
    )
  ) AS sclr_36,
  a0_.class_id AS class_id_37,
  a0_.cat_id AS cat_id_38,
  a0_.maker_id AS maker_id_39,
  a0_.model_id AS model_id_40,
  a0_.fuel_id AS fuel_id_41,
  a0_.gearbox_id AS gearbox_id_42,
  a0_.interior_type_id AS interior_type_id_43,
  a0_.door_count_id AS door_count_id_44,
  a0_.car_condition_id AS car_condition_id_45,
  a0_.climatisation_id AS climatisation_id_46,
  a0_.exterior_color_id AS exterior_color_id_47,
  a0_.filial_id AS filial_id_48,
  a0_.api_account_id AS api_account_id_49
FROM
  ads a0_
WHERE
  a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a0_.sale_status = ?
  AND a0_.sale_status = ?
  AND a0_.sale_status = ?
  AND a0_.sale_status = ?

SELECT a0_.id AS id_0, a0_.mobile_de_id AS mobile_de_id_1, a0_.slug AS slug_2, a0_.full_name AS full_name_3, a0_.price AS price_4, a0_.power AS power_5, a0_.mileage AS mileage_6, a0_.first_registration AS first_registration_7, a0_.delivery_date AS delivery_date_8, a0_.cubic_capacity AS cubic_capacity_9, a0_.num_seats AS num_seats_10, a0_.previous_owners AS previous_owners_11, a0_.manufacturer_color_name AS manufacturer_color_name_12, a0_.fuel_consumption_inner AS fuel_consumption_inner_13, a0_.fuel_consumption_outer AS fuel_consumption_outer_14, a0_.fuel_consumption_combined AS fuel_consumption_combined_15, a0_.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_16, a0_.co2_emission AS co2_emission_17, a0_.co2_emission_wltp AS co2_emission_wltp_18, a0_.emission_class AS emission_class_19, a0_.energy_efficiency_class AS energy_efficiency_class_20, a0_.on_home_page AS on_home_page_21, a0_.creating_method AS creating_method_22, a0_.full_description AS full_description_23, a0_.enriched_description AS enriched_description_24, a0_.financing_example AS financing_example_25, a0_.update_at AS update_at_26, a0_.seller_inventory_key AS seller_inventory_key_27, a0_.price_vatable AS price_vatable_28, a0_.car_internal_panorama AS car_internal_panorama_29, a0_.hire_purchase AS hire_purchase_30, a0_.huau AS huau_31, a0_.sale_status AS sale_status_32, a0_.reserved_at AS reserved_at_33, a0_.order_created_at AS order_created_at_34, MAX(ABS(CAST(a0_.price AS UNSIGNED))) AS sclr_35, MIN(ABS(CAST(a0_.price AS UNSIGNED))) AS sclr_36, a0_.class_id AS class_id_37, a0_.cat_id AS cat_id_38, a0_.maker_id AS maker_id_39, a0_.model_id AS model_id_40, a0_.fuel_id AS fuel_id_41, a0_.gearbox_id AS gearbox_id_42, a0_.interior_type_id AS interior_type_id_43, a0_.door_count_id AS door_count_id_44, a0_.car_condition_id AS car_condition_id_45, a0_.climatisation_id AS climatisation_id_46, a0_.exterior_color_id AS exterior_color_id_47, a0_.filial_id AS filial_id_48, a0_.api_account_id AS api_account_id_49 FROM ads a0_ WHERE a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a0_.sale_status = 'ON_SALE' AND a0_.sale_status = 'ON_SALE' AND a0_.sale_status = 'ON_SALE' AND a0_.sale_status = 'ON_SALE';

SELECT
  a0_.id AS id_0,
  a0_.mobile_de_id AS mobile_de_id_1,
  a0_.slug AS slug_2,
  a0_.full_name AS full_name_3,
  a0_.price AS price_4,
  a0_.power AS power_5,
  a0_.mileage AS mileage_6,
  a0_.first_registration AS first_registration_7,
  a0_.delivery_date AS delivery_date_8,
  a0_.cubic_capacity AS cubic_capacity_9,
  a0_.num_seats AS num_seats_10,
  a0_.previous_owners AS previous_owners_11,
  a0_.manufacturer_color_name AS manufacturer_color_name_12,
  a0_.fuel_consumption_inner AS fuel_consumption_inner_13,
  a0_.fuel_consumption_outer AS fuel_consumption_outer_14,
  a0_.fuel_consumption_combined AS fuel_consumption_combined_15,
  a0_.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_16,
  a0_.co2_emission AS co2_emission_17,
  a0_.co2_emission_wltp AS co2_emission_wltp_18,
  a0_.emission_class AS emission_class_19,
  a0_.energy_efficiency_class AS energy_efficiency_class_20,
  a0_.on_home_page AS on_home_page_21,
  a0_.creating_method AS creating_method_22,
  a0_.full_description AS full_description_23,
  a0_.enriched_description AS enriched_description_24,
  a0_.financing_example AS financing_example_25,
  a0_.update_at AS update_at_26,
  a0_.seller_inventory_key AS seller_inventory_key_27,
  a0_.price_vatable AS price_vatable_28,
  a0_.car_internal_panorama AS car_internal_panorama_29,
  a0_.hire_purchase AS hire_purchase_30,
  a0_.huau AS huau_31,
  a0_.sale_status AS sale_status_32,
  a0_.reserved_at AS reserved_at_33,
  a0_.order_created_at AS order_created_at_34,
  MAX(
    ABS(
      CAST(a0_.hire_purchase AS UNSIGNED)
    )
  ) AS sclr_35,
  MIN(
    ABS(
      CAST(a0_.hire_purchase AS UNSIGNED)
    )
  ) AS sclr_36,
  a0_.class_id AS class_id_37,
  a0_.cat_id AS cat_id_38,
  a0_.maker_id AS maker_id_39,
  a0_.model_id AS model_id_40,
  a0_.fuel_id AS fuel_id_41,
  a0_.gearbox_id AS gearbox_id_42,
  a0_.interior_type_id AS interior_type_id_43,
  a0_.door_count_id AS door_count_id_44,
  a0_.car_condition_id AS car_condition_id_45,
  a0_.climatisation_id AS climatisation_id_46,
  a0_.exterior_color_id AS exterior_color_id_47,
  a0_.filial_id AS filial_id_48,
  a0_.api_account_id AS api_account_id_49
FROM
  ads a0_
WHERE
  a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a0_.sale_status = ?
  AND a0_.sale_status = ?

SELECT a0_.id AS id_0, a0_.mobile_de_id AS mobile_de_id_1, a0_.slug AS slug_2, a0_.full_name AS full_name_3, a0_.price AS price_4, a0_.power AS power_5, a0_.mileage AS mileage_6, a0_.first_registration AS first_registration_7, a0_.delivery_date AS delivery_date_8, a0_.cubic_capacity AS cubic_capacity_9, a0_.num_seats AS num_seats_10, a0_.previous_owners AS previous_owners_11, a0_.manufacturer_color_name AS manufacturer_color_name_12, a0_.fuel_consumption_inner AS fuel_consumption_inner_13, a0_.fuel_consumption_outer AS fuel_consumption_outer_14, a0_.fuel_consumption_combined AS fuel_consumption_combined_15, a0_.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_16, a0_.co2_emission AS co2_emission_17, a0_.co2_emission_wltp AS co2_emission_wltp_18, a0_.emission_class AS emission_class_19, a0_.energy_efficiency_class AS energy_efficiency_class_20, a0_.on_home_page AS on_home_page_21, a0_.creating_method AS creating_method_22, a0_.full_description AS full_description_23, a0_.enriched_description AS enriched_description_24, a0_.financing_example AS financing_example_25, a0_.update_at AS update_at_26, a0_.seller_inventory_key AS seller_inventory_key_27, a0_.price_vatable AS price_vatable_28, a0_.car_internal_panorama AS car_internal_panorama_29, a0_.hire_purchase AS hire_purchase_30, a0_.huau AS huau_31, a0_.sale_status AS sale_status_32, a0_.reserved_at AS reserved_at_33, a0_.order_created_at AS order_created_at_34, MAX(ABS(CAST(a0_.hire_purchase AS UNSIGNED))) AS sclr_35, MIN(ABS(CAST(a0_.hire_purchase AS UNSIGNED))) AS sclr_36, a0_.class_id AS class_id_37, a0_.cat_id AS cat_id_38, a0_.maker_id AS maker_id_39, a0_.model_id AS model_id_40, a0_.fuel_id AS fuel_id_41, a0_.gearbox_id AS gearbox_id_42, a0_.interior_type_id AS interior_type_id_43, a0_.door_count_id AS door_count_id_44, a0_.car_condition_id AS car_condition_id_45, a0_.climatisation_id AS climatisation_id_46, a0_.exterior_color_id AS exterior_color_id_47, a0_.filial_id AS filial_id_48, a0_.api_account_id AS api_account_id_49 FROM ads a0_ WHERE a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a0_.sale_status = 'ON_SALE' AND a0_.sale_status = 'ON_SALE';

SELECT
  DISTINCT f0_.name AS name_0,
  f0_.full_name AS full_name_1
FROM
  ads a1_
  LEFT JOIN filial f0_ ON a1_.filial_id = f0_.id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?

SELECT DISTINCT f0_.name AS name_0, f0_.full_name AS full_name_1 FROM ads a1_ LEFT JOIN filial f0_ ON a1_.filial_id = f0_.id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE';

SELECT
  DISTINCT r0_.name AS name_0,
  r0_.name_de AS name_de_1,
  r0_.sort_key AS sort_key_2
FROM
  ads a1_
  LEFT JOIN ref_vehicle_makers r0_ ON a1_.maker_id = r0_.id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?

SELECT DISTINCT r0_.name AS name_0, r0_.name_de AS name_de_1, r0_.sort_key AS sort_key_2 FROM ads a1_ LEFT JOIN ref_vehicle_makers r0_ ON a1_.maker_id = r0_.id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE';

SELECT
  t0.id AS id_1,
  t0.img_num AS img_num_2,
  t0.mobile_de_id AS mobile_de_id_3,
  t0.file_name AS file_name_4,
  t0.path AS path_5,
  t0.web_path AS web_path_6,
  t0.ads_id AS ads_id_7
FROM
  ads_images t0
WHERE
  t0.ads_id = ?

SELECT t0.id AS id_1, t0.img_num AS img_num_2, t0.mobile_de_id AS mobile_de_id_3, t0.file_name AS file_name_4, t0.path AS path_5, t0.web_path AS web_path_6, t0.ads_id AS ads_id_7 FROM ads_images t0 WHERE t0.ads_id = 5127;

SELECT
  DISTINCT r0_.name AS name_0,
  r0_.name_de AS name_de_1
FROM
  ads a1_
  LEFT JOIN ref_vehicle_categories r0_ ON a1_.cat_id = r0_.id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?

SELECT DISTINCT r0_.name AS name_0, r0_.name_de AS name_de_1 FROM ads a1_ LEFT JOIN ref_vehicle_categories r0_ ON a1_.cat_id = r0_.id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE';

SELECT
  DISTINCT r0_.name AS name_0,
  r0_.name_de AS name_de_1
FROM
  ads a1_
  LEFT JOIN ref_condition r0_ ON a1_.car_condition_id = r0_.id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?

SELECT DISTINCT r0_.name AS name_0, r0_.name_de AS name_de_1 FROM ads a1_ LEFT JOIN ref_condition r0_ ON a1_.car_condition_id = r0_.id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE';

SELECT
  DISTINCT r0_.name AS name_0,
  r0_.name_de AS name_de_1
FROM
  ads a1_
  LEFT JOIN ref_fuel r0_ ON a1_.fuel_id = r0_.id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?
  AND a1_.sale_status = ?

SELECT DISTINCT r0_.name AS name_0, r0_.name_de AS name_de_1 FROM ads a1_ LEFT JOIN ref_fuel r0_ ON a1_.fuel_id = r0_.id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE' AND a1_.sale_status = 'ON_SALE';

SELECT
  DISTINCT r0_.name AS name_0,
  r0_.name_de AS name_de_1
FROM
  ads a1_
  LEFT JOIN ref_color r0_ ON a1_.exterior_color_id = r0_.id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?

SELECT DISTINCT r0_.name AS name_0, r0_.name_de AS name_de_1 FROM ads a1_ LEFT JOIN ref_color r0_ ON a1_.exterior_color_id = r0_.id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE';

SELECT
  DISTINCT r0_.name AS name_0,
  r0_.name_de AS name_de_1
FROM
  ads a1_
  LEFT JOIN ref_gearbox r0_ ON a1_.gearbox_id = r0_.id
WHERE
  a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a1_.sale_status = ?
  AND a1_.sale_status = ?

SELECT DISTINCT r0_.name AS name_0, r0_.name_de AS name_de_1 FROM ads a1_ LEFT JOIN ref_gearbox r0_ ON a1_.gearbox_id = r0_.id WHERE a1_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a1_.sale_status = 'ON_SALE' AND a1_.sale_status = 'ON_SALE';

SELECT
  t0.id AS id_1,
  t0.loan_prepayment AS loan_prepayment_2,
  t0.vendor AS vendor_3,
  t0.category_type AS category_type_4,
  t0.product_type AS product_type_5,
  t0.net_credit_amount AS net_credit_amount_6,
  t0.product_sub_type AS product_sub_type_7,
  t0.loan_term AS loan_term_8,
  t0.adjusted_term_value AS adjusted_term_value_9,
  t0.year_mileage AS year_mileage_10,
  t0.amount AS amount_11,
  t0.loan_amount AS loan_amount_12,
  t0.effective_interest AS effective_interest_13,
  t0.final_payment AS final_payment_14,
  t0.monthly_installment AS monthly_installment_15,
  t0.total_amount AS total_amount_16,
  t0.available_requests_values AS available_requests_values_17,
  t0.available_calculation_params_values AS available_calculation_params_values_18,
  t0.calculation_input_disclaimer_values AS calculation_input_disclaimer_values_19,
  t0.calculation_output_disclaimer_values AS calculation_output_disclaimer_values_20,
  t0.create_at AS create_at_21,
  t0.ads_id AS ads_id_22,
  t0.maker_id AS maker_id_23,
  t0.full_api_response_id AS full_api_response_id_24
FROM
  loan_calculator_calculations t0
WHERE
  t0.ads_id IN (?)

SELECT t0.id AS id_1, t0.loan_prepayment AS loan_prepayment_2, t0.vendor AS vendor_3, t0.category_type AS category_type_4, t0.product_type AS product_type_5, t0.net_credit_amount AS net_credit_amount_6, t0.product_sub_type AS product_sub_type_7, t0.loan_term AS loan_term_8, t0.adjusted_term_value AS adjusted_term_value_9, t0.year_mileage AS year_mileage_10, t0.amount AS amount_11, t0.loan_amount AS loan_amount_12, t0.effective_interest AS effective_interest_13, t0.final_payment AS final_payment_14, t0.monthly_installment AS monthly_installment_15, t0.total_amount AS total_amount_16, t0.available_requests_values AS available_requests_values_17, t0.available_calculation_params_values AS available_calculation_params_values_18, t0.calculation_input_disclaimer_values AS calculation_input_disclaimer_values_19, t0.calculation_output_disclaimer_values AS calculation_output_disclaimer_values_20, t0.create_at AS create_at_21, t0.ads_id AS ads_id_22, t0.maker_id AS maker_id_23, t0.full_api_response_id AS full_api_response_id_24 FROM loan_calculator_calculations t0 WHERE t0.ads_id IN (37);

SELECT
  t0.id AS id_1,
  t0.class_id AS class_id_2,
  t0.name AS name_3,
  t0.name_de AS name_de_4
FROM
  ref_vehicle_features t0
  INNER JOIN ads_ref_vehicle_features ON t0.id = ads_ref_vehicle_features.ref_vehicle_features_id
WHERE
  ads_ref_vehicle_features.ads_id = ?

SELECT t0.id AS id_1, t0.class_id AS class_id_2, t0.name AS name_3, t0.name_de AS name_de_4 FROM ref_vehicle_features t0 INNER JOIN ads_ref_vehicle_features ON t0.id = ads_ref_vehicle_features.ref_vehicle_features_id WHERE ads_ref_vehicle_features.ads_id = 37;

SELECT
  DISTINCT a0_.mileage AS mileage_0
FROM
  ads a0_
WHERE
  a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a0_.sale_status = ?
  AND a0_.sale_status = ?

SELECT DISTINCT a0_.mileage AS mileage_0 FROM ads a0_ WHERE a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a0_.sale_status = 'ON_SALE' AND a0_.sale_status = 'ON_SALE';

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.mileage AS mileage_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.calculated_at AS calculated_at_6,
  t0.ads_id AS ads_id_7
FROM
  ads_comparison t0
WHERE
  t0.ads_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.mileage AS mileage_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.calculated_at AS calculated_at_6, t0.ads_id AS ads_id_7 FROM ads_comparison t0 WHERE t0.ads_id = 37;

SELECT
  DISTINCT a0_.power AS power_0
FROM
  ads a0_
WHERE
  a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a0_.sale_status = ?
  AND a0_.sale_status = ?
  AND a0_.sale_status = ?

SELECT DISTINCT a0_.power AS power_0 FROM ads a0_ WHERE a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a0_.sale_status = 'ON_SALE' AND a0_.sale_status = 'ON_SALE' AND a0_.sale_status = 'ON_SALE';

SELECT
  DISTINCT a0_.first_registration AS first_registration_0
FROM
  ads a0_
WHERE
  a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
  AND a0_.sale_status = ?

SELECT DISTINCT a0_.first_registration AS first_registration_0 FROM ads a0_ WHERE a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT') AND a0_.sale_status = 'ON_SALE';

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  ads a0_
WHERE
  a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM ads a0_ WHERE a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_de AS name_de_3,
  t0.group_key AS group_key_4,
  t0.make_id AS make_id_5,
  t0.vehicle_class_id AS vehicle_class_id_6
FROM
  ref_vehicle_models t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3, t0.group_key AS group_key_4, t0.make_id AS make_id_5, t0.vehicle_class_id AS vehicle_class_id_6 FROM ref_vehicle_models t0 WHERE t0.id IN (24);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.section AS section_3,
  t0.value AS value_4,
  t0.description AS description_5,
  t0.twig_parameters AS twig_parameters_6,
  t0.flag AS flag_7,
  t0.data_type AS data_type_8
FROM
  craue_settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.section AS section_3, t0.value AS value_4, t0.description  AS description_5, t0.twig_parameters AS twig_parameters_6, t0.flag AS flag_7, t0.data_type AS data_type_8 FROM craue_settings t0 WHERE t0.name = 'PREFERRED_MAKERS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.full_name AS full_name_3,
  t0.phone AS phone_4,
  t0.e_mail AS e_mail_5,
  t0.firm_name AS firm_name_6,
  t0.address AS address_7,
  t0.city AS city_8,
  t0.zip AS zip_9,
  t0.geo_position AS geo_position_10,
  t0.photo_file AS photo_file_11,
  t0.is_active AS is_active_12,
  t0.map_url AS map_url_13,
  t0.map_iframe AS map_iframe_14,
  t0.link_antragstrecke AS link_antragstrecke_15,
  t0.link_landingpage AS link_landingpage_16,
  t0.brand_logos AS brand_logos_17,
  t0.opening_hours AS opening_hours_18,
  t0.order_weight AS order_weight_19,
  t0.external_id AS external_id_20
FROM
  filial t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.full_name AS full_name_3, t0.phone AS phone_4, t0.e_mail AS e_mail_5, t0.firm_name AS firm_name_6, t0.address AS address_7, t0.city AS city_8, t0.zip AS zip_9, t0.geo_position AS geo_position_10, t0.photo_file AS photo_file_11, t0.is_active AS is_active_12, t0.map_url AS map_url_13, t0.map_iframe AS map_iframe_14, t0.link_antragstrecke AS link_antragstrecke_15, t0.link_landingpage AS link_landingpage_16, t0.brand_logos AS brand_logos_17, t0.opening_hours AS opening_hours_18, t0.order_weight AS order_weight_19, t0.external_id AS external_id_20 FROM filial t0 WHERE t0.id IN (5);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_de AS name_de_3,
  t0.vehicle_class_id AS vehicle_class_id_4
FROM
  ref_vehicle_categories t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3, t0.vehicle_class_id AS vehicle_class_id_4 FROM ref_vehicle_categories t0 WHERE t0.id IN (27);

SELECT
  a0_.id AS id_0,
  a0_.mobile_de_id AS mobile_de_id_1,
  a0_.slug AS slug_2,
  a0_.full_name AS full_name_3,
  a0_.price AS price_4,
  a0_.power AS power_5,
  a0_.mileage AS mileage_6,
  a0_.first_registration AS first_registration_7,
  a0_.delivery_date AS delivery_date_8,
  a0_.cubic_capacity AS cubic_capacity_9,
  a0_.num_seats AS num_seats_10,
  a0_.previous_owners AS previous_owners_11,
  a0_.manufacturer_color_name AS manufacturer_color_name_12,
  a0_.fuel_consumption_inner AS fuel_consumption_inner_13,
  a0_.fuel_consumption_outer AS fuel_consumption_outer_14,
  a0_.fuel_consumption_combined AS fuel_consumption_combined_15,
  a0_.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_16,
  a0_.co2_emission AS co2_emission_17,
  a0_.co2_emission_wltp AS co2_emission_wltp_18,
  a0_.emission_class AS emission_class_19,
  a0_.energy_efficiency_class AS energy_efficiency_class_20,
  a0_.on_home_page AS on_home_page_21,
  a0_.creating_method AS creating_method_22,
  a0_.full_description AS full_description_23,
  a0_.enriched_description AS enriched_description_24,
  a0_.financing_example AS financing_example_25,
  a0_.update_at AS update_at_26,
  a0_.seller_inventory_key AS seller_inventory_key_27,
  a0_.price_vatable AS price_vatable_28,
  a0_.car_internal_panorama AS car_internal_panorama_29,
  a0_.hire_purchase AS hire_purchase_30,
  a0_.huau AS huau_31,
  a0_.sale_status AS sale_status_32,
  a0_.reserved_at AS reserved_at_33,
  a0_.order_created_at AS order_created_at_34,
  a0_.class_id AS class_id_35,
  a0_.cat_id AS cat_id_36,
  a0_.maker_id AS maker_id_37,
  a0_.model_id AS model_id_38,
  a0_.fuel_id AS fuel_id_39,
  a0_.gearbox_id AS gearbox_id_40,
  a0_.interior_type_id AS interior_type_id_41,
  a0_.door_count_id AS door_count_id_42,
  a0_.car_condition_id AS car_condition_id_43,
  a0_.climatisation_id AS climatisation_id_44,
  a0_.exterior_color_id AS exterior_color_id_45,
  a0_.filial_id AS filial_id_46,
  a0_.api_account_id AS api_account_id_47
FROM
  ads a0_
WHERE
  a0_.sale_status NOT IN ('ORDER_CREATED', 'SOLD_OUT')
GROUP BY
  a0_.id
ORDER BY
  a0_.id DESC
LIMIT
  24