Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.normalized_name AS normalized_name_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.sidebar AS sidebar_6,
  t0.created AS created_7,
  t0.featured AS featured_8,
  t0.moderation_log_public AS moderation_log_public_9,
  t0.background_image_mode AS background_image_mode_10,
  t0.voting_enabled AS voting_enabled_11,
  t0.light_background_image_id AS light_background_image_id_12,
  t0.dark_background_image_id AS dark_background_image_id_13,
  t0.suggested_theme_id AS suggested_theme_id_14
FROM
  forums t0
WHERE
  t0.normalized_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.title AS title_4, t0.description AS description_5, t0.sidebar AS sidebar_6, t0.created AS created_7, t0.featured AS featured_8, t0.moderation_log_public AS moderation_log_public_9, t0.background_image_mode AS background_image_mode_10, t0.voting_enabled AS voting_enabled_11, t0.light_background_image_id AS light_background_image_id_12, t0.dark_background_image_id AS dark_background_image_id_13, t0.suggested_theme_id AS suggested_theme_id_14 FROM forums t0 WHERE t0.normalized_name = 'geoengineering' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.media_type AS media_type_5,
  t0.comment_count AS comment_count_6,
  t0.timestamp AS timestamp_7,
  t0.last_active AS last_active_8,
  t0.visibility AS visibility_9,
  t0.image_alt_text AS image_alt_text_10,
  t0.ip AS ip_11,
  t0.sticky AS sticky_12,
  t0.ranking AS ranking_13,
  t0.edited_at AS edited_at_14,
  t0.moderated AS moderated_15,
  t0.user_flag AS user_flag_16,
  t0.locked AS locked_17,
  t0.net_score AS net_score_18,
  t0.search_doc AS search_doc_19,
  t0.forum_id AS forum_id_20,
  t0.user_id AS user_id_21,
  t0.image_id AS image_id_22
FROM
  submissions t0
WHERE
  t0.forum_id = ?
  AND t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.media_type AS media_type_5, t0.comment_count AS comment_count_6, t0.timestamp AS timestamp_7, t0.last_active AS last_active_8, t0.visibility AS visibility_9, t0.image_alt_text AS image_alt_text_10, t0.ip AS ip_11, t0.sticky AS sticky_12, t0.ranking AS ranking_13, t0.edited_at AS edited_at_14, t0.moderated AS moderated_15, t0.user_flag AS user_flag_16, t0.locked AS locked_17, t0.net_score AS net_score_18, t0.search_doc AS search_doc_19, t0.forum_id AS forum_id_20, t0.user_id AS user_id_21, t0.image_id AS image_id_22 FROM submissions t0 WHERE t0.forum_id = '8' AND t0.id = '66' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.body AS body_2,
  t0.timestamp AS timestamp_3,
  t0.visibility AS visibility_4,
  t0.ip AS ip_5,
  t0.edited_at AS edited_at_6,
  t0.moderated AS moderated_7,
  t0.user_flag AS user_flag_8,
  t0.net_score AS net_score_9,
  t0.search_doc AS search_doc_10,
  t0.user_id AS user_id_11,
  t0.submission_id AS submission_id_12,
  t0.parent_id AS parent_id_13
FROM
  comments t0
WHERE
  (
    t0.parent_id IS NULL
    AND t0.submission_id = ?
  )
ORDER BY
  t0.timestamp ASC

SELECT t0.id AS id_1, t0.body AS body_2, t0.timestamp AS timestamp_3, t0.visibility AS visibility_4, t0.ip AS ip_5, t0.edited_at AS edited_at_6, t0.moderated AS moderated_7, t0.user_flag AS user_flag_8, t0.net_score AS net_score_9, t0.search_doc AS search_doc_10, t0.user_id AS user_id_11, t0.submission_id AS submission_id_12, t0.parent_id AS parent_id_13 FROM comments t0 WHERE (t0.parent_id IS NULL AND t0.submission_id = '66') ORDER BY t0.timestamp ASC;

