POST https://loyalty.parsonsnose.co.uk/api/customer/register?email=Sam.groucott%40gmail.com

Query Metrics

6 Database Queries
6 Different statements
9.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.19 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.api_token AS api_token_5 FROM user t0 WHERE t0.api_token = ? LIMIT 1
Parameters:
[
  "9444kjLXzJrN9juTmg48pxhSbBbH6a7l"
]
2 0.87 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.api_token AS api_token_5 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "simon@kayo.digital"
]
3 3.76 ms
SELECT t0.id AS id_1, t0.loyalty_lion_id AS loyalty_lion_id_2, t0.shopify_id AS shopify_id_3, t0.parsons_nose_id AS parsons_nose_id_4, t0.email AS email_5, t0.one_time_passcode AS one_time_passcode_6, t0.one_time_passcode_datetime_created AS one_time_passcode_datetime_created_7, t0.one_time_passcode_confirmed AS one_time_passcode_confirmed_8 FROM customer t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "Sam.groucott@gmail.com"
]
4 1.43 ms
"START TRANSACTION"
Parameters:
[]
5 1.39 ms
UPDATE customer SET one_time_passcode = ?, one_time_passcode_datetime_created = ? WHERE id = ?
Parameters:
[
  158458
  "2025-01-10 09:25:20"
  1046
]
6 1.19 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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Customer No errors.