Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.registration_number AS registration_number_2,
  r0_.status AS status_3,
  r0_.registered_on AS registered_on_4,
  r0_.categories AS categories_5,
  r0_.legal_name AS legal_name_6,
  r0_.legal_organization_form AS legal_organization_form_7,
  r0_.address AS address_8,
  r0_.city AS city_9,
  r0_.postcode AS postcode_10,
  r0_.country AS country_11,
  r0_.unique_identification_number AS unique_identification_number_12,
  r0_.bic AS bic_13,
  r0_.company_employee AS company_employee_14,
  r0_.fiscal_code AS fiscal_code_15,
  r0_.vat_number AS vat_number_16,
  r0_.official_web_page AS official_web_page_17,
  r0_.employment_info AS employment_info_18,
  r0_.effective_beneficiary AS effective_beneficiary_19,
  r0_.final_control_person AS final_control_person_20,
  r0_.privileged_info_page1 AS privileged_info_page1_21,
  r0_.privileged_info_page2 AS privileged_info_page2_22,
  r0_.privileged_info_page3 AS privileged_info_page3_23,
  r0_.responsible_people AS responsible_people_24,
  r0_.administrators AS administrators_25,
  r0_.reason AS reason_26,
  r0_.revoke_on AS revoke_on_27,
  r0_.registration_dates AS registration_dates_28,
  r0_.company_info_id AS company_info_id_29,
  r0_.legal_form_lookup_record_id AS legal_form_lookup_record_id_30
FROM
  remit_participants r0_
