Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.domain AS domain_4,
  t0.created_at AS created_at_5,
  t0.normalized_url AS normalized_url_6,
  t0.description AS description_7,
  t0.domain_is_personal AS domain_is_personal_8,
  t0.original_author_name AS original_author_name_9,
  t0.type AS type_10,
  t0.featured_start_date AS featured_start_date_11,
  t0.featured_end_date AS featured_end_date_12,
  t0.publisher_metadata AS publisher_metadata_13,
  t0.author_id AS author_id_14
FROM
  post t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.domain AS domain_4, t0.created_at AS created_at_5, t0.normalized_url AS normalized_url_6, t0.description AS description_7, t0.domain_is_personal AS domain_is_personal_8, t0.original_author_name AS original_author_name_9, t0.type AS type_10, t0.featured_start_date AS featured_start_date_11, t0.featured_end_date AS featured_end_date_12, t0.publisher_metadata AS publisher_metadata_13, t0.author_id AS author_id_14 FROM post t0 WHERE t0.id = '1';

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.url AS url_2,
  p0_.domain AS domain_3,
  p0_.created_at AS created_at_4,
  p0_.normalized_url AS normalized_url_5,
  p0_.description AS description_6,
  p0_.domain_is_personal AS domain_is_personal_7,
  p0_.original_author_name AS original_author_name_8,
  p0_.type AS type_9,
  p0_.featured_start_date AS featured_start_date_10,
  p0_.featured_end_date AS featured_end_date_11,
  p0_.publisher_metadata AS publisher_metadata_12,
  p0_.author_id AS author_id_13
FROM
  post p0_
  LEFT JOIN post_vote p1_ ON p0_.id = p1_.post_id
  LEFT JOIN comment c2_ ON p0_.id = c2_.post_id
WHERE
  (
    p0_.created_at > ?
    AND c2_.visible = true
  )
  AND p0_.type IN (?, ?, ?, ?, ?)
GROUP BY
  p0_.id
ORDER BY
  COUNT(c2_.id) DESC,
  COUNT(p1_.id) DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.url AS url_2, p0_.domain AS domain_3, p0_.created_at AS created_at_4, p0_.normalized_url AS normalized_url_5, p0_.description AS description_6, p0_.domain_is_personal AS domain_is_personal_7, p0_.original_author_name AS original_author_name_8, p0_.type AS type_9, p0_.featured_start_date AS featured_start_date_10, p0_.featured_end_date AS featured_end_date_11, p0_.publisher_metadata AS publisher_metadata_12, p0_.author_id AS author_id_13 FROM post p0_ LEFT JOIN post_vote p1_ ON p0_.id = p1_.post_id LEFT JOIN comment c2_ ON p0_.id = c2_.post_id WHERE (p0_.created_at > '2026-01-10 10:29:43' AND c2_.visible = true) AND p0_.type IN ('article', 'project', 'showcase', 'resource', 'news') GROUP BY p0_.id ORDER BY COUNT(c2_.id) DESC, COUNT(p1_.id) DESC LIMIT 5;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.description AS description_2,
  e0_.location AS location_3,
  e0_.start_at AS start_at_4,
  e0_.end_at AS end_at_5,
  e0_.is_recurring AS is_recurring_6,
  e0_.recurrence AS recurrence_7,
  e0_.repeat_interval AS repeat_interval_8,
  e0_.repeat_until AS repeat_until_9,
  e0_.repeat_by_day AS repeat_by_day_10,
  e0_.created_at AS created_at_11,
  e0_.updated_at AS updated_at_12,
  e0_.type AS type_13,
  e0_.registration_limit AS registration_limit_14,
  e0_.is_active AS is_active_15,
  e0_.details AS details_16,
  e0_.uuid AS uuid_17,
  e0_.organizer_id AS organizer_id_18
FROM
  event e0_
WHERE
  (
    (
      e0_.start_at BETWEEN ?
      AND ?
      OR (
        e0_.is_recurring = true
        AND e0_.start_at <= ?
      )
    )
  )
  AND e0_.is_active = true
ORDER BY
  e0_.start_at ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.location AS location_3, e0_.start_at AS start_at_4, e0_.end_at AS end_at_5, e0_.is_recurring AS is_recurring_6, e0_.recurrence AS recurrence_7, e0_.repeat_interval AS repeat_interval_8, e0_.repeat_until AS repeat_until_9, e0_.repeat_by_day AS repeat_by_day_10, e0_.created_at AS created_at_11, e0_.updated_at AS updated_at_12, e0_.type AS type_13, e0_.registration_limit AS registration_limit_14, e0_.is_active AS is_active_15, e0_.details AS details_16, e0_.uuid AS uuid_17, e0_.organizer_id AS organizer_id_18 FROM event e0_ WHERE ((e0_.start_at BETWEEN '2026-02-09 10:29:43' AND '2026-02-23 10:29:43' OR (e0_.is_recurring = true AND e0_.start_at <= '2026-02-23 10:29:43'))) AND e0_.is_active = true ORDER BY e0_.start_at ASC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.visible AS visible_4,
  t0.moderation_reason AS moderation_reason_5,
  t0.moderated_at AS moderated_at_6,
  t0.author_id AS author_id_7,
  t0.post_id AS post_id_8,
  t0.moderated_by_id AS moderated_by_id_9,
  t0.parent_id AS parent_id_10
