Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.salutation AS salutation_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.password AS password_6,
  t0.password_reset_token AS password_reset_token_7,
  t0.password_reset_requested_at AS password_reset_requested_at_8,
  t0.enabled AS enabled_9,
  t0.signature_path AS signature_path_10,
  t0.signature_updated_at AS signature_updated_at_11,
  t0.phone1 AS phone1_12,
  t0.phone2 AS phone2_13,
  t0.is_examiner AS is_examiner_14,
  t0.is_technician AS is_technician_15,
  t0.is_service_worker AS is_service_worker_16,
  t0.is_superadmin AS is_superadmin_17,
  t0.created_at AS created_at_18,
  t0.archived_at AS archived_at_19,
  t0.wocken_salesperson_code AS wocken_salesperson_code_20,
  t0.intranet_user AS intranet_user_21,
  t0.wocken_catalog_enabled AS wocken_catalog_enabled_22,
  t0.wocken_catalog_full_access AS wocken_catalog_full_access_23,
  t0.wocken_catalog_categories AS wocken_catalog_categories_24,
  t0.wocken_person_code AS wocken_person_code_25,
  t0.wocken_superior AS wocken_superior_26,
  t0.wocken_catalog_budget_enabled AS wocken_catalog_budget_enabled_27,
  t0.wocken_catalog_budget_amount AS wocken_catalog_budget_amount_28,
  t0.wocken_catalog_budget_time_unit AS wocken_catalog_budget_time_unit_29,
  t0.wocken_catalog_supervisor_user_id AS wocken_catalog_supervisor_user_id_30
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.salutation AS salutation_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.password AS password_6, t0.password_reset_token AS password_reset_token_7, t0.password_reset_requested_at AS password_reset_requested_at_8, t0.enabled AS enabled_9, t0.signature_path AS signature_path_10, t0.signature_updated_at AS signature_updated_at_11, t0.phone1 AS phone1_12, t0.phone2 AS phone2_13, t0.is_examiner AS is_examiner_14, t0.is_technician AS is_technician_15, t0.is_service_worker AS is_service_worker_16, t0.is_superadmin AS is_superadmin_17, t0.created_at AS created_at_18, t0.archived_at AS archived_at_19, t0.wocken_salesperson_code AS wocken_salesperson_code_20, t0.intranet_user AS intranet_user_21, t0.wocken_catalog_enabled AS wocken_catalog_enabled_22, t0.wocken_catalog_full_access AS wocken_catalog_full_access_23, t0.wocken_catalog_categories AS wocken_catalog_categories_24, t0.wocken_person_code AS wocken_person_code_25, t0.wocken_superior AS wocken_superior_26, t0.wocken_catalog_budget_enabled AS wocken_catalog_budget_enabled_27, t0.wocken_catalog_budget_amount AS wocken_catalog_budget_amount_28, t0.wocken_catalog_budget_time_unit AS wocken_catalog_budget_time_unit_29, t0.wocken_catalog_supervisor_user_id AS wocken_catalog_supervisor_user_id_30 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.role AS role_3,
  t0.created_at AS created_at_4,
  t0.archived_at AS archived_at_5,
  t0.all_cost_centers AS all_cost_centers_6,
  t0.can_access_all_types AS can_access_all_types_7,
  t0.accessible_types AS accessible_types_8,
  t0.reminding_enabled AS reminding_enabled_9,
  t0.is_laborfreigabe AS is_laborfreigabe_10,
  t0.is_cert_mailing_enabled AS is_cert_mailing_enabled_11,
  t0.wocken_contact_number AS wocken_contact_number_12,
  t0.user_id AS user_id_13,
  t0.debitor_id AS debitor_id_14,
  t0.site_id AS site_id_15
