Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• Doctrine
• Debug
• Serializer
• Configuration

Query Metrics

SELECT r0_.rsid AS rsid_0, r0_.locale AS locale_1, r0_.category AS category_2, r0_.title AS title_3, r0_.author AS author_4, r0_.ingredients AS ingredients_5, r0_.tags AS tags_6, r0_.impressions AS impressions_7, r1_.uuid AS uuid_8, r1_.slug AS slug_9, r1_.cuuid AS cuuid_10, r1_.category AS category_11, r1_.title AS title_12, r1_.description AS description_13, r1_.preparation AS preparation_14, r1_.ingredients AS ingredients_15, r1_.translation AS translation_16, r1_.source AS source_17, r1_.author AS author_18, r1_.cover AS cover_19, r1_.images AS images_20, r1_.impressions AS impressions_21, r1_.created_at AS created_at_22, r1_.updated_at AS updated_at_23, r1_.active AS active_24, r0_.recipe AS recipe_25 FROM recipe_search r0_ INNER JOIN recipe r1_ ON r0_.recipe = r1_.uuid WHERE r0_.locale = ? AND ((r0_.category LIKE ? OR r0_.title LIKE ? OR r0_.ingredients LIKE ? OR r0_.author LIKE ? OR r0_.ingredients LIKE ? OR r0_.tags LIKE ?)) ORDER BY r0_.impressions DESC LIMIT 24

[
  "en"
  "%cocoa%"
  "%cocoa%"
  "%cocoa%"
  "%cocoa%"
  "%cocoa%"
  "%cocoa%"
]

SELECT
  r0_.rsid AS rsid_0,
  r0_.locale AS locale_1,
  r0_.category AS category_2,
  r0_.title AS title_3,
  r0_.author AS author_4,
  r0_.ingredients AS ingredients_5,
  r0_.tags AS tags_6,
  r0_.impressions AS impressions_7,
  r1_.uuid AS uuid_8,
  r1_.slug AS slug_9,
  r1_.cuuid AS cuuid_10,
  r1_.category AS category_11,
  r1_.title AS title_12,
  r1_.description AS description_13,
  r1_.preparation AS preparation_14,
  r1_.ingredients AS ingredients_15,
  r1_.translation AS translation_16,
  r1_.source AS source_17,
  r1_.author AS author_18,
  r1_.cover AS cover_19,
  r1_.images AS images_20,
  r1_.impressions AS impressions_21,
  r1_.created_at AS created_at_22,
  r1_.updated_at AS updated_at_23,
  r1_.active AS active_24,
  r0_.recipe AS recipe_25
FROM
  recipe_search r0_
  INNER JOIN recipe r1_ ON r0_.recipe = r1_.uuid
WHERE
  r0_.locale = ?
  AND (
    (
      r0_.category LIKE ?
      OR r0_.title LIKE ?
      OR r0_.ingredients LIKE ?
      OR r0_.author LIKE ?
      OR r0_.ingredients LIKE ?
      OR r0_.tags LIKE ?
    )
  )
ORDER BY
  r0_.impressions DESC
LIMIT
  24

SELECT r0_.rsid AS rsid_0, r0_.locale AS locale_1, r0_.category AS category_2, r0_.title AS title_3, r0_.author AS author_4, r0_.ingredients AS ingredients_5, r0_.tags AS tags_6, r0_.impressions AS impressions_7, r1_.uuid AS uuid_8, r1_.slug AS slug_9, r1_.cuuid AS cuuid_10, r1_.category AS category_11, r1_.title AS title_12, r1_.description AS description_13, r1_.preparation AS preparation_14, r1_.ingredients AS ingredients_15, r1_.translation AS translation_16, r1_.source AS source_17, r1_.author AS author_18, r1_.cover AS cover_19, r1_.images AS images_20, r1_.impressions AS impressions_21, r1_.created_at AS created_at_22, r1_.updated_at AS updated_at_23, r1_.active AS active_24, r0_.recipe AS recipe_25 FROM recipe_search r0_ INNER JOIN recipe r1_ ON r0_.recipe = r1_.uuid WHERE r0_.locale = 'en' AND ((r0_.category LIKE '%cocoa%' OR r0_.title LIKE '%cocoa%' OR r0_.ingredients LIKE '%cocoa%' OR r0_.author LIKE '%cocoa%' OR r0_.ingredients LIKE '%cocoa%' OR r0_.tags LIKE '%cocoa%')) ORDER BY r0_.impressions DESC LIMIT 24;