Symfony Profiler

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.system_user AS system_user_5,
  t0.invited AS invited_6,
  t0.removed AS removed_7,
  t0.failures AS failures_8,
  t0.id AS id_9,
  t0.tutorial_filter AS tutorial_filter_10,
  t0.tutorial_messenger AS tutorial_messenger_11,
  t0.tutorial_notifications AS tutorial_notifications_12,
  t0.tutorial_substances AS tutorial_substances_13,
  t0.settings_messenger_notification_sent AS settings_messenger_notification_sent_14,
  t0.token_string AS token_string_15,
  t0.token_expires AS token_expires_16,
  t17.created_at AS created_at_18,
  t17.updated_at AS updated_at_19,
  t17.title AS title_20,
  t17.first_name AS first_name_21,
  t17.sur_name AS sur_name_22,
  t17.notifications AS notifications_23,
  t17.id AS id_24,
  t17.user_id AS user_id_25
FROM
  security_user t0
  LEFT JOIN security_user_profile t17 ON t17.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.email AS email_3, t0.password AS password_4, t0.system_user AS system_user_5, t0.invited AS invited_6, t0.removed AS removed_7, t0.failures AS failures_8, t0.id AS id_9, t0.tutorial_filter AS tutorial_filter_10, t0.tutorial_messenger AS tutorial_messenger_11, t0.tutorial_notifications AS tutorial_notifications_12, t0.tutorial_substances AS tutorial_substances_13, t0.settings_messenger_notification_sent AS settings_messenger_notification_sent_14, t0.token_string AS token_string_15, t0.token_expires AS token_expires_16, t17.created_at AS created_at_18, t17.updated_at AS updated_at_19, t17.title AS title_20, t17.first_name AS first_name_21, t17.sur_name AS sur_name_22, t17.notifications AS notifications_23, t17.id AS id_24, t17.user_id AS user_id_25 FROM security_user t0 LEFT JOIN security_user_profile t17 ON t17.user_id = t0.id WHERE t0.id = 2;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  legal_entity_order_invoice l0_
  INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id
  INNER JOIN security_user s2_ ON l1_.user_id = s2_.id
WHERE
  (
    s2_.id = ?
    AND l0_.file_path IS NOT NULL
    AND l0_.hidden = 0
  )
  AND l0_._discr IN ('invoice')

SELECT COUNT(l0_.id) AS sclr_0 FROM legal_entity_order_invoice l0_ INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id INNER JOIN security_user s2_ ON l1_.user_id = s2_.id WHERE (s2_.id = 2 AND l0_.file_path IS NOT NULL AND l0_.hidden = 0) AND l0_._discr IN ('invoice');

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.visible_to_client AS visible_to_client_5,
  t0.system_group AS system_group_6,
  t0.id AS id_7
FROM
  security_group t0
  INNER JOIN _join_table_security_user_and_group ON t0.id = _join_table_security_user_and_group.group_id
