Symfony Profiler

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  posts p0_
  INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN membres m2_ ON p0_.membre_id = m2_.id
  LEFT JOIN likes l3_ ON p0_.id = l3_.post_id
  LEFT JOIN files f4_ ON p0_.id = f4_.post_id
WHERE
  m2_.is_public = ?
  AND (
    p0_.post_id = 0
    OR p0_.post_id IS NULL
  )
  AND p0_.is_statut = 1
GROUP BY
  p0_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM posts p0_ INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id INNER JOIN membres m2_ ON p0_.membre_id = m2_.id LEFT JOIN likes l3_ ON p0_.id = l3_.post_id LEFT JOIN files f4_ ON p0_.id = f4_.post_id WHERE m2_.is_public = 1 AND (p0_.post_id = 0 OR p0_.post_id IS NULL) AND p0_.is_statut = 1 GROUP BY p0_.id;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1
FROM
  posts p0_
  INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id
  INNER JOIN membres m2_ ON p0_.membre_id = m2_.id
  LEFT JOIN likes l3_ ON p0_.id = l3_.post_id
  LEFT JOIN files f4_ ON p0_.id = f4_.post_id
WHERE
  m2_.is_public = ?
  AND (
    p0_.post_id = 0
    OR p0_.post_id IS NULL
  )
  AND p0_.is_statut = 1
GROUP BY
  p0_.id
ORDER BY
  p0_.created_at DESC
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1 FROM posts p0_ INNER JOIN categories c1_ ON p0_.categorie_id = c1_.id INNER JOIN membres m2_ ON p0_.membre_id = m2_.id LEFT JOIN likes l3_ ON p0_.id = l3_.post_id LEFT JOIN files f4_ ON p0_.id = f4_.post_id WHERE m2_.is_public = 1 AND (p0_.post_id = 0 OR p0_.post_id IS NULL) AND p0_.is_statut = 1 GROUP BY p0_.id ORDER BY p0_.created_at DESC LIMIT 10;

SELECT
  COUNT(l0_.id) AS sclr_0,
  p1_.id AS id_1,
  p1_.content AS content_2,
  p1_.created_at AS created_at_3,
  p1_.is_brouillon AS is_brouillon_4,
  p1_.adresseip AS adresseip_5,
  p1_.is_statut AS is_statut_6,
  c2_.id AS id_7,
  c2_.nom AS nom_8,
  c2_.ordre AS ordre_9,
  c2_.photo AS photo_10,
  m3_.id AS id_11,
  m3_.email AS email_12,
  m3_.username AS username_13,
  m3_.roles AS roles_14,
  m3_.password AS password_15,
  m3_.biographie AS biographie_16,
  m3_.money AS money_17,
  m3_.created_at AS created_at_18,
  m3_.updated_at AS updated_at_19,
  m3_.last_activity AS last_activity_20,
  m3_.naissance AS naissance_21,
  m3_.is_verified AS is_verified_22,
  m3_.is_public AS is_public_23,
  m3_.ip AS ip_24,
  m3_.lastip AS lastip_25,
  l0_.id AS id_26,
  l0_.ip_vote AS ip_vote_27,
  l0_.is_active AS is_active_28,
  f4_.id AS id_29,
  f4_.filename AS filename_30,
  f4_.title AS title_31,
  f4_.type AS type_32,
  p1_.membre_id AS membre_id_33,
  p1_.categorie_id AS categorie_id_34,
  p1_.post_id AS post_id_35,
  m3_.parrain_id AS parrain_id_36,
  l0_.membre_id AS membre_id_37,
  l0_.post_id AS post_id_38,
  f4_.membre_id AS membre_id_39,
  f4_.post_id AS post_id_40
FROM
  posts p1_
  INNER JOIN categories c2_ ON p1_.categorie_id = c2_.id
  INNER JOIN membres m3_ ON p1_.membre_id = m3_.id
  LEFT JOIN likes l0_ ON p1_.id = l0_.post_id
  LEFT JOIN files f4_ ON p1_.id = f4_.post_id
WHERE
  m3_.is_public = ?
  AND (
    p1_.post_id = 0
    OR p1_.post_id IS NULL
  )
  AND p1_.is_statut = 1
  AND p1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  p1_.id
ORDER BY
  p1_.created_at DESC

SELECT COUNT(l0_.id) AS sclr_0, p1_.id AS id_1, p1_.content AS content_2, p1_.created_at AS created_at_3, p1_.is_brouillon AS is_brouillon_4, p1_.adresseip AS adresseip_5, p1_.is_statut AS is_statut_6, c2_.id AS id_7, c2_.nom AS nom_8, c2_.ordre AS ordre_9, c2_.photo AS photo_10, m3_.id AS id_11, m3_.email AS email_12, m3_.username AS username_13, m3_.roles AS roles_14, m3_.password AS password_15, m3_.biographie AS biographie_16, m3_.money AS money_17, m3_.created_at AS created_at_18, m3_.updated_at AS updated_at_19, m3_.last_activity AS last_activity_20, m3_.naissance AS naissance_21, m3_.is_verified AS is_verified_22, m3_.is_public AS is_public_23, m3_.ip AS ip_24, m3_.lastip AS lastip_25, l0_.id AS id_26, l0_.ip_vote AS ip_vote_27, l0_.is_active AS is_active_28, f4_.id AS id_29, f4_.filename AS filename_30, f4_.title AS title_31, f4_.type AS type_32, p1_.membre_id AS membre_id_33, p1_.categorie_id AS categorie_id_34, p1_.post_id AS post_id_35, m3_.parrain_id AS parrain_id_36, l0_.membre_id AS membre_id_37, l0_.post_id AS post_id_38, f4_.membre_id AS membre_id_39, f4_.post_id AS post_id_40 FROM posts p1_ INNER JOIN categories c2_ ON p1_.categorie_id = c2_.id INNER JOIN membres m3_ ON p1_.membre_id = m3_.id LEFT JOIN likes l0_ ON p1_.id = l0_.post_id LEFT JOIN files f4_ ON p1_.id = f4_.post_id WHERE m3_.is_public = 1 AND (p1_.post_id = 0 OR p1_.post_id IS NULL) AND p1_.is_statut = 1 AND p1_.id IN (3404, 3403, 3402, 3401, 3400, 3399, 3398, 3397, 3395, 3393) GROUP BY p1_.id ORDER BY p1_.created_at DESC;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.ordre AS ordre_2,
  c0_.photo AS photo_3
FROM
  categories c0_
ORDER BY
  c0_.nom ASC

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.ordre AS ordre_2, c0_.photo AS photo_3 FROM categories c0_ ORDER BY c0_.nom ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.title AS title_3,
  t0.type AS type_4,
  t0.membre_id AS membre_id_5,
  t0.post_id AS post_id_6
FROM
  files t0
WHERE
  t0.membre_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.title AS title_3, t0.type AS type_4, t0.membre_id AS membre_id_5, t0.post_id AS post_id_6 FROM files t0 WHERE t0.membre_id = 292;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_brouillon AS is_brouillon_4,
  t0.adresseip AS adresseip_5,
  t0.is_statut AS is_statut_6,
  t0.membre_id AS membre_id_7,
  t0.categorie_id AS categorie_id_8,
  t0.post_id AS post_id_9
FROM
  posts t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_brouillon AS is_brouillon_4, t0.adresseip AS adresseip_5, t0.is_statut AS is_statut_6, t0.membre_id AS membre_id_7, t0.categorie_id AS categorie_id_8, t0.post_id AS post_id_9 FROM posts t0 WHERE t0.post_id = 3404;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_brouillon AS is_brouillon_4,
  t0.adresseip AS adresseip_5,
  t0.is_statut AS is_statut_6,
  t0.membre_id AS membre_id_7,
  t0.categorie_id AS categorie_id_8,
  t0.post_id AS post_id_9
FROM
  posts t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_brouillon AS is_brouillon_4, t0.adresseip AS adresseip_5, t0.is_statut AS is_statut_6, t0.membre_id AS membre_id_7, t0.categorie_id AS categorie_id_8, t0.post_id AS post_id_9 FROM posts t0 WHERE t0.post_id = 3403;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.title AS title_3,
  t0.type AS type_4,
  t0.membre_id AS membre_id_5,
  t0.post_id AS post_id_6
FROM
  files t0
WHERE
  t0.membre_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.title AS title_3, t0.type AS type_4, t0.membre_id AS membre_id_5, t0.post_id AS post_id_6 FROM files t0 WHERE t0.membre_id = 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_brouillon AS is_brouillon_4,
  t0.adresseip AS adresseip_5,
  t0.is_statut AS is_statut_6,
  t0.membre_id AS membre_id_7,
  t0.categorie_id AS categorie_id_8,
  t0.post_id AS post_id_9
