[ DB ] CONNECT:[ UseTime:0.000338s ] mysql:dbname=xdc_web;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `system_station` [ RunTime:0.000985s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000298s ]
[ SQL ] SHOW COLUMNS FROM `newhouse_area` [ RunTime:0.000544s ]
[ SQL ] SELECT * FROM `newhouse_area` WHERE `areaName` = '蚌埠市' AND `siteId` = 340300 LIMIT 1 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `newhouse_area` WHERE `parentId` = 23 AND `status` = 1 [ RunTime:0.000414s ]
[ SQL ] SHOW COLUMNS FROM `system_config_content` [ RunTime:0.000538s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'ROOM' [ RunTime:0.000280s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'HOUSE-AREA' [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'PROPERTY-TYPE' [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'BUILDING-FEATURE' [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'SEARCH-PRICE' [ RunTime:0.000418s ]
[ SQL ] SELECT * FROM `newhouse_area` WHERE `siteId` = 340300 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT * FROM `newhouse_area` WHERE `parentId` = 23 [ RunTime:0.000317s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'HOUSE-AREA' [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'PROPERTY-TYPE' [ RunTime:0.000265s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'SEARCH-PRICE' [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'ROOM' [ RunTime:0.000233s ]
[ SQL ] SELECT * FROM `system_config_content` WHERE `sign` = 'BUILDING-FEATURE' [ RunTime:0.000277s ]
[ SQL ] SHOW COLUMNS FROM `newhouse_position` [ RunTime:0.000454s ]
[ SQL ] SELECT * FROM `newhouse_position` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SHOW COLUMNS FROM `newhouse_position_data` [ RunTime:0.000484s ]
[ SQL ] SELECT * FROM `newhouse_position_data` WHERE `posId` = 15 AND `siteId` = 340300 ORDER BY listOrder DESC,id DESC LIMIT 5 [ RunTime:0.001109s ]
[ SQL ] SHOW COLUMNS FROM `newhouse_project` [ RunTime:0.000891s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 5205 [ RunTime:0.000236s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 5181 [ RunTime:0.000187s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 5129 [ RunTime:0.000188s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 3631 [ RunTime:0.000187s ]
[ SQL ] SHOW COLUMNS FROM `newhouse_news` [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `newsType` = 0 AND `siteId` = 340300 AND `createTime` > 1531727524 AND `status` = 1 ORDER BY hits DESC LIMIT 8 [ RunTime:3.551152s ]
[ SQL ] SELECT * FROM `newhouse_position` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000384s ]
[ SQL ] SELECT * FROM `newhouse_position_data` WHERE `posId` = 17 AND `siteId` = 340300 ORDER BY listOrder DESC,id DESC LIMIT 4 [ RunTime:0.000801s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 4631 [ RunTime:0.000232s ]
[ SQL ] SELECT * FROM `newhouse_position` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT * FROM `newhouse_position_data` WHERE `posId` = 18 AND `siteId` = 340300 ORDER BY listOrder DESC,id DESC LIMIT 4 [ RunTime:0.000655s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 4870 [ RunTime:0.000257s ]
[ SQL ] SELECT * FROM `newhouse_position` WHERE `id` = 19 LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT * FROM `newhouse_position_data` WHERE `posId` = 19 AND `siteId` = 340300 ORDER BY listOrder DESC,id DESC LIMIT 4 [ RunTime:0.000919s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 5088 [ RunTime:0.000245s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 3631 [ RunTime:0.001000s ]
[ SQL ] SELECT * FROM `newhouse_position` WHERE `id` = 15 LIMIT 1 [ RunTime:0.000261s ]
[ SQL ] SELECT * FROM `newhouse_position_data` WHERE `posId` = 15 AND `siteId` = 340300 ORDER BY listOrder DESC,id DESC LIMIT 4 [ RunTime:0.001114s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 5205 [ RunTime:0.000253s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 5181 [ RunTime:0.000198s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 5129 [ RunTime:0.000200s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 3631 [ RunTime:0.000195s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `siteId` = 340300 AND ( `pId` <> 0 and `pId` <> 0 and `pId` <> 0 ) AND `status` = 1 ORDER BY id DESC LIMIT 6 [ RunTime:2.775366s ]
[ SQL ] SELECT * FROM `newhouse_position` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000579s ]
[ SQL ] SELECT * FROM `newhouse_position_data` WHERE `posId` = 36 AND `siteId` = 340300 ORDER BY listOrder DESC,id DESC LIMIT 5 [ RunTime:0.003546s ]
[ SQL ] SELECT updateTime as Time FROM `newhouse_project` WHERE `id` = 654457 [ RunTime:0.000248s ]
[ SQL ] SELECT * FROM `newhouse_area` [ RunTime:0.000583s ]
[ SQL ] SHOW COLUMNS FROM `newhouse_grouppurchase` [ RunTime:0.001381s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `newhouse_grouppurchase` `a` INNER JOIN `newhouse_project` `b` ON `a`.`pId`=`b`.`id` INNER JOIN `newhouse_project_part` `c` ON `a`.`pId`=`c`.`pId` WHERE `a`.`status` = 1 AND `a`.`endTime` > 1532332330 LIMIT 1 [ RunTime:0.000445s ]
[ SQL ] SELECT `a`.`id`,`a`.`pId`,`a`.`offers`,`a`.`endTime`,`b`.`projectName`,`b`.`areaId`,`b`.`thumb`,`b`.`freePhone` FROM `newhouse_grouppurchase` `a` INNER JOIN `newhouse_project` `b` ON `a`.`pId`=`b`.`id` INNER JOIN `newhouse_project_part` `c` ON `a`.`pId`=`c`.`pId` WHERE `a`.`status` = 1 AND `a`.`endTime` > 1532332330 ORDER BY a.listOrder DESC,a.id DESC LIMIT 0,10 [ RunTime:0.000519s ]
[ SQL ] SHOW COLUMNS FROM `newhouse_ad` [ RunTime:0.001079s ]
[ SQL ] SELECT * FROM `newhouse_ad` WHERE `startDate` < 1532332330 AND `endDate` > 1532332330 AND `siteId` = 340300 AND `spaceId` = 35 AND `status` = 1 ORDER BY listOrder DESC,id DESC LIMIT 2 [ RunTime:0.001286s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654457 LIMIT 1 [ RunTime:2.441307s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654457 LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654456 LIMIT 1 [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654456 LIMIT 1 [ RunTime:0.000400s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654433 LIMIT 1 [ RunTime:0.000331s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000271s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654433 LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654430 LIMIT 1 [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654430 LIMIT 1 [ RunTime:0.000408s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654429 LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT * FROM `newhouse_news` WHERE `id` = 654429 LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SELECT * FROM `system_station` WHERE `code` = 340300 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 949 LIMIT 1 [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 949 LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SELECT `b`.`averagePrice`,`b`.`averagePriceStr`,`b`.`showAveragePrice` FROM `newhouse_project` `a` INNER JOIN `newhouse_project_part` `b` ON `a`.`id`=`b`.`pid` WHERE `a`.`id` = 25 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 3511 LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 3511 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SELECT `b`.`averagePrice`,`b`.`averagePriceStr`,`b`.`showAveragePrice` FROM `newhouse_project` `a` INNER JOIN `newhouse_project_part` `b` ON `a`.`id`=`b`.`pid` WHERE `a`.`id` = 24 LIMIT 1 [ RunTime:0.000401s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 5164 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 5164 LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT `b`.`averagePrice`,`b`.`averagePriceStr`,`b`.`showAveragePrice` FROM `newhouse_project` `a` INNER JOIN `newhouse_project_part` `b` ON `a`.`id`=`b`.`pid` WHERE `a`.`id` = 20 LIMIT 1 [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 4824 LIMIT 1 [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 4824 LIMIT 1 [ RunTime:0.000316s ]
[ SQL ] SELECT `b`.`averagePrice`,`b`.`averagePriceStr`,`b`.`showAveragePrice` FROM `newhouse_project` `a` INNER JOIN `newhouse_project_part` `b` ON `a`.`id`=`b`.`pid` WHERE `a`.`id` = 19 LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 5072 LIMIT 1 [ RunTime:0.000329s ]
[ SQL ] SELECT * FROM `newhouse_project` WHERE `id` = 5072 LIMIT 1 [ RunTime:0.000307s ]
[ SQL ] SELECT `b`.`averagePrice`,`b`.`averagePriceStr`,`b`.`showAveragePrice` FROM `newhouse_project` `a` INNER JOIN `newhouse_project_part` `b` ON `a`.`id`=`b`.`pid` WHERE `a`.`id` = 17 LIMIT 1 [ RunTime:0.000249s ]
