Symfony Profiler

SELECT
  COUNT(DISTINCT l0_.id) AS sclr_0,
  (
    SELECT
      COUNT(p1_.id) AS sclr_2
    FROM
      posts p1_
    WHERE
      p1_.post_id = p2_.id
  ) AS sclr_1,
  0 AS sclr_3,
  p2_.id AS id_4,
  p2_.content AS content_5,
  p2_.created_at AS created_at_6,
  p2_.is_brouillon AS is_brouillon_7,
  p2_.adresseip AS adresseip_8,
  p2_.is_statut AS is_statut_9,
  c3_.id AS id_10,
  c3_.nom AS nom_11,
  c3_.ordre AS ordre_12,
  c3_.photo AS photo_13,
  m4_.id AS id_14,
  m4_.email AS email_15,
  m4_.username AS username_16,
  m4_.roles AS roles_17,
  m4_.password AS password_18,
  m4_.biographie AS biographie_19,
  m4_.money AS money_20,
  m4_.created_at AS created_at_21,
  m4_.updated_at AS updated_at_22,
  m4_.last_activity AS last_activity_23,
  m4_.naissance AS naissance_24,
  m4_.is_verified AS is_verified_25,
  m4_.is_public AS is_public_26,
  m4_.ip AS ip_27,
  m4_.lastip AS lastip_28,
  l0_.id AS id_29,
  l0_.ip_vote AS ip_vote_30,
  l0_.is_active AS is_active_31,
  f5_.id AS id_32,
  f5_.filename AS filename_33,
  f5_.title AS title_34,
  f5_.type AS type_35,
  p2_.membre_id AS membre_id_36,
  p2_.categorie_id AS categorie_id_37,
  p2_.post_id AS post_id_38,
  m4_.parrain_id AS parrain_id_39,
  l0_.membre_id AS membre_id_40,
  l0_.post_id AS post_id_41,
  f5_.membre_id AS membre_id_42,
  f5_.post_id AS post_id_43
FROM
  posts p2_
  INNER JOIN categories c3_ ON p2_.categorie_id = c3_.id
  INNER JOIN membres m4_ ON p2_.membre_id = m4_.id
  LEFT JOIN likes l0_ ON p2_.id = l0_.post_id
  LEFT JOIN files f5_ ON p2_.id = f5_.post_id
WHERE
  p2_.id = ?
  AND (
    p2_.post_id = 0
    OR p2_.post_id IS NULL
  )
  AND p2_.is_statut = 1
GROUP BY
  p2_.id

SELECT COUNT(DISTINCT l0_.id) AS sclr_0, (SELECT COUNT(p1_.id) AS sclr_2 FROM posts p1_ WHERE p1_.post_id = p2_.id) AS sclr_1, 0 AS sclr_3, p2_.id AS id_4, p2_.content AS content_5, p2_.created_at AS created_at_6, p2_.is_brouillon AS is_brouillon_7, p2_.adresseip AS adresseip_8, p2_.is_statut AS is_statut_9, c3_.id AS id_10, c3_.nom AS nom_11, c3_.ordre AS ordre_12, c3_.photo AS photo_13, m4_.id AS id_14, m4_.email AS email_15, m4_.username AS username_16, m4_.roles AS roles_17, m4_.password AS password_18, m4_.biographie AS biographie_19, m4_.money AS money_20, m4_.created_at AS created_at_21, m4_.updated_at AS updated_at_22, m4_.last_activity AS last_activity_23, m4_.naissance AS naissance_24, m4_.is_verified AS is_verified_25, m4_.is_public AS is_public_26, m4_.ip AS ip_27, m4_.lastip AS lastip_28, l0_.id AS id_29, l0_.ip_vote AS ip_vote_30, l0_.is_active AS is_active_31, f5_.id AS id_32, f5_.filename AS filename_33, f5_.title AS title_34, f5_.type AS type_35, p2_.membre_id AS membre_id_36, p2_.categorie_id AS categorie_id_37, p2_.post_id AS post_id_38, m4_.parrain_id AS parrain_id_39, l0_.membre_id AS membre_id_40, l0_.post_id AS post_id_41, f5_.membre_id AS membre_id_42, f5_.post_id AS post_id_43 FROM posts p2_ INNER JOIN categories c3_ ON p2_.categorie_id = c3_.id INNER JOIN membres m4_ ON p2_.membre_id = m4_.id LEFT JOIN likes l0_ ON p2_.id = l0_.post_id LEFT JOIN files f5_ ON p2_.id = f5_.post_id WHERE p2_.id = 3200 AND (p2_.post_id = 0 OR p2_.post_id IS NULL) AND p2_.is_statut = 1 GROUP BY p2_.id;

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 = 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.membre_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.membre_id = 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.created_at AS created_at_3,
  t0.last_follow AS last_follow_4,
  t0.last_un_follow AS last_un_follow_5,
  t0.de_id AS de_id_6,
  t0.vers_id AS vers_id_7
