Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_visible AS title_visible_3,
  t0.content_type AS content_type_4,
  t0.visibility AS visibility_5,
  t0.position AS position_6,
  t0.id_structure AS id_structure_7
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.title_visible AS title_visible_3, t0.content_type AS content_type_4, t0.visibility AS visibility_5, t0.position AS position_6, t0.id_structure AS id_structure_7 FROM structure_element t0 WHERE t0.id_structure = 115 ORDER BY t0.position ASC;

SELECT
  e0_.voivodeship AS voivodeship_0
FROM
  engineer_catalog e1_
  INNER JOIN engineer_catalog_voivodeship e0_ ON e1_.id = e0_.id_engineer_catalog
GROUP BY
  e0_.voivodeship

SELECT e0_.voivodeship AS voivodeship_0 FROM engineer_catalog e1_ INNER JOIN engineer_catalog_voivodeship e0_ ON e1_.id = e0_.id_engineer_catalog GROUP BY e0_.voivodeship;

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 = 'app_preloaded_og_meta_tags_description' 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 = '479';

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
  e0_.id AS id_0
FROM
  engineer_catalog e1_
  INNER JOIN engineer_catalog_specialization e2_ ON e1_.id = e2_.id_engineer_catalog
  INNER JOIN engineer_specialization e0_ ON e0_.id = e2_.id_engineer_specialization
GROUP BY
  e0_.id
ORDER BY
  e1_.first_name ASC,
  e1_.last_name ASC

SELECT e0_.id AS id_0 FROM engineer_catalog e1_ INNER JOIN engineer_catalog_specialization e2_ ON e1_.id = e2_.id_engineer_catalog INNER JOIN engineer_specialization e0_ ON e0_.id = e2_.id_engineer_specialization GROUP BY e0_.id ORDER BY e1_.first_name ASC, e1_.last_name ASC;

SELECT
  t0.voivodeship AS voivodeship_1,
  t0.id_engineer_catalog AS id_engineer_catalog_2
FROM
  engineer_catalog_voivodeship t0
WHERE
  t0.id_engineer_catalog = ?

SELECT t0.voivodeship AS voivodeship_1, t0.id_engineer_catalog AS id_engineer_catalog_2 FROM engineer_catalog_voivodeship t0 WHERE t0.id_engineer_catalog = '1';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3
FROM
  engineer_specialization t0
WHERE
  t0.id IN (?)
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3 FROM engineer_specialization t0 WHERE t0.id IN (2) ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_main AS is_main_3
FROM
  engineer_specialization t0
  INNER JOIN engineer_catalog_specialization ON t0.id = engineer_catalog_specialization.id_engineer_specialization
WHERE
  engineer_catalog_specialization.id_engineer_catalog = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_main AS is_main_3 FROM engineer_specialization t0 INNER JOIN engineer_catalog_specialization ON t0.id = engineer_catalog_specialization.id_engineer_specialization WHERE engineer_catalog_specialization.id_engineer_catalog = '1' ORDER BY t0.name ASC;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  engineer_catalog e0_