WHERE
  _join_table_security_user_and_group.user_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.name AS name_3, t0.description AS description_4, t0.visible_to_client AS visible_to_client_5, t0.system_group AS system_group_6, t0.id AS id_7 FROM security_group t0 INNER JOIN _join_table_security_user_and_group ON t0.id = _join_table_security_user_and_group.group_id WHERE _join_table_security_user_and_group.user_id = 2;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.member AS member_3,
  t0.uuid AS uuid_4,
  t0.name AS name_5,
  t0.echa_name AS echa_name_6,
  t0.invited_ts AS invited_ts_7,
  t0.status AS status_8,
  t0.status_at AS status_at_9,
  t0.updates_blocked AS updates_blocked_10,
  t0.limited AS limited_11,
  t0.acronym AS acronym_12,
  t0.sanctioned AS sanctioned_13,
  t0.id AS id_14,
  t0.address_street1 AS address_street1_15,
  t0.address_street2 AS address_street2_16,
  t0.address_street3 AS address_street3_17,
  t0.address_zip_code AS address_zip_code_18,
  t0.address_city AS address_city_19,
  t0.address_country AS address_country_20,
  t0.licensing_company_name AS licensing_company_name_21,
  t0.licensing_only_representative AS licensing_only_representative_22,
  t0.licensing_principal AS licensing_principal_23,
  t0.licensing_purchase_order_number AS licensing_purchase_order_number_24,
  t0.licensing_sanctions_certification AS licensing_sanctions_certification_25,
  t0.licensing_sanctions_data AS licensing_sanctions_data_26,
  t0.licensing_sanctions_allow_transfer AS licensing_sanctions_allow_transfer_27,
  t0.licensing_address_street1 AS licensing_address_street1_28,
  t0.licensing_address_street2 AS licensing_address_street2_29,
  t0.licensing_address_street3 AS licensing_address_street3_30,
  t0.licensing_address_zip_code AS licensing_address_zip_code_31,
  t0.licensing_address_city AS licensing_address_city_32,
  t0.licensing_address_country AS licensing_address_country_33,
  t0.licensing_only_representative_address_street1 AS licensing_only_representative_address_street1_34,
  t0.licensing_only_representative_address_street2 AS licensing_only_representative_address_street2_35,
  t0.licensing_only_representative_address_street3 AS licensing_only_representative_address_street3_36,
  t0.licensing_only_representative_address_zip_code AS licensing_only_representative_address_zip_code_37,
  t0.licensing_only_representative_address_city AS licensing_only_representative_address_city_38,
  t0.licensing_only_representative_address_country AS licensing_only_representative_address_country_39,
  t0.licensing_licensee_first_name AS licensing_licensee_first_name_40,
  t0.licensing_licensee_sur_name AS licensing_licensee_sur_name_41,
  t0.licensing_licensee_job_title AS licensing_licensee_job_title_42,
  t0.licensing_licensee_email AS licensing_licensee_email_43,
  t0.licensing_contact_person_job_title AS licensing_contact_person_job_title_44,
  t0.licensing_contact_person_phone_number AS licensing_contact_person_phone_number_45,
  t0.licensing_contact_person_first_name AS licensing_contact_person_first_name_46,
  t0.licensing_contact_person_sur_name AS licensing_contact_person_sur_name_47,
  t0.licensing_contact_person_email AS licensing_contact_person_email_48,
  t0.licensing_postal_address_street1 AS licensing_postal_address_street1_49,
  t0.licensing_postal_address_street2 AS licensing_postal_address_street2_50,
  t0.licensing_postal_address_street3 AS licensing_postal_address_street3_51,
  t0.licensing_postal_address_zip_code AS licensing_postal_address_zip_code_52,
  t0.licensing_postal_address_city AS licensing_postal_address_city_53,
  t0.licensing_postal_address_country AS licensing_postal_address_country_54,
  t0.validation_info_timestamp AS validation_info_timestamp_55,
  t0.validation_info_ip AS validation_info_ip_56,
  t0.validation_info_user_agent AS validation_info_user_agent_57,
  t0.user_id AS user_id_58,
  t0.status_by_id AS status_by_id_59,
  t0.member_company_id AS member_company_id_60,
  t0.active_definition_id AS active_definition_id_61,
  t0.billing_company_id AS billing_company_id_62
FROM
  legal_entity t0
