Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 11
• Events
• Routing
• Cache
• Translation 88
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Configuration

Query Metrics

SELECT a.*, l.first_name, l.last_name, g.name AS group_name
FROM agreement a
INNER JOIN learner l ON l.id = a.learner_id
LEFT JOIN class_group g ON g.id = a.class_group_id
WHERE a.school_id = ?
ORDER BY a.created_at DESC

[
  1
]

SELECT
  a.*,
  l.first_name,
  l.last_name,
  g.name AS group_name
FROM
  agreement a
  INNER JOIN learner l ON l.id = a.learner_id
  LEFT JOIN class_group g ON g.id = a.class_group_id
WHERE
  a.school_id = ?
ORDER BY
  a.created_at DESC

SELECT a.*, l.first_name, l.last_name, g.name AS group_name
FROM agreement a
INNER JOIN learner l ON l.id = a.learner_id
LEFT JOIN class_group g ON g.id = a.class_group_id
WHERE a.school_id = 1
ORDER BY a.created_at DESC;

SELECT
    s.id,
    s.name,
    s.slug,
    s.status,
    s.default_locale,
    s.logo_path,
    s.meta_title_suffix,
    d.id AS domain_id,
    d.host,
    d.primary_domain
FROM school_domain d
INNER JOIN school s ON s.id = d.school_id
WHERE d.host = ?
  AND d.active = 1
  AND s.status = 'active'
LIMIT 1

[
  "skillpilot.dfirma.pl"
]

SELECT
  s.id,
  s.name,
  s.slug,
  s.status,
  s.default_locale,
  s.logo_path,
  s.meta_title_suffix,
  d.id AS domain_id,
  d.host,
  d.primary_domain
FROM
  school_domain d
  INNER JOIN school s ON s.id = d.school_id
WHERE
  d.host = ?
  AND d.active = 1
  AND s.status = 'active'
LIMIT
  1

SELECT
    s.id,
    s.name,
    s.slug,
    s.status,
    s.default_locale,
    s.logo_path,
    s.meta_title_suffix,
    d.id AS domain_id,
    d.host,
    d.primary_domain
FROM school_domain d
INNER JOIN school s ON s.id = d.school_id
WHERE d.host = 'skillpilot.dfirma.pl'
  AND d.active = 1
  AND s.status = 'active'
LIMIT 1;

SELECT * FROM agreement_template WHERE school_id = ? AND active = 1 ORDER BY document_type, name

[
  1
]

SELECT
  *
FROM
  agreement_template
WHERE
  school_id = ?
  AND active = 1
ORDER BY
  document_type,
  name

SELECT * FROM agreement_template WHERE school_id = 1 AND active = 1 ORDER BY document_type, name;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM app_user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.active AS active_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.active AS active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM app_user t0 WHERE t0.id = 1;

SELECT * FROM learner WHERE school_id = ? AND active = 1 ORDER BY last_name, first_name

[
  1
]

SELECT
  *
FROM
  learner
WHERE
  school_id = ?
  AND active = 1
ORDER BY
  last_name,
  first_name

SELECT * FROM learner WHERE school_id = 1 AND active = 1 ORDER BY last_name, first_name;

SELECT * FROM class_group WHERE school_id = ? AND active = 1 ORDER BY name

[
  1
]

SELECT
  *
FROM
  class_group
WHERE
  school_id = ?
  AND active = 1
ORDER BY
  name

SELECT * FROM class_group WHERE school_id = 1 AND active = 1 ORDER BY name;

SELECT COUNT(*) FROM agreement_template WHERE school_id = ?

[
  1
]

SELECT
  COUNT(*)
FROM
  agreement_template
WHERE
  school_id = ?

SELECT COUNT(*) FROM agreement_template WHERE school_id = 1;