Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.url AS url_2,
  s0_.body AS body_3,
  s0_.media_type AS media_type_4,
  s0_.comment_count AS comment_count_5,
  s0_.timestamp AS timestamp_6,
  s0_.last_active AS last_active_7,
  s0_.visibility AS visibility_8,
  s0_.image_alt_text AS image_alt_text_9,
  s0_.ip AS ip_10,
  s0_.sticky AS sticky_11,
  s0_.ranking AS ranking_12,
  s0_.edited_at AS edited_at_13,
  s0_.moderated AS moderated_14,
  s0_.user_flag AS user_flag_15,
  s0_.locked AS locked_16,
  s0_.net_score AS net_score_17,
  s0_.search_doc AS search_doc_18,
  s0_.forum_id AS forum_id_19,
  s0_.user_id AS user_id_20,
  s0_.image_id AS image_id_21
FROM
  submissions s0_
WHERE
  s0_.visibility = ?
  AND s0_.timestamp > ?
  AND s0_.forum_id IN (
    SELECT
      f1_.id
    FROM
      forums f1_
    WHERE
      f1_.featured = TRUE
  )
ORDER BY
  s0_.net_score DESC,
  s0_.id DESC
LIMIT
  26

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.url AS url_2, s0_.body AS body_3, s0_.media_type AS media_type_4, s0_.comment_count AS comment_count_5, s0_.timestamp AS timestamp_6, s0_.last_active AS last_active_7, s0_.visibility AS visibility_8, s0_.image_alt_text AS image_alt_text_9, s0_.ip AS ip_10, s0_.sticky AS sticky_11, s0_.ranking AS ranking_12, s0_.edited_at AS edited_at_13, s0_.moderated AS moderated_14, s0_.user_flag AS user_flag_15, s0_.locked AS locked_16, s0_.net_score AS net_score_17, s0_.search_doc AS search_doc_18, s0_.forum_id AS forum_id_19, s0_.user_id AS user_id_20, s0_.image_id AS image_id_21 FROM submissions s0_ WHERE s0_.visibility = 'visible' AND s0_.timestamp > '2026-09-05 03:46:31+0000' AND s0_.forum_id IN (SELECT f1_.id FROM forums f1_ WHERE f1_.featured = TRUE) ORDER BY s0_.net_score DESC, s0_.id DESC LIMIT 26;

SELECT
  s0_.id AS id_0,
  u1_.id AS id_1,
  u1_.username AS username_2,
  u1_.normalized_username AS normalized_username_3,
  u1_.password AS password_4,
  u1_.email AS email_5,
  u1_.normalized_email AS normalized_email_6,
  u1_.created AS created_7,
  u1_.last_seen AS last_seen_8,
  u1_.registration_ip AS registration_ip_9,
  u1_.admin AS admin_10,
  u1_.locale AS locale_11,
  u1_.timezone AS timezone_12,
  u1_.night_mode AS night_mode_13,
  u1_.show_custom_stylesheets AS show_custom_stylesheets_14,
  u1_.trusted AS trusted_15,
  u1_.front_page AS front_page_16,
  u1_.front_page_sort_mode AS front_page_sort_mode_17,
  u1_.open_external_links_in_new_tab AS open_external_links_in_new_tab_18,
  u1_.biography AS biography_19,
  u1_.auto_fetch_submission_titles AS auto_fetch_submission_titles_20,
  u1_.enable_post_previews AS enable_post_previews_21,
  u1_.show_thumbnails AS show_thumbnails_22,
  u1_.allow_private_messages AS allow_private_messages_23,
  u1_.notify_on_reply AS notify_on_reply_24,
  u1_.notify_on_mentions AS notify_on_mentions_25,
  u1_.poppers_enabled AS poppers_enabled_26,
  u1_.preferred_fonts AS preferred_fonts_27,
  u1_.full_width_display_enabled AS full_width_display_enabled_28,
  u1_.submission_link_destination AS submission_link_destination_29,
  u1_.background_alpha AS background_alpha_30,
  f2_.id AS id_31,
  f2_.name AS name_32,
  f2_.normalized_name AS normalized_name_33,
  f2_.title AS title_34,
  f2_.description AS description_35,
  f2_.sidebar AS sidebar_36,
  f2_.created AS created_37,
  f2_.featured AS featured_38,
  f2_.moderation_log_public AS moderation_log_public_39,
  f2_.background_image_mode AS background_image_mode_40,
  f2_.voting_enabled AS voting_enabled_41,
  s0_.forum_id AS forum_id_42,
  s0_.user_id AS user_id_43,
  s0_.image_id AS image_id_44,
  u1_.preferred_theme_id AS preferred_theme_id_45,
  f2_.light_background_image_id AS light_background_image_id_46,
  f2_.dark_background_image_id AS dark_background_image_id_47,
  f2_.suggested_theme_id AS suggested_theme_id_48
FROM
  submissions s0_
  INNER JOIN users u1_ ON s0_.user_id = u1_.id
  INNER JOIN forums f2_ ON s0_.forum_id = f2_.id
WHERE
  s0_.id IN (NULL)

