[ SQL ] SHOW COLUMNS FROM `cmf_demand` [ RunTime:0.004730s ]
[ 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 <= 1786594905) ) AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) AND `d`.`step` = 3 [ RunTime:0.004199s ]
[ 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`.`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 <= 1786594905) ) AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) AND `d`.`step` = 3 ORDER BY CASE WHEN d.step = 0 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 176,8 [ RunTime:0.004337s ]
[ SQL ] SHOW COLUMNS FROM `cmf_demand_bid` [ RunTime:0.003991s ]
[ SQL ] SELECT `b`.`demand_id`,`u`.`avatar` FROM `cmf_demand_bid` `b` LEFT JOIN `cmf_user` `u` ON `b`.`user_id`=`u`.`id` WHERE `b`.`demand_id` IN (39,35,29) ORDER BY `b`.`id` DESC [ RunTime:0.003562s ]
[ 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`.`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 <= 1786594905) ) AND ( `da`.`id` IS NULL OR `da`.`audit_status` = 1 ) AND ( ((d.step = 0 AND d.end_time > 1786594905) OR d.step = 2) ) ORDER BY RAND() LIMIT 4 [ RunTime:0.003956s ]
[ SQL ] SHOW COLUMNS FROM `cmf_notice` [ RunTime:0.004009s ]
[ SQL ] SELECT `id`,`title`,`content`,`create_time` FROM `cmf_notice` WHERE `type` = 1 AND `delete_time` = 0 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.003514s ]
