Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.display_name AS display_name_3, t0.author_name AS author_name_4, t0.initials AS initials_5, t0.address_uid AS address_uid_6, t0.role AS role_7, t0.password_hash AS password_hash_8, t0.is_active AS is_active_9, t0.last_login_at AS last_login_at_10, t0.created_at AS created_at_11 FROM user_account t0 WHERE t0.id = ?

[
  b"\x01ŸÖÕQôzÑ­’2åÃp?¿"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.display_name AS display_name_3,
  t0.author_name AS author_name_4,
  t0.initials AS initials_5,
  t0.address_uid AS address_uid_6,
  t0.role AS role_7,
  t0.password_hash AS password_hash_8,
  t0.is_active AS is_active_9,
  t0.last_login_at AS last_login_at_10,
  t0.created_at AS created_at_11
FROM
  user_account t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.display_name AS display_name_3, t0.author_name AS author_name_4, t0.initials AS initials_5, t0.address_uid AS address_uid_6, t0.role AS role_7, t0.password_hash AS password_hash_8, t0.is_active AS is_active_9, t0.last_login_at AS last_login_at_10, t0.created_at AS created_at_11 FROM user_account t0 WHERE t0.id = 0x019FD6D551F47AD1AD9232E5C3703FBF;

SELECT n.*,
                (SELECT e.uid FROM tx_news_domain_model_news e
                    WHERE e.l10n_parent=n.uid AND e.sys_language_uid=1 AND e.deleted=0 LIMIT 1) en_uid,
                (SELECT e.hidden FROM tx_news_domain_model_news e
                    WHERE e.l10n_parent=n.uid AND e.sys_language_uid=1 AND e.deleted=0 LIMIT 1) en_hidden
            FROM tx_news_domain_model_news n
            WHERE n.uid=? AND n.deleted=0

[
  928
]

SELECT
  n.*,
  (
    SELECT
      e.uid
    FROM
      tx_news_domain_model_news e
    WHERE
      e.l10n_parent = n.uid
      AND e.sys_language_uid = 1
      AND e.deleted = 0
    LIMIT
      1
  ) en_uid,
  (
    SELECT
      e.hidden
    FROM
      tx_news_domain_model_news e
    WHERE
      e.l10n_parent = n.uid
      AND e.sys_language_uid = 1
      AND e.deleted = 0
    LIMIT
      1
  ) en_hidden
FROM
  tx_news_domain_model_news n
WHERE
  n.uid = ?
  AND n.deleted = 0

SELECT n.*,
                (SELECT e.uid FROM tx_news_domain_model_news e
                    WHERE e.l10n_parent=n.uid AND e.sys_language_uid=1 AND e.deleted=0 LIMIT 1) en_uid,
                (SELECT e.hidden FROM tx_news_domain_model_news e
                    WHERE e.l10n_parent=n.uid AND e.sys_language_uid=1 AND e.deleted=0 LIMIT 1) en_hidden
            FROM tx_news_domain_model_news n
            WHERE n.uid=928 AND n.deleted=0;

SELECT * FROM tt_content WHERE tx_news_related_news=? AND sys_language_uid=? AND deleted=0 ORDER BY sorting

[
  928
  0
]

SELECT
  *
FROM
  tt_content
WHERE
  tx_news_related_news = ?
  AND sys_language_uid = ?
  AND deleted = 0
ORDER BY
  sorting

SELECT * FROM tt_content WHERE tx_news_related_news=928 AND sys_language_uid=0 AND deleted=0 ORDER BY sorting;

SELECT * FROM tt_content
            WHERE tx_news_related_news=? AND sys_language_uid=? AND deleted=0 AND hidden=0 ORDER BY sorting

[
  928
  0
]

SELECT
  *
FROM
  tt_content
WHERE
  tx_news_related_news = ?
  AND sys_language_uid = ?
  AND deleted = 0
  AND hidden = 0
ORDER BY
  sorting

SELECT * FROM tt_content
            WHERE tx_news_related_news=928 AND sys_language_uid=0 AND deleted=0 AND hidden=0 ORDER BY sorting;

SELECT * FROM tx_news_domain_model_news WHERE uid=? AND deleted=0

[
  928
]

SELECT
  *
FROM
  tx_news_domain_model_news
WHERE
  uid = ?
  AND deleted = 0

SELECT * FROM tx_news_domain_model_news WHERE uid=928 AND deleted=0;

SELECT * FROM tx_mask_faq_items WHERE parentid IN (?) AND parenttable='tt_content' AND deleted=0 ORDER BY sorting

[
  7827
]

SELECT
  *
FROM
  tx_mask_faq_items
WHERE
  parentid IN (?)
  AND parenttable = 'tt_content'
  AND deleted = 0
ORDER BY
  sorting

SELECT * FROM tx_mask_faq_items WHERE parentid IN (7827) AND parenttable='tt_content' AND deleted=0 ORDER BY sorting;

SELECT f.identifier FROM sys_file_reference r JOIN sys_file f ON f.uid=r.uid_local
             WHERE r.tablenames='tx_news_domain_model_news' AND r.fieldname='fal_media' AND r.deleted=0
               AND r.uid_foreign=? ORDER BY r.sorting_foreign LIMIT 1

[
  928
]

SELECT
  f.identifier
FROM
  sys_file_reference r
  JOIN sys_file f ON f.uid = r.uid_local
WHERE
  r.tablenames = 'tx_news_domain_model_news'
  AND r.fieldname = 'fal_media'
  AND r.deleted = 0
  AND r.uid_foreign = ?
ORDER BY
  r.sorting_foreign
LIMIT
  1

SELECT f.identifier FROM sys_file_reference r JOIN sys_file f ON f.uid=r.uid_local
             WHERE r.tablenames='tx_news_domain_model_news' AND r.fieldname='fal_media' AND r.deleted=0
               AND r.uid_foreign=928 ORDER BY r.sorting_foreign LIMIT 1;

SELECT uid FROM tx_maxfeld_workflow_label WHERE deleted=0 AND title=? LIMIT 1

[
  "Freigegeben (Autor)"
]

SELECT
  uid
FROM
  tx_maxfeld_workflow_label
WHERE
  deleted = 0
  AND title = ?
LIMIT
  1

SELECT uid FROM tx_maxfeld_workflow_label WHERE deleted=0 AND title='Freigegeben (Autor)' LIMIT 1;