Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 34
• Events
• Routing
• Cache
• Translation 5
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Configuration

Query Metrics

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.description AS description_3, s0_.category AS category_4, s0_.created_at AS created_at_5, s0_.parent_id AS parent_id_6 FROM service_type s0_ LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id AND (s1_.is_posted = 1) WHERE (SELECT COUNT(*) FROM field f2_ WHERE f2_.service_id = s1_.id) > 0 AND (s0_.category = ? OR s0_.category = ?) LIMIT 10

[
  "Particulier"
  "both"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.price AS price_2,
  s0_.description AS description_3,
  s0_.category AS category_4,
  s0_.created_at AS created_at_5,
  s0_.parent_id AS parent_id_6
FROM
  service_type s0_
  LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id
  AND (s1_.is_posted = 1)
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      field f2_
    WHERE
      f2_.service_id = s1_.id
  ) > 0
  AND (
    s0_.category = ?
    OR s0_.category = ?
  )
LIMIT
  10

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.description AS description_3, s0_.category AS category_4, s0_.created_at AS created_at_5, s0_.parent_id AS parent_id_6 FROM service_type s0_ LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id AND (s1_.is_posted = 1) WHERE (SELECT COUNT(*) FROM field f2_ WHERE f2_.service_id = s1_.id) > 0 AND (s0_.category = 'Particulier' OR s0_.category = 'both') LIMIT 10;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.description AS description_3, s0_.category AS category_4, s0_.created_at AS created_at_5, s0_.parent_id AS parent_id_6 FROM service_type s0_ LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id AND (s1_.is_posted = 1) WHERE (SELECT COUNT(*) FROM field f2_ WHERE f2_.service_id = s1_.id) > 0 AND (s0_.category = ? OR s0_.category = ?) LIMIT 10

[
  "Professionnel"
  "both"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.price AS price_2,
  s0_.description AS description_3,
  s0_.category AS category_4,
  s0_.created_at AS created_at_5,
  s0_.parent_id AS parent_id_6
FROM
  service_type s0_
  LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id
  AND (s1_.is_posted = 1)
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      field f2_
    WHERE
      f2_.service_id = s1_.id
  ) > 0
  AND (
    s0_.category = ?
    OR s0_.category = ?
  )
LIMIT
  10

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.description AS description_3, s0_.category AS category_4, s0_.created_at AS created_at_5, s0_.parent_id AS parent_id_6 FROM service_type s0_ LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id AND (s1_.is_posted = 1) WHERE (SELECT COUNT(*) FROM field f2_ WHERE f2_.service_id = s1_.id) > 0 AND (s0_.category = 'Professionnel' OR s0_.category = 'both') LIMIT 10;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.description AS description_3, s0_.category AS category_4, s0_.created_at AS created_at_5, s0_.parent_id AS parent_id_6 FROM service_type s0_ LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id AND (s1_.is_posted = 1) WHERE (SELECT COUNT(*) FROM field f2_ WHERE f2_.service_id = s1_.id) > 0 AND ((s0_.category = ? OR s0_.category = ? OR s0_.category = ?)) LIMIT 5

[
  "Professionnel"
  "Particulier"
  "both"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.price AS price_2,
  s0_.description AS description_3,
  s0_.category AS category_4,
  s0_.created_at AS created_at_5,
  s0_.parent_id AS parent_id_6
FROM
  service_type s0_
  LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id
  AND (s1_.is_posted = 1)
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      field f2_
    WHERE
      f2_.service_id = s1_.id
  ) > 0
  AND (
    (
      s0_.category = ?
      OR s0_.category = ?
      OR s0_.category = ?
    )
  )
LIMIT
  5

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.description AS description_3, s0_.category AS category_4, s0_.created_at AS created_at_5, s0_.parent_id AS parent_id_6 FROM service_type s0_ LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id AND (s1_.is_posted = 1) WHERE (SELECT COUNT(*) FROM field f2_ WHERE f2_.service_id = s1_.id) > 0 AND ((s0_.category = 'Professionnel' OR s0_.category = 'Particulier' OR s0_.category = 'both')) LIMIT 5;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.document AS document_4, t0.delay AS delay_5, t0.fee AS fee_6, t0.is_posted AS is_posted_7, t0.is_document AS is_document_8, t0.created_at AS created_at_9, t0.api_url AS api_url_10, t0.api_key AS api_key_11, t0.service_type_id AS service_type_id_12 FROM services t0 WHERE t0.service_type_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.document AS document_4,
  t0.delay AS delay_5,
  t0.fee AS fee_6,
  t0.is_posted AS is_posted_7,
  t0.is_document AS is_document_8,
  t0.created_at AS created_at_9,
  t0.api_url AS api_url_10,
  t0.api_key AS api_key_11,
  t0.service_type_id AS service_type_id_12
FROM
  services t0
WHERE
  t0.service_type_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.document AS document_4, t0.delay AS delay_5, t0.fee AS fee_6, t0.is_posted AS is_posted_7, t0.is_document AS is_document_8, t0.created_at AS created_at_9, t0.api_url AS api_url_10, t0.api_key AS api_key_11, t0.service_type_id AS service_type_id_12 FROM services t0 WHERE t0.service_type_id = 1;

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.document AS document_4, t0.delay AS delay_5, t0.fee AS fee_6, t0.is_posted AS is_posted_7, t0.is_document AS is_document_8, t0.created_at AS created_at_9, t0.api_url AS api_url_10, t0.api_key AS api_key_11, t0.service_type_id AS service_type_id_12 FROM services t0 WHERE t0.service_type_id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.document AS document_4,
  t0.delay AS delay_5,
  t0.fee AS fee_6,
  t0.is_posted AS is_posted_7,
  t0.is_document AS is_document_8,
  t0.created_at AS created_at_9,
  t0.api_url AS api_url_10,
  t0.api_key AS api_key_11,
  t0.service_type_id AS service_type_id_12
FROM
  services t0
WHERE
  t0.service_type_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.document AS document_4, t0.delay AS delay_5, t0.fee AS fee_6, t0.is_posted AS is_posted_7, t0.is_document AS is_document_8, t0.created_at AS created_at_9, t0.api_url AS api_url_10, t0.api_key AS api_key_11, t0.service_type_id AS service_type_id_12 FROM services t0 WHERE t0.service_type_id = 3;