FROM
  debitor_user_debitor_connection t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.role AS role_3, t0.created_at AS created_at_4, t0.archived_at AS archived_at_5, t0.all_cost_centers AS all_cost_centers_6, t0.can_access_all_types AS can_access_all_types_7, t0.accessible_types AS accessible_types_8, t0.reminding_enabled AS reminding_enabled_9, t0.is_laborfreigabe AS is_laborfreigabe_10, t0.is_cert_mailing_enabled AS is_cert_mailing_enabled_11, t0.wocken_contact_number AS wocken_contact_number_12, t0.user_id AS user_id_13, t0.debitor_id AS debitor_id_14, t0.site_id AS site_id_15 FROM debitor_user_debitor_connection t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.enabled AS enabled_2,
  t0.role AS role_3,
  t0.created_at AS created_at_4,
  t0.archived_at AS archived_at_5,
  t0.all_cost_centers AS all_cost_centers_6,
  t0.can_access_all_types AS can_access_all_types_7,
  t0.accessible_types AS accessible_types_8,
  t0.reminding_enabled AS reminding_enabled_9,
  t0.is_laborfreigabe AS is_laborfreigabe_10,
  t0.is_cert_mailing_enabled AS is_cert_mailing_enabled_11,
  t0.wocken_contact_number AS wocken_contact_number_12,
  t0.user_id AS user_id_13,
  t0.debitor_id AS debitor_id_14,
  t0.site_id AS site_id_15
FROM
  debitor_user_debitor_connection t0
WHERE
  t0.user_id IS NULL

SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.role AS role_3, t0.created_at AS created_at_4, t0.archived_at AS archived_at_5, t0.all_cost_centers AS all_cost_centers_6, t0.can_access_all_types AS can_access_all_types_7, t0.accessible_types AS accessible_types_8, t0.reminding_enabled AS reminding_enabled_9, t0.is_laborfreigabe AS is_laborfreigabe_10, t0.is_cert_mailing_enabled AS is_cert_mailing_enabled_11, t0.wocken_contact_number AS wocken_contact_number_12, t0.user_id AS user_id_13, t0.debitor_id AS debitor_id_14, t0.site_id AS site_id_15 FROM debitor_user_debitor_connection t0 WHERE t0.user_id IS NULL;

SELECT
  DISTINCT u0_.id AS id_0
FROM
  user u0_
  LEFT JOIN debitor_user_debitor_connection d1_ ON u0_.id = d1_.user_id
  LEFT JOIN debitor d2_ ON d1_.debitor_id = d2_.id
  LEFT JOIN debitor_user_debitor_connection_has_cost_center d4_ ON d1_.id = d4_.user_debitor_connection_id
  LEFT JOIN debitor_cost_center d3_ ON d3_.id = d4_.cost_center_id
  LEFT JOIN contractor_user_contractor_connection c5_ ON u0_.id = c5_.user_id
  LEFT JOIN contractor c6_ ON c5_.contractor_id = c6_.id
WHERE
  u0_.enabled = ?
LIMIT
  20

