Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.created_by_user_id AS created_by_user_id_5,
  t0.updated_by_user_id AS updated_by_user_id_6,
  t0.application_id AS application_id_7
FROM
  remit_applications_messages t0
WHERE
  t0.application_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_user_id AS created_by_user_id_5, t0.updated_by_user_id AS updated_by_user_id_6, t0.application_id AS application_id_7 FROM remit_applications_messages t0 WHERE t0.application_id = 6 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.flow_type AS flow_type_2,
  t0.status AS status_3,
  t0.registration_number AS registration_number_4,
  t0.applied_on AS applied_on_5,
  t0.registered_on AS registered_on_6,
  t0.processed_on AS processed_on_7,
  t0.returned_on AS returned_on_8,
  t0.categories AS categories_9,
  t0.internal AS internal_10,
  t0.remaining_days_for_processing AS remaining_days_for_processing_11,
  t0.remaining_days_for_completing AS remaining_days_for_completing_12,
  t0.counters_updated_on AS counters_updated_on_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.legal_name AS legal_name_16,
  t0.legal_organization_form AS legal_organization_form_17,
  t0.address AS address_18,
  t0.city AS city_19,
  t0.postcode AS postcode_20,
  t0.country AS country_21,
  t0.unique_identification_number AS unique_identification_number_22,
  t0.bic AS bic_23,
  t0.company_employee AS company_employee_24,
  t0.fiscal_code AS fiscal_code_25,
  t0.vat_number AS vat_number_26,
  t0.official_web_page AS official_web_page_27,
  t0.employment_info AS employment_info_28,
  t0.effective_beneficiary AS effective_beneficiary_29,
  t0.final_control_person AS final_control_person_30,
  t0.privileged_info_page1 AS privileged_info_page1_31,
  t0.privileged_info_page2 AS privileged_info_page2_32,
  t0.privileged_info_page3 AS privileged_info_page3_33,
  t0.administrators AS administrators_34,
  t0.responsible_people AS responsible_people_35,
  t0.customer_id AS customer_id_36,
  t0.created_by_user_id AS created_by_user_id_37,
  t0.updated_by_user_id AS updated_by_user_id_38,
  t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_39,
  t0.dtype,
  t0.reason AS reason_40
FROM
  remit_applications t0
WHERE
  t0.id = ?
  AND t0.dtype IN ('1', '2')

SELECT t0.id AS id_1, t0.flow_type AS flow_type_2, t0.status AS status_3, t0.registration_number AS registration_number_4, t0.applied_on AS applied_on_5, t0.registered_on AS registered_on_6, t0.processed_on AS processed_on_7, t0.returned_on AS returned_on_8, t0.categories AS categories_9, t0.internal AS internal_10, t0.remaining_days_for_processing AS remaining_days_for_processing_11, t0.remaining_days_for_completing AS remaining_days_for_completing_12, t0.counters_updated_on AS counters_updated_on_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.legal_name AS legal_name_16, t0.legal_organization_form AS legal_organization_form_17, t0.address AS address_18, t0.city AS city_19, t0.postcode AS postcode_20, t0.country AS country_21, t0.unique_identification_number AS unique_identification_number_22, t0.bic AS bic_23, t0.company_employee AS company_employee_24, t0.fiscal_code AS fiscal_code_25, t0.vat_number AS vat_number_26, t0.official_web_page AS official_web_page_27, t0.employment_info AS employment_info_28, t0.effective_beneficiary AS effective_beneficiary_29, t0.final_control_person AS final_control_person_30, t0.privileged_info_page1 AS privileged_info_page1_31, t0.privileged_info_page2 AS privileged_info_page2_32, t0.privileged_info_page3 AS privileged_info_page3_33, t0.administrators AS administrators_34, t0.responsible_people AS responsible_people_35, t0.customer_id AS customer_id_36, t0.created_by_user_id AS created_by_user_id_37, t0.updated_by_user_id AS updated_by_user_id_38, t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_39, t0.dtype, t0.reason AS reason_40 FROM remit_applications t0 WHERE t0.id = '6' AND t0.dtype IN ('1', '2');

