Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.etat AS etat_2,
  c0_.capacity AS capacity_3
FROM
  chambre c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.etat AS etat_2, c0_.capacity AS capacity_3 FROM chambre c0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.etat AS etat_2
FROM
  service s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.etat AS etat_2 FROM service s0_;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.etat AS etat_2
FROM
  arrangements a0_

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.etat AS etat_2 FROM arrangements a0_;

SELECT
  count(DISTINCT h0_.id) AS sclr_0
FROM
  hotel h0_

SELECT count(DISTINCT h0_.id) AS sclr_0 FROM hotel h0_;

SELECT
  DISTINCT h0_.id AS id_0
FROM
  hotel h0_
LIMIT
  5 OFFSET 10

SELECT DISTINCT h0_.id AS id_0 FROM hotel h0_ LIMIT 5 OFFSET 10;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.maps AS maps_2,
  h0_.star AS star_3,
  h0_.maxenfant AS maxenfant_4,
  h0_.minenfant AS minenfant_5,
  h0_.shortdesc AS shortdesc_6,
  h0_.visite AS visite_7,
  h0_.longdesc AS longdesc_8,
  h0_.etat AS etat_9,
  h0_.pays_id AS pays_id_10,
  h0_.ville_id AS ville_id_11
FROM
  hotel h0_
WHERE
  h0_.id IN (?, ?, ?, ?)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.maps AS maps_2, h0_.star AS star_3, h0_.maxenfant AS maxenfant_4, h0_.minenfant AS minenfant_5, h0_.shortdesc AS shortdesc_6, h0_.visite AS visite_7, h0_.longdesc AS longdesc_8, h0_.etat AS etat_9, h0_.pays_id AS pays_id_10, h0_.ville_id AS ville_id_11 FROM hotel h0_ WHERE h0_.id IN (290, 291, 292, 293);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hotel_id AS hotel_id_3
FROM
  imageshotels t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_id AS hotel_id_3 FROM imageshotels t0 WHERE t0.hotel_id = 290;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.adulte AS adulte_3,
  t0.enfant AS enfant_4,
  t0.age AS age_5,
  t0.personne AS personne_6,
  t0.bebe AS bebe_7,
  t0.hotel_id AS hotel_id_8,
  t0.chambre_id AS chambre_id_9
FROM
  hotelroom t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.age AS age_5, t0.personne AS personne_6, t0.bebe AS bebe_7, t0.hotel_id AS hotel_id_8, t0.chambre_id AS chambre_id_9 FROM hotelroom t0 WHERE t0.hotel_id = 290;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.price AS price_3,
  t0.marge AS marge_4,
  t0.etat AS etat_5,
  t0.hotelroom_id AS hotelroom_id_6,
  t0.hotelprice_id AS hotelprice_id_7
FROM
  priceroom t0
WHERE
  t0.hotelroom_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.price AS price_3, t0.marge AS marge_4, t0.etat AS etat_5, t0.hotelroom_id AS hotelroom_id_6, t0.hotelprice_id AS hotelprice_id_7 FROM priceroom t0 WHERE t0.hotelroom_id = 244;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.hotel_id AS hotel_id_3,
  t0.arrangement_id AS arrangement_id_4
FROM
  hotelarrangement t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.hotel_id AS hotel_id_3, t0.arrangement_id AS arrangement_id_4 FROM hotelarrangement t0 WHERE t0.hotel_id = 290;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.marge AS marge_3,
  t0.etat AS etat_4,
  t0.hotelarrangement_id AS hotelarrangement_id_5,
  t0.hotelprice_id AS hotelprice_id_6
FROM
  pricearrangement t0
WHERE
  t0.hotelarrangement_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.marge AS marge_3, t0.etat AS etat_4, t0.hotelarrangement_id AS hotelarrangement_id_5, t0.hotelprice_id AS hotelprice_id_6 FROM pricearrangement t0 WHERE t0.hotelarrangement_id = 147;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.etat AS etat_3,
  t0.pays_id AS pays_id_4
