Query Metrics
28
Database Queries
25
Different statements
85.38 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 39.82 ms |
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 = ?
Parameters:
[ "florian@digidom.pro" "florian@digidom.pro" ] |
2 | 1.83 ms |
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 = ?
Parameters:
[
23797
]
|
3 | 1.21 ms |
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 = ?
Parameters:
[
23797
]
|
4 | 1.12 ms |
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 = ?
Parameters:
[
23797
]
|
5 | 1.20 ms |
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 = ?
Parameters:
[
23797
]
|
6 | 1.70 ms |
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 = ?
Parameters:
[
23797
]
|
7 | 1.04 ms |
"START TRANSACTION"
Parameters:
[] |
8 | 1.36 ms |
INSERT INTO document (name, TYPE, STATUS, reason_not_approved, path, expiration_date, created_at, aws_path, signed_by, yousign_link, awaiting_validation_date, yousign_error, html_document, label, rejection_message_title, rejection_message_description, is_from_pappers, organization_id, rejection_message_id, person_id, potential_case_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "Acte de cession" 2 => "SALES_DEED" 3 => "APPROVED" 4 => null 5 => "staging/organization/23797/2024-10-22/sales_deed.png" 6 => null 7 => "2024-10-22 13:23:42" 8 => "sales_deed.png" 9 => null 10 => null 11 => null 12 => null 13 => null 14 => null 15 => null 16 => null 17 => 0 18 => 23797 19 => null 20 => null 21 => null ] |
9 | 1.90 ms |
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 = ?
Parameters:
[
23797
]
|
10 | 1.63 ms |
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 = ?
Parameters:
[
23797
]
|
11 | 1.32 ms |
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 = ?
Parameters:
[
63505
]
|
12 | 1.63 ms |
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 = ?
Parameters:
[
63505
]
|
13 | 1.42 ms |
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 = ?
Parameters:
[
43285
]
|
14 | 2.95 ms |
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 = ?
Parameters:
[
23797
]
|
15 | 1.49 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price_without_tax AS unit_price_without_tax_3, t0.description AS description_4, t0.discount_without_tax AS discount_without_tax_5, t0.discount_without_tax_percent AS discount_without_tax_percent_6, t0.vatper_product AS vatper_product_7, t0.is_offer AS is_offer_8, t0.offer_quantity AS offer_quantity_9, t0.is_trial_offer AS is_trial_offer_10, t0.is_remove_at_trial_end AS is_remove_at_trial_end_11, t0.deadline_offer AS deadline_offer_12, t0.product_id AS product_id_13, t0.invoice_id AS invoice_id_14, t0.quote_id AS quote_id_15, t0.item_order_id AS item_order_id_16, t0.subscription_model_id AS subscription_model_id_17, t0.subscription_included_id AS subscription_included_id_18 FROM item t0 WHERE t0.invoice_id = ?
Parameters:
[
189096
]
|
16 | 1.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
17
]
|
17 | 1.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alternate_name AS alternate_name_3, t0.price_without_tax AS price_without_tax_4, t0.description AS description_5, t0.active AS active_6, t0.meta_description AS meta_description_7, t0.meta_title AS meta_title_8, t0.url AS url_9, t0.created_at AS created_at_10, t0.subscription_type AS subscription_type_11, t0.unique_key AS unique_key_12, t0.is_displayed AS is_displayed_13, t0.is_archived AS is_archived_14, t0.is_subscription_component AS is_subscription_component_15, t0.category_id AS category_id_16, t0.category_for_billing_report_id AS category_for_billing_report_id_17 FROM product t0 WHERE t0.id = ?
Parameters:
[
106
]
|
18 | 2.01 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.status AS status_4, t0.vatrate AS vatrate_5, t0.price_without_tax AS price_without_tax_6, t0.object AS object_7, t0.path AS path_8, t0.price AS price_9, t0.new_organization_legal_name AS new_organization_legal_name_10, t0.new_organization_vatid AS new_organization_vatid_11, t0.is_new_organization AS is_new_organization_12, t0.is_prescriber AS is_prescriber_13, t0.new_organization_user_email AS new_organization_user_email_14, t0.is_sent AS is_sent_15, t0.sent_date AS sent_date_16, t0.sent_to AS sent_to_17, t0.number AS number_18, t0.is_canceled AS is_canceled_19, t0.discount_without_tax AS discount_without_tax_20, t0.discount_without_tax_percent AS discount_without_tax_percent_21, t0.invoice_is_generated AS invoice_is_generated_22, t0.payment_url AS payment_url_23, t0.is_generate AS is_generate_24, t0.marge AS marge_25, t0.new_organization_phone_number AS new_organization_phone_number_26, t0.is_new_organization_prescribed AS is_new_organization_prescribed_27, t0.is_not_in_prescriber AS is_not_in_prescriber_28, t0.new_prescriber_legal_name AS new_prescriber_legal_name_29, t0.new_prescriber_vatid AS new_prescriber_vatid_30, t0.new_prescriber_user_email AS new_prescriber_user_email_31, t0.is_attached_to_prescriber AS is_attached_to_prescriber_32, t0.is_paid_by_stripe AS is_paid_by_stripe_33, t0.organization_id AS organization_id_34, t0.new_organization_address_id AS new_organization_address_id_35, t0.invoice_id AS invoice_id_36, t0.prescriber_id AS prescriber_id_37, t0.new_prescriber_address_id AS new_prescriber_address_id_38, t0.discount_code_id AS discount_code_id_39 FROM quote t0 WHERE t0.organization_id = ?
Parameters:
[
23797
]
|
19 | 1.50 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.type AS type_2, d0_.status AS status_3, d0_.reason_not_approved AS reason_not_approved_4, d0_.path AS path_5, d0_.expiration_date AS expiration_date_6, d0_.created_at AS created_at_7, d0_.aws_path AS aws_path_8, d0_.signed_by AS signed_by_9, d0_.yousign_link AS yousign_link_10, d0_.awaiting_validation_date AS awaiting_validation_date_11, d0_.yousign_error AS yousign_error_12, d0_.html_document AS html_document_13, d0_.label AS label_14, d0_.rejection_message_title AS rejection_message_title_15, d0_.rejection_message_description AS rejection_message_description_16, d0_.is_from_pappers AS is_from_pappers_17, d0_.organization_id AS organization_id_18, d0_.rejection_message_id AS rejection_message_id_19, d0_.person_id AS person_id_20, d0_.potential_case_id AS potential_case_id_21 FROM document d0_ WHERE d0_.id <> ? AND d0_.type = ? AND d0_.organization_id = ?
Parameters:
[ 3186921 "SALES_DEED" 23797 ] |
20 | 4.17 ms |
SELECT t0.id AS id_1, t0.active AS active_2, t0.price AS price_3, t0.type AS type_4, t0.subscription_deposit AS subscription_deposit_5, t0.created_at AS created_at_6, t0.discount_without_tax AS discount_without_tax_7, t0.payment_dates AS payment_dates_8, t0.price_without_tax AS price_without_tax_9, t0.stored_total_price_without_tax AS stored_total_price_without_tax_10, t0.is_updated_price AS is_updated_price_11, t0.next_payment AS next_payment_12, t0.pack_history AS pack_history_13, t0.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_14, t0.invoice_generation_date AS invoice_generation_date_15, t0.month_number AS month_number_16, t0.authorized_reccurency AS authorized_reccurency_17, t0.is_cancel_using_offer AS is_cancel_using_offer_18, t0.is_digipack_offer AS is_digipack_offer_19, t0.deadline_offered AS deadline_offered_20, t0.prepaid_months AS prepaid_months_21, t0.has_blocked_service AS has_blocked_service_22, t0.document_recovery_delay AS document_recovery_delay_23, t0.updated_at AS updated_at_24, t0.organization_id AS organization_id_25, t26.id AS id_27, t26.name AS name_28, t26.price AS price_29, t26.focus AS focus_30, t26.price_without_tax AS price_without_tax_31, t26.vat_rate AS vat_rate_32, t26.discount AS discount_33, t26.unique_key AS unique_key_34, t26.automation AS automation_35, t26.is_published AS is_published_36, t26.is_subscription AS is_subscription_37, t26.published_name AS published_name_38, t26.is_published_pack AS is_published_pack_39, t26.type AS type_40, t26.legal_status AS legal_status_41, t26.created_at AS created_at_42, t26.association_pack_id AS association_pack_id_43, t26.category_id AS category_id_44, t26.recurring_invoice_id AS recurring_invoice_id_45, t26.initial_invoice_id AS initial_invoice_id_46, t26.subscription_id AS subscription_id_47 FROM subscription t0 LEFT JOIN pack t26 ON t26.subscription_id = t0.id WHERE t0.organization_id = ?
Parameters:
[
23797
]
|
21 | 2.29 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.price_without_tax AS price_without_tax_3, t0.trial AS trial_4, t0.remove_after_trial AS remove_after_trial_5, t0.trial_period_length AS trial_period_length_6, t0.created_at AS created_at_7, t0.product_id AS product_id_8, t9.id AS id_10, t9.name AS name_11, t9.alternate_name AS alternate_name_12, t9.price_without_tax AS price_without_tax_13, t9.description AS description_14, t9.active AS active_15, t9.meta_description AS meta_description_16, t9.meta_title AS meta_title_17, t9.url AS url_18, t9.created_at AS created_at_19, t9.subscription_type AS subscription_type_20, t9.unique_key AS unique_key_21, t9.is_displayed AS is_displayed_22, t9.is_archived AS is_archived_23, t9.is_subscription_component AS is_subscription_component_24, t9.category_id AS category_id_25, t9.category_for_billing_report_id AS category_for_billing_report_id_26, t0.subscription_id AS subscription_id_27, t28.id AS id_29, t28.active AS active_30, t28.price AS price_31, t28.type AS type_32, t28.subscription_deposit AS subscription_deposit_33, t28.created_at AS created_at_34, t28.discount_without_tax AS discount_without_tax_35, t28.payment_dates AS payment_dates_36, t28.price_without_tax AS price_without_tax_37, t28.stored_total_price_without_tax AS stored_total_price_without_tax_38, t28.is_updated_price AS is_updated_price_39, t28.next_payment AS next_payment_40, t28.pack_history AS pack_history_41, t28.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_42, t28.invoice_generation_date AS invoice_generation_date_43, t28.month_number AS month_number_44, t28.authorized_reccurency AS authorized_reccurency_45, t28.is_cancel_using_offer AS is_cancel_using_offer_46, t28.is_digipack_offer AS is_digipack_offer_47, t28.deadline_offered AS deadline_offered_48, t28.prepaid_months AS prepaid_months_49, t28.has_blocked_service AS has_blocked_service_50, t28.document_recovery_delay AS document_recovery_delay_51, t28.updated_at AS updated_at_52, t28.organization_id AS organization_id_53, t0.subscription_model_id AS subscription_model_id_54 FROM service t0 INNER JOIN product t9 ON t0.product_id = t9.id LEFT JOIN subscription t28 ON t0.subscription_id = t28.id WHERE t0.subscription_id = ?
Parameters:
[
35528
]
|
22 | 1.32 ms |
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 = ?
Parameters:
[
23797
]
|
23 | 1.65 ms |
INSERT INTO activity_log (method, created_at, object, change_set, note, category, legal_representative_id, organization_id, user_id, potential_case_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "CREATE" 2 => "2024-10-22 13:23:43" 3 => "CREATION DOCUMENT" 4 => "a:0:{}" 5 => "Acte de cession" 6 => "DOCUMENTS" 7 => null 8 => 23797 9 => 19664 10 => null ] |
24 | 1.32 ms |
INSERT INTO activity_log (method, created_at, object, change_set, note, category, legal_representative_id, organization_id, user_id, potential_case_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "UPDATE" 2 => "2024-10-22 13:23:43" 3 => "DOCUMENT Acte de cession" 4 => "a:1:{s:20:"CHANGEMENT DE STATUT";a:1:{s:1:"-";s:9:"Approuvé";}}" 5 => null 6 => "DOCUMENTS" 7 => null 8 => 23797 9 => 19664 10 => null ] |
25 | 2.07 ms |
"COMMIT"
Parameters:
[] |
26 | 1.38 ms |
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.id = ?
Parameters:
[
3186921
]
|
27 | 1.51 ms |
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 INNER JOIN process_yousign_document ON t0.id = process_yousign_document.process_yousign_id WHERE process_yousign_document.document_id = ?
Parameters:
[
3186921
]
|
28 | 1.89 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.signature_date AS signature_date_3, t0.admin_id AS admin_id_4, t0.legal_representative_id AS legal_representative_id_5, t0.document_id AS document_id_6, t0.process_yousign_id AS process_yousign_id_7 FROM signature t0 WHERE t0.document_id = ?
Parameters:
[
3186921
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
Evo\Infrastructure\MappingORM\Product | No errors. |
Evo\Infrastructure\MappingORM\Invoice | No errors. |
Evo\Infrastructure\MappingORM\Subscription | No errors. |
Evo\Infrastructure\MappingORM\SubscriptionModel | No errors. |
Evo\Infrastructure\MappingORM\User | No errors. |
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper | No errors. |
Evo\Infrastructure\MappingORM\CreditNote | No errors. |
Evo\Infrastructure\MappingORM\Quote | No errors. |
Evo\Infrastructure\MappingORM\Organization | No errors. |
Evo\Infrastructure\MappingORM\Store | No errors. |
Evo\Infrastructure\MappingORM\UserUTM | No errors. |
Evo\Infrastructure\MappingORM\Lead | No errors. |
Evo\Infrastructure\MappingORM\ActivityLog | No errors. |
Evo\Infrastructure\MappingORM\CommercialGesture | No errors. |
Evo\Infrastructure\MappingORM\Associate | No errors. |
Evo\Infrastructure\MappingORM\LegalRepresentative | No errors. |
Evo\Infrastructure\MappingORM\Auditor | No errors. |
Evo\Infrastructure\MappingORM\Document | No errors. |
Evo\Infrastructure\MappingORM\PostalAddress | No errors. |
Evo\Infrastructure\MappingORM\Accountant | No errors. |
Evo\Infrastructure\MappingORM\Letter | No errors. |
Evo\Infrastructure\MappingORM\OrganizationSector | No errors. |
Evo\Infrastructure\MappingORM\LetterForward | No errors. |
Evo\Infrastructure\MappingORM\Mandatary | No errors. |
Evo\Infrastructure\MappingORM\Order | No errors. |
Evo\Infrastructure\MappingORM\DocumentHistory | No errors. |
Evo\Infrastructure\MappingORM\NotificationPreference | No errors. |
Evo\Infrastructure\MappingORM\DiscountCode | No errors. |
Evo\Infrastructure\MappingORM\PrescriberSource | No errors. |
Evo\Infrastructure\MappingORM\ReasonUnpaid | No errors. |
Evo\Infrastructure\MappingORM\ReasonRIBInactive | No errors. |
Evo\Infrastructure\MappingORM\IbmlOrganizationConfiguration | No errors. |
Evo\Infrastructure\MappingORM\PotentialCase | No errors. |
Evo\Infrastructure\MappingORM\ProfessionDetail | No errors. |
Evo\Infrastructure\MappingORM\ActivityDomain | No errors. |
Evo\Infrastructure\MappingORM\ProcessYousign | No errors. |
Evo\Infrastructure\MappingORM\Signature | No errors. |
Evo\Infrastructure\MappingORM\DocumentRejectionMessage | No errors. |
Evo\Infrastructure\MappingORM\Person | No errors. |
Evo\Infrastructure\MappingORM\ProfessionType | No errors. |
Evo\Infrastructure\MappingORM\ActivitySubdomain | No errors. |
Evo\Infrastructure\MappingORM\PromoCodeHistory | No errors. |
Evo\Infrastructure\MappingORM\Sector | No errors. |
Evo\Infrastructure\MappingORM\Payment | No errors. |
Evo\Infrastructure\MappingORM\Item | No errors. |
Evo\Infrastructure\MappingORM\Refund | No errors. |
Evo\Infrastructure\MappingORM\Category | No errors. |
Evo\Infrastructure\MappingORM\ProductHistory | No errors. |
Evo\Infrastructure\MappingORM\DiscountConfiguration | No errors. |
Evo\Infrastructure\MappingORM\Pack | No errors. |
Evo\Infrastructure\MappingORM\Service | No errors. |