Symfony Profiler

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
  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
  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_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 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
  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 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
  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_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
  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
  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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_de AS name_de_3
FROM
  ref_vehicle_classes t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_vehicle_classes t0 WHERE t0.id IN (3);

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.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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_de AS name_de_3,
  t0.sel_group AS sel_group_4,
  t0.sort_key AS sort_key_5,
  t0.vehicle_class_id AS vehicle_class_id_6
FROM
  ref_vehicle_makers t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3, t0.sel_group AS sel_group_4, t0.sort_key AS sort_key_5, t0.vehicle_class_id AS vehicle_class_id_6 FROM ref_vehicle_makers t0 WHERE t0.id IN (3);

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.name_de AS name_de_3
FROM
  ref_fuel t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_fuel t0 WHERE t0.id IN (1);

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_gearbox t0 WHERE t0.id IN (3);

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_interior_type t0 WHERE t0.id IN (3);

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_door_count t0 WHERE t0.id IN (2);

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_condition t0 WHERE t0.id IN (1);

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_climatisation t0 WHERE t0.id IN (5);

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_de AS name_de_3 FROM ref_color t0 WHERE t0.id IN (10);

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
  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
  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
  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
  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,
  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

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;

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