合肥合工大南区站楼盘-百瑞地产网

基本文件流程错误 SQL 调试

/home/web/website/Framework/web/index.php ( 0.68 KB )
/home/web/website/Framework/tpberui/ThinkPHP.php ( 4.71 KB )
/home/web/website/Framework/tpberui/Library/Think/Think.class.php ( 12.32 KB )
/home/web/website/Framework/tpberui/Library/Think/Storage.class.php ( 1.38 KB )
/home/web/website/Framework/tpberui/Library/Think/Storage/Driver/File.class.php ( 3.56 KB )
/home/web/website/Framework/tpberui/Mode/common.php ( 2.82 KB )
/home/web/website/Framework/tpberui/Common/functions.php ( 54.35 KB )
/home/web/website/Framework/webCode/Common/Common/function.php ( 10.16 KB )
/home/web/website/Framework/tpberui/Library/Think/Hook.class.php ( 4.02 KB )
/home/web/website/Framework/tpberui/Library/Think/App.class.php ( 12.44 KB )
/home/web/website/Framework/tpberui/Library/Think/Dispatcher.class.php ( 15.15 KB )
/home/web/website/Framework/tpberui/Library/Think/Route.class.php ( 13.38 KB )
/home/web/website/Framework/tpberui/Library/Think/Controller.class.php ( 10.95 KB )
/home/web/website/Framework/tpberui/Library/Think/View.class.php ( 7.96 KB )
/home/web/website/Framework/tpberui/Library/Behavior/BuildLiteBehavior.class.php ( 3.69 KB )
/home/web/website/Framework/tpberui/Library/Behavior/ParseTemplateBehavior.class.php ( 3.89 KB )
/home/web/website/Framework/tpberui/Library/Behavior/ContentReplaceBehavior.class.php ( 1.93 KB )
/home/web/website/Framework/tpberui/Conf/convention.php ( 11.18 KB )
/home/web/website/Framework/webCode/Common/Conf/config.php ( 7.80 KB )
/home/web/website/Framework/tpberui/Library/Think/Log.class.php ( 3.97 KB )
/home/web/website/Framework/tpberui/Lang/zh-cn.php ( 2.57 KB )
/home/web/website/Framework/tpberui/Conf/debug.php ( 1.51 KB )
/home/web/website/Framework/webCode/Common/Conf/debug.php ( 1.51 KB )
/home/web/website/Framework/webCode/Common/Conf/city_list.php ( 3.36 KB )
/home/web/website/Framework/webCode/Newhouse/Conf/config.php ( 3.88 KB )
/home/web/website/Framework/tpberui/Library/Behavior/ReadHtmlCacheBehavior.class.php ( 5.62 KB )
/home/web/website/Framework/webCode/Newhouse/Controller/HouseController.class.php ( 23.16 KB )
/home/web/website/Framework/webCode/Common/Controller/NewhouseController.class.php ( 24.38 KB )
/home/web/website/Framework/webCode/Common/Controller/PublicController.class.php ( 9.24 KB )
/home/web/website/Framework/tpberui/Library/Predis/Autoloader.class.php ( 1.67 KB )
/home/web/website/Framework/tpberui/Library/Predis/Client.class.php ( 15.08 KB )
/home/web/website/Framework/tpberui/Library/Predis/ClientInterface.php ( 8.23 KB )
/home/web/website/Framework/tpberui/Library/Predis/Configuration/Options.php ( 3.12 KB )
/home/web/website/Framework/tpberui/Library/Predis/Configuration/OptionsInterface.php ( 1.70 KB )
/home/web/website/Framework/tpberui/Library/Predis/Configuration/ConnectionFactoryOption.php ( 1.32 KB )
/home/web/website/Framework/tpberui/Library/Predis/Configuration/OptionInterface.php ( 0.96 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/Factory.php ( 4.19 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/FactoryInterface.php ( 1.51 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/Parameters.php ( 3.21 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/ParametersInterface.php ( 2.18 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/StreamConnection.php ( 7.51 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/AbstractConnection.php ( 4.79 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/NodeConnectionInterface.php ( 1.32 KB )
/home/web/website/Framework/tpberui/Library/Predis/Connection/ConnectionInterface.php ( 1.52 KB )
/home/web/website/Framework/tpberui/Library/Predis/Command/RawCommand.php ( 2.74 KB )
/home/web/website/Framework/tpberui/Library/Predis/Command/CommandInterface.php ( 1.82 KB )
/home/web/website/Framework/tpberui/Library/Predis/Configuration/ProfileOption.php ( 2.02 KB )
/home/web/website/Framework/tpberui/Library/Predis/Profile/Factory.php ( 2.46 KB )
/home/web/website/Framework/tpberui/Library/Predis/Profile/RedisVersion300.php ( 13.52 KB )
/home/web/website/Framework/tpberui/Library/Predis/Profile/RedisProfile.php ( 3.46 KB )
/home/web/website/Framework/tpberui/Library/Predis/Profile/ProfileInterface.php ( 1.43 KB )
/home/web/website/Framework/tpberui/Library/Think/Model.class.php ( 67.27 KB )
/home/web/website/Framework/tpberui/Library/Think/Db.class.php ( 5.70 KB )
/home/web/website/Framework/tpberui/Library/Think/Db/Driver/Mysql.class.php ( 8.73 KB )
/home/web/website/Framework/tpberui/Library/Think/Db/Driver.class.php ( 41.60 KB )
/home/web/website/Framework/tpberui/Library/Think/Cache.class.php ( 3.84 KB )
/home/web/website/Framework/tpberui/Library/Think/Cache/Driver/File.class.php ( 5.90 KB )
/home/web/website/Framework/tpberui/Library/Think/BrPage.class.php ( 6.95 KB )
/home/web/website/Framework/tpberui/Library/Think/Template.class.php ( 28.35 KB )
/home/web/website/Framework/tpberui/Library/Think/Template/TagLib/Cx.class.php ( 22.62 KB )
/home/web/website/Framework/tpberui/Library/Think/Template/TagLib.class.php ( 9.19 KB )
/home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php ( 55.38 KB )
/home/web/website/Framework/tpberui/Library/Behavior/WriteHtmlCacheBehavior.class.php ( 1.43 KB )
/home/web/website/Framework/tpberui/Library/Behavior/ShowPageTraceBehavior.class.php ( 5.27 KB )

[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangAfcDiscount /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 495 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 490 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 491 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 492 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangAfcDiscount /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 495 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 490 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 491 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 492 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangAfcDiscount /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 495 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 490 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 491 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 492 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 493 行.
[8] Undefined index: fangAfcDiscount /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 495 行.
[8] Use of undefined constant serverName - assumed 'serverName' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 515 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Undefined offset: 10001336 /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Undefined offset: 10000371 /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPicUrl - assumed 'fangPicUrl' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Undefined offset: 10000126 /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 534 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPrice - assumed 'fangPrice' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant fangPriceEnd - assumed 'fangPriceEnd' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Undefined index: fangPriceEnd /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 536 行.
[8] Use of undefined constant shortCity - assumed 'shortCity' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 774 行.
[8] Use of undefined constant cityId - assumed 'cityId' /home/web/website/Framework/cache/runtime/web/Cache/Newhouse/1521243d2cbee47a5a5ca3e8759bc655.php 第 874 行.

SHOW COLUMNS FROM `br_basic_city` [ RunTime:0.0010s ]
SELECT * FROM `br_basic_city` WHERE `cityId` = 340100 ORDER BY orderBY desc LIMIT 1 [ RunTime:0.0008s ]
SHOW COLUMNS FROM `br_basic_link` [ RunTime:0.0008s ]
SELECT * FROM `br_basic_link` WHERE `cityId` = '340100' AND `isDel` = 0 ORDER BY linkSort desc,linkId asc [ RunTime:0.0010s ]
SHOW COLUMNS FROM `br_fang_newinfo` [ RunTime:0.0014s ]
SHOW COLUMNS FROM `br_fang_area` [ RunTime:0.0009s ]
SHOW COLUMNS FROM `br_fang_type` [ RunTime:0.0008s ]
SELECT `fangTypeId` FROM `br_fang_type` WHERE `fangCityId` = 340100 AND `fangTypeName` = '价格区间' ORDER BY fangTypeId DESC LIMIT 1 [ RunTime:0.0011s ]
SELECT `fangTypeId` FROM `br_fang_type` WHERE `fangCityId` = 340100 AND `fangTypeName` = '环线位置' ORDER BY fangTypeId DESC LIMIT 1 [ RunTime:0.0008s ]
SHOW COLUMNS FROM `br_fang_ditie_line` [ RunTime:0.0008s ]
SHOW COLUMNS FROM `br_fang_ditie` [ RunTime:0.0008s ]
SHOW COLUMNS FROM `br_fang_ditie_re` [ RunTime:0.0007s ]
SELECT * FROM `br_fang_ditie_re` WHERE `fangditieId` = 1262 [ RunTime:0.0006s ]
SELECT * FROM `br_fang_ditie` WHERE `fangditieId` = 1262 ORDER BY fangditieId DESC LIMIT 1 [ RunTime:0.0007s ]
SHOW COLUMNS FROM `br_fang_afc` [ RunTime:0.0008s ]
SELECT * FROM `br_fang_afc` WHERE `isDel` = 0 AND `fangAfcEtime` > 1552918477 GROUP BY fangId ORDER BY fangAfcCreateTime desc [ RunTime:0.0011s ]
SHOW COLUMNS FROM `br_fang_new` [ RunTime:0.0012s ]
SELECT COUNT(*) AS tp_count FROM `br_fang_new` WHERE `cityId` = 340100 AND `fangId` IN ('10000977','10002254','10003056') AND `isDel` = 0 LIMIT 1 [ RunTime:0.0006s ]
SELECT * FROM `br_fang_new` WHERE `cityId` = 340100 AND `fangId` IN ('10000977','10002254','10003056') AND `isDel` = 0 ORDER BY field(fangStage,2,1),field(fangSellType,293,451,291,294,0),updateTime desc,fangOrder desc LIMIT 0,12 [ RunTime:0.0009s ]
select fangAddress,fang400,fangCharachteristic from br_fang_newinfo where fangId=10002254 limit 1 [ RunTime:0.0007s ]
SHOW COLUMNS FROM `br_list400` [ RunTime:0.0008s ]
SELECT * FROM `br_list400` WHERE `fangId` = 10002254 LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_type` WHERE `fangTypeId` = 463 LIMIT 1 [ RunTime:0.0006s ]
SELECT * FROM `br_fang_type` WHERE `fangTypeId` = 1406 LIMIT 1 [ RunTime:0.0006s ]
select fangAfcDiscount,fangAfcStime,fangAfcEtime from br_fang_afc where fangId=10002254 and fangAfcStime < 1552918477 and fangAfcEtime > 1552918477 and isDel=0 order by fangAfcId DESC limit 1 [ RunTime:0.0010s ]
select fangPicUrl from br_fang_pic where fangId=10002254 and fangPicType in (4,11,12) and isDel=0 order by fangPicOrder desc,fangPicId DESC limit 1 [ RunTime:0.0140s ]
select fangAreaName from br_fang_area where fangAreaId=290 limit 1 [ RunTime:0.0007s ]
select fangAddress,fang400,fangCharachteristic from br_fang_newinfo where fangId=10003056 limit 1 [ RunTime:0.0008s ]
SELECT * FROM `br_list400` WHERE `fangId` = 10003056 LIMIT 1 [ RunTime:0.0009s ]
SELECT * FROM `br_fang_type` WHERE `fangTypeId` = 1579 LIMIT 1 [ RunTime:0.0007s ]
select fangAfcDiscount,fangAfcStime,fangAfcEtime from br_fang_afc where fangId=10003056 and fangAfcStime < 1552918477 and fangAfcEtime > 1552918477 and isDel=0 order by fangAfcId DESC limit 1 [ RunTime:0.0011s ]
select fangPicUrl from br_fang_pic where fangId=10003056 and fangPicType in (4,11,12) and isDel=0 order by fangPicOrder desc,fangPicId DESC limit 1 [ RunTime:0.0136s ]
select fangAreaName from br_fang_area where fangAreaId=290 limit 1 [ RunTime:0.0008s ]
select fangAddress,fang400,fangCharachteristic from br_fang_newinfo where fangId=10000977 limit 1 [ RunTime:0.0007s ]
SELECT * FROM `br_list400` WHERE `fangId` = 10000977 LIMIT 1 [ RunTime:0.0009s ]
SELECT * FROM `br_fang_type` WHERE `fangTypeId` = 463 LIMIT 1 [ RunTime:0.0006s ]
select fangAfcDiscount,fangAfcStime,fangAfcEtime from br_fang_afc where fangId=10000977 and fangAfcStime < 1552918477 and fangAfcEtime > 1552918477 and isDel=0 order by fangAfcId DESC limit 1 [ RunTime:0.0011s ]
select fangPicUrl from br_fang_pic where fangId=10000977 and fangPicType in (4,11,12) and isDel=0 order by fangPicOrder desc,fangPicId DESC limit 1 [ RunTime:0.0136s ]
select fangAreaName from br_fang_area where fangAreaId=290 limit 1 [ RunTime:0.0007s ]
SHOW COLUMNS FROM `br_fang_new` [ RunTime:0.0012s ]
SELECT a.fangId,a.fangName,a.fangPrice,a.fangCityareaId FROM br_fang_new a left join br_fang_newinfo b on a.fangId=b.fangId WHERE a.cityId = '340100' AND a.isDel = 0 AND a.fangType = 1 AND b.fangRecommend LIKE '%1401%' AND a.fangSellType <> 610 LIMIT 8 [ RunTime:0.0068s ]
SELECT * FROM `br_basic_city` WHERE `cityId` = 340100 ORDER BY orderBY desc LIMIT 1 [ RunTime:0.0009s ]
SELECT * FROM `br_basic_link` WHERE `cityId` = '340100' AND `isDel` = 0 ORDER BY linkSort desc,linkId asc [ RunTime:0.0010s ]
SHOW COLUMNS FROM `br_fang_afc` [ RunTime:0.0009s ]
SHOW COLUMNS FROM `br_fang_pic` [ RunTime:0.0008s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002023' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0176s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002401' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0178s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002567' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002902' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002934' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002941' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0176s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002954' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10003032' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT a.fangId,a.fangName,a.fangPrice,a.fangCityareaId FROM br_fang_new a left join br_fang_newinfo b on a.fangId=b.fangId WHERE a.cityId = '340100' AND a.isDel = 0 AND a.fangType = 1 AND b.fangRecommend LIKE '%1392%' AND a.fangSellType <> 610 LIMIT 8 [ RunTime:0.0060s ]
SELECT * FROM `br_basic_city` WHERE `cityId` = 340100 ORDER BY orderBY desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_basic_link` WHERE `cityId` = '340100' AND `isDel` = 0 ORDER BY linkSort desc,linkId asc [ RunTime:0.0010s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10001314' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0178s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10001583' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002277' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0178s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002322' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002354' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002385' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002902' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0176s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 AND `fangId` = '10002944' ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0177s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangId` FROM `br_fang_new` WHERE ( isDel=0 and cityId=340100 and fangtype=1 and fangSellType<610 ) ORDER BY rand() LIMIT 5 [ RunTime:0.0042s ]
SELECT * FROM `br_fang_new` WHERE `fangId` = 10001336 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SHOW COLUMNS FROM `br_fang_newinfo` [ RunTime:0.0014s ]
SELECT * FROM `br_fang_newinfo` WHERE `fangId` = 10001336 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_new` WHERE `fangId` = 10002346 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_newinfo` WHERE `fangId` = 10002346 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_new` WHERE `fangId` = 10003081 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_newinfo` WHERE `fangId` = 10003081 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_new` WHERE `fangId` = 10000371 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_newinfo` WHERE `fangId` = 10000371 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_new` WHERE `fangId` = 10000126 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_newinfo` WHERE `fangId` = 10000126 ORDER BY fangId desc LIMIT 1 [ RunTime:0.0008s ]
SELECT * FROM `br_fang_area` WHERE ( fangAreaFid=0 and fangAreaIsDel=0 ) ORDER BY fangAreaId desc [ RunTime:0.0011s ]
SELECT `fangPicId`,`fangPicUrl`,`fangId`,`fangPicOrder` FROM `br_fang_pic` WHERE `fangPicType` IN ('1','4') AND `isDel` = 0 ORDER BY fangPicOrder desc,fangPicId desc LIMIT 2000 [ RunTime:0.0313s ]

优惠楼盘本月开盘3个合肥楼盘满足您的需求

金保合肥中心在售

星河广场待售

蓝鼎星河府售罄

热门楼盘

推荐楼盘

购房百科

猜你喜欢

优惠信息

全部楼盘优惠楼盘本月开盘3个合肥楼盘满足您的需求

金保合肥中心在售

星河广场待售

蓝鼎星河府售罄

热门楼盘

推荐楼盘

购房百科

猜你喜欢

优惠信息

优惠楼盘本月开盘3个合肥楼盘满足您的需求