[ SQL ] SHOW COLUMNS FROM `cmf_transfer` [ RunTime:0.000899s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_transfer` `t` INNER JOIN `cmf_transfer_shop_img` `si` ON `si`.`transfer_shop_id`=`t`.`id` INNER JOIN `cmf_transfer_contact_information` `c` ON `c`.`transfer_id`=`t`.`id` WHERE `t`.`type` = 2 AND `t`.`review` = 1 AND `t`.`finish` = 0 AND `province` = 520000 AND `city` = 520100 AND `t`.`category_id` LIKE '%21,%' AND ( t.measure >= 100 and t.measure <200 ) AND ( t.rent_money >= 5000 and t.rent_money <10000 ) [ RunTime:0.010031s ]
[ SQL ] SELECT `t`.*,`si`.`positive`,`si`.`side`,`si`.`hall`,`si`.`more`,`c`.`name`,`c`.`shop_type`,`c`.`adv_descript` FROM `cmf_transfer` `t` INNER JOIN `cmf_transfer_shop_img` `si` ON `si`.`transfer_shop_id`=`t`.`id` INNER JOIN `cmf_transfer_contact_information` `c` ON `c`.`transfer_id`=`t`.`id` WHERE `t`.`type` = 2 AND `t`.`review` = 1 AND `t`.`finish` = 0 AND `province` = 520000 AND `city` = 520100 AND `t`.`category_id` LIKE '%21,%' AND ( t.measure >= 100 and t.measure <200 ) AND ( t.rent_money >= 5000 and t.rent_money <10000 ) ORDER BY `t`.`attestation` DESC,`t`.`update_time` DESC LIMIT 0,20 [ RunTime:0.002458s ]
公众号
