Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

1179.98 ms Query time

0 Invalid entities

18 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements


(SELECT id, created_at, 'entry' AS type FROM entry WHERE ap_id ILIKE :url) 
        UNION 
        (SELECT id, created_at, 'entry_comment' AS type FROM entry_comment WHERE ap_id ILIKE :url)
        UNION 
        (SELECT id, created_at, 'post' AS type FROM post WHERE ap_id ILIKE :url)
        UNION 
        (SELECT id, created_at, 'post_comment' AS type FROM post_comment WHERE ap_id ILIKE :url)
        ORDER BY created_at DESC
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
(
        SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type 
        FROM entry 
        INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id 
        INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
        
            WHERE entry.visibility = :visibility
            AND m_entry.visibility = :visibility
            
            AND entry.body_ts @@ plainto_tsquery( :search ) = true
            
            AND entry.is_adult = false
            AND m_entry.is_adult = false
            
            AND (entry.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        UNION
        (
        SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type 
        FROM post 
        INNER JOIN magazine m_post ON post.magazine_id = m_post.id 
        INNER JOIN "user" u_post ON post.user_id = u_post.id
        
            WHERE post.visibility = :visibility
            AND m_post.visibility = :visibility
            
            AND post.body_ts @@ plainto_tsquery( :search ) = true
            
            AND post.is_adult = false
            AND m_post.is_adult = false
            
            AND (post.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        
        UNION
        (
        SELECT entry_comment.id, entry_comment.created_at, entry_comment.score, entry_comment.score + entry_comment.favourite_count AS ranking, entry_comment.last_active, 0 as comment_count, 'entry_comment' AS type 
        FROM entry_comment 
        INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id 
        INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id
        
            WHERE entry_comment.visibility = :visibility
            AND m_entry_comment.visibility = :visibility
            
            AND entry_comment.body_ts @@ plainto_tsquery( :search ) = true
            
            AND entry_comment.is_adult = false
            AND m_entry_comment.is_adult = false
            
            AND (entry_comment.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        UNION
        (
        SELECT post_comment.id, post_comment.created_at, post_comment.score, post_comment.score + post_comment.favourite_count AS ranking, post_comment.last_active, 0 as comment_count, 'post_comment' AS type 
        FROM post_comment 
        INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id 
        INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id
        
            WHERE post_comment.visibility = :visibility
            AND m_post_comment.visibility = :visibility
            
            AND post_comment.body_ts @@ plainto_tsquery( :search ) = true
            
            AND post_comment.is_adult = false
            AND m_post_comment.is_adult = false
            
            AND (post_comment.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        ORDER BY last_active DESC, created_at DESC LIMIT 25000
SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (NULL)
SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL)
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id IN (NULL)
SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id IN (NULL)

#▲	Time	Info
1	1041.87 ms	(SELECT id, created_at, 'entry' AS type FROM entry WHERE ap_id ILIKE :url) UNION (SELECT id, created_at, 'entry_comment' AS type FROM entry_comment WHERE ap_id ILIKE :url) UNION (SELECT id, created_at, 'post' AS type FROM post WHERE ap_id ILIKE :url) UNION (SELECT id, created_at, 'post_comment' AS type FROM post_comment WHERE ap_id ILIKE :url) ORDER BY created_at DESC Parameters: [`"url" => "%https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede%"`] View formatted query View runnable query Explain query ( SELECT id, created_at, 'entry' AS type FROM entry WHERE ap_id ILIKE :url ) UNION ( SELECT id, created_at, 'entry_comment' AS type FROM entry_comment WHERE ap_id ILIKE :url ) UNION ( SELECT id, created_at, 'post' AS type FROM post WHERE ap_id ILIKE :url ) UNION ( SELECT id, created_at, 'post_comment' AS type FROM post_comment WHERE ap_id ILIKE :url ) ORDER BY created_at DESC (SELECT id, created_at, 'entry' AS type FROM entry WHERE ap_id ILIKE '%https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede%') UNION (SELECT id, created_at, 'entry_comment' AS type FROM entry_comment WHERE ap_id ILIKE '%https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede%') UNION (SELECT id, created_at, 'post' AS type FROM post WHERE ap_id ILIKE '%https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede%') UNION (SELECT id, created_at, 'post_comment' AS type FROM post_comment WHERE ap_id ILIKE '%https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede%') ORDER BY created_at DESC ;
2	69.56 ms	INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?) Parameters: ["{"payload":"{\"@context\":[\"https:\/\/www.w3.org\/ns\/activitystreams\",\"https:\/\/w3id.org\/security\/v1\",{\"RsaSignature2017\":\"https:\/\/w3id.org\/security#RsaSignature2017\"},{\"pt\":\"https:\/\/joinpeertube.org\/ns#\",\"sc\":\"http:\/\/schema.org\/\",\"Hashtag\":\"as:Hashtag\",\"category\":\"sc:category\",\"licence\":\"sc:license\",\"subtitleLanguage\":\"sc:subtitleLanguage\",\"automaticallyGenerated\":\"pt:automaticallyGenerated\",\"sensitive\":\"as:sensitive\",\"language\":\"sc:inLanguage\",\"identifier\":\"sc:identifier\",\"isLiveBroadcast\":\"sc:isLiveBroadcast\",\"liveSaveReplay\":{\"@type\":\"sc:Boolean\",\"@id\":\"pt:liveSaveReplay\"},\"permanentLive\":{\"@type\":\"sc:Boolean\",\"@id\":\"pt:permanentLive\"},\"latencyMode\":{\"@type\":\"sc:Number\",\"@id\":\"pt:latencyMode\"},\"Infohash\":\"pt:Infohash\",\"tileWidth\":{\"@type\":\"sc:Number\",\"@id\":\"pt:tileWidth\"},\"tileHeight\":{\"@type\":\"sc:Number\",\"@id\":\"pt:tileHeight\"},\"tileDuration\":{\"@type\":\"sc:Number\",\"@id\":\"pt:tileDuration\"},\"aspectRatio\":{\"@type\":\"sc:Float\",\"@id\":\"pt:aspectRatio\"},\"uuid\":{\"@type\":\"sc:identifier\",\"@id\":\"pt:uuid\"},\"originallyPublishedAt\":\"sc:datePublished\",\"uploadDate\":\"sc:uploadDate\",\"hasParts\":\"sc:hasParts\",\"views\":{\"@type\":\"sc:Number\",\"@id\":\"pt:views\"},\"state\":{\"@type\":\"sc:Number\",\"@id\":\"pt:state\"},\"size\":{\"@type\":\"sc:Number\",\"@id\":\"pt:size\"},\"fps\":{\"@type\":\"sc:Number\",\"@id\":\"pt:fps\"},\"commentsEnabled\":{\"@type\":\"sc:Boolean\",\"@id\":\"pt:commentsEnabled\"},\"canReply\":\"pt:canReply\",\"commentsPolicy\":{\"@type\":\"sc:Number\",\"@id\":\"pt:commentsPolicy\"},\"downloadEnabled\":{\"@type\":\"sc:Boolean\",\"@id\":\"pt:downloadEnabled\"},\"waitTranscoding\":{\"@type\":\"sc:Boolean\",\"@id\":\"pt:waitTranscoding\"},\"support\":{\"@type\":\"sc:Text\",\"@id\":\"pt:support\"},\"likes\":{\"@id\":\"as:likes\",\"@type\":\"@id\"},\"dislikes\":{\"@id\":\"as:dislikes\",\"@type\":\"@id\"},\"shares\":{\"@id\":\"as:shares\",\"@type\":\"@id\"},\"comments\":{\"@id\":\"as:comments\",\"@type\":\"@id\"},\"PropertyValue\":\"sc:PropertyValue\",\"value\":\"sc:value\"}],\"to\":[\"https:\/\/www.w3.org\/ns\/activitystreams#Public\"],\"cc\":[\"https:\/\/tinkerbetter.tube\/accounts\/vkc\/followers\"],\"type\":\"Video\",\"id\":\"https:\/\/tinkerbetter.tube\/videos\/watch\/545674bb-30c5-4668-b488-10c7d5829ede\",\"name\":\"OpenSSH is about to change. (For the better.)\",\"duration\":\"PT600S\",\"uuid\":\"545674bb-30c5-4668-b488-10c7d5829ede\",\"category\":{\"identifier\":\"15\",\"name\":\"Science & Technology\"},\"licence\":{\"identifier\":\"5\",\"name\":\"Attribution - Non Commercial - Share Alike\"},\"language\":{\"identifier\":\"en\",\"name\":\"English\"},\"views\":1245,\"sensitive\":false,\"waitTranscoding\":true,\"state\":1,\"commentsEnabled\":true,\"canReply\":null,\"commentsPolicy\":1,\"downloadEnabled\":true,\"published\":\"2023-12-01T15:38:10.448Z\",\"originallyPublishedAt\":null,\"updated\":\"2025-01-18T13:22:15.000Z\",\"tag\":[{\"type\":\"Hashtag\",\"name\":\"homelab\"},{\"type\":\"Hashtag\",\"name\":\"Linux\"},{\"type\":\"Hashtag\",\"name\":\"Open Source\"},{\"type\":\"Hashtag\",\"name\":\"OpenSSH\"},{\"type\":\"Hashtag\",\"name\":\"terminal\"}],\"mediaType\":\"text\/markdown\",\"content\":\"OpenSSH's `ssh-keygen` command just got a great upgrade.\\r\\n\\r\\nIn today's episode, I cover how Ed25519 keys are now the default, and how it probably doesn't impact your workflow. I'll briefly cover how the whole thing works, in an under 10 minute video. As per the custom in these parts, there's a few vintage computing goodies peppered throughout the episode.\\r\\n\\r\\n\ud83e\udef6 Support (how this channel makes money) \ud83e\udef6\\r\\n\\r\\nThis episode of Veronica Explains isn't sponsored by anyone other than you. Your support makes this show possible, and I appreciate your consideration. Supporters at the $2\/mo level get a weekly newsletter from me.\\r\\n\\r\\nhttps:\/\/patreon.com\/VeronicaExplains\\r\\nhttps:\/\/ko-fi.com\/VeronicaExplains\\r\\n\\r\\nYou can also buy nerdy shirts from my web store (it's not sponsorship, I literally host and maintain the web store myself, and my family designs the merch): https:\/\/vkc.sh\/merch.\\r\\n\\r\\n\ud83e\udd29 What I'm Watching! \ud83e\udd29\\r\\n\\r\\nMacintosh Librarian put out a great video about a Power Computing Macintosh clone recently that really caught my eye. I find the history of Apple, and Apple-adjacent technology fascinating, and if that's something you're into as well, Macintosh Librarian is worth your attention.\\r\\n\\r\\nHer recent video: https:\/\/www.youtube.com\/watch?v=FK-BkdnEF-8\\r\\nHer channel (which you should subscribe to): https:\/\/youtube.com\/MacintoshLibrarian \\r\\n\\r\\n\ud83d\udda5\ufe0f Commands used during the making of this video \ud83d\udda5\ufe0f\\r\\n`ssh-keygen` by itself: creates a default key in the default location (usually the .ssh folder inside the home directory).\\r\\n\\r\\nWith options, it gets more features. The `-t` option specifies the key type:\\r\\n-- `ssh-keygen -t rsa` generates an rsa key\\r\\n-- `ssh-keygen -t ed25519` generates an ed25519 key\\r\\n\\r\\nYou'll see me combine this with the `-f` option to specify the output file(s). So `ssh-keygen -f .ssh\/testkeylmde -t ed25519` would create a key pair in the .ssh folder with the filename \\\"testkeylmde\\\" (and \\\"testkeylmde.pub\\\" for the public file).\\r\\n\\r\\nYou can then use `ssh-copy-id` to transfer and set up the public keyfile on a server, so that your private key will work with it:\\r\\n\\r\\n`ssh-copy-id -i [path-to-public-key] [user][at][server]`\\r\\n\\r\\nAs I mentioned a few times, I have a more thorough OpenSSH video: https:\/\/www.youtube.com\/watch?v=3FKsdbjzBcc\\r\\n\\r\\nAnd for further reading about cryptography in general, here's some Wikipedia I referenced in the video:\\r\\n\\r\\n- RSA: https:\/\/en.wikipedia.org\/wiki\/RSA_(cryptosystem)\\r\\n- Curve25519 (where ed25519 gets its mathy bits from): https:\/\/en.wikipedia.org\/wiki\/Curve25519\\r\\n- The Twisted Edwards curve: https:\/\/en.wikipedia.org\/wiki\/Twisted_Edwards_curve\\r\\n- EdDSA (the section on Ed25519): https:\/\/en.wikipedia.org\/wiki\/EdDSA#Ed25519\\r\\n\\r\\n\ud83d\udcd6 Chapters \ud83d\udcd6\\r\\n0:00 News about OpenSSH!\\r\\n1:48 The basics of OpenSSH and ssh-keygen\\r\\n4:27 How does this change impact you?\\r\\n7:34 Now's a good time to prune your keys\\r\\n9:04 What I'm Watching: Macintosh Librarian\",\"support\":\"This channel has no recurring sponsorships or anything like that.\\r\\n\\r\\nIf you want to support Veronica Explains, the best way is through recurring channel memberships:\\r\\n\\r\\nhttps:\/\/patreon.com\/VeronicaExplains\\r\\nhttps:\/\/ko-fi.com\/VeronicaExplains\\r\\n\\r\\nYou can also buy a nerdy t-shirt at https:\/\/vkc.sh\/merch.\",\"subtitleLanguage\":[{\"identifier\":\"en\",\"name\":\"English\",\"automaticallyGenerated\":false,\"url\":\"https:\/\/tinkerbetter.tube\/lazy-static\/video-captions\/48227255-4503-4318-bb71-26d1e722ed40-en.vtt\"}],\"icon\":[{\"type\":\"Image\",\"url\":\"https:\/\/tinkerbetter.tube\/lazy-static\/thumbnails\/0b9e86a2-7558-435a-9452-a6cd95f99431.jpg\",\"mediaType\":\"image\/jpeg\",\"width\":280,\"height\":157},{\"type\":\"Image\",\"url\":\"https:\/\/tinkerbetter.tube\/lazy-static\/previews\/f7e92880-f31b-4d13-956b-12fcad3fd3b9.jpg\",\"mediaType\":\"image\/jpeg\",\"width\":850,\"height\":480}],\"preview\":[{\"type\":\"Image\",\"rel\":[\"storyboard\"],\"url\":[{\"mediaType\":\"image\/jpeg\",\"href\":\"https:\/\/tinkerbetter.tube\/lazy-static\/storyboards\/a000e1e4-4eb6-4e3d-adef-e7cf325975b4.jpg\",\"width\":1920,\"height\":1080,\"tileWidth\":192,\"tileHeight\":108,\"tileDuration\":\"PT6S\"}]}],\"aspectRatio\":null,\"url\":[{\"type\":\"Link\",\"mediaType\":\"text\/html\",\"href\":\"https:\/\/tinkerbetter.tube\/videos\/watch\/545674bb-30c5-4668-b488-10c7d5829ede\"},{\"type\":\"Link\",\"mediaType\":\"application\/x-mpegURL\",\"href\":\"https:\/\/tinkerbetter-tube.us-ord-1.linodeobjects.com\/streaming-playlists\/hls\/545674bb-30c5-4668-b488-10c7d5829ede\/b19628d1-9452-468a-9ac7-373a3454c619-master.m3u8\",\"tag\":[{\"type\":\"Infohash\",\"name\":\"cad1bccd6e13aaac71d693c9ee020945bacfb071\"},{\"type\":\"Infohash\",\"name\":\"bc083fb7c51b33a508fae759bfdf8548bdaa9cf9\"},{\"type\":\"Infohash\",\"name\":\"4459945c30b03288a0c838320023561b036aa799\"},{\"type\":\"Link\",\"name\":\"sha256\",\"mediaType\":\"application\/json\",\"href\":\"https:\/\/tinkerbetter-tube.us-ord-1.linodeobjects.com\/streaming-playlists\/hls\/545674bb-30c5-4668-b488-10c7d5829ede\/7c35c314-c64a-4208-ba0a-91933974d617-segments-sha256.json\"},{\"type\":\"Link\",\"mediaType\":\"video\/mp4\",\"href\":\"https:\/\/tinkerbetter-tube.us-ord-1.linodeobjects.com\/streaming-playlists\/hls\/545674bb-30c5-4668-b488-10c7d5829ede\/f7047a67-ccb1-4c16-88d3-942054b9eea0-2160-fragmented.mp4\",\"height\":2160,\"width\":3840,\"size\":788935551,\"fps\":30,\"attachment\":[{\"type\":\"PropertyValue\",\"name\":\"ffprobe_codec_type\",\"value\":\"audio\"},{\"type\":\"PropertyValue\",\"name\":\"ffprobe_codec_type\",\"value\":\"video\"},{\"type\":\"PropertyValue\",\"name\":\"peertube_format_flag\",\"value\":\"fragmented\"}]},{\"type\":\"Link\",\"rel\":[\"metadata\",\"video\/mp4\"],\"mediaType\":\"application\/json\",\"href\":\"https:\/\/tinkerbetter.tube\/api\/v1\/videos\/545674bb-30c5-4668-b488-10c7d5829ede\/metadata\/92757\",\"height\":2160,\"width\":3840,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"application\/x-bittorrent\",\"href\":\"https:\/\/tinkerbetter.tube\/lazy-static\/torrents\/60282197-e14b-4a06-98cf-6a86aed2c99b-2160-hls.torrent\",\"height\":2160,\"width\":3840,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"application\/x-bittorrent;x-scheme-handler\/magnet\",\"href\":\"magnet:?xs=https%3A%2F%2Ftinkerbetter.tube%2Flazy-static%2Ftorrents%2F60282197-e14b-4a06-98cf-6a86aed2c99b-2160-hls.torrent&xt=urn:btih:49f21a58e4087de58b04bc28fdd6c1edeadc2b8f&dn=OpenSSH+is+about+to+change.+(For+the+better.)&tr=https%3A%2F%2Ftinkerbetter.tube%2Ftracker%2Fannounce&tr=wss%3A%2F%2Ftinkerbetter.tube%3A443%2Ftracker%2Fsocket&ws=https%3A%2F%2Ftinkerbetter-tube.us-ord-1.linodeobjects.com%2Fstreaming-playlists%2Fhls%2F545674bb-30c5-4668-b488-10c7d5829ede%2Ff7047a67-ccb1-4c16-88d3-942054b9eea0-2160-fragmented.mp4\",\"height\":2160,\"width\":3840,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"video\/mp4\",\"href\":\"https:\/\/tinkerbetter-tube.us-ord-1.linodeobjects.com\/streaming-playlists\/hls\/545674bb-30c5-4668-b488-10c7d5829ede\/5e367d8f-b68f-4ea9-8f19-211b032d3f5c-1080-fragmented.mp4\",\"height\":1080,\"width\":1920,\"size\":189250880,\"fps\":30,\"attachment\":[{\"type\":\"PropertyValue\",\"name\":\"ffprobe_codec_type\",\"value\":\"audio\"},{\"type\":\"PropertyValue\",\"name\":\"ffprobe_codec_type\",\"value\":\"video\"},{\"type\":\"PropertyValue\",\"name\":\"peertube_format_flag\",\"value\":\"fragmented\"}]},{\"type\":\"Link\",\"rel\":[\"metadata\",\"video\/mp4\"],\"mediaType\":\"application\/json\",\"href\":\"https:\/\/tinkerbetter.tube\/api\/v1\/videos\/545674bb-30c5-4668-b488-10c7d5829ede\/metadata\/92759\",\"height\":1080,\"width\":1920,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"application\/x-bittorrent\",\"href\":\"https:\/\/tinkerbetter.tube\/lazy-static\/torrents\/d9cc551e-6dde-4dd1-9a50-b69cc61eb8f6-1080-hls.torrent\",\"height\":1080,\"width\":1920,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"application\/x-bittorrent;x-scheme-handler\/magnet\",\"href\":\"magnet:?xs=https%3A%2F%2Ftinkerbetter.tube%2Flazy-static%2Ftorrents%2Fd9cc551e-6dde-4dd1-9a50-b69cc61eb8f6-1080-hls.torrent&xt=urn:btih:a183a362962d65c948bc155ba962f72ce70113fb&dn=OpenSSH+is+about+to+change.+(For+the+better.)&tr=https%3A%2F%2Ftinkerbetter.tube%2Ftracker%2Fannounce&tr=wss%3A%2F%2Ftinkerbetter.tube%3A443%2Ftracker%2Fsocket&ws=https%3A%2F%2Ftinkerbetter-tube.us-ord-1.linodeobjects.com%2Fstreaming-playlists%2Fhls%2F545674bb-30c5-4668-b488-10c7d5829ede%2F5e367d8f-b68f-4ea9-8f19-211b032d3f5c-1080-fragmented.mp4\",\"height\":1080,\"width\":1920,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"video\/mp4\",\"href\":\"https:\/\/tinkerbetter-tube.us-ord-1.linodeobjects.com\/streaming-playlists\/hls\/545674bb-30c5-4668-b488-10c7d5829ede\/3e87d34e-b595-407f-be42-7e5f03b27ea9-480-fragmented.mp4\",\"height\":480,\"width\":854,\"size\":65924867,\"fps\":30,\"attachment\":[{\"type\":\"PropertyValue\",\"name\":\"ffprobe_codec_type\",\"value\":\"audio\"},{\"type\":\"PropertyValue\",\"name\":\"ffprobe_codec_type\",\"value\":\"video\"},{\"type\":\"PropertyValue\",\"name\":\"peertube_format_flag\",\"value\":\"fragmented\"}]},{\"type\":\"Link\",\"rel\":[\"metadata\",\"video\/mp4\"],\"mediaType\":\"application\/json\",\"href\":\"https:\/\/tinkerbetter.tube\/api\/v1\/videos\/545674bb-30c5-4668-b488-10c7d5829ede\/metadata\/92758\",\"height\":480,\"width\":854,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"application\/x-bittorrent\",\"href\":\"https:\/\/tinkerbetter.tube\/lazy-static\/torrents\/5edfd1c2-bbf6-4c06-9c77-86a18657f064-480-hls.torrent\",\"height\":480,\"width\":854,\"fps\":30},{\"type\":\"Link\",\"mediaType\":\"application\/x-bittorrent;x-scheme-handler\/magnet\",\"href\":\"magnet:?xs=https%3A%2F%2Ftinkerbetter.tube%2Flazy-static%2Ftorrents%2F5edfd1c2-bbf6-4c06-9c77-86a18657f064-480-hls.torrent&xt=urn:btih:cd46d4c699f114f13a9822b4bef51d3758630879&dn=OpenSSH+is+about+to+change.+(For+the+better.)&tr=https%3A%2F%2Ftinkerbetter.tube%2Ftracker%2Fannounce&tr=wss%3A%2F%2Ftinkerbetter.tube%3A443%2Ftracker%2Fsocket&ws=https%3A%2F%2Ftinkerbetter-tube.us-ord-1.linodeobjects.com%2Fstreaming-playlists%2Fhls%2F545674bb-30c5-4668-b488-10c7d5829ede%2F3e87d34e-b595-407f-be42-7e5f03b27ea9-480-fragmented.mp4\",\"height\":480,\"width\":854,\"fps\":30}]},{\"type\":\"Link\",\"name\":\"tracker-http\",\"rel\":[\"tracker\",\"http\"],\"href\":\"https:\/\/tinkerbetter.tube\/tracker\/announce\"},{\"type\":\"Link\",\"name\":\"tracker-websocket\",\"rel\":[\"tracker\",\"websocket\"],\"href\":\"wss:\/\/tinkerbetter.tube:443\/tracker\/socket\"}],\"likes\":\"https:\/\/tinkerbetter.tube\/videos\/watch\/545674bb-30c5-4668-b488-10c7d5829ede\/likes\",\"dislikes\":\"https:\/\/tinkerbetter.tube\/videos\/watch\/545674bb-30c5-4668-b488-10c7d5829ede\/dislikes\",\"shares\":\"https:\/\/tinkerbetter.tube\/videos\/watch\/545674bb-30c5-4668-b488-10c7d5829ede\/announces\",\"comments\":\"https:\/\/tinkerbetter.tube\/videos\/watch\/545674bb-30c5-4668-b488-10c7d5829ede\/comments\",\"hasParts\":\"https:\/\/tinkerbetter.tube\/videos\/watch\/545674bb-30c5-4668-b488-10c7d5829ede\/chapters\",\"attributedTo\":[{\"type\":\"Person\",\"id\":\"https:\/\/tinkerbetter.tube\/accounts\/vkc\"},{\"type\":\"Group\",\"id\":\"https:\/\/tinkerbetter.tube\/video-channels\/veronicaexplains\"}],\"isLiveBroadcast\":false,\"liveSaveReplay\":null,\"permanentLive\":null,\"latencyMode\":null}","request":null,"headers":null}" "{"type":"App\\Message\\ActivityPub\\Inbox\\ActivityMessage","X-Message-Stamp-Symfony\\Component\\Messenger\\Stamp\\BusNameStamp":"[{\"busName\":\"messenger.bus.default\"}]","Content-Type":"application\/json"}" "default" "2025-01-19 02:25:01" "2025-01-19 02:25:01"] View formatted query View runnable query Explain query INSERT INTO messenger_messages ( body, headers, queue_name, created_at, available_at ) VALUES (?, ?, ?, ?, ?) INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('{\"payload\":\"{\\\"@context\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\\\",\\\"https:\\/\\/w3id.org\\/security\\/v1\\\",{\\\"RsaSignature2017\\\":\\\"https:\\/\\/w3id.org\\/security#RsaSignature2017\\\"},{\\\"pt\\\":\\\"https:\\/\\/joinpeertube.org\\/ns#\\\",\\\"sc\\\":\\\"http:\\/\\/schema.org\\/\\\",\\\"Hashtag\\\":\\\"as:Hashtag\\\",\\\"category\\\":\\\"sc:category\\\",\\\"licence\\\":\\\"sc:license\\\",\\\"subtitleLanguage\\\":\\\"sc:subtitleLanguage\\\",\\\"automaticallyGenerated\\\":\\\"pt:automaticallyGenerated\\\",\\\"sensitive\\\":\\\"as:sensitive\\\",\\\"language\\\":\\\"sc:inLanguage\\\",\\\"identifier\\\":\\\"sc:identifier\\\",\\\"isLiveBroadcast\\\":\\\"sc:isLiveBroadcast\\\",\\\"liveSaveReplay\\\":{\\\"@type\\\":\\\"sc:Boolean\\\",\\\"@id\\\":\\\"pt:liveSaveReplay\\\"},\\\"permanentLive\\\":{\\\"@type\\\":\\\"sc:Boolean\\\",\\\"@id\\\":\\\"pt:permanentLive\\\"},\\\"latencyMode\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:latencyMode\\\"},\\\"Infohash\\\":\\\"pt:Infohash\\\",\\\"tileWidth\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:tileWidth\\\"},\\\"tileHeight\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:tileHeight\\\"},\\\"tileDuration\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:tileDuration\\\"},\\\"aspectRatio\\\":{\\\"@type\\\":\\\"sc:Float\\\",\\\"@id\\\":\\\"pt:aspectRatio\\\"},\\\"uuid\\\":{\\\"@type\\\":\\\"sc:identifier\\\",\\\"@id\\\":\\\"pt:uuid\\\"},\\\"originallyPublishedAt\\\":\\\"sc:datePublished\\\",\\\"uploadDate\\\":\\\"sc:uploadDate\\\",\\\"hasParts\\\":\\\"sc:hasParts\\\",\\\"views\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:views\\\"},\\\"state\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:state\\\"},\\\"size\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:size\\\"},\\\"fps\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:fps\\\"},\\\"commentsEnabled\\\":{\\\"@type\\\":\\\"sc:Boolean\\\",\\\"@id\\\":\\\"pt:commentsEnabled\\\"},\\\"canReply\\\":\\\"pt:canReply\\\",\\\"commentsPolicy\\\":{\\\"@type\\\":\\\"sc:Number\\\",\\\"@id\\\":\\\"pt:commentsPolicy\\\"},\\\"downloadEnabled\\\":{\\\"@type\\\":\\\"sc:Boolean\\\",\\\"@id\\\":\\\"pt:downloadEnabled\\\"},\\\"waitTranscoding\\\":{\\\"@type\\\":\\\"sc:Boolean\\\",\\\"@id\\\":\\\"pt:waitTranscoding\\\"},\\\"support\\\":{\\\"@type\\\":\\\"sc:Text\\\",\\\"@id\\\":\\\"pt:support\\\"},\\\"likes\\\":{\\\"@id\\\":\\\"as:likes\\\",\\\"@type\\\":\\\"@id\\\"},\\\"dislikes\\\":{\\\"@id\\\":\\\"as:dislikes\\\",\\\"@type\\\":\\\"@id\\\"},\\\"shares\\\":{\\\"@id\\\":\\\"as:shares\\\",\\\"@type\\\":\\\"@id\\\"},\\\"comments\\\":{\\\"@id\\\":\\\"as:comments\\\",\\\"@type\\\":\\\"@id\\\"},\\\"PropertyValue\\\":\\\"sc:PropertyValue\\\",\\\"value\\\":\\\"sc:value\\\"}],\\\"to\\\":[\\\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\\\"],\\\"cc\\\":[\\\"https:\\/\\/tinkerbetter.tube\\/accounts\\/vkc\\/followers\\\"],\\\"type\\\":\\\"Video\\\",\\\"id\\\":\\\"https:\\/\\/tinkerbetter.tube\\/videos\\/watch\\/545674bb-30c5-4668-b488-10c7d5829ede\\\",\\\"name\\\":\\\"OpenSSH is about to change. (For the better.)\\\",\\\"duration\\\":\\\"PT600S\\\",\\\"uuid\\\":\\\"545674bb-30c5-4668-b488-10c7d5829ede\\\",\\\"category\\\":{\\\"identifier\\\":\\\"15\\\",\\\"name\\\":\\\"Science & Technology\\\"},\\\"licence\\\":{\\\"identifier\\\":\\\"5\\\",\\\"name\\\":\\\"Attribution - Non Commercial - Share Alike\\\"},\\\"language\\\":{\\\"identifier\\\":\\\"en\\\",\\\"name\\\":\\\"English\\\"},\\\"views\\\":1245,\\\"sensitive\\\":false,\\\"waitTranscoding\\\":true,\\\"state\\\":1,\\\"commentsEnabled\\\":true,\\\"canReply\\\":null,\\\"commentsPolicy\\\":1,\\\"downloadEnabled\\\":true,\\\"published\\\":\\\"2023-12-01T15:38:10.448Z\\\",\\\"originallyPublishedAt\\\":null,\\\"updated\\\":\\\"2025-01-18T13:22:15.000Z\\\",\\\"tag\\\":[{\\\"type\\\":\\\"Hashtag\\\",\\\"name\\\":\\\"homelab\\\"},{\\\"type\\\":\\\"Hashtag\\\",\\\"name\\\":\\\"Linux\\\"},{\\\"type\\\":\\\"Hashtag\\\",\\\"name\\\":\\\"Open Source\\\"},{\\\"type\\\":\\\"Hashtag\\\",\\\"name\\\":\\\"OpenSSH\\\"},{\\\"type\\\":\\\"Hashtag\\\",\\\"name\\\":\\\"terminal\\\"}],\\\"mediaType\\\":\\\"text\\/markdown\\\",\\\"content\\\":\\\"OpenSSH\'s `ssh-keygen` command just got a great upgrade.\\\\r\\\\n\\\\r\\\\nIn today\'s episode, I cover how Ed25519 keys are now the default, and how it probably doesn\'t impact your workflow. I\'ll briefly cover how the whole thing works, in an under 10 minute video. As per the custom in these parts, there\'s a few vintage computing goodies peppered throughout the episode.\\\\r\\\\n\\\\r\\\\n\\ud83e\\udef6 Support (how this channel makes money) \\ud83e\\udef6\\\\r\\\\n\\\\r\\\\nThis episode of Veronica Explains isn\'t sponsored by anyone other than you. Your support makes this show possible, and I appreciate your consideration. Supporters at the $2\\/mo level get a weekly newsletter from me.\\\\r\\\\n\\\\r\\\\nhttps:\\/\\/patreon.com\\/VeronicaExplains\\\\r\\\\nhttps:\\/\\/ko-fi.com\\/VeronicaExplains\\\\r\\\\n\\\\r\\\\nYou can also buy nerdy shirts from my web store (it\'s not sponsorship, I literally host and maintain the web store myself, and my family designs the merch): https:\\/\\/vkc.sh\\/merch.\\\\r\\\\n\\\\r\\\\n\\ud83e\\udd29 What I\'m Watching! \\ud83e\\udd29\\\\r\\\\n\\\\r\\\\nMacintosh Librarian put out a great video about a Power Computing Macintosh clone recently that really caught my eye. I find the history of Apple, and Apple-adjacent technology fascinating, and if that\'s something you\'re into as well, Macintosh Librarian is worth your attention.\\\\r\\\\n\\\\r\\\\nHer recent video: https:\\/\\/www.youtube.com\\/watch?v=FK-BkdnEF-8\\\\r\\\\nHer channel (which you should subscribe to): https:\\/\\/youtube.com\\/MacintoshLibrarian \\\\r\\\\n\\\\r\\\\n\\ud83d\\udda5\\ufe0f Commands used during the making of this video \\ud83d\\udda5\\ufe0f\\\\r\\\\n`ssh-keygen` by itself: creates a default key in the default location (usually the .ssh folder inside the home directory).\\\\r\\\\n\\\\r\\\\nWith options, it gets more features. The `-t` option specifies the key type:\\\\r\\\\n-- `ssh-keygen -t rsa` generates an rsa key\\\\r\\\\n-- `ssh-keygen -t ed25519` generates an ed25519 key\\\\r\\\\n\\\\r\\\\nYou\'ll see me combine this with the `-f` option to specify the output file(s). So `ssh-keygen -f .ssh\\/testkeylmde -t ed25519` would create a key pair in the .ssh folder with the filename \\\\\\\"testkeylmde\\\\\\\" (and \\\\\\\"testkeylmde.pub\\\\\\\" for the public file).\\\\r\\\\n\\\\r\\\\nYou can then use `ssh-copy-id` to transfer and set up the public keyfile on a server, so that your private key will work with it:\\\\r\\\\n\\\\r\\\\n`ssh-copy-id -i [path-to-public-key] [user][at][server]`\\\\r\\\\n\\\\r\\\\nAs I mentioned a few times, I have a more thorough OpenSSH video: https:\\/\\/www.youtube.com\\/watch?v=3FKsdbjzBcc\\\\r\\\\n\\\\r\\\\nAnd for further reading about cryptography in general, here\'s some Wikipedia I referenced in the video:\\\\r\\\\n\\\\r\\\\n- RSA: https:\\/\\/en.wikipedia.org\\/wiki\\/RSA_(cryptosystem)\\\\r\\\\n- Curve25519 (where ed25519 gets its mathy bits from): https:\\/\\/en.wikipedia.org\\/wiki\\/Curve25519\\\\r\\\\n- The Twisted Edwards curve: https:\\/\\/en.wikipedia.org\\/wiki\\/Twisted_Edwards_curve\\\\r\\\\n- EdDSA (the section on Ed25519): https:\\/\\/en.wikipedia.org\\/wiki\\/EdDSA#Ed25519\\\\r\\\\n\\\\r\\\\n\\ud83d\\udcd6 Chapters \\ud83d\\udcd6\\\\r\\\\n0:00 News about OpenSSH!\\\\r\\\\n1:48 The basics of OpenSSH and ssh-keygen\\\\r\\\\n4:27 How does this change impact you?\\\\r\\\\n7:34 Now\'s a good time to prune your keys\\\\r\\\\n9:04 What I\'m Watching: Macintosh Librarian\\\",\\\"support\\\":\\\"This channel has no recurring sponsorships or anything like that.\\\\r\\\\n\\\\r\\\\nIf you want to support Veronica Explains, the best way is through recurring channel memberships:\\\\r\\\\n\\\\r\\\\nhttps:\\/\\/patreon.com\\/VeronicaExplains\\\\r\\\\nhttps:\\/\\/ko-fi.com\\/VeronicaExplains\\\\r\\\\n\\\\r\\\\nYou can also buy a nerdy t-shirt at https:\\/\\/vkc.sh\\/merch.\\\",\\\"subtitleLanguage\\\":[{\\\"identifier\\\":\\\"en\\\",\\\"name\\\":\\\"English\\\",\\\"automaticallyGenerated\\\":false,\\\"url\\\":\\\"https:\\/\\/tinkerbetter.tube\\/lazy-static\\/video-captions\\/48227255-4503-4318-bb71-26d1e722ed40-en.vtt\\\"}],\\\"icon\\\":[{\\\"type\\\":\\\"Image\\\",\\\"url\\\":\\\"https:\\/\\/tinkerbetter.tube\\/lazy-static\\/thumbnails\\/0b9e86a2-7558-435a-9452-a6cd95f99431.jpg\\\",\\\"mediaType\\\":\\\"image\\/jpeg\\\",\\\"width\\\":280,\\\"height\\\":157},{\\\"type\\\":\\\"Image\\\",\\\"url\\\":\\\"https:\\/\\/tinkerbetter.tube\\/lazy-static\\/previews\\/f7e92880-f31b-4d13-956b-12fcad3fd3b9.jpg\\\",\\\"mediaType\\\":\\\"image\\/jpeg\\\",\\\"width\\\":850,\\\"height\\\":480}],\\\"preview\\\":[{\\\"type\\\":\\\"Image\\\",\\\"rel\\\":[\\\"storyboard\\\"],\\\"url\\\":[{\\\"mediaType\\\":\\\"image\\/jpeg\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/lazy-static\\/storyboards\\/a000e1e4-4eb6-4e3d-adef-e7cf325975b4.jpg\\\",\\\"width\\\":1920,\\\"height\\\":1080,\\\"tileWidth\\\":192,\\\"tileHeight\\\":108,\\\"tileDuration\\\":\\\"PT6S\\\"}]}],\\\"aspectRatio\\\":null,\\\"url\\\":[{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"text\\/html\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/videos\\/watch\\/545674bb-30c5-4668-b488-10c7d5829ede\\\"},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"application\\/x-mpegURL\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter-tube.us-ord-1.linodeobjects.com\\/streaming-playlists\\/hls\\/545674bb-30c5-4668-b488-10c7d5829ede\\/b19628d1-9452-468a-9ac7-373a3454c619-master.m3u8\\\",\\\"tag\\\":[{\\\"type\\\":\\\"Infohash\\\",\\\"name\\\":\\\"cad1bccd6e13aaac71d693c9ee020945bacfb071\\\"},{\\\"type\\\":\\\"Infohash\\\",\\\"name\\\":\\\"bc083fb7c51b33a508fae759bfdf8548bdaa9cf9\\\"},{\\\"type\\\":\\\"Infohash\\\",\\\"name\\\":\\\"4459945c30b03288a0c838320023561b036aa799\\\"},{\\\"type\\\":\\\"Link\\\",\\\"name\\\":\\\"sha256\\\",\\\"mediaType\\\":\\\"application\\/json\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter-tube.us-ord-1.linodeobjects.com\\/streaming-playlists\\/hls\\/545674bb-30c5-4668-b488-10c7d5829ede\\/7c35c314-c64a-4208-ba0a-91933974d617-segments-sha256.json\\\"},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"video\\/mp4\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter-tube.us-ord-1.linodeobjects.com\\/streaming-playlists\\/hls\\/545674bb-30c5-4668-b488-10c7d5829ede\\/f7047a67-ccb1-4c16-88d3-942054b9eea0-2160-fragmented.mp4\\\",\\\"height\\\":2160,\\\"width\\\":3840,\\\"size\\\":788935551,\\\"fps\\\":30,\\\"attachment\\\":[{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"ffprobe_codec_type\\\",\\\"value\\\":\\\"audio\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"ffprobe_codec_type\\\",\\\"value\\\":\\\"video\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"peertube_format_flag\\\",\\\"value\\\":\\\"fragmented\\\"}]},{\\\"type\\\":\\\"Link\\\",\\\"rel\\\":[\\\"metadata\\\",\\\"video\\/mp4\\\"],\\\"mediaType\\\":\\\"application\\/json\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/api\\/v1\\/videos\\/545674bb-30c5-4668-b488-10c7d5829ede\\/metadata\\/92757\\\",\\\"height\\\":2160,\\\"width\\\":3840,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"application\\/x-bittorrent\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/lazy-static\\/torrents\\/60282197-e14b-4a06-98cf-6a86aed2c99b-2160-hls.torrent\\\",\\\"height\\\":2160,\\\"width\\\":3840,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"application\\/x-bittorrent;x-scheme-handler\\/magnet\\\",\\\"href\\\":\\\"magnet:?xs=https%3A%2F%2Ftinkerbetter.tube%2Flazy-static%2Ftorrents%2F60282197-e14b-4a06-98cf-6a86aed2c99b-2160-hls.torrent&xt=urn:btih:49f21a58e4087de58b04bc28fdd6c1edeadc2b8f&dn=OpenSSH+is+about+to+change.+(For+the+better.)&tr=https%3A%2F%2Ftinkerbetter.tube%2Ftracker%2Fannounce&tr=wss%3A%2F%2Ftinkerbetter.tube%3A443%2Ftracker%2Fsocket&ws=https%3A%2F%2Ftinkerbetter-tube.us-ord-1.linodeobjects.com%2Fstreaming-playlists%2Fhls%2F545674bb-30c5-4668-b488-10c7d5829ede%2Ff7047a67-ccb1-4c16-88d3-942054b9eea0-2160-fragmented.mp4\\\",\\\"height\\\":2160,\\\"width\\\":3840,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"video\\/mp4\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter-tube.us-ord-1.linodeobjects.com\\/streaming-playlists\\/hls\\/545674bb-30c5-4668-b488-10c7d5829ede\\/5e367d8f-b68f-4ea9-8f19-211b032d3f5c-1080-fragmented.mp4\\\",\\\"height\\\":1080,\\\"width\\\":1920,\\\"size\\\":189250880,\\\"fps\\\":30,\\\"attachment\\\":[{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"ffprobe_codec_type\\\",\\\"value\\\":\\\"audio\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"ffprobe_codec_type\\\",\\\"value\\\":\\\"video\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"peertube_format_flag\\\",\\\"value\\\":\\\"fragmented\\\"}]},{\\\"type\\\":\\\"Link\\\",\\\"rel\\\":[\\\"metadata\\\",\\\"video\\/mp4\\\"],\\\"mediaType\\\":\\\"application\\/json\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/api\\/v1\\/videos\\/545674bb-30c5-4668-b488-10c7d5829ede\\/metadata\\/92759\\\",\\\"height\\\":1080,\\\"width\\\":1920,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"application\\/x-bittorrent\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/lazy-static\\/torrents\\/d9cc551e-6dde-4dd1-9a50-b69cc61eb8f6-1080-hls.torrent\\\",\\\"height\\\":1080,\\\"width\\\":1920,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"application\\/x-bittorrent;x-scheme-handler\\/magnet\\\",\\\"href\\\":\\\"magnet:?xs=https%3A%2F%2Ftinkerbetter.tube%2Flazy-static%2Ftorrents%2Fd9cc551e-6dde-4dd1-9a50-b69cc61eb8f6-1080-hls.torrent&xt=urn:btih:a183a362962d65c948bc155ba962f72ce70113fb&dn=OpenSSH+is+about+to+change.+(For+the+better.)&tr=https%3A%2F%2Ftinkerbetter.tube%2Ftracker%2Fannounce&tr=wss%3A%2F%2Ftinkerbetter.tube%3A443%2Ftracker%2Fsocket&ws=https%3A%2F%2Ftinkerbetter-tube.us-ord-1.linodeobjects.com%2Fstreaming-playlists%2Fhls%2F545674bb-30c5-4668-b488-10c7d5829ede%2F5e367d8f-b68f-4ea9-8f19-211b032d3f5c-1080-fragmented.mp4\\\",\\\"height\\\":1080,\\\"width\\\":1920,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"video\\/mp4\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter-tube.us-ord-1.linodeobjects.com\\/streaming-playlists\\/hls\\/545674bb-30c5-4668-b488-10c7d5829ede\\/3e87d34e-b595-407f-be42-7e5f03b27ea9-480-fragmented.mp4\\\",\\\"height\\\":480,\\\"width\\\":854,\\\"size\\\":65924867,\\\"fps\\\":30,\\\"attachment\\\":[{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"ffprobe_codec_type\\\",\\\"value\\\":\\\"audio\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"ffprobe_codec_type\\\",\\\"value\\\":\\\"video\\\"},{\\\"type\\\":\\\"PropertyValue\\\",\\\"name\\\":\\\"peertube_format_flag\\\",\\\"value\\\":\\\"fragmented\\\"}]},{\\\"type\\\":\\\"Link\\\",\\\"rel\\\":[\\\"metadata\\\",\\\"video\\/mp4\\\"],\\\"mediaType\\\":\\\"application\\/json\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/api\\/v1\\/videos\\/545674bb-30c5-4668-b488-10c7d5829ede\\/metadata\\/92758\\\",\\\"height\\\":480,\\\"width\\\":854,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"application\\/x-bittorrent\\\",\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/lazy-static\\/torrents\\/5edfd1c2-bbf6-4c06-9c77-86a18657f064-480-hls.torrent\\\",\\\"height\\\":480,\\\"width\\\":854,\\\"fps\\\":30},{\\\"type\\\":\\\"Link\\\",\\\"mediaType\\\":\\\"application\\/x-bittorrent;x-scheme-handler\\/magnet\\\",\\\"href\\\":\\\"magnet:?xs=https%3A%2F%2Ftinkerbetter.tube%2Flazy-static%2Ftorrents%2F5edfd1c2-bbf6-4c06-9c77-86a18657f064-480-hls.torrent&xt=urn:btih:cd46d4c699f114f13a9822b4bef51d3758630879&dn=OpenSSH+is+about+to+change.+(For+the+better.)&tr=https%3A%2F%2Ftinkerbetter.tube%2Ftracker%2Fannounce&tr=wss%3A%2F%2Ftinkerbetter.tube%3A443%2Ftracker%2Fsocket&ws=https%3A%2F%2Ftinkerbetter-tube.us-ord-1.linodeobjects.com%2Fstreaming-playlists%2Fhls%2F545674bb-30c5-4668-b488-10c7d5829ede%2F3e87d34e-b595-407f-be42-7e5f03b27ea9-480-fragmented.mp4\\\",\\\"height\\\":480,\\\"width\\\":854,\\\"fps\\\":30}]},{\\\"type\\\":\\\"Link\\\",\\\"name\\\":\\\"tracker-http\\\",\\\"rel\\\":[\\\"tracker\\\",\\\"http\\\"],\\\"href\\\":\\\"https:\\/\\/tinkerbetter.tube\\/tracker\\/announce\\\"},{\\\"type\\\":\\\"Link\\\",\\\"name\\\":\\\"tracker-websocket\\\",\\\"rel\\\":[\\\"tracker\\\",\\\"websocket\\\"],\\\"href\\\":\\\"wss:\\/\\/tinkerbetter.tube:443\\/tracker\\/socket\\\"}],\\\"likes\\\":\\\"https:\\/\\/tinkerbetter.tube\\/videos\\/watch\\/545674bb-30c5-4668-b488-10c7d5829ede\\/likes\\\",\\\"dislikes\\\":\\\"https:\\/\\/tinkerbetter.tube\\/videos\\/watch\\/545674bb-30c5-4668-b488-10c7d5829ede\\/dislikes\\\",\\\"shares\\\":\\\"https:\\/\\/tinkerbetter.tube\\/videos\\/watch\\/545674bb-30c5-4668-b488-10c7d5829ede\\/announces\\\",\\\"comments\\\":\\\"https:\\/\\/tinkerbetter.tube\\/videos\\/watch\\/545674bb-30c5-4668-b488-10c7d5829ede\\/comments\\\",\\\"hasParts\\\":\\\"https:\\/\\/tinkerbetter.tube\\/videos\\/watch\\/545674bb-30c5-4668-b488-10c7d5829ede\\/chapters\\\",\\\"attributedTo\\\":[{\\\"type\\\":\\\"Person\\\",\\\"id\\\":\\\"https:\\/\\/tinkerbetter.tube\\/accounts\\/vkc\\\"},{\\\"type\\\":\\\"Group\\\",\\\"id\\\":\\\"https:\\/\\/tinkerbetter.tube\\/video-channels\\/veronicaexplains\\\"}],\\\"isLiveBroadcast\\\":false,\\\"liveSaveReplay\\\":null,\\\"permanentLive\\\":null,\\\"latencyMode\\\":null}\",\"request\":null,\"headers\":null}', '{\"type\":\"App\\\\Message\\\\ActivityPub\\\\Inbox\\\\ActivityMessage\",\"X-Message-Stamp-Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\":\"[{\\\"busName\\\":\\\"messenger.bus.default\\\"}]\",\"Content-Type\":\"application\\/json\"}', 'default', '2025-01-19 02:25:01', '2025-01-19 02:25:01');
3	34.02 ms	( SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type FROM entry INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id INNER JOIN "user" u_entry ON entry.user_id = u_entry.id WHERE entry.visibility = :visibility AND m_entry.visibility = :visibility AND entry.body_ts @@ plainto_tsquery( :search ) = true AND entry.is_adult = false AND m_entry.is_adult = false AND (entry.created_at BETWEEN :timeFrom AND :timeTo) ) UNION ( SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type FROM post INNER JOIN magazine m_post ON post.magazine_id = m_post.id INNER JOIN "user" u_post ON post.user_id = u_post.id WHERE post.visibility = :visibility AND m_post.visibility = :visibility AND post.body_ts @@ plainto_tsquery( :search ) = true AND post.is_adult = false AND m_post.is_adult = false AND (post.created_at BETWEEN :timeFrom AND :timeTo) ) UNION ( SELECT entry_comment.id, entry_comment.created_at, entry_comment.score, entry_comment.score + entry_comment.favourite_count AS ranking, entry_comment.last_active, 0 as comment_count, 'entry_comment' AS type FROM entry_comment INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id WHERE entry_comment.visibility = :visibility AND m_entry_comment.visibility = :visibility AND entry_comment.body_ts @@ plainto_tsquery( :search ) = true AND entry_comment.is_adult = false AND m_entry_comment.is_adult = false AND (entry_comment.created_at BETWEEN :timeFrom AND :timeTo) ) UNION ( SELECT post_comment.id, post_comment.created_at, post_comment.score, post_comment.score + post_comment.favourite_count AS ranking, post_comment.last_active, 0 as comment_count, 'post_comment' AS type FROM post_comment INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id WHERE post_comment.visibility = :visibility AND m_post_comment.visibility = :visibility AND post_comment.body_ts @@ plainto_tsquery( :search ) = true AND post_comment.is_adult = false AND m_post_comment.is_adult = false AND (post_comment.created_at BETWEEN :timeFrom AND :timeTo) ) ORDER BY last_active DESC, created_at DESC LIMIT 25000 Parameters: [`"visibility" => "visible" "timeFrom" => "2024-01-19 02:25:01" "timeTo" => "2025-01-19 02:25:01" "search" => "https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede"`] View formatted query View runnable query Explain query ( SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type FROM entry INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id INNER JOIN "user" u_entry ON entry.user_id = u_entry.id WHERE entry.visibility = :visibility AND m_entry.visibility = :visibility AND entry.body_ts @@ plainto_tsquery(:search) = true AND entry.is_adult = false AND m_entry.is_adult = false AND ( entry.created_at BETWEEN :timeFrom AND :timeTo ) ) UNION ( SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type FROM post INNER JOIN magazine m_post ON post.magazine_id = m_post.id INNER JOIN "user" u_post ON post.user_id = u_post.id WHERE post.visibility = :visibility AND m_post.visibility = :visibility AND post.body_ts @@ plainto_tsquery(:search) = true AND post.is_adult = false AND m_post.is_adult = false AND ( post.created_at BETWEEN :timeFrom AND :timeTo ) ) UNION ( SELECT entry_comment.id, entry_comment.created_at, entry_comment.score, entry_comment.score + entry_comment.favourite_count AS ranking, entry_comment.last_active, 0 as comment_count, 'entry_comment' AS type FROM entry_comment INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id WHERE entry_comment.visibility = :visibility AND m_entry_comment.visibility = :visibility AND entry_comment.body_ts @@ plainto_tsquery(:search) = true AND entry_comment.is_adult = false AND m_entry_comment.is_adult = false AND ( entry_comment.created_at BETWEEN :timeFrom AND :timeTo ) ) UNION ( SELECT post_comment.id, post_comment.created_at, post_comment.score, post_comment.score + post_comment.favourite_count AS ranking, post_comment.last_active, 0 as comment_count, 'post_comment' AS type FROM post_comment INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id WHERE post_comment.visibility = :visibility AND m_post_comment.visibility = :visibility AND post_comment.body_ts @@ plainto_tsquery(:search) = true AND post_comment.is_adult = false AND m_post_comment.is_adult = false AND ( post_comment.created_at BETWEEN :timeFrom AND :timeTo ) ) ORDER BY last_active DESC, created_at DESC LIMIT 25000 ( SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type FROM entry INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id INNER JOIN "user" u_entry ON entry.user_id = u_entry.id WHERE entry.visibility = 'visible' AND m_entry.visibility = 'visible' AND entry.body_ts @@ plainto_tsquery( 'https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede' ) = true AND entry.is_adult = false AND m_entry.is_adult = false AND (entry.created_at BETWEEN '2024-01-19 02:25:01' AND '2025-01-19 02:25:01') ) UNION ( SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type FROM post INNER JOIN magazine m_post ON post.magazine_id = m_post.id INNER JOIN "user" u_post ON post.user_id = u_post.id WHERE post.visibility = 'visible' AND m_post.visibility = 'visible' AND post.body_ts @@ plainto_tsquery( 'https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede' ) = true AND post.is_adult = false AND m_post.is_adult = false AND (post.created_at BETWEEN '2024-01-19 02:25:01' AND '2025-01-19 02:25:01') ) UNION ( SELECT entry_comment.id, entry_comment.created_at, entry_comment.score, entry_comment.score + entry_comment.favourite_count AS ranking, entry_comment.last_active, 0 as comment_count, 'entry_comment' AS type FROM entry_comment INNER JOIN magazine m_entry_comment ON entry_comment.magazine_id = m_entry_comment.id INNER JOIN "user" u_entry_comment ON entry_comment.user_id = u_entry_comment.id WHERE entry_comment.visibility = 'visible' AND m_entry_comment.visibility = 'visible' AND entry_comment.body_ts @@ plainto_tsquery( 'https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede' ) = true AND entry_comment.is_adult = false AND m_entry_comment.is_adult = false AND (entry_comment.created_at BETWEEN '2024-01-19 02:25:01' AND '2025-01-19 02:25:01') ) UNION ( SELECT post_comment.id, post_comment.created_at, post_comment.score, post_comment.score + post_comment.favourite_count AS ranking, post_comment.last_active, 0 as comment_count, 'post_comment' AS type FROM post_comment INNER JOIN magazine m_post_comment ON post_comment.magazine_id = m_post_comment.id INNER JOIN "user" u_post_comment ON post_comment.user_id = u_post_comment.id WHERE post_comment.visibility = 'visible' AND m_post_comment.visibility = 'visible' AND post_comment.body_ts @@ plainto_tsquery( 'https://tinkerbetter.tube/videos/watch/545674bb-30c5-4668-b488-10c7d5829ede' ) = true AND post_comment.is_adult = false AND m_post_comment.is_adult = false AND (post_comment.created_at BETWEEN '2024-01-19 02:25:01' AND '2025-01-19 02:25:01') ) ORDER BY last_active DESC, created_at DESC LIMIT 25000;
4	2.49 ms	SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (NULL) Parameters: [] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (NULL) SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (NULL);
5	6.49 ms	SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL) Parameters: [] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL) SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL);
6	17.32 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id IN (NULL) Parameters: [] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id IN (NULL) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.score AS score_5, t0.last_active AS last_active_6, t0.ip AS ip_7, t0.tags AS tags_8, t0.mentions AS mentions_9, t0.id AS id_10, t0.body_ts AS body_ts_11, t0.up_votes AS up_votes_12, t0.down_votes AS down_votes_13, t0.visibility AS visibility_14, t0.ap_id AS ap_id_15, t0.edited_at AS edited_at_16, t0.created_at AS created_at_17, t0.user_id AS user_id_18, t0.entry_id AS entry_id_19, t0.magazine_id AS magazine_id_20, t0.image_id AS image_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23 FROM entry_comment t0 WHERE t0.id IN (NULL);
7	8.23 ms	SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id IN (NULL) Parameters: [] View formatted query View runnable query Explain query SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id IN (NULL) SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.id IN (NULL);

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

18 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
app_entity_settings	16
app_entity_magazine	2

Entities Mapping

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\Entry	No errors.
App\Entity\User	No errors.
App\Entity\Magazine	No errors.
App\Entity\Image	No errors.
App\Entity\Domain	No errors.
App\Entity\Post	No errors.
App\Entity\EntryComment	No errors.
App\Entity\PostComment	No errors.
App\Entity\Moderator	No errors.
App\Entity\MagazineOwnershipRequest	No errors.
App\Entity\ModeratorRequest	No errors.
App\Entity\MagazineSubscription	No errors.
App\Entity\MagazineBan	No errors.
App\Entity\Report	No errors.
App\Entity\Badge	No errors.
App\Entity\MagazineLog	No errors.
App\Entity\Award	No errors.
App\Entity\CategoryMagazine	No errors.

Symfony Profiler

GET https://kbin.spritesserver.nl/search/active/1y?q=https%3A%2F%2Ftinkerbetter.tube%2Fvideos%2Fwatch%2F545674bb-30c5-4668-b488-10c7d5829ede

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Entities Mapping