Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.description AS description_4,
  t0.category AS category_5,
  t0.created_at AS created_at_6,
  t0.parent_id AS parent_id_7
FROM
  service_type t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.category AS category_5, t0.created_at AS created_at_6, t0.parent_id AS parent_id_7 FROM service_type t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.image AS image_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.is_posted AS is_posted_7,
  t0.author_id AS author_id_8
FROM
  post t0
WHERE
  t0.is_posted = ?
ORDER BY
  t0.id DESC
LIMIT
  8

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.is_posted AS is_posted_7, t0.author_id AS author_id_8 FROM post t0 WHERE t0.is_posted = 1 ORDER BY t0.id DESC LIMIT 8;

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.description AS description_2,
  s0_.document AS document_3,
  s0_.delay AS delay_4,
  s0_.fee AS fee_5,
  s0_.is_posted AS is_posted_6,
  s0_.is_document AS is_document_7,
  s0_.created_at AS created_at_8,
  s0_.api_url AS api_url_9,
  s0_.api_key AS api_key_10,
  s0_.service_type_id AS service_type_id_11
FROM
  services s0_
  INNER JOIN service_type s1_ ON s0_.service_type_id = s1_.id
WHERE
  s1_.category = ?
  OR s1_.category = ?

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.document AS document_3, s0_.delay AS delay_4, s0_.fee AS fee_5, s0_.is_posted AS is_posted_6, s0_.is_document AS is_document_7, s0_.created_at AS created_at_8, s0_.api_url AS api_url_9, s0_.api_key AS api_key_10, s0_.service_type_id AS service_type_id_11 FROM services s0_ INNER JOIN service_type s1_ ON s0_.service_type_id = s1_.id WHERE s1_.category = 'Particulier' OR s1_.category = 'both';

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.description AS description_2,
  s0_.document AS document_3,
  s0_.delay AS delay_4,
  s0_.fee AS fee_5,
  s0_.is_posted AS is_posted_6,
  s0_.is_document AS is_document_7,
  s0_.created_at AS created_at_8,
  s0_.api_url AS api_url_9,
  s0_.api_key AS api_key_10,
  s0_.service_type_id AS service_type_id_11
FROM
  services s0_
  INNER JOIN service_type s1_ ON s0_.service_type_id = s1_.id
WHERE
  s1_.category = ?
  OR s1_.category = ?

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.document AS document_3, s0_.delay AS delay_4, s0_.fee AS fee_5, s0_.is_posted AS is_posted_6, s0_.is_document AS is_document_7, s0_.created_at AS created_at_8, s0_.api_url AS api_url_9, s0_.api_key AS api_key_10, s0_.service_type_id AS service_type_id_11 FROM services s0_ INNER JOIN service_type s1_ ON s0_.service_type_id = s1_.id WHERE s1_.category = 'Professionnel' OR s1_.category = '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

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,
  s1_.id AS id_6,
  s1_.title AS title_7,
  s1_.description AS description_8,
  s1_.document AS document_9,
  s1_.delay AS delay_10,
  s1_.fee AS fee_11,
  s1_.is_posted AS is_posted_12,
  s1_.is_document AS is_document_13,
  s1_.created_at AS created_at_14,
  s1_.api_url AS api_url_15,
  s1_.api_key AS api_key_16,
  s0_.parent_id AS parent_id_17,
  s1_.service_type_id AS service_type_id_18
FROM
  service_type s0_
  LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id
  AND (s1_.is_posted = 1)
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, s1_.id AS id_6, s1_.title AS title_7, s1_.description AS description_8, s1_.document AS document_9, s1_.delay AS delay_10, s1_.fee AS fee_11, s1_.is_posted AS is_posted_12, s1_.is_document AS is_document_13, s1_.created_at AS created_at_14, s1_.api_url AS api_url_15, s1_.api_key AS api_key_16, s0_.parent_id AS parent_id_17, s1_.service_type_id AS service_type_id_18 FROM service_type s0_ LEFT JOIN services s1_ ON s0_.id = s1_.service_type_id AND (s1_.is_posted = 1) 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 = ?
      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 = ?

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;