FROM
  comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.visible AS visible_4, t0.moderation_reason AS moderation_reason_5, t0.moderated_at AS moderated_at_6, t0.author_id AS author_id_7, t0.post_id AS post_id_8, t0.moderated_by_id AS moderated_by_id_9, t0.parent_id AS parent_id_10 FROM comment t0 WHERE t0.post_id = 1 ORDER BY t0.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.avatar_url AS avatar_url_5,
  t0.header_photo_url AS header_photo_url_6,
  t0.banned AS banned_7,
  t0.banned_at AS banned_at_8,
  t0.ban_reason AS ban_reason_9,
  t0.joined_at AS joined_at_10,
  t0.display_name AS display_name_11,
  t0.receive_comment_email_notification AS receive_comment_email_notification_12,
  t0.receive_upvote_email_notification AS receive_upvote_email_notification_13,
  t0.receive_comment_reply_email_notification AS receive_comment_reply_email_notification_14,
  t0.username AS username_15,
  t0.api_token_limit AS api_token_limit_16,
  t0.about AS about_17,
  t0.social_link1 AS social_link1_18,
  t0.social_link2 AS social_link2_19,
  t0.social_link3 AS social_link3_20,
  t0.theme AS theme_21,
  t0.account_type AS account_type_22,
  t0.onboarding_done AS onboarding_done_23,
  t0.bio AS bio_24,
  t0.location AS location_25,
  t0.email_verified AS email_verified_26,
  t0.receive_event_user_joined_email_notification AS receive_event_user_joined_email_notification_27,
  t0.receive_event_start_reminder_email_notification AS receive_event_start_reminder_email_notification_28,
  t0.receive_event_user_comment_email_notification AS receive_event_user_comment_email_notification_29,
  t0.banned_by_id AS banned_by_id_30
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.avatar_url AS avatar_url_5, t0.header_photo_url AS header_photo_url_6, t0.banned AS banned_7, t0.banned_at AS banned_at_8, t0.ban_reason AS ban_reason_9, t0.joined_at AS joined_at_10, t0.display_name AS display_name_11, t0.receive_comment_email_notification AS receive_comment_email_notification_12, t0.receive_upvote_email_notification AS receive_upvote_email_notification_13, t0.receive_comment_reply_email_notification AS receive_comment_reply_email_notification_14, t0.username AS username_15, t0.api_token_limit AS api_token_limit_16, t0.about AS about_17, t0.social_link1 AS social_link1_18, t0.social_link2 AS social_link2_19, t0.social_link3 AS social_link3_20, t0.theme AS theme_21, t0.account_type AS account_type_22, t0.onboarding_done AS onboarding_done_23, t0.bio AS bio_24, t0.location AS location_25, t0.email_verified AS email_verified_26, t0.receive_event_user_joined_email_notification AS receive_event_user_joined_email_notification_27, t0.receive_event_start_reminder_email_notification AS receive_event_start_reminder_email_notification_28, t0.receive_event_user_comment_email_notification AS receive_event_user_comment_email_notification_29, t0.banned_by_id AS banned_by_id_30 FROM "user" t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.user_id AS user_id_3,
  t0.post_id AS post_id_4
FROM
  post_vote t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.post_id AS post_id_4 FROM post_vote t0 WHERE t0.post_id = 1;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.visible AS visible_4,
  t0.moderation_reason AS moderation_reason_5,
  t0.moderated_at AS moderated_at_6,
  t0.author_id AS author_id_7,
  t0.post_id AS post_id_8,
  t0.moderated_by_id AS moderated_by_id_9,
  t0.parent_id AS parent_id_10
FROM
  comment t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.visible AS visible_4, t0.moderation_reason AS moderation_reason_5, t0.moderated_at AS moderated_at_6, t0.author_id AS author_id_7, t0.post_id AS post_id_8, t0.moderated_by_id AS moderated_by_id_9, t0.parent_id AS parent_id_10 FROM comment t0 WHERE t0.parent_id = 1 ORDER BY t0.created_at ASC;

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.created_at AS created_at_3,
  t0.visible AS visible_4,
  t0.moderation_reason AS moderation_reason_5,
  t0.moderated_at AS moderated_at_6,
  t0.author_id AS author_id_7,
  t0.post_id AS post_id_8,
  t0.moderated_by_id AS moderated_by_id_9,
  t0.parent_id AS parent_id_10
FROM
  comment t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.id AS id_1, t0.content AS content_2, t0.created_at AS created_at_3, t0.visible AS visible_4, t0.moderation_reason AS moderation_reason_5, t0.moderated_at AS moderated_at_6, t0.author_id AS author_id_7, t0.post_id AS post_id_8, t0.moderated_by_id AS moderated_by_id_9, t0.parent_id AS parent_id_10 FROM comment t0 WHERE t0.parent_id = 2 ORDER BY t0.created_at ASC;

SELECT
  COUNT(*)
FROM
  "user" t0
WHERE
  t0.banned = ?

SELECT COUNT(*) FROM "user" t0 WHERE t0.banned = 0;