Symfony Profiler

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

"START TRANSACTION"

"START TRANSACTION";

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;

"COMMIT"

"COMMIT";

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;

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

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 = 2 AND q0_.is_active = 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 = 2 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 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 = 3 AND q0_.is_active = 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 = 3 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));