1
2.26 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 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"tailwind-css "
]
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 WHERE t0 . slug = 'tailwind-css' LIMIT 1 ;
Copy
2
0.92 ms
SELECT count (DISTINCT a0_ . id ) AS sclr_0 FROM article a0_ WHERE a0_ . is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_ . article_id = a0_ . id AND a1_ . category_id IN (? ))
SELECT count (DISTINCT a0_ . id ) AS sclr_0 FROM article a0_ WHERE a0_ . is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_ . article_id = a0_ . id AND a1_ . category_id IN (290 ));
Copy
3
2.29 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 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_ . article_id = a0_ . id AND a1_ . category_id IN (? )) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC LIMIT 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 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_ . article_id = a0_ . id AND a1_ . category_id IN (290 )) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC LIMIT 9 ;
Copy
4
2.10 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 EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_ . article_id = a0_ . id AND a1_ . category_id IN (? )) AND a0_ . id IN (? , ? ) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC
Parameters :
[
290
723
731
]
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 EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_ . article_id = a0_ . id AND a1_ . category_id IN (290 )) AND a0_ . id IN (723 , 731 ) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC ;
Copy
5
1.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
6
1.12 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
7
1.01 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 = 723 ;
Copy
8
0.74 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 = 731 ;
Copy