Symfony Profiler

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

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 = '3dd1455e-35f9-458a-b8e1-585014597aa6';

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

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 = '3dd1455e-35f9-458a-b8e1-585014597aa6';

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

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 = '3dd1455e-35f9-458a-b8e1-585014597aa6';

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

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 = '5c54889d-09fb-43b6-b3a1-e2f4154e5ba2' ORDER BY t0.day_week ASC;

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

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 = '64421403-0fc4-4ab4-9f82-e01e9a120be9';

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

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 = '64421403-0fc4-4ab4-9f82-e01e9a120be9';

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 = 'rent.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 = '/veicolo-noleggio/privati/nlt/alfa-romeo-giulia-2-2-business-diesel/' OR r0_.source_path = '/veicolo-noleggio/privati/nlt/alfa-romeo-giulia-2-2-business-diesel')) OR (r0_.strict_trailing_slash = 1 AND (r0_.strict_url_query = 0 OR r0_.strict_url_query IS NULL) AND (r0_.source_path = '/veicolo-noleggio/privati/nlt/alfa-romeo-giulia-2-2-business-diesel')) OR ((r0_.strict_trailing_slash = 0 OR r0_.strict_trailing_slash IS NULL) AND r0_.strict_url_query = 1 AND (r0_.source_path = '/veicolo-noleggio/privati/nlt/alfa-romeo-giulia-2-2-business-diesel/?' OR r0_.source_path = '/veicolo-noleggio/privati/nlt/alfa-romeo-giulia-2-2-business-diesel?')) OR (r0_.strict_trailing_slash = 1 AND r0_.strict_url_query = 1 AND (r0_.source_path = '/veicolo-noleggio/privati/nlt/alfa-romeo-giulia-2-2-business-diesel?')));

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.is_visible AS is_visible_3,
  t0.sort_index AS sort_index_4,
  t0.type AS type_5,
  t0.rentalVehicleId AS rentalVehicleId_6
FROM
  rental_vehicle_image t0
WHERE
  t0.rentalVehicleId = ?
ORDER BY
  t0.sort_index ASC

SELECT t0.id AS id_1, t0.url AS url_2, t0.is_visible AS is_visible_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.rentalVehicleId AS rentalVehicleId_6 FROM rental_vehicle_image t0 WHERE t0.rentalVehicleId = 'b40011a0-f8d2-4589-a006-b66d9eb1b1d9' ORDER BY t0.sort_index ASC;

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

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_
  INNER JOIN rental_vehicle r1_ ON r0_.rentalVehicleId = r1_.id
WHERE
  r0_.is_visible = 1
  AND r1_.is_visible = 1
  AND r0_.type = ?
  AND r0_.rental_type = ?
  AND r1_.url_name = ?

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_ INNER JOIN rental_vehicle r1_ ON r0_.rentalVehicleId = r1_.id WHERE r0_.is_visible = 1 AND r1_.is_visible = 1 AND r0_.type = 'privati' AND r0_.rental_type = 'nlt' AND r1_.url_name = 'alfa-romeo-giulia-2-2-business-diesel';

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_
  LEFT JOIN location l1_ ON l0_.locationId = l1_.id
  LEFT JOIN location_brand_join l3_ ON l1_.id = l3_.locationId
  LEFT JOIN brand b2_ ON b2_.id = l3_.brandId
WHERE
  l1_.is_visible = 1
  AND l0_.is_visible = 1
  AND l0_.type = ?
ORDER BY
  l1_.sort_index ASC,
  l1_.name ASC

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_ LEFT JOIN location l1_ ON l0_.locationId = l1_.id LEFT JOIN location_brand_join l3_ ON l1_.id = l3_.locationId LEFT JOIN brand b2_ ON b2_.id = l3_.brandId WHERE l1_.is_visible = 1 AND l0_.is_visible = 1 AND l0_.type = 'vendita' ORDER BY l1_.sort_index ASC, l1_.name ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.eurotax_brand_id AS eurotax_brand_id_3,
  t0.infocar_brand_id AS infocar_brand_id_4,
  t0.is_auto AS is_auto_5,
  t0.is_moto AS is_moto_6,
  t0.is_vic AS is_vic_7,
  t0.brandId AS brandId_8
