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
  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
  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
  u0_.user_id AS user_id_0,
  u0_.user_name AS user_name_1,
  u0_.company AS company_2,
  u0_.email AS email_3,
  u0_.contact_person AS contact_person_4,
  u0_.contact_person_email AS contact_person_email_5,
  u0_.telephone AS telephone_6,
  u0_.psw AS psw_7,
  u0_.type AS type_8,
  u0_.notes AS notes_9,
  u0_.date_inserted AS date_inserted_10,
  u0_.last_login AS last_login_11,
  u0_.address AS address_12,
  u0_.invoice_address AS invoice_address_13,
  u0_.ico AS ico_14,
  u0_.preferred_language_id AS preferred_language_id_15,
  u0_.preferred_currency_id AS preferred_currency_id_16,
  u0_.preferred_payment_id AS preferred_payment_id_17,
  u0_.preferred_delivery_id AS preferred_delivery_id_18,
  u0_.business_model AS business_model_19,
  u0_.date_payment AS date_payment_20,
  u0_.responsible_admin_user_id AS responsible_admin_user_id_21,
  u0_.date_responsibility_given AS date_responsibility_given_22,
  u0_.status AS status_23,
  u0_.server_id AS server_id_24,
  u0_.area_id AS area_id_25,
  u0_.preferred_section_id AS preferred_section_id_26,
  u0_.avatar_url AS avatar_url_27,
  u0_.logo_url AS logo_url_28,
  u0_.preferred_section_id2 AS preferred_section_id2_29,
  u0_.character_set AS character_set_30,
  u0_.date_entities_updated AS date_entities_updated_31,
  u0_.database_host AS database_host_32,
  u0_.database_name AS database_name_33,
  u0_.database_user AS database_user_34,
  u0_.database_password AS database_password_35,
  u0_.bank_account AS bank_account_36
FROM
  user u0_
WHERE
  u0_.user_id = ?

SELECT u0_.user_id AS user_id_0, u0_.user_name AS user_name_1, u0_.company AS company_2, u0_.email AS email_3, u0_.contact_person AS contact_person_4, u0_.contact_person_email AS contact_person_email_5, u0_.telephone AS telephone_6, u0_.psw AS psw_7, u0_.type AS type_8, u0_.notes AS notes_9, u0_.date_inserted AS date_inserted_10, u0_.last_login AS last_login_11, u0_.address AS address_12, u0_.invoice_address AS invoice_address_13, u0_.ico AS ico_14, u0_.preferred_language_id AS preferred_language_id_15, u0_.preferred_currency_id AS preferred_currency_id_16, u0_.preferred_payment_id AS preferred_payment_id_17, u0_.preferred_delivery_id AS preferred_delivery_id_18, u0_.business_model AS business_model_19, u0_.date_payment AS date_payment_20, u0_.responsible_admin_user_id AS responsible_admin_user_id_21, u0_.date_responsibility_given AS date_responsibility_given_22, u0_.status AS status_23, u0_.server_id AS server_id_24, u0_.area_id AS area_id_25, u0_.preferred_section_id AS preferred_section_id_26, u0_.avatar_url AS avatar_url_27, u0_.logo_url AS logo_url_28, u0_.preferred_section_id2 AS preferred_section_id2_29, u0_.character_set AS character_set_30, u0_.date_entities_updated AS date_entities_updated_31, u0_.database_host AS database_host_32, u0_.database_name AS database_name_33, u0_.database_user AS database_user_34, u0_.database_password AS database_password_35, u0_.bank_account AS bank_account_36 FROM user u0_ WHERE u0_.user_id = 95;

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
  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
  w0_.content AS content_0,
  w0_.field AS field_1
FROM
  web_page_translation w0_
WHERE
  w0_.foreign_key = ?
  AND w0_.locale = ?
  AND w0_.object_class = ?

SELECT w0_.content AS content_0, w0_.field AS field_1 FROM web_page_translation w0_ WHERE w0_.foreign_key = '2' AND w0_.locale = 'en_US' AND w0_.object_class = 'App\\Entity\\WebPage';

