Symfony Profiler

SELECT
  s0_.server_id AS server_id_0,
  s0_.http_host AS http_host_1,
  s0_.label AS label_2,
  s0_.preferred_area_id AS preferred_area_id_3,
  s0_.preferred_language_id AS preferred_language_id_4,
  s0_.preferred_currency_id AS preferred_currency_id_5,
  s0_.ftp_host AS ftp_host_6,
  s0_.ftp_user AS ftp_user_7,
  s0_.ftp_password AS ftp_password_8,
  s0_.file_path AS file_path_9,
  s0_.google_api_key AS google_api_key_10,
  s0_.parent_section_id AS parent_section_id_11,
  s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12,
  s0_.header_url AS header_url_13,
  s0_.footer_url AS footer_url_14,
  s0_.css_url AS css_url_15,
  s0_.meta_tags AS meta_tags_16,
  s0_.home_page_id AS home_page_id_17,
  s0_.landing_page_id AS landing_page_id_18,
  s0_.header_title AS header_title_19,
  s0_.is_shopping_agent AS is_shopping_agent_20,
  s0_.is_service_list AS is_service_list_21,
  s0_.date_start AS date_start_22,
  s0_.status_id AS status_id_23,
  s0_.address AS address_24,
  s0_.email AS email_25,
  s0_.logo_url AS logo_url_26
FROM
  server s0_
WHERE
  s0_.http_host = ?
  OR s0_.http_host = ?

SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.http_host = 'virtualrealitycommerce.eu' OR s0_.http_host = 'www.virtualrealitycommerce.eu';

SELECT
  s0_.server_id AS server_id_0,
  s0_.http_host AS http_host_1,
  s0_.label AS label_2,
  s0_.preferred_area_id AS preferred_area_id_3,
  s0_.preferred_language_id AS preferred_language_id_4,
  s0_.preferred_currency_id AS preferred_currency_id_5,
  s0_.ftp_host AS ftp_host_6,
  s0_.ftp_user AS ftp_user_7,
  s0_.ftp_password AS ftp_password_8,
  s0_.file_path AS file_path_9,
  s0_.google_api_key AS google_api_key_10,
  s0_.parent_section_id AS parent_section_id_11,
  s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12,
  s0_.header_url AS header_url_13,
  s0_.footer_url AS footer_url_14,
  s0_.css_url AS css_url_15,
  s0_.meta_tags AS meta_tags_16,
  s0_.home_page_id AS home_page_id_17,
  s0_.landing_page_id AS landing_page_id_18,
  s0_.header_title AS header_title_19,
  s0_.is_shopping_agent AS is_shopping_agent_20,
  s0_.is_service_list AS is_service_list_21,
  s0_.date_start AS date_start_22,
  s0_.status_id AS status_id_23,
  s0_.address AS address_24,
  s0_.email AS email_25,
  s0_.logo_url AS logo_url_26
FROM
  server s0_
WHERE
  s0_.label = ?

SELECT s0_.server_id AS server_id_0, s0_.http_host AS http_host_1, s0_.label AS label_2, s0_.preferred_area_id AS preferred_area_id_3, s0_.preferred_language_id AS preferred_language_id_4, s0_.preferred_currency_id AS preferred_currency_id_5, s0_.ftp_host AS ftp_host_6, s0_.ftp_user AS ftp_user_7, s0_.ftp_password AS ftp_password_8, s0_.file_path AS file_path_9, s0_.google_api_key AS google_api_key_10, s0_.parent_section_id AS parent_section_id_11, s0_.is_dedicated_header_footer AS is_dedicated_header_footer_12, s0_.header_url AS header_url_13, s0_.footer_url AS footer_url_14, s0_.css_url AS css_url_15, s0_.meta_tags AS meta_tags_16, s0_.home_page_id AS home_page_id_17, s0_.landing_page_id AS landing_page_id_18, s0_.header_title AS header_title_19, s0_.is_shopping_agent AS is_shopping_agent_20, s0_.is_service_list AS is_service_list_21, s0_.date_start AS date_start_22, s0_.status_id AS status_id_23, s0_.address AS address_24, s0_.email AS email_25, s0_.logo_url AS logo_url_26 FROM server s0_ WHERE s0_.label = 'virtualrealitycommerce.eu';

SELECT
  l0_.lang_id AS lang_id_0,
  l0_.lang_name AS lang_name_1,
  l0_.lang_key AS lang_key_2,
  l0_.is_live AS is_live_3
FROM
  language l0_

SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_;

SELECT
  c0_.currency_id AS currency_id_0,
  c0_.currency_name AS currency_name_1,
  c0_.currency_key AS currency_key_2,
  c0_.is_live AS is_live_3,
  c0_.rate_eur AS rate_eur_4
FROM
  currency c0_

SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_;

