SHOW FULL COLUMNS FROM `blog_posts` [ RunTime:0.001636s ]
SELECT `p`.`post_id` AS `id`,`post_title` AS `title`,`post_author` AS `author`,`post_content` AS `content`,`create_time` AS `time`,`um`.`meta_value` AS `avatar`,`um2`.`meta_value` AS `nicename`,`pm`.`meta_value` AS `featured` FROM `blog_posts` `p` LEFT JOIN `blog_usermeta` `um` ON `p`.`post_author`=um.user_id and um.meta_key="avatar" LEFT JOIN `blog_usermeta` `um2` ON `p`.`post_author`=um2.user_id and um2.meta_key="nicename" LEFT JOIN `blog_postmeta` `pm` ON `p`.`post_id`=pm.post_id and pm.meta_key="featured_image" WHERE `p`.`post_id` = '54' LIMIT 1 [ RunTime:0.000694s ]
评论