SELECT a.title,a.pic,a.info_id,b.id,b.user_id,b.build_name,b.thumb,b.house,b.space,b.style,b.budget,b.user_id,a.is_juzhuang FROM sp_photo a INNER JOIN ( SELECT * FROM `sp_case` WHERE `ischeck` = 1 AND `isdel` = 0 ORDER BY id desc ) b ON a.info_id=b.id WHERE a.class_id = 0 AND a.isdel = 0 [ RunTime:0.0803s ]
SELECT a.title,a.pic,a.info_id,b.id,b.hits,b.user_id,b.build_name,b.thumb,b.house,b.area,b.ocity,b.space,b.style,b.budget,b.user_id,a.is_juzhuang FROM sp_photo a INNER JOIN ( SELECT * FROM `sp_case` WHERE `ischeck` = 1 AND `isdel` = 0 ORDER BY id desc ) b ON a.info_id=b.id WHERE a.class_id = 0 AND a.isdel = 0 ORDER BY b.id desc LIMIT 3200,8 [ RunTime:0.0781s ]
SELECT * FROM `sp_designer` WHERE ( user_id=402 ) LIMIT 1 [ RunTime:0.0004s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=0 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4179 ) LIMIT 1 [ RunTime:0.0018s ]
SELECT * FROM `sp_designer` WHERE ( user_id=3342 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=4673 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4177 ) LIMIT 1 [ RunTime:0.0017s ]
SELECT * FROM `sp_designer` WHERE ( user_id=402 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=0 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4176 ) LIMIT 1 [ RunTime:0.0016s ]
SELECT * FROM `sp_designer` WHERE ( user_id=402 ) LIMIT 1 [ RunTime:0.0004s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=0 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4175 ) LIMIT 1 [ RunTime:0.0015s ]
SELECT * FROM `sp_designer` WHERE ( user_id=402 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=0 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4174 ) LIMIT 1 [ RunTime:0.0016s ]
SELECT * FROM `sp_designer` WHERE ( user_id=402 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=0 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4172 ) LIMIT 1 [ RunTime:0.0015s ]
SELECT * FROM `sp_building` WHERE `bid` = 0 LIMIT 1 [ RunTime:0.0010s ]
SELECT * FROM `sp_designer` WHERE ( user_id=40 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=4671 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4157 ) LIMIT 1 [ RunTime:0.0015s ]
SELECT * FROM `sp_building` WHERE `bid` = 0 LIMIT 1 [ RunTime:0.0010s ]
SELECT * FROM `sp_designer` WHERE ( user_id=40 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=438 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=4666 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=4152 ) LIMIT 1 [ RunTime:0.0015s ]
SELECT * FROM `sp_building` WHERE `bid` = 0 LIMIT 1 [ RunTime:0.0010s ]
SELECT * FROM `sp_area` WHERE `area_parent_id` = 438 GROUP BY area_id [ RunTime:0.0009s ]