Symfony Profiler

Query Metrics

40 Database Queries

8 Different statements

79.71 ms Query time

0 Invalid entities

Queries


SELECT ts_headline(e.body, search_query, ?) AS body_excerpt, e.id AS id, e.body AS body, e.timestamp AS timestamp, e.visibility AS visibility, e.ip AS ip, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.net_score AS net_score, e.search_doc AS search_doc, e.user_id AS user_id, e.submission_id AS submission_id, e.parent_id AS parent_id, ?::TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM comments e, (SELECT plainto_tsquery(?::TEXT) AS search_query) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50
SELECT ts_headline(e.title, search_query, ?) AS title_highlighted, ts_headline(e.body, search_query, ?) AS body_excerpt, e.id AS id, e.title AS title, e.url AS url, e.body AS body, e.media_type AS media_type, e.comment_count AS comment_count, e.timestamp AS timestamp, e.last_active AS last_active, e.visibility AS visibility, e.image_alt_text AS image_alt_text, e.ip AS ip, e.sticky AS sticky, e.ranking AS ranking, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.locked AS locked, e.net_score AS net_score, e.search_doc AS search_doc, e.forum_id AS forum_id, e.user_id AS user_id, e.image_id AS image_id, ?::TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM submissions e, (SELECT plainto_tsquery(?::TEXT) AS search_query) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50
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, 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 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 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.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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?
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 = ?

