Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.etat AS etat_2
FROM
  banniere b0_
WHERE
  b0_.etat = 1

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.etat AS etat_2 FROM banniere b0_ WHERE b0_.etat = 1;

SELECT
  s0_.id AS id_0,
  s0_.libelle AS libelle_1,
  s0_.dcr AS dcr_2,
  s0_.etat AS etat_3,
  s0_.titre AS titre_4,
  s0_.dureesej AS dureesej_5,
  s0_.prix AS prix_6,
  s0_.pindex AS pindex_7,
  s0_.villed AS villed_8,
  s0_.voyagecart AS voyagecart_9,
  s0_.villea AS villea_10,
  s0_.hotel AS hotel_11,
  s0_.nbreetoile AS nbreetoile_12,
  s0_.nbreplaces AS nbreplaces_13,
  s0_.description AS description_14,
  s0_.prixavance AS prixavance_15,
  s0_.ageminenf AS ageminenf_16,
  s0_.agemaxenf AS agemaxenf_17,
  s0_.ageminbb AS ageminbb_18,
  s0_.agemaxbb AS agemaxbb_19,
  s0_.marge AS marge_20,
  s0_.maps AS maps_21,
  s0_.dated AS dated_22,
  s0_.datef AS datef_23,
  s0_.serviceinclus AS serviceinclus_24,
  s0_.servicenoninclus AS servicenoninclus_25,
  s0_.latest AS latest_26,
  s0_.themes_id AS themes_id_27,
  s0_.arrangement_id AS arrangement_id_28
FROM
  sejour s0_
WHERE
  s0_.etat = 1
  AND s0_.latest = 1

SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.dcr AS dcr_2, s0_.etat AS etat_3, s0_.titre AS titre_4, s0_.dureesej AS dureesej_5, s0_.prix AS prix_6, s0_.pindex AS pindex_7, s0_.villed AS villed_8, s0_.voyagecart AS voyagecart_9, s0_.villea AS villea_10, s0_.hotel AS hotel_11, s0_.nbreetoile AS nbreetoile_12, s0_.nbreplaces AS nbreplaces_13, s0_.description AS description_14, s0_.prixavance AS prixavance_15, s0_.ageminenf AS ageminenf_16, s0_.agemaxenf AS agemaxenf_17, s0_.ageminbb AS ageminbb_18, s0_.agemaxbb AS agemaxbb_19, s0_.marge AS marge_20, s0_.maps AS maps_21, s0_.dated AS dated_22, s0_.datef AS datef_23, s0_.serviceinclus AS serviceinclus_24, s0_.servicenoninclus AS servicenoninclus_25, s0_.latest AS latest_26, s0_.themes_id AS themes_id_27, s0_.arrangement_id AS arrangement_id_28 FROM sejour s0_ WHERE s0_.etat = 1 AND s0_.latest = 1;

SELECT
  c0_.id AS id_0,
  c0_.dated AS dated_1,
  c0_.datef AS datef_2,
  c0_.libelle AS libelle_3,
  c0_.type AS type_4,
  c0_.dcr AS dcr_5,
  c0_.ville AS ville_6,
  c0_.nbre_etoiles AS nbre_etoiles_7,
  c0_.prix AS prix_8,
  c0_.prixavance AS prixavance_9,
  c0_.marge AS marge_10,
  c0_.apartir AS apartir_11,
  c0_.etat AS etat_12,
  c0_.pindex AS pindex_13,
  c0_.nbrejour AS nbrejour_14,
  c0_.description AS description_15,
  c0_.ageminenf AS ageminenf_16,
  c0_.ageminbb AS ageminbb_17,
  c0_.agemaxenf AS agemaxenf_18,
  c0_.agemaxbb AS agemaxbb_19,
  c0_.maps AS maps_20,
  c0_.serviceinclus AS serviceinclus_21,
  c0_.servicenoninclus AS servicenoninclus_22
FROM
  circuit c0_
WHERE
  c0_.etat = 1

SELECT c0_.id AS id_0, c0_.dated AS dated_1, c0_.datef AS datef_2, c0_.libelle AS libelle_3, c0_.type AS type_4, c0_.dcr AS dcr_5, c0_.ville AS ville_6, c0_.nbre_etoiles AS nbre_etoiles_7, c0_.prix AS prix_8, c0_.prixavance AS prixavance_9, c0_.marge AS marge_10, c0_.apartir AS apartir_11, c0_.etat AS etat_12, c0_.pindex AS pindex_13, c0_.nbrejour AS nbrejour_14, c0_.description AS description_15, c0_.ageminenf AS ageminenf_16, c0_.ageminbb AS ageminbb_17, c0_.agemaxenf AS agemaxenf_18, c0_.agemaxbb AS agemaxbb_19, c0_.maps AS maps_20, c0_.serviceinclus AS serviceinclus_21, c0_.servicenoninclus AS servicenoninclus_22 FROM circuit c0_ WHERE c0_.etat = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.etat AS etat_2
FROM
  croisiere c0_
WHERE
  c0_.etat = 1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.etat AS etat_2 FROM croisiere c0_ WHERE c0_.etat = 1;

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_.etat = 1

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_.etat = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.bannieres_id AS bannieres_id_3
FROM
  imagesbannieres t0
WHERE
  t0.bannieres_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.bannieres_id AS bannieres_id_3 FROM imagesbannieres t0 WHERE t0.bannieres_id = 21;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.bannieres_id AS bannieres_id_3
FROM
  imagesbannieres t0
WHERE
  t0.bannieres_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.bannieres_id AS bannieres_id_3 FROM imagesbannieres t0 WHERE t0.bannieres_id = 22;

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 = 280;

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 = 280;

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 = 235;

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 = 280;

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 = 142;

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 = 281;

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 = 281;

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 = 238;

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 = 281;

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 = 144;

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 = 282;

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 = 282;

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 = 224;

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 = 282;

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 = 137;

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 = 283;

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 = 283;

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 = 206;

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 = 283;

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 = 126;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.croisieres_id AS croisieres_id_3
FROM
  imagescroisiere t0
WHERE
  t0.croisieres_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.croisieres_id AS croisieres_id_3 FROM imagescroisiere t0 WHERE t0.croisieres_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.croisieres_id AS croisieres_id_3
FROM
  imagescroisiere t0
WHERE
  t0.croisieres_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.croisieres_id AS croisieres_id_3 FROM imagescroisiere t0 WHERE t0.croisieres_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.croisieres_id AS croisieres_id_3
FROM
  imagescroisiere t0
WHERE
  t0.croisieres_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.croisieres_id AS croisieres_id_3 FROM imagescroisiere t0 WHERE t0.croisieres_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sejours_id AS sejours_id_3
FROM
  image_sejours t0
WHERE
  t0.sejours_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sejours_id AS sejours_id_3 FROM image_sejours t0 WHERE t0.sejours_id = 101;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sejours_id AS sejours_id_3
FROM
  image_sejours t0
WHERE
  t0.sejours_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sejours_id AS sejours_id_3 FROM image_sejours t0 WHERE t0.sejours_id = 111;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sejours_id AS sejours_id_3
FROM
  image_sejours t0
WHERE
  t0.sejours_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sejours_id AS sejours_id_3 FROM image_sejours t0 WHERE t0.sejours_id = 113;