[ SQL ] SHOW COLUMNS FROM `cmf_demand_review` [ RunTime:0.005617s ]
[ 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.003714s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_checker_review` [ RunTime:0.003759s ]
[ SQL ] SELECT checker_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_checker_review` WHERE `checker_id` = 17 AND `delete_time` = 0 GROUP BY `checker_id` [ RunTime:0.003305s ]
[ SQL ] SELECT `u`.`user_nickname`,`u`.`avatar`,`u`.`mobile`,`b`.* FROM `cmf_demand_bid` `b` LEFT JOIN `cmf_user` `u` ON `b`.`user_id`=`u`.`id` WHERE `b`.`demand_id` = '363' ORDER BY `b`.`id` ASC [ RunTime:0.004573s ]
[ 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.004781s ]
[ SQL ] SELECT `u`.`user_nickname`,`u`.`avatar`,`u`.`mobile`,`b`.* FROM `cmf_demand_checker_bid` `b` LEFT JOIN `cmf_user` `u` ON `b`.`user_id`=`u`.`id` WHERE `b`.`demand_id` = '363' ORDER BY `b`.`id` ASC [ RunTime:0.004752s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_audit` [ RunTime:0.005603s ]
[ SQL ] SELECT `a`.*,u.user_nickname as admin_name FROM `cmf_demand_audit` `a` LEFT JOIN `cmf_user` `u` ON `a`.`admin_id`=`u`.`id` WHERE `a`.`demand_id` = '363' AND `a`.`delete_time` = 0 ORDER BY `a`.`create_time` DESC [ RunTime:0.004835s ]
下载图集规范
接取项目任务
浏览最新课程
保留下载记录