WHERE
  t0.user_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.member AS member_3, t0.uuid AS uuid_4, t0.name AS name_5, t0.echa_name AS echa_name_6, t0.invited_ts AS invited_ts_7, t0.status AS status_8, t0.status_at AS status_at_9, t0.updates_blocked AS updates_blocked_10, t0.limited AS limited_11, t0.acronym AS acronym_12, t0.sanctioned AS sanctioned_13, t0.id AS id_14, t0.address_street1 AS address_street1_15, t0.address_street2 AS address_street2_16, t0.address_street3 AS address_street3_17, t0.address_zip_code AS address_zip_code_18, t0.address_city AS address_city_19, t0.address_country AS address_country_20, t0.licensing_company_name AS licensing_company_name_21, t0.licensing_only_representative AS licensing_only_representative_22, t0.licensing_principal AS licensing_principal_23, t0.licensing_purchase_order_number AS licensing_purchase_order_number_24, t0.licensing_sanctions_certification AS licensing_sanctions_certification_25, t0.licensing_sanctions_data AS licensing_sanctions_data_26, t0.licensing_sanctions_allow_transfer AS licensing_sanctions_allow_transfer_27, t0.licensing_address_street1 AS licensing_address_street1_28, t0.licensing_address_street2 AS licensing_address_street2_29, t0.licensing_address_street3 AS licensing_address_street3_30, t0.licensing_address_zip_code AS licensing_address_zip_code_31, t0.licensing_address_city AS licensing_address_city_32, t0.licensing_address_country AS licensing_address_country_33, t0.licensing_only_representative_address_street1 AS licensing_only_representative_address_street1_34, t0.licensing_only_representative_address_street2 AS licensing_only_representative_address_street2_35, t0.licensing_only_representative_address_street3 AS licensing_only_representative_address_street3_36, t0.licensing_only_representative_address_zip_code AS licensing_only_representative_address_zip_code_37, t0.licensing_only_representative_address_city AS licensing_only_representative_address_city_38, t0.licensing_only_representative_address_country AS licensing_only_representative_address_country_39, t0.licensing_licensee_first_name AS licensing_licensee_first_name_40, t0.licensing_licensee_sur_name AS licensing_licensee_sur_name_41, t0.licensing_licensee_job_title AS licensing_licensee_job_title_42, t0.licensing_licensee_email AS licensing_licensee_email_43, t0.licensing_contact_person_job_title AS licensing_contact_person_job_title_44, t0.licensing_contact_person_phone_number AS licensing_contact_person_phone_number_45, t0.licensing_contact_person_first_name AS licensing_contact_person_first_name_46, t0.licensing_contact_person_sur_name AS licensing_contact_person_sur_name_47, t0.licensing_contact_person_email AS licensing_contact_person_email_48, t0.licensing_postal_address_street1 AS licensing_postal_address_street1_49, t0.licensing_postal_address_street2 AS licensing_postal_address_street2_50, t0.licensing_postal_address_street3 AS licensing_postal_address_street3_51, t0.licensing_postal_address_zip_code AS licensing_postal_address_zip_code_52, t0.licensing_postal_address_city AS licensing_postal_address_city_53, t0.licensing_postal_address_country AS licensing_postal_address_country_54, t0.validation_info_timestamp AS validation_info_timestamp_55, t0.validation_info_ip AS validation_info_ip_56, t0.validation_info_user_agent AS validation_info_user_agent_57, t0.user_id AS user_id_58, t0.status_by_id AS status_by_id_59, t0.member_company_id AS member_company_id_60, t0.active_definition_id AS active_definition_id_61, t0.billing_company_id AS billing_company_id_62 FROM legal_entity t0 WHERE t0.user_id = 2;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  legal_entity_contract l0_
  INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id
WHERE
  (
    l1_.user_id = ?
    AND l0_.accepted = ?
    AND l0_.file_path IS NOT NULL
    AND l0_.force_acceptance = 1
    AND l1_.status = ?
  )
  AND l0_.dtype IN (
    'contract', 'agreement', 'nonpetroleumagreement',
    'sanctionscontract', 'modifiedlicenseagreement',
    'licenseagreement', 'tonnagebandamendment',
    'amendment', 'schedule3amendment',
    'othercontract', 'addendum', 'membercontract'
  )