SELECT DISTINCT u0_.id AS id_0 FROM user u0_ LEFT JOIN debitor_user_debitor_connection d1_ ON u0_.id = d1_.user_id LEFT JOIN debitor d2_ ON d1_.debitor_id = d2_.id LEFT JOIN debitor_user_debitor_connection_has_cost_center d4_ ON d1_.id = d4_.user_debitor_connection_id LEFT JOIN debitor_cost_center d3_ ON d3_.id = d4_.cost_center_id LEFT JOIN contractor_user_contractor_connection c5_ ON u0_.id = c5_.user_id LEFT JOIN contractor c6_ ON c5_.contractor_id = c6_.id WHERE u0_.enabled = 1 LIMIT 20;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.salutation AS salutation_2,
  u0_.firstname AS firstname_3,
  u0_.lastname AS lastname_4,
  u0_.password AS password_5,
  u0_.password_reset_token AS password_reset_token_6,
  u0_.password_reset_requested_at AS password_reset_requested_at_7,
  u0_.enabled AS enabled_8,
  u0_.signature_path AS signature_path_9,
  u0_.signature_updated_at AS signature_updated_at_10,
  u0_.phone1 AS phone1_11,
  u0_.phone2 AS phone2_12,
  u0_.is_examiner AS is_examiner_13,
  u0_.is_technician AS is_technician_14,
  u0_.is_service_worker AS is_service_worker_15,
  u0_.is_superadmin AS is_superadmin_16,
  u0_.created_at AS created_at_17,
  u0_.archived_at AS archived_at_18,
  u0_.wocken_salesperson_code AS wocken_salesperson_code_19,
  u0_.intranet_user AS intranet_user_20,
  u0_.wocken_catalog_enabled AS wocken_catalog_enabled_21,
  u0_.wocken_catalog_full_access AS wocken_catalog_full_access_22,
  u0_.wocken_catalog_categories AS wocken_catalog_categories_23,
  u0_.wocken_person_code AS wocken_person_code_24,
  u0_.wocken_superior AS wocken_superior_25,
  u0_.wocken_catalog_budget_enabled AS wocken_catalog_budget_enabled_26,
  u0_.wocken_catalog_budget_amount AS wocken_catalog_budget_amount_27,
  u0_.wocken_catalog_budget_time_unit AS wocken_catalog_budget_time_unit_28,
  d1_.id AS id_29,
  d1_.enabled AS enabled_30,
  d1_.role AS role_31,
  d1_.created_at AS created_at_32,
  d1_.archived_at AS archived_at_33,
  d1_.all_cost_centers AS all_cost_centers_34,
  d1_.can_access_all_types AS can_access_all_types_35,
  d1_.accessible_types AS accessible_types_36,
  d1_.reminding_enabled AS reminding_enabled_37,
  d1_.is_laborfreigabe AS is_laborfreigabe_38,
  d1_.is_cert_mailing_enabled AS is_cert_mailing_enabled_39,
  d1_.wocken_contact_number AS wocken_contact_number_40,
  d2_.id AS id_41,
  d2_.number AS number_42,
  d2_.name AS name_43,
  d2_.custom_name AS custom_name_44,
  d2_.name_suffix AS name_suffix_45,
  d2_.address_line1 AS address_line1_46,
  d2_.address_line2 AS address_line2_47,
  d2_.address_zipcode AS address_zipcode_48,
  d2_.address_city AS address_city_49,
  d2_.address_country AS address_country_50,
  d2_.phone1 AS phone1_51,
  d2_.phone2 AS phone2_52,
  d2_.email AS email_53,
  d2_.url AS url_54,
  d2_.logo_path AS logo_path_55,
  d2_.logo_updated_at AS logo_updated_at_56,
  d2_.created_at AS created_at_57,
  d2_.archived_at AS archived_at_58,
  d2_.wocken_salesperson_code AS wocken_salesperson_code_59,
  d2_.wocken_catalog_default_categories AS wocken_catalog_default_categories_60,
  d2_.wocken_catalog_enabled AS wocken_catalog_enabled_61,
  d3_.id AS id_62,
  d3_.name AS name_63,
  d3_.number AS number_64,
  c4_.id AS id_65,
  c4_.enabled AS enabled_66,
  c4_.role AS role_67,
  c4_.created_at AS created_at_68,
  c4_.archived_at AS archived_at_69,
  c4_.accessible_types AS accessible_types_70,
  c5_.id AS id_71,
  c5_.number AS number_72,
  c5_.name AS name_73,
  c5_.custom_name AS custom_name_74,
  c5_.name_suffix AS name_suffix_75,
  c5_.address_line1 AS address_line1_76,
  c5_.address_line2 AS address_line2_77,
  c5_.address_zipcode AS address_zipcode_78,
  c5_.address_city AS address_city_79,
  c5_.address_country AS address_country_80,
  c5_.phone1 AS phone1_81,
  c5_.phone2 AS phone2_82,
  c5_.email AS email_83,
  c5_.url AS url_84,
  c5_.logo_path AS logo_path_85,
  c5_.logo_updated_at AS logo_updated_at_86,
  c5_.created_at AS created_at_87,
  c5_.archived_at AS archived_at_88,
  u0_.wocken_catalog_supervisor_user_id AS wocken_catalog_supervisor_user_id_89,
  d1_.user_id AS user_id_90,
  d1_.debitor_id AS debitor_id_91,
  d1_.site_id AS site_id_92,
  d3_.debitor_id AS debitor_id_93,
  c4_.user_id AS user_id_94,
  c4_.contractor_id AS contractor_id_95
FROM
  user u0_
  LEFT JOIN debitor_user_debitor_connection d1_ ON u0_.id = d1_.user_id
  LEFT JOIN debitor d2_ ON d1_.debitor_id = d2_.id
  LEFT JOIN debitor_user_debitor_connection_has_cost_center d6_ ON d1_.id = d6_.user_debitor_connection_id
  LEFT JOIN debitor_cost_center d3_ ON d3_.id = d6_.cost_center_id
  LEFT JOIN contractor_user_contractor_connection c4_ ON u0_.id = c4_.user_id
  LEFT JOIN contractor c5_ ON c4_.contractor_id = c5_.id