#▲	Time	Info
1	30.02 ms	SELECT ts_headline(e.body, search_query, ?) AS body_excerpt, e.id AS id, e.body AS body, e.timestamp AS timestamp, e.visibility AS visibility, e.ip AS ip, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.net_score AS net_score, e.search_doc AS search_doc, e.user_id AS user_id, e.submission_id AS submission_id, e.parent_id AS parent_id, ?::TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM comments e, (SELECT plainto_tsquery(?::TEXT) AS search_query) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50 Parameters: [`"MaxFragments=3" "comment" "archive.threefoldcord.site"`] View formatted query View runnable query Explain query SELECT ts_headline(e.body, search_query, ?) AS body_excerpt, e.id AS id, e.body AS body, e.timestamp AS timestamp, e.visibility AS visibility, e.ip AS ip, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.net_score AS net_score, e.search_doc AS search_doc, e.user_id AS user_id, e.submission_id AS submission_id, e.parent_id AS parent_id, ? :: TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM comments e, ( SELECT plainto_tsquery(? :: TEXT) AS search_query ) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50 SELECT ts_headline(e.body, search_query, 'MaxFragments=3') AS body_excerpt, e.id AS id, e.body AS body, e.timestamp AS timestamp, e.visibility AS visibility, e.ip AS ip, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.net_score AS net_score, e.search_doc AS search_doc, e.user_id AS user_id, e.submission_id AS submission_id, e.parent_id AS parent_id, 'comment'::TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM comments e, (SELECT plainto_tsquery('archive.threefoldcord.site'::TEXT) AS search_query) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50;
2	3.20 ms	SELECT ts_headline(e.title, search_query, ?) AS title_highlighted, ts_headline(e.body, search_query, ?) AS body_excerpt, e.id AS id, e.title AS title, e.url AS url, e.body AS body, e.media_type AS media_type, e.comment_count AS comment_count, e.timestamp AS timestamp, e.last_active AS last_active, e.visibility AS visibility, e.image_alt_text AS image_alt_text, e.ip AS ip, e.sticky AS sticky, e.ranking AS ranking, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.locked AS locked, e.net_score AS net_score, e.search_doc AS search_doc, e.forum_id AS forum_id, e.user_id AS user_id, e.image_id AS image_id, ?::TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM submissions e, (SELECT plainto_tsquery(?::TEXT) AS search_query) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50 Parameters: [`"HighlightAll=TRUE" "MaxFragments=3" "submission" "archive.threefoldcord.site"`] View formatted query View runnable query Explain query SELECT ts_headline(e.title, search_query, ?) AS title_highlighted, ts_headline(e.body, search_query, ?) AS body_excerpt, e.id AS id, e.title AS title, e.url AS url, e.body AS body, e.media_type AS media_type, e.comment_count AS comment_count, e.timestamp AS timestamp, e.last_active AS last_active, e.visibility AS visibility, e.image_alt_text AS image_alt_text, e.ip AS ip, e.sticky AS sticky, e.ranking AS ranking, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.locked AS locked, e.net_score AS net_score, e.search_doc AS search_doc, e.forum_id AS forum_id, e.user_id AS user_id, e.image_id AS image_id, ? :: TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM submissions e, ( SELECT plainto_tsquery(? :: TEXT) AS search_query ) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50 SELECT ts_headline(e.title, search_query, 'HighlightAll=TRUE') AS title_highlighted, ts_headline(e.body, search_query, 'MaxFragments=3') AS body_excerpt, e.id AS id, e.title AS title, e.url AS url, e.body AS body, e.media_type AS media_type, e.comment_count AS comment_count, e.timestamp AS timestamp, e.last_active AS last_active, e.visibility AS visibility, e.image_alt_text AS image_alt_text, e.ip AS ip, e.sticky AS sticky, e.ranking AS ranking, e.edited_at AS edited_at, e.moderated AS moderated, e.user_flag AS user_flag, e.locked AS locked, e.net_score AS net_score, e.search_doc AS search_doc, e.forum_id AS forum_id, e.user_id AS user_id, e.image_id AS image_id, 'submission'::TEXT AS entity, ts_rank(search_doc, search_query) AS search_rank FROM submissions e, (SELECT plainto_tsquery('archive.threefoldcord.site'::TEXT) AS search_query) q WHERE (search_doc @@ search_query) AND (visibility = 'visible') ORDER BY search_rank DESC LIMIT 50;
3	2.30 ms	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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"1" "2" "3" "4" "5" "6" "7" "8" "9" "38" "39" "96" "14" "17" "18" "19" "20" "80" "23" "25" "26" "27" "31" "32" "33" "34" "35" "36" "37" "41" "28" "30" "82" "43" "45" "46" "47" "51" "53" "81" "49" "54" "97" "44" "55" "83" "94" "58" "60" "62"`] View formatted query View runnable query Explain query 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 ('1', '2', '3', '4', '5', '6', '7', '8', '9', '38', '39', '96', '14', '17', '18', '19', '20', '80', '23', '25', '26', '27', '31', '32', '33', '34', '35', '36', '37', '41', '28', '30', '82', '43', '45', '46', '47', '51', '53', '81', '49', '54', '97', '44', '55', '83', '94', '58', '60', '62');
4	3.96 ms	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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"1" "2" "3" "4" "5" "6" "7" "8" "9" "38" "39" "96" "14" "17" "18" "19" "20" "80" "23" "25" "26" "27" "31" "32" "33" "34" "35" "36" "37" "41" "28" "30" "82" "43" "45" "46" "47" "51" "53" "81" "49" "54" "97" "44" "55" "83" "94" "58" "60" "62"`] View formatted query View runnable query Explain query 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 ('1', '2', '3', '4', '5', '6', '7', '8', '9', '38', '39', '96', '14', '17', '18', '19', '20', '80', '23', '25', '26', '27', '31', '32', '33', '34', '35', '36', '37', '41', '28', '30', '82', '43', '45', '46', '47', '51', '53', '81', '49', '54', '97', '44', '55', '83', '94', '58', '60', '62');
5	3.36 ms	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) Parameters: [] View formatted query View runnable query Explain query 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);
6	2.61 ms	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) Parameters: [] View formatted query View runnable query Explain query 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);
7	0.55 ms	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 = ? Parameters: [`"00000000-0000-0000-0000-000000000000"`] View formatted query View runnable query Explain query 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';
8	3.96 ms	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 = ? Parameters: [`"d13c1bff-9cc8-47cd-a4b1-77f91c64e635"`] View formatted query View runnable query Explain query 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';
9	0.24 ms	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 = ? Parameters: [`"26d1d96d-75ac-4a91-b3b6-0cee3f14ff39"`] View formatted query View runnable query Explain query 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';
10	3.38 ms	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 = ? Parameters: [`"9be98641-aab1-4894-89ee-6d77ceb0ed0c"`] View formatted query View runnable query Explain query 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';
11	0.27 ms	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 = ? Parameters: [`"2a4d0341-dcf1-46d2-b206-3a54dd05d158"`] View formatted query View runnable query Explain query 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';
12	3.25 ms	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 = ? Parameters: [`"2acbf2fc-d333-423f-9a50-bfe9728bc8e0"`] View formatted query View runnable query Explain query 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';
13	3.15 ms	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 = ? Parameters: [`"30425659-38f5-4ac1-a633-40e3db9a11f6"`] View formatted query View runnable query Explain query 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';
14	3.40 ms	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 = ? Parameters: [`"c83c1c7e-ae0d-4934-ab75-4d33415be106"`] View formatted query View runnable query Explain query 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';
15	0.34 ms	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 = ? Parameters: [`"f86b66b1-d7d8-4d0a-9372-2bb53289029e"`] View formatted query View runnable query Explain query 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';
16	3.52 ms	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 = ? Parameters: [`"f281ac3b-980f-4b97-8112-595e74bff112"`] View formatted query View runnable query Explain query 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';
17	2.12 ms	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 = ? Parameters: [`"a56a7a3e-ed4a-4a45-8fef-c26e6fddbc55"`] View formatted query View runnable query Explain query 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';
18	1.46 ms	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 = ? Parameters: [`"aee531fa-1ed0-4bcb-b4b0-0aa31d98626f"`] View formatted query View runnable query Explain query 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';
19	3.64 ms	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 = ? Parameters: [`"bc1bb3f3-524e-4e05-afd1-fd9d65bfcffc"`] View formatted query View runnable query Explain query 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';
20	0.35 ms	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 = ? Parameters: [`"7879b209-09e0-4e22-b415-1190a7091034"`] View formatted query View runnable query Explain query 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 = '7879b209-09e0-4e22-b415-1190a7091034';
21	0.24 ms	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 = ? Parameters: [`"3d1f4953-b680-4005-a569-ce1c12caef87"`] View formatted query View runnable query Explain query 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 = '3d1f4953-b680-4005-a569-ce1c12caef87';
22	0.26 ms	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 = ? Parameters: [`"10f29a4d-4870-4d1f-9805-6ac1f464ee65"`] View formatted query View runnable query Explain query 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 = '10f29a4d-4870-4d1f-9805-6ac1f464ee65';
23	0.25 ms	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 = ? Parameters: [`"2fce0d40-aa3b-4dce-80ff-a2a48e2806b7"`] View formatted query View runnable query Explain query 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 = '2fce0d40-aa3b-4dce-80ff-a2a48e2806b7';
24	0.23 ms	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 = ? Parameters: [`"d91f428d-5127-4105-8e89-34927889f4a5"`] View formatted query View runnable query Explain query 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';
25	0.22 ms	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 = ? Parameters: [`"26634ce0-dcde-40c9-a833-0002e8aea05e"`] View formatted query View runnable query Explain query 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 = '26634ce0-dcde-40c9-a833-0002e8aea05e';
26	0.23 ms	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 = ? Parameters: [`"f3105711-e622-450c-afed-e107c885daa8"`] View formatted query View runnable query Explain query 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 = 'f3105711-e622-450c-afed-e107c885daa8';
27	0.24 ms	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 = ? Parameters: [`"731ac274-c922-4ec0-8b83-9bded4302e33"`] View formatted query View runnable query Explain query 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';
28	0.22 ms	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 = ? Parameters: [`"91d5c9b2-b562-4175-b909-7b640f2e5c70"`] View formatted query View runnable query Explain query 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';
29	0.22 ms	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 = ? Parameters: [`"2869a28e-1224-434d-b7ac-0831a46be709"`] View formatted query View runnable query Explain query 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';
30	0.24 ms	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 = ? Parameters: [`"c2d538cf-9666-4ca1-97f5-ec738e9469af"`] View formatted query View runnable query Explain query 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';
31	0.24 ms	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 = ? Parameters: [`"99f8e50a-9997-415e-9370-d737beb5ba7d"`] View formatted query View runnable query Explain query 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 = '99f8e50a-9997-415e-9370-d737beb5ba7d';
32	0.23 ms	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 = ? Parameters: [`"00e6ffdb-e14b-48ca-a40a-158fd20d4be9"`] View formatted query View runnable query Explain query 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';
33	0.22 ms	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 = ? Parameters: [`"b97cbd49-184c-404a-8288-623e39c3e463"`] View formatted query View runnable query Explain query 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 = 'b97cbd49-184c-404a-8288-623e39c3e463';
34	0.22 ms	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 = ? Parameters: [`"ad2661e1-b0ca-4fdf-b8bb-604216712d5a"`] View formatted query View runnable query Explain query 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 = 'ad2661e1-b0ca-4fdf-b8bb-604216712d5a';
35	0.22 ms	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 = ? Parameters: [`"bd9e2fff-19c2-4f06-96c0-43dbd6fb9cdf"`] View formatted query View runnable query Explain query 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 = 'bd9e2fff-19c2-4f06-96c0-43dbd6fb9cdf';
36	0.25 ms	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 = ? Parameters: [`"e08d3f79-8dc8-4414-8b9f-415fb33bc1ea"`] View formatted query View runnable query Explain query 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';
37	0.23 ms	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 = ? Parameters: [`"a13606a3-4b41-4a58-904f-d546155971fd"`] View formatted query View runnable query Explain query 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 = 'a13606a3-4b41-4a58-904f-d546155971fd';
38	0.22 ms	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 = ? Parameters: [`"10a53947-b600-46cc-ad09-22fa53bb7f5a"`] View formatted query View runnable query Explain query 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 = '10a53947-b600-46cc-ad09-22fa53bb7f5a';
39	0.22 ms	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 = ? Parameters: [`"638fc342-fda6-45a4-ab65-07602e68facc"`] View formatted query View runnable query Explain query 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 = '638fc342-fda6-45a4-ab65-07602e68facc';
40	0.23 ms	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 = ? Parameters: [`"f4edf813-3de6-4d2e-8cbd-d18712ea5b2f"`] View formatted query View runnable query Explain query 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 = 'f4edf813-3de6-4d2e-8cbd-d18712ea5b2f';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Comment	No errors.
App\Entity\User	No errors.
App\Entity\Submission	No errors.
App\Entity\Vote	No errors.
App\Entity\CommentVote	No errors.
App\Entity\Notification	No errors.
App\Entity\CommentNotification	No errors.
App\Entity\CommentMention	No errors.
App\Entity\Forum	No errors.
App\Entity\Image	No errors.
App\Entity\SubmissionVote	No errors.
App\Entity\SubmissionMention	No errors.
App\Entity\Flair	No errors.
App\Entity\Theme	No errors.
App\Entity\ForumSubscription	No errors.
App\Entity\Moderator	No errors.
App\Entity\UserBan	No errors.
App\Entity\IpBan	No errors.
App\Entity\UserBlock	No errors.
App\Entity\Message	No errors.
App\Entity\ForumBan	No errors.
App\Entity\ForumTag	No errors.
App\Entity\ForumLogEntry	No errors.
App\Entity\CustomTextFlair	No errors.
App\Entity\Site	No errors.

Symfony Profiler

GET http://forum.threefoldcord.site/search?q=archive.threefoldcord.site

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping