Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.mobile_de_id AS mobile_de_id_2,
  t0.slug AS slug_3,
  t0.full_name AS full_name_4,
  t0.price AS price_5,
  t0.power AS power_6,
  t0.mileage AS mileage_7,
  t0.first_registration AS first_registration_8,
  t0.delivery_date AS delivery_date_9,
  t0.cubic_capacity AS cubic_capacity_10,
  t0.num_seats AS num_seats_11,
  t0.previous_owners AS previous_owners_12,
  t0.manufacturer_color_name AS manufacturer_color_name_13,
  t0.fuel_consumption_inner AS fuel_consumption_inner_14,
  t0.fuel_consumption_outer AS fuel_consumption_outer_15,
  t0.fuel_consumption_combined AS fuel_consumption_combined_16,
  t0.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_17,
  t0.co2_emission AS co2_emission_18,
  t0.co2_emission_wltp AS co2_emission_wltp_19,
  t0.emission_class AS emission_class_20,
  t0.energy_efficiency_class AS energy_efficiency_class_21,
  t0.on_home_page AS on_home_page_22,
  t0.creating_method AS creating_method_23,
  t0.full_description AS full_description_24,
  t0.enriched_description AS enriched_description_25,
  t0.financing_example AS financing_example_26,
  t0.update_at AS update_at_27,
  t0.seller_inventory_key AS seller_inventory_key_28,
  t0.price_vatable AS price_vatable_29,
  t0.car_internal_panorama AS car_internal_panorama_30,
  t0.hire_purchase AS hire_purchase_31,
  t0.huau AS huau_32,
  t0.sale_status AS sale_status_33,
  t0.reserved_at AS reserved_at_34,
  t0.order_created_at AS order_created_at_35,
  t0.class_id AS class_id_36,
  t37.id AS id_38,
  t37.name AS name_39,
  t37.name_de AS name_de_40,
  t0.cat_id AS cat_id_41,
  t42.id AS id_43,
  t42.name AS name_44,
  t42.name_de AS name_de_45,
  t42.vehicle_class_id AS vehicle_class_id_46,
  t0.maker_id AS maker_id_47,
  t48.id AS id_49,
  t48.name AS name_50,
  t48.name_de AS name_de_51,
  t48.sel_group AS sel_group_52,
  t48.sort_key AS sort_key_53,
  t48.vehicle_class_id AS vehicle_class_id_54,
  t0.model_id AS model_id_55,
  t56.id AS id_57,
  t56.name AS name_58,
  t56.name_de AS name_de_59,
  t56.group_key AS group_key_60,
  t56.make_id AS make_id_61,
  t56.vehicle_class_id AS vehicle_class_id_62,
  t0.fuel_id AS fuel_id_63,
  t64.id AS id_65,
  t64.name AS name_66,
  t64.name_de AS name_de_67,
  t0.gearbox_id AS gearbox_id_68,
  t69.id AS id_70,
  t69.name AS name_71,
  t69.name_de AS name_de_72,
  t0.interior_type_id AS interior_type_id_73,
  t74.id AS id_75,
  t74.name AS name_76,
  t74.name_de AS name_de_77,
  t0.door_count_id AS door_count_id_78,
  t79.id AS id_80,
  t79.name AS name_81,
  t79.name_de AS name_de_82,
  t0.car_condition_id AS car_condition_id_83,
  t84.id AS id_85,
  t84.name AS name_86,
  t84.name_de AS name_de_87,
  t0.climatisation_id AS climatisation_id_88,
  t89.id AS id_90,
  t89.name AS name_91,
  t89.name_de AS name_de_92,
  t0.exterior_color_id AS exterior_color_id_93,
  t94.id AS id_95,
  t94.name AS name_96,
  t94.name_de AS name_de_97,
  t98.id AS id_99,
  t98.price AS price_100,
  t98.mileage AS mileage_101,
  t98.created_at AS created_at_102,
  t98.updated_at AS updated_at_103,
  t98.calculated_at AS calculated_at_104,
  t98.ads_id AS ads_id_105,
  t0.filial_id AS filial_id_106,
  t107.id AS id_108,
  t107.name AS name_109,
  t107.full_name AS full_name_110,
  t107.phone AS phone_111,
  t107.e_mail AS e_mail_112,
  t107.firm_name AS firm_name_113,
  t107.address AS address_114,
  t107.city AS city_115,
  t107.zip AS zip_116,
  t107.geo_position AS geo_position_117,
  t107.photo_file AS photo_file_118,
  t107.is_active AS is_active_119,
  t107.map_url AS map_url_120,
  t107.map_iframe AS map_iframe_121,
  t107.link_antragstrecke AS link_antragstrecke_122,
  t107.link_landingpage AS link_landingpage_123,
  t107.brand_logos AS brand_logos_124,
  t107.opening_hours AS opening_hours_125,
  t107.order_weight AS order_weight_126,
  t107.external_id AS external_id_127,
  t0.api_account_id AS api_account_id_128
