1
0.52 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM blog_categories t0 WHERE t0 . name = ? LIMIT 1
Parameters :
[
"energy efficiency "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM blog_categories t0 WHERE t0 . name = 'energy efficiency' LIMIT 1 ;
Copy
2
0.86 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 WHERE (c . 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 WHERE (c . id = 1 ) AND (p . published = 1 ) ORDER BY date desc ) tmp ;
Copy
3
1.03 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 WHERE (c . 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 WHERE (c . id = 1 ) AND (p . published = 1 ) ORDER BY date desc LIMIT 10 ;
Copy
4
0.73 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.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
6
0.71 ms
SELECT id , name FROM blog_categories
SELECT id , name FROM blog_categories ;
Copy
7
0.65 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
8
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
9
0.62 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.66 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.61 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.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
13
0.67 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
14
0.80 ms
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 24
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 24 ;
Copy
15
0.63 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
16
0.62 ms
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2 ;
Copy
17
0.62 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.60 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