Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 31
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Configuration

Query Metrics

SELECT COUNT(q0_.id) AS sclr_0 FROM question_bank_topic q0_ WHERE q0_.subject_id = ? AND q0_.is_active = 1 AND (EXISTS (SELECT q1_.id FROM question_bank q1_ LEFT JOIN paper_question p2_ ON (p2_.question_id = q1_.id) WHERE q1_.topic_id = q0_.id AND q1_.is_active = 1 AND p2_.id IS NULL))

[
  1
]

SELECT
  COUNT(q0_.id) AS sclr_0
FROM
  question_bank_topic q0_
WHERE
  q0_.subject_id = ?
  AND q0_.is_active = 1
  AND (
    EXISTS (
      SELECT
        q1_.id
      FROM
        question_bank q1_
        LEFT JOIN paper_question p2_ ON (p2_.question_id = q1_.id)
      WHERE
        q1_.topic_id = q0_.id
        AND q1_.is_active = 1
        AND p2_.id IS NULL
    )
  )

SELECT COUNT(q0_.id) AS sclr_0 FROM question_bank_topic q0_ WHERE q0_.subject_id = 1 AND q0_.is_active = 1 AND (EXISTS (SELECT q1_.id FROM question_bank q1_ LEFT JOIN paper_question p2_ ON (p2_.question_id = q1_.id) WHERE q1_.topic_id = q0_.id AND q1_.is_active = 1 AND p2_.id IS NULL));

UPDATE user_sessions SET last_activity_at = ?, updated_at = ? WHERE id = ?

[
  "2026-06-02 12:40:28"
  "2026-06-02 12:40:28"
  475
]

UPDATE
  user_sessions
SET
  last_activity_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user_sessions SET last_activity_at = '2026-06-02 12:40:28', updated_at = '2026-06-02 12:40:28' WHERE id = 475;

SELECT COUNT(q0_.id) AS sclr_0 FROM question_bank q0_ INNER JOIN question_bank_topic q1_ ON q0_.topic_id = q1_.id WHERE q1_.subject_id = ? AND q0_.is_active = ?

[
  1
  1
]

SELECT
  COUNT(q0_.id) AS sclr_0
FROM
  question_bank q0_
  INNER JOIN question_bank_topic q1_ ON q0_.topic_id = q1_.id
WHERE
  q1_.subject_id = ?
  AND q0_.is_active = ?

SELECT COUNT(q0_.id) AS sclr_0 FROM question_bank q0_ INNER JOIN question_bank_topic q1_ ON q0_.topic_id = q1_.id WHERE q1_.subject_id = 1 AND q0_.is_active = 1;

SELECT t0.id AS id_1, t0.jti AS jti_2, t0.ip_address AS ip_address_3, t0.user_agent AS user_agent_4, t0.expires_at AS expires_at_5, t0.is_active AS is_active_6, t0.last_activity_at AS last_activity_at_7, t0.terminated_at AS terminated_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM user_sessions t0 WHERE t0.jti = ? AND t0.is_active = ? LIMIT 1

[
  "3dfdd5707cfee9c0fae39c7d2fba1627"
  1
]

SELECT
  t0.id AS id_1,
  t0.jti AS jti_2,
  t0.ip_address AS ip_address_3,
  t0.user_agent AS user_agent_4,
  t0.expires_at AS expires_at_5,
  t0.is_active AS is_active_6,
  t0.last_activity_at AS last_activity_at_7,
  t0.terminated_at AS terminated_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.user_id AS user_id_11
FROM
  user_sessions t0
WHERE
  t0.jti = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.jti AS jti_2, t0.ip_address AS ip_address_3, t0.user_agent AS user_agent_4, t0.expires_at AS expires_at_5, t0.is_active AS is_active_6, t0.last_activity_at AS last_activity_at_7, t0.terminated_at AS terminated_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM user_sessions t0 WHERE t0.jti = '3dfdd5707cfee9c0fae39c7d2fba1627' AND t0.is_active = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.username AS username_6, t0.name AS name_7, t0.address AS address_8, t0.phone_number AS phone_number_9, t0.profile_pic AS profile_pic_10, t0.oauth_provider AS oauth_provider_11, t0.oauth_id AS oauth_id_12, t0.oauth_access_token AS oauth_access_token_13, t0.oauth_refresh_token AS oauth_refresh_token_14, t0.oauth_token_expires_at AS oauth_token_expires_at_15, t0.referral_code AS referral_code_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM user t0 WHERE t0.email = ? LIMIT 1

[
  "webrivals@gmail.com"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.username AS username_6,
  t0.name AS name_7,
  t0.address AS address_8,
  t0.phone_number AS phone_number_9,
  t0.profile_pic AS profile_pic_10,
  t0.oauth_provider AS oauth_provider_11,
  t0.oauth_id AS oauth_id_12,
  t0.oauth_access_token AS oauth_access_token_13,
  t0.oauth_refresh_token AS oauth_refresh_token_14,
  t0.oauth_token_expires_at AS oauth_token_expires_at_15,
  t0.referral_code AS referral_code_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.username AS username_6, t0.name AS name_7, t0.address AS address_8, t0.phone_number AS phone_number_9, t0.profile_pic AS profile_pic_10, t0.oauth_provider AS oauth_provider_11, t0.oauth_id AS oauth_id_12, t0.oauth_access_token AS oauth_access_token_13, t0.oauth_refresh_token AS oauth_refresh_token_14, t0.oauth_token_expires_at AS oauth_token_expires_at_15, t0.referral_code AS referral_code_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM user t0 WHERE t0.email = 'webrivals@gmail.com' LIMIT 1;

SELECT q0_.id AS id_0, q0_.name AS name_1, q0_.description AS description_2, q0_.sort_order AS sort_order_3, q0_.is_active AS is_active_4, q0_.created_at AS created_at_5, q0_.updated_at AS updated_at_6 FROM question_bank_subject q0_ WHERE q0_.is_active = ? ORDER BY q0_.sort_order ASC, q0_.name ASC

[
  1
]

SELECT
  q0_.id AS id_0,
  q0_.name AS name_1,
  q0_.description AS description_2,
  q0_.sort_order AS sort_order_3,
  q0_.is_active AS is_active_4,
  q0_.created_at AS created_at_5,
  q0_.updated_at AS updated_at_6
FROM
  question_bank_subject q0_
WHERE
  q0_.is_active = ?
ORDER BY
  q0_.sort_order ASC,
  q0_.name ASC

SELECT q0_.id AS id_0, q0_.name AS name_1, q0_.description AS description_2, q0_.sort_order AS sort_order_3, q0_.is_active AS is_active_4, q0_.created_at AS created_at_5, q0_.updated_at AS updated_at_6 FROM question_bank_subject q0_ WHERE q0_.is_active = 1 ORDER BY q0_.sort_order ASC, q0_.name ASC;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";