Symfony Profiler

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

Query Metrics

SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.type AS type_3, o0_.work_mode AS work_mode_4, o0_.city AS city_5, o0_.country AS country_6, o0_.salary_min AS salary_min_7, o0_.salary_max AS salary_max_8, o0_.status AS status_9, o0_.created_at AS created_at_10, o0_.expires_at AS expires_at_11, o0_.company_id AS company_id_12 FROM offer o0_ LEFT JOIN company_profile c1_ ON o0_.company_id = c1_.id WHERE o0_.status = ? AND (o0_.title LIKE ? OR o0_.description LIKE ?) AND o0_.type = ? AND (o0_.city LIKE ? OR o0_.country LIKE ?) ORDER BY o0_.created_at DESC LIMIT 12

[
  "PUBLISHED"
  "%Développeur%"
  "%Développeur%"
  "JOB"
  "%Lyon%"
  "%Lyon%"
]

SELECT
  o0_.id AS id_0,
  o0_.title AS title_1,
  o0_.description AS description_2,
  o0_.type AS type_3,
  o0_.work_mode AS work_mode_4,
  o0_.city AS city_5,
  o0_.country AS country_6,
  o0_.salary_min AS salary_min_7,
  o0_.salary_max AS salary_max_8,
  o0_.status AS status_9,
  o0_.created_at AS created_at_10,
  o0_.expires_at AS expires_at_11,
  o0_.company_id AS company_id_12
FROM
  offer o0_
  LEFT JOIN company_profile c1_ ON o0_.company_id = c1_.id
WHERE
  o0_.status = ?
  AND (
    o0_.title LIKE ?
    OR o0_.description LIKE ?
  )
  AND o0_.type = ?
  AND (
    o0_.city LIKE ?
    OR o0_.country LIKE ?
  )
ORDER BY
  o0_.created_at DESC
LIMIT
  12

SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.description AS description_2, o0_.type AS type_3, o0_.work_mode AS work_mode_4, o0_.city AS city_5, o0_.country AS country_6, o0_.salary_min AS salary_min_7, o0_.salary_max AS salary_max_8, o0_.status AS status_9, o0_.created_at AS created_at_10, o0_.expires_at AS expires_at_11, o0_.company_id AS company_id_12 FROM offer o0_ LEFT JOIN company_profile c1_ ON o0_.company_id = c1_.id WHERE o0_.status = 'PUBLISHED' AND (o0_.title LIKE '%Développeur%' OR o0_.description LIKE '%Développeur%') AND o0_.type = 'JOB' AND (o0_.city LIKE '%Lyon%' OR o0_.country LIKE '%Lyon%') ORDER BY o0_.created_at DESC LIMIT 12;

SELECT COUNT(o0_.id) AS sclr_0 FROM offer o0_ WHERE o0_.status = ? AND (o0_.title LIKE ? OR o0_.description LIKE ?) AND o0_.type = ? AND (o0_.city LIKE ? OR o0_.country LIKE ?)

[
  "PUBLISHED"
  "%Développeur%"
  "%Développeur%"
  "JOB"
  "%Lyon%"
  "%Lyon%"
]

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offer o0_
WHERE
  o0_.status = ?
  AND (
    o0_.title LIKE ?
    OR o0_.description LIKE ?
  )
  AND o0_.type = ?
  AND (
    o0_.city LIKE ?
    OR o0_.country LIKE ?
  )

SELECT COUNT(o0_.id) AS sclr_0 FROM offer o0_ WHERE o0_.status = 'PUBLISHED' AND (o0_.title LIKE '%Développeur%' OR o0_.description LIKE '%Développeur%') AND o0_.type = 'JOB' AND (o0_.city LIKE '%Lyon%' OR o0_.country LIKE '%Lyon%');

SELECT DISTINCT o0_.city AS city_0 FROM offer o0_ WHERE o0_.city IS NOT NULL AND o0_.city <> ? AND o0_.status = ? ORDER BY o0_.city ASC

[
  ""
  "PUBLISHED"
]

SELECT
  DISTINCT o0_.city AS city_0
FROM
  offer o0_
WHERE
  o0_.city IS NOT NULL
  AND o0_.city <> ?
  AND o0_.status = ?
ORDER BY
  o0_.city ASC

SELECT DISTINCT o0_.city AS city_0 FROM offer o0_ WHERE o0_.city IS NOT NULL AND o0_.city <> '' AND o0_.status = 'PUBLISHED' ORDER BY o0_.city ASC;