2.19 ms (26.79%)
2
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 = 1122 ;
Copy
1.73 ms (21.21%)
1
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 (442 ));
Copy
1.39 ms (17.05%)
2
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
1.06 ms (13.02%)
1
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
1.01 ms (12.34%)
1
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 :
[
442
1122
1130
]
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 (442 )) AND a0_ . id IN (1122 , 1130 ) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC ;
Copy
0.78 ms (9.60%)
1
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 (442 )) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC LIMIT 9 ;
Copy