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 = '/car-configurator/?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04' OR r0_.source_path = '/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/car-configurator/?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04' OR r0_.source_path = '/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04')));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.codice_motornet AS codice_motornet_3,
  t0.codice_eurotax AS codice_eurotax_4,
  t0.nome AS nome_5,
  t0.deleted AS deleted_6,
  t0.dettaglio AS dettaglio_7,
  t0.accessori AS accessori_8,
  t0.last_update AS last_update_9,
  t0.carConfiguratorModelId AS carConfiguratorModelId_10
FROM
  car_configurator_version t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.codice_motornet AS codice_motornet_3, t0.codice_eurotax AS codice_eurotax_4, t0.nome AS nome_5, t0.deleted AS deleted_6, t0.dettaglio AS dettaglio_7, t0.accessori AS accessori_8, t0.last_update AS last_update_9, t0.carConfiguratorModelId AS carConfiguratorModelId_10 FROM car_configurator_version t0 WHERE t0.id = 'fa21cd23-9beb-4dfe-aa18-10ac3bccee04';

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
  t0.id AS id_1,
  t0.codice_marca AS codice_marca_2,
  t0.codice_gamma_modello AS codice_gamma_modello_3,
  t0.descrizione_gamma_modello AS descrizione_gamma_modello_4,
  t0.url_name AS url_name_5,
  t0.sort_index AS sort_index_6,
  t0.active AS active_7,
  t0.visible AS visible_8,
  t0.dettaglio AS dettaglio_9,
  t0.last_update AS last_update_10,
  t0.price_from AS price_from_11,
  t0.versions_by_fuel AS versions_by_fuel_12,
  t0.from_to_params AS from_to_params_13,
  t0.image AS image_14
FROM
  car_configurator_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codice_marca AS codice_marca_2, t0.codice_gamma_modello AS codice_gamma_modello_3, t0.descrizione_gamma_modello AS descrizione_gamma_modello_4, t0.url_name AS url_name_5, t0.sort_index AS sort_index_6, t0.active AS active_7, t0.visible AS visible_8, t0.dettaglio AS dettaglio_9, t0.last_update AS last_update_10, t0.price_from AS price_from_11, t0.versions_by_fuel AS versions_by_fuel_12, t0.from_to_params AS from_to_params_13, t0.image AS image_14 FROM car_configurator_model t0 WHERE t0.id = 'f9ef8731-c0cd-4a10-b130-6cbcbd208e97';

SELECT
  i0_.id AS id_0,
  i0_.tag_type AS tag_type_1,
  i0_.tag_reference AS tag_reference_2,
  i0_.label AS label_3
FROM
  imgbundle_image_tag i0_
WHERE
  i0_.tag_type = ?
  AND i0_.tag_reference = ?
ORDER BY
  i0_.label ASC

SELECT i0_.id AS id_0, i0_.tag_type AS tag_type_1, i0_.tag_reference AS tag_reference_2, i0_.label AS label_3 FROM imgbundle_image_tag i0_ WHERE i0_.tag_type = 'carConfiguratorModelList' AND i0_.tag_reference = 'ed5fe47152117a2c7ef3685dc1f72c2ea4b7b0b3' ORDER BY i0_.label 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 = ?
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;

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 = '/car-configurator?version=fa21cd23-9beb-4dfe-aa18-10ac3bccee04' AND l0_.site = 'default';

SELECT
  b0_.code AS code_0
FROM
  brand b0_
WHERE
  b0_.eurotax_code = ?
  AND (
    b0_.is_vic IS NULL
    OR b0_.is_vic = 0
  )

SELECT b0_.code AS code_0 FROM brand b0_ WHERE b0_.eurotax_code = 'AUD' AND (b0_.is_vic IS NULL OR b0_.is_vic = 0);