POST http://rezervace-dev.pneuparking.cz/login/verify

Query Metrics

6 Database Queries
6 Different statements
4.35 ms Query time
0 Invalid entities
2 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.code_hash AS code_hash_3, t0.expires_at AS expires_at_4, t0.created_at AS created_at_5 FROM login_otp t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "david.ruzicka@pneuparking.cz"
]
2 0.56 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.is_active AS is_active_6, t0.roles AS roles_7, t0.password AS password_8, t0.reset_token AS reset_token_9, t0.reset_token_expires_at AS reset_token_expires_at_10, t0.registration_token AS registration_token_11, t0.registration_token_expires_at AS registration_token_expires_at_12 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "david.ruzicka@pneuparking.cz"
]
3 1.75 ms
DELETE FROM login_otp WHERE email = ?
Parameters:
[
  "david.ruzicka@pneuparking.cz"
]
4 0.25 ms
"START TRANSACTION"
Parameters:
[]
5 0.57 ms
INSERT INTO user (email, first_name, last_name, phone, is_active, roles, password, reset_token, reset_token_expires_at, registration_token, registration_token_expires_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "david.ruzicka@pneuparking.cz"
  null
  null
  null
  1
  "["ROLE_USER"]"
  "$2y$13$vbCnYgJfE1f2jjGNzU1sUOb25A5WbcJrGaFWCsdMb43o6BTCNOISC"
  null
  null
  null
  null
]
6 0.75 ms
"COMMIT"
Parameters:
[]

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
App\Entity\LoginOtp 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\LoginOtp No errors.
App\Entity\User No errors.
App\Entity\Vehicle No errors.