SELECT s0_.id AS id_0, u1_.id AS id_1, u1_.username AS username_2, u1_.normalized_username AS normalized_username_3, u1_.password AS password_4, u1_.email AS email_5, u1_.normalized_email AS normalized_email_6, u1_.created AS created_7, u1_.last_seen AS last_seen_8, u1_.registration_ip AS registration_ip_9, u1_.admin AS admin_10, u1_.locale AS locale_11, u1_.timezone AS timezone_12, u1_.night_mode AS night_mode_13, u1_.show_custom_stylesheets AS show_custom_stylesheets_14, u1_.trusted AS trusted_15, u1_.front_page AS front_page_16, u1_.front_page_sort_mode AS front_page_sort_mode_17, u1_.open_external_links_in_new_tab AS open_external_links_in_new_tab_18, u1_.biography AS biography_19, u1_.auto_fetch_submission_titles AS auto_fetch_submission_titles_20, u1_.enable_post_previews AS enable_post_previews_21, u1_.show_thumbnails AS show_thumbnails_22, u1_.allow_private_messages AS allow_private_messages_23, u1_.notify_on_reply AS notify_on_reply_24, u1_.notify_on_mentions AS notify_on_mentions_25, u1_.poppers_enabled AS poppers_enabled_26, u1_.preferred_fonts AS preferred_fonts_27, u1_.full_width_display_enabled AS full_width_display_enabled_28, u1_.submission_link_destination AS submission_link_destination_29, u1_.background_alpha AS background_alpha_30, f2_.id AS id_31, f2_.name AS name_32, f2_.normalized_name AS normalized_name_33, f2_.title AS title_34, f2_.description AS description_35, f2_.sidebar AS sidebar_36, f2_.created AS created_37, f2_.featured AS featured_38, f2_.moderation_log_public AS moderation_log_public_39, f2_.background_image_mode AS background_image_mode_40, f2_.voting_enabled AS voting_enabled_41, s0_.forum_id AS forum_id_42, s0_.user_id AS user_id_43, s0_.image_id AS image_id_44, u1_.preferred_theme_id AS preferred_theme_id_45, f2_.light_background_image_id AS light_background_image_id_46, f2_.dark_background_image_id AS dark_background_image_id_47, f2_.suggested_theme_id AS suggested_theme_id_48 FROM submissions s0_ INNER JOIN users u1_ ON s0_.user_id = u1_.id INNER JOIN forums f2_ ON s0_.forum_id = f2_.id WHERE s0_.id IN (NULL);

SELECT
  s0_.id AS id_0,
  f1_.id AS id_1,
  f1_.label_text AS label_text_2,
  s0_.forum_id AS forum_id_3,
  s0_.user_id AS user_id_4,
  s0_.image_id AS image_id_5,
  f1_.flair_type AS flair_type_6
FROM
  submissions s0_
  LEFT JOIN submissions_flairs s2_ ON s0_.id = s2_.submission_id
  LEFT JOIN flairs f1_ ON f1_.id = s2_.flair_id
  AND f1_.flair_type IN ('custom_text')
WHERE
  s0_.id IN (NULL)

SELECT s0_.id AS id_0, f1_.id AS id_1, f1_.label_text AS label_text_2, s0_.forum_id AS forum_id_3, s0_.user_id AS user_id_4, s0_.image_id AS image_id_5, f1_.flair_type AS flair_type_6 FROM submissions s0_ LEFT JOIN submissions_flairs s2_ ON s0_.id = s2_.submission_id LEFT JOIN flairs f1_ ON f1_.id = s2_.flair_id AND f1_.flair_type IN ('custom_text') WHERE s0_.id IN (NULL);

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1
FROM
  forums f0_
WHERE
  f0_.featured = TRUE
ORDER BY
  f0_.normalized_name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1 FROM forums f0_ WHERE f0_.featured = TRUE ORDER BY f0_.normalized_name ASC;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.registration_open AS registration_open_3,
  t0.username_change_enabled AS username_change_enabled_4,
  t0.default_sort_mode AS default_sort_mode_5,
  t0.wiki_enabled AS wiki_enabled_6,
  t0.wiki_log_public AS wiki_log_public_7,
  t0.forum_create_role AS forum_create_role_8,
  t0.message_compose_role AS message_compose_role_9,
  t0.moderators_can_set_forum_log_visibility AS moderators_can_set_forum_log_visibility_10,
  t0.image_upload_role AS image_upload_role_11,
  t0.wiki_edit_role AS wiki_edit_role_12,
  t0.trash_enabled AS trash_enabled_13,
  t0.registration_captcha_enabled AS registration_captcha_enabled_14,
  t0.url_images_enabled AS url_images_enabled_15,
  t0.submission_link_destination AS submission_link_destination_16,
  t0.default_theme_id AS default_theme_id_17
FROM
  sites t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.registration_open AS registration_open_3, t0.username_change_enabled AS username_change_enabled_4, t0.default_sort_mode AS default_sort_mode_5, t0.wiki_enabled AS wiki_enabled_6, t0.wiki_log_public AS wiki_log_public_7, t0.forum_create_role AS forum_create_role_8, t0.message_compose_role AS message_compose_role_9, t0.moderators_can_set_forum_log_visibility AS moderators_can_set_forum_log_visibility_10, t0.image_upload_role AS image_upload_role_11, t0.wiki_edit_role AS wiki_edit_role_12, t0.trash_enabled AS trash_enabled_13, t0.registration_captcha_enabled AS registration_captcha_enabled_14, t0.url_images_enabled AS url_images_enabled_15, t0.submission_link_destination AS submission_link_destination_16, t0.default_theme_id AS default_theme_id_17 FROM sites t0 WHERE t0.id = '00000000-0000-0000-0000-000000000000';