Query Metrics

5 Database Queries
3 Different statements
97.61 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
89.09 ms
(91.28%)
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"
]
5.18 ms
(5.30%)
1
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM pappers_activity_log_wrapper p0_ INNER JOIN activity_log a1_ ON p0_.activity_log_id = a1_.id INNER JOIN organization o2_ ON a1_.organization_id = o2_.id WHERE p0_.id IN (SELECT p3_.id FROM pappers_activity_log_wrapper p3_ INNER JOIN activity_log a4_ ON p3_.activity_log_id = a4_.id INNER JOIN organization o5_ ON a4_.organization_id = o5_.id WHERE p3_.status = ? AND o5_.id = ? AND p3_.documents LIKE CONCAT('%', ?, '%'))
Parameters:
[
  "SENT"
  "27817"
  "KBIS_CANCELLATION"
]
3.34 ms
(3.42%)
1
SELECT p0_.id AS id_0, p0_.status AS status_1, p0_.documents AS documents_2, p0_.activity_log_id AS activity_log_id_3, p0_.user_id AS user_id_4 FROM pappers_activity_log_wrapper p0_ INNER JOIN activity_log a1_ ON p0_.activity_log_id = a1_.id INNER JOIN organization o2_ ON a1_.organization_id = o2_.id WHERE p0_.id IN (SELECT p3_.id FROM pappers_activity_log_wrapper p3_ INNER JOIN activity_log a4_ ON p3_.activity_log_id = a4_.id INNER JOIN organization o5_ ON a4_.organization_id = o5_.id WHERE p3_.status = ? AND o5_.id = ? AND p3_.documents LIKE CONCAT('%', ?, '%')) ORDER BY a1_.created_at DESC LIMIT 30
Parameters:
[
  "SENT"
  "27817"
  "KBIS_CANCELLATION"
]

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\PappersActivityLogWrapper No errors.
Evo\Infrastructure\MappingORM\ActivityLog No errors.
Evo\Infrastructure\MappingORM\Organization No errors.
Evo\Infrastructure\MappingORM\User No errors.
Evo\Infrastructure\MappingORM\CreditNote No errors.
Evo\Infrastructure\MappingORM\Quote No errors.
Evo\Infrastructure\MappingORM\Store No errors.
Evo\Infrastructure\MappingORM\UserUTM No errors.
Evo\Infrastructure\MappingORM\Lead No errors.
Evo\Infrastructure\MappingORM\CommercialGesture No errors.
Evo\Infrastructure\MappingORM\ActivityDomain No errors.
Evo\Infrastructure\MappingORM\ActivitySubdomain No errors.
Evo\Infrastructure\MappingORM\ProfessionDetail No errors.
Evo\Infrastructure\MappingORM\ProfessionType No errors.
Evo\Infrastructure\MappingORM\LegalRepresentative No errors.
Evo\Infrastructure\MappingORM\PostalAddress No errors.
Evo\Infrastructure\MappingORM\DiscountCode No errors.
Evo\Infrastructure\MappingORM\Pack No errors.
Evo\Infrastructure\MappingORM\Category No errors.
Evo\Infrastructure\MappingORM\ProductHistory No errors.
Evo\Infrastructure\MappingORM\DiscountConfiguration No errors.
Evo\Infrastructure\MappingORM\Payment No errors.
Evo\Infrastructure\MappingORM\Item No errors.
Evo\Infrastructure\MappingORM\PotentialCase 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\Order No errors.
Evo\Infrastructure\MappingORM\Service No errors.