FROM
  ads t0
  LEFT JOIN ref_vehicle_classes t37 ON t0.class_id = t37.id
  LEFT JOIN ref_vehicle_categories t42 ON t0.cat_id = t42.id
  LEFT JOIN ref_vehicle_makers t48 ON t0.maker_id = t48.id
  LEFT JOIN ref_vehicle_models t56 ON t0.model_id = t56.id
  LEFT JOIN ref_fuel t64 ON t0.fuel_id = t64.id
  LEFT JOIN ref_gearbox t69 ON t0.gearbox_id = t69.id
  LEFT JOIN ref_interior_type t74 ON t0.interior_type_id = t74.id
  LEFT JOIN ref_door_count t79 ON t0.door_count_id = t79.id
  LEFT JOIN ref_condition t84 ON t0.car_condition_id = t84.id
  LEFT JOIN ref_climatisation t89 ON t0.climatisation_id = t89.id
  LEFT JOIN ref_color t94 ON t0.exterior_color_id = t94.id
  LEFT JOIN ads_comparison t98 ON t98.ads_id = t0.id
  LEFT JOIN filial t107 ON t0.filial_id = t107.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.mobile_de_id AS mobile_de_id_2, t0.slug AS slug_3, t0.full_name AS full_name_4, t0.price AS price_5, t0.power AS power_6, t0.mileage AS mileage_7, t0.first_registration AS first_registration_8, t0.delivery_date AS delivery_date_9, t0.cubic_capacity AS cubic_capacity_10, t0.num_seats AS num_seats_11, t0.previous_owners AS previous_owners_12, t0.manufacturer_color_name AS manufacturer_color_name_13, t0.fuel_consumption_inner AS fuel_consumption_inner_14, t0.fuel_consumption_outer AS fuel_consumption_outer_15, t0.fuel_consumption_combined AS fuel_consumption_combined_16, t0.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_17, t0.co2_emission AS co2_emission_18, t0.co2_emission_wltp AS co2_emission_wltp_19, t0.emission_class AS emission_class_20, t0.energy_efficiency_class AS energy_efficiency_class_21, t0.on_home_page AS on_home_page_22, t0.creating_method AS creating_method_23, t0.full_description AS full_description_24, t0.enriched_description AS enriched_description_25, t0.financing_example AS financing_example_26, t0.update_at AS update_at_27, t0.seller_inventory_key AS seller_inventory_key_28, t0.price_vatable AS price_vatable_29, t0.car_internal_panorama AS car_internal_panorama_30, t0.hire_purchase AS hire_purchase_31, t0.huau AS huau_32, t0.sale_status AS sale_status_33, t0.reserved_at AS reserved_at_34, t0.order_created_at AS order_created_at_35, t0.class_id AS class_id_36, t37.id AS id_38, t37.name AS name_39, t37.name_de AS name_de_40, t0.cat_id AS cat_id_41, t42.id AS id_43, t42.name AS name_44, t42.name_de AS name_de_45, t42.vehicle_class_id AS vehicle_class_id_46, t0.maker_id AS maker_id_47, t48.id AS id_49, t48.name AS name_50, t48.name_de AS name_de_51, t48.sel_group AS sel_group_52, t48.sort_key AS sort_key_53, t48.vehicle_class_id AS vehicle_class_id_54, t0.model_id AS model_id_55, t56.id AS id_57, t56.name AS name_58, t56.name_de AS name_de_59, t56.group_key AS group_key_60, t56.make_id AS make_id_61, t56.vehicle_class_id AS vehicle_class_id_62, t0.fuel_id AS fuel_id_63, t64.id AS id_65, t64.name AS name_66, t64.name_de AS name_de_67, t0.gearbox_id AS gearbox_id_68, t69.id AS id_70, t69.name AS name_71, t69.name_de AS name_de_72, t0.interior_type_id AS interior_type_id_73, t74.id AS id_75, t74.name AS name_76, t74.name_de AS name_de_77, t0.door_count_id AS door_count_id_78, t79.id AS id_80, t79.name AS name_81, t79.name_de AS name_de_82, t0.car_condition_id AS car_condition_id_83, t84.id AS id_85, t84.name AS name_86, t84.name_de AS name_de_87, t0.climatisation_id AS climatisation_id_88, t89.id AS id_90, t89.name AS name_91, t89.name_de AS name_de_92, t0.exterior_color_id AS exterior_color_id_93, t94.id AS id_95, t94.name AS name_96, t94.name_de AS name_de_97, t98.id AS id_99, t98.price AS price_100, t98.mileage AS mileage_101, t98.created_at AS created_at_102, t98.updated_at AS updated_at_103, t98.calculated_at AS calculated_at_104, t98.ads_id AS ads_id_105, t0.filial_id AS filial_id_106, t107.id AS id_108, t107.name AS name_109, t107.full_name AS full_name_110, t107.phone AS phone_111, t107.e_mail AS e_mail_112, t107.firm_name AS firm_name_113, t107.address AS address_114, t107.city AS city_115, t107.zip AS zip_116, t107.geo_position AS geo_position_117, t107.photo_file AS photo_file_118, t107.is_active AS is_active_119, t107.map_url AS map_url_120, t107.map_iframe AS map_iframe_121, t107.link_antragstrecke AS link_antragstrecke_122, t107.link_landingpage AS link_landingpage_123, t107.brand_logos AS brand_logos_124, t107.opening_hours AS opening_hours_125, t107.order_weight AS order_weight_126, t107.external_id AS external_id_127, t0.api_account_id AS api_account_id_128 FROM ads t0 LEFT JOIN ref_vehicle_classes t37 ON t0.class_id = t37.id LEFT JOIN ref_vehicle_categories t42 ON t0.cat_id = t42.id LEFT JOIN ref_vehicle_makers t48 ON t0.maker_id = t48.id LEFT JOIN ref_vehicle_models t56 ON t0.model_id = t56.id LEFT JOIN ref_fuel t64 ON t0.fuel_id = t64.id LEFT JOIN ref_gearbox t69 ON t0.gearbox_id = t69.id LEFT JOIN ref_interior_type t74 ON t0.interior_type_id = t74.id LEFT JOIN ref_door_count t79 ON t0.door_count_id = t79.id LEFT JOIN ref_condition t84 ON t0.car_condition_id = t84.id LEFT JOIN ref_climatisation t89 ON t0.climatisation_id = t89.id LEFT JOIN ref_color t94 ON t0.exterior_color_id = t94.id LEFT JOIN ads_comparison t98 ON t98.ads_id = t0.id LEFT JOIN filial t107 ON t0.filial_id = t107.id WHERE t0.slug = 'BMW_218i_00003005022' LIMIT 1;

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

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 (221);

SELECT
  e0_.id AS id_0,
  e0_.username AS username_1,
  e0_.first_name AS first_name_2,
  e0_.last_name AS last_name_3,
  e0_.password AS password_4,
  e0_.plain_password AS plain_password_5,
  e0_.roles AS roles_6,
  e0_.salt AS salt_7,
  e0_.email AS email_8,
  e0_.phone AS phone_9,
  e0_.position AS position_10,
  e0_.image AS image_11,
  e0_.is_active AS is_active_12,
  e0_.staff_manager AS staff_manager_13,
  e0_.order_weight AS order_weight_14,
  e0_.old_car_mail_manager AS old_car_mail_manager_15,
  e0_.old_car_show_manager AS old_car_show_manager_16,
  e0_.new_car_mail_manager AS new_car_mail_manager_17,
  e0_.new_car_show_manager AS new_car_show_manager_18,
  RAND() AS sclr_19
FROM
  employees e0_
  INNER JOIN employee_filial e2_ ON e0_.id = e2_.employee_id
  INNER JOIN filial f1_ ON f1_.id = e2_.filial_id
  AND (f1_.id = ?)
WHERE
  (
    (
      EXISTS (
        SELECT
          1
        FROM
          employee_ref_vehicle_makes e3_
        WHERE
          e3_.employee_id = e0_.id
          AND e3_.ref_vehicle_makes_id IN (?)
      )
    )
    OR (
      SELECT
        COUNT(*)
      FROM
        employee_ref_vehicle_makes e3_
      WHERE
        e3_.employee_id = e0_.id
    ) = 0
  )
  AND e0_.new_car_show_manager = 1
