Symfony Profiler

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.id AS id_1
FROM
  bedroom_chamber b0_
  LEFT JOIN bedroom b1_ ON b0_.bedroom_id = b1_.id
  LEFT JOIN type_bedroom t2_ ON b1_.type_bedroom_id = t2_.id
  LEFT JOIN bedroom_translation b3_ ON b1_.id = b3_.bedroom_id
ORDER BY
  b0_.id DESC
LIMIT
  30

SELECT DISTINCT b0_.id AS id_0, b0_.id AS id_1 FROM bedroom_chamber b0_ LEFT JOIN bedroom b1_ ON b0_.bedroom_id = b1_.id LEFT JOIN type_bedroom t2_ ON b1_.type_bedroom_id = t2_.id LEFT JOIN bedroom_translation b3_ ON b1_.id = b3_.bedroom_id ORDER BY b0_.id DESC LIMIT 30;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.status AS status_2,
  b0_.is_occuped AS is_occuped_3,
  b0_.order_number AS order_number_4,
  b0_.created_at AS created_at_5,
  b1_.id AS id_6,
  b1_.created_at AS created_at_7,
  b1_.updated_at AS updated_at_8,
  b1_.number AS number_9,
  b1_.description AS description_10,
  b1_.with_breakfast AS with_breakfast_11,
  b1_.on_comand AS on_comand_12,
  b1_.subtitle AS subtitle_13,
  t2_.id AS id_14,
  t2_.name AS name_15,
  t2_.created_at AS created_at_16,
  t2_.base_price AS base_price_17,
  t2_.locale AS locale_18,
  b3_.id AS id_19,
  b3_.locale AS locale_20,
  b3_.description AS description_21,
  b3_.number AS number_22,
  b3_.subtitle AS subtitle_23,
  b0_.bedroom_id AS bedroom_id_24,
  b1_.site_id AS site_id_25,
  b1_.type_bedroom_id AS type_bedroom_id_26,
  b3_.bedroom_id AS bedroom_id_27
FROM
  bedroom_chamber b0_
  LEFT JOIN bedroom b1_ ON b0_.bedroom_id = b1_.id
  LEFT JOIN type_bedroom t2_ ON b1_.type_bedroom_id = t2_.id
  LEFT JOIN bedroom_translation b3_ ON b1_.id = b3_.bedroom_id
WHERE
  b0_.id IN (?)
ORDER BY
  b0_.id DESC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.status AS status_2, b0_.is_occuped AS is_occuped_3, b0_.order_number AS order_number_4, b0_.created_at AS created_at_5, b1_.id AS id_6, b1_.created_at AS created_at_7, b1_.updated_at AS updated_at_8, b1_.number AS number_9, b1_.description AS description_10, b1_.with_breakfast AS with_breakfast_11, b1_.on_comand AS on_comand_12, b1_.subtitle AS subtitle_13, t2_.id AS id_14, t2_.name AS name_15, t2_.created_at AS created_at_16, t2_.base_price AS base_price_17, t2_.locale AS locale_18, b3_.id AS id_19, b3_.locale AS locale_20, b3_.description AS description_21, b3_.number AS number_22, b3_.subtitle AS subtitle_23, b0_.bedroom_id AS bedroom_id_24, b1_.site_id AS site_id_25, b1_.type_bedroom_id AS type_bedroom_id_26, b3_.bedroom_id AS bedroom_id_27 FROM bedroom_chamber b0_ LEFT JOIN bedroom b1_ ON b0_.bedroom_id = b1_.id LEFT JOIN type_bedroom t2_ ON b1_.type_bedroom_id = t2_.id LEFT JOIN bedroom_translation b3_ ON b1_.id = b3_.bedroom_id WHERE b0_.id IN (40, 39, 38, 37, 36, 35, 34, 28, 26, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4) ORDER BY b0_.id DESC;

SELECT
  count(DISTINCT b0_.id) AS sclr_0
FROM
  bedroom_chamber b0_
  LEFT JOIN bedroom b1_ ON b0_.bedroom_id = b1_.id
  LEFT JOIN type_bedroom t2_ ON b1_.type_bedroom_id = t2_.id
  LEFT JOIN bedroom_translation b3_ ON b1_.id = b3_.bedroom_id

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM bedroom_chamber b0_ LEFT JOIN bedroom b1_ ON b0_.bedroom_id = b1_.id LEFT JOIN type_bedroom t2_ ON b1_.type_bedroom_id = t2_.id LEFT JOIN bedroom_translation b3_ ON b1_.id = b3_.bedroom_id;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.username AS username_4,
  t0.roles AS roles_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.created_at AS created_at_9
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.username AS username_4, t0.roles AS roles_5, t0.phone AS phone_6, t0.email AS email_7, t0.password AS password_8, t0.created_at AS created_at_9 FROM user t0 WHERE t0.username = 'figuc' LIMIT 1;