Symfony Profiler

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

Query Metrics

SELECT COUNT(l0_.id) AS sclr_0, SUM(CASE WHEN l0_.membre_id = ? THEN 1 ELSE 0 END) AS sclr_1, p1_.id AS id_2, p1_.content AS content_3, p1_.created_at AS created_at_4, p1_.is_brouillon AS is_brouillon_5, p1_.adresseip AS adresseip_6, p1_.is_statut AS is_statut_7, c2_.id AS id_8, c2_.nom AS nom_9, c2_.ordre AS ordre_10, c2_.photo AS photo_11, m3_.id AS id_12, m3_.email AS email_13, m3_.username AS username_14, m3_.roles AS roles_15, m3_.password AS password_16, m3_.biographie AS biographie_17, m3_.money AS money_18, m3_.created_at AS created_at_19, m3_.updated_at AS updated_at_20, m3_.last_activity AS last_activity_21, m3_.naissance AS naissance_22, m3_.is_verified AS is_verified_23, m3_.is_public AS is_public_24, m3_.ip AS ip_25, m3_.lastip AS lastip_26, l0_.id AS id_27, l0_.ip_vote AS ip_vote_28, l0_.is_active AS is_active_29, f4_.id AS id_30, f4_.filename AS filename_31, f4_.title AS title_32, f4_.type AS type_33, p1_.membre_id AS membre_id_34, p1_.categorie_id AS categorie_id_35, p1_.post_id AS post_id_36, m3_.parrain_id AS parrain_id_37, l0_.membre_id AS membre_id_38, l0_.post_id AS post_id_39, f4_.membre_id AS membre_id_40, f4_.post_id AS post_id_41 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 (p1_.post_id = 0 OR p1_.post_id IS NULL) AND p1_.is_statut = 1 GROUP BY p1_.id HAVING COUNT(l0_.id) >= 1 ORDER BY COUNT(l0_.id) DESC LIMIT 10

[
  null
]

SELECT
  COUNT(l0_.id) AS sclr_0,
  SUM(
    CASE WHEN l0_.membre_id = ? THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  p1_.id AS id_2,
  p1_.content AS content_3,
  p1_.created_at AS created_at_4,
  p1_.is_brouillon AS is_brouillon_5,
  p1_.adresseip AS adresseip_6,
  p1_.is_statut AS is_statut_7,
  c2_.id AS id_8,
  c2_.nom AS nom_9,
  c2_.ordre AS ordre_10,
  c2_.photo AS photo_11,
  m3_.id AS id_12,
  m3_.email AS email_13,
  m3_.username AS username_14,
  m3_.roles AS roles_15,
  m3_.password AS password_16,
  m3_.biographie AS biographie_17,
  m3_.money AS money_18,
  m3_.created_at AS created_at_19,
  m3_.updated_at AS updated_at_20,
  m3_.last_activity AS last_activity_21,
  m3_.naissance AS naissance_22,
  m3_.is_verified AS is_verified_23,
  m3_.is_public AS is_public_24,
  m3_.ip AS ip_25,
  m3_.lastip AS lastip_26,
  l0_.id AS id_27,
  l0_.ip_vote AS ip_vote_28,
  l0_.is_active AS is_active_29,
  f4_.id AS id_30,
  f4_.filename AS filename_31,
  f4_.title AS title_32,
  f4_.type AS type_33,
  p1_.membre_id AS membre_id_34,
  p1_.categorie_id AS categorie_id_35,
  p1_.post_id AS post_id_36,
  m3_.parrain_id AS parrain_id_37,
  l0_.membre_id AS membre_id_38,
  l0_.post_id AS post_id_39,
  f4_.membre_id AS membre_id_40,
  f4_.post_id AS post_id_41
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
  (
    p1_.post_id = 0
    OR p1_.post_id IS NULL
  )
  AND p1_.is_statut = 1
GROUP BY
  p1_.id
HAVING
  COUNT(l0_.id) >= 1
ORDER BY
  COUNT(l0_.id) DESC
LIMIT
  10

SELECT COUNT(l0_.id) AS sclr_0, SUM(CASE WHEN l0_.membre_id = NULL THEN 1 ELSE 0 END) AS sclr_1, p1_.id AS id_2, p1_.content AS content_3, p1_.created_at AS created_at_4, p1_.is_brouillon AS is_brouillon_5, p1_.adresseip AS adresseip_6, p1_.is_statut AS is_statut_7, c2_.id AS id_8, c2_.nom AS nom_9, c2_.ordre AS ordre_10, c2_.photo AS photo_11, m3_.id AS id_12, m3_.email AS email_13, m3_.username AS username_14, m3_.roles AS roles_15, m3_.password AS password_16, m3_.biographie AS biographie_17, m3_.money AS money_18, m3_.created_at AS created_at_19, m3_.updated_at AS updated_at_20, m3_.last_activity AS last_activity_21, m3_.naissance AS naissance_22, m3_.is_verified AS is_verified_23, m3_.is_public AS is_public_24, m3_.ip AS ip_25, m3_.lastip AS lastip_26, l0_.id AS id_27, l0_.ip_vote AS ip_vote_28, l0_.is_active AS is_active_29, f4_.id AS id_30, f4_.filename AS filename_31, f4_.title AS title_32, f4_.type AS type_33, p1_.membre_id AS membre_id_34, p1_.categorie_id AS categorie_id_35, p1_.post_id AS post_id_36, m3_.parrain_id AS parrain_id_37, l0_.membre_id AS membre_id_38, l0_.post_id AS post_id_39, f4_.membre_id AS membre_id_40, f4_.post_id AS post_id_41 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 (p1_.post_id = 0 OR p1_.post_id IS NULL) AND p1_.is_statut = 1 GROUP BY p1_.id HAVING COUNT(l0_.id) >= 1 ORDER BY COUNT(l0_.id) DESC LIMIT 10;

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