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.0841s ]
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 3736,8 [ RunTime:0.0813s ]
SELECT * FROM `sp_designer` WHERE ( user_id=2149 ) 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=4677 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=2289 ) LIMIT 1 [ RunTime:0.0015s ]
SELECT * FROM `sp_designer` WHERE ( user_id=68 ) 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=4669 ) LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `sp_case` WHERE ( id=2288 ) LIMIT 1 [ RunTime:0.0013s ]
SELECT * FROM `sp_designer` WHERE ( user_id=68 ) 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=2287 ) LIMIT 1 [ RunTime:0.0012s ]
SELECT * FROM `sp_designer` WHERE ( user_id=41 ) 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=4672 ) LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `sp_case` WHERE ( id=2286 ) LIMIT 1 [ RunTime:0.0013s ]
SELECT * FROM `sp_designer` WHERE ( user_id=68 ) 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=4669 ) LIMIT 1 [ RunTime:0.0007s ]
SELECT * FROM `sp_case` WHERE ( id=2285 ) LIMIT 1 [ RunTime:0.0013s ]
SELECT * FROM `sp_designer` WHERE ( user_id=68 ) 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=45057 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=2284 ) LIMIT 1 [ RunTime:0.0012s ]
SELECT * FROM `sp_designer` WHERE ( user_id=316 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=441 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=0 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=2283 ) LIMIT 1 [ RunTime:0.0013s ]
SELECT * FROM `sp_designer` WHERE ( user_id=316 ) LIMIT 1 [ RunTime:0.0003s ]
SELECT * FROM `sp_area` WHERE ( area_id=441 ) LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `sp_area` WHERE ( area_id=0 ) LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `sp_case` WHERE ( id=2283 ) LIMIT 1 [ RunTime:0.0012s ]
SELECT * FROM `sp_area` WHERE `area_parent_id` = 438 GROUP BY area_id [ RunTime:0.0009s ]