1
0.54 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM blog_tag_names t0 WHERE t0 . name = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM blog_tag_names t0 WHERE t0 . name = 'solar' LIMIT 1 ;
Copy
2
1.08 ms
SELECT COUNT (* ) FROM (SELECT p . id , p . title , p . cover , p . text , p . url , p . published , p . date , c . id AS category_id , c . name AS category_name , a . url AS author_url , a . name AS author_name , a . avatar AS author_avatar , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_categories c ON p . category_id = c . id INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_tags t ON t . post_id = p . id WHERE (t . tag_id = ? ) AND (p . published = ? ) ORDER BY date desc ) tmp
SELECT COUNT (* ) FROM (SELECT p . id , p . title , p . cover , p . text , p . url , p . published , p . date , c . id AS category_id , c . name AS category_name , a . url AS author_url , a . name AS author_name , a . avatar AS author_avatar , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_categories c ON p . category_id = c . id INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_tags t ON t . post_id = p . id WHERE (t . tag_id = 1 ) AND (p . published = 1 ) ORDER BY date desc ) tmp ;
Copy
3
2.09 ms
SELECT p . id , p . title , p . cover , p . text , p . url , p . published , p . date , c . id AS category_id , c . name AS category_name , a . url AS author_url , a . name AS author_name , a . avatar AS author_avatar , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_categories c ON p . category_id = c . id INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_tags t ON t . post_id = p . id WHERE (t . tag_id = ? ) AND (p . published = ? ) ORDER BY date desc LIMIT 10
SELECT p . id , p . title , p . cover , p . text , p . url , p . published , p . date , c . id AS category_id , c . name AS category_name , a . url AS author_url , a . name AS author_name , a . avatar AS author_avatar , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_categories c ON p . category_id = c . id INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_tags t ON t . post_id = p . id WHERE (t . tag_id = 1 ) AND (p . published = 1 ) ORDER BY date desc LIMIT 10 ;
Copy
4
2.19 ms
SELECT a . id , a . name , a . url FROM blog_authors a
SELECT a . id , a . name , a . url FROM blog_authors a ;
Copy
5
1.15 ms
SELECT a . id , a . name , a . url FROM blog_authors a
SELECT a . id , a . name , a . url FROM blog_authors a ;
Copy
6
1.55 ms
SELECT id , name FROM blog_categories
SELECT id , name FROM blog_categories ;
Copy
7
1.11 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
8
0.84 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
9
0.83 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
10
0.99 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1 ;
Copy
11
1.07 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1 ;
Copy
12
0.69 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
13
0.68 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
14
0.64 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1 ;
Copy
15
0.94 ms
SELECT p . url , p . title , p . cover , p . date , c . id AS category_id , c . name AS category_name , a . name AS author_name , a . url AS author_url , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_categories c ON p . category_id = c . id WHERE p . id IN (? , ? )
SELECT p . url , p . title , p . cover , p . date , c . id AS category_id , c . name AS category_name , a . name AS author_name , a . url AS author_url , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_categories c ON p . category_id = c . id WHERE p . id IN (2 , 1 );
Copy
16
0.86 ms
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 20
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 20 ;
Copy
17
0.67 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
18
0.69 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1 ;
Copy
19
0.67 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
20
0.59 ms
SELECT p . url , p . title , p . cover , p . date , c . id AS category_id , c . name AS category_name , a . name AS author_name , a . url AS author_url , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_categories c ON p . category_id = c . id WHERE p . id IN (? , ? )
SELECT p . url , p . title , p . cover , p . date , c . id AS category_id , c . name AS category_name , a . name AS author_name , a . url AS author_url , (SELECT COUNT (m . id ) FROM blog_post_comments m WHERE m . post_id = p . id ) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p . author_id = a . id INNER JOIN blog_categories c ON p . category_id = c . id WHERE p . id IN (1 , 2 );
Copy