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

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.text AS text_2,
  n0_.published_at AS published_at_3,
  n0_.url AS url_4,
  n0_.section AS section_5,
  n0_.is_visible AS is_visible_6,
  n0_.gallery AS gallery_7
FROM
  novelty n0_
WHERE
  n0_.is_visible = 1
  AND n0_.published_at <= CURRENT_DATE
ORDER BY
  n0_.published_at DESC
LIMIT
  1

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.text AS text_2, n0_.published_at AS published_at_3, n0_.url AS url_4, n0_.section AS section_5, n0_.is_visible AS is_visible_6, n0_.gallery AS gallery_7 FROM novelty n0_ WHERE n0_.is_visible = 1 AND n0_.published_at <= CURRENT_DATE ORDER BY n0_.published_at DESC LIMIT 1;

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 = 'hotel' AND c0_.type = 'portal-text';

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 = 'privileges' AND c0_.type = 'portal-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 = ?
  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 = 'crown-golden-vallarta' AND b0_.sub_section = 'hotel';

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 = 'crown-golden-vallarta' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'crown-club-vallarta' AND b0_.sub_section = 'hotel';

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 = 'crown-club-vallarta' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'crown-club-cancun' AND b0_.sub_section = 'hotel';

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 = 'crown-club-cancun' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'vista-manzanillo' AND b0_.sub_section = 'hotel';

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 = 'vista-manzanillo' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'vista-express-morelia' AND b0_.sub_section = 'hotel';

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 = 'vista-express-morelia' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'westin-cozumel' AND b0_.sub_section = 'hotel';

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 = 'westin-cozumel' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'ibis-tijuana' AND b0_.sub_section = 'hotel';

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 = 'ibis-tijuana' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'vista-express-guadalajara-expo' AND b0_.sub_section = 'hotel';

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 = 'vista-express-guadalajara-expo' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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 = 'sensira-rivera-maya' AND b0_.sub_section = 'hotel';

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 = 'sensira-rivera-maya' AND c0_.sub_section = 'hotel' AND c0_.type = 'hotel-text';

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