Symfony Profiler

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

Query Metrics

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.title AS title_6 FROM service_categories t0 WHERE t0.id = ?

[
  b"\x01ž\x1AÓÙhr-‡L\x06¤å£D\x08"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.image AS image_3,
  t0.image_directory AS image_directory_4,
  t0.id AS id_5,
  t0.title AS title_6
FROM
  service_categories t0
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.image AS image_3, t0.image_directory AS image_directory_4, t0.id AS id_5, t0.title AS title_6 FROM service_categories t0 WHERE t0.id = 0x019E1AD3D968722D874C06A4E5A34408;

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.image AS image_2, s0_.image_directory AS image_directory_3, s0_.id AS id_4, s0_.title AS title_5, s0_.featured AS featured_6, s0_.status AS status_7, s0_.description AS description_8, s0_.category_id AS category_id_9 FROM services s0_ LEFT JOIN service_categories s1_ ON s0_.category_id = s1_.id WHERE s0_.status = ? AND ((LOWER(s0_.title) LIKE ? OR LOWER(s1_.title) LIKE ?) AND (LOWER(s0_.title) LIKE ? OR LOWER(s1_.title) LIKE ?)) ORDER BY s0_.title ASC LIMIT 50

[
  "active"
  "%printing%"
  "%printing%"
  "%services%"
  "%services%"
]

SELECT
  s0_.created_at AS created_at_0,
  s0_.updated_at AS updated_at_1,
  s0_.image AS image_2,
  s0_.image_directory AS image_directory_3,
  s0_.id AS id_4,
  s0_.title AS title_5,
  s0_.featured AS featured_6,
  s0_.status AS status_7,
  s0_.description AS description_8,
  s0_.category_id AS category_id_9
FROM
  services s0_
  LEFT JOIN service_categories s1_ ON s0_.category_id = s1_.id
WHERE
  s0_.status = ?
  AND (
    (
      LOWER(s0_.title) LIKE ?
      OR LOWER(s1_.title) LIKE ?
    )
    AND (
      LOWER(s0_.title) LIKE ?
      OR LOWER(s1_.title) LIKE ?
    )
  )
ORDER BY
  s0_.title ASC
LIMIT
  50

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.image AS image_2, s0_.image_directory AS image_directory_3, s0_.id AS id_4, s0_.title AS title_5, s0_.featured AS featured_6, s0_.status AS status_7, s0_.description AS description_8, s0_.category_id AS category_id_9 FROM services s0_ LEFT JOIN service_categories s1_ ON s0_.category_id = s1_.id WHERE s0_.status = 'active' AND ((LOWER(s0_.title) LIKE '%printing%' OR LOWER(s1_.title) LIKE '%printing%') AND (LOWER(s0_.title) LIKE '%services%' OR LOWER(s1_.title) LIKE '%services%')) ORDER BY s0_.title ASC LIMIT 50;