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_.forum_id IN (
    SELECT
      f1_.id
    FROM
      forums f1_
    WHERE
      f1_.featured = TRUE
  )
ORDER BY
  s0_.ranking 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 (SELECT f1_.id FROM forums f1_ WHERE f1_.featured = TRUE) ORDER BY s0_.ranking 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 ('91', '90', '88', '71', '60', '50', '43', '37', '36', '35', '32', '31', '26', '19', '17', '14', '9', '8', '7', '6', '5', '4', '3', '2', '1');

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 ('91', '90', '88', '71', '60', '50', '43', '37', '36', '35', '32', '31', '26', '19', '17', '14', '9', '8', '7', '6', '5', '4', '3', '2', '1');

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

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 = 'ab892f1a-09a9-4e2c-b835-cb13a1a75da1';

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 = '940ab71b-3e93-4e83-a2a8-caa05877a4b0';

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 = 'fcc30dd7-7812-43d1-a1d7-ecf2cafe9fea';

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 = '00e6ffdb-e14b-48ca-a40a-158fd20d4be9';

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 = '2869a28e-1224-434d-b7ac-0831a46be709';

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 = '91d5c9b2-b562-4175-b909-7b640f2e5c70';

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 = '731ac274-c922-4ec0-8b83-9bded4302e33';

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 = 'd91f428d-5127-4105-8e89-34927889f4a5';

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 = 'bc1bb3f3-524e-4e05-afd1-fd9d65bfcffc';

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 = 'a56a7a3e-ed4a-4a45-8fef-c26e6fddbc55';

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 = 'f281ac3b-980f-4b97-8112-595e74bff112';

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 = 'c83c1c7e-ae0d-4934-ab75-4d33415be106';

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 = '30425659-38f5-4ac1-a633-40e3db9a11f6';

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 = '2acbf2fc-d333-423f-9a50-bfe9728bc8e0';

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 = '2a4d0341-dcf1-46d2-b206-3a54dd05d158';

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 = '9be98641-aab1-4894-89ee-6d77ceb0ed0c';

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 = '26d1d96d-75ac-4a91-b3b6-0cee3f14ff39';

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 = 'd13c1bff-9cc8-47cd-a4b1-77f91c64e635';