1
0.61 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . avatar AS avatar_4 , t0 . bio AS bio_5 , t0 . facebook AS facebook_6 , t0 . twitter AS twitter_7 , t0 . linkedin AS linkedin_8 , t0 . instagram AS instagram_9 , t0 . pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0 . url = ? LIMIT 1
Parameters :
[
"david-reynolds "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . url AS url_3 , t0 . avatar AS avatar_4 , t0 . bio AS bio_5 , t0 . facebook AS facebook_6 , t0 . twitter AS twitter_7 , t0 . linkedin AS linkedin_8 , t0 . instagram AS instagram_9 , t0 . pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0 . url = 'david-reynolds' LIMIT 1 ;
Copy
2
4.97 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 (a . 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 (a . id = 6 ) AND (p . published = 1 ) ORDER BY date desc ) tmp ;
Copy
3
16.54 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 (a . 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 (a . id = 6 ) AND (p . published = 1 ) ORDER BY date desc LIMIT 10 ;
Copy
4
0.88 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.69 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.69 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.65 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.61 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.64 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.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
12
0.61 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.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
14
0.68 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
0.83 ms
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 25
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 25 ;
Copy
16
0.64 ms
SELECT COUNT (`id` ) FROM `published_blog_posts_ids`
SELECT COUNT (`id` ) FROM `published_blog_posts_ids` ;
Copy
17
0.65 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.64 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
0.61 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