FROM
  villes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3, t0.pays_id AS pays_id_4 FROM villes t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.etat AS etat_3
FROM
  service t0
  INNER JOIN service_hotel ON t0.id = service_hotel.service_id
WHERE
  service_hotel.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM service t0 INNER JOIN service_hotel ON t0.id = service_hotel.service_id WHERE service_hotel.hotel_id = 290;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hotel_id AS hotel_id_3
FROM
  imageshotels t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_id AS hotel_id_3 FROM imageshotels t0 WHERE t0.hotel_id = 291;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.adulte AS adulte_3,
  t0.enfant AS enfant_4,
  t0.age AS age_5,
  t0.personne AS personne_6,
  t0.bebe AS bebe_7,
  t0.hotel_id AS hotel_id_8,
  t0.chambre_id AS chambre_id_9
FROM
  hotelroom t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.age AS age_5, t0.personne AS personne_6, t0.bebe AS bebe_7, t0.hotel_id AS hotel_id_8, t0.chambre_id AS chambre_id_9 FROM hotelroom t0 WHERE t0.hotel_id = 291;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.price AS price_3,
  t0.marge AS marge_4,
  t0.etat AS etat_5,
  t0.hotelroom_id AS hotelroom_id_6,
  t0.hotelprice_id AS hotelprice_id_7
FROM
  priceroom t0
WHERE
  t0.hotelroom_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.price AS price_3, t0.marge AS marge_4, t0.etat AS etat_5, t0.hotelroom_id AS hotelroom_id_6, t0.hotelprice_id AS hotelprice_id_7 FROM priceroom t0 WHERE t0.hotelroom_id = 214;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.hotel_id AS hotel_id_3,
  t0.arrangement_id AS arrangement_id_4
FROM
  hotelarrangement t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.hotel_id AS hotel_id_3, t0.arrangement_id AS arrangement_id_4 FROM hotelarrangement t0 WHERE t0.hotel_id = 291;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.marge AS marge_3,
  t0.etat AS etat_4,
  t0.hotelarrangement_id AS hotelarrangement_id_5,
  t0.hotelprice_id AS hotelprice_id_6
FROM
  pricearrangement t0
WHERE
  t0.hotelarrangement_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.marge AS marge_3, t0.etat AS etat_4, t0.hotelarrangement_id AS hotelarrangement_id_5, t0.hotelprice_id AS hotelprice_id_6 FROM pricearrangement t0 WHERE t0.hotelarrangement_id = 130;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.etat AS etat_3
FROM
  service t0
  INNER JOIN service_hotel ON t0.id = service_hotel.service_id
WHERE
  service_hotel.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM service t0 INNER JOIN service_hotel ON t0.id = service_hotel.service_id WHERE service_hotel.hotel_id = 291;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hotel_id AS hotel_id_3
FROM
  imageshotels t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_id AS hotel_id_3 FROM imageshotels t0 WHERE t0.hotel_id = 292;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.adulte AS adulte_3,
  t0.enfant AS enfant_4,
  t0.age AS age_5,
  t0.personne AS personne_6,
  t0.bebe AS bebe_7,
  t0.hotel_id AS hotel_id_8,
  t0.chambre_id AS chambre_id_9
FROM
  hotelroom t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.age AS age_5, t0.personne AS personne_6, t0.bebe AS bebe_7, t0.hotel_id AS hotel_id_8, t0.chambre_id AS chambre_id_9 FROM hotelroom t0 WHERE t0.hotel_id = 292;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.price AS price_3,
  t0.marge AS marge_4,
  t0.etat AS etat_5,
  t0.hotelroom_id AS hotelroom_id_6,
  t0.hotelprice_id AS hotelprice_id_7
FROM
  priceroom t0
