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.name AS name_2,
  t0.active AS active_3,
  t0.description AS description_4,
  t0.stateTransfer AS stateTransfer_5,
  t0.externalId AS externalId_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.country_id AS country_id_9,
  t0.image_id AS image_id_10
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.externalId AS externalId_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.country_id AS country_id_9, t0.image_id AS image_id_10 FROM City t0 WHERE t0.name = 'Tunis' LIMIT 1;

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
  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_.city IN ('Tunis')
  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
    )
  )

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_.city IN ('Tunis') 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));

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.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_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
  f0_.id AS id_0,
  f0_.question AS question_1,
  f0_.answer AS answer_2,
  f0_.route AS route_3,
  f0_.routeParameter AS routeParameter_4,
  f0_.isActive AS isActive_5,
  f0_.sort_order AS sort_order_6,
  f0_.deletedAt AS deletedAt_7
FROM
  faq f0_
WHERE
  f0_.route = ?
  AND f0_.isActive = 1
  AND f0_.deletedAt IS NULL
  AND (
    f0_.routeParameter = ?
    OR f0_.routeParameter IS NULL
  )
ORDER BY
  f0_.sort_order ASC

SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.route AS route_3, f0_.routeParameter AS routeParameter_4, f0_.isActive AS isActive_5, f0_.sort_order AS sort_order_6, f0_.deletedAt AS deletedAt_7 FROM faq f0_ WHERE f0_.route = 'app_front_hotel_city' AND f0_.isActive = 1 AND f0_.deletedAt IS NULL AND (f0_.routeParameter = 'tunis' OR f0_.routeParameter IS NULL) ORDER BY f0_.sort_order ASC;