Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.phone_number AS phone_number_2,
  a0_.password AS password_3,
  a0_.roles AS roles_4,
  a0_.lastname AS lastname_5,
  a0_.firstname AS firstname_6,
  a0_.created_at AS created_at_7,
  a0_.registration_source AS registration_source_8,
  a0_.honorific_prefix AS honorific_prefix_9,
  a0_.reset_token AS reset_token_10,
  a0_.reset_token_expiration_date AS reset_token_expiration_date_11,
  a0_.uniq_id AS uniq_id_12,
  a0_.code_confirmation AS code_confirmation_13,
  a0_.updated_at AS updated_at_14,
  a0_.is_active AS is_active_15
FROM
  app_users a0_
WHERE
  a0_.email = ?
  OR a0_.phone_number = ?

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.phone_number AS phone_number_2, a0_.password AS password_3, a0_.roles AS roles_4, a0_.lastname AS lastname_5, a0_.firstname AS firstname_6, a0_.created_at AS created_at_7, a0_.registration_source AS registration_source_8, a0_.honorific_prefix AS honorific_prefix_9, a0_.reset_token AS reset_token_10, a0_.reset_token_expiration_date AS reset_token_expiration_date_11, a0_.uniq_id AS uniq_id_12, a0_.code_confirmation AS code_confirmation_13, a0_.updated_at AS updated_at_14, a0_.is_active AS is_active_15 FROM app_users a0_ WHERE a0_.email = 'davy@digidom.pro' OR a0_.phone_number = 'davy@digidom.pro';

SELECT
  o0_.id AS id_0,
  o0_.legal_name AS legal_name_1,
  o0_.telephone AS telephone_2,
  o0_.vat_id AS vat_id_3,
  o0_.legal_status AS legal_status_4,
  o0_.purpose AS purpose_5,
  o0_.founding_date AS founding_date_6,
  o0_.fiscal_date AS fiscal_date_7,
  o0_.fiscal_date_end AS fiscal_date_end_8,
  o0_.first_fiscal_date AS first_fiscal_date_9,
  o0_.first_fiscal_date_end AS first_fiscal_date_end_10,
  o0_.head_quarters_address_type AS head_quarters_address_type_11,
  o0_.legal_representative_address_type AS legal_representative_address_type_12,
  o0_.share_capital AS share_capital_13,
  o0_.share_capital_type AS share_capital_type_14,
  o0_.share_capital_fixed_amount AS share_capital_fixed_amount_15,
  o0_.shares_count AS shares_count_16,
  o0_.bank_choice AS bank_choice_17,
  o0_.registration_source AS registration_source_18,
  o0_.commercial_court_registry AS commercial_court_registry_19,
  o0_.sector_other AS sector_other_20,
  o0_.rcs AS rcs_21,
  o0_.status AS status_22,
  o0_.email AS email_23,
  o0_.mandatary AS mandatary_24,
  o0_.bal AS bal_25,
  o0_.forwarding_frequency AS forwarding_frequency_26,
  o0_.forwarding_address_name AS forwarding_address_name_27,
  o0_.alternate_name AS alternate_name_28,
  o0_.domiciliation_start_date AS domiciliation_start_date_29,
  o0_.created_at AS created_at_30,
  o0_.termination_date AS termination_date_31,
  o0_.termination_reason AS termination_reason_32,
  o0_.termination_reason_other AS termination_reason_other_33,
  o0_.siret AS siret_34,
  o0_.is_new_immatriculation AS is_new_immatriculation_35,
  o0_.is_new_domiciliation AS is_new_domiciliation_36,
  o0_.mandat_id AS mandat_id_37,
  o0_.conversion_reason AS conversion_reason_38,
  o0_.status_is_forced AS status_is_forced_39,
  o0_.uniq_id AS uniq_id_40,
  o0_.iban AS iban_41,
  o0_.reference_gocardless AS reference_gocardless_42,
  o0_.is_forwarding_active AS is_forwarding_active_43,
  o0_.vatrate AS vatrate_44,
  o0_.is_imported AS is_imported_45,
  o0_.credit_notes_amount AS credit_notes_amount_46,
  o0_.available_credits AS available_credits_47,
  o0_.invoice_token AS invoice_token_48,
  o0_.share_capital_free_percentage AS share_capital_free_percentage_49,
  o0_.is_prescriber AS is_prescriber_50,
  o0_.have_accountant AS have_accountant_51,
  o0_.status_immatriculation AS status_immatriculation_52,
  o0_.is_exempt_tva AS is_exempt_tva_53,
  o0_.project_stage AS project_stage_54,
  o0_.status_invoice_payed AS status_invoice_payed_55,
  o0_.date_max_unpaid AS date_max_unpaid_56,
  o0_.is_have_auditor AS is_have_auditor_57,
  o0_.benefit_imposition AS benefit_imposition_58,
  o0_.benefit_imposition_option AS benefit_imposition_option_59,
  o0_.vat_taxe_regim AS vat_taxe_regim_60,
  o0_.vat_taxe_regime_option AS vat_taxe_regime_option_61,
  o0_.prolongation_date_kyc AS prolongation_date_kyc_62,
  o0_.status_transfert AS status_transfert_63,
  o0_.is_new_transfert AS is_new_transfert_64,
  o0_.special_request_bal AS special_request_bal_65,
  o0_.trac_fin AS trac_fin_66,
  o0_.trac_fin_note AS trac_fin_note_67,
  o0_.pack_imat AS pack_imat_68,
  o0_.is_authorize_prescriber AS is_authorize_prescriber_69,
  o0_.is_attached_to_prescriber AS is_attached_to_prescriber_70,
  o0_.is_emptybal AS is_emptybal_71,
  o0_.is_authorized_debit AS is_authorized_debit_72,
  o0_.history_nav_tunnel AS history_nav_tunnel_73,
  o0_.note AS note_74,
  o0_.reason_change AS reason_change_75,
  o0_.previous_pack AS previous_pack_76,
  o0_.zapier_hook_url AS zapier_hook_url_77,
  o0_.sigle AS sigle_78,
  o0_.enseigne AS enseigne_79,
  o0_.corporate_object AS corporate_object_80,
  o0_.place_know_digidom AS place_know_digidom_81,
  o0_.other_place_known_digidom AS other_place_known_digidom_82,
  o0_.bank_name AS bank_name_83,
  o0_.titulaire AS titulaire_84,
  o0_.is_invalid_email AS is_invalid_email_85,
  o0_.is_invalid_phone_number AS is_invalid_phone_number_86,
  o0_.special_customer_type AS special_customer_type_87,
  o0_.encrypted_parent_id AS encrypted_parent_id_88,
  o0_.is_referral_process_finished AS is_referral_process_finished_89,
  o0_.is_digidom_accountant AS is_digidom_accountant_90,
  o0_.is_surveillance AS is_surveillance_91,
  o0_.beneficial_owners AS beneficial_owners_92,
  o0_.accounts_submission_last_year AS accounts_submission_last_year_93,
  o0_.address_id AS address_id_94,
  o0_.accountant_id AS accountant_id_95,
  o0_.sector_id AS sector_id_96,
  o0_.store_id AS store_id_97,
  o0_.forwarding_address_id AS forwarding_address_id_98,
  o0_.prescriber_id AS prescriber_id_99,
  o0_.notification_preference_id AS notification_preference_id_100,
  o0_.discount_code_id AS discount_code_id_101,
  o0_.prescriber_source_id AS prescriber_source_id_102,
  o0_.reason_unpaid_id AS reason_unpaid_id_103,
  o0_.reason_ribinactive_id AS reason_ribinactive_id_104,
  o0_.activity_category_id AS activity_category_id_105,
  o0_.referral_source_id AS referral_source_id_106,
  o0_.activity_domain_id AS activity_domain_id_107
