Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  area t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM area t0;

SELECT
  a0_.id AS id_0,
  a0_.available_from AS available_from_1,
  a0_.available_until AS available_until_2,
  a0_.location AS location_3,
  a0_.notes AS notes_4,
  a0_.is_active AS is_active_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.profile_id AS profile_id_8
FROM
  available_now a0_
  INNER JOIN profile p1_ ON a0_.profile_id = p1_.id
WHERE
  a0_.is_active = 1
  AND a0_.available_from <= ?
  AND a0_.available_until >= ?
  AND p1_.status = ?
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.available_from AS available_from_1, a0_.available_until AS available_until_2, a0_.location AS location_3, a0_.notes AS notes_4, a0_.is_active AS is_active_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.profile_id AS profile_id_8 FROM available_now a0_ INNER JOIN profile p1_ ON a0_.profile_id = p1_.id WHERE a0_.is_active = 1 AND a0_.available_from <= '2026-06-03 09:10:19' AND a0_.available_until >= '2026-06-03 09:10:19' AND p1_.status = 10 ORDER BY a0_.created_at DESC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4
FROM
  area a0_
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4
FROM
  service s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.position AS position_2,
  b0_.image_path AS image_path_3,
  b0_.link_url AS link_url_4,
  b0_.start_date AS start_date_5,
  b0_.end_date AS end_date_6,
  b0_.is_active AS is_active_7,
  b0_.click_count AS click_count_8,
  b0_.view_count AS view_count_9,
  b0_.sort_order AS sort_order_10,
  b0_.created_at AS created_at_11
FROM
  banner b0_
WHERE
  b0_.is_active = 1
  AND (
    (
      b0_.start_date IS NULL
      OR b0_.start_date <= ?
    )
  )
  AND (
    (
      b0_.end_date IS NULL
      OR b0_.end_date >= ?
    )
  )
  AND b0_.position = ?
ORDER BY
  b0_.sort_order ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= 1780470619)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780470619)) AND b0_.position = 'header' ORDER BY b0_.sort_order ASC;

SELECT
  a0_.id AS id_0,
  a0_.page_type AS page_type_1,
  a0_.slot_name AS slot_name_2,
  a0_.display_name AS display_name_3,
  a0_.rotation_mode AS rotation_mode_4,
  a0_.allowed_formats AS allowed_formats_5,
  a0_.dimensions AS dimensions_6,
  a0_.is_active AS is_active_7,
  a0_.created_at AS created_at_8
FROM
  ad_slot a0_
WHERE
  a0_.page_type = ?
  AND a0_.slot_name = ?
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = 'area_list' AND a0_.slot_name = 'area_list-top-landscape' AND a0_.is_active = 1;

SELECT
  a0_.id AS id_0,
  a0_.priority AS priority_1,
  a0_.start_at AS start_at_2,
  a0_.end_at AS end_at_3,
  a0_.is_active AS is_active_4,
  a0_.created_at AS created_at_5,
  a0_.advert_id AS advert_id_6,
  a0_.ad_slot_id AS ad_slot_id_7
FROM
  ad_schedule a0_
  INNER JOIN advert a1_ ON a0_.advert_id = a1_.id
  INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id
WHERE
  a2_.page_type = ?
  AND a2_.slot_name = ?
  AND a2_.is_active = 1
  AND a0_.is_active = 1
  AND a1_.is_active = 1
  AND (
    (
      a0_.start_at IS NULL
      OR a0_.start_at <= ?
    )
  )
  AND (
    (
      a0_.end_at IS NULL
      OR a0_.end_at >= ?
    )
  )
ORDER BY
  a0_.priority DESC,
  a0_.created_at ASC

SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = 'area_list' AND a2_.slot_name = 'area_list-top-landscape' AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= '2026-06-03 09:10:19')) AND ((a0_.end_at IS NULL OR a0_.end_at >= '2026-06-03 09:10:19')) ORDER BY a0_.priority DESC, a0_.created_at ASC;

SELECT
  a0_.id AS id_0,
  a0_.page_type AS page_type_1,
  a0_.slot_name AS slot_name_2,
  a0_.display_name AS display_name_3,
  a0_.rotation_mode AS rotation_mode_4,
  a0_.allowed_formats AS allowed_formats_5,
  a0_.dimensions AS dimensions_6,
  a0_.is_active AS is_active_7,
  a0_.created_at AS created_at_8
FROM
  ad_slot a0_
WHERE
  a0_.page_type = ?
  AND a0_.slot_name = ?
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = 'area_list' AND a0_.slot_name = 'area_list-top-portrait' AND a0_.is_active = 1;

SELECT
  a0_.id AS id_0,
  a0_.priority AS priority_1,
  a0_.start_at AS start_at_2,
  a0_.end_at AS end_at_3,
  a0_.is_active AS is_active_4,
  a0_.created_at AS created_at_5,
  a0_.advert_id AS advert_id_6,
  a0_.ad_slot_id AS ad_slot_id_7
FROM
  ad_schedule a0_
  INNER JOIN advert a1_ ON a0_.advert_id = a1_.id
  INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id
WHERE
  a2_.page_type = ?
  AND a2_.slot_name = ?
  AND a2_.is_active = 1
  AND a0_.is_active = 1
  AND a1_.is_active = 1
  AND (
    (
      a0_.start_at IS NULL
      OR a0_.start_at <= ?
    )
  )
  AND (
    (
      a0_.end_at IS NULL
      OR a0_.end_at >= ?
    )
  )
ORDER BY
  a0_.priority DESC,
  a0_.created_at ASC

SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = 'area_list' AND a2_.slot_name = 'area_list-top-portrait' AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= '2026-06-03 09:10:19')) AND ((a0_.end_at IS NULL OR a0_.end_at >= '2026-06-03 09:10:19')) ORDER BY a0_.priority DESC, a0_.created_at ASC;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 1;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 2;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 3;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 4;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 5;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 6;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 7;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 8;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 9;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 10;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 11;

SELECT
  t0.is_primary AS is_primary_1,
  t0.travel_available AS travel_available_2,
  t0.created_at AS created_at_3,
  t0.profile_id AS profile_id_4,
  t0.area_id AS area_id_5
FROM
  profile_area t0
WHERE
  t0.area_id = ?

SELECT t0.is_primary AS is_primary_1, t0.travel_available AS travel_available_2, t0.created_at AS created_at_3, t0.profile_id AS profile_id_4, t0.area_id AS area_id_5 FROM profile_area t0 WHERE t0.area_id = 12;