Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 107
• Events
• Routing
• Cache
• Translation 119
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Blocks 0
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.inclusions AS inclusions_5, t0.exclusions AS exclusions_6, t0.departure_date AS departure_date_7, t0.returning_date AS returning_date_8, t0.length_in_days AS length_in_days_9, t0.other_dates AS other_dates_10, t0.country AS country_11, t0.country_description AS country_description_12, t0.price AS price_13, t0.price_starting_at AS price_starting_at_14, t0.price_label AS price_label_15, t0.specifications AS specifications_16, t0.conditions AS conditions_17, t0.comment AS comment_18, t0.active AS active_19, t0.created_uid AS created_uid_20, t0.updated_uid AS updated_uid_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.main_image_id AS main_image_id_24, t0.gallery_id AS gallery_id_25 FROM tour t0 WHERE t0.id = ?

[
  "86"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.inclusions AS inclusions_5,
  t0.exclusions AS exclusions_6,
  t0.departure_date AS departure_date_7,
  t0.returning_date AS returning_date_8,
  t0.length_in_days AS length_in_days_9,
  t0.other_dates AS other_dates_10,
  t0.country AS country_11,
  t0.country_description AS country_description_12,
  t0.price AS price_13,
  t0.price_starting_at AS price_starting_at_14,
  t0.price_label AS price_label_15,
  t0.specifications AS specifications_16,
  t0.conditions AS conditions_17,
  t0.comment AS comment_18,
  t0.active AS active_19,
  t0.created_uid AS created_uid_20,
  t0.updated_uid AS updated_uid_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.main_image_id AS main_image_id_24,
  t0.gallery_id AS gallery_id_25
FROM
  tour t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.inclusions AS inclusions_5, t0.exclusions AS exclusions_6, t0.departure_date AS departure_date_7, t0.returning_date AS returning_date_8, t0.length_in_days AS length_in_days_9, t0.other_dates AS other_dates_10, t0.country AS country_11, t0.country_description AS country_description_12, t0.price AS price_13, t0.price_starting_at AS price_starting_at_14, t0.price_label AS price_label_15, t0.specifications AS specifications_16, t0.conditions AS conditions_17, t0.comment AS comment_18, t0.active AS active_19, t0.created_uid AS created_uid_20, t0.updated_uid AS updated_uid_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.main_image_id AS main_image_id_24, t0.gallery_id AS gallery_id_25 FROM tour t0 WHERE t0.id = '86';

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.address AS address_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_id AS image_id_9 FROM agency t0 ORDER BY t0.position ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.phone AS phone_4,
  t0.address AS address_5,
  t0.position AS position_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.image_id AS image_id_9
FROM
  agency t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.phone AS phone_4, t0.address AS address_5, t0.position AS position_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.image_id AS image_id_9 FROM agency t0 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM page t0 WHERE t0.name = ? LIMIT 1

[
  "home"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.meta_description AS meta_description_3,
  t0.title AS title_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  page t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.meta_description AS meta_description_3, t0.title AS title_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM page t0 WHERE t0.name = 'home' LIMIT 1;

SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.resume AS resume_2, s0_.description AS description_3, s0_.eventStart AS eventStart_4, s0_.eventEnd AS eventEnd_5, s0_.sale_start AS sale_start_6, s0_.sale_end AS sale_end_7, s0_.active AS active_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.event_thumbnail_id AS event_thumbnail_id_11, s0_.event_banner_id AS event_banner_id_12 FROM special_event s0_ WHERE s0_.sale_start <= ? AND ? <= s0_.sale_end AND s0_.active = ?

[
  "2026-07-27"
  "2026-07-27"
  1
]

SELECT
  s0_.id AS id_0,
  s0_.label AS label_1,
  s0_.resume AS resume_2,
  s0_.description AS description_3,
  s0_.eventStart AS eventStart_4,
  s0_.eventEnd AS eventEnd_5,
  s0_.sale_start AS sale_start_6,
  s0_.sale_end AS sale_end_7,
  s0_.active AS active_8,
  s0_.created_at AS created_at_9,
  s0_.updated_at AS updated_at_10,
  s0_.event_thumbnail_id AS event_thumbnail_id_11,
  s0_.event_banner_id AS event_banner_id_12
FROM
  special_event s0_
WHERE
  s0_.sale_start <= ?
  AND ? <= s0_.sale_end
  AND s0_.active = ?

SELECT s0_.id AS id_0, s0_.label AS label_1, s0_.resume AS resume_2, s0_.description AS description_3, s0_.eventStart AS eventStart_4, s0_.eventEnd AS eventEnd_5, s0_.sale_start AS sale_start_6, s0_.sale_end AS sale_end_7, s0_.active AS active_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10, s0_.event_thumbnail_id AS event_thumbnail_id_11, s0_.event_banner_id AS event_banner_id_12 FROM special_event s0_ WHERE s0_.sale_start <= '2026-07-27' AND '2026-07-27' <= s0_.sale_end AND s0_.active = 1;

SELECT c0_.id AS id_0, c0_.iso_code AS iso_code_1, c0_.name AS name_2, c0_.country AS country_3, c0_.active AS active_4, c0_.display_home AS display_home_5, c0_.sort AS sort_6, c0_.city_id AS city_id_7, c0_.zone_id AS zone_id_8, c0_.main_image_id AS main_image_id_9, c0_.gallery_id AS gallery_id_10 FROM country c0_ INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id WHERE c0_.active = 1 AND c0_.display_home = 1 ORDER BY c0_.sort ASC, c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.iso_code AS iso_code_1,
  c0_.name AS name_2,
  c0_.country AS country_3,
  c0_.active AS active_4,
  c0_.display_home AS display_home_5,
  c0_.sort AS sort_6,
  c0_.city_id AS city_id_7,
  c0_.zone_id AS zone_id_8,
  c0_.main_image_id AS main_image_id_9,
  c0_.gallery_id AS gallery_id_10
FROM
  country c0_
  INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id
WHERE
  c0_.active = 1
  AND c0_.display_home = 1
ORDER BY
  c0_.sort ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.iso_code AS iso_code_1, c0_.name AS name_2, c0_.country AS country_3, c0_.active AS active_4, c0_.display_home AS display_home_5, c0_.sort AS sort_6, c0_.city_id AS city_id_7, c0_.zone_id AS zone_id_8, c0_.main_image_id AS main_image_id_9, c0_.gallery_id AS gallery_id_10 FROM country c0_ INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id WHERE c0_.active = 1 AND c0_.display_home = 1 ORDER BY c0_.sort ASC, c0_.name ASC;