[ SQL ] SHOW COLUMNS FROM `hxj_fg` [ RunTime:0.000743s ]
[ SQL ] SELECT * FROM `hxj_fg` WHERE `isshow` = 1 ORDER BY `sort` ASC [ RunTime:0.000513s ]
[ SQL ] SHOW COLUMNS FROM `hxj_case` [ RunTime:0.000818s ]
[ SQL ] SELECT `c`.`id`,c.title as ctitle,`c`.`pic`,`c`.`price`,`c`.`describe`,`c`.`area`,`c`.`house`,`f`.`fgmc`,`h`.`hxmc`,t.img as timg,t.title as tname,`t`.`idea`,`t`.`school`,`t`.`works`,`t`.`style`,`z`.`zcmc`,`t`.`experience` FROM `hxj_case` `c` INNER JOIN `hxj_fg` `f` ON `c`.`fgid`=`f`.`id` INNER JOIN `hxj_hx` `h` ON `c`.`hxid`=`h`.`id` INNER JOIN `hxj_team` `t` ON `c`.`sjsid`=`t`.`id` INNER JOIN `hxj_sjzc` `z` ON `z`.`id`=`t`.`zcid` WHERE `c`.`id` = '90' LIMIT 1 [ RunTime:0.000692s ]
[ SQL ] SELECT `cimg`.`img` FROM `hxj_case` `c` INNER JOIN `hxj_caseimg` `cimg` ON `c`.`id`=`cimg`.`caseid` WHERE `c`.`id` = '90' [ RunTime:0.000558s ]
[ SQL ] SELECT `c`.`id`,c.title as ctitle,`c`.`price`,`c`.`describe`,`c`.`img`,`c`.`area`,`c`.`house`,`f`.`fgmc`,t.img as timg,t.title as tname,`t`.`idea` FROM `hxj_case` `c` INNER JOIN `hxj_fg` `f` ON `c`.`fgid`=`f`.`id` INNER JOIN `hxj_team` `t` ON `c`.`sjsid`=`t`.`id` WHERE ( find_in_set(1,c.recommend) ) ORDER BY `c`.`sort` DESC LIMIT 4 [ RunTime:0.000706s ]
[ SQL ] SHOW COLUMNS FROM `hxj_team` [ RunTime:0.000675s ]
[ SQL ] SELECT `t`.`id`,`img`,`title`,`z`.`zcmc` FROM `hxj_team` `t` INNER JOIN `hxj_sjzc` `z` ON `t`.`zcid`=`z`.`id` ORDER BY `t`.`id` ASC LIMIT 4 [ RunTime:0.000632s ]
[ SQL ] SELECT * FROM `hxj_case` ORDER BY `id` DESC LIMIT 3 [ RunTime:0.000423s ]