FROM
  organization o0_
WHERE
  o0_.id = ?

SELECT o0_.id AS id_0, o0_.legal_name AS legal_name_1, o0_.telephone AS telephone_2, o0_.vat_id AS vat_id_3, o0_.legal_status AS legal_status_4, o0_.purpose AS purpose_5, o0_.founding_date AS founding_date_6, o0_.fiscal_date AS fiscal_date_7, o0_.fiscal_date_end AS fiscal_date_end_8, o0_.first_fiscal_date AS first_fiscal_date_9, o0_.first_fiscal_date_end AS first_fiscal_date_end_10, o0_.head_quarters_address_type AS head_quarters_address_type_11, o0_.legal_representative_address_type AS legal_representative_address_type_12, o0_.share_capital AS share_capital_13, o0_.share_capital_type AS share_capital_type_14, o0_.share_capital_fixed_amount AS share_capital_fixed_amount_15, o0_.shares_count AS shares_count_16, o0_.bank_choice AS bank_choice_17, o0_.registration_source AS registration_source_18, o0_.commercial_court_registry AS commercial_court_registry_19, o0_.sector_other AS sector_other_20, o0_.rcs AS rcs_21, o0_.status AS status_22, o0_.email AS email_23, o0_.mandatary AS mandatary_24, o0_.bal AS bal_25, o0_.forwarding_frequency AS forwarding_frequency_26, o0_.forwarding_address_name AS forwarding_address_name_27, o0_.alternate_name AS alternate_name_28, o0_.domiciliation_start_date AS domiciliation_start_date_29, o0_.created_at AS created_at_30, o0_.termination_date AS termination_date_31, o0_.termination_reason AS termination_reason_32, o0_.termination_reason_other AS termination_reason_other_33, o0_.siret AS siret_34, o0_.is_new_immatriculation AS is_new_immatriculation_35, o0_.is_new_domiciliation AS is_new_domiciliation_36, o0_.mandat_id AS mandat_id_37, o0_.conversion_reason AS conversion_reason_38, o0_.status_is_forced AS status_is_forced_39, o0_.uniq_id AS uniq_id_40, o0_.iban AS iban_41, o0_.reference_gocardless AS reference_gocardless_42, o0_.is_forwarding_active AS is_forwarding_active_43, o0_.vatrate AS vatrate_44, o0_.is_imported AS is_imported_45, o0_.credit_notes_amount AS credit_notes_amount_46, o0_.available_credits AS available_credits_47, o0_.invoice_token AS invoice_token_48, o0_.share_capital_free_percentage AS share_capital_free_percentage_49, o0_.is_prescriber AS is_prescriber_50, o0_.have_accountant AS have_accountant_51, o0_.status_immatriculation AS status_immatriculation_52, o0_.is_exempt_tva AS is_exempt_tva_53, o0_.project_stage AS project_stage_54, o0_.status_invoice_payed AS status_invoice_payed_55, o0_.date_max_unpaid AS date_max_unpaid_56, o0_.is_have_auditor AS is_have_auditor_57, o0_.benefit_imposition AS benefit_imposition_58, o0_.benefit_imposition_option AS benefit_imposition_option_59, o0_.vat_taxe_regim AS vat_taxe_regim_60, o0_.vat_taxe_regime_option AS vat_taxe_regime_option_61, o0_.prolongation_date_kyc AS prolongation_date_kyc_62, o0_.status_transfert AS status_transfert_63, o0_.is_new_transfert AS is_new_transfert_64, o0_.special_request_bal AS special_request_bal_65, o0_.trac_fin AS trac_fin_66, o0_.trac_fin_note AS trac_fin_note_67, o0_.pack_imat AS pack_imat_68, o0_.is_authorize_prescriber AS is_authorize_prescriber_69, o0_.is_attached_to_prescriber AS is_attached_to_prescriber_70, o0_.is_emptybal AS is_emptybal_71, o0_.is_authorized_debit AS is_authorized_debit_72, o0_.history_nav_tunnel AS history_nav_tunnel_73, o0_.note AS note_74, o0_.reason_change AS reason_change_75, o0_.previous_pack AS previous_pack_76, o0_.zapier_hook_url AS zapier_hook_url_77, o0_.sigle AS sigle_78, o0_.enseigne AS enseigne_79, o0_.corporate_object AS corporate_object_80, o0_.place_know_digidom AS place_know_digidom_81, o0_.other_place_known_digidom AS other_place_known_digidom_82, o0_.bank_name AS bank_name_83, o0_.titulaire AS titulaire_84, o0_.is_invalid_email AS is_invalid_email_85, o0_.is_invalid_phone_number AS is_invalid_phone_number_86, o0_.special_customer_type AS special_customer_type_87, o0_.encrypted_parent_id AS encrypted_parent_id_88, o0_.is_referral_process_finished AS is_referral_process_finished_89, o0_.is_digidom_accountant AS is_digidom_accountant_90, o0_.is_surveillance AS is_surveillance_91, o0_.beneficial_owners AS beneficial_owners_92, o0_.accounts_submission_last_year AS accounts_submission_last_year_93, o0_.address_id AS address_id_94, o0_.accountant_id AS accountant_id_95, o0_.sector_id AS sector_id_96, o0_.store_id AS store_id_97, o0_.forwarding_address_id AS forwarding_address_id_98, o0_.prescriber_id AS prescriber_id_99, o0_.notification_preference_id AS notification_preference_id_100, o0_.discount_code_id AS discount_code_id_101, o0_.prescriber_source_id AS prescriber_source_id_102, o0_.reason_unpaid_id AS reason_unpaid_id_103, o0_.reason_ribinactive_id AS reason_ribinactive_id_104, o0_.activity_category_id AS activity_category_id_105, o0_.referral_source_id AS referral_source_id_106, o0_.activity_domain_id AS activity_domain_id_107 FROM organization o0_ WHERE o0_.id = 27499;

