POST http://bandoo-dev.ru/api/login/by-email/request

Response
200 OK
IP
172.20.0.9
Profiled on
Token
d52583

Query Metrics

12 Database Queries
11 Different statements
18.39 ms Query time
3 Invalid entities
4 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.11 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 5.13 ms 
SELECT t0.id AS id_1, t0.trace_id AS trace_id_2, t0.started_at AS started_at_3, t0.finished_at AS finished_at_4, t0.status AS status_5, t0.initiator AS initiator_6, t0.metadata AS metadata_7 FROM mfv_flow_run t0 WHERE t0.id = ?
Parameters: 
[
  "f98bffd9-80fb-4c52-8fb4-8e504f7dafac"
]
View formatted query    View runnable query    Explain query
3 0.84 ms 
INSERT INTO mfv_flow_run (id, trace_id, started_at, finished_at, status, initiator, metadata) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "f98bffd9-80fb-4c52-8fb4-8e504f7dafac"
  "53e08883-aaca-46fd-9919-abdf2e4b2848"
  "2026-07-02 21:31:53"
  null
  "running"
  "http:POST /api/login/by-email/request"
  "[]"
]
View formatted query    View runnable query    Explain query
4 2.38 ms 
SELECT u0_.id AS id_0, u0_.public_number AS public_number_1, u0_.date AS date_2, u0_.email AS email_3, u0_.phone AS phone_4, u0_.phone_numeric AS phone_numeric_5, u0_.privacy_mask AS privacy_mask_6, u0_.push_settings_mask AS push_settings_mask_7, u0_.publish_daily_count AS publish_daily_count_8, u0_.publish_daily_at AS publish_daily_at_9, u0_.settings AS settings_10, u0_.password AS password_11, u0_.about AS about_12, u0_.stuff AS stuff_13, u0_.vk_code_verifier AS vk_code_verifier_14, u0_.vk_id AS vk_id_15, u0_.vk_avatar AS vk_avatar_16, u0_.new_email AS new_email_17, u0_.new_email_token AS new_email_token_18, u0_.status AS status_19, u0_.role AS role_20, u0_.is_online AS is_online_21, u0_.last_visit AS last_visit_22, u0_.last_visit_at AS last_visit_at_23, u0_.confirm_token_token AS confirm_token_token_24, u0_.confirm_token_expires AS confirm_token_expires_25, u0_.name_first AS name_first_26, u0_.name_last AS name_last_27, u0_.name_middle AS name_middle_28, u0_.avatar_small_hash AS avatar_small_hash_29, u0_.avatar_original_hash AS avatar_original_hash_30, u0_.reset_token_token AS reset_token_token_31, u0_.reset_token_expires AS reset_token_expires_32, u0_.city_id AS city_id_33 FROM "user_users" u0_ WHERE u0_.email = ?
Parameters: 
[
  "jetme2013@gmail.com"
]
View formatted query    View runnable query    Explain query
5 2.07 ms 
INSERT INTO mfv_flow_step (id, parent_step_id, message_class, message_id, handler_class, transport, is_async, dispatched_at, received_at, handled_at, processing_duration_ms, queue_wait_duration_ms, total_duration_ms, status, exception_class, exception_message, retry_count, metadata, flow_run_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "acb06b70-9ecd-4040-940f-13bde648c828"
  null
  "App\Model\User\UseCase\Login\ByEmail\Request\Command"
  null
  null
  "sync"
  0
  "2026-07-02 21:31:53"
  null
  null
  null
  null
  null
  "pending"
  null
  null
  0
  "[]"
  "f98bffd9-80fb-4c52-8fb4-8e504f7dafac"
]
View formatted query    View runnable query    Explain query
6 1.32 ms 
UPDATE "user_users" SET confirm_token_token = ?, confirm_token_expires = ? WHERE id = ?
Parameters: 
[
  "5164"
  "2026-07-02 21:32:53"
  "018f4446-a88d-59ec-ff06-73c81be48e65"
]
View formatted query    View runnable query    Explain query
7 3.32 ms 
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) RETURNING id
Parameters: 
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:3:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:9:\"event.bus\";}}s:32:\"App\\Messenger\\Stamp\\TraceIdStamp\";a:1:{i:0;O:32:\"App\\Messenger\\Stamp\\TraceIdStamp\":1:{s:7:\"traceId\";s:36:\"019f24be-d176-7b19-9f7a-9f62f9194afd\";}}s:56:\"MichalKanak\\MessageFlowVisualizerBundle\\Stamp\\TraceStamp\";a:1:{i:0;O:56:\"MichalKanak\\MessageFlowVisualizerBundle\\Stamp\\TraceStamp\":7:{s:7:\"traceId\";s:36:\"53e08883-aaca-46fd-9919-abdf2e4b2848\";s:9:\"flowRunId\";s:36:\"f98bffd9-80fb-4c52-8fb4-8e504f7dafac\";s:12:\"parentStepId\";s:36:\"acb06b70-9ecd-4040-940f-13bde648c828\";s:6:\"stepId\";s:36:\"4d70cda6-4626-4eef-bf0d-49202673496d\";s:13:\"correlationId\";s:36:\"2a54b6a0-f622-4145-8f1d-7d50082c41bc\";s:11:\"causationId\";N;s:9:\"isSampled\";b:1;}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:51:\"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\":2:{s:60:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0message\";O:42:\"Symfony\\Bridge\\Twig\\Mime\\NotificationEmail\":4:{i:0;a:8:{s:10:\"importance\";s:4:\"high\";s:7:\"content\";s:46:\"Код подтверждения Bandoo: 5164\";s:9:\"exception\";b:0;s:11:\"action_text\";N;s:10:\"action_url\";N;s:8:\"markdown\";b:0;s:3:\"raw\";b:0;s:11:\"footer_text\";s:34:\"Notification email sent by Symfony\";}i:1;s:7:\"default\";i:2;b:0;i:3;a:5:{i:0;N;i:1;N;i:2;a:0:{}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\"Symfony\\Component\\Mime\\Header\\Headers\":2:{s:46:\"\0Symfony\\Component\\Mime\\Header\\Headers\0headers\";a:3:{s:2:\"to\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:2:\"To\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:19:\"jetme2013@gmail.com\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}s:7:\"subject\";a:1:{i:0;O:48:\"Symfony\\Component\\Mime\\Header\\UnstructuredHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:7:\"Subject\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:55:\"\0Symfony\\Component\\Mime\\Header\\UnstructuredHeader\0value\";s:46:\"Код подтверждения Bandoo: 5164\";}}s:4:\"from\";a:1:{i:0;O:47:\"Symfony\\Component\\Mime\\Header\\MailboxListHeader\":5:{s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0name\";s:4:\"From\";s:56:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lineLength\";i:76;s:50:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0lang\";N;s:53:\"\0Symfony\\Component\\Mime\\Header\\AbstractHeader\0charset\";s:5:\"utf-8\";s:58:\"\0Symfony\\Component\\Mime\\Header\\MailboxListHeader\0addresses\";a:1:{i:0;O:30:\"Symfony\\Component\\Mime\\Address\":2:{s:39:\"\0Symfony\\Component\\Mime\\Address\0address\";s:16:\"usmian@yandex.ru\";s:36:\"\0Symfony\\Component\\Mime\\Address\0name\";s:0:\"\";}}}}}s:49:\"\0Symfony\\Component\\Mime\\Header\\Headers\0lineLength\";i:76;}i:1;N;}}i:4;N;}}s:61:\"\0Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage\0envelope\";N;}}"
  "[]"
  "default"
  "2026-07-02 21:31:53"
  "2026-07-02 21:31:53"
]
View formatted query    View runnable query    Explain query
8 0.17 ms 
SELECT pg_notify(?, ?)
Parameters: 
[
  "messenger_messages"
  "default"
]
View formatted query    View runnable query    Explain query
9 1.25 ms 
INSERT INTO mfv_flow_step (id, parent_step_id, message_class, message_id, handler_class, transport, is_async, dispatched_at, received_at, handled_at, processing_duration_ms, queue_wait_duration_ms, total_duration_ms, status, exception_class, exception_message, retry_count, metadata, flow_run_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  "4d70cda6-4626-4eef-bf0d-49202673496d"
  "acb06b70-9ecd-4040-940f-13bde648c828"
  "Symfony\Component\Mailer\Messenger\SendEmailMessage"
  null
  null
  "async"
  1
  "2026-07-02 21:31:53"
  null
  null
  null
  null
  null
  "pending"
  null
  null
  0
  "{"dispatchedChildren":[{"messageClass":"Symfony\\Component\\Mailer\\Messenger\\SendEmailMessage","transport":"async"}]}"
  "f98bffd9-80fb-4c52-8fb4-8e504f7dafac"
]
View formatted query    View runnable query    Explain query
10 0.37 ms 
UPDATE mfv_flow_run SET finished_at = ?, status = ? WHERE id = ?
Parameters: 
[
  "2026-07-02 21:31:53"
  "completed"
  "f98bffd9-80fb-4c52-8fb4-8e504f7dafac"
]
View formatted query    View runnable query    Explain query
11 0.76 ms 
UPDATE mfv_flow_step SET handler_class = ?, handled_at = ?, processing_duration_ms = ?, total_duration_ms = ?, status = ? WHERE id = ?
Parameters: 
[
  "App\Model\User\UseCase\Login\ByEmail\Request\Handler::__invoke"
  "2026-07-02 21:31:53"
  26
  26
  "handled"
  "acb06b70-9ecd-4040-940f-13bde648c828"
]
View formatted query    View runnable query    Explain query
12 0.68 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
MichalKanak\MessageFlowVisualizerBundle\Entity\FlowStep 2
MichalKanak\MessageFlowVisualizerBundle\Entity\FlowRun 1
App\Model\User\Entity\User 1

Entities Mapping

Class Mapping errors
App\Model\User\Entity\ConfirmToken No errors.
App\Model\User\Entity\Name No errors.
App\Model\User\Entity\Avatar No errors.
App\Model\User\Entity\ResetToken No errors.
App\Model\User\Entity\User
  • The field 'App\Model\User\Entity\User#phoneNumeric' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Model\User\Entity\RefreshToken No errors.
MichalKanak\MessageFlowVisualizerBundle\Entity\FlowRun No errors.
MichalKanak\MessageFlowVisualizerBundle\Entity\FlowStep No errors.
App\Model\City\Entity\CityReference
  • The field 'App\Model\City\Entity\CityReference#foundationYear' has the property type 'int' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Model\User\Entity\Network\Network No errors.
App\Model\User\Entity\Review\Reply No errors.
App\Model\User\Entity\Review\Review No errors.
App\Model\User\Entity\Achievement\Achievement No errors.
App\Model\User\Entity\Photo No errors.
App\Model\User\Entity\Video No errors.
App\Model\User\Entity\Audio
  • The field 'App\Model\User\Entity\Audio#duration' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Model\User\Entity\Album No errors.
App\Model\User\Entity\Link\Link No errors.
App\Model\User\Entity\Like\Like No errors.
App\Model\User\Entity\Viewed\Viewed No errors.
App\Model\User\Entity\Favorite\Favorite No errors.
App\Model\User\Entity\FavoriteUser\FavoriteUser No errors.
App\Model\User\Entity\Message\MessageStatus No errors.
App\Model\User\Entity\Message\Message No errors.
App\Model\User\Entity\Instrument\UserInstrument No errors.
App\Model\User\Entity\FcmToken\UserFcmToken No errors.