Symfony Profiler

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

Query Metrics

SELECT
    s.id,
    s.name,
    s.slug,
    s.status,
    s.default_locale,
    s.logo_path,
    s.meta_title_suffix,
    s.gtm_container_id,
    s.google_analytics_id,
    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

[
  "demo.skillpilot.dfirma.pl"
]

SELECT
  s.id,
  s.name,
  s.slug,
  s.status,
  s.default_locale,
  s.logo_path,
  s.meta_title_suffix,
  s.gtm_container_id,
  s.google_analytics_id,
  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,
    s.gtm_container_id,
    s.google_analytics_id,
    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 = 'demo.skillpilot.dfirma.pl'
  AND d.active = 1
  AND s.status = 'active'
LIMIT 1;

SELECT id FROM app_user WHERE email = ? AND active = 1 LIMIT 1

[
  "admin.demo@skillpilot.pl"
]

SELECT
  id
FROM
  app_user
WHERE
  email = ?
  AND active = 1
LIMIT
  1

SELECT id FROM app_user WHERE email = 'admin.demo@skillpilot.pl' AND 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.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 = ?

[
  8
]

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 = 8;

SELECT COUNT(*) FROM class_group WHERE school_id = ?

[
  4
]

SELECT
  COUNT(*)
FROM
  class_group
WHERE
  school_id = ?

SELECT COUNT(*) FROM class_group WHERE school_id = 4;

SELECT COUNT(*) FROM lesson WHERE school_id = ? AND DATE(starts_at) = CURRENT_DATE()

[
  4
]

SELECT
  COUNT(*)
FROM
  lesson
WHERE
  school_id = ?
  AND DATE(starts_at) = CURRENT_DATE()

SELECT COUNT(*) FROM lesson WHERE school_id = 4 AND DATE(starts_at) = CURRENT_DATE();

SELECT COUNT(*) FROM invoice WHERE school_id = ?

[
  4
]

SELECT
  COUNT(*)
FROM
  invoice
WHERE
  school_id = ?

SELECT COUNT(*) FROM invoice WHERE school_id = 4;

SELECT COUNT(*) FROM learner WHERE school_id = ? AND active = 1

[
  4
]

SELECT
  COUNT(*)
FROM
  learner
WHERE
  school_id = ?
  AND active = 1

SELECT COUNT(*) FROM learner WHERE school_id = 4 AND active = 1;

SELECT s.*, d.host
FROM school s
LEFT JOIN school_domain d ON d.school_id = s.id AND d.primary_domain = 1
ORDER BY s.name

[]

SELECT
  s.*,
  d.host
FROM
  school s
  LEFT JOIN school_domain d ON d.school_id = s.id
  AND d.primary_domain = 1
ORDER BY
  s.name

SELECT s.*, d.host
FROM school s
LEFT JOIN school_domain d ON d.school_id = s.id AND d.primary_domain = 1
ORDER BY s.name;

SELECT * FROM school_r2_config WHERE school_id = ? LIMIT 1

[
  4
]

SELECT
  *
FROM
  school_r2_config
WHERE
  school_id = ?
LIMIT
  1

SELECT * FROM school_r2_config WHERE school_id = 4 LIMIT 1;

SELECT lesson.*, g.name AS group_name
FROM lesson
INNER JOIN class_group g ON g.id = lesson.class_group_id
WHERE lesson.school_id = ?
ORDER BY lesson.starts_at ASC
LIMIT 10

[
  4
]

SELECT
  lesson.*,
  g.name AS group_name
FROM
  lesson
  INNER JOIN class_group g ON g.id = lesson.class_group_id
WHERE
  lesson.school_id = ?
ORDER BY
  lesson.starts_at ASC
LIMIT
  10

SELECT lesson.*, g.name AS group_name
FROM lesson
INNER JOIN class_group g ON g.id = lesson.class_group_id
WHERE lesson.school_id = 4
ORDER BY lesson.starts_at ASC
LIMIT 10;