Query Metrics
23
Database Queries
11
Different statements
63.21 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
32.55 ms (51.50%) |
1 |
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" ] |
8.53 ms (13.50%) |
5 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.alternate_name AS alternate_name_2, p0_.price_without_tax AS price_without_tax_3, p0_.description AS description_4, p0_.active AS active_5, p0_.meta_description AS meta_description_6, p0_.meta_title AS meta_title_7, p0_.url AS url_8, p0_.created_at AS created_at_9, p0_.subscription_type AS subscription_type_10, p0_.unique_key AS unique_key_11, p0_.is_displayed AS is_displayed_12, p0_.is_archived AS is_archived_13, p0_.is_subscription_component AS is_subscription_component_14, p0_.category_id AS category_id_15, p0_.category_for_billing_report_id AS category_for_billing_report_id_16 FROM product p0_ WHERE p0_.id = ?
Parameters:
[
2
]
|
6.82 ms (10.79%) |
5 |
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 IN (?)
Parameters:
[
[
2
]
]
|
5.73 ms (9.06%) |
5 |
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.price_without_tax AS price_without_tax_2, s0_.trial AS trial_3, s0_.remove_after_trial AS remove_after_trial_4, s0_.trial_period_length AS trial_period_length_5, s0_.created_at AS created_at_6, s0_.product_id AS product_id_7, s0_.subscription_id AS subscription_id_8, s0_.subscription_model_id AS subscription_model_id_9 FROM service s0_ WHERE s0_.id = ?
Parameters:
[
168839
]
|
1.60 ms (2.53%) |
1 |
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:
[
27889
]
|
1.50 ms (2.38%) |
1 |
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:
[
38402
]
|
1.47 ms (2.32%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.focus AS focus_4, t0.price_without_tax AS price_without_tax_5, t0.vat_rate AS vat_rate_6, t0.discount AS discount_7, t0.unique_key AS unique_key_8, t0.automation AS automation_9, t0.is_published AS is_published_10, t0.is_subscription AS is_subscription_11, t0.published_name AS published_name_12, t0.is_published_pack AS is_published_pack_13, t0.type AS type_14, t0.legal_status AS legal_status_15, t0.created_at AS created_at_16, t0.association_pack_id AS association_pack_id_17, t0.category_id AS category_id_18, t0.recurring_invoice_id AS recurring_invoice_id_19, t0.initial_invoice_id AS initial_invoice_id_20, t0.subscription_id AS subscription_id_21 FROM pack t0 WHERE t0.subscription_id = ?
Parameters:
[
38402
]
|
1.42 ms (2.25%) |
1 |
SELECT s0_.id AS id_0, s0_.active AS active_1, s0_.price AS price_2, s0_.type AS type_3, s0_.subscription_deposit AS subscription_deposit_4, s0_.created_at AS created_at_5, s0_.discount_without_tax AS discount_without_tax_6, s0_.payment_dates AS payment_dates_7, s0_.price_without_tax AS price_without_tax_8, s0_.stored_total_price_without_tax AS stored_total_price_without_tax_9, s0_.is_updated_price AS is_updated_price_10, s0_.next_payment AS next_payment_11, s0_.pack_history AS pack_history_12, s0_.not_accepted_scan_enveloppe AS not_accepted_scan_enveloppe_13, s0_.invoice_generation_date AS invoice_generation_date_14, s0_.month_number AS month_number_15, s0_.authorized_reccurency AS authorized_reccurency_16, s0_.is_cancel_using_offer AS is_cancel_using_offer_17, s0_.is_digipack_offer AS is_digipack_offer_18, s0_.deadline_offered AS deadline_offered_19, s0_.prepaid_months AS prepaid_months_20, s0_.has_blocked_service AS has_blocked_service_21, s0_.document_recovery_delay AS document_recovery_delay_22, s0_.updated_at AS updated_at_23, s0_.organization_id AS organization_id_24 FROM subscription s0_ WHERE s0_.id = ?
Parameters:
[
38402
]
|
1.23 ms (1.95%) |
1 |
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:
[
27889
]
|
1.20 ms (1.90%) |
1 |
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:
[
27889
]
|
1.15 ms (1.82%) |
1 |
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:
[
27889
]
|
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\Service | No errors. |
Evo\Infrastructure\MappingORM\Item | No errors. |
Evo\Infrastructure\MappingORM\Pack | No errors. |
Evo\Infrastructure\MappingORM\Category | 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\ProductHistory | No errors. |
Evo\Infrastructure\MappingORM\DiscountConfiguration | No errors. |
Evo\Infrastructure\MappingORM\Payment | No errors. |
Evo\Infrastructure\MappingORM\Refund | No errors. |
Evo\Infrastructure\MappingORM\BAL | No errors. |
Evo\Infrastructure\MappingORM\Sector | No errors. |
Evo\Infrastructure\MappingORM\Task | No errors. |
Evo\Infrastructure\MappingORM\Person | No errors. |
Evo\Infrastructure\MappingORM\DocumentRejectionMessage | No errors. |
Evo\Infrastructure\MappingORM\Signature | No errors. |
Evo\Infrastructure\MappingORM\LetterSignature | No errors. |
Evo\Infrastructure\MappingORM\LetterTag | No errors. |
Evo\Infrastructure\MappingORM\PromoCodeHistory | No errors. |
Evo\Infrastructure\MappingORM\ProfessionType | No errors. |
Evo\Infrastructure\MappingORM\ActivitySubdomain | No errors. |
Evo\Infrastructure\MappingORM\CMSSlug | No errors. |
Evo\Infrastructure\MappingORM\CMSArticle | No errors. |
Evo\Infrastructure\MappingORM\Message | No errors. |
Evo\Infrastructure\MappingORM\AWSSync | No errors. |
Evo\Infrastructure\MappingORM\Elastic\LetterOCRIndexation | No errors. |
Evo\Infrastructure\MappingORM\GocardlessEvent | No errors. |
Evo\Infrastructure\MappingORM\RiskyCountry | No errors. |
Evo\Infrastructure\MappingORM\RefreshToken | No errors. |
Evo\Infrastructure\MappingORM\CustomerIoEvent | No errors. |
Evo\Infrastructure\MappingORM\CMSCategory | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |