Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

1 Different statements

93.73 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	39.82 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: [`"davy+6@digidom.pro" "davy+6@digidom.pro"`] View formatted query View runnable query Explain query 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 = ? 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 = 'davy+6@digidom.pro' OR a0_.phone_number = 'davy+6@digidom.pro';
2	23.16 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: [`"davy+6@digidom.pro" "davy+6@digidom.pro"`] View formatted query View runnable query Explain query 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 = ? 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 = 'davy+6@digidom.pro' OR a0_.phone_number = 'davy+6@digidom.pro';
3	30.75 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: [`"_d5b8339a9e234260f0f028a38d7b491f" "_d5b8339a9e234260f0f028a38d7b491f"`] View formatted query View runnable query Explain query 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 = ? 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 = '_d5b8339a9e234260f0f028a38d7b491f' OR a0_.phone_number = '_d5b8339a9e234260f0f028a38d7b491f';

#▲

Time

Info

39.82 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:

[
  "davy+6@digidom.pro"
  "davy+6@digidom.pro"
]

View formatted query View runnable query Explain query

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 = ?

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 = 'davy+6@digidom.pro' OR a0_.phone_number = 'davy+6@digidom.pro';

23.16 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:

[
  "davy+6@digidom.pro"
  "davy+6@digidom.pro"
]

View formatted query View runnable query Explain query

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 = ?

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 = 'davy+6@digidom.pro' OR a0_.phone_number = 'davy+6@digidom.pro';

30.75 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:

[
  "_d5b8339a9e234260f0f028a38d7b491f"
  "_d5b8339a9e234260f0f028a38d7b491f"
]

View formatted query View runnable query Explain query

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 = ?

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 = '_d5b8339a9e234260f0f028a38d7b491f' OR a0_.phone_number = '_d5b8339a9e234260f0f028a38d7b491f';

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\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\Document	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\LetterSignature	No errors.
Evo\Infrastructure\MappingORM\CMSSlug	No errors.
Evo\Infrastructure\MappingORM\CMSArticle	No errors.
Evo\Infrastructure\MappingORM\PromoCodeHistory	No errors.
Evo\Infrastructure\MappingORM\DocumentRejectionMessage	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\Person	No errors.
Evo\Infrastructure\MappingORM\Signature	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.

Symfony Profiler

http://staging.api.digidom.pro/v1/users?email=davy%2B6%40digidom.pro&q=%2Fv1%2Fusers

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping