Symfony Profiler

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_.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 = 1;

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 = 1;

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_.server_id = ?

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_.server_id = 15;

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.org' OR s0_.http_host = 'www.virtualrealitycommerce.org';

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
  p0_.product_id AS product_id_0,
  p0_.product_key AS product_key_1,
  p0_.ean AS ean_2,
  p0_.erpkey AS erpkey_3,
  p0_.parent_product_id AS parent_product_id_4,
  p0_.product_name AS product_name_5,
  p0_.product_description AS product_description_6,
  p0_.product_short_description AS product_short_description_7,
  p0_.image1 AS image1_8,
  p0_.image2 AS image2_9,
  p0_.image3 AS image3_10,
  p0_.is_active AS is_active_11,
  p0_.active_from AS active_from_12,
  p0_.active_to AS active_to_13,
  p0_.unit_name AS unit_name_14,
  p0_.marketplace_department_id AS marketplace_department_id_15,
  p0_.product_link AS product_link_16,
  p0_.viewed_count AS viewed_count_17,
  p0_.clicked_count AS clicked_count_18,
  p0_.product_vat AS product_vat_19,
  p0_.stock AS stock_20,
  p0_.title_seo AS title_seo_21,
  p0_.keywords_seo AS keywords_seo_22,
  p0_.priority AS priority_23,
  p0_.pieces_in_pack AS pieces_in_pack_24,
  p0_.pack_price AS pack_price_25,
  p0_.is_strict_pack_sale AS is_strict_pack_sale_26,
  p0_.product_model_link AS product_model_link_27,
  p0_.manufacturer AS manufacturer_28,
  p0_.gallery3d_id AS gallery3d_id_29,
  p0_.minimal_amount AS minimal_amount_30
FROM
  product p0_
  INNER JOIN product_department p2_ ON p0_.product_id = p2_.product_id
  INNER JOIN department d1_ ON d1_.department_id = p2_.department_id
WHERE
  d1_.department_id IN (?)
LIMIT
  6

SELECT p0_.product_id AS product_id_0, p0_.product_key AS product_key_1, p0_.ean AS ean_2, p0_.erpkey AS erpkey_3, p0_.parent_product_id AS parent_product_id_4, p0_.product_name AS product_name_5, p0_.product_description AS product_description_6, p0_.product_short_description AS product_short_description_7, p0_.image1 AS image1_8, p0_.image2 AS image2_9, p0_.image3 AS image3_10, p0_.is_active AS is_active_11, p0_.active_from AS active_from_12, p0_.active_to AS active_to_13, p0_.unit_name AS unit_name_14, p0_.marketplace_department_id AS marketplace_department_id_15, p0_.product_link AS product_link_16, p0_.viewed_count AS viewed_count_17, p0_.clicked_count AS clicked_count_18, p0_.product_vat AS product_vat_19, p0_.stock AS stock_20, p0_.title_seo AS title_seo_21, p0_.keywords_seo AS keywords_seo_22, p0_.priority AS priority_23, p0_.pieces_in_pack AS pieces_in_pack_24, p0_.pack_price AS pack_price_25, p0_.is_strict_pack_sale AS is_strict_pack_sale_26, p0_.product_model_link AS product_model_link_27, p0_.manufacturer AS manufacturer_28, p0_.gallery3d_id AS gallery3d_id_29, p0_.minimal_amount AS minimal_amount_30 FROM product p0_ INNER JOIN product_department p2_ ON p0_.product_id = p2_.product_id INNER JOIN department d1_ ON d1_.department_id = p2_.department_id WHERE d1_.department_id IN (3) LIMIT 6;

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 = 3;

SELECT
  s0_.service_id AS service_id_0,
  s0_.service_name AS service_name_1,
  s0_.action AS action_2,
  s0_.service_type AS service_type_3,
  s0_.is_live AS is_live_4,
  s0_.image AS image_5,
  s0_.importance AS importance_6,
  s0_.trial_months AS trial_months_7,
  s0_.landing_url AS landing_url_8,
  s0_.register_url AS register_url_9,
  s0_.price AS price_10,
  s0_.background_image AS background_image_11
FROM
  service s0_
WHERE
  s0_.service_id = ?

SELECT s0_.service_id AS service_id_0, s0_.service_name AS service_name_1, s0_.action AS action_2, s0_.service_type AS service_type_3, s0_.is_live AS is_live_4, s0_.image AS image_5, s0_.importance AS importance_6, s0_.trial_months AS trial_months_7, s0_.landing_url AS landing_url_8, s0_.register_url AS register_url_9, s0_.price AS price_10, s0_.background_image AS background_image_11 FROM service s0_ WHERE s0_.service_id = 4;

SELECT
  t0.service_id AS service_id_1,
  t0.service_name AS service_name_2,
  t0.action AS action_3,
  t0.service_type AS service_type_4,
  t0.is_live AS is_live_5,
  t0.image AS image_6,
  t0.importance AS importance_7,
  t0.trial_months AS trial_months_8,
  t0.landing_url AS landing_url_9,
  t0.register_url AS register_url_10,
  t0.price AS price_11,
  t0.background_image AS background_image_12
FROM
  service t0
  INNER JOIN server_service ON t0.service_id = server_service.service_id
WHERE
  server_service.server_id = ?

SELECT t0.service_id AS service_id_1, t0.service_name AS service_name_2, t0.action AS action_3, t0.service_type AS service_type_4, t0.is_live AS is_live_5, t0.image AS image_6, t0.importance AS importance_7, t0.trial_months AS trial_months_8, t0.landing_url AS landing_url_9, t0.register_url AS register_url_10, t0.price AS price_11, t0.background_image AS background_image_12 FROM service t0 INNER JOIN server_service ON t0.service_id = server_service.service_id WHERE server_service.server_id = 15;