Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.rooms AS rooms_3, t0.cover AS cover_4, t0.calendar_token AS calendar_token_5, t0.agency_note AS agency_note_6, t0.owner_id AS owner_id_7, t0.district_id AS district_id_8, t0.manager_id AS manager_id_9 FROM villa t0 WHERE t0.calendar_token = ? LIMIT 1

[
  "uKFditUo9KW8vC7uyX2gZuyVsmKj1RMwX9vUYa5O"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rooms AS rooms_3,
  t0.cover AS cover_4,
  t0.calendar_token AS calendar_token_5,
  t0.agency_note AS agency_note_6,
  t0.owner_id AS owner_id_7,
  t0.district_id AS district_id_8,
  t0.manager_id AS manager_id_9
FROM
  villa t0
WHERE
  t0.calendar_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.rooms AS rooms_3, t0.cover AS cover_4, t0.calendar_token AS calendar_token_5, t0.agency_note AS agency_note_6, t0.owner_id AS owner_id_7, t0.district_id AS district_id_8, t0.manager_id AS manager_id_9 FROM villa t0 WHERE t0.calendar_token = 'uKFditUo9KW8vC7uyX2gZuyVsmKj1RMwX9vUYa5O' LIMIT 1;

SELECT s0_.id AS id_0, s0_.start AS start_1, s0_.end AS end_2, s0_.arrival AS arrival_3, s0_.departure AS departure_4, s0_.status AS status_5, s0_.agency_request AS agency_request_6, s0_.cancel AS cancel_7, s0_.note AS note_8, s0_.rooms AS rooms_9, s0_.price_per_week AS price_per_week_10, s0_.price_per_day AS price_per_day_11, s0_.amount AS amount_12, s0_.currency AS currency_13, s0_.comission AS comission_14, s0_.villa_id AS villa_id_15, s0_.agency_id AS agency_id_16 FROM stay s0_ LEFT JOIN villa v1_ ON s0_.villa_id = v1_.id WHERE v1_.id IN (?) AND ((s0_.start <= ? AND s0_.end >= ?) OR (s0_.start >= ? AND s0_.end <= ?) OR (s0_.start <= ? AND s0_.end >= ?) OR (s0_.start <= ? AND s0_.end >= ?)) ORDER BY s0_.start ASC

[
  2
  "2045-06-01 00:00"
  "2045-06-01 00:00"
  "2045-06-01 00:00"
  "2045-06-30 23:59"
  "2045-06-30 23:59"
  "2045-06-30 23:59"
  "2045-06-01 00:00"
  "2045-06-30 23:59"
]

SELECT
  s0_.id AS id_0,
  s0_.start AS start_1,
  s0_.end AS end_2,
  s0_.arrival AS arrival_3,
  s0_.departure AS departure_4,
  s0_.status AS status_5,
  s0_.agency_request AS agency_request_6,
  s0_.cancel AS cancel_7,
  s0_.note AS note_8,
  s0_.rooms AS rooms_9,
  s0_.price_per_week AS price_per_week_10,
  s0_.price_per_day AS price_per_day_11,
  s0_.amount AS amount_12,
  s0_.currency AS currency_13,
  s0_.comission AS comission_14,
  s0_.villa_id AS villa_id_15,
  s0_.agency_id AS agency_id_16
FROM
  stay s0_
  LEFT JOIN villa v1_ ON s0_.villa_id = v1_.id
WHERE
  v1_.id IN (?)
  AND (
    (
      s0_.start <= ?
      AND s0_.end >= ?
    )
    OR (
      s0_.start >= ?
      AND s0_.end <= ?
    )
    OR (
      s0_.start <= ?
      AND s0_.end >= ?
    )
    OR (
      s0_.start <= ?
      AND s0_.end >= ?
    )
  )
ORDER BY
  s0_.start ASC

SELECT s0_.id AS id_0, s0_.start AS start_1, s0_.end AS end_2, s0_.arrival AS arrival_3, s0_.departure AS departure_4, s0_.status AS status_5, s0_.agency_request AS agency_request_6, s0_.cancel AS cancel_7, s0_.note AS note_8, s0_.rooms AS rooms_9, s0_.price_per_week AS price_per_week_10, s0_.price_per_day AS price_per_day_11, s0_.amount AS amount_12, s0_.currency AS currency_13, s0_.comission AS comission_14, s0_.villa_id AS villa_id_15, s0_.agency_id AS agency_id_16 FROM stay s0_ LEFT JOIN villa v1_ ON s0_.villa_id = v1_.id WHERE v1_.id IN (2) AND ((s0_.start <= '2045-06-01 00:00' AND s0_.end >= '2045-06-01 00:00') OR (s0_.start >= '2045-06-01 00:00' AND s0_.end <= '2045-06-30 23:59') OR (s0_.start <= '2045-06-30 23:59' AND s0_.end >= '2045-06-30 23:59') OR (s0_.start <= '2045-06-01 00:00' AND s0_.end >= '2045-06-30 23:59')) ORDER BY s0_.start ASC;