[ SQL ] SHOW COLUMNS FROM `cmf_find_shop` [ RunTime:0.000753s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_find_shop` `f` INNER JOIN `cmf_find_shop_contact` `c` ON `c`.`fs_id`=`f`.`id` WHERE `province` = 520000 AND `city` = 520100 AND `f`.`review` = 1 AND `f`.`finish` = 0 AND `f`.`rent_type_id` LIKE '%19,%' AND `f`.`min_area` >= 100 AND `f`.`min_area` <= 200 AND ( `f`.`position` LIKE '%1,%' or `f`.`position` LIKE '%,1,%' or `f`.`position` LIKE '%,1%' ) [ RunTime:0.001480s ]
[ SQL ] SELECT `f`.*,`c`.`name`,`c`.`fs_type`,`c`.`description` FROM `cmf_find_shop` `f` INNER JOIN `cmf_find_shop_contact` `c` ON `c`.`fs_id`=`f`.`id` WHERE `province` = 520000 AND `city` = 520100 AND `f`.`review` = 1 AND `f`.`finish` = 0 AND `f`.`rent_type_id` LIKE '%19,%' AND `f`.`min_area` >= 100 AND `f`.`min_area` <= 200 AND ( `f`.`position` LIKE '%1,%' or `f`.`position` LIKE '%,1,%' or `f`.`position` LIKE '%,1%' ) ORDER BY `f`.`attestation` DESC,`f`.`update_time` DESC LIMIT 0,20 [ RunTime:0.003631s ]
公众号
