Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.section AS section_2,
  t0.name AS name_3,
  t0.code AS code_4,
  t0.is_visible AS is_visible_5,
  t0.content AS content_6,
  t0.priority AS priority_7
FROM
  promotion t0
WHERE
  t0.id = ?
  AND t0.is_visible = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.section AS section_2, t0.name AS name_3, t0.code AS code_4, t0.is_visible AS is_visible_5, t0.content AS content_6, t0.priority AS priority_7 FROM promotion t0 WHERE t0.id = '111111152' AND t0.is_visible = 1 LIMIT 1;

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 = '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 = 'the-palm' 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;