Symfony Profiler

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

Query Metrics

SELECT
    i.*,
    u.email,
    u.first_name,
    u.last_name,
    d.host AS primary_domain
FROM invoice i
INNER JOIN app_user u ON u.id = i.recipient_id
INNER JOIN school s ON s.id = i.school_id
LEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1
WHERE i.payment_public_token = ?
    AND s.active = 1
LIMIT 1

[
  "pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0"
]

SELECT
  i.*,
  u.email,
  u.first_name,
  u.last_name,
  d.host AS primary_domain
FROM
  invoice i
  INNER JOIN app_user u ON u.id = i.recipient_id
  INNER JOIN school s ON s.id = i.school_id
  LEFT JOIN school_domain d ON d.school_id = i.school_id
  AND d.primary_domain = 1
  AND d.active = 1
WHERE
  i.payment_public_token = ?
  AND s.active = 1
LIMIT
  1

SELECT
    i.*,
    u.email,
    u.first_name,
    u.last_name,
    d.host AS primary_domain
FROM invoice i
INNER JOIN app_user u ON u.id = i.recipient_id
INNER JOIN school s ON s.id = i.school_id
LEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1
WHERE i.payment_public_token = 'pay_A69wMP8SIjEMdm60N8169VBQrl5k_Ira2_EXwEpN0c0'
    AND s.active = 1
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 = ?
  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
    i.*,
    u.email,
    u.first_name,
    u.last_name,
    d.host AS primary_domain
FROM invoice i
INNER JOIN app_user u ON u.id = i.recipient_id
INNER JOIN school s ON s.id = i.school_id
LEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1
WHERE s.active = 1
    AND i.issued_at >= ?
ORDER BY i.issued_at DESC, i.id DESC
LIMIT 1000

[
  "2025-02-19 16:48:19"
]

SELECT
  i.*,
  u.email,
  u.first_name,
  u.last_name,
  d.host AS primary_domain
FROM
  invoice i
  INNER JOIN app_user u ON u.id = i.recipient_id
  INNER JOIN school s ON s.id = i.school_id
  LEFT JOIN school_domain d ON d.school_id = i.school_id
  AND d.primary_domain = 1
  AND d.active = 1
WHERE
  s.active = 1
  AND i.issued_at >= ?
ORDER BY
  i.issued_at DESC,
  i.id DESC
LIMIT
  1000

SELECT
    i.*,
    u.email,
    u.first_name,
    u.last_name,
    d.host AS primary_domain
FROM invoice i
INNER JOIN app_user u ON u.id = i.recipient_id
INNER JOIN school s ON s.id = i.school_id
LEFT JOIN school_domain d ON d.school_id = i.school_id AND d.primary_domain = 1 AND d.active = 1
WHERE s.active = 1
    AND i.issued_at >= '2025-02-19 16:48:19'
ORDER BY i.issued_at DESC, i.id DESC
LIMIT 1000;