SELECT COUNT(l0_.id) AS sclr_0 FROM legal_entity_contract l0_ INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id WHERE (l1_.user_id = 2 AND l0_.accepted = 0 AND l0_.file_path IS NOT NULL AND l0_.force_acceptance = 1 AND l1_.status = 'approved') AND l0_.dtype IN ('contract', 'agreement', 'nonpetroleumagreement', 'sanctionscontract', 'modifiedlicenseagreement', 'licenseagreement', 'tonnagebandamendment', 'amendment', 'schedule3amendment', 'othercontract', 'addendum', 'membercontract');

SELECT
  t0.substances AS substances_1,
  t0.user_email AS user_email_2,
  t0.user_first_name AS user_first_name_3,
  t0.user_sur_name AS user_sur_name_4,
  t0.original_uuid AS original_uuid_5,
  t0.original_entity_id AS original_entity_id_6,
  t0.original_entity_name AS original_entity_name_7,
  t0.destination_uuid AS destination_uuid_8,
  t0.destination_entity_id AS destination_entity_id_9,
  t0.representative_first_name AS representative_first_name_10,
  t0.representative_sur_name AS representative_sur_name_11,
  t0.representative_email AS representative_email_12,
  t0.representative_position AS representative_position_13,
  t0.echa_date AS echa_date_14,
  t0.accepted AS accepted_15,
  t0.awaiting_approval AS awaiting_approval_16,
  t0.staff_comment AS staff_comment_17,
  t0.send AS send_18,
  t0.steps AS steps_19,
  t0.member AS member_20,
  t0.staff AS staff_21,
  t0.reminder_at AS reminder_at_22,
  t0.id AS id_23,
  t0.file_name AS file_name_24,
  t0.file_path AS file_path_25,
  t0.file_mime_type AS file_mime_type_26,
  t0.file_size AS file_size_27,
  t0.file_timestamp AS file_timestamp_28,
  t0.progress_steps AS progress_steps_29,
  t0.progress_waiting AS progress_waiting_30,
  t0.progress_completed AS progress_completed_31,
  t0.progress_status AS progress_status_32,
  t0.progress_status_text AS progress_status_text_33,
  t0.progress_percentage AS progress_percentage_34
FROM
  legal_entity_transfer t0
WHERE
  t0.user_email = ?
  AND t0.destination_entity_id IS NULL
LIMIT
  1

SELECT t0.substances AS substances_1, t0.user_email AS user_email_2, t0.user_first_name AS user_first_name_3, t0.user_sur_name AS user_sur_name_4, t0.original_uuid AS original_uuid_5, t0.original_entity_id AS original_entity_id_6, t0.original_entity_name AS original_entity_name_7, t0.destination_uuid AS destination_uuid_8, t0.destination_entity_id AS destination_entity_id_9, t0.representative_first_name AS representative_first_name_10, t0.representative_sur_name AS representative_sur_name_11, t0.representative_email AS representative_email_12, t0.representative_position AS representative_position_13, t0.echa_date AS echa_date_14, t0.accepted AS accepted_15, t0.awaiting_approval AS awaiting_approval_16, t0.staff_comment AS staff_comment_17, t0.send AS send_18, t0.steps AS steps_19, t0.member AS member_20, t0.staff AS staff_21, t0.reminder_at AS reminder_at_22, t0.id AS id_23, t0.file_name AS file_name_24, t0.file_path AS file_path_25, t0.file_mime_type AS file_mime_type_26, t0.file_size AS file_size_27, t0.file_timestamp AS file_timestamp_28, t0.progress_steps AS progress_steps_29, t0.progress_waiting AS progress_waiting_30, t0.progress_completed AS progress_completed_31, t0.progress_status AS progress_status_32, t0.progress_status_text AS progress_status_text_33, t0.progress_percentage AS progress_percentage_34 FROM legal_entity_transfer t0 WHERE t0.user_email = '[email protected]' AND t0.destination_entity_id IS NULL LIMIT 1;

