Symfony Profiler

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_
WHERE
  (
    p0_.featured_start_date <= ?
    AND p0_.featured_end_date >= ?
  )
  AND p0_.type IN (?, ?, ?, ?, ?)
ORDER BY
  p0_.created_at DESC

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_ WHERE (p0_.featured_start_date <= '2026-02-09 09:16:30' AND p0_.featured_end_date >= '2026-02-09 09:16:30') AND p0_.type IN ('article', 'project', 'showcase', 'resource', 'news') ORDER BY p0_.created_at DESC;

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 09:16:30' 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
  a0_.id AS id_0,
  a0_.link AS link_1,
  a0_.title AS title_2,
  a0_.start_date AS start_date_3,
  a0_.end_date AS end_date_4,
  a0_.sort AS sort_5,
  a0_.sponsor_id AS sponsor_id_6
FROM
  ad a0_
  INNER JOIN sponsor s1_ ON a0_.sponsor_id = s1_.id
WHERE
  (
    a0_.start_date <= ?
    AND a0_.end_date >= ?
  )
  AND (
    s1_.start_date <= ?
    AND (
      s1_.end_date >= ?
      OR s1_.end_date IS NULL
    )
  )
ORDER BY
  a0_.sort ASC

SELECT a0_.id AS id_0, a0_.link AS link_1, a0_.title AS title_2, a0_.start_date AS start_date_3, a0_.end_date AS end_date_4, a0_.sort AS sort_5, a0_.sponsor_id AS sponsor_id_6 FROM ad a0_ INNER JOIN sponsor s1_ ON a0_.sponsor_id = s1_.id WHERE (a0_.start_date <= '2026-02-09 09:16:30' AND a0_.end_date >= '2026-02-09 09:16:30') AND (s1_.start_date <= '2026-02-09 09:16:30' AND (s1_.end_date >= '2026-02-09 09:16:30' OR s1_.end_date IS NULL)) ORDER BY a0_.sort ASC;

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
  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 09:16:30' AND '2026-02-23 09:16:30' OR (e0_.is_recurring = true AND e0_.start_at <= '2026-02-23 09:16:30'))) 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
  COUNT(*)
FROM
  "user" t0
WHERE
  t0.banned = ?

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

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.url AS url_2,
  s0_.start_date AS start_date_3,
  s0_.end_date AS end_date_4,
  s0_.notes AS notes_5,
  s0_.logo AS logo_6,
  s0_.visible AS visible_7
FROM
  sponsor s0_
WHERE
  s0_.start_date <= ?
  AND (
    s0_.end_date >= ?
    OR s0_.end_date IS NULL
  )
  AND s0_.visible = true
ORDER BY
  s0_.start_date DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.url AS url_2, s0_.start_date AS start_date_3, s0_.end_date AS end_date_4, s0_.notes AS notes_5, s0_.logo AS logo_6, s0_.visible AS visible_7 FROM sponsor s0_ WHERE s0_.start_date <= '2026-02-09 09:16:30' AND (s0_.end_date >= '2026-02-09 09:16:30' OR s0_.end_date IS NULL) AND s0_.visible = true ORDER BY s0_.start_date DESC;

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
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        FROM
          post p0_
        WHERE
          (
            p0_.featured_start_date IS NULL
            AND p0_.featured_end_date IS NULL
          )
          AND p0_.type IN (?, ?, ?, ?, ?)
        ORDER BY
          p0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM post p0_ WHERE (p0_.featured_start_date IS NULL AND p0_.featured_end_date IS NULL) AND p0_.type IN ('article', 'project', 'showcase', 'resource', 'news') ORDER BY p0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  post p0_
WHERE
  (
    p0_.featured_start_date IS NULL
    AND p0_.featured_end_date IS NULL
  )
  AND p0_.type IN (?, ?, ?, ?, ?)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ WHERE (p0_.featured_start_date IS NULL AND p0_.featured_end_date IS NULL) AND p0_.type IN ('article', 'project', 'showcase', 'resource', 'news');

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_
WHERE
  (
    p0_.featured_start_date IS NULL
    AND p0_.featured_end_date IS NULL
  )
  AND p0_.type IN (?, ?, ?, ?, ?)
ORDER BY
  p0_.created_at DESC
LIMIT
  20

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_ WHERE (p0_.featured_start_date IS NULL AND p0_.featured_end_date IS NULL) AND p0_.type IN ('article', 'project', 'showcase', 'resource', 'news') ORDER BY p0_.created_at DESC LIMIT 20;