Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.section AS section_1,
  b0_.sub_section AS sub_section_2,
  b0_.content AS content_3
FROM
  banner b0_
WHERE
  b0_.section = ?
  AND b0_.sub_section = ?

SELECT b0_.id AS id_0, b0_.section AS section_1, b0_.sub_section AS sub_section_2, b0_.content AS content_3 FROM banner b0_ WHERE b0_.section = 'golden-shores' AND b0_.sub_section = 'referenced';

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 = 'en' AND e0_.object_class = 'App\\Entity\\Banner';

SELECT
  c0_.id AS id_0,
  c0_.section AS section_1,
  c0_.sub_section AS sub_section_2,
  c0_.content AS content_3,
  c0_.type AS type_4
FROM
  content c0_
WHERE
  c0_.section = ?
  AND c0_.sub_section = ?
  AND c0_.type = ?

SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.sub_section AS sub_section_2, c0_.content AS content_3, c0_.type AS type_4 FROM content c0_ WHERE c0_.section = 'golden-shores' AND c0_.sub_section = 'referenced' AND c0_.type = 'portal-text';

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 = 'en' AND e0_.object_class = 'App\\Entity\\Content';

SELECT
  c0_.id AS id_0,
  c0_.section AS section_1,
  c0_.sub_section AS sub_section_2,
  c0_.content AS content_3,
  c0_.type AS type_4
FROM
  content c0_
WHERE
  c0_.section = ?
  AND c0_.sub_section = ?
  AND c0_.type = ?

SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.sub_section AS sub_section_2, c0_.content AS content_3, c0_.type AS type_4 FROM content c0_ WHERE c0_.section = 'golden-shores' AND c0_.sub_section = 'referenced-benefits' AND c0_.type = 'portal-section';

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 = 'en' AND e0_.object_class = 'App\\Entity\\Content';

SELECT
  c0_.id AS id_0,
  c0_.section AS section_1,
  c0_.sub_section AS sub_section_2,
  c0_.content AS content_3,
  c0_.type AS type_4
FROM
  content c0_
WHERE
  c0_.section = ?
  AND c0_.sub_section = ?
  AND c0_.type = ?

SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.sub_section AS sub_section_2, c0_.content AS content_3, c0_.type AS type_4 FROM content c0_ WHERE c0_.section = 'golden-shores' AND c0_.sub_section = 'referenced-referral' AND c0_.type = 'portal-section';

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 = '5' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Content';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'golden-shores' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111151' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

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 = '111111152' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'crown-club-cancun' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111144' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

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 = '111111155' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

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 = '111111154' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

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 = '111111156' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'crown-club-vallarta' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111145' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'crown-golden-vallarta' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111146' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'vista-manzanillo' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111147' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'vista-express-morelia' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111140' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'westin-cozumel' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111143' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

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 = '111111131' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'ibis-tijuana' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111141' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'vista-express-guadalajara-expo' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111157' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'the-palm' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111158' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

SELECT
  p0_.id AS id_0,
  p0_.section AS section_1,
  p0_.name AS name_2,
  p0_.code AS code_3,
  p0_.is_visible AS is_visible_4,
  p0_.content AS content_5,
  p0_.priority AS priority_6
FROM
  promotion p0_
WHERE
  p0_.section = ?
  AND p0_.is_visible = 1
ORDER BY
  p0_.priority ASC

SELECT p0_.id AS id_0, p0_.section AS section_1, p0_.name AS name_2, p0_.code AS code_3, p0_.is_visible AS is_visible_4, p0_.content AS content_5, p0_.priority AS priority_6 FROM promotion p0_ WHERE p0_.section = 'sensira-rivera-maya' AND p0_.is_visible = 1 ORDER BY p0_.priority 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 = '111111148' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';

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 = '111111142' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Promotion';