show full columns from `lk_webconfig` [ runtime:0.001155s ]
select * from `lk_webconfig` where `id` = 1 limit 1 [ runtime:0.000507s ]
show full columns from `lk_webad` [ runtime:0.000968s ]
select * from `lk_webad` where `sdate` <= 1728403200 and `edate` > 1728403200 and `webadlocal` = '凯发线上平台在线首页顶部' order by `list_order` asc [ runtime:0.000586s ]
show full columns from `lk_dictionary` [ runtime:0.006493s ]
select * from `lk_dictionary` where `dname` = '项目户型' order by `px` asc [ runtime:0.000585s ]
select * from `lk_dictionary` where `dname` = '项目特色' order by `px` asc [ runtime:0.000468s ]
show full columns from `lk_project_more` [ runtime:0.000813s ]
select `prjid` from `lk_project_more` where `prjkind` = '项目特色' and `prjvalue` = '改善房' group by `prjid` [ runtime:0.001380s ]
show full columns from `lk_project_info` [ runtime:0.001037s ]
select count(*) as think_count from `lk_project_info` where `id` > 0 and `zzprice` >= '8000' and `zzprice` < '10000' and `id` in (974,985,991,993,994) limit 1 [ runtime:0.000609s ]
select * from `lk_project_info` where `id` > 0 and `zzprice` >= '8000' and `zzprice` < '10000' and `id` in (974,985,991,993,994) order by `prjid` desc limit 0,10 [ runtime:0.000688s ]
select `prjvalue` from `lk_project_more` where `prjid` = 974 and `prjkind` = '项目特色' order by `list_order` asc [ runtime:0.001161s ]
select `prjvalue` from `lk_project_more` where `prjid` = 974 and `prjkind` = '项目户型' order by `list_order` asc [ runtime:0.001085s ]
select `prjvalue` from `lk_project_more` where `prjid` = 991 and `prjkind` = '项目特色' order by `list_order` asc [ runtime:0.003115s ]
select `prjvalue` from `lk_project_more` where `prjid` = 991 and `prjkind` = '项目户型' order by `list_order` asc [ runtime:0.001160s ]
select `prjvalue` from `lk_project_more` where `prjid` = 985 and `prjkind` = '项目特色' order by `list_order` asc [ runtime:0.001086s ]
select `prjvalue` from `lk_project_more` where `prjid` = 985 and `prjkind` = '项目户型' order by `list_order` asc [ runtime:0.001071s ]
select * from `lk_project_info` where `ishot` = 1 order by `updatetime` desc limit 6 [ runtime:0.000842s ]
select * from `lk_project_info` order by `hits` desc limit 6 [ runtime:0.000753s ]