Symfony Profiler

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

Query Metrics

SELECT pi.path FROM product_image pi WHERE pi.product_id = ?

[
  b"\x13ð⢋®\x11ïµ6Ùây‘\x16Â"
]

SELECT
  pi.path
FROM
  product_image pi
WHERE
  pi.product_id = ?

SELECT pi.path FROM product_image pi WHERE pi.product_id = 0x13F0E2A28BAE11EFB536D9E2799116C2;

SELECT p.*, pc.designation AS category FROM product p INNER JOIN product_category pc ON pc.id = p.category_id INNER JOIN company c ON c.id = p.company_id WHERE c.slug = ?

[
  "tafiya-rfjcwi"
]

SELECT
  p.*,
  pc.designation AS category
FROM
  product p
  INNER JOIN product_category pc ON pc.id = p.category_id
  INNER JOIN company c ON c.id = p.company_id
WHERE
  c.slug = ?

SELECT p.*, pc.designation AS category FROM product p INNER JOIN product_category pc ON pc.id = p.category_id INNER JOIN company c ON c.id = p.company_id WHERE c.slug = 'tafiya-rfjcwi';

SELECT COUNT(*) AS total FROM (SELECT p.*, pc.designation AS category FROM product p INNER JOIN product_category pc ON pc.id = p.category_id INNER JOIN company c ON c.id = p.company_id WHERE c.slug = ?) t

[
  "tafiya-rfjcwi"
]

SELECT
  COUNT(*) AS total
FROM
  (
    SELECT
      p.*,
      pc.designation AS category
    FROM
      product p
      INNER JOIN product_category pc ON pc.id = p.category_id
      INNER JOIN company c ON c.id = p.company_id
    WHERE
      c.slug = ?
  ) t

SELECT COUNT(*) AS total FROM (SELECT p.*, pc.designation AS category FROM product p INNER JOIN product_category pc ON pc.id = p.category_id INNER JOIN company c ON c.id = p.company_id WHERE c.slug = 'tafiya-rfjcwi') t;