Symfony Profiler

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 = 'footer_opis_firmy' 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

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_.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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.extension AS extension_3,
  t0.full_name AS full_name_4,
  t0.file AS file_5,
  t0.description AS description_6,
  t0.updated_at AS updated_at_7,
  t0.added_at AS added_at_8,
  t0.id_file_repository_folder AS id_file_repository_folder_9,
  t0.id_updated_by_user AS id_updated_by_user_10,
  t0.id_added_by_user AS id_added_by_user_11
FROM
  file_repository t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.full_name AS full_name_4, t0.file AS file_5, t0.description AS description_6, t0.updated_at AS updated_at_7, t0.added_at AS added_at_8, t0.id_file_repository_folder AS id_file_repository_folder_9, t0.id_updated_by_user AS id_updated_by_user_10, t0.id_added_by_user AS id_added_by_user_11 FROM file_repository t0 WHERE t0.id = 71;

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
  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
  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.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
  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 = 'Mikołajki' 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 = ?
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
  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_;