[ SQL ] SHOW COLUMNS FROM `cmf_demand_review` [ RunTime:0.005453s ]
[ 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` = 2075 AND `delete_time` = 0 GROUP BY `bid_user_id` [ RunTime:0.004772s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_change_price` [ RunTime:0.003994s ]
[ SQL ] SELECT `status`,`extra_total` FROM `cmf_demand_change_price` WHERE `demand_id` = 120 AND `execution_round` = 0 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003346s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_bid` [ RunTime:0.003803s ]
[ SQL ] SELECT `u`.`user_nickname`,`u`.`avatar`,`u`.`mobile`,`u`.`is_vip`,`u`.`vip_end_time`,`b`.* FROM `cmf_demand_bid` `b` LEFT JOIN `cmf_user` `u` ON `b`.`user_id`=`u`.`id` WHERE `b`.`demand_id` = '120' ORDER BY `b`.`id` ASC [ RunTime:0.003640s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_reissue_log` [ RunTime:0.004075s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_demand_reissue_log` WHERE `demand_id` = 120 AND `round_to` = 0 AND `reuse_paid_order` = 1 [ RunTime:0.003521s ]
[ SQL ] SELECT bid_user_id as user_id,COUNT(*) as complete_count FROM `cmf_demand` WHERE `bid_user_id` IN (2145,1114,2075) AND `step` = 3 AND `delete_time` = 0 GROUP BY `bid_user_id` [ RunTime:0.003629s ]
[ SQL ] SHOW COLUMNS FROM `cmf_provider_auth` [ RunTime:0.003927s ]
[ SQL ] SELECT `id`,`user_id`,`type` FROM `cmf_provider_auth` WHERE `user_id` IN (2145,1114,2075) AND `status` = 1 AND `delete_time` = 0 ORDER BY `id` DESC [ RunTime:0.003328s ]
[ 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` IN (2145,1114,2075) AND `delete_time` = 0 GROUP BY `bid_user_id` [ RunTime:0.003347s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_checker_bid` [ RunTime:0.003857s ]
[ SQL ] SELECT `u`.`user_nickname`,`u`.`avatar`,`u`.`mobile`,`u`.`is_vip`,`u`.`vip_end_time`,`b`.* FROM `cmf_demand_checker_bid` `b` LEFT JOIN `cmf_user` `u` ON `b`.`user_id`=`u`.`id` WHERE `b`.`demand_id` = '120' ORDER BY `b`.`id` ASC [ RunTime:0.003368s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_audit` [ RunTime:0.004103s ]
[ 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` = '120' AND `a`.`delete_time` = 0 ORDER BY `a`.`create_time` DESC [ RunTime:0.003515s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_promotion_payment` [ RunTime:0.004285s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_demand_promotion_payment` WHERE `demand_id` = 120 AND `action_type` = 2 AND `status` = 1 [ RunTime:0.003333s ]