Symfony Profiler

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

Query Metrics

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.status AS status_2, s0_.created_at AS created_at_3, s0_.study_session AS study_session_4, s0_.competition_id AS competition_id_5, s0_.user_id AS user_id_6 FROM scheduled_learning s0_ INNER JOIN learning l1_ ON s0_.id = l1_.scheduled_learning_id WHERE s0_.user_id = ? AND s0_.status = ? ORDER BY s0_.id DESC LIMIT 1

[
  587
  "ACTIVE"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.status AS status_2,
  s0_.created_at AS created_at_3,
  s0_.study_session AS study_session_4,
  s0_.competition_id AS competition_id_5,
  s0_.user_id AS user_id_6
FROM
  scheduled_learning s0_
  INNER JOIN learning l1_ ON s0_.id = l1_.scheduled_learning_id
WHERE
  s0_.user_id = ?
  AND s0_.status = ?
ORDER BY
  s0_.id DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.status AS status_2, s0_.created_at AS created_at_3, s0_.study_session AS study_session_4, s0_.competition_id AS competition_id_5, s0_.user_id AS user_id_6 FROM scheduled_learning s0_ INNER JOIN learning l1_ ON s0_.id = l1_.scheduled_learning_id WHERE s0_.user_id = 587 AND s0_.status = 'ACTIVE' ORDER BY s0_.id DESC LIMIT 1;

SELECT t0.id AS id_1, t0.day AS day_2, t0.mode AS mode_3, t0.score AS score_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.created_at AS created_at_7, t0.scheduled_at AS scheduled_at_8, t0.status AS status_9, t0.options AS options_10, t0.admin_note AS admin_note_11, t0.user_id AS user_id_12, t0.dataset_version_id AS dataset_version_id_13, t0.scheduled_learning_id AS scheduled_learning_id_14 FROM learning t0 WHERE t0.scheduled_learning_id = ?

[
  2363
]

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.mode AS mode_3,
  t0.score AS score_4,
  t0.start_at AS start_at_5,
  t0.end_at AS end_at_6,
  t0.created_at AS created_at_7,
  t0.scheduled_at AS scheduled_at_8,
  t0.status AS status_9,
  t0.options AS options_10,
  t0.admin_note AS admin_note_11,
  t0.user_id AS user_id_12,
  t0.dataset_version_id AS dataset_version_id_13,
  t0.scheduled_learning_id AS scheduled_learning_id_14
FROM
  learning t0
WHERE
  t0.scheduled_learning_id = ?

SELECT t0.id AS id_1, t0.day AS day_2, t0.mode AS mode_3, t0.score AS score_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.created_at AS created_at_7, t0.scheduled_at AS scheduled_at_8, t0.status AS status_9, t0.options AS options_10, t0.admin_note AS admin_note_11, t0.user_id AS user_id_12, t0.dataset_version_id AS dataset_version_id_13, t0.scheduled_learning_id AS scheduled_learning_id_14 FROM learning t0 WHERE t0.scheduled_learning_id = 2363;

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 t0.id AS id_1, t0.slug AS slug_2, t0.with_dataset AS with_dataset_3, t0.active AS active_4, t0.hero_image AS hero_image_5, t0.name AS name_6, t0.content AS content_7, t0.created_at AS created_at_8 FROM competition t0 WHERE t0.id = ?

[
  22
]

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.with_dataset AS with_dataset_3,
  t0.active AS active_4,
  t0.hero_image AS hero_image_5,
  t0.name AS name_6,
  t0.content AS content_7,
  t0.created_at AS created_at_8
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.with_dataset AS with_dataset_3, t0.active AS active_4, t0.hero_image AS hero_image_5, t0.name AS name_6, t0.content AS content_7, t0.created_at AS created_at_8 FROM competition t0 WHERE t0.id = 22;

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;