http://dev.api.digidom.pro/v1/documents/3185470?q=%2Fv1%2Fdocuments%2F3185470 Return to referer URL

Query Metrics

6 Database Queries
6 Different statements
37.01 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
28.60 ms
(77.29%)
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:
[
  "stanislas@digidom.pro"
  "stanislas@digidom.pro"
]
2.86 ms
(7.72%)
1
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:
[
  3185470
]
1.69 ms
(4.56%)
1
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:
[
  3185470
]
1.36 ms
(3.67%)
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 INNER JOIN process_yousign_document ON t0.id = process_yousign_document.process_yousign_id WHERE process_yousign_document.document_id = ?
Parameters:
[
  3185470
]
1.29 ms
(3.50%)
1
SELECT p0_.id AS id_0, p0_.honorific_prefix AS honorific_prefix_1, p0_.family_name AS family_name_2, p0_.given_name AS given_name_3, p0_.birth_date AS birth_date_4, p0_.nationality AS nationality_5, p0_.type AS type_6, p0_.siret AS siret_7, p0_.legal_name AS legal_name_8, p0_.registration_city AS registration_city_9, p0_.legal_status AS legal_status_10, p0_.father_honorific_prefix AS father_honorific_prefix_11, p0_.father_family_name AS father_family_name_12, p0_.father_given_name AS father_given_name_13, p0_.mother_honorific_prefix AS mother_honorific_prefix_14, p0_.mother_birth_name AS mother_birth_name_15, p0_.mother_given_name AS mother_given_name_16, p0_.birth_name AS birth_name_17, p0_.is_hosted AS is_hosted_18, p0_.securite_sociale AS securite_sociale_19, p0_.assurance_maladie AS assurance_maladie_20, p0_.declaration_cotisation AS declaration_cotisation_21, p0_.prelevement_liberatoire_impot AS prelevement_liberatoire_impot_22, p0_.address_id AS address_id_23, p0_.birth_place_id AS birth_place_id_24 FROM person p0_ WHERE p0_.id = ?
Parameters:
[
  68850
]
1.21 ms
(3.27%)
1
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 = ?
Parameters:
[
  3185470
]

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\Document No errors.
Evo\Infrastructure\MappingORM\DocumentRejectionMessage No errors.
Evo\Infrastructure\MappingORM\Person No errors.
Evo\Infrastructure\MappingORM\ProcessYousign No errors.
Evo\Infrastructure\MappingORM\Signature No errors.
Evo\Infrastructure\MappingORM\PotentialCase No errors.
Evo\Infrastructure\MappingORM\PostalAddress No errors.
Evo\Infrastructure\MappingORM\LegalRepresentative No errors.