ORDER BY
  sclr_19 ASC
LIMIT
  1

SELECT e0_.id AS id_0, e0_.username AS username_1, e0_.first_name AS first_name_2, e0_.last_name AS last_name_3, e0_.password AS password_4, e0_.plain_password AS plain_password_5, e0_.roles AS roles_6, e0_.salt AS salt_7, e0_.email AS email_8, e0_.phone AS phone_9, e0_.position AS position_10, e0_.image AS image_11, e0_.is_active AS is_active_12, e0_.staff_manager AS staff_manager_13, e0_.order_weight AS order_weight_14, e0_.old_car_mail_manager AS old_car_mail_manager_15, e0_.old_car_show_manager AS old_car_show_manager_16, e0_.new_car_mail_manager AS new_car_mail_manager_17, e0_.new_car_show_manager AS new_car_show_manager_18, RAND() AS sclr_19 FROM employees e0_ INNER JOIN employee_filial e2_ ON e0_.id = e2_.employee_id INNER JOIN filial f1_ ON f1_.id = e2_.filial_id AND (f1_.id = 2) WHERE ((EXISTS (SELECT 1 FROM employee_ref_vehicle_makes e3_ WHERE e3_.employee_id = e0_.id AND e3_.ref_vehicle_makes_id IN (15))) OR (SELECT COUNT(*) FROM employee_ref_vehicle_makes e3_ WHERE e3_.employee_id = e0_.id) = 0) AND e0_.new_car_show_manager = 1 ORDER BY sclr_19 ASC LIMIT 1;

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

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

