Symfony Profiler

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

Query Metrics

SELECT
            COUNT(*) AS total_answers,
            COUNT(CASE WHEN ua.correct = 1 THEN 1 ELSE NULL END) AS correct_answers,
            COUNT(CASE WHEN ua.correct = 0 THEN 1 ELSE NULL END) AS wrong_answers
          FROM answer ua
          JOIN learning l ON l.id = ua.learning_id
          WHERE l.user_id = :userId;

[
  ":userId" => 587
]

SELECT
  COUNT(*) AS total_answers,
  COUNT(
    CASE WHEN ua.correct = 1 THEN 1 ELSE NULL END
  ) AS correct_answers,
  COUNT(
    CASE WHEN ua.correct = 0 THEN 1 ELSE NULL END
  ) AS wrong_answers
FROM
  answer ua
  JOIN learning l ON l.id = ua.learning_id
WHERE
  l.user_id = :userId;

SELECT
            COUNT(*) AS total_answers,
            COUNT(CASE WHEN ua.correct = 1 THEN 1 ELSE NULL END) AS correct_answers,
            COUNT(CASE WHEN ua.correct = 0 THEN 1 ELSE NULL END) AS wrong_answers
          FROM answer ua
          JOIN learning l ON l.id = ua.learning_id
          WHERE l.user_id = :userId;;

SELECT  
                COUNT(*) AS total,
                COUNT(CASE WHEN a.correct = 1 THEN 1 ELSE NULL END) AS correct_answers,
                COUNT(CASE WHEN a.correct = 0 THEN 1 ELSE NULL END) AS wrong_answers,
                s.name AS subject
            FROM answer a 
            JOIN question q ON q.id = a.question_id 
            JOIN subject s ON s.id  = q.subject_id 
            JOIN learning l ON l.id = a.learning_id 
            WHERE 
                l.user_id = :userId
            GROUP  BY s.id

[
  ":userId" => 587
]

SELECT
  COUNT(*) AS total,
  COUNT(
    CASE WHEN a.correct = 1 THEN 1 ELSE NULL END
  ) AS correct_answers,
  COUNT(
    CASE WHEN a.correct = 0 THEN 1 ELSE NULL END
  ) AS wrong_answers,
  s.name AS subject
FROM
  answer a
  JOIN question q ON q.id = a.question_id
  JOIN subject s ON s.id = q.subject_id
  JOIN learning l ON l.id = a.learning_id
WHERE
  l.user_id = :userId
GROUP BY
  s.id

SELECT  
                COUNT(*) AS total,
                COUNT(CASE WHEN a.correct = 1 THEN 1 ELSE NULL END) AS correct_answers,
                COUNT(CASE WHEN a.correct = 0 THEN 1 ELSE NULL END) AS wrong_answers,
                s.name AS subject
            FROM answer a 
            JOIN question q ON q.id = a.question_id 
            JOIN subject s ON s.id  = q.subject_id 
            JOIN learning l ON l.id = a.learning_id 
            WHERE 
                l.user_id = :userId
            GROUP  BY s.id ;

SELECT COUNT(l0_.id) AS sclr_0 FROM learning l0_ INNER JOIN dataset_version d1_ ON l0_.dataset_version_id = d1_.id WHERE l0_.user_id = ? AND l0_.mode = ? AND l0_.end_at IS NOT NULL

[
  587
  "exam"
]

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  learning l0_
  INNER JOIN dataset_version d1_ ON l0_.dataset_version_id = d1_.id
WHERE
  l0_.user_id = ?
  AND l0_.mode = ?
  AND l0_.end_at IS NOT NULL

SELECT COUNT(l0_.id) AS sclr_0 FROM learning l0_ INNER JOIN dataset_version d1_ ON l0_.dataset_version_id = d1_.id WHERE l0_.user_id = 587 AND l0_.mode = 'exam' AND l0_.end_at IS NOT NULL;

SELECT COUNT(l0_.id) AS sclr_0 FROM learning l0_ INNER JOIN dataset_version d1_ ON l0_.dataset_version_id = d1_.id WHERE l0_.user_id = ? AND l0_.mode = ? AND l0_.score >= d1_.score_threshold AND l0_.end_at IS NOT NULL

[
  587
  "exam"
]

SELECT
  COUNT(l0_.id) AS sclr_0
FROM
  learning l0_
  INNER JOIN dataset_version d1_ ON l0_.dataset_version_id = d1_.id
WHERE
  l0_.user_id = ?
  AND l0_.mode = ?
  AND l0_.score >= d1_.score_threshold
  AND l0_.end_at IS NOT NULL

