Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation 92
• Security
• Twig
• Doctrine
• HTTP Client
• Debug
• Emails
• Serializer
• Configuration

Query Metrics

SELECT
    f.*
FROM
    faq f
LEFT JOIN
    faqcategories fc ON f.idCategory = fc.id
WHERE
    fc.id = :categoryId
    AND f.Active = 'Active'
ORDER BY
    f.SortOrder

[
  ":categoryId" => 1
]

SELECT
  f.*
FROM
  faq f
  LEFT JOIN faqcategories fc ON f.idCategory = fc.id
WHERE
  fc.id = :categoryId
  AND f.Active = 'Active'
ORDER BY
  f.SortOrder

SELECT
    f.*
FROM
    faq f
LEFT JOIN
    faqcategories fc ON f.idCategory = fc.id
WHERE
    fc.id = :categoryId
    AND f.Active = 'Active'
ORDER BY
    f.SortOrder;

SELECT t0.description AS description_1, t0.SortOrder AS SortOrder_2, t0.updated AS updated_3, t0.created AS created_4, t0.id AS id_5 FROM faqcategories t0 WHERE t0.id = ?

[
  "1"
]

SELECT
  t0.description AS description_1,
  t0.SortOrder AS SortOrder_2,
  t0.updated AS updated_3,
  t0.created AS created_4,
  t0.id AS id_5
FROM
  faqcategories t0
WHERE
  t0.id = ?

SELECT t0.description AS description_1, t0.SortOrder AS SortOrder_2, t0.updated AS updated_3, t0.created AS created_4, t0.id AS id_5 FROM faqcategories t0 WHERE t0.id = '1';

SELECT t0.Name AS Name_1, t0.ShortCode AS ShortCode_2, t0.IsWrittenLanguage AS IsWrittenLanguage_3, t0.IsSpokenLanguage AS IsSpokenLanguage_4, t0.IsSignLanguage AS IsSignLanguage_5 FROM language t0 WHERE t0.ShortCode = ? LIMIT 1

[
  "fa"
]

SELECT
  t0.Name AS Name_1,
  t0.ShortCode AS ShortCode_2,
  t0.IsWrittenLanguage AS IsWrittenLanguage_3,
  t0.IsSpokenLanguage AS IsSpokenLanguage_4,
  t0.IsSignLanguage AS IsSignLanguage_5
FROM
  language t0
WHERE
  t0.ShortCode = ?
LIMIT
  1

SELECT t0.Name AS Name_1, t0.ShortCode AS ShortCode_2, t0.IsWrittenLanguage AS IsWrittenLanguage_3, t0.IsSpokenLanguage AS IsSpokenLanguage_4, t0.IsSignLanguage AS IsSignLanguage_5 FROM language t0 WHERE t0.ShortCode = 'fa' LIMIT 1;

SELECT t0.description AS description_1, t0.SortOrder AS SortOrder_2, t0.updated AS updated_3, t0.created AS created_4, t0.id AS id_5 FROM faqcategories t0 ORDER BY t0.SortOrder ASC

[]

SELECT
  t0.description AS description_1,
  t0.SortOrder AS SortOrder_2,
  t0.updated AS updated_3,
  t0.created AS created_4,
  t0.id AS id_5
FROM
  faqcategories t0
ORDER BY
  t0.SortOrder ASC

SELECT t0.description AS description_1, t0.SortOrder AS SortOrder_2, t0.updated AS updated_3, t0.created AS created_4, t0.id AS id_5 FROM faqcategories t0 ORDER BY t0.SortOrder ASC;