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

Response
200 OK
IP
18.168.29.105
Profiled on
Token
7a8b0f

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
16.03 ms
(84.80%) 		4 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.75 ms
(3.95%) 		2 
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
0.65 ms
(3.45%) 		4 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.41 ms
(2.18%) 		1 
UPDATE api_log SET payload = ?, updated_at_timestamp = ? WHERE id = ?
Parameters: 
[
  """
    {\n
                    "fullName": "Health Check",\n
                    "contact": {\n
                        "telephone": "0"\n
                    }\n
                }
    """
  1786622837
  12700
]
View formatted query    View runnable query    Explain query
0.39 ms
(2.05%) 		1 
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:1786622837;}}"
  "[]"
  "default"
  "2026-08-13 12:07:17"
  "2026-08-13 12:07:17"
]
View formatted query    View runnable query    Explain query
0.37 ms
(1.98%) 		1 
UPDATE api_log SET reference = ?, response_code = ? WHERE id = ?
Parameters: 
[
  0
  200
  12700
]
View formatted query    View runnable query    Explain query
0.30 ms
(1.59%) 		1 
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
  1786622837
  null
]
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.