GET http://gruppobossoni.wi-staging.it/v/n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic

Query Metrics

6 Database Queries
5 Different statements
15.75 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.66 ms
(48.64%)
1
SELECT t0.id AS id_1, t0.weicola_id AS weicola_id_2, t0.company_code AS company_code_3, t0.eurotax AS eurotax_4, t0.erp_id AS erp_id_5, t0.vehicle_status AS vehicle_status_6, t0.archive AS archive_7, t0.group_type AS group_type_8, t0.brand AS brand_9, t0.model AS model_10, t0.version AS version_11, t0.plate AS plate_12, t0.vin AS vin_13, t0.displacement AS displacement_14, t0.is_promo AS is_promo_15, t0.check_phyron AS check_phyron_16, t0.phyron_src AS phyron_src_17, t0.phyron_poster AS phyron_poster_18, t0.hide_list_price AS hide_list_price_19, t0.hide_location AS hide_location_20, t0.final_price AS final_price_21, t0.price_changed AS price_changed_22, t0.list_price AS list_price_23, t0.online_discount AS online_discount_24, t0.url_name AS url_name_25, t0.vat_label AS vat_label_26, t0.vat_exposed AS vat_exposed_27, t0.vat_included AS vat_included_28, t0.km AS km_29, t0.frame_type AS frame_type_30, t0.registration_year AS registration_year_31, t0.registration_month AS registration_month_32, t0.registration_date AS registration_date_33, t0.internal_color AS internal_color_34, t0.external_color AS external_color_35, t0.color AS color_36, t0.power_hp AS power_hp_37, t0.gears_number AS gears_number_38, t0.cylinders_number AS cylinders_number_39, t0.tax_hp AS tax_hp_40, t0.doors_number AS doors_number_41, t0.seats_number AS seats_number_42, t0.weight_kg AS weight_kg_43, t0.certification AS certification_44, t0.emission_gkm AS emission_gkm_45, t0.consumption_urban AS consumption_urban_46, t0.consumption_extra AS consumption_extra_47, t0.consumption_mixed AS consumption_mixed_48, t0.wltp_certification AS wltp_certification_49, t0.wltp_consumption_combined AS wltp_consumption_combined_50, t0.wltp_co2_combined AS wltp_co2_combined_51, t0.wltp_consumption_electric AS wltp_consumption_electric_52, t0.wltp_range_electric AS wltp_range_electric_53, t0.gear_type AS gear_type_54, t0.traction AS traction_55, t0.fuel AS fuel_56, t0.import_date AS import_date_57, t0.is_deleted AS is_deleted_58, t0.deleted_date AS deleted_date_59, t0.warranty AS warranty_60, t0.warranty_type AS warranty_type_61, t0.warranty_name AS warranty_name_62, t0.warranty_month AS warranty_month_63, t0.young_driver AS young_driver_64, t0.description AS description_65, t0.special_equipment AS special_equipment_66, t0.special_equipment_formatted AS special_equipment_formatted_67, t0.public_notes AS public_notes_68, t0.web_ad AS web_ad_69, t0.v_height AS v_height_70, t0.v_width AS v_width_71, t0.v_length AS v_length_72, t0.acceleration AS acceleration_73, t0.torque AS torque_74, t0.max_speed AS max_speed_75, t0.valves AS valves_76, t0.step AS step_77, t0.luggage AS luggage_78, t0.pulling AS pulling_79, t0.weight_power AS weight_power_80, t0.tank_capacity AS tank_capacity_81, t0.wrap360internal AS wrap360internal_82, t0.wrap360external AS wrap360external_83, t0.location_erp_id AS location_erp_id_84, t0.youtube_code AS youtube_code_85, t0.counter_clicked_total AS counter_clicked_total_86, t0.counter_clicked_h24 AS counter_clicked_h24_87, t0.monthly_fee AS monthly_fee_88, t0.tan AS tan_89, t0.taeg AS taeg_90, t0.legal_note AS legal_note_91, t0.stock_days AS stock_days_92, t0.is_booked AS is_booked_93, t0.booked_end AS booked_end_94, t0.santander_json AS santander_json_95, t0.santander_log AS santander_log_96 FROM vehicle t0 WHERE t0.archive = ? AND t0.brand = ? AND t0.model = ? AND t0.group_type = ? AND t0.is_deleted IS NULL
Parameters:
[
  "nuovo"
  "audi"
  "a3"
  "auto"
]
4.08 ms
(25.92%)
2
SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND (((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = ?)) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = ? OR r0_.source_path = ?)) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = ?)))
Parameters:
[
  "gruppobossoni.wi-staging.it"
  "/v/n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic/"
  "/v/n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic"
  "/v/n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic"
  "/v/n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic/?"
  "/v/n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic?"
  "/v/n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic?"
]
1.70 ms
(10.80%)
1
SELECT v0_.id AS id_0, v0_.weicola_id AS weicola_id_1, v0_.company_code AS company_code_2, v0_.eurotax AS eurotax_3, v0_.erp_id AS erp_id_4, v0_.vehicle_status AS vehicle_status_5, v0_.archive AS archive_6, v0_.group_type AS group_type_7, v0_.brand AS brand_8, v0_.model AS model_9, v0_.version AS version_10, v0_.plate AS plate_11, v0_.vin AS vin_12, v0_.displacement AS displacement_13, v0_.is_promo AS is_promo_14, v0_.check_phyron AS check_phyron_15, v0_.phyron_src AS phyron_src_16, v0_.phyron_poster AS phyron_poster_17, v0_.hide_list_price AS hide_list_price_18, v0_.hide_location AS hide_location_19, v0_.final_price AS final_price_20, v0_.price_changed AS price_changed_21, v0_.list_price AS list_price_22, v0_.online_discount AS online_discount_23, v0_.url_name AS url_name_24, v0_.vat_label AS vat_label_25, v0_.vat_exposed AS vat_exposed_26, v0_.vat_included AS vat_included_27, v0_.km AS km_28, v0_.frame_type AS frame_type_29, v0_.registration_year AS registration_year_30, v0_.registration_month AS registration_month_31, v0_.registration_date AS registration_date_32, v0_.internal_color AS internal_color_33, v0_.external_color AS external_color_34, v0_.color AS color_35, v0_.power_hp AS power_hp_36, v0_.gears_number AS gears_number_37, v0_.cylinders_number AS cylinders_number_38, v0_.tax_hp AS tax_hp_39, v0_.doors_number AS doors_number_40, v0_.seats_number AS seats_number_41, v0_.weight_kg AS weight_kg_42, v0_.certification AS certification_43, v0_.emission_gkm AS emission_gkm_44, v0_.consumption_urban AS consumption_urban_45, v0_.consumption_extra AS consumption_extra_46, v0_.consumption_mixed AS consumption_mixed_47, v0_.wltp_certification AS wltp_certification_48, v0_.wltp_consumption_combined AS wltp_consumption_combined_49, v0_.wltp_co2_combined AS wltp_co2_combined_50, v0_.wltp_consumption_electric AS wltp_consumption_electric_51, v0_.wltp_range_electric AS wltp_range_electric_52, v0_.gear_type AS gear_type_53, v0_.traction AS traction_54, v0_.fuel AS fuel_55, v0_.import_date AS import_date_56, v0_.is_deleted AS is_deleted_57, v0_.deleted_date AS deleted_date_58, v0_.warranty AS warranty_59, v0_.warranty_type AS warranty_type_60, v0_.warranty_name AS warranty_name_61, v0_.warranty_month AS warranty_month_62, v0_.young_driver AS young_driver_63, v0_.description AS description_64, v0_.special_equipment AS special_equipment_65, v0_.special_equipment_formatted AS special_equipment_formatted_66, v0_.public_notes AS public_notes_67, v0_.web_ad AS web_ad_68, v0_.v_height AS v_height_69, v0_.v_width AS v_width_70, v0_.v_length AS v_length_71, v0_.acceleration AS acceleration_72, v0_.torque AS torque_73, v0_.max_speed AS max_speed_74, v0_.valves AS valves_75, v0_.step AS step_76, v0_.luggage AS luggage_77, v0_.pulling AS pulling_78, v0_.weight_power AS weight_power_79, v0_.tank_capacity AS tank_capacity_80, v0_.wrap360internal AS wrap360internal_81, v0_.wrap360external AS wrap360external_82, v0_.location_erp_id AS location_erp_id_83, v0_.youtube_code AS youtube_code_84, v0_.counter_clicked_total AS counter_clicked_total_85, v0_.counter_clicked_h24 AS counter_clicked_h24_86, v0_.monthly_fee AS monthly_fee_87, v0_.tan AS tan_88, v0_.taeg AS taeg_89, v0_.legal_note AS legal_note_90, v0_.stock_days AS stock_days_91, v0_.is_booked AS is_booked_92, v0_.booked_end AS booked_end_93, v0_.santander_json AS santander_json_94, v0_.santander_log AS santander_log_95 FROM vehicle v0_ WHERE (v0_.is_deleted = 0 OR v0_.is_deleted IS NULL) AND v0_.url_name = ?
Parameters:
[
  "n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic"
]
1.53 ms
(9.71%)
1
SELECT r0_.id AS id_0, r0_.source_host AS source_host_1, r0_.source_path AS source_path_2, r0_.redirect_url AS redirect_url_3, r0_.redirect_status_code AS redirect_status_code_4, r0_.strict_trailing_slash AS strict_trailing_slash_5, r0_.strict_url_query AS strict_url_query_6, r0_.redirect_count AS redirect_count_7, r0_.last_redirect AS last_redirect_8 FROM redirector_mapping r0_ WHERE r0_.source_host = ? AND r0_.source_path = ?
Parameters:
[
  "gruppobossoni.wi-staging.it"
  "*"
]
0.78 ms
(4.94%)
1
SELECT t0.id AS id_1, t0.weicola_id AS weicola_id_2, t0.company_code AS company_code_3, t0.eurotax AS eurotax_4, t0.erp_id AS erp_id_5, t0.vehicle_status AS vehicle_status_6, t0.archive AS archive_7, t0.group_type AS group_type_8, t0.brand AS brand_9, t0.model AS model_10, t0.version AS version_11, t0.plate AS plate_12, t0.vin AS vin_13, t0.displacement AS displacement_14, t0.is_promo AS is_promo_15, t0.check_phyron AS check_phyron_16, t0.phyron_src AS phyron_src_17, t0.phyron_poster AS phyron_poster_18, t0.hide_list_price AS hide_list_price_19, t0.hide_location AS hide_location_20, t0.final_price AS final_price_21, t0.price_changed AS price_changed_22, t0.list_price AS list_price_23, t0.online_discount AS online_discount_24, t0.url_name AS url_name_25, t0.vat_label AS vat_label_26, t0.vat_exposed AS vat_exposed_27, t0.vat_included AS vat_included_28, t0.km AS km_29, t0.frame_type AS frame_type_30, t0.registration_year AS registration_year_31, t0.registration_month AS registration_month_32, t0.registration_date AS registration_date_33, t0.internal_color AS internal_color_34, t0.external_color AS external_color_35, t0.color AS color_36, t0.power_hp AS power_hp_37, t0.gears_number AS gears_number_38, t0.cylinders_number AS cylinders_number_39, t0.tax_hp AS tax_hp_40, t0.doors_number AS doors_number_41, t0.seats_number AS seats_number_42, t0.weight_kg AS weight_kg_43, t0.certification AS certification_44, t0.emission_gkm AS emission_gkm_45, t0.consumption_urban AS consumption_urban_46, t0.consumption_extra AS consumption_extra_47, t0.consumption_mixed AS consumption_mixed_48, t0.wltp_certification AS wltp_certification_49, t0.wltp_consumption_combined AS wltp_consumption_combined_50, t0.wltp_co2_combined AS wltp_co2_combined_51, t0.wltp_consumption_electric AS wltp_consumption_electric_52, t0.wltp_range_electric AS wltp_range_electric_53, t0.gear_type AS gear_type_54, t0.traction AS traction_55, t0.fuel AS fuel_56, t0.import_date AS import_date_57, t0.is_deleted AS is_deleted_58, t0.deleted_date AS deleted_date_59, t0.warranty AS warranty_60, t0.warranty_type AS warranty_type_61, t0.warranty_name AS warranty_name_62, t0.warranty_month AS warranty_month_63, t0.young_driver AS young_driver_64, t0.description AS description_65, t0.special_equipment AS special_equipment_66, t0.special_equipment_formatted AS special_equipment_formatted_67, t0.public_notes AS public_notes_68, t0.web_ad AS web_ad_69, t0.v_height AS v_height_70, t0.v_width AS v_width_71, t0.v_length AS v_length_72, t0.acceleration AS acceleration_73, t0.torque AS torque_74, t0.max_speed AS max_speed_75, t0.valves AS valves_76, t0.step AS step_77, t0.luggage AS luggage_78, t0.pulling AS pulling_79, t0.weight_power AS weight_power_80, t0.tank_capacity AS tank_capacity_81, t0.wrap360internal AS wrap360internal_82, t0.wrap360external AS wrap360external_83, t0.location_erp_id AS location_erp_id_84, t0.youtube_code AS youtube_code_85, t0.counter_clicked_total AS counter_clicked_total_86, t0.counter_clicked_h24 AS counter_clicked_h24_87, t0.monthly_fee AS monthly_fee_88, t0.tan AS tan_89, t0.taeg AS taeg_90, t0.legal_note AS legal_note_91, t0.stock_days AS stock_days_92, t0.is_booked AS is_booked_93, t0.booked_end AS booked_end_94, t0.santander_json AS santander_json_95, t0.santander_log AS santander_log_96 FROM vehicle t0 WHERE t0.url_name = ? LIMIT 1
Parameters:
[
  "n132720-audi-a3-sportback-40-1-4-tfsi-e-business-advanced-s-tronic"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.