FROM
  wi_brand t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.eurotax_brand_id AS eurotax_brand_id_3, t0.infocar_brand_id AS infocar_brand_id_4, t0.is_auto AS is_auto_5, t0.is_moto AS is_moto_6, t0.is_vic AS is_vic_7, t0.brandId AS brandId_8 FROM wi_brand t0 WHERE t0.id = 4;

SELECT
  COUNT(*)
FROM
  rental_vehicle_rental_service_join t
WHERE
  t.rentalVehicleId = ?

SELECT COUNT(*) FROM rental_vehicle_rental_service_join t WHERE t.rentalVehicleId = 'b40011a0-f8d2-4589-a006-b66d9eb1b1d9';

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 = 'rent' 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 = '/veicolo-noleggio/privati/nlt/alfa-romeo-giulia-2-2-business-diesel' AND l0_.site = 'rent';

SELECT
  t0.id AS id_1,
  t0.eurotax_brand_code AS eurotax_brand_code_2,
  t0.eurotax_model_code AS eurotax_model_code_3,
  t0.eurotax_version_code AS eurotax_version_code_4,
  t0.vic AS vic_5,
  t0.eurotax_json AS eurotax_json_6,
  t0.model AS model_7,
  t0.model_stock AS model_stock_8,
  t0.version AS version_9,
  t0.frame_type AS frame_type_10,
  t0.traction AS traction_11,
  t0.displacement AS displacement_12,
  t0.doors_number AS doors_number_13,
  t0.kw AS kw_14,
  t0.hp AS hp_15,
  t0.emission AS emission_16,
  t0.consumption_avg AS consumption_avg_17,
  t0.young_driver AS young_driver_18,
  t0.content AS content_19,
  t0.optionals AS optionals_20,
  t0.fuel AS fuel_21,
  t0.gear_type AS gear_type_22,
  t0.url_name AS url_name_23,
  t0.seo_title AS seo_title_24,
  t0.seo_description AS seo_description_25,
  t0.is_visible AS is_visible_26,
  t0.sort_index AS sort_index_27,
  t0.image_home AS image_home_28,
  t0.date_create AS date_create_29,
  t0.date_last_update AS date_last_update_30,
  t0.brandId AS brandId_31,
  t0.wiBrandId AS wiBrandId_32,
  t0.rentalVehicleId AS rentalVehicleId_33,
  t0.companyId AS companyId_34
FROM
  rental_vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.eurotax_brand_code AS eurotax_brand_code_2, t0.eurotax_model_code AS eurotax_model_code_3, t0.eurotax_version_code AS eurotax_version_code_4, t0.vic AS vic_5, t0.eurotax_json AS eurotax_json_6, t0.model AS model_7, t0.model_stock AS model_stock_8, t0.version AS version_9, t0.frame_type AS frame_type_10, t0.traction AS traction_11, t0.displacement AS displacement_12, t0.doors_number AS doors_number_13, t0.kw AS kw_14, t0.hp AS hp_15, t0.emission AS emission_16, t0.consumption_avg AS consumption_avg_17, t0.young_driver AS young_driver_18, t0.content AS content_19, t0.optionals AS optionals_20, t0.fuel AS fuel_21, t0.gear_type AS gear_type_22, t0.url_name AS url_name_23, t0.seo_title AS seo_title_24, t0.seo_description AS seo_description_25, t0.is_visible AS is_visible_26, t0.sort_index AS sort_index_27, t0.image_home AS image_home_28, t0.date_create AS date_create_29, t0.date_last_update AS date_last_update_30, t0.brandId AS brandId_31, t0.wiBrandId AS wiBrandId_32, t0.rentalVehicleId AS rentalVehicleId_33, t0.companyId AS companyId_34 FROM rental_vehicle t0 WHERE t0.id = 'b40011a0-f8d2-4589-a006-b66d9eb1b1d9';