GET http://forum.threefoldcord.site/all/active

Query Metrics

16 Database Queries
5 Different statements
7.90 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.83 ms
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 = ? ORDER BY s0_.last_active DESC, s0_.id DESC LIMIT 26
Parameters:
[
  "visible"
]
2 1.63 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:
[
  "97"
  "96"
  "95"
  "94"
  "93"
  "92"
  "91"
  "90"
  "89"
  "88"
  "87"
  "86"
  "85"
  "84"
  "83"
  "82"
  "81"
  "80"
  "75"
  "74"
  "72"
  "71"
  "70"
  "67"
  "66"
]
3 1.05 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:
[
  "97"
  "96"
  "95"
  "94"
  "93"
  "92"
  "91"
  "90"
  "89"
  "88"
  "87"
  "86"
  "85"
  "84"
  "83"
  "82"
  "81"
  "80"
  "75"
  "74"
  "72"
  "71"
  "70"
  "67"
  "66"
]
4 0.43 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"
]
5 0.42 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:
[
  "ab892f1a-09a9-4e2c-b835-cb13a1a75da1"
]
6 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:
[
  "768c85a8-f6e8-4521-9dc2-d7e1d4641556"
]
7 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:
[
  "940ab71b-3e93-4e83-a2a8-caa05877a4b0"
]
8 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:
[
  "11fde2c3-e90d-46fd-ba3d-39063f8a078e"
]
9 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"
]
10 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:
[
  "3d1f4953-b680-4005-a569-ce1c12caef87"
]
11 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:
[
  "a88ba748-b691-415b-b9a2-4700160e63aa"
]
12 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:
[
  "8f965f97-07bf-44d9-b41d-ff498c068bba"
]
13 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:
[
  "fcc30dd7-7812-43d1-a1d7-ecf2cafe9fea"
]
14 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:
[
  "575eafc2-b187-43bb-8b5a-b15c42b6051f"
]
15 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:
[
  "95dc994d-fa18-4ad7-a018-249603efc613"
]
16 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:
[
  "910843bf-97c8-438b-a931-eb627aff0688"
]

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