SELECT
  s0_.created_at AS created_at_0,
  s0_.updated_at AS updated_at_1,
  s0_.email AS email_2,
  s0_.password AS password_3,
  s0_.system_user AS system_user_4,
  s0_.invited AS invited_5,
  s0_.removed AS removed_6,
  s0_.failures AS failures_7,
  s0_.id AS id_8,
  s0_.tutorial_filter AS tutorial_filter_9,
  s0_.tutorial_messenger AS tutorial_messenger_10,
  s0_.tutorial_notifications AS tutorial_notifications_11,
  s0_.tutorial_substances AS tutorial_substances_12,
  s0_.settings_messenger_notification_sent AS settings_messenger_notification_sent_13,
  s0_.token_string AS token_string_14,
  s0_.token_expires AS token_expires_15
FROM
  security_user s0_
  INNER JOIN _join_table_security_user_and_group t2_ ON s0_.id = t2_.user_id
  INNER JOIN security_group s1_ ON s1_.id = t2_.group_id
  INNER JOIN security_user_profile s3_ ON s0_.id = s3_.user_id
WHERE
  s1_.id = ?
ORDER BY
  s3_.sur_name ASC,
  s3_.first_name ASC,
  s0_.email ASC

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.email AS email_2, s0_.password AS password_3, s0_.system_user AS system_user_4, s0_.invited AS invited_5, s0_.removed AS removed_6, s0_.failures AS failures_7, s0_.id AS id_8, s0_.tutorial_filter AS tutorial_filter_9, s0_.tutorial_messenger AS tutorial_messenger_10, s0_.tutorial_notifications AS tutorial_notifications_11, s0_.tutorial_substances AS tutorial_substances_12, s0_.settings_messenger_notification_sent AS settings_messenger_notification_sent_13, s0_.token_string AS token_string_14, s0_.token_expires AS token_expires_15 FROM security_user s0_ INNER JOIN _join_table_security_user_and_group t2_ ON s0_.id = t2_.user_id INNER JOIN security_group s1_ ON s1_.id = t2_.group_id INNER JOIN security_user_profile s3_ ON s0_.id = s3_.user_id WHERE s1_.id = 'ROLE_STAFF' ORDER BY s3_.sur_name ASC, s3_.first_name ASC, s0_.email ASC;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.title AS title_3,
  t0.first_name AS first_name_4,
  t0.sur_name AS sur_name_5,
  t0.notifications AS notifications_6,
  t0.id AS id_7,
  t0.user_id AS user_id_8
FROM
  security_user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.title AS title_3, t0.first_name AS first_name_4, t0.sur_name AS sur_name_5, t0.notifications AS notifications_6, t0.id AS id_7, t0.user_id AS user_id_8 FROM security_user_profile t0 WHERE t0.user_id = 40;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.title AS title_3,
  t0.first_name AS first_name_4,
  t0.sur_name AS sur_name_5,
  t0.notifications AS notifications_6,
  t0.id AS id_7,
  t0.user_id AS user_id_8
FROM
  security_user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.title AS title_3, t0.first_name AS first_name_4, t0.sur_name AS sur_name_5, t0.notifications AS notifications_6, t0.id AS id_7, t0.user_id AS user_id_8 FROM security_user_profile t0 WHERE t0.user_id = 798;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  legal_entity_order_invoice l0_
  INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id
  INNER JOIN security_user s2_ ON l1_.user_id = s2_.id
WHERE
  (
    s2_.id = ?
    AND l0_.file_path IS NOT NULL
    AND l0_.hidden = 0
  )
  AND l0_._discr IN ('invoice')

SELECT COUNT(l0_.id) AS sclr_0 FROM legal_entity_order_invoice l0_ INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id INNER JOIN security_user s2_ ON l1_.user_id = s2_.id WHERE (s2_.id = 40 AND l0_.file_path IS NOT NULL AND l0_.hidden = 0) AND l0_._discr IN ('invoice');

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.title AS title_3,
  t0.first_name AS first_name_4,
  t0.sur_name AS sur_name_5,
  t0.notifications AS notifications_6,
  t0.id AS id_7,
  t0.user_id AS user_id_8