SELECT
  c0_.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,
  s2_.id AS id_31,
  s2_.title AS title_32,
  s2_.url AS url_33,
  s2_.body AS body_34,
  s2_.media_type AS media_type_35,
  s2_.comment_count AS comment_count_36,
  s2_.timestamp AS timestamp_37,
  s2_.last_active AS last_active_38,
  s2_.visibility AS visibility_39,
  s2_.image_alt_text AS image_alt_text_40,
  s2_.ip AS ip_41,
  s2_.sticky AS sticky_42,
  s2_.ranking AS ranking_43,
  s2_.edited_at AS edited_at_44,
  s2_.moderated AS moderated_45,
  s2_.user_flag AS user_flag_46,
  s2_.locked AS locked_47,
  s2_.net_score AS net_score_48,
  s2_.search_doc AS search_doc_49,
  f3_.id AS id_50,
  f3_.name AS name_51,
  f3_.normalized_name AS normalized_name_52,
  f3_.title AS title_53,
  f3_.description AS description_54,
  f3_.sidebar AS sidebar_55,
  f3_.created AS created_56,
  f3_.featured AS featured_57,
  f3_.moderation_log_public AS moderation_log_public_58,
  f3_.background_image_mode AS background_image_mode_59,
  f3_.voting_enabled AS voting_enabled_60,
  u4_.id AS id_61,
  u4_.username AS username_62,
  u4_.normalized_username AS normalized_username_63,
  u4_.password AS password_64,
  u4_.email AS email_65,
  u4_.normalized_email AS normalized_email_66,
  u4_.created AS created_67,
  u4_.last_seen AS last_seen_68,
  u4_.registration_ip AS registration_ip_69,
  u4_.admin AS admin_70,
  u4_.locale AS locale_71,
  u4_.timezone AS timezone_72,
  u4_.night_mode AS night_mode_73,
  u4_.show_custom_stylesheets AS show_custom_stylesheets_74,
  u4_.trusted AS trusted_75,
  u4_.front_page AS front_page_76,
  u4_.front_page_sort_mode AS front_page_sort_mode_77,
  u4_.open_external_links_in_new_tab AS open_external_links_in_new_tab_78,
  u4_.biography AS biography_79,
  u4_.auto_fetch_submission_titles AS auto_fetch_submission_titles_80,
  u4_.enable_post_previews AS enable_post_previews_81,
  u4_.show_thumbnails AS show_thumbnails_82,
  u4_.allow_private_messages AS allow_private_messages_83,
  u4_.notify_on_reply AS notify_on_reply_84,
  u4_.notify_on_mentions AS notify_on_mentions_85,
  u4_.poppers_enabled AS poppers_enabled_86,
  u4_.preferred_fonts AS preferred_fonts_87,
  u4_.full_width_display_enabled AS full_width_display_enabled_88,
  u4_.submission_link_destination AS submission_link_destination_89,
  u4_.background_alpha AS background_alpha_90,
  c0_.user_id AS user_id_91,
  c0_.submission_id AS submission_id_92,
  c0_.parent_id AS parent_id_93,
  u1_.preferred_theme_id AS preferred_theme_id_94,
  s2_.forum_id AS forum_id_95,
  s2_.user_id AS user_id_96,
  s2_.image_id AS image_id_97,
  f3_.light_background_image_id AS light_background_image_id_98,
  f3_.dark_background_image_id AS dark_background_image_id_99,
  f3_.suggested_theme_id AS suggested_theme_id_100,
  u4_.preferred_theme_id AS preferred_theme_id_101
FROM
  comments c0_
  INNER JOIN users u1_ ON c0_.user_id = u1_.id
  INNER JOIN submissions s2_ ON c0_.submission_id = s2_.id
  INNER JOIN forums f3_ ON s2_.forum_id = f3_.id
  INNER JOIN users u4_ ON s2_.user_id = u4_.id
WHERE
  c0_.id IN (NULL)