SELECT
  l0_.lang_id AS lang_id_0,
  l0_.lang_name AS lang_name_1,
  l0_.lang_key AS lang_key_2,
  l0_.is_live AS is_live_3
FROM
  language l0_
WHERE
  l0_.lang_id = ?

SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_ WHERE l0_.lang_id = 1;

SELECT
  c0_.currency_id AS currency_id_0,
  c0_.currency_name AS currency_name_1,
  c0_.currency_key AS currency_key_2,
  c0_.is_live AS is_live_3,
  c0_.rate_eur AS rate_eur_4
FROM
  currency c0_
WHERE
  c0_.currency_id = ?

SELECT c0_.currency_id AS currency_id_0, c0_.currency_name AS currency_name_1, c0_.currency_key AS currency_key_2, c0_.is_live AS is_live_3, c0_.rate_eur AS rate_eur_4 FROM currency c0_ WHERE c0_.currency_id = 1;

SELECT
  d0_.department_id AS department_id_0,
  d0_.department_key AS department_key_1,
  d0_.department_name AS department_name_2,
  d0_.department_description AS department_description_3,
  d0_.image1 AS image1_4,
  d0_.lft AS lft_5,
  d0_.lvl AS lvl_6,
  d0_.rgt AS rgt_7,
  d0_.root_id AS root_id_8,
  d0_.parent_id AS parent_id_9
FROM
  department d0_
WHERE
  d0_.department_id = ?

SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.department_id = '2';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '2' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  t0.department_id AS department_id_1,
  t0.department_key AS department_key_2,
  t0.department_name AS department_name_3,
  t0.department_description AS department_description_4,
  t0.image1 AS image1_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.root_id AS root_id_9,
  t0.parent_id AS parent_id_10
FROM
  department t0
WHERE
  t0.department_id = ?

SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = 2;

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '2' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.department_id AS department_id_0,
  d0_.department_key AS department_key_1,
  d0_.department_name AS department_name_2,
  d0_.department_description AS department_description_3,
  d0_.image1 AS image1_4,
  d0_.lft AS lft_5,
  d0_.lvl AS lvl_6,
  d0_.rgt AS rgt_7,
  d0_.root_id AS root_id_8,
  d0_.parent_id AS parent_id_9
FROM
  department d0_
WHERE
  d0_.lft <= 1
  AND d0_.rgt >= 50
  AND d0_.root_id = ?
ORDER BY
  d0_.lft ASC

SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.lft <= 1 AND d0_.rgt >= 50 AND d0_.root_id = 2 ORDER BY d0_.lft ASC;

SELECT
  t0.department_id AS department_id_1,
  t0.department_key AS department_key_2,
  t0.department_name AS department_name_3,
  t0.department_description AS department_description_4,
  t0.image1 AS image1_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.root_id AS root_id_9,
  t0.parent_id AS parent_id_10
FROM
  department t0
WHERE
  t0.department_id = ?

SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = 2;

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '2' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  l0_.lang_id AS lang_id_0,
  l0_.lang_name AS lang_name_1,
  l0_.lang_key AS lang_key_2,
  l0_.is_live AS is_live_3
FROM
  language l0_

SELECT l0_.lang_id AS lang_id_0, l0_.lang_name AS lang_name_1, l0_.lang_key AS lang_key_2, l0_.is_live AS is_live_3 FROM language l0_;

SELECT
  e0_.eshop_link_id AS eshop_link_id_0,
  e0_.eshop_link_name AS eshop_link_name_1,
  e0_.eshop_link_description AS eshop_link_description_2,
  e0_.eshop_link_url AS eshop_link_url_3,
  e0_.user_id AS user_id_4,
  e0_.eshop_link_type AS eshop_link_type_5,
  e0_.priority AS priority_6,
  e0_.status AS status_7,
  e0_.date_inserted AS date_inserted_8,
  e0_.date_last_control AS date_last_control_9,
  e0_.logo_url AS logo_url_10,
  e0_.notes AS notes_11,
  e0_.admin_user_id AS admin_user_id_12,
  e0_.eshop_link_email AS eshop_link_email_13,
  e0_.preferred_language_id AS preferred_language_id_14,
  e0_.cut_long_description AS cut_long_description_15,
  e0_.eshop_link_current AS eshop_link_current_16,
  e0_.viewed_count AS viewed_count_17,
  e0_.clicked_count AS clicked_count_18
FROM
  eshop_link e0_
  INNER JOIN eshop_link_department e2_ ON e0_.eshop_link_id = e2_.eshop_link_id
  INNER JOIN department d1_ ON d1_.department_id = e2_.department_id
WHERE
  d1_.department_id = ?

