Symfony Profiler

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 = ?)
    )
  )

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 = 'gruppobossoni.wi-staging.it' 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 = '/ricerca-veicoli/?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto' OR r0_.source_path = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/ricerca-veicoli/?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto' OR r0_.source_path = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto')));

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 = ?)
    )
  )

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 = 'gruppobossoni.wi-staging.it' 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 = '/ricerca-veicoli/' OR r0_.source_path = '/ricerca-veicoli')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/ricerca-veicoli')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/ricerca-veicoli/?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto' OR r0_.source_path = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto')));

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 = ?

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 = 'gruppobossoni.wi-staging.it' AND r0_.source_path = '*';

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_listing = 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

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 = 'custom' AND b0_.in_listing = 1 AND ((b0_.date_start IS NULL OR b0_.date_start <= '2024-09-28')) AND ((b0_.date_end IS NULL OR b0_.date_end >= '2024-09-28')) AND b0_.is_visible = 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 = ?

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 = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto' AND l0_.site = 'default';

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 = ?

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 = '/ricerca-veicoli?archives=nuovo&brand=volkswagen&model=id.3&groupTypes=auto' AND l0_.site = 'default';

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

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 = 'default' ORDER BY c0_.column_position ASC, c0_.sort_index ASC;