Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 145
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = ? LIMIT 1

[
  "og_meta_tags_image"
]

SELECT
  t0.id AS id_1,
  t0.foreign_key AS foreign_key_2,
  t0.value AS value_3
FROM
  translator t0
WHERE
  t0.foreign_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.foreign_key AS foreign_key_2, t0.value AS value_3 FROM translator t0 WHERE t0.foreign_key = 'og_meta_tags_image' LIMIT 1;

SELECT t0.id AS id_1, t0.title AS title_2, t0.content_type AS content_type_3, t0.visibility AS visibility_4, t0.position AS position_5, t0.id_structure AS id_structure_6 FROM structure_element t0 WHERE t0.id_structure = ? ORDER BY t0.position ASC

[
  13
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content_type AS content_type_3,
  t0.visibility AS visibility_4,
  t0.position AS position_5,
  t0.id_structure AS id_structure_6
FROM
  structure_element t0
WHERE
  t0.id_structure = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.content_type AS content_type_3, t0.visibility AS visibility_4, t0.position AS position_5, t0.id_structure AS id_structure_6 FROM structure_element t0 WHERE t0.id_structure = 13 ORDER BY t0.position ASC;

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.name AS name_2, s0_.is_homepage AS is_homepage_3, s0_.visibility AS visibility_4, s0_.access_type AS access_type_5, s0_.page_layout AS page_layout_6, s0_.lft AS lft_7, s0_.rgt AS rgt_8, s0_.depth AS depth_9, s0_.lang AS lang_10, s0_.slug AS slug_11, s0_.id_target AS id_target_12 FROM structure s0_ WHERE s0_.lang = ? AND s0_.is_homepage = 1 LIMIT 1

[
  "pl"
]

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.name AS name_2,
  s0_.is_homepage AS is_homepage_3,
  s0_.visibility AS visibility_4,
  s0_.access_type AS access_type_5,
  s0_.page_layout AS page_layout_6,
  s0_.lft AS lft_7,
  s0_.rgt AS rgt_8,
  s0_.depth AS depth_9,
  s0_.lang AS lang_10,
  s0_.slug AS slug_11,
  s0_.id_target AS id_target_12
FROM
  structure s0_
WHERE
  s0_.lang = ?
  AND s0_.is_homepage = 1
LIMIT
  1

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.name AS name_2, s0_.is_homepage AS is_homepage_3, s0_.visibility AS visibility_4, s0_.access_type AS access_type_5, s0_.page_layout AS page_layout_6, s0_.lft AS lft_7, s0_.rgt AS rgt_8, s0_.depth AS depth_9, s0_.lang AS lang_10, s0_.slug AS slug_11, s0_.id_target AS id_target_12 FROM structure s0_ WHERE s0_.lang = 'pl' AND s0_.is_homepage = 1 LIMIT 1;

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.name AS name_2, s0_.is_homepage AS is_homepage_3, s0_.visibility AS visibility_4, s0_.access_type AS access_type_5, s0_.page_layout AS page_layout_6, s0_.lft AS lft_7, s0_.rgt AS rgt_8, s0_.depth AS depth_9, s0_.lang AS lang_10, s0_.slug AS slug_11, s0_.id_target AS id_target_12 FROM structure s0_ WHERE s0_.lang = ? AND (s0_.lft > ? AND s0_.rgt < ?) AND s0_.depth = ? AND s0_.slug = ? LIMIT 1

[
  "pl"
  1
  18
  1
  "lokalizacje"
]

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.name AS name_2,
  s0_.is_homepage AS is_homepage_3,
  s0_.visibility AS visibility_4,
  s0_.access_type AS access_type_5,
  s0_.page_layout AS page_layout_6,
  s0_.lft AS lft_7,
  s0_.rgt AS rgt_8,
  s0_.depth AS depth_9,
  s0_.lang AS lang_10,
  s0_.slug AS slug_11,
  s0_.id_target AS id_target_12
FROM
  structure s0_
WHERE
  s0_.lang = ?
  AND (
    s0_.lft > ?
    AND s0_.rgt < ?
  )
  AND s0_.depth = ?
  AND s0_.slug = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.name AS name_2, s0_.is_homepage AS is_homepage_3, s0_.visibility AS visibility_4, s0_.access_type AS access_type_5, s0_.page_layout AS page_layout_6, s0_.lft AS lft_7, s0_.rgt AS rgt_8, s0_.depth AS depth_9, s0_.lang AS lang_10, s0_.slug AS slug_11, s0_.id_target AS id_target_12 FROM structure s0_ WHERE s0_.lang = 'pl' AND (s0_.lft > 1 AND s0_.rgt < 18) AND s0_.depth = 1 AND s0_.slug = 'lokalizacje' LIMIT 1;

SELECT l0_.city AS city_0, l0_.sort_order AS sort_order_1 FROM location_content l0_

[]

SELECT
  l0_.city AS city_0,
  l0_.sort_order AS sort_order_1
FROM
  location_content l0_

SELECT l0_.city AS city_0, l0_.sort_order AS sort_order_1 FROM location_content l0_;

SELECT h0_.city AS city_0, COUNT(h1_.id) AS sclr_1 FROM hotel_conference_room h1_ INNER JOIN hotel h0_ ON h1_.id_hotel = h0_.id WHERE h1_.is_edited_by_admin = 1 AND h1_.id_hotel IS NOT NULL GROUP BY h0_.city ORDER BY h0_.city ASC

[]

SELECT
  h0_.city AS city_0,
  COUNT(h1_.id) AS sclr_1
FROM
  hotel_conference_room h1_
  INNER JOIN hotel h0_ ON h1_.id_hotel = h0_.id
WHERE
  h1_.is_edited_by_admin = 1
  AND h1_.id_hotel IS NOT NULL
GROUP BY
  h0_.city
ORDER BY
  h0_.city ASC

SELECT h0_.city AS city_0, COUNT(h1_.id) AS sclr_1 FROM hotel_conference_room h1_ INNER JOIN hotel h0_ ON h1_.id_hotel = h0_.id WHERE h1_.is_edited_by_admin = 1 AND h1_.id_hotel IS NOT NULL GROUP BY h0_.city ORDER BY h0_.city ASC;

SELECT t0.id AS id_1, t0.city AS city_2, t0.description AS description_3, t0.sort_order AS sort_order_4, t0.id_image AS id_image_5, t0.id_header_image AS id_header_image_6 FROM location_content t0 WHERE t0.city = ? LIMIT 1

[
  "Szczawnica"
]

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.description AS description_3,
  t0.sort_order AS sort_order_4,
  t0.id_image AS id_image_5,
  t0.id_header_image AS id_header_image_6
FROM
  location_content t0
WHERE
  t0.city = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.city AS city_2, t0.description AS description_3, t0.sort_order AS sort_order_4, t0.id_image AS id_image_5, t0.id_header_image AS id_header_image_6 FROM location_content t0 WHERE t0.city = 'Szczawnica' LIMIT 1;

SELECT t0.name AS name_1, t0.value AS value_2 FROM settings t0 WHERE t0.name = ?

[
  "app.settings"
]

SELECT
  t0.name AS name_1,
  t0.value AS value_2
FROM
  settings t0
WHERE
  t0.name = ?

SELECT t0.name AS name_1, t0.value AS value_2 FROM settings t0 WHERE t0.name = 'app.settings';

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.name AS name_2, s0_.is_homepage AS is_homepage_3, s0_.visibility AS visibility_4, s0_.access_type AS access_type_5, s0_.page_layout AS page_layout_6, s0_.lft AS lft_7, s0_.rgt AS rgt_8, s0_.depth AS depth_9, s0_.lang AS lang_10, s0_.slug AS slug_11, s0_.id_target AS id_target_12 FROM structure s0_ WHERE s0_.lang = ? ORDER BY s0_.depth ASC, s0_.lft ASC

[
  "pl"
]

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.name AS name_2,
  s0_.is_homepage AS is_homepage_3,
  s0_.visibility AS visibility_4,
  s0_.access_type AS access_type_5,
  s0_.page_layout AS page_layout_6,
  s0_.lft AS lft_7,
  s0_.rgt AS rgt_8,
  s0_.depth AS depth_9,
  s0_.lang AS lang_10,
  s0_.slug AS slug_11,
  s0_.id_target AS id_target_12
FROM
  structure s0_
WHERE
  s0_.lang = ?
ORDER BY
  s0_.depth ASC,
  s0_.lft ASC

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.name AS name_2, s0_.is_homepage AS is_homepage_3, s0_.visibility AS visibility_4, s0_.access_type AS access_type_5, s0_.page_layout AS page_layout_6, s0_.lft AS lft_7, s0_.rgt AS rgt_8, s0_.depth AS depth_9, s0_.lang AS lang_10, s0_.slug AS slug_11, s0_.id_target AS id_target_12 FROM structure s0_ WHERE s0_.lang = 'pl' ORDER BY s0_.depth ASC, s0_.lft ASC;

SELECT h0_.city AS city_0, COUNT(h0_.id) AS sclr_1 FROM hotel h0_ WHERE h0_.is_edited_by_admin = 1 GROUP BY h0_.city ORDER BY h0_.city ASC

[]

SELECT
  h0_.city AS city_0,
  COUNT(h0_.id) AS sclr_1
FROM
  hotel h0_
WHERE
  h0_.is_edited_by_admin = 1
GROUP BY
  h0_.city
ORDER BY
  h0_.city ASC

SELECT h0_.city AS city_0, COUNT(h0_.id) AS sclr_1 FROM hotel h0_ WHERE h0_.is_edited_by_admin = 1 GROUP BY h0_.city ORDER BY h0_.city ASC;

SELECT t0.id AS id_1, t0.city AS city_2, t0.description AS description_3, t0.sort_order AS sort_order_4, t0.id_image AS id_image_5, t0.id_header_image AS id_header_image_6 FROM location_content t0

[]

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.description AS description_3,
  t0.sort_order AS sort_order_4,
  t0.id_image AS id_image_5,
  t0.id_header_image AS id_header_image_6
FROM
  location_content t0

SELECT t0.id AS id_1, t0.city AS city_2, t0.description AS description_3, t0.sort_order AS sort_order_4, t0.id_image AS id_image_5, t0.id_header_image AS id_header_image_6 FROM location_content t0;

SELECT l0_.id AS id_0, l0_.city AS city_1 FROM location_content l0_

[]

SELECT
  l0_.id AS id_0,
  l0_.city AS city_1
FROM
  location_content l0_

SELECT l0_.id AS id_0, l0_.city AS city_1 FROM location_content l0_;