http://dev.api.digidom.pro/v1/letters?order%5BcreatedAt%5D=desc&organization=27817&page=1&q=%2Fv1%2Fletters

Query Metrics

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

Queries

Group similar statements

# Time Info
1 36.94 ms
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 30.29 ms
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:
[
  "fdnnrn@digidom.pro"
  "fdnnrn@digidom.pro"
]
3 34.46 ms
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:
[
  "_14c8b71ac21141ae322d6f1df15f517c"
  "_14c8b71ac21141ae322d6f1df15f517c"
]
4 2.87 ms
SELECT DISTINCT l0_.id AS id_0, l0_.created_at AS created_at_1 FROM letter l0_ INNER JOIN organization o1_ ON l0_.organization_id = o1_.id INNER JOIN organization_user o3_ ON o1_.id = o3_.organization_id INNER JOIN app_users a2_ ON a2_.id = o3_.user_id WHERE l0_.id IN (SELECT l4_.id FROM letter l4_ INNER JOIN organization o5_ ON l4_.organization_id = o5_.id INNER JOIN organization_user o7_ ON o5_.id = o7_.organization_id INNER JOIN app_users a6_ ON a6_.id = o7_.user_id WHERE a2_.id = ? AND l4_.deleted_at IS NULL AND l4_.organization_id = ?) ORDER BY l0_.created_at DESC LIMIT 30
Parameters:
[
  26167
  "27817"
]
5 2.11 ms
SELECT COUNT(DISTINCT l0_.id) AS sclr_0 FROM letter l0_ INNER JOIN organization o1_ ON l0_.organization_id = o1_.id INNER JOIN organization_user o3_ ON o1_.id = o3_.organization_id INNER JOIN app_users a2_ ON a2_.id = o3_.user_id WHERE l0_.id IN (SELECT l4_.id FROM letter l4_ INNER JOIN organization o5_ ON l4_.organization_id = o5_.id INNER JOIN organization_user o7_ ON o5_.id = o7_.organization_id INNER JOIN app_users a6_ ON a6_.id = o7_.user_id WHERE a2_.id = ? AND l4_.deleted_at IS NULL AND l4_.organization_id = ?)
Parameters:
[
  26167
  "27817"
]

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\Letter No errors.
Evo\Infrastructure\MappingORM\Organization No errors.
Evo\Infrastructure\MappingORM\Store 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\UserUTM No errors.
Evo\Infrastructure\MappingORM\Lead No errors.
Evo\Infrastructure\MappingORM\ActivityLog 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\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\LegalRepresentative No errors.
Evo\Infrastructure\MappingORM\Associate 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.