[ DB ] CONNECT:[ UseTime:0.000297s ] mysql:host=127.0.0.1;port=3306;dbname=fang6;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fls_seo_list` [ RunTime:0.001429s ]
[ SQL ] SELECT * FROM `fls_seo_list` WHERE `s_status` = 1 LIMIT 1 [ RunTime:0.000334s ]
[ SQL ] SHOW COLUMNS FROM `fls_area` [ RunTime:0.001305s ]
[ SQL ] SELECT * FROM `fls_area` WHERE `name` LIKE '%孝感%' LIMIT 1 [ RunTime:0.001463s ]
[ SQL ] SHOW COLUMNS FROM `fls_search_house` [ RunTime:0.001228s ]
[ SQL ] SELECT * FROM `fls_search_house` WHERE `area_id` = '4209' AND `type_id` IN (1,2) AND `time` = 1593532800 [ RunTime:0.000405s ]
[ SQL ] SELECT * FROM `fls_search_house` WHERE `area_id` = '4209' AND `type_id` IN (1,2) AND `time` = 1590940800 [ RunTime:0.000340s ]
[ SQL ] SELECT group_concat(this_month_price order by time asc ) price,group_concat(FROM_UNIXTIME(time,"%m月") order by time asc) time,type_id FROM `fls_search_house` WHERE `area_id` = '4209' AND `time` >= 1577808000 GROUP BY `type_id` ORDER BY `type_id` ASC [ RunTime:0.000362s ]
[ SQL ] SHOW COLUMNS FROM `fls_priceinfo` [ RunTime:0.001174s ]
[ SQL ] SELECT p.id,p.house_id,p.house_type,p.p_avgprice,p.p_startprice,p.change_price,p.rate,max(p_date) p_date,sh.house_domain FROM `fls_priceinfo` `p` LEFT JOIN `fls_second_house` `sh` ON `sh`.`id`=`p`.`house_type` WHERE `p`.`change_type` = 1 GROUP BY `house_id` ORDER BY `rate` DESC LIMIT 10 [ RunTime:0.000372s ]
[ SQL ] SELECT p.id,p.house_id,p.house_type,p.p_avgprice,p.p_startprice,p.change_price,p.rate,max(p_date) p_date,sh.house_domain FROM `fls_priceinfo` `p` LEFT JOIN `fls_second_house` `sh` ON `sh`.`id`=`p`.`house_type` WHERE `p`.`change_type` = 0 GROUP BY `house_id` ORDER BY `rate` DESC LIMIT 10 [ RunTime:0.000382s ]
[ SQL ] SHOW COLUMNS FROM `fls_tradelog` [ RunTime:0.001161s ]
[ SQL ] SELECT count(*) count,house_id,b_type,deal_avgprice FROM `fls_tradelog` GROUP BY `house_id` ORDER BY `count` DESC [ RunTime:0.000332s ]
[ SQL ] SHOW COLUMNS FROM `fls_house` [ RunTime:0.001572s ]
[ SQL ] SELECT `id`,`house_title`,`house_domain` FROM `fls_house` WHERE `id` = 163 LIMIT 1 [ RunTime:0.000338s ]
[ SQL ] SELECT `id`,`house_title`,`house_domain` FROM `fls_house` WHERE `id` = 199 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT `id`,`house_title`,`house_domain` FROM `fls_house` WHERE `id` = 153 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT `id`,`house_title`,`house_domain` FROM `fls_house` WHERE `id` = 206 LIMIT 1 [ RunTime:0.000252s ]
[ SQL ] SELECT `id`,`house_title`,`house_domain` FROM `fls_house` WHERE `id` = 211 LIMIT 1 [ RunTime:0.000252s ]
[ SQL ] SHOW COLUMNS FROM `fls_buildings` [ RunTime:0.001452s ]
[ SQL ] SELECT `b`.`id`,`b`.`b_imgs`,`b`.`b_type`,`b`.`b_name`,`b`.`b_price`,`b`.`b_market_price`,`b`.`b_activity_price`,`b`.`b_orientation`,`b`.`b_acreage`,`b`.`b_huxing` FROM `fls_buildings` `b` LEFT JOIN `fls_house` `h` ON `b`.`b_house_id`=`h`.`id` LEFT JOIN `fls_second_house` `sh` ON `b`.`b_house_id`=`sh`.`id` WHERE `b`.`b_type` <= 2 AND `b`.`b_isspecial_price` = 1 AND ( `h`.`city` = 4209 OR `sh`.`city` = 4209 ) ORDER BY `b`.`id` DESC LIMIT 5 [ RunTime:0.000512s ]
[ SQL ] SHOW COLUMNS FROM `fls_theme_file` [ RunTime:0.001142s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'house/house/index' LIMIT 1 [ RunTime:0.000318s ]
[ SQL ] UPDATE `fls_theme_file` SET `theme`='simpleboot3',`action`='portal/Article/index',`file`='house/house/index',`name`='文章页',`more`='{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`config_more`='{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`description`='文章页模板文件',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'house/house/index' [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000298s ]
[ SQL ] UPDATE `fls_theme_file` SET `theme`='simpleboot3',`action`='public/Config',`file`='public/config',`name`='模板全局配置',`more`='{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}',`config_more`='{\"vars\":{\"enable_mobile\":{\"title\":\"\\u624b\\u673a\\u6ce8\\u518c\",\"value\":1,\"type\":\"select\",\"options\":{\"1\":\"\\u5f00\\u542f\",\"0\":\"\\u5173\\u95ed\"},\"tip\":\"\"}}}',`description`='模板全局配置文件',`is_public`=1,`list_order`=0 WHERE `theme` = 'simpleboot3' AND `file` = 'public/config' [ RunTime:0.000342s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000312s ]
[ SQL ] UPDATE `fls_theme_file` SET `theme`='simpleboot3',`action`='public/Nav',`file`='public/nav',`name`='导航条',`more`='{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`config_more`='{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"ThinkCMF\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}',`description`='导航条模板文件',`is_public`=1,`list_order`=1 WHERE `theme` = 'simpleboot3' AND `file` = 'public/nav' [ RunTime:0.000355s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000290s ]
[ SQL ] SHOW COLUMNS FROM `fls_theme` [ RunTime:0.001143s ]
[ SQL ] SELECT `more` FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'house/search_price/search_price' ) [ RunTime:0.000302s ]
[ SQL ] SHOW COLUMNS FROM `fls_ad_position` [ RunTime:0.001153s ]
[ SQL ] SELECT `id`,`name`,`tag`,`url` FROM `fls_ad_position` WHERE ( class_id=14 ) ORDER BY `ordernum` ASC [ RunTime:0.000387s ]
[ SQL ] SHOW COLUMNS FROM `fls_ad` [ RunTime:0.001134s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_index' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000867s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_new_house' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000953s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_second_house' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000934s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_shop' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000940s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_rent' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000939s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_message' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000906s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_knowledge' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000896s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_interlocution' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000841s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'menu_more' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000878s ]
[ SQL ] SELECT * FROM `fls_area` WHERE ( pid=4209 ) [ RunTime:0.000309s ]
