Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3, t0.usage_last_date AS usage_last_date_4, t0.api_key AS api_key_5, t0.is_active AS is_active_6, t0.expiration_date AS expiration_date_7, t0.description AS description_8, t0.domain AS domain_9, t0.user_id AS user_id_10 FROM calendar_api_key t0 WHERE t0.api_key = ? AND t0.is_active = ? LIMIT 1

[
  "VP5kaUsOB1zgkxfUSE9TVbDnKWye275Cwtzzu3JhVpYc2o3ecyVqS8FdxGn9sm8QecrqXTmivUsp4tHxb2ptEwI3f/cjBFGkl4KUUpN59VUQPrWiXIIC+WUACafAEdcuv2lBcMZebxOuDgUJdGll3EHzStVnlo/AKZEIDlSwU+pXB1lSALxRELdQt2CtwlVU"
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.creation_date AS creation_date_3,
  t0.usage_last_date AS usage_last_date_4,
  t0.api_key AS api_key_5,
  t0.is_active AS is_active_6,
  t0.expiration_date AS expiration_date_7,
  t0.description AS description_8,
  t0.domain AS domain_9,
  t0.user_id AS user_id_10
FROM
  calendar_api_key t0
WHERE
  t0.api_key = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.creation_date AS creation_date_3, t0.usage_last_date AS usage_last_date_4, t0.api_key AS api_key_5, t0.is_active AS is_active_6, t0.expiration_date AS expiration_date_7, t0.description AS description_8, t0.domain AS domain_9, t0.user_id AS user_id_10 FROM calendar_api_key t0 WHERE t0.api_key = 'VP5kaUsOB1zgkxfUSE9TVbDnKWye275Cwtzzu3JhVpYc2o3ecyVqS8FdxGn9sm8QecrqXTmivUsp4tHxb2ptEwI3f/cjBFGkl4KUUpN59VUQPrWiXIIC+WUACafAEdcuv2lBcMZebxOuDgUJdGll3EHzStVnlo/AKZEIDlSwU+pXB1lSALxRELdQt2CtwlVU' AND t0.is_active = 1 LIMIT 1;

SELECT s0_.id AS id_0, s0_.trader_light_subscription_id AS trader_light_subscription_id_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.status AS status_4, s0_.start_date AS start_date_5, s0_.end_date AS end_date_6, s0_.cancelled_at AS cancelled_at_7, s0_.cancellation_reason AS cancellation_reason_8, s0_.sms_used AS sms_used_9, s0_.emails_used AS emails_used_10, s0_.auto_renew AS auto_renew_11, s0_.autopay_order_id AS autopay_order_id_12, s0_.autopay_remote_id AS autopay_remote_id_13, s0_.payment_data AS payment_data_14, s0_.limits_reset_at AS limits_reset_at_15, s0_.user_id AS user_id_16, s0_.plan_id AS plan_id_17 FROM subscription s0_ INNER JOIN subscription_plan s1_ ON s0_.plan_id = s1_.id WHERE s0_.user_id = ? AND s0_.status IN (?, ?) AND s1_.plan_type = ? AND (s0_.end_date IS NULL OR s0_.end_date > ?) ORDER BY s0_.created_at DESC LIMIT 1

[
  1
  "active"
  "cancelled"
  "calendar"
  "2025-12-15 18:23:12"
]

SELECT
  s0_.id AS id_0,
  s0_.trader_light_subscription_id AS trader_light_subscription_id_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.status AS status_4,
  s0_.start_date AS start_date_5,
  s0_.end_date AS end_date_6,
  s0_.cancelled_at AS cancelled_at_7,
  s0_.cancellation_reason AS cancellation_reason_8,
  s0_.sms_used AS sms_used_9,
  s0_.emails_used AS emails_used_10,
  s0_.auto_renew AS auto_renew_11,
  s0_.autopay_order_id AS autopay_order_id_12,
  s0_.autopay_remote_id AS autopay_remote_id_13,
  s0_.payment_data AS payment_data_14,
  s0_.limits_reset_at AS limits_reset_at_15,
  s0_.user_id AS user_id_16,
  s0_.plan_id AS plan_id_17
FROM
  subscription s0_
  INNER JOIN subscription_plan s1_ ON s0_.plan_id = s1_.id
WHERE
  s0_.user_id = ?
  AND s0_.status IN (?, ?)
  AND s1_.plan_type = ?
  AND (
    s0_.end_date IS NULL
    OR s0_.end_date > ?
  )
ORDER BY
  s0_.created_at DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.trader_light_subscription_id AS trader_light_subscription_id_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.status AS status_4, s0_.start_date AS start_date_5, s0_.end_date AS end_date_6, s0_.cancelled_at AS cancelled_at_7, s0_.cancellation_reason AS cancellation_reason_8, s0_.sms_used AS sms_used_9, s0_.emails_used AS emails_used_10, s0_.auto_renew AS auto_renew_11, s0_.autopay_order_id AS autopay_order_id_12, s0_.autopay_remote_id AS autopay_remote_id_13, s0_.payment_data AS payment_data_14, s0_.limits_reset_at AS limits_reset_at_15, s0_.user_id AS user_id_16, s0_.plan_id AS plan_id_17 FROM subscription s0_ INNER JOIN subscription_plan s1_ ON s0_.plan_id = s1_.id WHERE s0_.user_id = 1 AND s0_.status IN ('active', 'cancelled') AND s1_.plan_type = 'calendar' AND (s0_.end_date IS NULL OR s0_.end_date > '2025-12-15 18:23:12') ORDER BY s0_.created_at DESC LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE calendar_api_key SET usage_last_date = ? WHERE id = ?

[
  "2025-12-15 18:23:12"
  1
]

UPDATE
  calendar_api_key
SET
  usage_last_date = ?
WHERE
  id = ?

UPDATE calendar_api_key SET usage_last_date = '2025-12-15 18:23:12' WHERE id = 1;

"COMMIT"

[]

"COMMIT"

"COMMIT";