SELECT
  t0.id AS id_1,
  t0.given_name AS given_name_2,
  t0.family_name AS family_name_3,
  t0.phone_number AS phone_number_4,
  t0.email AS email_5,
  t0.service AS service_6,
  t0.created_at AS created_at_7,
  t0.note AS note_8,
  t0.status AS status_9,
  t0.generate_user AS generate_user_10,
  t0.call_time AS call_time_11,
  t0.priority AS priority_12,
  t0.date AS date_13,
  t0.step AS step_14,
  t0.source AS source_15,
  t0.legal_name AS legal_name_16,
  t0.pack AS pack_17,
  t0.manager_id AS manager_id_18,
  t0.formality_id AS formality_id_19,
  t0.organization_id AS organization_id_20
FROM
  leads t0
WHERE
  t0.organization_id = ?

SELECT t0.id AS id_1, t0.given_name AS given_name_2, t0.family_name AS family_name_3, t0.phone_number AS phone_number_4, t0.email AS email_5, t0.service AS service_6, t0.created_at AS created_at_7, t0.note AS note_8, t0.status AS status_9, t0.generate_user AS generate_user_10, t0.call_time AS call_time_11, t0.priority AS priority_12, t0.date AS date_13, t0.step AS step_14, t0.source AS source_15, t0.legal_name AS legal_name_16, t0.pack AS pack_17, t0.manager_id AS manager_id_18, t0.formality_id AS formality_id_19, t0.organization_id AS organization_id_20 FROM leads t0 WHERE t0.organization_id = 27499;