SELECT
  t0.web_page_id AS web_page_id_1,
  t0.web_page_name AS web_page_name_2,
  t0.web_page_content AS web_page_content_3,
  t0.web_page_description AS web_page_description_4,
  t0.website_id AS website_id_5,
  t0.eshop_id AS eshop_id_6,
  t0.date_inserted AS date_inserted_7,
  t0.date_last_control AS date_last_control_8,
  t0.date_published AS date_published_9,
  t0.web_page_type AS web_page_type_10,
  t0.seo_title AS seo_title_11,
  t0.seo_description AS seo_description_12,
  t0.priority AS priority_13,
  t0.image_file AS image_file_14,
  t0.score AS score_15,
  t0.auction_hall_id AS auction_hall_id_16
FROM
  web_page t0
WHERE
  t0.web_page_id = ?

SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 WHERE t0.web_page_id = 5;

SELECT
  r0_.redaction_list_id AS redaction_list_id_0,
  r0_.redaction_list_name AS redaction_list_name_1,
  r0_.redaction_list_description AS redaction_list_description_2,
  r0_.is_public AS is_public_3,
  r0_.is_web_based AS is_web_based_4,
  r0_.date_created AS date_created_5,
  r0_.wepages_count AS wepages_count_6,
  r0_.thumb_width AS thumb_width_7,
  r0_.thumb_height AS thumb_height_8,
  r0_.priority AS priority_9,
  r0_.user_id AS user_id_10,
  r0_.score AS score_11,
  r0_.css_class AS css_class_12
FROM
  redaction_list r0_
WHERE
  r0_.redaction_list_id = ?

SELECT r0_.redaction_list_id AS redaction_list_id_0, r0_.redaction_list_name AS redaction_list_name_1, r0_.redaction_list_description AS redaction_list_description_2, r0_.is_public AS is_public_3, r0_.is_web_based AS is_web_based_4, r0_.date_created AS date_created_5, r0_.wepages_count AS wepages_count_6, r0_.thumb_width AS thumb_width_7, r0_.thumb_height AS thumb_height_8, r0_.priority AS priority_9, r0_.user_id AS user_id_10, r0_.score AS score_11, r0_.css_class AS css_class_12 FROM redaction_list r0_ WHERE r0_.redaction_list_id = 1;

SELECT
  t0.web_page_id AS web_page_id_1,
  t0.web_page_name AS web_page_name_2,
  t0.web_page_content AS web_page_content_3,
  t0.web_page_description AS web_page_description_4,
  t0.website_id AS website_id_5,
  t0.eshop_id AS eshop_id_6,
  t0.date_inserted AS date_inserted_7,
  t0.date_last_control AS date_last_control_8,
  t0.date_published AS date_published_9,
  t0.web_page_type AS web_page_type_10,
  t0.seo_title AS seo_title_11,
  t0.seo_description AS seo_description_12,
  t0.priority AS priority_13,
  t0.image_file AS image_file_14,
  t0.score AS score_15,
  t0.auction_hall_id AS auction_hall_id_16
FROM
  web_page t0
  INNER JOIN redaction_list_webpage ON t0.web_page_id = redaction_list_webpage.web_page_id
WHERE
  redaction_list_webpage.redaction_list_id = ?

SELECT t0.web_page_id AS web_page_id_1, t0.web_page_name AS web_page_name_2, t0.web_page_content AS web_page_content_3, t0.web_page_description AS web_page_description_4, t0.website_id AS website_id_5, t0.eshop_id AS eshop_id_6, t0.date_inserted AS date_inserted_7, t0.date_last_control AS date_last_control_8, t0.date_published AS date_published_9, t0.web_page_type AS web_page_type_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.priority AS priority_13, t0.image_file AS image_file_14, t0.score AS score_15, t0.auction_hall_id AS auction_hall_id_16 FROM web_page t0 INNER JOIN redaction_list_webpage ON t0.web_page_id = redaction_list_webpage.web_page_id WHERE redaction_list_webpage.redaction_list_id = 1;