Query Metrics
33
Database Queries
26
Different statements
112.68 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
23.60 ms (20.95%) |
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_.archive = 'usato') OR (v0_.archive = 'km0'))) AND (v0_.is_deleted IS NULL OR v0_.is_deleted = 0)
Parameters:
[] |
16.57 ms (14.70%) |
3 |
SELECT t0.id AS id_1, t0.prefix AS prefix_2, t0.title AS title_3, t0.description AS description_4, t0.original_filename AS original_filename_5, t0.image_type AS image_type_6, t0.image_source AS image_source_7, t0.mime_type AS mime_type_8, t0.cache_status_json AS cache_status_json_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11 FROM imgbundle_image t0 WHERE t0.id = ?
Parameters:
[
"1cd8c3d8-b68b-4462-afa0-30107229562c"
]
|
10.84 ms (9.62%) |
3 |
SELECT i0_.id AS id_0, i0_.prefix AS prefix_1, i0_.title AS title_2, i0_.description AS description_3, i0_.original_filename AS original_filename_4, i0_.image_type AS image_type_5, i0_.image_source AS image_source_6, i0_.mime_type AS mime_type_7, i0_.cache_status_json AS cache_status_json_8, i0_.created_at AS created_at_9, i0_.modified_at AS modified_at_10 FROM imgbundle_image i0_ WHERE i0_.id = ?
Parameters:
[
"1cd8c3d8-b68b-4462-afa0-30107229562c"
]
|
7.88 ms (6.99%) |
1 |
SELECT t0.id AS id_1, t0.erp_id AS erp_id_2, t0.name AS name_3, t0.company AS company_4, t0.is_visible AS is_visible_5, t0.storage_area AS storage_area_6, t0.city AS city_7, t0.province AS province_8, t0.address AS address_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.cap AS cap_12, t0.sort_index AS sort_index_13, t0.url_name AS url_name_14, t0.seo_title AS seo_title_15, t0.seo_description AS seo_description_16, t0.image AS image_17, t0.image_map AS image_map_18, t0.general_info AS general_info_19, t0.date_create AS date_create_20, t0.date_last_update AS date_last_update_21 FROM location t0 WHERE t0.id = ?
Parameters:
[
"213c9f5f-7da7-4b60-b22b-77f891f34849"
]
|
7.52 ms (6.67%) |
1 |
SELECT t0.id AS id_1, t0.day_week AS day_week_2, t0.time_start_morning AS time_start_morning_3, t0.time_end_morning AS time_end_morning_4, t0.time_start_afternoon AS time_start_afternoon_5, t0.time_end_afternoon AS time_end_afternoon_6, t0.locationTypeId AS locationTypeId_7 FROM HOUR t0 WHERE t0.locationTypeId = ? ORDER BY t0.day_week ASC
Parameters:
[
"60ddf482-8c14-40c2-9f55-276a1f0de662"
]
|
6.07 ms (5.39%) |
1 |
SELECT t0.id AS id_1, t0.sort_index AS sort_index_2, t0.image_url AS image_url_3, t0.image_url_small AS image_url_small_4, t0.image_url_medium AS image_url_medium_5, t0.image_url_thumb AS image_url_thumb_6, t0.vehicleId AS vehicleId_7 FROM vehicle_image t0 WHERE t0.vehicleId = ? ORDER BY t0.sort_index ASC
Parameters:
[
"12506"
]
|
4.40 ms (3.91%) |
3 |
SELECT t0.id AS id_1, t0.sort_index AS sort_index_2, t0.image_id AS image_id_3, t0.tag_id AS tag_id_4 FROM imgbundle_image_tag_join t0 WHERE t0.image_id = ?
Parameters:
[
"1cd8c3d8-b68b-4462-afa0-30107229562c"
]
|
4.31 ms (3.82%) |
1 |
SELECT b0_.id AS id_0, b0_.label AS label_1, b0_.disclaimer AS disclaimer_2, b0_.day AS day_3, b0_.deposit AS deposit_4, b0_.is_visible AS is_visible_5, b0_.plates AS plates_6, b0_.vins AS vins_7, b0_.erp_ids AS erp_ids_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.date_create AS date_create_11, b0_.date_last_update AS date_last_update_12 FROM booking b0_ LEFT JOIN booking_brand_model b1_ ON b0_.id = b1_.idBooking LEFT JOIN booking_archive b2_ ON b0_.id = b2_.idBooking WHERE b0_.is_visible = 1 AND ((b0_.date_start IS NULL OR b0_.date_start <= ?)) AND ((b0_.date_end IS NULL OR b0_.date_end >= ?)) AND (((b2_.archive = ? AND ((b1_.brand = ? AND b1_.model = ?) OR (b1_.brand = ? AND b1_.model IS NULL) OR (b1_.brand IS NULL AND b1_.model IS NULL))) OR (b0_.plates LIKE ? AND b0_.plates IS NOT NULL AND b0_.plates <> ?) OR (b0_.vins LIKE ? AND b0_.vins IS NOT NULL AND b0_.vins <> ?) OR (b0_.erp_ids LIKE ? AND b0_.erp_ids IS NOT NULL AND b0_.erp_ids <> ?))) ORDER BY b0_.deposit ASC
Parameters:
[ "2024-10-05 00:00:00" "2024-10-05 00:00:00" "km0" "Peugeot" "e-208" "Peugeot" "%GL844PY%" "" "%VR3UHZKXZNT120411%" "" "%GB-N696440%" "" ] |
4.22 ms (3.74%) |
1 |
SELECT l0_.id AS id_0, l0_.type AS type_1, l0_.is_visible AS is_visible_2, l0_.phone AS phone_3, l0_.whatsapp AS whatsapp_4, l0_.hour_text AS hour_text_5, l0_.fax AS fax_6, l0_.email AS email_7, l0_.sort_index AS sort_index_8, l0_.date_create AS date_create_9, l0_.date_last_update AS date_last_update_10, l0_.locationId AS locationId_11 FROM location_type l0_ INNER JOIN location l1_ ON l0_.locationId = l1_.id WHERE l0_.is_visible = 1 AND l1_.is_visible = 1 AND l1_.erp_id = ? AND l0_.type = ?
Parameters:
[ "GB-7" "vendita" ] |
4.14 ms (3.67%) |
1 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.type AS type_4, t0.vehicleId AS vehicleId_5 FROM vehicle_optional t0 WHERE t0.vehicleId = ?
Parameters:
[
"12506"
]
|
3.68 ms (3.26%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.url_name AS url_name_4, t0.is_vic AS is_vic_5, t0.eurotax_code AS eurotax_code_6, t0.sort_index AS sort_index_7, t0.emergency_call_italy AS emergency_call_italy_8, t0.emergency_call_abroad AS emergency_call_abroad_9, t0.companyId AS companyId_10 FROM brand t0 INNER JOIN location_brand_join ON t0.id = location_brand_join.brandId WHERE location_brand_join.locationId = ?
Parameters:
[
"213c9f5f-7da7-4b60-b22b-77f891f34849"
]
|
3.32 ms (2.95%) |
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/gb-n696440-peugeot-208-5-porte-100kw-gt/" "/v/gb-n696440-peugeot-208-5-porte-100kw-gt" "/v/gb-n696440-peugeot-208-5-porte-100kw-gt" "/v/gb-n696440-peugeot-208-5-porte-100kw-gt/?" "/v/gb-n696440-peugeot-208-5-porte-100kw-gt?" "/v/gb-n696440-peugeot-208-5-porte-100kw-gt?" ] |
1.79 ms (1.59%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.hide_title AS hide_title_2, b0_.show_your_style AS show_your_style_3, b0_.type AS type_4, b0_.custom_type AS custom_type_5, b0_.subtitle AS subtitle_6, b0_.content AS content_7, b0_.sort_index AS sort_index_8, b0_.link AS link_9, b0_.link_label AS link_label_10, b0_.link_blank AS link_blank_11, b0_.show_text_desktop AS show_text_desktop_12, b0_.show_text_mobile AS show_text_mobile_13, b0_.image AS image_14, b0_.image_listing AS image_listing_15, b0_.image_mobile AS image_mobile_16, b0_.image_listing_mobile AS image_listing_mobile_17, b0_.video AS video_18, b0_.is_visible AS is_visible_19, b0_.date_create AS date_create_20, b0_.date_last_update AS date_last_update_21, b0_.date_start AS date_start_22, b0_.date_end AS date_end_23, b0_.is_countdown AS is_countdown_24, b0_.countdown_end AS countdown_end_25, b0_.list_price AS list_price_26, b0_.promo_price AS promo_price_27, b0_.is_free AS is_free_28, b0_.request_type AS request_type_29, b0_.open_dedicated_form AS open_dedicated_form_30, b0_.in_listing AS in_listing_31, b0_.in_card AS in_card_32, b0_.card_color AS card_color_33, b0_.card_label AS card_label_34, b0_.vins AS vins_35, b0_.plates AS plates_36, b0_.erp_ids AS erp_ids_37, b0_.bannerPositionId AS bannerPositionId_38, b0_.brandId AS brandId_39 FROM banner b0_ LEFT JOIN banner_archive b1_ ON b0_.id = b1_.idBanner LEFT JOIN banner_brand_model b2_ ON b0_.id = b2_.bannerId LEFT JOIN banner_warranty b3_ ON b0_.id = b3_.bannerId LEFT JOIN banner_fuel b4_ ON b0_.id = b4_.bannerId LEFT JOIN banner_frame_type b5_ ON b0_.id = b5_.bannerId WHERE (((b1_.archive = ? AND ((b2_.brand = ? AND b2_.model = ?) OR (b2_.brand = ? AND b2_.model IS NULL) OR (b2_.brand IS NULL AND b2_.model IS NULL)) AND (b3_.warranty IS NULL OR b3_.warranty = ?) AND (b4_.fuel IS NULL OR b4_.fuel = ?) AND (b5_.frame_type IS NULL OR b5_.frame_type = ?)) OR (b0_.plates LIKE ? AND b0_.plates IS NOT NULL AND b0_.plates <> ?) OR (b0_.vins LIKE ? AND b0_.vins IS NOT NULL AND b0_.vins <> ?) OR (b0_.erp_ids LIKE ? AND b0_.erp_ids IS NOT NULL AND b0_.erp_ids <> ?))) AND ((b0_.date_start IS NULL OR b0_.date_start <= ?)) AND ((b0_.date_end IS NULL OR b0_.date_end >= ?)) AND b0_.is_visible = 1 AND b0_.type = ? ORDER BY b0_.date_end ASC
Parameters:
[ "km0" "Peugeot" "e-208" "Peugeot" null "Elettrica" "Berlina" "%GL844PY%" "" "%VR3UHZKXZNT120411%" "" "%GB-N696440%" "" "2024-10-05 00:00:00" "2024-10-05 00:00:00" "custom" ] |
1.64 ms (1.45%) |
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 IS NULL OR v0_.is_deleted = 0)) AND v0_.brand = ? AND v0_.model = ? AND v0_.frame_type = ? AND v0_.archive = ? ORDER BY v0_.final_price ASC LIMIT 1
Parameters:
[ "Peugeot" "e-208" "Berlina" "nuovo" ] |
1.53 ms (1.36%) |
1 |
SELECT c0_.id AS id_0, c0_.site AS site_1, c0_.label AS label_2, c0_.link AS link_3, c0_.link_blank AS link_blank_4, c0_.visible AS visible_5, c0_.initial_open AS initial_open_6, c0_.column_position AS column_position_7, c0_.sort_index AS sort_index_8, c0_.parentCustomMenuItemId AS parentCustomMenuItemId_9 FROM custom_menu_item c0_ WHERE c0_.visible = 1 AND c0_.site = ? ORDER BY c0_.column_position ASC, c0_.sort_index ASC
Parameters:
[
"default"
]
|
1.52 ms (1.35%) |
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" "*" ] |
1.49 ms (1.33%) |
1 |
SELECT l0_.id AS id_0, l0_.voucher_counter_number AS voucher_counter_number_1, l0_.title AS title_2, l0_.subtitle AS subtitle_3, l0_.image AS image_4, l0_.sort_index AS sort_index_5, l0_.downloads AS downloads_6, l0_.discount AS discount_7, l0_.price_type AS price_type_8, l0_.email AS email_9, l0_.object_email AS object_email_10, l0_.body_email AS body_email_11, l0_.image_pdf AS image_pdf_12, l0_.text_pdf AS text_pdf_13, l0_.vins AS vins_14, l0_.plates AS plates_15, l0_.erp_ids AS erp_ids_16, l0_.landingId AS landingId_17 FROM landing_voucher l0_ INNER JOIN landing l1_ ON l0_.landingId = l1_.id LEFT JOIN landing_voucher_archive l2_ ON l0_.id = l2_.landingVoucherId LEFT JOIN landing_voucher_brand_model l3_ ON l0_.id = l3_.landingVoucherId WHERE (((l2_.archive = ? AND ((l3_.brand = ? AND l3_.model = ?) OR (l3_.brand = ? AND l3_.model IS NULL) OR (l3_.brand IS NULL AND l3_.model IS NULL))) OR (l0_.plates LIKE ? AND l0_.plates IS NOT NULL AND l0_.plates <> ?) OR (l0_.vins LIKE ? AND l0_.vins IS NOT NULL AND l0_.vins <> ?) OR (l0_.erp_ids LIKE ? AND l0_.erp_ids IS NOT NULL AND l0_.erp_ids <> ?))) AND ((l1_.date_start IS NULL OR l1_.date_start <= ?)) AND ((l1_.date_end IS NULL OR l1_.date_end >= ?)) AND (l1_.is_visible = 1) ORDER BY l1_.date_end ASC
Parameters:
[ "km0" "Peugeot" "e-208" "Peugeot" "%GL844PY%" "" "%VR3UHZKXZNT120411%" "" "%GB-N696440%" "" "2024-10-05 14:20:27" "2024-10-05 14:20:27" ] |
1.48 ms (1.31%) |
1 |
SELECT l0_.id AS id_0, l0_.site AS site_1, l0_.url AS url_2, l0_.is_visible AS is_visible_3, l0_.content AS content_4, l0_.content_secondary AS content_secondary_5, l0_.title AS title_6, l0_.seo_title AS seo_title_7, l0_.seo_description AS seo_description_8, l0_.pre_footer_title AS pre_footer_title_9, l0_.pre_footer_content AS pre_footer_content_10, l0_.date_create AS date_create_11, l0_.date_last_update AS date_last_update_12 FROM link_seo l0_ WHERE l0_.is_visible = 1 AND l0_.url = ? AND l0_.site = ?
Parameters:
[ "/v/gb-n696440-peugeot-208-5-porte-100kw-gt" "default" ] |
1.42 ms (1.26%) |
1 |
SELECT v0_.id AS id_0, v0_.sort_index AS sort_index_1, v0_.image_url AS image_url_2, v0_.image_url_small AS image_url_small_3, v0_.image_url_medium AS image_url_medium_4, v0_.image_url_thumb AS image_url_thumb_5, v0_.vehicleId AS vehicleId_6 FROM vehicle_image v0_ INNER JOIN vehicle v1_ ON v0_.vehicleId = v1_.id WHERE v1_.id IN (?, ?, ?, ?, ?) AND v0_.sort_index = 0 ORDER BY v0_.sort_index ASC
Parameters:
[ "7562" "12282" "13260" "17025" "16199" ] |
1.25 ms (1.11%) |
1 |
SELECT r0_.id AS id_0, r0_.rental_type AS rental_type_1, r0_.type AS type_2, r0_.is_visible AS is_visible_3, r0_.km AS km_4, r0_.fee AS fee_5, r0_.advance AS advance_6, r0_.duration AS duration_7, r0_.is_vat AS is_vat_8, r0_.promo_date_start AS promo_date_start_9, r0_.promo_date_end AS promo_date_end_10, r0_.promo_title AS promo_title_11, r0_.promo_fee AS promo_fee_12, r0_.is_promo AS is_promo_13, r0_.is_home AS is_home_14, r0_.date_created AS date_created_15, r0_.date_last_updated AS date_last_updated_16, r0_.legal_note AS legal_note_17, r0_.rentalVehicleId AS rentalVehicleId_18 FROM rental_vehicle_type r0_ LEFT JOIN rental_vehicle r1_ ON r0_.rentalVehicleId = r1_.id LEFT JOIN rental_vehicle_image r2_ ON r1_.id = r2_.rentalVehicleId LEFT JOIN wi_brand w3_ ON r1_.wiBrandId = w3_.id WHERE (r1_.is_visible = 1 AND w3_.label = ? AND r1_.model_stock = ?) AND r0_.is_visible = 1 AND r0_.type = ? ORDER BY r0_.fee DESC
Parameters:
[ "Peugeot" "e-208" "privati" ] |
1.08 ms (0.96%) |
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_.erp_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "GB-N713567" "GB-N711038" "GB-N714061" "GB-N711761" "GB-N702743" "GB-U680509" "BT-N109873" "GB-N722996" ] |
1.04 ms (0.92%) |
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:
[
"gb-n696440-peugeot-208-5-porte-100kw-gt"
]
|
0.70 ms (0.62%) |
1 |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.hide_title AS hide_title_2, b0_.show_your_style AS show_your_style_3, b0_.type AS type_4, b0_.custom_type AS custom_type_5, b0_.subtitle AS subtitle_6, b0_.content AS content_7, b0_.sort_index AS sort_index_8, b0_.link AS link_9, b0_.link_label AS link_label_10, b0_.link_blank AS link_blank_11, b0_.show_text_desktop AS show_text_desktop_12, b0_.show_text_mobile AS show_text_mobile_13, b0_.image AS image_14, b0_.image_listing AS image_listing_15, b0_.image_mobile AS image_mobile_16, b0_.image_listing_mobile AS image_listing_mobile_17, b0_.video AS video_18, b0_.is_visible AS is_visible_19, b0_.date_create AS date_create_20, b0_.date_last_update AS date_last_update_21, b0_.date_start AS date_start_22, b0_.date_end AS date_end_23, b0_.is_countdown AS is_countdown_24, b0_.countdown_end AS countdown_end_25, b0_.list_price AS list_price_26, b0_.promo_price AS promo_price_27, b0_.is_free AS is_free_28, b0_.request_type AS request_type_29, b0_.open_dedicated_form AS open_dedicated_form_30, b0_.in_listing AS in_listing_31, b0_.in_card AS in_card_32, b0_.card_color AS card_color_33, b0_.card_label AS card_label_34, b0_.vins AS vins_35, b0_.plates AS plates_36, b0_.erp_ids AS erp_ids_37, b0_.bannerPositionId AS bannerPositionId_38, b0_.brandId AS brandId_39 FROM banner b0_ WHERE b0_.type = ? AND b0_.in_card = 1 AND ((b0_.date_start IS NULL OR b0_.date_start <= ?)) AND ((b0_.date_end IS NULL OR b0_.date_end >= ?)) AND b0_.is_visible = 1 ORDER BY b0_.date_end ASC
Parameters:
[ "custom" "2024-10-05" "2024-10-05" ] |
0.48 ms (0.43%) |
1 |
SELECT b0_.id AS id_0, b0_.label AS label_1, b0_.disclaimer AS disclaimer_2, b0_.day AS day_3, b0_.deposit AS deposit_4, b0_.is_visible AS is_visible_5, b0_.plates AS plates_6, b0_.vins AS vins_7, b0_.erp_ids AS erp_ids_8, b0_.date_start AS date_start_9, b0_.date_end AS date_end_10, b0_.date_create AS date_create_11, b0_.date_last_update AS date_last_update_12 FROM booking b0_ WHERE ((b0_.date_start IS NULL OR b0_.date_start <= ?)) AND ((b0_.date_end IS NULL OR b0_.date_end >= ?)) AND b0_.is_visible = 1 ORDER BY b0_.date_end ASC
Parameters:
[ "2024-10-05" "2024-10-05" ] |
0.38 ms (0.34%) |
1 |
SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.idBooking AS idBooking_4 FROM booking_brand_model t0 WHERE t0.idBooking = ?
Parameters:
[
"c5287bfc-b6b6-45ed-9bcd-8c1d93a7b1cf"
]
|
0.33 ms (0.29%) |
1 |
SELECT t0.id AS id_1, t0.archive AS archive_2, t0.idBooking AS idBooking_3 FROM booking_archive t0 WHERE t0.idBooking = ?
Parameters:
[
"c5287bfc-b6b6-45ed-9bcd-8c1d93a7b1cf"
]
|
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.