1
0.29 ms
SELECT count (DISTINCT a0_ . id ) AS sclr_0 FROM article a0_ WHERE a0_ . is_published = 1
SELECT count (DISTINCT a0_ . id ) AS sclr_0 FROM article a0_ WHERE a0_ . is_published = 1 ;
Copy
2
0.31 ms
SELECT DISTINCT a0_ . id AS id_0 , a0_ . published_at AS published_at_1 , a0_ . created_at AS created_at_2 FROM article a0_ WHERE a0_ . is_published = 1 ORDER BY a0_ . published_at DESC , a0_ . created_at DESC LIMIT 9 OFFSET 9
SELECT DISTINCT a0_ . id AS id_0 , a0_ . published_at AS published_at_1 , a0_ . created_at AS created_at_2 FROM article a0_ WHERE a0_ . is_published = 1 ORDER BY a0_ . published_at DESC , a0_ . created_at DESC LIMIT 9 OFFSET 9 ;
Copy
3
0.39 ms
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . content AS content_3 , a0_ . excerpt AS excerpt_4 , a0_ . featured_image AS featured_image_5 , a0_ . is_published AS is_published_6 , a0_ . created_at AS created_at_7 , a0_ . published_at AS published_at_8 , a0_ . updated_at AS updated_at_9 FROM article a0_ WHERE a0_ . is_published = 1 AND a0_ . id IN (? , ? , ? , ? , ? , ? , ? ) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC
Parameters :
[
1125
1126
1127
1128
1129
1130
1131
]
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . content AS content_3 , a0_ . excerpt AS excerpt_4 , a0_ . featured_image AS featured_image_5 , a0_ . is_published AS is_published_6 , a0_ . created_at AS created_at_7 , a0_ . published_at AS published_at_8 , a0_ . updated_at AS updated_at_9 FROM article a0_ WHERE a0_ . is_published = 1 AND a0_ . id IN (1125 , 1126 , 1127 , 1128 , 1129 , 1130 , 1131 ) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC ;
Copy
4
0.34 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 ORDER BY t0 . title ASC
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 ORDER BY t0 . title ASC ;
Copy
5
0.33 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 ORDER BY t0 . title ASC
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 ORDER BY t0 . title ASC ;
Copy
6
0.32 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = 1125 ;
Copy
7
0.27 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = 1126 ;
Copy
8
0.24 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = 1127 ;
Copy
9
0.25 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = 1128 ;
Copy
10
0.28 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = 1129 ;
Copy
11
0.29 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = 1130 ;
Copy
12
0.28 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . color AS color_4 , t0 . description AS description_5 , t0 . level AS level_6 FROM category t0 INNER JOIN article_category ON t0 . id = article_category . category_id WHERE article_category . article_id = 1131 ;
Copy