WHERE
  u0_.enabled = ?
  AND u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.salutation AS salutation_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.password AS password_5, u0_.password_reset_token AS password_reset_token_6, u0_.password_reset_requested_at AS password_reset_requested_at_7, u0_.enabled AS enabled_8, u0_.signature_path AS signature_path_9, u0_.signature_updated_at AS signature_updated_at_10, u0_.phone1 AS phone1_11, u0_.phone2 AS phone2_12, u0_.is_examiner AS is_examiner_13, u0_.is_technician AS is_technician_14, u0_.is_service_worker AS is_service_worker_15, u0_.is_superadmin AS is_superadmin_16, u0_.created_at AS created_at_17, u0_.archived_at AS archived_at_18, u0_.wocken_salesperson_code AS wocken_salesperson_code_19, u0_.intranet_user AS intranet_user_20, u0_.wocken_catalog_enabled AS wocken_catalog_enabled_21, u0_.wocken_catalog_full_access AS wocken_catalog_full_access_22, u0_.wocken_catalog_categories AS wocken_catalog_categories_23, u0_.wocken_person_code AS wocken_person_code_24, u0_.wocken_superior AS wocken_superior_25, u0_.wocken_catalog_budget_enabled AS wocken_catalog_budget_enabled_26, u0_.wocken_catalog_budget_amount AS wocken_catalog_budget_amount_27, u0_.wocken_catalog_budget_time_unit AS wocken_catalog_budget_time_unit_28, d1_.id AS id_29, d1_.enabled AS enabled_30, d1_.role AS role_31, d1_.created_at AS created_at_32, d1_.archived_at AS archived_at_33, d1_.all_cost_centers AS all_cost_centers_34, d1_.can_access_all_types AS can_access_all_types_35, d1_.accessible_types AS accessible_types_36, d1_.reminding_enabled AS reminding_enabled_37, d1_.is_laborfreigabe AS is_laborfreigabe_38, d1_.is_cert_mailing_enabled AS is_cert_mailing_enabled_39, d1_.wocken_contact_number AS wocken_contact_number_40, d2_.id AS id_41, d2_.number AS number_42, d2_.name AS name_43, d2_.custom_name AS custom_name_44, d2_.name_suffix AS name_suffix_45, d2_.address_line1 AS address_line1_46, d2_.address_line2 AS address_line2_47, d2_.address_zipcode AS address_zipcode_48, d2_.address_city AS address_city_49, d2_.address_country AS address_country_50, d2_.phone1 AS phone1_51, d2_.phone2 AS phone2_52, d2_.email AS email_53, d2_.url AS url_54, d2_.logo_path AS logo_path_55, d2_.logo_updated_at AS logo_updated_at_56, d2_.created_at AS created_at_57, d2_.archived_at AS archived_at_58, d2_.wocken_salesperson_code AS wocken_salesperson_code_59, d2_.wocken_catalog_default_categories AS wocken_catalog_default_categories_60, d2_.wocken_catalog_enabled AS wocken_catalog_enabled_61, d3_.id AS id_62, d3_.name AS name_63, d3_.number AS number_64, c4_.id AS id_65, c4_.enabled AS enabled_66, c4_.role AS role_67, c4_.created_at AS created_at_68, c4_.archived_at AS archived_at_69, c4_.accessible_types AS accessible_types_70, c5_.id AS id_71, c5_.number AS number_72, c5_.name AS name_73, c5_.custom_name AS custom_name_74, c5_.name_suffix AS name_suffix_75, c5_.address_line1 AS address_line1_76, c5_.address_line2 AS address_line2_77, c5_.address_zipcode AS address_zipcode_78, c5_.address_city AS address_city_79, c5_.address_country AS address_country_80, c5_.phone1 AS phone1_81, c5_.phone2 AS phone2_82, c5_.email AS email_83, c5_.url AS url_84, c5_.logo_path AS logo_path_85, c5_.logo_updated_at AS logo_updated_at_86, c5_.created_at AS created_at_87, c5_.archived_at AS archived_at_88, u0_.wocken_catalog_supervisor_user_id AS wocken_catalog_supervisor_user_id_89, d1_.user_id AS user_id_90, d1_.debitor_id AS debitor_id_91, d1_.site_id AS site_id_92, d3_.debitor_id AS debitor_id_93, c4_.user_id AS user_id_94, c4_.contractor_id AS contractor_id_95 FROM user u0_ LEFT JOIN debitor_user_debitor_connection d1_ ON u0_.id = d1_.user_id LEFT JOIN debitor d2_ ON d1_.debitor_id = d2_.id LEFT JOIN debitor_user_debitor_connection_has_cost_center d6_ ON d1_.id = d6_.user_debitor_connection_id LEFT JOIN debitor_cost_center d3_ ON d3_.id = d6_.cost_center_id LEFT JOIN contractor_user_contractor_connection c4_ ON u0_.id = c4_.user_id LEFT JOIN contractor c5_ ON c4_.contractor_id = c5_.id WHERE u0_.enabled = 1 AND u0_.id IN (1, 43, 44, 45, 46, 47, 48, 49, 51, 52, 53, 54, 55, 56, 57, 59, 60, 61, 62);

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN debitor_user_debitor_connection d1_ ON u0_.id = d1_.user_id
  LEFT JOIN debitor d2_ ON d1_.debitor_id = d2_.id
  LEFT JOIN debitor_user_debitor_connection_has_cost_center d4_ ON d1_.id = d4_.user_debitor_connection_id
  LEFT JOIN debitor_cost_center d3_ ON d3_.id = d4_.cost_center_id
  LEFT JOIN contractor_user_contractor_connection c5_ ON u0_.id = c5_.user_id
  LEFT JOIN contractor c6_ ON c5_.contractor_id = c6_.id
