[ SQL ] SHOW COLUMNS FROM `cmf_demand_review` [ RunTime:0.005599s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_demand_review` `r` LEFT JOIN `cmf_demand` `d` ON `d`.`id`=`r`.`demand_id` LEFT JOIN `cmf_user` `u` ON `u`.`id`=`r`.`user_id` WHERE `r`.`bid_user_id` = 1938 AND `r`.`delete_time` = 0 [ RunTime:0.005128s ]
[ SQL ] SELECT *,`r`.`id`,`r`.`review_type`,`r`.`review_content`,`r`.`review_source`,`r`.`create_time`,d.seq as demand_no,d.title as demand_title,u.user_nickname as reviewer_name FROM `cmf_demand_review` `r` LEFT JOIN `cmf_demand` `d` ON `d`.`id`=`r`.`demand_id` LEFT JOIN `cmf_user` `u` ON `u`.`id`=`r`.`user_id` WHERE `r`.`bid_user_id` = 1938 AND `r`.`delete_time` = 0 ORDER BY `r`.`create_time` DESC,`r`.`id` DESC LIMIT 0,10 [ RunTime:0.005063s ]
[ SQL ] SELECT bid_user_id as user_id,SUM(CASE WHEN review_type = 1 THEN 1 ELSE 0 END) as good_count,SUM(CASE WHEN review_type = 2 THEN 1 ELSE 0 END) as bad_count,COUNT(*) as total_count FROM `cmf_demand_review` WHERE `bid_user_id` = 1938 AND `delete_time` = 0 GROUP BY `bid_user_id` [ RunTime:0.004996s ]