Query Metrics

3 Database Queries
3 Different statements
44.50 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
30.00 ms
(67.41%)
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"
]
11.87 ms
(26.67%)
1
SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM activity_log a0_ LEFT JOIN legal_representative l1_ ON a0_.legal_representative_id = l1_.id INNER JOIN organization_legal_representative o3_ ON l1_.id = o3_.legal_representative_id INNER JOIN organization o2_ ON o2_.id = o3_.organization_id WHERE (a0_.organization_id = ? OR EXISTS (SELECT 1 FROM organization_legal_representative o4_ WHERE o4_.legal_representative_id = l1_.id AND o4_.organization_id IN (?))) AND a0_.organization_id IS NULL AND a0_.legal_representative_id IS NOT NULL AND o2_.id = ? AND a0_.category = ? AND a0_.change_set LIKE ? ORDER BY a0_.created_at DESC LIMIT 30
Parameters:
[
  27860
  27860
  27860
  "DOCUMENTS"
  "%Refusé%"
]
2.64 ms
(5.92%)
1
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM activity_log a0_ LEFT JOIN legal_representative l1_ ON a0_.legal_representative_id = l1_.id INNER JOIN organization_legal_representative o3_ ON l1_.id = o3_.legal_representative_id INNER JOIN organization o2_ ON o2_.id = o3_.organization_id WHERE (a0_.organization_id = ? OR EXISTS (SELECT 1 FROM organization_legal_representative o4_ WHERE o4_.legal_representative_id = l1_.id AND o4_.organization_id IN (?))) AND a0_.organization_id IS NULL AND a0_.legal_representative_id IS NOT NULL AND o2_.id = ? AND a0_.category = ? AND a0_.change_set LIKE ?
Parameters:
[
  27860
  27860
  27860
  "DOCUMENTS"
  "%Refusé%"
]

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\ActivityLog No errors.
Evo\Infrastructure\MappingORM\Organization No errors.
Evo\Infrastructure\MappingORM\PotentialCase No errors.
Evo\Infrastructure\MappingORM\LegalRepresentative No errors.
Evo\Infrastructure\MappingORM\PappersActivityLogWrapper 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.