1
0.53 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 = 'power' LIMIT 1 ;
Copy
2
0.66 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 = 4 ) AND (p . published = 1 ) ORDER BY date desc ) tmp ;
Copy
3
1.50 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 = 4 ) AND (p . published = 1 ) ORDER BY date desc LIMIT 10 ;
Copy
4
0.72 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
0.78 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
0.94 ms
SELECT id , name FROM blog_categories
SELECT id , name FROM blog_categories ;
Copy
7
0.76 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
8
0.75 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.74 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.73 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
0.75 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.78 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.77 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.74 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.87 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
1.03 ms
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 19
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 19 ;
Copy
17
1.19 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
18
0.78 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.77 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.77 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