7.18 ms
(26.26%)
|
2 |
SELECT COUNT(`id`) FROM `blog_posts_published_ids`
SELECT COUNT(`id`) FROM `blog_posts_published_ids`;
|
7.06 ms
(25.85%)
|
1 |
SELECT a.id, a.name, a.url FROM blog_authors a
SELECT a.id, a.name, a.url FROM blog_authors a;
|
4.10 ms
(15.00%)
|
1 |
SELECT id, name FROM blog_categories
SELECT id, name FROM blog_categories;
|
3.34 ms
(12.22%)
|
1 |
SELECT user_id, network, identity, nickname FROM user_networks WHERE user_id IN(?, ?, ?, ?, ?, ?, ?)
Parameters: [
7
6
5
4
3
2
1
]
SELECT user_id, network, identity, nickname FROM user_networks WHERE user_id IN(7, 6, 5, 4, 3, 2, 1);
|
2.26 ms
(8.28%)
|
1 |
SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id ORDER BY id desc LIMIT 9 OFFSET 36
SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id ORDER BY id desc LIMIT 9 OFFSET 36;
|
1.21 ms
(4.43%)
|
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.68 ms
(2.48%)
|
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.65 ms
(2.39%)
|
1 |
SELECT COUNT(*) FROM (SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id) tmp
SELECT COUNT(*) FROM (SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id) tmp;
|
0.47 ms
(1.70%)
|
1 |
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 5
SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 5;
|
0.38 ms
(1.39%)
|
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;
|