Symfony Profiler

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_1,
  t0.productType AS productType_2,
  t0.dataJson AS dataJson_3,
  t0.value AS value_4,
  t0.valueType AS valueType_5
FROM
  HubLocation t0
WHERE
  t0.productType = ?

SELECT t0.id AS id_1, t0.productType AS productType_2, t0.dataJson AS dataJson_3, t0.value AS value_4, t0.valueType AS valueType_5 FROM HubLocation t0 WHERE t0.productType = 'FLIGHT';

SELECT
  t0.id AS id_1,
  t0.productType AS productType_2,
  t0.dataJson AS dataJson_3,
  t0.value AS value_4,
  t0.valueType AS valueType_5
FROM
  HubLocation t0
WHERE
  t0.productType = ?

SELECT t0.id AS id_1, t0.productType AS productType_2, t0.dataJson AS dataJson_3, t0.value AS value_4, t0.valueType AS valueType_5 FROM HubLocation t0 WHERE t0.productType = 'HOTEL';

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.title AS title_2,
  t0.route AS route_3,
  t0.displayOrder AS displayOrder_4,
  t0.parent AS parent_5,
  t0.active AS active_6,
  t0.externalUrl AS externalUrl_7,
  t0.country_id AS country_id_8
FROM
  MenuItemFront t0
WHERE
  t0.active = ?
ORDER BY
  t0.displayOrder ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.displayOrder AS displayOrder_4, t0.parent AS parent_5, t0.active AS active_6, t0.externalUrl AS externalUrl_7, t0.country_id AS country_id_8 FROM MenuItemFront t0 WHERE t0.active = 1 ORDER BY t0.displayOrder ASC;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = 'FRONT' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\MenuItemFront';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = 'HOME' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\MenuItemFront';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = 'HOTEL-COUNTRY-1' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\MenuItemFront';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = 'HOTEL-PROMOS' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\MenuItemFront';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = 'PARTY' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\MenuItemFront';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = 'CONTACT' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\MenuItemFront';

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.externalId AS externalId_7,
  t0.continent_id AS continent_id_8
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.externalId AS externalId_7, t0.continent_id AS continent_id_8 FROM Country t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.active AS active_2,
  c0_.description AS description_3,
  c0_.stateTransfer AS stateTransfer_4,
  c0_.externalId AS externalId_5,
  c0_.latitude AS latitude_6,
  c0_.longitude AS longitude_7,
  c0_.country_id AS country_id_8,
  c0_.image_id AS image_id_9
FROM
  City c0_
  LEFT JOIN Country c1_ ON c0_.country_id = c1_.id
WHERE
  c0_.active = ?
  AND c1_.id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.active AS active_2, c0_.description AS description_3, c0_.stateTransfer AS stateTransfer_4, c0_.externalId AS externalId_5, c0_.latitude AS latitude_6, c0_.longitude AS longitude_7, c0_.country_id AS country_id_8, c0_.image_id AS image_id_9 FROM City c0_ LEFT JOIN Country c1_ ON c0_.country_id = c1_.id WHERE c0_.active = 1 AND c1_.id = 1;

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_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.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.id AS id_1,
  t0.slug AS slug_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.content AS content_5,
  t0.active AS active_6,
  t0.editable AS editable_7,
  t0.seoTitle AS seoTitle_8,
  t0.seoDescription AS seoDescription_9
FROM
  FrontPage t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.content AS content_5, t0.active AS active_6, t0.editable AS editable_7, t0.seoTitle AS seoTitle_8, t0.seoDescription AS seoDescription_9 FROM FrontPage t0 WHERE t0.slug = 'home' LIMIT 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontPage';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.directoryPath AS directoryPath_3,
  t0.extension AS extension_4,
  t0.alt AS alt_5,
  t0.displayOrder AS displayOrder_6,
  t0.url AS url_7,
  t0.active AS active_8,
  t0.title AS title_9,
  t0.sub_title AS sub_title_10,
  t0.type AS type_11,
  t0.createdAt AS createdAt_12,
  t0.updatedAt AS updatedAt_13,
  t0.provider_id AS provider_id_14,
  t0.product_id AS product_id_15,
  t16.id AS id_17,
  t16.iataCode AS iataCode_18,
  t16.businessName AS businessName_19,
  t16.icaoCode AS icaoCode_20,
  t16.commonName AS commonName_21,
  t16.logo_id AS logo_id_22
FROM
  FileData t0
  LEFT JOIN Airline t16 ON t16.logo_id = t0.id