WHERE
  u0_.enabled = ?

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN debitor_user_debitor_connection d1_ ON u0_.id = d1_.user_id LEFT JOIN debitor d2_ ON d1_.debitor_id = d2_.id LEFT JOIN debitor_user_debitor_connection_has_cost_center d4_ ON d1_.id = d4_.user_debitor_connection_id LEFT JOIN debitor_cost_center d3_ ON d3_.id = d4_.cost_center_id LEFT JOIN contractor_user_contractor_connection c5_ ON u0_.id = c5_.user_id LEFT JOIN contractor c6_ ON c5_.contractor_id = c6_.id WHERE u0_.enabled = 1;

SELECT
  COUNT(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM user u0_;

SELECT
  COUNT(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.enabled = 1

SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.enabled = 1;

SELECT
  d0_.id AS id_0,
  d0_.number AS number_1,
  d0_.name AS name_2,
  d0_.custom_name AS custom_name_3,
  d0_.name_suffix AS name_suffix_4,
  d0_.address_line1 AS address_line1_5,
  d0_.address_line2 AS address_line2_6,
  d0_.address_zipcode AS address_zipcode_7,
  d0_.address_city AS address_city_8,
  d0_.address_country AS address_country_9,
  d0_.phone1 AS phone1_10,
  d0_.phone2 AS phone2_11,
  d0_.email AS email_12,
  d0_.url AS url_13,
  d0_.logo_path AS logo_path_14,
  d0_.logo_updated_at AS logo_updated_at_15,
  d0_.created_at AS created_at_16,
  d0_.archived_at AS archived_at_17,
  d0_.wocken_salesperson_code AS wocken_salesperson_code_18,
  d0_.wocken_catalog_default_categories AS wocken_catalog_default_categories_19,
  d0_.wocken_catalog_enabled AS wocken_catalog_enabled_20
FROM
  debitor d0_
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.number AS number_1, d0_.name AS name_2, d0_.custom_name AS custom_name_3, d0_.name_suffix AS name_suffix_4, d0_.address_line1 AS address_line1_5, d0_.address_line2 AS address_line2_6, d0_.address_zipcode AS address_zipcode_7, d0_.address_city AS address_city_8, d0_.address_country AS address_country_9, d0_.phone1 AS phone1_10, d0_.phone2 AS phone2_11, d0_.email AS email_12, d0_.url AS url_13, d0_.logo_path AS logo_path_14, d0_.logo_updated_at AS logo_updated_at_15, d0_.created_at AS created_at_16, d0_.archived_at AS archived_at_17, d0_.wocken_salesperson_code AS wocken_salesperson_code_18, d0_.wocken_catalog_default_categories AS wocken_catalog_default_categories_19, d0_.wocken_catalog_enabled AS wocken_catalog_enabled_20 FROM debitor d0_ ORDER BY d0_.name ASC;