SELECT
  t0.id AS id_1,
  t0.current AS current_2,
  t0.path AS path_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.verified_status AS verified_status_6,
  t0.verified_at AS verified_at_7,
  t0.presented_at AS presented_at_8,
  t0.signed AS signed_9,
  t0.signed_at AS signed_at_10,
  t0.signed_by AS signed_by_11,
  t0.document_id AS document_id_12,
  t0.verified_by_id AS verified_by_id_13,
  t0.presented_to_id AS presented_to_id_14
FROM
  remit_customers_documents_versions t0
  INNER JOIN remit_applications_attached_documents ON t0.id = remit_applications_attached_documents.document_version_id
WHERE
  remit_applications_attached_documents.application_id = ?

SELECT t0.id AS id_1, t0.current AS current_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.verified_status AS verified_status_6, t0.verified_at AS verified_at_7, t0.presented_at AS presented_at_8, t0.signed AS signed_9, t0.signed_at AS signed_at_10, t0.signed_by AS signed_by_11, t0.document_id AS document_id_12, t0.verified_by_id AS verified_by_id_13, t0.presented_to_id AS presented_to_id_14 FROM remit_customers_documents_versions t0 INNER JOIN remit_applications_attached_documents ON t0.id = remit_applications_attached_documents.document_version_id WHERE remit_applications_attached_documents.application_id = 6;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.phone_number AS phone_number_3,
  t0.email AS email_4,
  t5.address AS address_6,
  t5.city AS city_7,
  t5.postcode AS postcode_8,
  t5.country AS country_9,
  t5.id AS id_10,
  t5.idno AS idno_11,
  t5.legal_organization_form AS legal_organization_form_12,
  t5.legal_name AS legal_name_13,
  t5.deleted_at AS deleted_at_14,
  t5.profile_state AS profile_state_15,
  t5.unique_identification_number AS unique_identification_number_16,
  t5.bic AS bic_17,
  t5.fiscal_code AS fiscal_code_18,
  t5.vat_number AS vat_number_19,
  t5.official_web_page AS official_web_page_20,
  t5.effective_beneficiary AS effective_beneficiary_21,
  t5.final_control_person AS final_control_person_22,
  t5.privileged_info_page1 AS privileged_info_page1_23,
  t5.privileged_info_page2 AS privileged_info_page2_24,
  t5.privileged_info_page3 AS privileged_info_page3_25,
  t5.customer_id AS customer_id_26,
  t5.legal_form_lookup_record_id AS legal_form_lookup_record_id_27
FROM
  remit_customers t0
  LEFT JOIN remit_customers_companies_info t5 ON t5.customer_id = t0.id
  INNER JOIN remit_security_users_customers ON t0.id = remit_security_users_customers.customer_id
WHERE
  remit_security_users_customers.user_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.phone_number AS phone_number_3, t0.email AS email_4, t5.address AS address_6, t5.city AS city_7, t5.postcode AS postcode_8, t5.country AS country_9, t5.id AS id_10, t5.idno AS idno_11, t5.legal_organization_form AS legal_organization_form_12, t5.legal_name AS legal_name_13, t5.deleted_at AS deleted_at_14, t5.profile_state AS profile_state_15, t5.unique_identification_number AS unique_identification_number_16, t5.bic AS bic_17, t5.fiscal_code AS fiscal_code_18, t5.vat_number AS vat_number_19, t5.official_web_page AS official_web_page_20, t5.effective_beneficiary AS effective_beneficiary_21, t5.final_control_person AS final_control_person_22, t5.privileged_info_page1 AS privileged_info_page1_23, t5.privileged_info_page2 AS privileged_info_page2_24, t5.privileged_info_page3 AS privileged_info_page3_25, t5.customer_id AS customer_id_26, t5.legal_form_lookup_record_id AS legal_form_lookup_record_id_27 FROM remit_customers t0 LEFT JOIN remit_customers_companies_info t5 ON t5.customer_id = t0.id INNER JOIN remit_security_users_customers ON t0.id = remit_security_users_customers.customer_id WHERE remit_security_users_customers.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.idnp AS idnp_3,
  t0.display_name AS display_name_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.language AS language_7,
  t0.password AS password_8,
  t0.email AS email_9,
  t0.phone_number AS phone_number_10,
  t0.active AS active_11,
  t0.auth_method AS auth_method_12
