SELECT a.*,c.user_login,c.user_nicename,b.term_id FROM cmf_posts a INNER JOIN cmf_term_relationships b ON a.id = b.object_id INNER JOIN cmf_users c ON a.post_author = c.id WHERE a.id = 59 AND b.term_id = 4 LIMIT 1 [ RunTime:0.0020s ]
SHOW COLUMNS FROM `cmf_terms` [ RunTime:0.0029s ]
SELECT * FROM `cmf_terms` WHERE `term_id` = 4 LIMIT 1 [ RunTime:0.0000s ]
UPDATE `cmf_posts` SET `post_hits`=post_hits+1 WHERE `id` = 59 [ RunTime:0.0010s ]
SHOW COLUMNS FROM `cmf_term_relationships` [ RunTime:0.0029s ]
SELECT * FROM cmf_term_relationships a INNER JOIN cmf_posts as b on a.object_id =b.id INNER JOIN cmf_users as c on b.post_author = c.id WHERE `post_date` >= '2021-08-18 00:00:00' AND `object_id` <> 59 AND a.status = 1 AND a.term_id = 4 AND `post_status` = 1 ORDER BY post_date asc LIMIT 1 [ RunTime:0.0029s ]
SELECT * FROM cmf_term_relationships a INNER JOIN cmf_posts as b on a.object_id =b.id INNER JOIN cmf_users as c on b.post_author = c.id WHERE `post_date` <= '2021-08-18 00:00:00' AND `object_id` <> 59 AND a.status = 1 AND a.term_id = 4 AND `post_status` = 1 ORDER BY post_date desc LIMIT 1 [ RunTime:0.0029s ]
SELECT COUNT(*) AS tp_count FROM cmf_term_relationships term_relationships INNER JOIN cmf_posts as posts on term_relationships.object_id = posts.id INNER JOIN cmf_users as users on posts.post_author = users.id WHERE term_relationships.status = 1 AND posts.post_status = 1 AND term_relationships.term_id IN (4) LIMIT 1 [ RunTime:0.0010s ]
SELECT * FROM cmf_term_relationships term_relationships INNER JOIN cmf_posts as posts on term_relationships.object_id = posts.id INNER JOIN cmf_users as users on posts.post_author = users.id WHERE term_relationships.status = 1 AND posts.post_status = 1 AND term_relationships.term_id IN (4) ORDER BY post_date DESC LIMIT 0,50 [ RunTime:0.0029s ]