1.02 ms (11.22%)
3
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
0.87 ms (9.61%)
3
SELECT COUNT (`id` ) FROM `blog_posts_published_ids`
SELECT COUNT (`id` ) FROM `blog_posts_published_ids` ;
Copy
0.76 ms (8.31%)
2
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
0.63 ms (6.92%)
2
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
0.63 ms (6.89%)
2
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
0.55 ms (6.01%)
1
SELECT id , name FROM blog_categories
SELECT id , name FROM blog_categories ;
Copy
0.54 ms (5.89%)
1
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
0.47 ms (5.19%)
1
SELECT a . id , a . name , a . url FROM blog_authors a
SELECT a . id , a . name , a . url FROM blog_authors a ;
Copy
0.46 ms (5.07%)
1
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
0.45 ms (4.96%)
1
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
0.40 ms (4.37%)
1
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
0.40 ms (4.34%)
1
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
0.39 ms (4.28%)
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 = ? 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
0.30 ms (3.32%)
1
SELECT COUNT (id ) FROM blog_post_likes WHERE post_id = ?
SELECT COUNT (id ) FROM blog_post_likes WHERE post_id = 19 ;
Copy
0.26 ms (2.91%)
1
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
0.26 ms (2.89%)
1
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
0.26 ms (2.88%)
1
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
0.24 ms (2.59%)
1
SELECT COUNT (id ) FROM blog_post_dislikes WHERE post_id = ?
SELECT COUNT (id ) FROM blog_post_dislikes WHERE post_id = 19 ;
Copy
0.21 ms (2.34%)
1
SELECT COUNT (id ) FROM blog_post_favorites WHERE post_id = ?
SELECT COUNT (id ) FROM blog_post_favorites WHERE post_id = 19 ;
Copy