Symfony Profiler

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