SELECT COUNT(l0_.id) AS sclr_0 FROM learning l0_ INNER JOIN dataset_version d1_ ON l0_.dataset_version_id = d1_.id WHERE l0_.user_id = 587 AND l0_.mode = 'exam' AND l0_.score >= d1_.score_threshold AND l0_.end_at IS NOT NULL;

SELECT COUNT(c0_.id) AS sclr_0, s1_.name AS name_1, s1_.id AS id_2 FROM critical_question c0_ INNER JOIN question q2_ ON c0_.question_id = q2_.id INNER JOIN subject s1_ ON q2_.subject_id = s1_.id WHERE c0_.user_id = ? GROUP BY s1_.id

[
  587
]

SELECT
  COUNT(c0_.id) AS sclr_0,
  s1_.name AS name_1,
  s1_.id AS id_2
FROM
  critical_question c0_
  INNER JOIN question q2_ ON c0_.question_id = q2_.id
  INNER JOIN subject s1_ ON q2_.subject_id = s1_.id
WHERE
  c0_.user_id = ?
GROUP BY
  s1_.id

SELECT COUNT(c0_.id) AS sclr_0, s1_.name AS name_1, s1_.id AS id_2 FROM critical_question c0_ INNER JOIN question q2_ ON c0_.question_id = q2_.id INNER JOIN subject s1_ ON q2_.subject_id = s1_.id WHERE c0_.user_id = 587 GROUP BY s1_.id;

SELECT t0.price_payed AS price_payed_1, t0.currency AS currency_2, t0.gateway AS gateway_3, t0.gateway_identifier AS gateway_identifier_4, t0.billing_address AS billing_address_5, t0.created_at AS created_at_6, t0.payed_at AS payed_at_7, t0.is_invoiced AS is_invoiced_8, t0.membership_id AS membership_id_9 FROM transaction t0 WHERE t0.membership_id = ?

[
  889
]

SELECT
  t0.price_payed AS price_payed_1,
  t0.currency AS currency_2,
  t0.gateway AS gateway_3,
  t0.gateway_identifier AS gateway_identifier_4,
  t0.billing_address AS billing_address_5,
  t0.created_at AS created_at_6,
  t0.payed_at AS payed_at_7,
  t0.is_invoiced AS is_invoiced_8,
  t0.membership_id AS membership_id_9
FROM
  transaction t0
WHERE
  t0.membership_id = ?

SELECT t0.price_payed AS price_payed_1, t0.currency AS currency_2, t0.gateway AS gateway_3, t0.gateway_identifier AS gateway_identifier_4, t0.billing_address AS billing_address_5, t0.created_at AS created_at_6, t0.payed_at AS payed_at_7, t0.is_invoiced AS is_invoiced_8, t0.membership_id AS membership_id_9 FROM transaction t0 WHERE t0.membership_id = 889;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.tax_id AS tax_id_7 FROM `user` t0 WHERE t0.email = ? LIMIT 1

[
  "lafranca.vincent@icloud.com"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.last_name AS last_name_6,
  t0.tax_id AS tax_id_7
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.name AS name_5, t0.last_name AS last_name_6, t0.tax_id AS tax_id_7 FROM `user` t0 WHERE t0.email = 'lafranca.vincent@icloud.com' LIMIT 1;

SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.expire_at AS expire_at_2, m0_.created_at AS created_at_3, m0_.license_id AS license_id_4, m0_.user_id AS user_id_5 FROM membership m0_ WHERE m0_.user_id = ? ORDER BY m0_.id DESC LIMIT 1

[
  587
]

SELECT
  m0_.id AS id_0,
  m0_.uuid AS uuid_1,
  m0_.expire_at AS expire_at_2,
  m0_.created_at AS created_at_3,
  m0_.license_id AS license_id_4,
  m0_.user_id AS user_id_5
FROM
  membership m0_
WHERE
  m0_.user_id = ?
ORDER BY
  m0_.id DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.uuid AS uuid_1, m0_.expire_at AS expire_at_2, m0_.created_at AS created_at_3, m0_.license_id AS license_id_4, m0_.user_id AS user_id_5 FROM membership m0_ WHERE m0_.user_id = 587 ORDER BY m0_.id DESC LIMIT 1;

SELECT COUNT(c0_.id) AS sclr_0 FROM critical_question c0_ WHERE c0_.user_id = ?

[
  587
]

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  critical_question c0_
WHERE
  c0_.user_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM critical_question c0_ WHERE c0_.user_id = 587;