Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation 2
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• E-mails
• Serializer
• JMS Serializer 0 + 0
• Configuration

Query Metrics

Grouped Statements

Show all queries

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 = ?

[
  "golden-shores"
  "hotel"
]

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 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 = ?

[
  "golden-shores"
  "hotel"
  "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 = 'hotel' AND c0_.type = 'portal-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

[
  "golden-shores"
]

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

Database Connections

Entity Managers

Second Level Cache

Entities Mapping