SELECT c0_.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, s2_.id AS id_31, s2_.title AS title_32, s2_.url AS url_33, s2_.body AS body_34, s2_.media_type AS media_type_35, s2_.comment_count AS comment_count_36, s2_.timestamp AS timestamp_37, s2_.last_active AS last_active_38, s2_.visibility AS visibility_39, s2_.image_alt_text AS image_alt_text_40, s2_.ip AS ip_41, s2_.sticky AS sticky_42, s2_.ranking AS ranking_43, s2_.edited_at AS edited_at_44, s2_.moderated AS moderated_45, s2_.user_flag AS user_flag_46, s2_.locked AS locked_47, s2_.net_score AS net_score_48, s2_.search_doc AS search_doc_49, f3_.id AS id_50, f3_.name AS name_51, f3_.normalized_name AS normalized_name_52, f3_.title AS title_53, f3_.description AS description_54, f3_.sidebar AS sidebar_55, f3_.created AS created_56, f3_.featured AS featured_57, f3_.moderation_log_public AS moderation_log_public_58, f3_.background_image_mode AS background_image_mode_59, f3_.voting_enabled AS voting_enabled_60, u4_.id AS id_61, u4_.username AS username_62, u4_.normalized_username AS normalized_username_63, u4_.password AS password_64, u4_.email AS email_65, u4_.normalized_email AS normalized_email_66, u4_.created AS created_67, u4_.last_seen AS last_seen_68, u4_.registration_ip AS registration_ip_69, u4_.admin AS admin_70, u4_.locale AS locale_71, u4_.timezone AS timezone_72, u4_.night_mode AS night_mode_73, u4_.show_custom_stylesheets AS show_custom_stylesheets_74, u4_.trusted AS trusted_75, u4_.front_page AS front_page_76, u4_.front_page_sort_mode AS front_page_sort_mode_77, u4_.open_external_links_in_new_tab AS open_external_links_in_new_tab_78, u4_.biography AS biography_79, u4_.auto_fetch_submission_titles AS auto_fetch_submission_titles_80, u4_.enable_post_previews AS enable_post_previews_81, u4_.show_thumbnails AS show_thumbnails_82, u4_.allow_private_messages AS allow_private_messages_83, u4_.notify_on_reply AS notify_on_reply_84, u4_.notify_on_mentions AS notify_on_mentions_85, u4_.poppers_enabled AS poppers_enabled_86, u4_.preferred_fonts AS preferred_fonts_87, u4_.full_width_display_enabled AS full_width_display_enabled_88, u4_.submission_link_destination AS submission_link_destination_89, u4_.background_alpha AS background_alpha_90, c0_.user_id AS user_id_91, c0_.submission_id AS submission_id_92, c0_.parent_id AS parent_id_93, u1_.preferred_theme_id AS preferred_theme_id_94, s2_.forum_id AS forum_id_95, s2_.user_id AS user_id_96, s2_.image_id AS image_id_97, f3_.light_background_image_id AS light_background_image_id_98, f3_.dark_background_image_id AS dark_background_image_id_99, f3_.suggested_theme_id AS suggested_theme_id_100, u4_.preferred_theme_id AS preferred_theme_id_101 FROM comments c0_ INNER JOIN users u1_ ON c0_.user_id = u1_.id INNER JOIN submissions s2_ ON c0_.submission_id = s2_.id INNER JOIN forums f3_ ON s2_.forum_id = f3_.id INNER JOIN users u4_ ON s2_.user_id = u4_.id WHERE c0_.id IN (NULL);

SELECT
  c0_.id AS id_0,
  c1_.id AS id_1,
  c1_.body AS body_2,
  c1_.timestamp AS timestamp_3,
  c1_.visibility AS visibility_4,
  c1_.ip AS ip_5,
  c1_.edited_at AS edited_at_6,
  c1_.moderated AS moderated_7,
  c1_.user_flag AS user_flag_8,
  c1_.net_score AS net_score_9,
  c1_.search_doc AS search_doc_10,
  c0_.user_id AS user_id_11,
  c0_.submission_id AS submission_id_12,
  c0_.parent_id AS parent_id_13,
  c1_.user_id AS user_id_14,
  c1_.submission_id AS submission_id_15,
  c1_.parent_id AS parent_id_16
FROM
  comments c0_
  LEFT JOIN comments c1_ ON c0_.id = c1_.parent_id
WHERE
  c0_.id IN (NULL)

SELECT c0_.id AS id_0, c1_.id AS id_1, c1_.body AS body_2, c1_.timestamp AS timestamp_3, c1_.visibility AS visibility_4, c1_.ip AS ip_5, c1_.edited_at AS edited_at_6, c1_.moderated AS moderated_7, c1_.user_flag AS user_flag_8, c1_.net_score AS net_score_9, c1_.search_doc AS search_doc_10, c0_.user_id AS user_id_11, c0_.submission_id AS submission_id_12, c0_.parent_id AS parent_id_13, c1_.user_id AS user_id_14, c1_.submission_id AS submission_id_15, c1_.parent_id AS parent_id_16 FROM comments c0_ LEFT JOIN comments c1_ ON c0_.id = c1_.parent_id WHERE c0_.id IN (NULL);

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

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.sha256 AS sha256_3,
  t0.width AS width_4,
  t0.height AS height_5