WHERE
  r0_.status IN (?)
  AND (
    r0_.categories #>> '{}') LIKE ? ORDER BY r0_.id ASC
WARNING: unclosed parentheses or section

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.registration_number AS registration_number_2, r0_.status AS status_3, r0_.registered_on AS registered_on_4, r0_.categories AS categories_5, r0_.legal_name AS legal_name_6, r0_.legal_organization_form AS legal_organization_form_7, r0_.address AS address_8, r0_.city AS city_9, r0_.postcode AS postcode_10, r0_.country AS country_11, r0_.unique_identification_number AS unique_identification_number_12, r0_.bic AS bic_13, r0_.company_employee AS company_employee_14, r0_.fiscal_code AS fiscal_code_15, r0_.vat_number AS vat_number_16, r0_.official_web_page AS official_web_page_17, r0_.employment_info AS employment_info_18, r0_.effective_beneficiary AS effective_beneficiary_19, r0_.final_control_person AS final_control_person_20, r0_.privileged_info_page1 AS privileged_info_page1_21, r0_.privileged_info_page2 AS privileged_info_page2_22, r0_.privileged_info_page3 AS privileged_info_page3_23, r0_.responsible_people AS responsible_people_24, r0_.administrators AS administrators_25, r0_.reason AS reason_26, r0_.revoke_on AS revoke_on_27, r0_.registration_dates AS registration_dates_28, r0_.company_info_id AS company_info_id_29, r0_.legal_form_lookup_record_id AS legal_form_lookup_record_id_30 FROM remit_participants r0_ WHERE r0_.status IN (20) AND (r0_.categories #>> '{}') LIKE '%electricity%' ORDER BY r0_.id ASC;

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.participant_id IN (?)
  AND t0.doc_type IN (?, ?)
ORDER BY
  t0.id 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.participant_id IN (1) AND t0.doc_type IN (5, 4) ORDER BY t0.id 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.customer_id AS customer_id_16,
  t0.created_by_user_id AS created_by_user_id_17,
  t0.updated_by_user_id AS updated_by_user_id_18,
  t0.dtype,
  t0.legal_name AS legal_name_19,
  t0.legal_organization_form AS legal_organization_form_20,
  t0.address AS address_21,
  t0.city AS city_22,
  t0.postcode AS postcode_23,
  t0.country AS country_24,
  t0.unique_identification_number AS unique_identification_number_25,
  t0.bic AS bic_26,
  t0.company_employee AS company_employee_27,
  t0.fiscal_code AS fiscal_code_28,
  t0.vat_number AS vat_number_29,
  t0.official_web_page AS official_web_page_30,
  t0.employment_info AS employment_info_31,
  t0.effective_beneficiary AS effective_beneficiary_32,
  t0.final_control_person AS final_control_person_33,
  t0.privileged_info_page1 AS privileged_info_page1_34,
  t0.privileged_info_page2 AS privileged_info_page2_35,
  t0.privileged_info_page3 AS privileged_info_page3_36,
  t0.administrators AS administrators_37,
  t0.responsible_people AS responsible_people_38,
  t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_39,
  t0.reason AS reason_40,
  t0.revoke AS revoke_41,
  t0.revoke_on AS revoke_on_42,
  t0.reason AS reason_43
FROM
  remit_applications t0
WHERE
  t0.id = ?
  AND t0.dtype IN ('1', '2', '3')

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.customer_id AS customer_id_16, t0.created_by_user_id AS created_by_user_id_17, t0.updated_by_user_id AS updated_by_user_id_18, t0.dtype, t0.legal_name AS legal_name_19, t0.legal_organization_form AS legal_organization_form_20, t0.address AS address_21, t0.city AS city_22, t0.postcode AS postcode_23, t0.country AS country_24, t0.unique_identification_number AS unique_identification_number_25, t0.bic AS bic_26, t0.company_employee AS company_employee_27, t0.fiscal_code AS fiscal_code_28, t0.vat_number AS vat_number_29, t0.official_web_page AS official_web_page_30, t0.employment_info AS employment_info_31, t0.effective_beneficiary AS effective_beneficiary_32, t0.final_control_person AS final_control_person_33, t0.privileged_info_page1 AS privileged_info_page1_34, t0.privileged_info_page2 AS privileged_info_page2_35, t0.privileged_info_page3 AS privileged_info_page3_36, t0.administrators AS administrators_37, t0.responsible_people AS responsible_people_38, t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_39, t0.reason AS reason_40, t0.revoke AS revoke_41, t0.revoke_on AS revoke_on_42, t0.reason AS reason_43 FROM remit_applications t0 WHERE t0.id = 1 AND t0.dtype IN ('1', '2', '3');

SELECT
  t0.address AS address_1,
  t0.city AS city_2,
  t0.postcode AS postcode_3,
  t0.country AS country_4,
  t0.id AS id_5,
  t0.idno AS idno_6,
  t0.legal_organization_form AS legal_organization_form_7,
  t0.legal_name AS legal_name_8,
  t0.deleted_at AS deleted_at_9,
  t0.profile_state AS profile_state_10,
  t0.unique_identification_number AS unique_identification_number_11,
  t0.bic AS bic_12,
  t0.fiscal_code AS fiscal_code_13,
  t0.vat_number AS vat_number_14,
  t0.official_web_page AS official_web_page_15,
  t0.effective_beneficiary AS effective_beneficiary_16,
  t0.final_control_person AS final_control_person_17,
  t0.privileged_info_page1 AS privileged_info_page1_18,
  t0.privileged_info_page2 AS privileged_info_page2_19,
  t0.privileged_info_page3 AS privileged_info_page3_20,
  t0.customer_id AS customer_id_21,
  t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_22,
  t23.id AS id_24,
  t23.code AS code_25,
  t23.registration_number AS registration_number_26,
  t23.status AS status_27,
  t23.registered_on AS registered_on_28,
  t23.categories AS categories_29,
  t23.legal_name AS legal_name_30,
  t23.legal_organization_form AS legal_organization_form_31,
  t23.address AS address_32,
  t23.city AS city_33,
  t23.postcode AS postcode_34,
  t23.country AS country_35,
  t23.unique_identification_number AS unique_identification_number_36,
  t23.bic AS bic_37,
  t23.company_employee AS company_employee_38,
  t23.fiscal_code AS fiscal_code_39,
  t23.vat_number AS vat_number_40,
  t23.official_web_page AS official_web_page_41,
  t23.employment_info AS employment_info_42,
  t23.effective_beneficiary AS effective_beneficiary_43,
  t23.final_control_person AS final_control_person_44,
  t23.privileged_info_page1 AS privileged_info_page1_45,
  t23.privileged_info_page2 AS privileged_info_page2_46,
  t23.privileged_info_page3 AS privileged_info_page3_47,
  t23.responsible_people AS responsible_people_48,
  t23.administrators AS administrators_49,
  t23.reason AS reason_50,
  t23.revoke_on AS revoke_on_51,
  t23.registration_dates AS registration_dates_52,
  t23.company_info_id AS company_info_id_53,
  t23.legal_form_lookup_record_id AS legal_form_lookup_record_id_54
FROM
  remit_customers_companies_info t0
  LEFT JOIN remit_participants t23 ON t23.company_info_id = t0.id
WHERE
  t0.id = ?

SELECT t0.address AS address_1, t0.city AS city_2, t0.postcode AS postcode_3, t0.country AS country_4, t0.id AS id_5, t0.idno AS idno_6, t0.legal_organization_form AS legal_organization_form_7, t0.legal_name AS legal_name_8, t0.deleted_at AS deleted_at_9, t0.profile_state AS profile_state_10, t0.unique_identification_number AS unique_identification_number_11, t0.bic AS bic_12, t0.fiscal_code AS fiscal_code_13, t0.vat_number AS vat_number_14, t0.official_web_page AS official_web_page_15, t0.effective_beneficiary AS effective_beneficiary_16, t0.final_control_person AS final_control_person_17, t0.privileged_info_page1 AS privileged_info_page1_18, t0.privileged_info_page2 AS privileged_info_page2_19, t0.privileged_info_page3 AS privileged_info_page3_20, t0.customer_id AS customer_id_21, t0.legal_form_lookup_record_id AS legal_form_lookup_record_id_22, t23.id AS id_24, t23.code AS code_25, t23.registration_number AS registration_number_26, t23.status AS status_27, t23.registered_on AS registered_on_28, t23.categories AS categories_29, t23.legal_name AS legal_name_30, t23.legal_organization_form AS legal_organization_form_31, t23.address AS address_32, t23.city AS city_33, t23.postcode AS postcode_34, t23.country AS country_35, t23.unique_identification_number AS unique_identification_number_36, t23.bic AS bic_37, t23.company_employee AS company_employee_38, t23.fiscal_code AS fiscal_code_39, t23.vat_number AS vat_number_40, t23.official_web_page AS official_web_page_41, t23.employment_info AS employment_info_42, t23.effective_beneficiary AS effective_beneficiary_43, t23.final_control_person AS final_control_person_44, t23.privileged_info_page1 AS privileged_info_page1_45, t23.privileged_info_page2 AS privileged_info_page2_46, t23.privileged_info_page3 AS privileged_info_page3_47, t23.responsible_people AS responsible_people_48, t23.administrators AS administrators_49, t23.reason AS reason_50, t23.revoke_on AS revoke_on_51, t23.registration_dates AS registration_dates_52, t23.company_info_id AS company_info_id_53, t23.legal_form_lookup_record_id AS legal_form_lookup_record_id_54 FROM remit_customers_companies_info t0 LEFT JOIN remit_participants t23 ON t23.company_info_id = t0.id WHERE t0.id = 1;

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
WHERE
  t0.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 WHERE t0.id = 1;

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;