1
0.84 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
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 = 'php' LIMIT 1 ;
Copy
2
1.04 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 (436 ));
Copy
3
1.10 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 (436 )) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC LIMIT 9 ;
Copy
4
1.73 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 :
[
436
1117
1137
1119
1123
1125
1128
]
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 (436 )) AND a0_ . id IN (1117 , 1137 , 1119 , 1123 , 1125 , 1128 ) ORDER BY a0_ . published_at DESC , a0_ . created_at DESC ;
Copy
5
0.40 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.84 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.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 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 = 1117 ;
Copy
8
0.61 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 = 1137 ;
Copy
9
0.46 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 = 1119 ;
Copy
10
0.47 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 = 1123 ;
Copy
11
0.57 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
12
0.52 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