1
0.91 ms
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM post p0_ WHERE p0_ . is_published = ? AND p0_ . post_at < = ?
Parameters :
[
1
"2026-01-11 10:02:15 "
]
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM post p0_ WHERE p0_ . is_published = 1 AND p0_ . post_at < = '2026-01-11 10:02:15' ;
Copy
2
0.37 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . post_at AS post_at_1 FROM post p0_ WHERE p0_ . is_published = ? AND p0_ . post_at < = ? ORDER BY p0_ . post_at DESC LIMIT 6
Parameters :
[
1
"2026-01-11 10:02:15 "
]
SELECT DISTINCT p0_ . id AS id_0 , p0_ . post_at AS post_at_1 FROM post p0_ WHERE p0_ . is_published = 1 AND p0_ . post_at < = '2026-01-11 10:02:15' ORDER BY p0_ . post_at DESC LIMIT 6 ;
Copy
3
0.50 ms
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . content AS content_2 , p0_ . featured_image AS featured_image_3 , p0_ . created_at AS created_at_4 , p0_ . updated_at AS updated_at_5 , p0_ . post_at AS post_at_6 , p0_ . is_published AS is_published_7 , p0_ . author_id AS author_id_8 , p0_ . updated_by_id AS updated_by_id_9 FROM post p0_ WHERE p0_ . is_published = ? AND p0_ . post_at < = ? AND p0_ . id IN (? , ? , ? , ? , ? , ? ) ORDER BY p0_ . post_at DESC
Parameters :
[
1
"2026-01-11 10:02:15 "
14
12
11
10
9
8
]
SELECT p0_ . id AS id_0 , p0_ . title AS title_1 , p0_ . content AS content_2 , p0_ . featured_image AS featured_image_3 , p0_ . created_at AS created_at_4 , p0_ . updated_at AS updated_at_5 , p0_ . post_at AS post_at_6 , p0_ . is_published AS is_published_7 , p0_ . author_id AS author_id_8 , p0_ . updated_by_id AS updated_by_id_9 FROM post p0_ WHERE p0_ . is_published = 1 AND p0_ . post_at < = '2026-01-11 10:02:15' AND p0_ . id IN (14 , 12 , 11 , 10 , 9 , 8 ) ORDER BY p0_ . post_at DESC ;
Copy
4
0.36 ms
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 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 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0 . post_id = 14 ;
Copy
5
0.17 ms
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 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 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0 . post_id = 12 ;
Copy
6
0.17 ms
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 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 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0 . post_id = 11 ;
Copy
7
0.16 ms
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 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 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0 . post_id = 10 ;
Copy
8
0.14 ms
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 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 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0 . post_id = 9 ;
Copy
9
0.13 ms
SELECT t0 . id AS id_1 , t0 . content AS content_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 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 . updated_at AS updated_at_4 , t0 . is_approved AS is_approved_5 , t0 . author_id AS author_id_6 , t0 . post_id AS post_id_7 , t0 . updated_by_id AS updated_by_id_8 FROM comment t0 WHERE t0 . post_id = 8 ;
Copy