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 = 'tech' LIMIT 1;

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_.forum_id IN (?)
ORDER BY
  s0_.sticky DESC,
  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_.forum_id IN ('3') ORDER BY s0_.sticky DESC, 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 (?, ?, ?, ?, ?)

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 ('54', '41', '38', '23', '18');

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 (?, ?, ?, ?, ?)

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 ('54', '41', '38', '23', '18');

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 = 'e08d3f79-8dc8-4414-8b9f-415fb33bc1ea';

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 = 'c2d538cf-9666-4ca1-97f5-ec738e9469af';

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 = 'f86b66b1-d7d8-4d0a-9372-2bb53289029e';

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 = 'aee531fa-1ed0-4bcb-b4b0-0aa31d98626f';

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