0.71 ms (14.01%)
|
2 |
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 AND m.approved = 1) 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(NULL)
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 AND m.approved = 1) 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(NULL);
|
0.64 ms (12.74%)
|
1 |
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 AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_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 p.priority, 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 AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_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 = 2) AND (p.published = 1) ORDER BY p.priority, date desc LIMIT 10;
|
0.64 ms (12.56%)
|
1 |
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 AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_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 = ?)) 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 AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_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 = 2) AND (p.published = 1)) tmp;
|
0.62 ms (12.33%)
|
2 |
SELECT COUNT(`id`) FROM `blog_posts_published_ids`
SELECT COUNT(`id`) FROM `blog_posts_published_ids`;
|
0.47 ms (9.21%)
|
1 |
SELECT a.id, a.name, a.url FROM blog_authors a
SELECT a.id, a.name, a.url FROM blog_authors a;
|
0.46 ms (8.99%)
|
1 |
SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 16
SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 16;
|
0.41 ms (8.12%)
|
1 |
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 6
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 6;
|
0.39 ms (7.67%)
|
1 |
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: [
"jordan-lee"
]
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 = 'jordan-lee' LIMIT 1;
|
0.37 ms (7.25%)
|
1 |
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 2
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 2;
|
0.36 ms (7.11%)
|
1 |
SELECT id, name FROM blog_categories
SELECT id, name FROM blog_categories;
|