SELECT
  t0.id AS id_1,
  t0.alternate_name AS alternate_name_2,
  t0.legal_name AS legal_name_3,
  t0.name_legal_representative AS name_legal_representative_4,
  t0.organization_id AS organization_id_5
FROM
  ibml_organization_configuration t0
WHERE
  t0.organization_id = ?

SELECT t0.id AS id_1, t0.alternate_name AS alternate_name_2, t0.legal_name AS legal_name_3, t0.name_legal_representative AS name_legal_representative_4, t0.organization_id AS organization_id_5 FROM ibml_organization_configuration t0 WHERE t0.organization_id = 27499;

SELECT
  t0.id AS id_1,
  t0.signature_request_id AS signature_request_id_2,
  t0.created_at AS created_at_3,
  t0.external_file_id AS external_file_id_4,
  t0.last_uploaded_file_at AS last_uploaded_file_at_5,
  t0.organization_id AS organization_id_6
FROM
  process_yousign t0
WHERE
  t0.organization_id = ?

SELECT t0.id AS id_1, t0.signature_request_id AS signature_request_id_2, t0.created_at AS created_at_3, t0.external_file_id AS external_file_id_4, t0.last_uploaded_file_at AS last_uploaded_file_at_5, t0.organization_id AS organization_id_6 FROM process_yousign t0 WHERE t0.organization_id = 27499;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone_number AS phone_number_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.lastname AS lastname_6,
  t0.firstname AS firstname_7,
  t0.created_at AS created_at_8,
  t0.registration_source AS registration_source_9,
  t0.honorific_prefix AS honorific_prefix_10,
  t0.reset_token AS reset_token_11,
  t0.reset_token_expiration_date AS reset_token_expiration_date_12,
  t0.uniq_id AS uniq_id_13,
  t0.code_confirmation AS code_confirmation_14,
  t0.updated_at AS updated_at_15,
  t0.is_active AS is_active_16
FROM
  app_users t0
