Symfony Profiler

Query Metrics

16 Database Queries

12 Different statements

22.91 ms Query time

0 Invalid entities

4 Managed entities

Queries

Group similar statements

default connection


SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1
"START TRANSACTION"
UPDATE tenant_api_key SET last_used_at = ? WHERE id = ?
"COMMIT"
SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.secret AS secret_7, t5.backup_codes AS backup_codes_8, t5.enabled AS enabled_9, t5.created_at AS created_at_10, t5.enabled_at AS enabled_at_11, t5.last_used_at AS last_used_at_12, t5.tenant_user_id AS tenant_user_id_13 FROM tenant_user t0 LEFT JOIN tenant_user_authenticator t5 ON t5.tenant_user_id = t0.id WHERE t0.id = ?
SELECT NEXTVAL('api_logs_id_seq')
"START TRANSACTION"
INSERT INTO api_logs (id, timestamp, username, action, details, request_data, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"COMMIT"

#▲	Time	Info
1	4.98 ms	SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1 Parameters: [`"7698a68238a20b789118ec4251d5a3b0"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1 SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = '7698a68238a20b789118ec4251d5a3b0' LIMIT 1;
2	0.23 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.85 ms	UPDATE tenant_api_key SET last_used_at = ? WHERE id = ? Parameters: [`"2026-07-15 21:14:06" 6`] View formatted query View runnable query Explain query UPDATE tenant_api_key SET last_used_at = ? WHERE id = ? UPDATE tenant_api_key SET last_used_at = '2026-07-15 21:14:06' WHERE id = 6;
4	1.48 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
5	1.13 ms	SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = 4;
6	0.46 ms	SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = ? LIMIT 1 Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = ? LIMIT 1 SELECT t0.id AS id_1, t0.driver_type AS driver_type_2, t0.db_name AS db_name_3, t0.db_user_name AS db_user_name_4, t0.db_password AS db_password_5, t0.db_host AS db_host_6, t0.db_port AS db_port_7, t0.database_status AS database_status_8 FROM tenant_db_config t0 WHERE t0.id = '4' LIMIT 1;
7	0.45 ms	SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1 Parameters: [`"7698a68238a20b789118ec4251d5a3b0"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1 SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = '7698a68238a20b789118ec4251d5a3b0' LIMIT 1;
8	0.45 ms	SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1 Parameters: [`"7698a68238a20b789118ec4251d5a3b0"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = ? LIMIT 1 SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.created_at AS created_at_3, t0.last_used_at AS last_used_at_4, t0.tenant_user_id AS tenant_user_id_5, t0.tenant_db_config_id AS tenant_db_config_id_6 FROM tenant_api_key t0 WHERE t0.api_key = '7698a68238a20b789118ec4251d5a3b0' LIMIT 1;
9	2.87 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.secret AS secret_7, t5.backup_codes AS backup_codes_8, t5.enabled AS enabled_9, t5.created_at AS created_at_10, t5.enabled_at AS enabled_at_11, t5.last_used_at AS last_used_at_12, t5.tenant_user_id AS tenant_user_id_13 FROM tenant_user t0 LEFT JOIN tenant_user_authenticator t5 ON t5.tenant_user_id = t0.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.secret AS secret_7, t5.backup_codes AS backup_codes_8, t5.enabled AS enabled_9, t5.created_at AS created_at_10, t5.enabled_at AS enabled_at_11, t5.last_used_at AS last_used_at_12, t5.tenant_user_id AS tenant_user_id_13 FROM tenant_user t0 LEFT JOIN tenant_user_authenticator t5 ON t5.tenant_user_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t5.id AS id_6, t5.secret AS secret_7, t5.backup_codes AS backup_codes_8, t5.enabled AS enabled_9, t5.created_at AS created_at_10, t5.enabled_at AS enabled_at_11, t5.last_used_at AS last_used_at_12, t5.tenant_user_id AS tenant_user_id_13 FROM tenant_user t0 LEFT JOIN tenant_user_authenticator t5 ON t5.tenant_user_id = t0.id WHERE t0.id = 1;
10	0.76 ms	SELECT NEXTVAL('api_logs_id_seq') Parameters: [] View formatted query View runnable query Explain query SELECT NEXTVAL('api_logs_id_seq') SELECT NEXTVAL('api_logs_id_seq');
11	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
12	1.35 ms	INSERT INTO api_logs (id, timestamp, username, action, details, request_data, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`85997 "2026-07-15 21:14:06" "[email protected]" "GET /api/recipients/reconcile (200)" "API call completed in 12.16ms with status 200" "{"query":{"page":"1","limit":"500","include_disabled":"true"}}" null "172.70.160.130" "Symfony HttpClient/Curl" 4`] View formatted query View runnable query Explain query INSERT INTO api_logs ( id, timestamp, username, action, details, request_data, response_data, ip_address, user_agent, tenant_db_config_id ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO api_logs (id, timestamp, username, action, details, request_data, response_data, ip_address, user_agent, tenant_db_config_id) VALUES (85997, '2026-07-15 21:14:06', '[email protected]', 'GET /api/recipients/reconcile (200)', 'API call completed in 12.16ms with status 200', '{\"query\":{\"page\":\"1\",\"limit\":\"500\",\"include_disabled\":\"true\"}}', NULL, '172.70.160.130', 'Symfony HttpClient/Curl', 4);
13	1.27 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

tenant connection

#▲	Time	Info
1	2.81 ms	SELECT COUNT() FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL SELECT COUNT(*) FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL;
2	3.03 ms	SELECT id, source_id, email, version, updated_at FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL ORDER BY LOWER(TRIM(email)) COLLATE "C" ASC, id ASC LIMIT ? OFFSET ? Parameters: [`500 0`] View formatted query View runnable query Explain query SELECT id, source_id, email, version, updated_at FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL ORDER BY LOWER( TRIM(email) ) COLLATE "C" ASC, id ASC LIMIT ? OFFSET ? SELECT id, source_id, email, version, updated_at FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL ORDER BY LOWER(TRIM(email)) COLLATE "C" ASC, id ASC LIMIT 500 OFFSET 0;
3	0.56 ms	SELECT id, source_id, email, version, updated_at, deleted_at FROM recipient WHERE (enable <= 0 OR deleted_at IS NOT NULL) AND email IS NOT NULL Parameters: [] View formatted query View runnable query Explain query SELECT id, source_id, email, version, updated_at, deleted_at FROM recipient WHERE ( enable <= 0 OR deleted_at IS NOT NULL ) AND email IS NOT NULL SELECT id, source_id, email, version, updated_at, deleted_at FROM recipient WHERE (enable <= 0 OR deleted_at IS NOT NULL) AND email IS NOT NULL;

#▲

Time

Info

2.81 ms

SELECT COUNT(*) FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  COUNT(*)
FROM
  recipient
WHERE
  enable > 0
  AND deleted_at IS NULL
  AND email IS NOT NULL

SELECT COUNT(*) FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL;

3.03 ms

SELECT id, source_id, email, version, updated_at FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL
             ORDER BY LOWER(TRIM(email)) COLLATE "C" ASC, id ASC LIMIT ? OFFSET ?

Parameters:

View formatted query View runnable query Explain query

SELECT
  id,
  source_id,
  email,
  version,
  updated_at
FROM
  recipient
WHERE
  enable > 0
  AND deleted_at IS NULL
  AND email IS NOT NULL
ORDER BY
  LOWER(
    TRIM(email)
  ) COLLATE "C" ASC,
  id ASC
LIMIT
  ?
OFFSET
  ?

SELECT id, source_id, email, version, updated_at FROM recipient WHERE enable > 0 AND deleted_at IS NULL AND email IS NOT NULL
             ORDER BY LOWER(TRIM(email)) COLLATE "C" ASC, id ASC LIMIT 500 OFFSET 0;

0.56 ms

SELECT id, source_id, email, version, updated_at, deleted_at FROM recipient WHERE (enable <= 0 OR deleted_at IS NOT NULL) AND email IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  id,
  source_id,
  email,
  version,
  updated_at,
  deleted_at
FROM
  recipient
WHERE
  (
    enable <= 0
    OR deleted_at IS NOT NULL
  )
  AND email IS NOT NULL

SELECT id, source_id, email, version, updated_at, deleted_at FROM recipient WHERE (enable <= 0 OR deleted_at IS NOT NULL) AND email IS NOT NULL;

Database Connections

Name	Service
tenant	doctrine.dbal.tenant_connection
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
tenant	doctrine.orm.tenant_entity_manager
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

tenant entity manager

Class	Amount of managed objects

default entity manager

Class	Amount of managed objects
App\Entity\Main\TenantApiKey	1
App\Entity\Main\TenantUser	1
App\Entity\Main\TenantDbConfig	1
App\Entity\Main\ApiLog	1

Entities Mapping

tenant entity manager

No loaded entities.

default entity manager

Class	Mapping errors
App\Entity\Main\TenantApiKey	No errors.
App\Entity\Main\TenantUser	No errors.
App\Entity\Main\TenantDbConfig	No errors.
App\Entity\Main\TenantHostname	No errors.
App\Entity\Main\TenantUserAuthenticator	No errors.
App\Entity\Main\ApiLog	No errors.

Symfony Profiler

GET https://publite-joel.servicelevelmanagement.co.uk/api/recipients/reconcile?include_disabled=true&limit=500&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

tenant entity manager

default entity manager

Entities Mapping

tenant entity manager

default entity manager