[ SQL ] SHOW COLUMNS FROM `cmf_demand` [ RunTime:0.006319s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_demand` `d` LEFT JOIN `cmf_demand_approval` `da` ON `d`.`id`=`da`.`demand_id` WHERE `status` = 1 AND `delete_time` = 0 AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) [ RunTime:0.005119s ]
[ SQL ] SELECT `d`.`id`,`d`.`title`,`d`.`total`,`d`.`step`,`d`.`delivery_time`,`d`.`end_time`,`d`.`show`,`d`.`bid`,`d`.`user_id`,`d`.`budget` FROM `cmf_demand` `d` LEFT JOIN `cmf_demand_approval` `da` ON `d`.`id`=`da`.`demand_id` WHERE `status` = 1 AND `delete_time` = 0 AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) ORDER BY `d`.`up_time` DESC LIMIT 40,10 [ RunTime:0.005294s ]
[ SQL ] SELECT `d`.`id`,`d`.`title`,`d`.`total`,`d`.`bid`,`d`.`budget` FROM `cmf_demand` `d` LEFT JOIN `cmf_demand_approval` `da` ON `d`.`id`=`da`.`demand_id` WHERE `d`.`step` = 0 AND `d`.`end_time` > 1771297038 AND `d`.`status` = 1 AND `d`.`delete_time` = 0 AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) ORDER BY `d`.`show` DESC LIMIT 8 [ RunTime:0.003614s ]