WHERE
  t0.email = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone_number AS phone_number_3, t0.password AS password_4, t0.roles AS roles_5, t0.lastname AS lastname_6, t0.firstname AS firstname_7, t0.created_at AS created_at_8, t0.registration_source AS registration_source_9, t0.honorific_prefix AS honorific_prefix_10, t0.reset_token AS reset_token_11, t0.reset_token_expiration_date AS reset_token_expiration_date_12, t0.uniq_id AS uniq_id_13, t0.code_confirmation AS code_confirmation_14, t0.updated_at AS updated_at_15, t0.is_active AS is_active_16 FROM app_users t0 WHERE t0.email = 'davy+6@digidom.pro' LIMIT 2;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO app_users (
  email, phone_number, PASSWORD, roles,
  lastname, firstname, created_at,
  registration_source, honorific_prefix,
  reset_token, reset_token_expiration_date,
  uniq_id, code_confirmation, updated_at,
  is_active
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO app_users (email, phone_number, PASSWORD, roles, lastname, firstname, created_at, registration_source, honorific_prefix, reset_token, reset_token_expiration_date, uniq_id, code_confirmation, updated_at, is_active) VALUES ('davy+6@digidom.pro', '', '$2y$12$0XrBkELGFv5hSrtjb/.lbeh9He/LeIMA8t0XBa1Cf7gxgOB5.ff1e', '[\"ROLE_USER\"]', NULL, 'fde', '2024-11-08 14:22:33', NULL, NULL, '1a5b89159dfe495de0b5b9ebb8fb63008c0d6462', '1731158555', '672e109bd44cb', NULL, NULL, 1);

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone_number AS phone_number_3,
  t0.password AS password_4,
  t0.roles AS roles_5,
  t0.lastname AS lastname_6,
  t0.firstname AS firstname_7,
  t0.created_at AS created_at_8,
  t0.registration_source AS registration_source_9,
  t0.honorific_prefix AS honorific_prefix_10,
  t0.reset_token AS reset_token_11,
  t0.reset_token_expiration_date AS reset_token_expiration_date_12,
  t0.uniq_id AS uniq_id_13,
  t0.code_confirmation AS code_confirmation_14,
  t0.updated_at AS updated_at_15,
  t0.is_active AS is_active_16
FROM
  app_users t0
  INNER JOIN organization_user ON t0.id = organization_user.user_id
WHERE
  organization_user.organization_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone_number AS phone_number_3, t0.password AS password_4, t0.roles AS roles_5, t0.lastname AS lastname_6, t0.firstname AS firstname_7, t0.created_at AS created_at_8, t0.registration_source AS registration_source_9, t0.honorific_prefix AS honorific_prefix_10, t0.reset_token AS reset_token_11, t0.reset_token_expiration_date AS reset_token_expiration_date_12, t0.uniq_id AS uniq_id_13, t0.code_confirmation AS code_confirmation_14, t0.updated_at AS updated_at_15, t0.is_active AS is_active_16 FROM app_users t0 INNER JOIN organization_user ON t0.id = organization_user.user_id WHERE organization_user.organization_id = 27499;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.status AS status_4,
  t0.reason_not_approved AS reason_not_approved_5,
  t0.path AS path_6,
  t0.expiration_date AS expiration_date_7,
  t0.created_at AS created_at_8,
  t0.aws_path AS aws_path_9,
  t0.signed_by AS signed_by_10,
  t0.yousign_link AS yousign_link_11,
  t0.awaiting_validation_date AS awaiting_validation_date_12,
  t0.yousign_error AS yousign_error_13,
  t0.html_document AS html_document_14,
  t0.label AS label_15,
  t0.rejection_message_title AS rejection_message_title_16,
  t0.rejection_message_description AS rejection_message_description_17,
  t0.is_from_pappers AS is_from_pappers_18,
  t0.organization_id AS organization_id_19,
  t0.rejection_message_id AS rejection_message_id_20,
  t0.person_id AS person_id_21,
  t0.potential_case_id AS potential_case_id_22
FROM
  document t0
WHERE
  t0.organization_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.status AS status_4, t0.reason_not_approved AS reason_not_approved_5, t0.path AS path_6, t0.expiration_date AS expiration_date_7, t0.created_at AS created_at_8, t0.aws_path AS aws_path_9, t0.signed_by AS signed_by_10, t0.yousign_link AS yousign_link_11, t0.awaiting_validation_date AS awaiting_validation_date_12, t0.yousign_error AS yousign_error_13, t0.html_document AS html_document_14, t0.label AS label_15, t0.rejection_message_title AS rejection_message_title_16, t0.rejection_message_description AS rejection_message_description_17, t0.is_from_pappers AS is_from_pappers_18, t0.organization_id AS organization_id_19, t0.rejection_message_id AS rejection_message_id_20, t0.person_id AS person_id_21, t0.potential_case_id AS potential_case_id_22 FROM document t0 WHERE t0.organization_id = 27499;

SELECT
  t0.id AS id_1,
  t0.quality AS quality_2,
  t0.email AS email_3,
  t0.phone_number AS phone_number_4,
  t0.share_capital AS share_capital_5,
  t0.contribution_type AS contribution_type_6,
  t0.contribution_amount AS contribution_amount_7,
  t0.is_associate AS is_associate_8,
  t9.id AS id_10,
  t9.contribution_type AS contribution_type_11,
  t9.contribution_amount AS contribution_amount_12,
  t9.share_capital AS share_capital_13,
  t9.created_at AS created_at_14,
  t9.quality AS quality_15,
  t9.legal_representative_id AS legal_representative_id_16,
  t9.person_id AS person_id_17,
  t9.is_legal_representative_id AS is_legal_representative_id_18,
  t0.parent_id AS parent_id_19,
  t0.person_id AS person_id_20
FROM
  legal_representative t0
  LEFT JOIN associate t9 ON t9.legal_representative_id = t0.id
  INNER JOIN organization_legal_representative ON t0.id = organization_legal_representative.legal_representative_id
WHERE
  organization_legal_representative.organization_id = ?

SELECT t0.id AS id_1, t0.quality AS quality_2, t0.email AS email_3, t0.phone_number AS phone_number_4, t0.share_capital AS share_capital_5, t0.contribution_type AS contribution_type_6, t0.contribution_amount AS contribution_amount_7, t0.is_associate AS is_associate_8, t9.id AS id_10, t9.contribution_type AS contribution_type_11, t9.contribution_amount AS contribution_amount_12, t9.share_capital AS share_capital_13, t9.created_at AS created_at_14, t9.quality AS quality_15, t9.legal_representative_id AS legal_representative_id_16, t9.person_id AS person_id_17, t9.is_legal_representative_id AS is_legal_representative_id_18, t0.parent_id AS parent_id_19, t0.person_id AS person_id_20 FROM legal_representative t0 LEFT JOIN associate t9 ON t9.legal_representative_id = t0.id INNER JOIN organization_legal_representative ON t0.id = organization_legal_representative.legal_representative_id WHERE organization_legal_representative.organization_id = 27499;

SELECT
  t0.id AS id_1,
  t0.honorific_prefix AS honorific_prefix_2,
  t0.family_name AS family_name_3,
  t0.given_name AS given_name_4,
  t0.birth_date AS birth_date_5,
  t0.nationality AS nationality_6,
  t0.type AS type_7,
  t0.siret AS siret_8,
  t0.legal_name AS legal_name_9,
  t0.registration_city AS registration_city_10,
  t0.legal_status AS legal_status_11,
  t0.father_honorific_prefix AS father_honorific_prefix_12,
  t0.father_family_name AS father_family_name_13,
  t0.father_given_name AS father_given_name_14,
  t0.mother_honorific_prefix AS mother_honorific_prefix_15,
  t0.mother_birth_name AS mother_birth_name_16,
  t0.mother_given_name AS mother_given_name_17,
  t0.birth_name AS birth_name_18,
  t0.is_hosted AS is_hosted_19,
  t0.securite_sociale AS securite_sociale_20,
  t0.assurance_maladie AS assurance_maladie_21,
  t0.declaration_cotisation AS declaration_cotisation_22,
  t0.prelevement_liberatoire_impot AS prelevement_liberatoire_impot_23,
  t0.address_id AS address_id_24,
  t0.birth_place_id AS birth_place_id_25
FROM
  person t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.honorific_prefix AS honorific_prefix_2, t0.family_name AS family_name_3, t0.given_name AS given_name_4, t0.birth_date AS birth_date_5, t0.nationality AS nationality_6, t0.type AS type_7, t0.siret AS siret_8, t0.legal_name AS legal_name_9, t0.registration_city AS registration_city_10, t0.legal_status AS legal_status_11, t0.father_honorific_prefix AS father_honorific_prefix_12, t0.father_family_name AS father_family_name_13, t0.father_given_name AS father_given_name_14, t0.mother_honorific_prefix AS mother_honorific_prefix_15, t0.mother_birth_name AS mother_birth_name_16, t0.mother_given_name AS mother_given_name_17, t0.birth_name AS birth_name_18, t0.is_hosted AS is_hosted_19, t0.securite_sociale AS securite_sociale_20, t0.assurance_maladie AS assurance_maladie_21, t0.declaration_cotisation AS declaration_cotisation_22, t0.prelevement_liberatoire_impot AS prelevement_liberatoire_impot_23, t0.address_id AS address_id_24, t0.birth_place_id AS birth_place_id_25 FROM person t0 WHERE t0.id = 69876;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.status AS status_4,
  t0.reason_not_approved AS reason_not_approved_5,
  t0.path AS path_6,
  t0.expiration_date AS expiration_date_7,
  t0.created_at AS created_at_8,
  t0.aws_path AS aws_path_9,
  t0.signed_by AS signed_by_10,
  t0.yousign_link AS yousign_link_11,
  t0.awaiting_validation_date AS awaiting_validation_date_12,
  t0.yousign_error AS yousign_error_13,
  t0.html_document AS html_document_14,
  t0.label AS label_15,
  t0.rejection_message_title AS rejection_message_title_16,
  t0.rejection_message_description AS rejection_message_description_17,
  t0.is_from_pappers AS is_from_pappers_18,
  t0.organization_id AS organization_id_19,
  t0.rejection_message_id AS rejection_message_id_20,
  t0.person_id AS person_id_21,
  t0.potential_case_id AS potential_case_id_22
FROM
  document t0
WHERE
  t0.person_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.status AS status_4, t0.reason_not_approved AS reason_not_approved_5, t0.path AS path_6, t0.expiration_date AS expiration_date_7, t0.created_at AS created_at_8, t0.aws_path AS aws_path_9, t0.signed_by AS signed_by_10, t0.yousign_link AS yousign_link_11, t0.awaiting_validation_date AS awaiting_validation_date_12, t0.yousign_error AS yousign_error_13, t0.html_document AS html_document_14, t0.label AS label_15, t0.rejection_message_title AS rejection_message_title_16, t0.rejection_message_description AS rejection_message_description_17, t0.is_from_pappers AS is_from_pappers_18, t0.organization_id AS organization_id_19, t0.rejection_message_id AS rejection_message_id_20, t0.person_id AS person_id_21, t0.potential_case_id AS potential_case_id_22 FROM document t0 WHERE t0.person_id = 69876;

SELECT
  t0.id AS id_1,
  t0.quality AS quality_2,
  t0.email AS email_3,
  t0.phone_number AS phone_number_4,
  t0.share_capital AS share_capital_5,
  t0.contribution_type AS contribution_type_6,
  t0.contribution_amount AS contribution_amount_7,
  t0.is_associate AS is_associate_8,
  t9.id AS id_10,
  t9.contribution_type AS contribution_type_11,
  t9.contribution_amount AS contribution_amount_12,
  t9.share_capital AS share_capital_13,
  t9.created_at AS created_at_14,
  t9.quality AS quality_15,
  t9.legal_representative_id AS legal_representative_id_16,
  t9.person_id AS person_id_17,
  t9.is_legal_representative_id AS is_legal_representative_id_18,
  t0.parent_id AS parent_id_19,
  t0.person_id AS person_id_20
FROM
  legal_representative t0
  LEFT JOIN associate t9 ON t9.legal_representative_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.quality AS quality_2, t0.email AS email_3, t0.phone_number AS phone_number_4, t0.share_capital AS share_capital_5, t0.contribution_type AS contribution_type_6, t0.contribution_amount AS contribution_amount_7, t0.is_associate AS is_associate_8, t9.id AS id_10, t9.contribution_type AS contribution_type_11, t9.contribution_amount AS contribution_amount_12, t9.share_capital AS share_capital_13, t9.created_at AS created_at_14, t9.quality AS quality_15, t9.legal_representative_id AS legal_representative_id_16, t9.person_id AS person_id_17, t9.is_legal_representative_id AS is_legal_representative_id_18, t0.parent_id AS parent_id_19, t0.person_id AS person_id_20 FROM legal_representative t0 LEFT JOIN associate t9 ON t9.legal_representative_id = t0.id WHERE t0.parent_id = 47243;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.confirmation_number AS confirmation_number_4,
  t0.status AS status_5,
  t0.period_start AS period_start_6,
  t0.period_end AS period_end_7,
  t0.period_length AS period_length_8,
  t0.vatrate AS vatrate_9,
  t0.price_without_tax AS price_without_tax_10,
  t0.object AS object_11,
  t0.path AS path_12,
  t0.price AS price_13,
  t0.payment_recurrence AS payment_recurrence_14,
  t0.new_organization_legal_name AS new_organization_legal_name_15,
  t0.new_organization_vatid AS new_organization_vatid_16,
  t0.is_new_organization AS is_new_organization_17,
  t0.is_prescriber AS is_prescriber_18,
  t0.total_paid AS total_paid_19,
  t0.new_organization_user_email AS new_organization_user_email_20,
  t0.is_sent AS is_sent_21,
  t0.sent_date AS sent_date_22,
  t0.sent_to AS sent_to_23,
  t0.number AS number_24,
  t0.total_refund AS total_refund_25,
  t0.is_canceled AS is_canceled_26,
  t0.discount_without_tax AS discount_without_tax_27,
  t0.discount_without_tax_percent AS discount_without_tax_percent_28,
  t0.is_imported AS is_imported_29,
  t0.is_domiciliation AS is_domiciliation_30,
  t0.payment_url AS payment_url_31,
  t0.reference AS reference_32,
  t0.remaining_to_pay AS remaining_to_pay_33,
  t0.total_refunded_payment AS total_refunded_payment_34,
  t0.marge AS marge_35,
  t0.is_new_organization_prescribed AS is_new_organization_prescribed_36,
  t0.is_not_in_prescriber AS is_not_in_prescriber_37,
  t0.new_prescriber_legal_name AS new_prescriber_legal_name_38,
  t0.new_prescriber_vatid AS new_prescriber_vatid_39,
  t0.new_prescriber_user_email AS new_prescriber_user_email_40,
  t0.is_attached_to_prescriber AS is_attached_to_prescriber_41,
  t0.invoice_type AS invoice_type_42,
  t0.reference_stripe AS reference_stripe_43,
  t0.new_organization_phone_number AS new_organization_phone_number_44,
  t0.payment_deadline AS payment_deadline_45,
  t0.is_template AS is_template_46,
  t0.unique_key AS unique_key_47,
  t0.is_paid_by_stripe AS is_paid_by_stripe_48,
  t0.is_pack_invoice AS is_pack_invoice_49,
  t0.sync_billing_report AS sync_billing_report_50,
  t0.external_id AS external_id_51,
  t0.organization_id AS organization_id_52,
  t0.user_id AS user_id_53,
  t0.new_organization_address_id AS new_organization_address_id_54,
  t55.id AS id_56,
  t55.created_at AS created_at_57,
  t55.updated_at AS updated_at_58,
  t55.status AS status_59,
  t55.vatrate AS vatrate_60,
  t55.price_without_tax AS price_without_tax_61,
  t55.object AS object_62,
  t55.path AS path_63,
  t55.price AS price_64,
  t55.new_organization_legal_name AS new_organization_legal_name_65,
  t55.new_organization_vatid AS new_organization_vatid_66,
  t55.is_new_organization AS is_new_organization_67,
  t55.is_prescriber AS is_prescriber_68,
  t55.new_organization_user_email AS new_organization_user_email_69,
  t55.is_sent AS is_sent_70,
  t55.sent_date AS sent_date_71,
  t55.sent_to AS sent_to_72,
  t55.number AS number_73,
  t55.is_canceled AS is_canceled_74,
  t55.discount_without_tax AS discount_without_tax_75,
  t55.discount_without_tax_percent AS discount_without_tax_percent_76,
  t55.invoice_is_generated AS invoice_is_generated_77,
  t55.payment_url AS payment_url_78,
  t55.is_generate AS is_generate_79,
  t55.marge AS marge_80,
  t55.new_organization_phone_number AS new_organization_phone_number_81,
  t55.is_new_organization_prescribed AS is_new_organization_prescribed_82,
  t55.is_not_in_prescriber AS is_not_in_prescriber_83,
  t55.new_prescriber_legal_name AS new_prescriber_legal_name_84,
  t55.new_prescriber_vatid AS new_prescriber_vatid_85,
  t55.new_prescriber_user_email AS new_prescriber_user_email_86,
  t55.is_attached_to_prescriber AS is_attached_to_prescriber_87,
  t55.is_paid_by_stripe AS is_paid_by_stripe_88,
  t55.organization_id AS organization_id_89,
  t55.new_organization_address_id AS new_organization_address_id_90,
  t55.invoice_id AS invoice_id_91,
  t55.prescriber_id AS prescriber_id_92,
  t55.new_prescriber_address_id AS new_prescriber_address_id_93,
  t55.discount_code_id AS discount_code_id_94,
  t0.prescriber_id AS prescriber_id_95,
  t0.new_prescriber_address_id AS new_prescriber_address_id_96,
  t97.id AS id_98,
  t97.created_at AS created_at_99,
  t97.updated_at AS updated_at_100,
  t97.is_done AS is_done_101,
  t97.comment AS comment_102,
  t97.npai AS npai_103,
  t97.price_without_tax AS price_without_tax_104,
  t97.tracking_number AS tracking_number_105,
  t97.price AS price_106,
  t97.days_keep AS days_keep_107,
  t97.organization_id AS organization_id_108,
  t97.invoice_id AS invoice_id_109,
  t0.invoice_parent_id AS invoice_parent_id_110,
  t111.id AS id_112,
  t111.created_at AS created_at_113,
  t111.updated_at AS updated_at_114,
  t111.confirmation_number AS confirmation_number_115,
  t111.status AS status_116,
  t111.period_start AS period_start_117,
  t111.period_end AS period_end_118,
  t111.period_length AS period_length_119,
  t111.vatrate AS vatrate_120,
  t111.price_without_tax AS price_without_tax_121,
  t111.object AS object_122,
  t111.path AS path_123,
  t111.price AS price_124,
  t111.payment_recurrence AS payment_recurrence_125,
  t111.new_organization_legal_name AS new_organization_legal_name_126,
  t111.new_organization_vatid AS new_organization_vatid_127,
  t111.is_new_organization AS is_new_organization_128,
  t111.is_prescriber AS is_prescriber_129,
  t111.total_paid AS total_paid_130,
  t111.new_organization_user_email AS new_organization_user_email_131,
  t111.is_sent AS is_sent_132,
  t111.sent_date AS sent_date_133,
  t111.sent_to AS sent_to_134,
  t111.number AS number_135,
  t111.total_refund AS total_refund_136,
  t111.is_canceled AS is_canceled_137,
  t111.discount_without_tax AS discount_without_tax_138,
  t111.discount_without_tax_percent AS discount_without_tax_percent_139,
  t111.is_imported AS is_imported_140,
  t111.is_domiciliation AS is_domiciliation_141,
  t111.payment_url AS payment_url_142,
  t111.reference AS reference_143,
  t111.remaining_to_pay AS remaining_to_pay_144,
  t111.total_refunded_payment AS total_refunded_payment_145,
  t111.marge AS marge_146,
  t111.is_new_organization_prescribed AS is_new_organization_prescribed_147,
  t111.is_not_in_prescriber AS is_not_in_prescriber_148,
  t111.new_prescriber_legal_name AS new_prescriber_legal_name_149,
  t111.new_prescriber_vatid AS new_prescriber_vatid_150,
  t111.new_prescriber_user_email AS new_prescriber_user_email_151,
  t111.is_attached_to_prescriber AS is_attached_to_prescriber_152,
  t111.invoice_type AS invoice_type_153,
  t111.reference_stripe AS reference_stripe_154,
  t111.new_organization_phone_number AS new_organization_phone_number_155,
  t111.payment_deadline AS payment_deadline_156,
  t111.is_template AS is_template_157,
  t111.unique_key AS unique_key_158,
  t111.is_paid_by_stripe AS is_paid_by_stripe_159,
  t111.is_pack_invoice AS is_pack_invoice_160,
  t111.sync_billing_report AS sync_billing_report_161,
  t111.external_id AS external_id_162,
  t111.organization_id AS organization_id_163,
  t111.user_id AS user_id_164,
  t111.new_organization_address_id AS new_organization_address_id_165,
  t111.prescriber_id AS prescriber_id_166,
  t111.new_prescriber_address_id AS new_prescriber_address_id_167,
  t111.invoice_parent_id AS invoice_parent_id_168,
  t111.discount_code_id AS discount_code_id_169,
  t0.discount_code_id AS discount_code_id_170
FROM
  invoice t0
  LEFT JOIN quote t55 ON t55.invoice_id = t0.id
  LEFT JOIN letter_forward t97 ON t97.invoice_id = t0.id
  LEFT JOIN invoice t111 ON t111.invoice_parent_id = t0.id
WHERE
  t0.organization_id = ?