Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.api_key AS api_key_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.status AS status_13, t11.current_period_start AS current_period_start_14, t11.current_period_end AS current_period_end_15, t11.verifications_used_this_period AS verifications_used_this_period_16, t11.created_at AS created_at_17, t11.updated_at AS updated_at_18, t11.user_id AS user_id_19, t11.plan_id AS plan_id_20 FROM users t0 LEFT JOIN user_subscriptions t11 ON t11.user_id = t0.id WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.api_key AS api_key_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.is_verified AS is_verified_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.status AS status_13,
  t11.current_period_start AS current_period_start_14,
  t11.current_period_end AS current_period_end_15,
  t11.verifications_used_this_period AS verifications_used_this_period_16,
  t11.created_at AS created_at_17,
  t11.updated_at AS updated_at_18,
  t11.user_id AS user_id_19,
  t11.plan_id AS plan_id_20
FROM
  users t0
  LEFT JOIN user_subscriptions t11 ON t11.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.api_key AS api_key_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.status AS status_13, t11.current_period_start AS current_period_start_14, t11.current_period_end AS current_period_end_15, t11.verifications_used_this_period AS verifications_used_this_period_16, t11.created_at AS created_at_17, t11.updated_at AS updated_at_18, t11.user_id AS user_id_19, t11.plan_id AS plan_id_20 FROM users t0 LEFT JOIN user_subscriptions t11 ON t11.user_id = t0.id WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.monthly_price AS monthly_price_4, t0.monthly_verifications AS monthly_verifications_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.features AS features_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM plans t0 WHERE t0.id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.monthly_price AS monthly_price_4,
  t0.monthly_verifications AS monthly_verifications_5,
  t0.is_active AS is_active_6,
  t0.sort_order AS sort_order_7,
  t0.features AS features_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  plans t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.monthly_price AS monthly_price_4, t0.monthly_verifications AS monthly_verifications_5, t0.is_active AS is_active_6, t0.sort_order AS sort_order_7, t0.features AS features_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM plans t0 WHERE t0.id = 5;

SELECT SUM(c0_.credits_remaining) AS sclr_0 FROM credit_purchases c0_ WHERE c0_.user_id = ? AND c0_.credits_remaining > 0 AND (c0_.expires_at IS NULL OR c0_.expires_at > ?)

[
  2
  "2026-06-24 09:34:46"
]

SELECT
  SUM(c0_.credits_remaining) AS sclr_0
FROM
  credit_purchases c0_
WHERE
  c0_.user_id = ?
  AND c0_.credits_remaining > 0
  AND (
    c0_.expires_at IS NULL
    OR c0_.expires_at > ?
  )

SELECT SUM(c0_.credits_remaining) AS sclr_0 FROM credit_purchases c0_ WHERE c0_.user_id = 2 AND c0_.credits_remaining > 0 AND (c0_.expires_at IS NULL OR c0_.expires_at > '2026-06-24 09:34:46');

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO verification_results (email, status, score, domain, provider, checks, suggestion, verified_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "ken.wu@starrcompanies.com"
  "valid"
  85
  "starrcompanies.com"
  null
  "{"format":true,"domain":true,"nullMx":true,"mailRoute":true,"mx":true,"smtp":null,"disposable":true,"catchAll":null,"roleBased":true,"noReply":true,"freeProvider":false}"
  null
  "2026-06-24 09:34:46"
  2
]

INSERT INTO verification_results (
  email, status, score, domain, provider,
  checks, suggestion, verified_at,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO verification_results (email, status, score, domain, provider, checks, suggestion, verified_at, user_id) VALUES ('ken.wu@starrcompanies.com', 'valid', 85, 'starrcompanies.com', NULL, '{\"format\":true,\"domain\":true,\"nullMx\":true,\"mailRoute\":true,\"mx\":true,\"smtp\":null,\"disposable\":true,\"catchAll\":null,\"roleBased\":true,\"noReply\":true,\"freeProvider\":false}', NULL, '2026-06-24 09:34:46', 2);

UPDATE user_subscriptions SET verifications_used_this_period = ?, updated_at = ? WHERE id = ?

[
  634
  "2026-06-24 09:34:46"
  2
]

UPDATE
  user_subscriptions
SET
  verifications_used_this_period = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user_subscriptions SET verifications_used_this_period = 634, updated_at = '2026-06-24 09:34:46' WHERE id = 2;

"COMMIT"

[]

"COMMIT"

"COMMIT";