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 = 'CONTACT' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\MenuItemFront';

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.subtitle AS subtitle_5,
  t0.backgroundColor AS backgroundColor_6,
  t0.active AS active_7,
  t0.nbElementsToDisplay AS nbElementsToDisplay_8,
  t0.query AS query_9,
  t0.backgroundImage_id AS backgroundImage_id_10
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.subtitle AS subtitle_5, t0.backgroundColor AS backgroundColor_6, t0.active AS active_7, t0.nbElementsToDisplay AS nbElementsToDisplay_8, t0.query AS query_9, t0.backgroundImage_id AS backgroundImage_id_10 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 = '3' AND e0_.locale = 'fr' AND e0_.object_class = 'App\\Entity\\FrontZone';

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
  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
  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
  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 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_main' AND f0_.isActive = 1 AND f0_.deletedAt IS NULL AND f0_.routeParameter IS NULL ORDER BY f0_.sort_order ASC;