SELECT e0_.eshop_link_id AS eshop_link_id_0, e0_.eshop_link_name AS eshop_link_name_1, e0_.eshop_link_description AS eshop_link_description_2, e0_.eshop_link_url AS eshop_link_url_3, e0_.user_id AS user_id_4, e0_.eshop_link_type AS eshop_link_type_5, e0_.priority AS priority_6, e0_.status AS status_7, e0_.date_inserted AS date_inserted_8, e0_.date_last_control AS date_last_control_9, e0_.logo_url AS logo_url_10, e0_.notes AS notes_11, e0_.admin_user_id AS admin_user_id_12, e0_.eshop_link_email AS eshop_link_email_13, e0_.preferred_language_id AS preferred_language_id_14, e0_.cut_long_description AS cut_long_description_15, e0_.eshop_link_current AS eshop_link_current_16, e0_.viewed_count AS viewed_count_17, e0_.clicked_count AS clicked_count_18 FROM eshop_link e0_ INNER JOIN eshop_link_department e2_ ON e0_.eshop_link_id = e2_.eshop_link_id INNER JOIN department d1_ ON d1_.department_id = e2_.department_id WHERE d1_.department_id = '2';

SELECT
  d0_.department_id AS department_id_0,
  d0_.department_key AS department_key_1,
  d0_.department_name AS department_name_2,
  d0_.department_description AS department_description_3,
  d0_.image1 AS image1_4,
  d0_.lft AS lft_5,
  d0_.lvl AS lvl_6,
  d0_.rgt AS rgt_7,
  d0_.root_id AS root_id_8,
  d0_.parent_id AS parent_id_9
FROM
  department d0_
WHERE
  d0_.parent_id IS NULL
ORDER BY
  d0_.lft ASC

SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id IS NULL ORDER BY d0_.lft ASC;

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '1' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '3' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '4' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '5' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '6' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '7' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '8' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '9' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '10' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '11' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '12' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  t0.department_id AS department_id_1,
  t0.department_key AS department_key_2,
  t0.department_name AS department_name_3,
  t0.department_description AS department_description_4,
  t0.image1 AS image1_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.root_id AS root_id_9,
  t0.parent_id AS parent_id_10
FROM
  department t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.parent_id = 2 ORDER BY t0.lft ASC;

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '36' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '35' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '37' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '38' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '39' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '40' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '41' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '42' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '43' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '53' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '57' AND d0_.locale = 'en_US' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  t0.department_id AS department_id_1,
  t0.department_key AS department_key_2,
  t0.department_name AS department_name_3,
  t0.department_description AS department_description_4,
  t0.image1 AS image1_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.root_id AS root_id_9,
  t0.parent_id AS parent_id_10
FROM
  department t0
WHERE
  t0.department_id = ?

SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = 36;

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '36' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';

SELECT
  d0_.department_id AS department_id_0,
  d0_.department_key AS department_key_1,
  d0_.department_name AS department_name_2,
  d0_.department_description AS department_description_3,
  d0_.image1 AS image1_4,
  d0_.lft AS lft_5,
  d0_.lvl AS lvl_6,
  d0_.rgt AS rgt_7,
  d0_.root_id AS root_id_8,
  d0_.parent_id AS parent_id_9
FROM
  department d0_
WHERE
  d0_.parent_id = ?

SELECT d0_.department_id AS department_id_0, d0_.department_key AS department_key_1, d0_.department_name AS department_name_2, d0_.department_description AS department_description_3, d0_.image1 AS image1_4, d0_.lft AS lft_5, d0_.lvl AS lvl_6, d0_.rgt AS rgt_7, d0_.root_id AS root_id_8, d0_.parent_id AS parent_id_9 FROM department d0_ WHERE d0_.parent_id = 36;

SELECT
  t0.department_id AS department_id_1,
  t0.department_key AS department_key_2,
  t0.department_name AS department_name_3,
  t0.department_description AS department_description_4,
  t0.image1 AS image1_5,
  t0.lft AS lft_6,
  t0.lvl AS lvl_7,
  t0.rgt AS rgt_8,
  t0.root_id AS root_id_9,
  t0.parent_id AS parent_id_10
FROM
  department t0
WHERE
  t0.department_id = ?

SELECT t0.department_id AS department_id_1, t0.department_key AS department_key_2, t0.department_name AS department_name_3, t0.department_description AS department_description_4, t0.image1 AS image1_5, t0.lft AS lft_6, t0.lvl AS lvl_7, t0.rgt AS rgt_8, t0.root_id AS root_id_9, t0.parent_id AS parent_id_10 FROM department t0 WHERE t0.department_id = 35;

SELECT
  d0_.content AS content_0,
  d0_.field AS field_1
FROM
  department_translation d0_
WHERE
  d0_.foreign_key = ?
  AND d0_.locale = ?
  AND d0_.object_class = ?

SELECT d0_.content AS content_0, d0_.field AS field_1 FROM department_translation d0_ WHERE d0_.foreign_key = '35' AND d0_.locale = 'en' AND d0_.object_class = 'App\\Entity\\Department';