2.46 ms (20.89%)
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
2.29 ms (19.42%)
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 (290 )) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC LIMIT 9 ;
Copy
2.26 ms (19.23%)
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
2.10 ms (17.81%)
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 :
[
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
1.75 ms (14.88%)
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 = 723 ;
Copy
0.92 ms (7.77%)
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 (290 ));
Copy