FROM
  images t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5 FROM images t0 WHERE t0.id = '910843bf-97c8-438b-a931-eb627aff0688';

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.normalized_username AS normalized_username_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.normalized_email AS normalized_email_6,
  t0.created AS created_7,
  t0.last_seen AS last_seen_8,
  t0.registration_ip AS registration_ip_9,
  t0.admin AS admin_10,
  t0.locale AS locale_11,
  t0.timezone AS timezone_12,
  t0.night_mode AS night_mode_13,
  t0.show_custom_stylesheets AS show_custom_stylesheets_14,
  t0.trusted AS trusted_15,
  t0.front_page AS front_page_16,
  t0.front_page_sort_mode AS front_page_sort_mode_17,
  t0.open_external_links_in_new_tab AS open_external_links_in_new_tab_18,
  t0.biography AS biography_19,
  t0.auto_fetch_submission_titles AS auto_fetch_submission_titles_20,
  t0.enable_post_previews AS enable_post_previews_21,
  t0.show_thumbnails AS show_thumbnails_22,
  t0.allow_private_messages AS allow_private_messages_23,
  t0.notify_on_reply AS notify_on_reply_24,
  t0.notify_on_mentions AS notify_on_mentions_25,
  t0.poppers_enabled AS poppers_enabled_26,
  t0.preferred_fonts AS preferred_fonts_27,
  t0.full_width_display_enabled AS full_width_display_enabled_28,
  t0.submission_link_destination AS submission_link_destination_29,
  t0.background_alpha AS background_alpha_30,
  t0.preferred_theme_id AS preferred_theme_id_31
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.normalized_username AS normalized_username_3, t0.password AS password_4, t0.email AS email_5, t0.normalized_email AS normalized_email_6, t0.created AS created_7, t0.last_seen AS last_seen_8, t0.registration_ip AS registration_ip_9, t0.admin AS admin_10, t0.locale AS locale_11, t0.timezone AS timezone_12, t0.night_mode AS night_mode_13, t0.show_custom_stylesheets AS show_custom_stylesheets_14, t0.trusted AS trusted_15, t0.front_page AS front_page_16, t0.front_page_sort_mode AS front_page_sort_mode_17, t0.open_external_links_in_new_tab AS open_external_links_in_new_tab_18, t0.biography AS biography_19, t0.auto_fetch_submission_titles AS auto_fetch_submission_titles_20, t0.enable_post_previews AS enable_post_previews_21, t0.show_thumbnails AS show_thumbnails_22, t0.allow_private_messages AS allow_private_messages_23, t0.notify_on_reply AS notify_on_reply_24, t0.notify_on_mentions AS notify_on_mentions_25, t0.poppers_enabled AS poppers_enabled_26, t0.preferred_fonts AS preferred_fonts_27, t0.full_width_display_enabled AS full_width_display_enabled_28, t0.submission_link_destination AS submission_link_destination_29, t0.background_alpha AS background_alpha_30, t0.preferred_theme_id AS preferred_theme_id_31 FROM users t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.flair_type,
  t0.label_text AS label_text_2
FROM
  flairs t0
  INNER JOIN submissions_flairs ON t0.id = submissions_flairs.flair_id
WHERE
  submissions_flairs.submission_id = ?
  AND t0.flair_type IN ('custom_text')

SELECT t0.id AS id_1, t0.flair_type, t0.label_text AS label_text_2 FROM flairs t0 INNER JOIN submissions_flairs ON t0.id = submissions_flairs.flair_id WHERE submissions_flairs.submission_id = 66 AND t0.flair_type IN ('custom_text');

SELECT
  t0.id AS id_1,
  t0.upvote AS upvote_2,
  t0.timestamp AS timestamp_3,
  t0.ip AS ip_4,
  t0.user_id AS user_id_5,
  t0.submission_id AS submission_id_6
FROM
  submission_votes t0
WHERE
  t0.submission_id = ?

SELECT t0.id AS id_1, t0.upvote AS upvote_2, t0.timestamp AS timestamp_3, t0.ip AS ip_4, t0.user_id AS user_id_5, t0.submission_id AS submission_id_6 FROM submission_votes t0 WHERE t0.submission_id = 66;

SELECT
  te.id AS id,
  te.name AS name,
  te.normalized_name AS normalized_name,
  te.description AS description
FROM
  forum_tags te
  JOIN forums_tags t ON t.tag_id = te.id
WHERE
  t.forum_id = ?
ORDER BY
  normalized_name ASC

SELECT te.id AS id, te.name AS name, te.normalized_name AS normalized_name, te.description AS description FROM forum_tags te JOIN forums_tags t ON t.tag_id = te.id WHERE t.forum_id = '8' ORDER BY normalized_name ASC;

SELECT
  t0.id AS id_1,
  t0.timestamp AS timestamp_2,
  t0.forum_id AS forum_id_3,
  t0.user_id AS user_id_4
FROM
  moderators t0
WHERE
  t0.forum_id = ?

SELECT t0.id AS id_1, t0.timestamp AS timestamp_2, t0.forum_id AS forum_id_3, t0.user_id AS user_id_4 FROM moderators t0 WHERE t0.forum_id = 8;