1 |
1.21 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.cover AS cover_3, t0.text_ai AS text_ai_4, t0.text AS text_5, t0.url AS url_6, t0.published AS published_7, t0.date AS date_8, t0.author_id AS author_id_9, t0.editor_id AS editor_id_10, t0.category_id AS category_id_11 FROM blog_posts t0 WHERE t0.url = ? LIMIT 1
Parameters: [
"general-solar-storage-news-why-buying-solar-now-is-often-better-than-later"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.cover AS cover_3, t0.text_ai AS text_ai_4, t0.text AS text_5, t0.url AS url_6, t0.published AS published_7, t0.date AS date_8, t0.author_id AS author_id_9, t0.editor_id AS editor_id_10, t0.category_id AS category_id_11 FROM blog_posts t0 WHERE t0.url = 'general-solar-storage-news-why-buying-solar-now-is-often-better-than-later' LIMIT 1;
|
2 |
0.52 ms |
SELECT COUNT(id) FROM blog_post_likes WHERE post_id = ?
SELECT COUNT(id) FROM blog_post_likes WHERE post_id = 3;
|
3 |
0.42 ms |
SELECT COUNT(id) FROM blog_post_dislikes WHERE post_id = ?
SELECT COUNT(id) FROM blog_post_dislikes WHERE post_id = 3;
|
4 |
0.48 ms |
SELECT c.id, c.text, DATE_FORMAT(c.date, '%M %e, %Y %h:%i:%s') AS date, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.avatar, u.photos_dir_num FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (post_id = ?) AND (reply_to IS NULL)
SELECT c.id, c.text, DATE_FORMAT(c.date, '%M %e, %Y %h:%i:%s') AS date, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.avatar, u.photos_dir_num FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (post_id = 3) AND (reply_to IS NULL);
|
5 |
0.38 ms |
SELECT c.id, c.text, DATE_FORMAT(c.date, '%M %e, %Y %h:%i:%s') AS date, c.reply_to, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.avatar, u.photos_dir_num FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE reply_to IN (NULL)
SELECT c.id, c.text, DATE_FORMAT(c.date, '%M %e, %Y %h:%i:%s') AS date, c.reply_to, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.avatar, u.photos_dir_num FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE reply_to IN (NULL);
|
6 |
0.42 ms |
SELECT COUNT(id) FROM blog_post_comments WHERE post_id = ?
SELECT COUNT(id) FROM blog_post_comments WHERE post_id = 3;
|
7 |
0.46 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.id = ?
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.id = 6;
|
8 |
1.20 ms |
SELECT a.id, a.name, a.url FROM blog_authors a
SELECT a.id, a.name, a.url FROM blog_authors a;
|
9 |
0.67 ms |
SELECT a.id, a.name, a.url FROM blog_authors a
SELECT a.id, a.name, a.url FROM blog_authors a;
|
10 |
0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_categories t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_categories t0 WHERE t0.id = 3;
|
11 |
0.49 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_tag_names t0 INNER JOIN blog_tags ON t0.id = blog_tags.tag_id WHERE blog_tags.post_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_tag_names t0 INNER JOIN blog_tags ON t0.id = blog_tags.tag_id WHERE blog_tags.post_id = 3;
|
12 |
0.44 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.id = ?
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.id = 2;
|
13 |
0.76 ms |
SELECT COUNT(`id`) FROM `published_blog_posts_ids`
SELECT COUNT(`id`) FROM `published_blog_posts_ids`;
|
14 |
0.63 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;
|
15 |
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;
|
16 |
0.63 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);
|
17 |
0.88 ms |
SELECT id, name FROM blog_categories
SELECT id, name FROM blog_categories;
|
18 |
0.72 ms |
SELECT COUNT(`id`) FROM `published_blog_posts_ids`
SELECT COUNT(`id`) FROM `published_blog_posts_ids`;
|
19 |
0.75 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;
|
20 |
0.63 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;
|
21 |
0.63 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;
|
22 |
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;
|
23 |
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;
|
24 |
0.69 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;
|
25 |
0.69 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1;
|
26 |
0.70 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);
|
27 |
0.81 ms |
SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 22
SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 22;
|
28 |
0.68 ms |
SELECT COUNT(`id`) FROM `published_blog_posts_ids`
SELECT COUNT(`id`) FROM `published_blog_posts_ids`;
|
29 |
0.68 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;
|
30 |
0.63 ms |
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2
SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;
|
31 |
0.50 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);
|