Query Metrics
16
Database Queries
5
Different statements
7.90 ms
Query time
0
Invalid entities
Queries
| #▲ | 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
| Class | Mapping errors |
|---|---|
| App\Entity\Submission | No errors. |
| App\Entity\Forum | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Vote | No errors. |
| App\Entity\SubmissionVote | No errors. |
| App\Entity\Notification | 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\CommentVote | 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. |