WHERE
  t0.type = ?
  AND t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.directoryPath AS directoryPath_3, t0.extension AS extension_4, t0.alt AS alt_5, t0.displayOrder AS displayOrder_6, t0.url AS url_7, t0.active AS active_8, t0.title AS title_9, t0.sub_title AS sub_title_10, t0.type AS type_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.provider_id AS provider_id_14, t0.product_id AS product_id_15, t16.id AS id_17, t16.iataCode AS iataCode_18, t16.businessName AS businessName_19, t16.icaoCode AS icaoCode_20, t16.commonName AS commonName_21, t16.logo_id AS logo_id_22 FROM FileData t0 LEFT JOIN Airline t16 ON t16.logo_id = t0.id WHERE t0.type = 'slider' AND t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.image AS image_5,
  t0.class AS class_6
FROM
  FrontSection t0

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.image AS image_5, t0.class AS class_6 FROM FrontSection t0;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontSection';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontSection';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontSection';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '4' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontSection';

SELECT
  t0.id AS id_1,
  t0.htmlFileName AS htmlFileName_2,
  t0.description AS description_3,
  t0.title AS title_4,
  t0.backgroundColor AS backgroundColor_5,
  t0.active AS active_6,
  t0.nbElementsToDisplay AS nbElementsToDisplay_7,
  t0.query AS query_8,
  t0.backgroundImage_id AS backgroundImage_id_9
FROM
  FrontZone t0
WHERE
  t0.active = ?

SELECT t0.id AS id_1, t0.htmlFileName AS htmlFileName_2, t0.description AS description_3, t0.title AS title_4, t0.backgroundColor AS backgroundColor_5, t0.active AS active_6, t0.nbElementsToDisplay AS nbElementsToDisplay_7, t0.query AS query_8, t0.backgroundImage_id AS backgroundImage_id_9 FROM FrontZone t0 WHERE t0.active = 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontZone';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontZone';

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '3' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontZone';

SELECT
  t0.id AS id_1,
  t0.parameter AS parameter_2,
  t0.value AS value_3,
  t0.frontZone_id AS frontZone_id_4
FROM
  FrontZoneParamValue t0
WHERE
  t0.frontZone_id = ?
ORDER BY
  t0.parameter ASC

SELECT t0.id AS id_1, t0.parameter AS parameter_2, t0.value AS value_3, t0.frontZone_id AS frontZone_id_4 FROM FrontZoneParamValue t0 WHERE t0.frontZone_id = 1 ORDER BY t0.parameter ASC;

SELECT
  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
  h0_.price = (
    SELECT
      MIN(h2_.price) AS sclr_6
    FROM
      HotelXmlPrice h2_
    WHERE
      h2_.hotelXml_id = h0_.hotelXml_id
  )
  AND h1_.name IN (
    'Sousse Palace', 'Iberostar Kantaoui Bay',
    'Iberostar Diar el Andalous', 'Jaz Tour Khalef',
    'Golf Residence  GAS'
  )
  AND (
    h0_.id = (
      SELECT
        MIN(h3_.id) AS sclr_7
      FROM
        HotelXmlPrice h3_
      WHERE
        h3_.hotelXml_id = h0_.hotelXml_id
        AND h3_.price = h0_.price
    )
  )
LIMIT
  5

SELECT 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 h0_.price = (SELECT MIN(h2_.price) AS sclr_6 FROM HotelXmlPrice h2_ WHERE h2_.hotelXml_id = h0_.hotelXml_id) AND h1_.name IN ('Sousse Palace', 'Iberostar Kantaoui Bay', 'Iberostar Diar el Andalous', 'Jaz Tour Khalef', 'Golf Residence  GAS') AND (h0_.id = (SELECT MIN(h3_.id) AS sclr_7 FROM HotelXmlPrice h3_ WHERE h3_.hotelXml_id = h0_.hotelXml_id AND h3_.price = h0_.price)) LIMIT 5;

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

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.commissionType AS commissionType_32,
  t3.creditCard_id AS creditCard_id_33,
  t3.b2cMarkupStrategy_id AS b2cMarkupStrategy_id_34,
  t3.b2bMarkupStrategy_id AS b2bMarkupStrategy_id_35,
  t4.name AS name_36,
  t4.active AS active_37,
  t4.country_id AS country_id_38,
  t5.name AS name_39,
  t5.description AS description_40,
  t5.minPrice AS minPrice_41,
  t5.active AS active_42,
  t5.expireDate AS expireDate_43,
  t5.extraType_id AS extraType_id_44,
  t6.name AS name_45,
  t7.name AS name_46,
  t7.sourceId AS sourceId_47
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.commissionType AS commissionType_32, t3.creditCard_id AS creditCard_id_33, t3.b2cMarkupStrategy_id AS b2cMarkupStrategy_id_34, t3.b2bMarkupStrategy_id AS b2bMarkupStrategy_id_35, t4.name AS name_36, t4.active AS active_37, t4.country_id AS country_id_38, t5.name AS name_39, t5.description AS description_40, t5.minPrice AS minPrice_41, t5.active AS active_42, t5.expireDate AS expireDate_43, t5.extraType_id AS extraType_id_44, t6.name AS name_45, t7.name AS name_46, t7.sourceId AS sourceId_47 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_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;