SELECT
  t0.id AS id_1,
  t0.mobile_de_id AS mobile_de_id_2,
  t0.slug AS slug_3,
  t0.full_name AS full_name_4,
  t0.price AS price_5,
  t0.power AS power_6,
  t0.mileage AS mileage_7,
  t0.first_registration AS first_registration_8,
  t0.delivery_date AS delivery_date_9,
  t0.cubic_capacity AS cubic_capacity_10,
  t0.num_seats AS num_seats_11,
  t0.previous_owners AS previous_owners_12,
  t0.manufacturer_color_name AS manufacturer_color_name_13,
  t0.fuel_consumption_inner AS fuel_consumption_inner_14,
  t0.fuel_consumption_outer AS fuel_consumption_outer_15,
  t0.fuel_consumption_combined AS fuel_consumption_combined_16,
  t0.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_17,
  t0.co2_emission AS co2_emission_18,
  t0.co2_emission_wltp AS co2_emission_wltp_19,
  t0.emission_class AS emission_class_20,
  t0.energy_efficiency_class AS energy_efficiency_class_21,
  t0.on_home_page AS on_home_page_22,
  t0.creating_method AS creating_method_23,
  t0.full_description AS full_description_24,
  t0.enriched_description AS enriched_description_25,
  t0.financing_example AS financing_example_26,
  t0.update_at AS update_at_27,
  t0.seller_inventory_key AS seller_inventory_key_28,
  t0.price_vatable AS price_vatable_29,
  t0.car_internal_panorama AS car_internal_panorama_30,
  t0.hire_purchase AS hire_purchase_31,
  t0.huau AS huau_32,
  t0.sale_status AS sale_status_33,
  t0.reserved_at AS reserved_at_34,
  t0.order_created_at AS order_created_at_35,
  t0.class_id AS class_id_36,
  t37.id AS id_38,
  t37.name AS name_39,
  t37.name_de AS name_de_40,
  t0.cat_id AS cat_id_41,
  t42.id AS id_43,
  t42.name AS name_44,
  t42.name_de AS name_de_45,
  t42.vehicle_class_id AS vehicle_class_id_46,
  t0.maker_id AS maker_id_47,
  t48.id AS id_49,
  t48.name AS name_50,
  t48.name_de AS name_de_51,
  t48.sel_group AS sel_group_52,
  t48.sort_key AS sort_key_53,
  t48.vehicle_class_id AS vehicle_class_id_54,
  t0.model_id AS model_id_55,
  t56.id AS id_57,
  t56.name AS name_58,
  t56.name_de AS name_de_59,
  t56.group_key AS group_key_60,
  t56.make_id AS make_id_61,
  t56.vehicle_class_id AS vehicle_class_id_62,
  t0.fuel_id AS fuel_id_63,
  t64.id AS id_65,
  t64.name AS name_66,
  t64.name_de AS name_de_67,
  t0.gearbox_id AS gearbox_id_68,
  t69.id AS id_70,
  t69.name AS name_71,
  t69.name_de AS name_de_72,
  t0.interior_type_id AS interior_type_id_73,
  t74.id AS id_75,
  t74.name AS name_76,
  t74.name_de AS name_de_77,
  t0.door_count_id AS door_count_id_78,
  t79.id AS id_80,
  t79.name AS name_81,
  t79.name_de AS name_de_82,
  t0.car_condition_id AS car_condition_id_83,
  t84.id AS id_85,
  t84.name AS name_86,
  t84.name_de AS name_de_87,
  t0.climatisation_id AS climatisation_id_88,
  t89.id AS id_90,
  t89.name AS name_91,
  t89.name_de AS name_de_92,
  t0.exterior_color_id AS exterior_color_id_93,
  t94.id AS id_95,
  t94.name AS name_96,
  t94.name_de AS name_de_97,
  t98.id AS id_99,
  t98.price AS price_100,
  t98.mileage AS mileage_101,
  t98.created_at AS created_at_102,
  t98.updated_at AS updated_at_103,
  t98.calculated_at AS calculated_at_104,
  t98.ads_id AS ads_id_105,
  t0.filial_id AS filial_id_106,
  t107.id AS id_108,
  t107.name AS name_109,
  t107.full_name AS full_name_110,
  t107.phone AS phone_111,
  t107.e_mail AS e_mail_112,
  t107.firm_name AS firm_name_113,
  t107.address AS address_114,
  t107.city AS city_115,
  t107.zip AS zip_116,
  t107.geo_position AS geo_position_117,
  t107.photo_file AS photo_file_118,
  t107.is_active AS is_active_119,
  t107.map_url AS map_url_120,
  t107.map_iframe AS map_iframe_121,
  t107.link_antragstrecke AS link_antragstrecke_122,
  t107.link_landingpage AS link_landingpage_123,
  t107.brand_logos AS brand_logos_124,
  t107.opening_hours AS opening_hours_125,
  t107.order_weight AS order_weight_126,
  t107.external_id AS external_id_127,
  t0.api_account_id AS api_account_id_128
FROM
  ads t0
  LEFT JOIN ref_vehicle_classes t37 ON t0.class_id = t37.id
  LEFT JOIN ref_vehicle_categories t42 ON t0.cat_id = t42.id
  LEFT JOIN ref_vehicle_makers t48 ON t0.maker_id = t48.id
  LEFT JOIN ref_vehicle_models t56 ON t0.model_id = t56.id
  LEFT JOIN ref_fuel t64 ON t0.fuel_id = t64.id
  LEFT JOIN ref_gearbox t69 ON t0.gearbox_id = t69.id
  LEFT JOIN ref_interior_type t74 ON t0.interior_type_id = t74.id
  LEFT JOIN ref_door_count t79 ON t0.door_count_id = t79.id
  LEFT JOIN ref_condition t84 ON t0.car_condition_id = t84.id
  LEFT JOIN ref_climatisation t89 ON t0.climatisation_id = t89.id
  LEFT JOIN ref_color t94 ON t0.exterior_color_id = t94.id
  LEFT JOIN ads_comparison t98 ON t98.ads_id = t0.id
  LEFT JOIN filial t107 ON t0.filial_id = t107.id
WHERE
  t0.slug = ?
LIMIT
  1