FROM
  posts t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_brouillon AS is_brouillon_4, t0.adresseip AS adresseip_5, t0.is_statut AS is_statut_6, t0.membre_id AS membre_id_7, t0.categorie_id AS categorie_id_8, t0.post_id AS post_id_9 FROM posts t0 WHERE t0.post_id = 3402;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.title AS title_3,
  t0.type AS type_4,
  t0.membre_id AS membre_id_5,
  t0.post_id AS post_id_6
FROM
  files t0
WHERE
  t0.membre_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.title AS title_3, t0.type AS type_4, t0.membre_id AS membre_id_5, t0.post_id AS post_id_6 FROM files t0 WHERE t0.membre_id = 567;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_brouillon AS is_brouillon_4,
  t0.adresseip AS adresseip_5,
  t0.is_statut AS is_statut_6,
  t0.membre_id AS membre_id_7,
  t0.categorie_id AS categorie_id_8,
  t0.post_id AS post_id_9
FROM
  posts t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_brouillon AS is_brouillon_4, t0.adresseip AS adresseip_5, t0.is_statut AS is_statut_6, t0.membre_id AS membre_id_7, t0.categorie_id AS categorie_id_8, t0.post_id AS post_id_9 FROM posts t0 WHERE t0.post_id = 3401;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.title AS title_3,
  t0.type AS type_4,
  t0.membre_id AS membre_id_5,
  t0.post_id AS post_id_6
FROM
  files t0
WHERE
  t0.membre_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.title AS title_3, t0.type AS type_4, t0.membre_id AS membre_id_5, t0.post_id AS post_id_6 FROM files t0 WHERE t0.membre_id = 501;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_brouillon AS is_brouillon_4,
  t0.adresseip AS adresseip_5,
  t0.is_statut AS is_statut_6,
  t0.membre_id AS membre_id_7,
  t0.categorie_id AS categorie_id_8,
  t0.post_id AS post_id_9
FROM
  posts t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_brouillon AS is_brouillon_4, t0.adresseip AS adresseip_5, t0.is_statut AS is_statut_6, t0.membre_id AS membre_id_7, t0.categorie_id AS categorie_id_8, t0.post_id AS post_id_9 FROM posts t0 WHERE t0.post_id = 3400;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_brouillon AS is_brouillon_4,
  t0.adresseip AS adresseip_5,
  t0.is_statut AS is_statut_6,
  t0.membre_id AS membre_id_7,
  t0.categorie_id AS categorie_id_8,
  t0.post_id AS post_id_9
FROM
  posts t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_brouillon AS is_brouillon_4, t0.adresseip AS adresseip_5, t0.is_statut AS is_statut_6, t0.membre_id AS membre_id_7, t0.categorie_id AS categorie_id_8, t0.post_id AS post_id_9 FROM posts t0 WHERE t0.post_id = 3399;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.title AS title_3,
  t0.type AS type_4,
  t0.membre_id AS membre_id_5,
  t0.post_id AS post_id_6
FROM
  files t0
WHERE
  t0.membre_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.title AS title_3, t0.type AS type_4, t0.membre_id AS membre_id_5, t0.post_id AS post_id_6 FROM files t0 WHERE t0.membre_id = 564;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.is_brouillon AS is_brouillon_4,
  t0.adresseip AS adresseip_5,
  t0.is_statut AS is_statut_6,
  t0.membre_id AS membre_id_7,
  t0.categorie_id AS categorie_id_8,
  t0.post_id AS post_id_9
FROM
  posts t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.is_brouillon AS is_brouillon_4, t0.adresseip AS adresseip_5, t0.is_statut AS is_statut_6, t0.membre_id AS membre_id_7, t0.categorie_id AS categorie_id_8, t0.post_id AS post_id_9 FROM posts t0 WHERE t0.post_id = 3398;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.title AS title_3,
  t0.type AS type_4,
  t0.membre_id AS membre_id_5,
  t0.post_id AS post_id_6
FROM
  files t0
WHERE
  t0.membre_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.title AS title_3, t0.type AS type_4, t0.membre_id AS membre_id_5, t0.post_id AS post_id_6 FROM files t0 WHERE t0.membre_id = 563;