1
0.34 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . image AS image_3 , t0 . caption AS caption_4 , t0 . upload_date AS upload_date_5 , t0 . deleted_date AS deleted_date_6 , t0 . views AS views_7 , t0 . type AS type_8 , t0 . video_guid AS video_guid_9 , t0 . video_duration AS video_duration_10 , t0 . video_thumbnail AS video_thumbnail_11 , t0 . likes AS likes_12 , t0 . slug AS slug_13 , t0 . redgif_id AS redgif_id_14 , t0 . rating AS rating_15 , t0 . user_id AS user_id_16 FROM post t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"asdasdasd "
]
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . image AS image_3 , t0 . caption AS caption_4 , t0 . upload_date AS upload_date_5 , t0 . deleted_date AS deleted_date_6 , t0 . views AS views_7 , t0 . type AS type_8 , t0 . video_guid AS video_guid_9 , t0 . video_duration AS video_duration_10 , t0 . video_thumbnail AS video_thumbnail_11 , t0 . likes AS likes_12 , t0 . slug AS slug_13 , t0 . redgif_id AS redgif_id_14 , t0 . rating AS rating_15 , t0 . user_id AS user_id_16 FROM post t0 WHERE t0 . slug = 'asdasdasd' LIMIT 1 ;
Copy
2
0.08 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
3
0.20 ms
UPDATE post SET views = ? WHERE id = ?
UPDATE post SET views = 23 WHERE id = 22 ;
Copy
4
0.07 ms
"COMMIT"
5
0.28 ms
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . image AS image_2 , p0_ . caption AS caption_3 , p0_ . upload_date AS upload_date_4 , p0_ . deleted_date AS deleted_date_5 , p0_ . views AS views_6 , p0_ . type AS type_7 , p0_ . video_guid AS video_guid_8 , p0_ . video_duration AS video_duration_9 , p0_ . video_thumbnail AS video_thumbnail_10 , p0_ . likes AS likes_11 , p0_ . slug AS slug_12 , p0_ . redgif_id AS redgif_id_13 , p0_ . rating AS rating_14 , p0_ . user_id AS user_id_15 FROM post p0_ LEFT JOIN `user` u1_ ON p0_ . user_id = u1_ . id WHERE p0_ . upload_date < ? AND p0_ . deleted_date IS NULL AND u1_ . is_active = 1 ORDER BY p0_ . upload_date DESC LIMIT 1
Parameters :
[
"2026-03-15 17:34:27 "
]
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . image AS image_2 , p0_ . caption AS caption_3 , p0_ . upload_date AS upload_date_4 , p0_ . deleted_date AS deleted_date_5 , p0_ . views AS views_6 , p0_ . type AS type_7 , p0_ . video_guid AS video_guid_8 , p0_ . video_duration AS video_duration_9 , p0_ . video_thumbnail AS video_thumbnail_10 , p0_ . likes AS likes_11 , p0_ . slug AS slug_12 , p0_ . redgif_id AS redgif_id_13 , p0_ . rating AS rating_14 , p0_ . user_id AS user_id_15 FROM post p0_ LEFT JOIN `user` u1_ ON p0_ . user_id = u1_ . id WHERE p0_ . upload_date < '2026-03-15 17:34:27' AND p0_ . deleted_date IS NULL AND u1_ . is_active = 1 ORDER BY p0_ . upload_date DESC LIMIT 1 ;
Copy
6
0.18 ms
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . image AS image_2 , p0_ . caption AS caption_3 , p0_ . upload_date AS upload_date_4 , p0_ . deleted_date AS deleted_date_5 , p0_ . views AS views_6 , p0_ . type AS type_7 , p0_ . video_guid AS video_guid_8 , p0_ . video_duration AS video_duration_9 , p0_ . video_thumbnail AS video_thumbnail_10 , p0_ . likes AS likes_11 , p0_ . slug AS slug_12 , p0_ . redgif_id AS redgif_id_13 , p0_ . rating AS rating_14 , p0_ . user_id AS user_id_15 FROM post p0_ LEFT JOIN `user` u1_ ON p0_ . user_id = u1_ . id WHERE p0_ . upload_date > ? AND p0_ . deleted_date IS NULL AND u1_ . is_active = 1 ORDER BY p0_ . upload_date ASC LIMIT 1
Parameters :
[
"2026-03-15 17:34:27 "
]
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . image AS image_2 , p0_ . caption AS caption_3 , p0_ . upload_date AS upload_date_4 , p0_ . deleted_date AS deleted_date_5 , p0_ . views AS views_6 , p0_ . type AS type_7 , p0_ . video_guid AS video_guid_8 , p0_ . video_duration AS video_duration_9 , p0_ . video_thumbnail AS video_thumbnail_10 , p0_ . likes AS likes_11 , p0_ . slug AS slug_12 , p0_ . redgif_id AS redgif_id_13 , p0_ . rating AS rating_14 , p0_ . user_id AS user_id_15 FROM post p0_ LEFT JOIN `user` u1_ ON p0_ . user_id = u1_ . id WHERE p0_ . upload_date > '2026-03-15 17:34:27' AND p0_ . deleted_date IS NULL AND u1_ . is_active = 1 ORDER BY p0_ . upload_date ASC LIMIT 1 ;
Copy
7
0.17 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . popularity AS popularity_4 , t0 . last_used_at AS last_used_at_5 , t0 . category_id AS category_id_6 FROM tag t0 INNER JOIN post_tag ON t0 . id = post_tag . tag_id WHERE post_tag . post_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . popularity AS popularity_4 , t0 . last_used_at AS last_used_at_5 , t0 . category_id AS category_id_6 FROM tag t0 INNER JOIN post_tag ON t0 . id = post_tag . tag_id WHERE post_tag . post_id = 22 ;
Copy
8
0.14 ms
SELECT COUNT (f0_ . id ) AS sclr_0 FROM follow f0_ WHERE f0_ . type = ? AND f0_ . target_id = ?
SELECT COUNT (f0_ . id ) AS sclr_0 FROM follow f0_ WHERE f0_ . type = 'user' AND f0_ . target_id = 5 ;
Copy
9
0.13 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . username AS username_5 , t0 . is_verified AS is_verified_6 , t0 . avatar AS avatar_7 , t0 . banner AS banner_8 , t0 . bio AS bio_9 , t0 . location AS location_10 , t0 . is_active AS is_active_11 , t0 . premium_until AS premium_until_12 , t0 . points AS points_13 , t0 . rank_id AS rank_id_14 FROM `user` t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . username AS username_5 , t0 . is_verified AS is_verified_6 , t0 . avatar AS avatar_7 , t0 . banner AS banner_8 , t0 . bio AS bio_9 , t0 . location AS location_10 , t0 . is_active AS is_active_11 , t0 . premium_until AS premium_until_12 , t0 . points AS points_13 , t0 . rank_id AS rank_id_14 FROM `user` t0 WHERE t0 . id = 5 ;
Copy
10
0.13 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . post_id AS post_id_3 , t0 . user_id AS user_id_4 FROM post_like t0 WHERE t0 . post_id = ?
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . post_id AS post_id_3 , t0 . user_id AS user_id_4 FROM post_like t0 WHERE t0 . post_id = 22 ;
Copy
11
0.09 ms
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . post_id AS post_id_4 , t0 . user_id AS user_id_5 FROM comment t0 WHERE t0 . post_id = ?
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . post_id AS post_id_4 , t0 . user_id AS user_id_5 FROM comment t0 WHERE t0 . post_id = 22 ;
Copy