GET https://test.crm.seniorstairlifts.co.uk/api/sales-leads

Response
200 OK
IP
18.168.29.105
Profiled on
Token
5fc763

Query Metrics

14 Database Queries
7 Different statements
20.82 ms Query time
1 Invalid entities
2 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.36 ms 
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.roles AS roles_3, t0.status AS status_4, t0.name AS name_5, t0.email_address_for_confirmation AS email_address_for_confirmation_6, t0.show_in_reports AS show_in_reports_7 FROM api_user t0 WHERE t0.api_key = ? LIMIT 1
Parameters: 
[
  "c69384e217208f1c3e4dc7b4233bddfe"
]
View formatted query    View runnable query    Explain query
2 0.41 ms 
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.roles AS roles_3, t0.status AS status_4, t0.name AS name_5, t0.email_address_for_confirmation AS email_address_for_confirmation_6, t0.show_in_reports AS show_in_reports_7 FROM api_user t0 WHERE t0.api_key = ? LIMIT 1
Parameters: 
[
  "c69384e217208f1c3e4dc7b4233bddfe"
]
View formatted query    View runnable query    Explain query
3 0.18 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 0.55 ms 
INSERT INTO api_log (subject, reference, payload, route, sender, response_code, created_at_timestamp, updated_at_timestamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  null
  null
  null
  "/api/sales-leads"
  "Partner Portal"
  null
  1786642715
  null
]
View formatted query    View runnable query    Explain query
5 4.60 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.20 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 0.43 ms 
UPDATE api_log SET payload = ?, updated_at_timestamp = ? WHERE id = ?
Parameters: 
[
  """
    {\n
                    "fullName": "Health Check",\n
                    "contact": {\n
                        "telephone": "0"\n
                    }\n
                }
    """
  1786642715
  12703
]
View formatted query    View runnable query    Explain query
8 4.53 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
9 0.23 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
10 0.37 ms 
UPDATE api_log SET reference = ?, response_code = ? WHERE id = ?
Parameters: 
[
  0
  200
  12703
]
View formatted query    View runnable query    Explain query
11 4.85 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 0.16 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
13 0.40 ms 
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters: 
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{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:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:50:\"App\\Message\\Email\\SuccessfulApiRequestEmailMessage\":3:{s:59:\"\0App\\Message\\Email\\SuccessfulApiRequestEmailMessage\0toEmail\";s:36:\"partnerportal@seniorstairlifts.co.uk\";s:64:\"\0App\\Message\\Email\\SuccessfulApiRequestEmailMessage\0customerName\";s:12:\"Health Check\";s:61:\"\0App\\Message\\Email\\SuccessfulApiRequestEmailMessage\0timestamp\";i:1786642715;}}"
  "[]"
  "default"
  "2026-08-13 17:38:35"
  "2026-08-13 17:38:35"
]
View formatted query    View runnable query    Explain query
14 3.54 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
App\Entity\ApiUser 1
App\Entity\ApiLog 1

Entities Mapping

Class Mapping errors
App\Entity\ApiUser No errors.
App\Entity\ApiLog No errors.
App\Entity\Customer
  • The field 'App\Entity\Customer#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Customer#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Project No errors.