Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.starRating AS starRating_3,
  t0.imageUrl AS imageUrl_4,
  t0.description AS description_5,
  t0.code AS code_6,
  t0.codeExternal AS codeExternal_7,
  t0.gdsRefreshDate AS gdsRefreshDate_8,
  t0.city AS city_9,
  t0.marginB2C AS marginB2C_10,
  t0.marginB2B AS marginB2B_11,
  t0.country AS country_12,
  t0.seoTitle AS seoTitle_13,
  t0.seoDescription AS seoDescription_14,
  t0.product_id AS product_id_15,
  t0.hotel_id AS hotel_id_16
FROM
  HotelXml t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.starRating AS starRating_3, t0.imageUrl AS imageUrl_4, t0.description AS description_5, t0.code AS code_6, t0.codeExternal AS codeExternal_7, t0.gdsRefreshDate AS gdsRefreshDate_8, t0.city AS city_9, t0.marginB2C AS marginB2C_10, t0.marginB2B AS marginB2B_11, t0.country AS country_12, t0.seoTitle AS seoTitle_13, t0.seoDescription AS seoDescription_14, t0.product_id AS product_id_15, t0.hotel_id AS hotel_id_16 FROM HotelXml t0 WHERE t0.id = 69;

SELECT
  DISTINCT h0_.id AS id_0,
  h0_.room AS room_1,
  h0_.board AS board_2,
  h0_.currency AS currency_3,
  h0_.price AS price_4,
  h0_.hotelXml_id AS hotelXml_id_5
FROM
  HotelXmlPrice h0_
  INNER JOIN HotelXml h1_ ON h0_.hotelXml_id = h1_.id
WHERE
  h1_.city IN ('Hammamet')
GROUP BY
  h0_.hotelXml_id

SELECT DISTINCT h0_.id AS id_0, h0_.room AS room_1, h0_.board AS board_2, h0_.currency AS currency_3, h0_.price AS price_4, h0_.hotelXml_id AS hotelXml_id_5 FROM HotelXmlPrice h0_ INNER JOIN HotelXml h1_ ON h0_.hotelXml_id = h1_.id WHERE h1_.city IN ('Hammamet') GROUP BY h0_.hotelXml_id;

SELECT
  t0.id AS id_8,
  t0.onlyBack AS onlyBack_9,
  t0.seoTitle AS seoTitle_10,
  t0.seoDescription AS seoDescription_11,
  t0.provider_id AS provider_id_12,
  t0.dtype,
  t1.hotel_id AS hotel_id_13,
  t2.title AS title_14,
  t2.date AS date_15,
  t2.hotelStayRequired AS hotelStayRequired_16,
  t2.description AS description_17,
  t2.address AS address_18,
  t2.active AS active_19,
  t2.hotelContract_id AS hotelContract_id_20,
  t2.city_id AS city_id_21,
  t3.name AS name_22,
  t3.gdsCode AS gdsCode_23,
  t3.color AS color_24,
  t3.payAtHotelAuthorized AS payAtHotelAuthorized_25,
  t3.immediatePaymentPercent AS immediatePaymentPercent_26,
  t3.source AS source_27,
  t3.marginB2C AS marginB2C_28,
  t3.marginB2B AS marginB2B_29,
  t3.active AS active_30,
  t3.xmlApiType AS xmlApiType_31,
  t3.creditCard_id AS creditCard_id_32,
  t3.b2cMarkupStrategy_id AS b2cMarkupStrategy_id_33,
  t3.b2bMarkupStrategy_id AS b2bMarkupStrategy_id_34,
  t4.name AS name_35,
  t4.active AS active_36,
  t4.country_id AS country_id_37,
  t5.name AS name_38,
  t5.description AS description_39,
  t5.minPrice AS minPrice_40,
  t5.active AS active_41,
  t5.expireDate AS expireDate_42,
  t5.extraType_id AS extraType_id_43,
  t6.name AS name_44,
  t7.name AS name_45
FROM
  Product t0
  LEFT JOIN HotelContract t1 ON t0.id = t1.id
  LEFT JOIN Party t2 ON t0.id = t2.id
  LEFT JOIN XmlApi t3 ON t0.id = t3.id
  LEFT JOIN Transfer t4 ON t0.id = t4.id
  LEFT JOIN Extra t5 ON t0.id = t5.id
  LEFT JOIN CustomService t6 ON t0.id = t6.id
  LEFT JOIN ManualFlight t7 ON t0.id = t7.id
WHERE
  t0.id = ?

SELECT t0.id AS id_8, t0.onlyBack AS onlyBack_9, t0.seoTitle AS seoTitle_10, t0.seoDescription AS seoDescription_11, t0.provider_id AS provider_id_12, t0.dtype, t1.hotel_id AS hotel_id_13, t2.title AS title_14, t2.date AS date_15, t2.hotelStayRequired AS hotelStayRequired_16, t2.description AS description_17, t2.address AS address_18, t2.active AS active_19, t2.hotelContract_id AS hotelContract_id_20, t2.city_id AS city_id_21, t3.name AS name_22, t3.gdsCode AS gdsCode_23, t3.color AS color_24, t3.payAtHotelAuthorized AS payAtHotelAuthorized_25, t3.immediatePaymentPercent AS immediatePaymentPercent_26, t3.source AS source_27, t3.marginB2C AS marginB2C_28, t3.marginB2B AS marginB2B_29, t3.active AS active_30, t3.xmlApiType AS xmlApiType_31, t3.creditCard_id AS creditCard_id_32, t3.b2cMarkupStrategy_id AS b2cMarkupStrategy_id_33, t3.b2bMarkupStrategy_id AS b2bMarkupStrategy_id_34, t4.name AS name_35, t4.active AS active_36, t4.country_id AS country_id_37, t5.name AS name_38, t5.description AS description_39, t5.minPrice AS minPrice_40, t5.active AS active_41, t5.expireDate AS expireDate_42, t5.extraType_id AS extraType_id_43, t6.name AS name_44, t7.name AS name_45 FROM Product t0 LEFT JOIN HotelContract t1 ON t0.id = t1.id LEFT JOIN Party t2 ON t0.id = t2.id LEFT JOIN XmlApi t3 ON t0.id = t3.id LEFT JOIN Transfer t4 ON t0.id = t4.id LEFT JOIN Extra t5 ON t0.id = t5.id LEFT JOIN CustomService t6 ON t0.id = t6.id LEFT JOIN ManualFlight t7 ON t0.id = t7.id WHERE t0.id = 1;

SELECT
  t0.id AS id_3,
  t0.auxiliaryCode AS auxiliaryCode_4,
  t0.note AS note_5,
  t0.currency AS currency_6,
  t0.isDefault AS isDefault_7,
  t0.active AS active_8,
  t0.showAllHotelXml AS showAllHotelXml_9,
  t0.createdAt AS createdAt_10,
  t0.updatedAt AS updatedAt_11,
  t0.name AS name_12,
  t0.address AS address_13,
  t0.postalCode AS postalCode_14,
  t0.phone AS phone_15,
  t0.email AS email_16,
  t0.fax AS fax_17,
  t0.identityDocument AS identityDocument_18,
  t0.identityNumber AS identityNumber_19,
  t0.market_id AS market_id_20,
  t0.city_id AS city_id_21,
  t0.parent_id AS parent_id_22,
  t0.logo_id AS logo_id_23,
  t0.dtype,
  t1.exemptTax AS exemptTax_24,
  t1.exemptStamp AS exemptStamp_25,
  t1.authorizedCreditAmount AS authorizedCreditAmount_26,
  t1.preferred AS preferred_27,
  t1.corporateStrategy AS corporateStrategy_28,
  t1.resellerMargin AS resellerMargin_29,
  t1.logoVisibility AS logoVisibility_30,
  t1.foundationDate AS foundationDate_31,
  t2.civility AS civility_32,
  t2.firstName AS firstName_33,
  t2.lastName AS lastName_34,
  t2.birthdate AS birthdate_35
FROM
  Customer t0
  LEFT JOIN CustomerMoral t1 ON t0.id = t1.id
  LEFT JOIN CustomerPhysical t2 ON t0.id = t2.id
WHERE
  t0.isDefault = ?
  AND t0.active = ?

SELECT t0.id AS id_3, t0.auxiliaryCode AS auxiliaryCode_4, t0.note AS note_5, t0.currency AS currency_6, t0.isDefault AS isDefault_7, t0.active AS active_8, t0.showAllHotelXml AS showAllHotelXml_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.name AS name_12, t0.address AS address_13, t0.postalCode AS postalCode_14, t0.phone AS phone_15, t0.email AS email_16, t0.fax AS fax_17, t0.identityDocument AS identityDocument_18, t0.identityNumber AS identityNumber_19, t0.market_id AS market_id_20, t0.city_id AS city_id_21, t0.parent_id AS parent_id_22, t0.logo_id AS logo_id_23, t0.dtype, t1.exemptTax AS exemptTax_24, t1.exemptStamp AS exemptStamp_25, t1.authorizedCreditAmount AS authorizedCreditAmount_26, t1.preferred AS preferred_27, t1.corporateStrategy AS corporateStrategy_28, t1.resellerMargin AS resellerMargin_29, t1.logoVisibility AS logoVisibility_30, t1.foundationDate AS foundationDate_31, t2.civility AS civility_32, t2.firstName AS firstName_33, t2.lastName AS lastName_34, t2.birthdate AS birthdate_35 FROM Customer t0 LEFT JOIN CustomerMoral t1 ON t0.id = t1.id LEFT JOIN CustomerPhysical t2 ON t0.id = t2.id WHERE t0.isDefault = 1 AND t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.description AS description_4,
  t0.stateTransfer AS stateTransfer_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.country_id AS country_id_8,
  t0.image_id AS image_id_9
FROM
  City t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.description AS description_4, t0.stateTransfer AS stateTransfer_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.country_id AS country_id_8, t0.image_id AS image_id_9 FROM City t0 WHERE t0.name = 'Hammamet' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone AS phone_4,
  t0.active AS active_5,
  t0.currency AS currency_6,
  t0.isDefault AS isDefault_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.city_id AS city_id_10
FROM
  Agency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.active AS active_5, t0.currency AS currency_6, t0.isDefault AS isDefault_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.city_id AS city_id_10 FROM Agency t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_4,
  t0.name AS name_5,
  t0.address AS address_6,
  t0.longitude AS longitude_7,
  t0.latitude AS latitude_8,
  t0.email AS email_9,
  t0.website AS website_10,
  t0.phone AS phone_11,
  t0.fax AS fax_12,
  t0.rib AS rib_13,
  t0.active AS active_14,
  t0.currency AS currency_15,
  t0.city_id AS city_id_16,
  t0.logo_id AS logo_id_17,
  t0.dtype,
  t1.description AS description_18,
  t1.starRating AS starRating_19,
  t1.autoMail AS autoMail_20,
  t1.tripadvisorId AS tripadvisorId_21,
  t1.customRating AS customRating_22,
  t1.seoTitle AS seoTitle_23,
  t1.seoDescription AS seoDescription_24,
  t1.chain_id AS chain_id_25,
  t1.type_id AS type_id_26
FROM
  Provider t0
  LEFT JOIN Hotel t1 ON t0.id = t1.id
  LEFT JOIN HotelChain t2 ON t0.id = t2.id
  LEFT JOIN OtherProvider t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.name AS name_5, t0.address AS address_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.email AS email_9, t0.website AS website_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.rib AS rib_13, t0.active AS active_14, t0.currency AS currency_15, t0.city_id AS city_id_16, t0.logo_id AS logo_id_17, t0.dtype, t1.description AS description_18, t1.starRating AS starRating_19, t1.autoMail AS autoMail_20, t1.tripadvisorId AS tripadvisorId_21, t1.customRating AS customRating_22, t1.seoTitle AS seoTitle_23, t1.seoDescription AS seoDescription_24, t1.chain_id AS chain_id_25, t1.type_id AS type_id_26 FROM Provider t0 LEFT JOIN Hotel t1 ON t0.id = t1.id LEFT JOIN HotelChain t2 ON t0.id = t2.id LEFT JOIN OtherProvider t3 ON t0.id = t3.id WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone AS phone_4,
  t0.active AS active_5,
  t0.currency AS currency_6,
  t0.isDefault AS isDefault_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.city_id AS city_id_10
FROM
  Agency t0
WHERE
  t0.isDefault = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.active AS active_5, t0.currency AS currency_6, t0.isDefault AS isDefault_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.city_id AS city_id_10 FROM Agency t0 WHERE t0.isDefault = 0;

SELECT
  t0.path AS path_1,
  t0.value AS value_2
FROM
  Parameter t0

SELECT t0.path AS path_1, t0.value AS value_2 FROM Parameter t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.icon AS icon_4,
  t0.active AS active_5,
  t0.clicksCount AS clicksCount_6,
  t0.pageId AS pageId_7
FROM
  SocialNetwork t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.icon AS icon_4, t0.active AS active_5, t0.clicksCount AS clicksCount_6, t0.pageId AS pageId_7 FROM SocialNetwork t0 WHERE t0.active = 'true';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.currency AS currency_4,
  t0.prefix AS prefix_5,
  t0.codeAlpha2 AS codeAlpha2_6,
  t0.continent_id AS continent_id_7
FROM
  Country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.currency AS currency_4, t0.prefix AS prefix_5, t0.codeAlpha2 AS codeAlpha2_6, t0.continent_id AS continent_id_7 FROM Country t0 WHERE t0.id = 1;