1
0.71 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM blog_tag_names t0 WHERE t0 . name = ? LIMIT 1
Parameters :
[
"renewable "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM blog_tag_names t0 WHERE t0 . name = 'renewable' LIMIT 1 ;
Copy
2
1.21 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 = 18 ) AND (p . published = 1 ) ORDER BY date desc ) tmp ;
Copy
3
2.67 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 = 18 ) AND (p . published = 1 ) ORDER BY date desc LIMIT 10 ;
Copy
4
1.04 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.09 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.34 ms
SELECT id , name FROM blog_categories
SELECT id , name FROM blog_categories ;
Copy
7
0.94 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
8
0.94 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
1.06 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1 ;
Copy
10
0.82 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
11
0.98 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.81 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.88 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
1.06 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
15
1.34 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
16
1.05 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
17
0.83 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1 ;
Copy
18
0.91 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
19
1.23 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