http://dev.api.digidom.pro/v1/documents/3115861?q=%2Fv1%2Fdocuments%2F3115861

Query Metrics

4 Database Queries
2 Different statements
158.65 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
146.36 ms
(92.25%)
3
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"
]
12.29 ms
(7.75%)
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_ LEFT JOIN organization o1_ ON d0_.organization_id = o1_.id LEFT JOIN person p2_ ON d0_.person_id = p2_.id LEFT JOIN organization_user o4_ ON o1_.id = o4_.organization_id LEFT JOIN app_users a3_ ON a3_.id = o4_.user_id LEFT JOIN legal_representative l5_ ON (l5_.person_id = p2_.id) LEFT JOIN organization_legal_representative o7_ ON l5_.id = o7_.legal_representative_id LEFT JOIN organization o6_ ON o6_.id = o7_.organization_id LEFT JOIN organization_user o9_ ON o6_.id = o9_.organization_id LEFT JOIN app_users a8_ ON a8_.id = o9_.user_id LEFT JOIN legal_representative l10_ ON l5_.id = l10_.parent_id LEFT JOIN person p11_ ON l10_.person_id = p11_.id LEFT JOIN organization_legal_representative o13_ ON l10_.id = o13_.legal_representative_id LEFT JOIN organization o12_ ON o12_.id = o13_.organization_id LEFT JOIN organization_user o15_ ON o12_.id = o15_.organization_id LEFT JOIN app_users a14_ ON a14_.id = o15_.user_id LEFT JOIN legal_representative l16_ ON l5_.parent_id = l16_.id LEFT JOIN person p17_ ON l16_.person_id = p17_.id LEFT JOIN postal_address p18_ ON p17_.address_id = p18_.id LEFT JOIN postal_address p19_ ON p17_.birth_place_id = p19_.id LEFT JOIN organization_legal_representative o21_ ON l16_.id = o21_.legal_representative_id LEFT JOIN organization o20_ ON o20_.id = o21_.organization_id LEFT JOIN organization_user o23_ ON o20_.id = o23_.organization_id LEFT JOIN app_users a22_ ON a22_.id = o23_.user_id WHERE d0_.id = ? AND ((a3_.id IS NOT NULL AND a3_.id = ?) OR ((a8_.id IS NOT NULL AND a8_.id = ?) OR (a14_.id IS NOT NULL AND a14_.id = ?) OR (a22_.id IS NOT NULL AND a22_.id = ?)))
Parameters:
[
  3115861
  23504
  23504
  23504
  23504
]

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\Category No errors.
Evo\Infrastructure\MappingORM\ProductHistory No errors.
Evo\Infrastructure\MappingORM\DiscountCode No errors.
Evo\Infrastructure\MappingORM\DiscountConfiguration No errors.
Evo\Infrastructure\MappingORM\PostalAddress No errors.
Evo\Infrastructure\MappingORM\Payment No errors.
Evo\Infrastructure\MappingORM\Item No errors.
Evo\Infrastructure\MappingORM\LetterForward No errors.
Evo\Infrastructure\MappingORM\Refund No errors.
Evo\Infrastructure\MappingORM\PotentialCase No errors.
Evo\Infrastructure\MappingORM\Service No errors.
Evo\Infrastructure\MappingORM\Pack No errors.
Evo\Infrastructure\MappingORM\BAL No errors.
Evo\Infrastructure\MappingORM\Associate No errors.
Evo\Infrastructure\MappingORM\LegalRepresentative No errors.
Evo\Infrastructure\MappingORM\Auditor No errors.
Evo\Infrastructure\MappingORM\Accountant No errors.
Evo\Infrastructure\MappingORM\Letter No errors.
Evo\Infrastructure\MappingORM\OrganizationSector 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\PrescriberSource No errors.
Evo\Infrastructure\MappingORM\ReasonUnpaid No errors.
Evo\Infrastructure\MappingORM\ReasonRIBInactive No errors.
Evo\Infrastructure\MappingORM\IbmlOrganizationConfiguration No errors.
Evo\Infrastructure\MappingORM\ProfessionDetail No errors.
Evo\Infrastructure\MappingORM\ActivityDomain No errors.
Evo\Infrastructure\MappingORM\ProcessYousign No errors.
Evo\Infrastructure\MappingORM\Sector No errors.
Evo\Infrastructure\MappingORM\Task No errors.
Evo\Infrastructure\MappingORM\DocumentRejectionMessage No errors.
Evo\Infrastructure\MappingORM\Person No errors.
Evo\Infrastructure\MappingORM\Signature No errors.
Evo\Infrastructure\MappingORM\LetterSignature No errors.
Evo\Infrastructure\MappingORM\CMSSlug No errors.
Evo\Infrastructure\MappingORM\CMSArticle No errors.
Evo\Infrastructure\MappingORM\PromoCodeHistory No errors.
Evo\Infrastructure\MappingORM\Message No errors.
Evo\Infrastructure\MappingORM\AWSSync No errors.
Evo\Infrastructure\MappingORM\ProfessionType 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\ActivitySubdomain No errors.
Evo\Infrastructure\MappingORM\CMSCategory No errors.
Evo\Infrastructure\MappingORM\LetterTag No errors.
Vich\UploaderBundle\Entity\File No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.