Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 29
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.mfr_code AS mfr_code_2, p0_.blk_code AS blk_code_3, p0_.slug AS slug_4, p1_.name AS name_5, p2_.name AS name_6, p3_.slug AS slug_7 FROM products p0_ INNER JOIN product_manufacturer p1_ ON (p0_.manufacturer_id = p1_.id) INNER JOIN product_type p2_ ON (p0_.type_id = p2_.id) LEFT JOIN products_categories p4_ ON (p4_.product_id = p0_.id AND p4_.main = 1) LEFT JOIN product_category p3_ ON (p4_.category_id = p3_.id) WHERE (p0_.published = ? AND (LOWER(p0_.name) LIKE ? OR LOWER(p1_.name) LIKE ? OR LOWER(p2_.name) LIKE ? OR LOWER(p0_.mfr_code) LIKE ? OR LOWER(p0_.blk_code) LIKE ?)) AND p0_.discr IN ('product', 'product_kit') ORDER BY p0_.name ASC LIMIT 30

[
  1
  "%sirui%"
  "%sirui%"
  "%sirui%"
  "%sirui%"
  "%sirui%"
]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.mfr_code AS mfr_code_2,
  p0_.blk_code AS blk_code_3,
  p0_.slug AS slug_4,
  p1_.name AS name_5,
  p2_.name AS name_6,
  p3_.slug AS slug_7
FROM
  products p0_
  INNER JOIN product_manufacturer p1_ ON (p0_.manufacturer_id = p1_.id)
  INNER JOIN product_type p2_ ON (p0_.type_id = p2_.id)
  LEFT JOIN products_categories p4_ ON (
    p4_.product_id = p0_.id
    AND p4_.main = 1
  )
  LEFT JOIN product_category p3_ ON (p4_.category_id = p3_.id)
WHERE
  (
    p0_.published = ?
    AND (
      LOWER(p0_.name) LIKE ?
      OR LOWER(p1_.name) LIKE ?
      OR LOWER(p2_.name) LIKE ?
      OR LOWER(p0_.mfr_code) LIKE ?
      OR LOWER(p0_.blk_code) LIKE ?
    )
  )
  AND p0_.discr IN ('product', 'product_kit')
ORDER BY
  p0_.name ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.name AS name_1, p0_.mfr_code AS mfr_code_2, p0_.blk_code AS blk_code_3, p0_.slug AS slug_4, p1_.name AS name_5, p2_.name AS name_6, p3_.slug AS slug_7 FROM products p0_ INNER JOIN product_manufacturer p1_ ON (p0_.manufacturer_id = p1_.id) INNER JOIN product_type p2_ ON (p0_.type_id = p2_.id) LEFT JOIN products_categories p4_ ON (p4_.product_id = p0_.id AND p4_.main = 1) LEFT JOIN product_category p3_ ON (p4_.category_id = p3_.id) WHERE (p0_.published = 1 AND (LOWER(p0_.name) LIKE '%sirui%' OR LOWER(p1_.name) LIKE '%sirui%' OR LOWER(p2_.name) LIKE '%sirui%' OR LOWER(p0_.mfr_code) LIKE '%sirui%' OR LOWER(p0_.blk_code) LIKE '%sirui%')) AND p0_.discr IN ('product', 'product_kit') ORDER BY p0_.name ASC LIMIT 30;