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 = 'og_meta_tags_image' 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 = 417;

SELECT
  t0.id AS id_1,
  t0.width_lg AS width_lg_2,
  t0.width_md AS width_md_3,
  t0.width_sm AS width_sm_4,
  t0.width_xs AS width_xs_5,
  t0.content AS content_6,
  t0.id_structure_element AS id_structure_element_7
FROM
  structure_element_html_content t0
WHERE
  t0.id_structure_element = ?

SELECT t0.id AS id_1, t0.width_lg AS width_lg_2, t0.width_md AS width_md_3, t0.width_sm AS width_sm_4, t0.width_xs AS width_xs_5, t0.content AS content_6, t0.id_structure_element AS id_structure_element_7 FROM structure_element_html_content t0 WHERE t0.id_structure_element = 11;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.added_at AS added_at_4,
  t0.id_added_by_user AS id_added_by_user_5
FROM
  module_multilang_entry t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.added_at AS added_at_4, t0.id_added_by_user AS id_added_by_user_5 FROM module_multilang_entry t0 WHERE t0.id = 7;

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 = 4 ORDER BY t0.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.description AS description_2,
  p0_.publish_from AS publish_from_3,
  p0_.publish_to AS publish_to_4,
  p0_.is_active AS is_active_5,
  p0_.id_image_file_repository AS id_image_file_repository_6
FROM
  popup p0_
WHERE
  p0_.is_active = 1
  AND (
    (
      p0_.publish_from IS NULL
      OR p0_.publish_from <= CURRENT_DATE
    )
  )
  AND (
    (
      p0_.publish_to IS NULL
      OR p0_.publish_to >= CURRENT_DATE
    )
  )
ORDER BY
  RAND() ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.description AS description_2, p0_.publish_from AS publish_from_3, p0_.publish_to AS publish_to_4, p0_.is_active AS is_active_5, p0_.id_image_file_repository AS id_image_file_repository_6 FROM popup p0_ WHERE p0_.is_active = 1 AND ((p0_.publish_from IS NULL OR p0_.publish_from <= CURRENT_DATE)) AND ((p0_.publish_to IS NULL OR p0_.publish_to >= CURRENT_DATE)) ORDER BY RAND() ASC 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_.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
  t0.id AS id_1,
  t0.width_lg AS width_lg_2,
  t0.width_md AS width_md_3,
  t0.width_sm AS width_sm_4,
  t0.width_xs AS width_xs_5,
  t0.content AS content_6,
  t0.id_structure_element AS id_structure_element_7,
  t0.id_image_file_repository AS id_image_file_repository_8
FROM
  structure_element_html_text_image t0
WHERE
  t0.id_structure_element = ?

SELECT t0.id AS id_1, t0.width_lg AS width_lg_2, t0.width_md AS width_md_3, t0.width_sm AS width_sm_4, t0.width_xs AS width_xs_5, t0.content AS content_6, t0.id_structure_element AS id_structure_element_7, t0.id_image_file_repository AS id_image_file_repository_8 FROM structure_element_html_text_image t0 WHERE t0.id_structure_element = 10;

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.name AS name_2,
  t0.description AS description_3,
  t0.street AS street_4,
  t0.building_number AS building_number_5,
  t0.postal_code AS postal_code_6,
  t0.city AS city_7,
  t0.room_count AS room_count_8,
  t0.stars_number AS stars_number_9,
  t0.geo_lat AS geo_lat_10,
  t0.geo_lng AS geo_lng_11,
  t0.url AS url_12,
  t0.is_imported AS is_imported_13,
  t0.is_edited_by_admin AS is_edited_by_admin_14,
  t0.id_image_file_repository AS id_image_file_repository_15,
  t0.id_api_hotels_hub_hotel AS id_api_hotels_hub_hotel_16
FROM
  hotel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.street AS street_4, t0.building_number AS building_number_5, t0.postal_code AS postal_code_6, t0.city AS city_7, t0.room_count AS room_count_8, t0.stars_number AS stars_number_9, t0.geo_lat AS geo_lat_10, t0.geo_lng AS geo_lng_11, t0.url AS url_12, t0.is_imported AS is_imported_13, t0.is_edited_by_admin AS is_edited_by_admin_14, t0.id_image_file_repository AS id_image_file_repository_15, t0.id_api_hotels_hub_hotel AS id_api_hotels_hub_hotel_16 FROM hotel t0 WHERE t0.id = 3;