FROM
  remit_security_users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.idnp AS idnp_3, t0.display_name AS display_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.language AS language_7, t0.password AS password_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.active AS active_11, t0.auth_method AS auth_method_12 FROM remit_security_users t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.created_by_user_id AS created_by_user_id_5,
  t0.updated_by_user_id AS updated_by_user_id_6,
  t0.application_id AS application_id_7
FROM
  remit_applications_comments t0
WHERE
  t0.application_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_user_id AS created_by_user_id_5, t0.updated_by_user_id AS updated_by_user_id_6, t0.application_id AS application_id_7 FROM remit_applications_comments t0 WHERE t0.application_id = 6 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.doc_type AS doc_type_2,
  t0.path AS path_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.verified_status AS verified_status_6,
  t0.verified_at AS verified_at_7,
  t0.presented_at AS presented_at_8,
  t0.signed AS signed_9,
  t0.signed_at AS signed_at_10,
  t0.signed_by AS signed_by_11,
  t0.application_id AS application_id_12,
  t0.participant_id AS participant_id_13,
  t0.verified_by_id AS verified_by_id_14,
  t0.presented_to_id AS presented_to_id_15
FROM
  remit_applications_documents t0
WHERE
  t0.application_id = ?

SELECT t0.id AS id_1, t0.doc_type AS doc_type_2, t0.path AS path_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.verified_status AS verified_status_6, t0.verified_at AS verified_at_7, t0.presented_at AS presented_at_8, t0.signed AS signed_9, t0.signed_at AS signed_at_10, t0.signed_by AS signed_by_11, t0.application_id AS application_id_12, t0.participant_id AS participant_id_13, t0.verified_by_id AS verified_by_id_14, t0.presented_to_id AS presented_to_id_15 FROM remit_applications_documents t0 WHERE t0.application_id = 6;

SELECT
  COUNT(*)
FROM
  remit_core_notifications t0
WHERE
  t0.recipient_user_id = ?
  AND t0.record_type IN ('2')

SELECT COUNT(*) FROM remit_core_notifications t0 WHERE t0.recipient_user_id = 1 AND t0.record_type IN ('2');

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.idnp AS idnp_3,
  t0.display_name AS display_name_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.language AS language_7,
  t0.password AS password_8,
  t0.email AS email_9,
  t0.phone_number AS phone_number_10,
  t0.active AS active_11,
  t0.auth_method AS auth_method_12
FROM
  remit_security_users t0
  INNER JOIN remit_applications_authorization_specialists ON t0.id = remit_applications_authorization_specialists.specialist_user_id
WHERE
  remit_applications_authorization_specialists.application_id = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.idnp AS idnp_3, t0.display_name AS display_name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.language AS language_7, t0.password AS password_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.active AS active_11, t0.auth_method AS auth_method_12 FROM remit_security_users t0 INNER JOIN remit_applications_authorization_specialists ON t0.id = remit_applications_authorization_specialists.specialist_user_id WHERE remit_applications_authorization_specialists.application_id = 6;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.registration_number AS registration_number_3,
  t0.status AS status_4,
  t0.registered_on AS registered_on_5,
  t0.categories AS categories_6,
  t0.legal_name AS legal_name_7,
  t0.legal_organization_form AS legal_organization_form_8,
  t0.address AS address_9,
  t0.city AS city_10,
  t0.postcode AS postcode_11,
  t0.country AS country_12,
  t0.unique_identification_number AS unique_identification_number_13,
  t0.bic AS bic_14,
  t0.company_employee AS company_employee_15,
  t0.fiscal_code AS fiscal_code_16,
  t0.vat_number AS vat_number_17,
  t0.official_web_page AS official_web_page_18,
  t0.employment_info AS employment_info_19,
  t0.effective_beneficiary AS effective_beneficiary_20,
  t0.final_control_person AS final_control_person_21,
  t0.privileged_info_page1 AS privileged_info_page1_22,
  t0.privileged_info_page2 AS privileged_info_page2_23,
  t0.privileged_info_page3 AS privileged_info_page3_24,
  t0.responsible_people AS responsible_people_25,
  t0.administrators AS administrators_26,
  t0.reason AS reason_27,
  t0.revoke_on AS revoke_on_28,
  t0.registration_dates AS registration_dates_29,
  t0.company_info_id AS company_info_id_30,
  t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_31