WHERE
  EXISTS (
    SELECT
      e1_.id
    FROM
      engineer_catalog e1_
      INNER JOIN engineer_catalog_specialization e3_ ON e1_.id = e3_.id_engineer_catalog
      INNER JOIN engineer_specialization e2_ ON e2_.id = e3_.id_engineer_specialization
    WHERE
      e1_.id = e0_.id
      AND e2_.id IN (?)
  )

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM engineer_catalog e0_ WHERE EXISTS (SELECT e1_.id FROM engineer_catalog e1_ INNER JOIN engineer_catalog_specialization e3_ ON e1_.id = e3_.id_engineer_catalog INNER JOIN engineer_specialization e2_ ON e2_.id = e3_.id_engineer_specialization WHERE e1_.id = e0_.id AND e2_.id IN (2));

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_.meta_title AS meta_title_7,
  s0_.meta_description AS meta_description_8,
  s0_.url AS url_9,
  s0_.lft AS lft_10,
  s0_.rgt AS rgt_11,
  s0_.depth AS depth_12,
  s0_.lang AS lang_13,
  s0_.slug AS slug_14,
  s0_.custom_slug AS custom_slug_15,
  s0_.updated_at AS updated_at_16,
  s0_.id_target AS id_target_17,
  s0_.id_page_header_image AS id_page_header_image_18,
  s0_.id_linked_to_main_lang_page AS id_linked_to_main_lang_page_19
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_.meta_title AS meta_title_7, s0_.meta_description AS meta_description_8, s0_.url AS url_9, s0_.lft AS lft_10, s0_.rgt AS rgt_11, s0_.depth AS depth_12, s0_.lang AS lang_13, s0_.slug AS slug_14, s0_.custom_slug AS custom_slug_15, s0_.updated_at AS updated_at_16, s0_.id_target AS id_target_17, s0_.id_page_header_image AS id_page_header_image_18, s0_.id_linked_to_main_lang_page AS id_linked_to_main_lang_page_19 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_.meta_title AS meta_title_7,
  s0_.meta_description AS meta_description_8,
  s0_.url AS url_9,
  s0_.lft AS lft_10,
  s0_.rgt AS rgt_11,
  s0_.depth AS depth_12,
  s0_.lang AS lang_13,
  s0_.slug AS slug_14,
  s0_.custom_slug AS custom_slug_15,
  s0_.updated_at AS updated_at_16,
  s0_.id_target AS id_target_17,
  s0_.id_page_header_image AS id_page_header_image_18,
  s0_.id_linked_to_main_lang_page AS id_linked_to_main_lang_page_19
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_.meta_title AS meta_title_7, s0_.meta_description AS meta_description_8, s0_.url AS url_9, s0_.lft AS lft_10, s0_.rgt AS rgt_11, s0_.depth AS depth_12, s0_.lang AS lang_13, s0_.slug AS slug_14, s0_.custom_slug AS custom_slug_15, s0_.updated_at AS updated_at_16, s0_.id_target AS id_target_17, s0_.id_page_header_image AS id_page_header_image_18, s0_.id_linked_to_main_lang_page AS id_linked_to_main_lang_page_19 FROM structure s0_ WHERE s0_.lang = 'pl' ORDER BY s0_.depth ASC, s0_.lft ASC;

SELECT
  e0_.id AS id_0,
  e0_.first_name AS first_name_1,
  e0_.last_name AS last_name_2,
  e0_.slug AS slug_3,
  e0_.description AS description_4,
  e0_.day_price AS day_price_5,
  e0_.image AS image_6,
  e0_.added_at AS added_at_7,
  e0_.id_main_engineer_specialization AS id_main_engineer_specialization_8
FROM
  engineer_catalog e0_
WHERE
  EXISTS (
    SELECT
      e1_.id
    FROM
      engineer_catalog e1_
      INNER JOIN engineer_catalog_specialization e3_ ON e1_.id = e3_.id_engineer_catalog
      INNER JOIN engineer_specialization e2_ ON e2_.id = e3_.id_engineer_specialization
    WHERE
      e1_.id = e0_.id
      AND e2_.id IN (?)
  )
  AND e0_.id IN (?, ?)
ORDER BY
  e0_.first_name ASC,
  e0_.last_name ASC

SELECT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2, e0_.slug AS slug_3, e0_.description AS description_4, e0_.day_price AS day_price_5, e0_.image AS image_6, e0_.added_at AS added_at_7, e0_.id_main_engineer_specialization AS id_main_engineer_specialization_8 FROM engineer_catalog e0_ WHERE EXISTS (SELECT e1_.id FROM engineer_catalog e1_ INNER JOIN engineer_catalog_specialization e3_ ON e1_.id = e3_.id_engineer_catalog INNER JOIN engineer_specialization e2_ ON e2_.id = e3_.id_engineer_specialization WHERE e1_.id = e0_.id AND e2_.id IN (2)) AND e0_.id IN ('1', '2') ORDER BY e0_.first_name ASC, e0_.last_name ASC;

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.first_name AS first_name_1,
  e0_.last_name AS last_name_2
FROM
  engineer_catalog e0_
WHERE
  EXISTS (
    SELECT
      e1_.id
    FROM
      engineer_catalog e1_
      INNER JOIN engineer_catalog_specialization e3_ ON e1_.id = e3_.id_engineer_catalog
      INNER JOIN engineer_specialization e2_ ON e2_.id = e3_.id_engineer_specialization
    WHERE
      e1_.id = e0_.id
      AND e2_.id IN (?)
  )
ORDER BY
  e0_.first_name ASC,
  e0_.last_name ASC
LIMIT
  10

SELECT DISTINCT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2 FROM engineer_catalog e0_ WHERE EXISTS (SELECT e1_.id FROM engineer_catalog e1_ INNER JOIN engineer_catalog_specialization e3_ ON e1_.id = e3_.id_engineer_catalog INNER JOIN engineer_specialization e2_ ON e2_.id = e3_.id_engineer_specialization WHERE e1_.id = e0_.id AND e2_.id IN (2)) ORDER BY e0_.first_name ASC, e0_.last_name ASC LIMIT 10;