Symfony Profiler

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

Query Metrics

SELECT * FROM school_website_config WHERE school_id = ? LIMIT 1

[
  53
]

SELECT
  *
FROM
  school_website_config
WHERE
  school_id = ?
LIMIT
  1

SELECT * FROM school_website_config WHERE school_id = 53 LIMIT 1;

SELECT code, enabled FROM school_feature_flag WHERE school_id = ?

[
  53
]

SELECT
  code,
  enabled
FROM
  school_feature_flag
WHERE
  school_id = ?

SELECT code, enabled FROM school_feature_flag WHERE school_id = 53;

SELECT * FROM location WHERE school_id = ? AND active = 1 ORDER BY sort_order ASC, name ASC, id ASC

[
  53
]

SELECT
  *
FROM
  location
WHERE
  school_id = ?
  AND active = 1
ORDER BY
  sort_order ASC,
  name ASC,
  id ASC

SELECT * FROM location WHERE school_id = 53 AND active = 1 ORDER BY sort_order ASC, name ASC, id ASC;

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.panelzajec.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.panelzajec.pl'
  AND d.active = 1
  AND s.status = 'active'
LIMIT 1;

SELECT g.*, l.name AS location_name
FROM class_group g
LEFT JOIN location l ON l.id = g.default_location_id
WHERE g.school_id = ?
    AND g.active = 1
    AND g.self_enrollment_enabled = 1
ORDER BY g.sort_order ASC, g.name ASC, g.id ASC

[
  53
]

SELECT
  g.*,
  l.name AS location_name
FROM
  class_group g
  LEFT JOIN location l ON l.id = g.default_location_id
WHERE
  g.school_id = ?
  AND g.active = 1
  AND g.self_enrollment_enabled = 1
ORDER BY
  g.sort_order ASC,
  g.name ASC,
  g.id ASC

SELECT g.*, l.name AS location_name
FROM class_group g
LEFT JOIN location l ON l.id = g.default_location_id
WHERE g.school_id = 53
    AND g.active = 1
    AND g.self_enrollment_enabled = 1
ORDER BY g.sort_order ASC, g.name ASC, g.id ASC;

SELECT name, file_path FROM school_file_document WHERE school_id = ? AND active = 1 AND display_in_footer = 1 ORDER BY name ASC, id ASC

[
  53
]

SELECT
  name,
  file_path
FROM
  school_file_document
WHERE
  school_id = ?
  AND active = 1
  AND display_in_footer = 1
ORDER BY
  name ASC,
  id ASC

SELECT name, file_path FROM school_file_document WHERE school_id = 53 AND active = 1 AND display_in_footer = 1 ORDER BY name ASC, id ASC;