FROM
  friends t0
WHERE
  t0.de_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.last_follow AS last_follow_4, t0.last_un_follow AS last_un_follow_5, t0.de_id AS de_id_6, t0.vers_id AS vers_id_7 FROM friends t0 WHERE t0.de_id = 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.created_at AS created_at_3,
  t0.last_follow AS last_follow_4,
  t0.last_un_follow AS last_un_follow_5,
  t0.de_id AS de_id_6,
  t0.vers_id AS vers_id_7
FROM
  friends t0
WHERE
  t0.vers_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.last_follow AS last_follow_4, t0.last_un_follow AS last_un_follow_5, t0.de_id AS de_id_6, t0.vers_id AS vers_id_7 FROM friends t0 WHERE t0.vers_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 = 3200;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.biographie AS biographie_6,
  t0.money AS money_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.last_activity AS last_activity_10,
  t0.naissance AS naissance_11,
  t0.is_verified AS is_verified_12,
  t0.is_public AS is_public_13,
  t0.ip AS ip_14,
  t0.lastip AS lastip_15,
  t0.parrain_id AS parrain_id_16
FROM
  membres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.biographie AS biographie_6, t0.money AS money_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.last_activity AS last_activity_10, t0.naissance AS naissance_11, t0.is_verified AS is_verified_12, t0.is_public AS is_public_13, t0.ip AS ip_14, t0.lastip AS lastip_15, t0.parrain_id AS parrain_id_16 FROM membres t0 WHERE t0.id = 447;

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 = 447;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.biographie AS biographie_6,
  t0.money AS money_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.last_activity AS last_activity_10,
  t0.naissance AS naissance_11,
  t0.is_verified AS is_verified_12,
  t0.is_public AS is_public_13,
  t0.ip AS ip_14,
  t0.lastip AS lastip_15,
  t0.parrain_id AS parrain_id_16
FROM
  membres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.biographie AS biographie_6, t0.money AS money_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.last_activity AS last_activity_10, t0.naissance AS naissance_11, t0.is_verified AS is_verified_12, t0.is_public AS is_public_13, t0.ip AS ip_14, t0.lastip AS lastip_15, t0.parrain_id AS parrain_id_16 FROM membres t0 WHERE t0.id = 417;

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 = 417;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.biographie AS biographie_6,
  t0.money AS money_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.last_activity AS last_activity_10,
  t0.naissance AS naissance_11,
  t0.is_verified AS is_verified_12,
  t0.is_public AS is_public_13,
  t0.ip AS ip_14,
  t0.lastip AS lastip_15,
  t0.parrain_id AS parrain_id_16
FROM
  membres t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.biographie AS biographie_6, t0.money AS money_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.last_activity AS last_activity_10, t0.naissance AS naissance_11, t0.is_verified AS is_verified_12, t0.is_public AS is_public_13, t0.ip AS ip_14, t0.lastip AS lastip_15, t0.parrain_id AS parrain_id_16 FROM membres t0 WHERE t0.id = 458;

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 = 458;