FROM
  security_user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.title AS title_3, t0.first_name AS first_name_4, t0.sur_name AS sur_name_5, t0.notifications AS notifications_6, t0.id AS id_7, t0.user_id AS user_id_8 FROM security_user_profile t0 WHERE t0.user_id = 890;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  legal_entity_order_invoice l0_
  INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id
  INNER JOIN security_user s2_ ON l1_.user_id = s2_.id
WHERE
  (
    s2_.id = ?
    AND l0_.file_path IS NOT NULL
    AND l0_.hidden = 0
  )
  AND l0_._discr IN ('invoice')

SELECT COUNT(l0_.id) AS sclr_0 FROM legal_entity_order_invoice l0_ INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id INNER JOIN security_user s2_ ON l1_.user_id = s2_.id WHERE (s2_.id = 798 AND l0_.file_path IS NOT NULL AND l0_.hidden = 0) AND l0_._discr IN ('invoice');

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.title AS title_3,
  t0.first_name AS first_name_4,
  t0.sur_name AS sur_name_5,
  t0.notifications AS notifications_6,
  t0.id AS id_7,
  t0.user_id AS user_id_8
FROM
  security_user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.title AS title_3, t0.first_name AS first_name_4, t0.sur_name AS sur_name_5, t0.notifications AS notifications_6, t0.id AS id_7, t0.user_id AS user_id_8 FROM security_user_profile t0 WHERE t0.user_id = 787;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  legal_entity_order_invoice l0_
  INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id
  INNER JOIN security_user s2_ ON l1_.user_id = s2_.id
WHERE
  (
    s2_.id = ?
    AND l0_.file_path IS NOT NULL
    AND l0_.hidden = 0
  )
  AND l0_._discr IN ('invoice')

SELECT COUNT(l0_.id) AS sclr_0 FROM legal_entity_order_invoice l0_ INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id INNER JOIN security_user s2_ ON l1_.user_id = s2_.id WHERE (s2_.id = 890 AND l0_.file_path IS NOT NULL AND l0_.hidden = 0) AND l0_._discr IN ('invoice');

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.title AS title_3,
  t0.first_name AS first_name_4,
  t0.sur_name AS sur_name_5,
  t0.notifications AS notifications_6,
  t0.id AS id_7,
  t0.user_id AS user_id_8
FROM
  security_user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.title AS title_3, t0.first_name AS first_name_4, t0.sur_name AS sur_name_5, t0.notifications AS notifications_6, t0.id AS id_7, t0.user_id AS user_id_8 FROM security_user_profile t0 WHERE t0.user_id = 1226;

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  legal_entity_order_invoice l0_
  INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id
  INNER JOIN security_user s2_ ON l1_.user_id = s2_.id
WHERE
  (
    s2_.id = ?
    AND l0_.file_path IS NOT NULL
    AND l0_.hidden = 0
  )
  AND l0_._discr IN ('invoice')

SELECT COUNT(l0_.id) AS sclr_0 FROM legal_entity_order_invoice l0_ INNER JOIN legal_entity l1_ ON l0_.legal_entity_id = l1_.id INNER JOIN security_user s2_ ON l1_.user_id = s2_.id WHERE (s2_.id = 787 AND l0_.file_path IS NOT NULL AND l0_.hidden = 0) AND l0_._discr IN ('invoice');

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.title AS title_3,
  t0.first_name AS first_name_4,
  t0.sur_name AS sur_name_5,
  t0.notifications AS notifications_6,
  t0.id AS id_7,
  t0.user_id AS user_id_8
FROM
  security_user_profile t0
WHERE
  t0.user_id = ?