WHERE
  t0.hotelroom_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.price AS price_3, t0.marge AS marge_4, t0.etat AS etat_5, t0.hotelroom_id AS hotelroom_id_6, t0.hotelprice_id AS hotelprice_id_7 FROM priceroom t0 WHERE t0.hotelroom_id = 242;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.hotel_id AS hotel_id_3,
  t0.arrangement_id AS arrangement_id_4
FROM
  hotelarrangement t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.hotel_id AS hotel_id_3, t0.arrangement_id AS arrangement_id_4 FROM hotelarrangement t0 WHERE t0.hotel_id = 292;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.marge AS marge_3,
  t0.etat AS etat_4,
  t0.hotelarrangement_id AS hotelarrangement_id_5,
  t0.hotelprice_id AS hotelprice_id_6
FROM
  pricearrangement t0
WHERE
  t0.hotelarrangement_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.marge AS marge_3, t0.etat AS etat_4, t0.hotelarrangement_id AS hotelarrangement_id_5, t0.hotelprice_id AS hotelprice_id_6 FROM pricearrangement t0 WHERE t0.hotelarrangement_id = 146;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.etat AS etat_3
FROM
  service t0
  INNER JOIN service_hotel ON t0.id = service_hotel.service_id
WHERE
  service_hotel.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM service t0 INNER JOIN service_hotel ON t0.id = service_hotel.service_id WHERE service_hotel.hotel_id = 292;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.hotel_id AS hotel_id_3
FROM
  imageshotels t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.hotel_id AS hotel_id_3 FROM imageshotels t0 WHERE t0.hotel_id = 293;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.adulte AS adulte_3,
  t0.enfant AS enfant_4,
  t0.age AS age_5,
  t0.personne AS personne_6,
  t0.bebe AS bebe_7,
  t0.hotel_id AS hotel_id_8,
  t0.chambre_id AS chambre_id_9
FROM
  hotelroom t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.adulte AS adulte_3, t0.enfant AS enfant_4, t0.age AS age_5, t0.personne AS personne_6, t0.bebe AS bebe_7, t0.hotel_id AS hotel_id_8, t0.chambre_id AS chambre_id_9 FROM hotelroom t0 WHERE t0.hotel_id = 293;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.price AS price_3,
  t0.marge AS marge_4,
  t0.etat AS etat_5,
  t0.hotelroom_id AS hotelroom_id_6,
  t0.hotelprice_id AS hotelprice_id_7
FROM
  priceroom t0
WHERE
  t0.hotelroom_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.price AS price_3, t0.marge AS marge_4, t0.etat AS etat_5, t0.hotelroom_id AS hotelroom_id_6, t0.hotelprice_id AS hotelprice_id_7 FROM priceroom t0 WHERE t0.hotelroom_id = 218;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.hotel_id AS hotel_id_3,
  t0.arrangement_id AS arrangement_id_4
FROM
  hotelarrangement t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.hotel_id AS hotel_id_3, t0.arrangement_id AS arrangement_id_4 FROM hotelarrangement t0 WHERE t0.hotel_id = 293;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.marge AS marge_3,
  t0.etat AS etat_4,
  t0.hotelarrangement_id AS hotelarrangement_id_5,
  t0.hotelprice_id AS hotelprice_id_6
FROM
  pricearrangement t0
WHERE
  t0.hotelarrangement_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.marge AS marge_3, t0.etat AS etat_4, t0.hotelarrangement_id AS hotelarrangement_id_5, t0.hotelprice_id AS hotelprice_id_6 FROM pricearrangement t0 WHERE t0.hotelarrangement_id = 133;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.etat AS etat_3
FROM
  service t0
  INNER JOIN service_hotel ON t0.id = service_hotel.service_id
WHERE
  service_hotel.hotel_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.etat AS etat_3 FROM service t0 INNER JOIN service_hotel ON t0.id = service_hotel.service_id WHERE service_hotel.hotel_id = 293;