[ SQL ] SHOW COLUMNS FROM `cmf_demand` [ RunTime:0.004690s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_demand` `d` LEFT JOIN `cmf_demand_approval` `da` ON `d`.`id`=`da`.`demand_id` WHERE `d`.`status` = 1 AND `d`.`delete_time` = 0 AND `d`.`step` <> 5 AND ( NOT (d.step = 0 AND d.end_time <= 1786590060) ) AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) [ RunTime:0.004170s ]
[ SQL ] SELECT `d`.`id`,`d`.`title`,`d`.`content`,`d`.`total`,`d`.`budget`,`d`.`step`,`d`.`delivery_time`,`d`.`end_time`,`d`.`bid`,`d`.`cates`,`d`.`money_type`,`d`.`tonnage`,`d`.`price`,`d`.`complete_period`,`d`.`show`,`d`.`up_time`,`d`.`cre_time`,`d`.`user_id` FROM `cmf_demand` `d` LEFT JOIN `cmf_demand_approval` `da` ON `d`.`id`=`da`.`demand_id` WHERE `d`.`status` = 1 AND `d`.`delete_time` = 0 AND `d`.`step` <> 5 AND ( NOT (d.step = 0 AND d.end_time <= 1786590060) ) AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) ORDER BY CASE WHEN d.step = 0 AND d.end_time > 1786590060 THEN 1 WHEN d.step = 2 THEN 2 WHEN d.step = 3 THEN 3 ELSE 4 END ASC, d.up_time DESC, d.id DESC LIMIT 30,10 [ RunTime:0.004331s ]