FROM
  remit_participants t0
WHERE
  t0.company_info_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.registration_number AS registration_number_3, t0.status AS status_4, t0.registered_on AS registered_on_5, t0.categories AS categories_6, t0.legal_name AS legal_name_7, t0.legal_organization_form AS legal_organization_form_8, t0.address AS address_9, t0.city AS city_10, t0.postcode AS postcode_11, t0.country AS country_12, t0.unique_identification_number AS unique_identification_number_13, t0.bic AS bic_14, t0.company_employee AS company_employee_15, t0.fiscal_code AS fiscal_code_16, t0.vat_number AS vat_number_17, t0.official_web_page AS official_web_page_18, t0.employment_info AS employment_info_19, t0.effective_beneficiary AS effective_beneficiary_20, t0.final_control_person AS final_control_person_21, t0.privileged_info_page1 AS privileged_info_page1_22, t0.privileged_info_page2 AS privileged_info_page2_23, t0.privileged_info_page3 AS privileged_info_page3_24, t0.responsible_people AS responsible_people_25, t0.administrators AS administrators_26, t0.reason AS reason_27, t0.revoke_on AS revoke_on_28, t0.registration_dates AS registration_dates_29, t0.company_info_id AS company_info_id_30, t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_31 FROM remit_participants t0 WHERE t0.company_info_id = 4;

SELECT
  r0_.id AS id_0,
  r0_.display_name AS display_name_1,
  r0_.phone_number AS phone_number_2,
  r0_.email AS email_3
FROM
  remit_customers r0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      remit_security_users_customers r1_
    WHERE
      r1_.customer_id = r0_.id
      AND r1_.user_id IN (?)
  )
ORDER BY
  r0_.id ASC

SELECT r0_.id AS id_0, r0_.display_name AS display_name_1, r0_.phone_number AS phone_number_2, r0_.email AS email_3 FROM remit_customers r0_ WHERE EXISTS (SELECT 1 FROM remit_security_users_customers r1_ WHERE r1_.customer_id = r0_.id AND r1_.user_id IN (1)) ORDER BY r0_.id ASC;

SELECT
  t0.resident AS resident_1,
  t0.idnp AS idnp_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.id AS id_5,
  t0.data_hash AS data_hash_6,
  t0.company_id AS company_id_7
FROM
  remit_customers_companies_administrators t0
WHERE
  t0.company_id = ?

SELECT t0.resident AS resident_1, t0.idnp AS idnp_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.id AS id_5, t0.data_hash AS data_hash_6, t0.company_id AS company_id_7 FROM remit_customers_companies_administrators t0 WHERE t0.company_id = 4;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.name_ro AS name_ro_3,
  t0.name_ru AS name_ru_4,
  t0.name_en AS name_en_5,
  t0.lookup_id AS lookup_id_6,
  t0.parent_id AS parent_id_7
FROM
  remit_system_mconnect_lookups_records t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.name_ro AS name_ro_3, t0.name_ru AS name_ru_4, t0.name_en AS name_en_5, t0.lookup_id AS lookup_id_6, t0.parent_id AS parent_id_7 FROM remit_system_mconnect_lookups_records t0 WHERE t0.id = 8;