Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 35
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

[
  "7698a68238a20b789118ec4251d5a3b0"
]

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;

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
]

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;

"COMMIT"

[]

"COMMIT"

"COMMIT";

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
]

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);

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
]

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;

UPDATE tenant_api_key SET last_used_at = ? WHERE id = ?

[
  "2026-07-15 21:14:06"
  6
]

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;

SELECT NEXTVAL('api_logs_id_seq')

[]

SELECT
  NEXTVAL('api_logs_id_seq')

SELECT NEXTVAL('api_logs_id_seq');

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

[
  "4"
]

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;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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 ?

[
  500
  0
]

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;

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

SELECT COUNT(*) FROM recipient WHERE enable > 0 AND deleted_at IS 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

[]

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;