Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.onlyBack AS onlyBack_1,
  p0_.seoTitle AS seoTitle_2,
  p0_.seoDescription AS seoDescription_3,
  p1_.title AS title_4,
  p1_.date AS date_5,
  p1_.hotelStayRequired AS hotelStayRequired_6,
  p1_.description AS description_7,
  p1_.address AS address_8,
  p1_.active AS active_9,
  p0_.dtype AS dtype_10,
  p0_.provider_id AS provider_id_11,
  p1_.hotelContract_id AS hotelContract_id_12,
  p1_.city_id AS city_id_13
FROM
  Party p1_
  INNER JOIN Product p0_ ON p1_.id = p0_.id
  LEFT JOIN ProductElement p2_ ON p0_.id = p2_.product_id
  LEFT JOIN HotelRoomType h3_ ON p2_.id = h3_.id
  LEFT JOIN PartyZone p4_ ON p2_.id = p4_.id
ORDER BY
  p1_.date ASC

SELECT p0_.id AS id_0, p0_.onlyBack AS onlyBack_1, p0_.seoTitle AS seoTitle_2, p0_.seoDescription AS seoDescription_3, p1_.title AS title_4, p1_.date AS date_5, p1_.hotelStayRequired AS hotelStayRequired_6, p1_.description AS description_7, p1_.address AS address_8, p1_.active AS active_9, p0_.dtype AS dtype_10, p0_.provider_id AS provider_id_11, p1_.hotelContract_id AS hotelContract_id_12, p1_.city_id AS city_id_13 FROM Party p1_ INNER JOIN Product p0_ ON p1_.id = p0_.id LEFT JOIN ProductElement p2_ ON p0_.id = p2_.product_id LEFT JOIN HotelRoomType h3_ ON p2_.id = h3_.id LEFT JOIN PartyZone p4_ ON p2_.id = p4_.id ORDER BY p1_.date ASC;

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.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;