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