1
0.40 ms
SELECT t0 . id AS id_1 , t0 . product_id AS product_id_2 , t0 . title AS title_3 , t0 . cover AS cover_4 , t0 . toc AS toc_5 , t0 . text_ai AS text_ai_6 , t0 . text AS text_7 , t0 . url AS url_8 , t0 . published AS published_9 , t0 . moderated AS moderated_10 , t0 . priority AS priority_11 , t0 . themed_images AS themed_images_12 , t0 . photos_dir_num AS photos_dir_num_13 , t0 . parsed_url AS parsed_url_14 , t0 . add_later AS add_later_15 , t0 . created_at AS created_at_16 , t0 . updated_at AS updated_at_17 , t0 . author_id AS author_id_18 , t0 . editor_id AS editor_id_19 , t0 . category_id AS category_id_20 FROM blog_posts t0 WHERE t0 . url = ? LIMIT 1
Parameters :
[
"merceder-s-class "
]
SELECT t0 . id AS id_1 , t0 . product_id AS product_id_2 , t0 . title AS title_3 , t0 . cover AS cover_4 , t0 . toc AS toc_5 , t0 . text_ai AS text_ai_6 , t0 . text AS text_7 , t0 . url AS url_8 , t0 . published AS published_9 , t0 . moderated AS moderated_10 , t0 . priority AS priority_11 , t0 . themed_images AS themed_images_12 , t0 . photos_dir_num AS photos_dir_num_13 , t0 . parsed_url AS parsed_url_14 , t0 . add_later AS add_later_15 , t0 . created_at AS created_at_16 , t0 . updated_at AS updated_at_17 , t0 . author_id AS author_id_18 , t0 . editor_id AS editor_id_19 , t0 . category_id AS category_id_20 FROM blog_posts t0 WHERE t0 . url = 'merceder-s-class' LIMIT 1 ;
Copy
2
0.30 ms
SELECT COUNT (id ) FROM blog_post_likes WHERE post_id = ?
SELECT COUNT (id ) FROM blog_post_likes WHERE post_id = 19 ;
Copy
3
0.24 ms
SELECT COUNT (id ) FROM blog_post_dislikes WHERE post_id = ?
SELECT COUNT (id ) FROM blog_post_dislikes WHERE post_id = 19 ;
Copy
4
0.21 ms
SELECT COUNT (id ) FROM blog_post_favorites WHERE post_id = ?
SELECT COUNT (id ) FROM blog_post_favorites WHERE post_id = 19 ;
Copy
5
0.54 ms
SELECT COUNT (* ) FROM (SELECT c . id , c . text , c . created_at , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = c . author_id AND cl . comment_id = c . id
) AS likes_cnt , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = c . author_id AND cd . comment_id = c . id
) AS dislikes_cnt , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = ? AND cl . comment_id = c . id
) AS is_current_user_liked , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = ? AND cd . comment_id = c . id
) AS is_current_user_disliked , TRIM (CONCAT (u . name_first , ' ' , u . name_last )) AS name , u . nickname , u . avatar , u . photos_dir_num , u . fake FROM blog_post_comments c INNER JOIN user_users u ON c . author_id = u . id WHERE (c . post_id = ? ) AND (c . approved = 1 ) AND (c . reply_to IS NULL )) tmp
SELECT COUNT (* ) FROM (SELECT c . id , c . text , c . created_at , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = c . author_id AND cl . comment_id = c . id
) AS likes_cnt , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = c . author_id AND cd . comment_id = c . id
) AS dislikes_cnt , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = 0 AND cl . comment_id = c . id
) AS is_current_user_liked , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = 0 AND cd . comment_id = c . id
) AS is_current_user_disliked , TRIM (CONCAT (u . name_first , ' ' , u . name_last )) AS name , u . nickname , u . avatar , u . photos_dir_num , u . fake FROM blog_post_comments c INNER JOIN user_users u ON c . author_id = u . id WHERE (c . post_id = 19 ) AND (c . approved = 1 ) AND (c . reply_to IS NULL )) tmp ;
Copy
6
0.39 ms
SELECT c . id , c . text , c . created_at , c . reply_to , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = c . author_id AND cl . comment_id = c . id
) AS likes_cnt , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = c . author_id AND cd . comment_id = c . id
) AS dislikes_cnt , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = ? AND cl . comment_id = c . id
) AS is_current_user_liked , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = ? AND cd . comment_id = c . id
) AS is_current_user_disliked , TRIM (CONCAT (u . name_first , ' ' , u . name_last )) AS name , u . nickname , u . avatar , u . photos_dir_num , u . fake FROM blog_post_comments c INNER JOIN user_users u ON c . author_id = u . id WHERE (c . reply_to IN (NULL )) AND (c . approved = 1 )
SELECT c . id , c . text , c . created_at , c . reply_to , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = c . author_id AND cl . comment_id = c . id
) AS likes_cnt , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = c . author_id AND cd . comment_id = c . id
) AS dislikes_cnt , (
SELECT COUNT (cl . id )
FROM blog_post_comments_likes cl
WHERE cl . user_id = 0 AND cl . comment_id = c . id
) AS is_current_user_liked , (
SELECT COUNT (cd . id )
FROM blog_post_comments_dislikes cd
WHERE cd . user_id = 0 AND cd . comment_id = c . id
) AS is_current_user_disliked , TRIM (CONCAT (u . name_first , ' ' , u . name_last )) AS name , u . nickname , u . avatar , u . photos_dir_num , u . fake FROM blog_post_comments c INNER JOIN user_users u ON c . author_id = u . id WHERE (c . reply_to IN (NULL )) AND (c . approved = 1 );
Copy
7
0.40 ms
SELECT COUNT (id ) FROM blog_post_comments WHERE (post_id = ? ) AND (approved = 1 )
SELECT COUNT (id ) FROM blog_post_comments WHERE (post_id = 19 ) AND (approved = 1 );
Copy
8
0.38 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 = 1 ;
Copy
9
0.47 ms
SELECT a . id , a . name , a . url FROM blog_authors a
SELECT a . id , a . name , a . url FROM blog_authors a ;
Copy
10
0.26 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 = 14 ;
Copy
11
0.35 ms
SELECT w . id , w . title , w . description , w . cover , w . url , w . affiliate_link , w . partner_domain , w . widget_mode , w . created_at FROM site_ad_ads w WHERE (w . title = ? ) AND (w . is_widget = 1 ) AND (w . enabled = 1 ) LIMIT 1
Parameters :
[
"dating_reg_form "
]
SELECT w . id , w . title , w . description , w . cover , w . url , w . affiliate_link , w . partner_domain , w . widget_mode , w . created_at FROM site_ad_ads w WHERE (w . title = 'dating_reg_form' ) AND (w . is_widget = 1 ) AND (w . enabled = 1 ) LIMIT 1 ;
Copy
12
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . gallery AS gallery_3 , t0 . url AS url_4 , t0 . width AS width_5 , t0 . height AS height_6 , t0 . post_id AS post_id_7 FROM blog_post_images t0 WHERE t0 . post_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . gallery AS gallery_3 , t0 . url AS url_4 , t0 . width AS width_5 , t0 . height AS height_6 , t0 . post_id AS post_id_7 FROM blog_post_images t0 WHERE t0 . post_id = 19 ;
Copy
13
0.28 ms
SELECT w . id , w . title , w . description , w . cover , w . url , w . affiliate_link , w . partner_domain , w . widget_mode , w . created_at FROM site_ad_ads w WHERE (w . title = ? ) AND (w . is_widget = 1 ) AND (w . enabled = 1 ) LIMIT 1
Parameters :
[
"dating_reg_form "
]
SELECT w . id , w . title , w . description , w . cover , w . url , w . affiliate_link , w . partner_domain , w . widget_mode , w . created_at FROM site_ad_ads w WHERE (w . title = 'dating_reg_form' ) AND (w . is_widget = 1 ) AND (w . enabled = 1 ) LIMIT 1 ;
Copy
14
0.26 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 = 19 ;
Copy
15
0.25 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 = 5 ;
Copy
16
0.29 ms
SELECT COUNT (`id` ) FROM `blog_posts_published_ids`
SELECT COUNT (`id` ) FROM `blog_posts_published_ids` ;
Copy
17
0.40 ms
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 ;
Copy
18
0.33 ms
SELECT p . url , p . title , p . cover , p . created_at , 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 . created_at , 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 );
Copy
19
0.55 ms
SELECT id , name FROM blog_categories
SELECT id , name FROM blog_categories ;
Copy
20
0.32 ms
SELECT COUNT (`id` ) FROM `blog_posts_published_ids`
SELECT COUNT (`id` ) FROM `blog_posts_published_ids` ;
Copy
21
0.46 ms
SELECT id FROM blog_posts WHERE (published = 1 ) AND (priority = 1 ) ORDER BY RAND () ASC LIMIT 7
SELECT id FROM blog_posts WHERE (published = 1 ) AND (priority = 1 ) ORDER BY RAND () ASC LIMIT 7 ;
Copy
22
0.37 ms
SELECT p . url , p . title , p . cover , p . created_at , 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 . created_at , 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 );
Copy
23
0.45 ms
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 21
SELECT id , name FROM blog_tag_names ORDER BY RAND () ASC LIMIT 21 ;
Copy
24
0.27 ms
SELECT COUNT (`id` ) FROM `blog_posts_published_ids`
SELECT COUNT (`id` ) FROM `blog_posts_published_ids` ;
Copy
25
0.36 ms
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 ;
Copy
26
0.32 ms
SELECT p . url , p . title , p . cover , p . created_at , 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 . created_at , 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 );
Copy