SELECT
  r0_.id AS id_0,
  r0_.system_name AS system_name_1,
  r0_.full_name AS full_name_2,
  r0_.position_title AS position_title_3,
  r0_.content AS content_4,
  r0_.sort_order AS sort_order_5,
  r0_.id_hotel AS id_hotel_6
FROM
  review r0_
ORDER BY
  r0_.sort_order ASC,
  r0_.id DESC
LIMIT
  6

SELECT r0_.id AS id_0, r0_.system_name AS system_name_1, r0_.full_name AS full_name_2, r0_.position_title AS position_title_3, r0_.content AS content_4, r0_.sort_order AS sort_order_5, r0_.id_hotel AS id_hotel_6 FROM review r0_ ORDER BY r0_.sort_order ASC, r0_.id DESC LIMIT 6;

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.lead AS lead_2,
  m0_.content AS content_3,
  m0_.slug AS slug_4,
  m0_.published_at AS published_at_5,
  m0_.is_active AS is_active_6,
  m0_.id_module_multilang_entry AS id_module_multilang_entry_7,
  m0_.id_category AS id_category_8,
  m0_.id_image_file_repository AS id_image_file_repository_9
FROM
  module_article m0_
  INNER JOIN module_multilang_entry m1_ ON m0_.id_module_multilang_entry = m1_.id
  INNER JOIN module_multilang_entry_lang m2_ ON m1_.id = m2_.id_module_multilang_entry
WHERE
  (
    m2_.lang = ?
    AND m2_.content_edited = 1
  )
  AND m0_.is_active = 1
ORDER BY
  m0_.published_at DESC
LIMIT
  3

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.lead AS lead_2, m0_.content AS content_3, m0_.slug AS slug_4, m0_.published_at AS published_at_5, m0_.is_active AS is_active_6, m0_.id_module_multilang_entry AS id_module_multilang_entry_7, m0_.id_category AS id_category_8, m0_.id_image_file_repository AS id_image_file_repository_9 FROM module_article m0_ INNER JOIN module_multilang_entry m1_ ON m0_.id_module_multilang_entry = m1_.id INNER JOIN module_multilang_entry_lang m2_ ON m1_.id = m2_.id_module_multilang_entry WHERE (m2_.lang = 'pl' AND m2_.content_edited = 1) AND m0_.is_active = 1 ORDER BY m0_.published_at DESC LIMIT 3;

SELECT
  m0_.id AS id_0,
  m0_.url AS url_1,
  m0_.position AS position_2,
  m0_.id_module_multilang_entry AS id_module_multilang_entry_3,
  m0_.id_logo AS id_logo_4
FROM
  module_recommendations m0_
  INNER JOIN module_multilang_entry m1_ ON m0_.id_module_multilang_entry = m1_.id
  INNER JOIN module_multilang_entry_lang m2_ ON m1_.id = m2_.id_module_multilang_entry
WHERE
  m2_.lang = ?
  AND m2_.content_edited = 1
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.url AS url_1, m0_.position AS position_2, m0_.id_module_multilang_entry AS id_module_multilang_entry_3, m0_.id_logo AS id_logo_4 FROM module_recommendations m0_ INNER JOIN module_multilang_entry m1_ ON m0_.id_module_multilang_entry = m1_.id INNER JOIN module_multilang_entry_lang m2_ ON m1_.id = m2_.id_module_multilang_entry WHERE m2_.lang = 'pl' AND m2_.content_edited = 1 ORDER BY m0_.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_
  INNER JOIN structure_element s1_ ON s0_.id = s1_.id_structure
WHERE
  s0_.lang = ?
  AND s1_.content_type = ?
ORDER BY
  s0_.lft ASC,
  s1_.position ASC
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_ INNER JOIN structure_element s1_ ON s0_.id = s1_.id_structure WHERE s0_.lang = 'pl' AND s1_.content_type = 101 ORDER BY s0_.lft ASC, s1_.position ASC 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(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
  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_;