[ DB ] CONNECT:[ UseTime:0.000384s ] mysql:host=127.0.0.1;port=3306;dbname=fang6;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fls_seo_list` [ RunTime:0.001449s ]
[ SQL ] SELECT * FROM `fls_seo_list` WHERE `s_status` = 1 LIMIT 1 [ RunTime:0.000350s ]
[ SQL ] SHOW COLUMNS FROM `fls_huxing_name` [ RunTime:0.001136s ]
[ SQL ] SELECT * FROM `fls_huxing_name` [ RunTime:0.000218s ]
[ SQL ] SHOW COLUMNS FROM `fls_area` [ RunTime:0.001083s ]
[ SQL ] SELECT * FROM `fls_area` WHERE ( pid=4209 ) [ RunTime:0.000322s ]
[ SQL ] SHOW COLUMNS FROM `fls_buildings` [ RunTime:0.001469s ]
[ SQL ] SELECT COUNT(*) AS tp_count 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` LEFT JOIN `fls_house_tags` `ht` ON `h`.`house_tags`=`ht`.`id` LEFT JOIN `fls_house_detail` `hd` ON `hd`.`house_id`=`h`.`id` WHERE `b`.`b_type` = '3' AND `b`.`is_rent` = '1' LIMIT 1 [ RunTime:0.000746s ]
[ SQL ] SELECT b.id,b.b_house_id,b.b_imgs,b.b_name,b.b_name,b.b_acreage,b.b_orientation,b_sale_status,b.b_price,b.b_amount,b.b_lease,b.feature,b.b_create_time,
(CASE WHEN b.house_type = 1 THEN h.house_address WHEN b.house_type = 2 THEN sh.house_address END) house_address,
(CASE WHEN b.house_type = 1 THEN h.province WHEN b.house_type = 2 THEN sh.province END) province,
(CASE WHEN b.house_type = 1 THEN h.city WHEN b.house_type = 2 THEN sh.city END) city,
(CASE WHEN b.house_type = 1 THEN h.area WHEN b.house_type = 2 THEN sh.area END) area,
(CASE WHEN b.house_type = 1 THEN h.house_type WHEN b.house_type = 2 THEN sh.house_type END) house_type,
(CASE WHEN b.house_type = 1 THEN h.house_title WHEN b.house_type = 2 THEN sh.house_title END) house_title,
(CASE WHEN b.house_type = 1 THEN h.house_tags WHEN b.house_type = 2 THEN sh.house_tags END) house_tags,
hd.d_decoration 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` LEFT JOIN `fls_house_tags` `ht` ON `h`.`house_tags`=`ht`.`id` LEFT JOIN `fls_house_detail` `hd` ON `hd`.`house_id`=`h`.`id` WHERE `b`.`b_type` = '3' AND `b`.`is_rent` = '1' ORDER BY `b`.`b_create_time` DESC LIMIT 0,10 [ RunTime:0.001183s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 42 LIMIT 1 [ RunTime:0.000251s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 4209 LIMIT 1 [ RunTime:0.000236s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 420902 LIMIT 1 [ RunTime:0.000221s ]
[ SQL ] SHOW COLUMNS FROM `fls_house_tags` [ RunTime:0.001079s ]
[ SQL ] SELECT `id`,`tags_name` FROM `fls_house_tags` WHERE `id` IN (3) [ RunTime:0.000251s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 42 LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 4209 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 420902 LIMIT 1 [ RunTime:0.000216s ]
[ SQL ] SELECT `id`,`tags_name` FROM `fls_house_tags` WHERE `id` IN (0) [ RunTime:0.000199s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 42 LIMIT 1 [ RunTime:0.000239s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 4209 LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT `name` FROM `fls_area` WHERE `code` = 420902 LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] SELECT `id`,`tags_name` FROM `fls_house_tags` WHERE `id` IN (0) [ RunTime:0.000198s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_buildings` `b` LEFT JOIN `fls_house` `h` ON `b`.`b_house_id`=`h`.`id` LEFT JOIN `fls_house_tags` `ht` ON `h`.`house_tags`=`ht`.`id` LEFT JOIN `fls_house_detail` `hd` ON `hd`.`house_id`=`h`.`id` WHERE `b`.`b_type` = '3' AND `b`.`is_rent` = '1' ORDER BY `b`.`b_create_time` DESC LIMIT 1 [ RunTime:0.000555s ]
[ SQL ] SHOW COLUMNS FROM `fls_message_category` [ RunTime:0.001146s ]
[ SQL ] SELECT `id`,`parent_id`,`post_count`,`status`,`delete_time`,`list_order`,`name`,`description`,`path`,`seo_title`,`seo_keywords`,`seo_description`,`list_tpl`,`one_tpl`,`more` FROM `fls_message_category` `message_category` WHERE `delete_time` = 0 AND `message_category`.`status` = 1 AND `id` = 2 LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] SHOW COLUMNS FROM `fls_message_category_post` [ RunTime:0.001116s ]
[ SQL ] SELECT * FROM `fls_message_category_post` WHERE `category_id` = 2 [ RunTime:0.000603s ]
[ SQL ] SHOW COLUMNS FROM `fls_message_post` [ RunTime:0.002358s ]
[ SQL ] SELECT * FROM `fls_message_post` WHERE `id` IN (21,22,31,160,170,171,174,175,179,180,181,182,183,184,185,186,187,188,192,190,193,196,216,220,374,375,380,381,385,386,390,400,401,402,411,414,420,436,452,454,456,473,479,481,497,503,539,542,544,564,571,577,583,591,615,637,638,640,660,663,668,686,690,693,706,712,713,722,724,736,753,757,758,761,762,763,768,774,776,779,783,793,794,808,811,879,943,949,955,964,966,967,970,987,993,1000,1003,1010,1014,1017,1020,1023,1026,1029,1033,1040,1043,1046,1050,1053,1061,1072,1073,1082,1084,1085,1087,1094,1095,1098,1104,1107,1109,1110,1206,1239,1249,1252,1256,1257,1264,1267,1308) AND `delete_time` = 0 ORDER BY `update_time` DESC [ RunTime:0.003420s ]
[ SQL ] SHOW COLUMNS FROM `fls_knowledge_category` [ RunTime:0.001409s ]
[ SQL ] SELECT * FROM `fls_knowledge_category` WHERE ( status=1 and parent_id=1 ) [ RunTime:0.000438s ]
[ SQL ] SHOW COLUMNS FROM `fls_knowledge` [ RunTime:0.001162s ]
[ SQL ] SELECT * FROM `fls_knowledge` `k` LEFT JOIN `fls_knowledge_category` `kc` ON `kc`.`id`=`k`.`cate_id` WHERE `kc`.`parent_id` IN (18,22) AND `k`.`status` = 1 ORDER BY `sort` LIMIT 8 [ RunTime:0.000787s ]
[ SQL ] SHOW COLUMNS FROM `fls_interlocution_problem` [ RunTime:0.001212s ]
[ SQL ] SELECT `id`,`p_title` FROM `fls_interlocution_problem` WHERE ( status=1 ) ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000340s ]
[ SQL ] SELECT `id`,`tags_name` FROM `fls_house_tags` WHERE `tags_type` = 8 AND `tags_tag` = 'fy' [ RunTime:0.000311s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_buildings` `b` LEFT JOIN `fls_house` `h` ON `b`.`b_house_id`=`h`.`id` LEFT JOIN `fls_house_tags` `ht` ON `h`.`house_tags`=`ht`.`id` LEFT JOIN `fls_house_detail` `hd` ON `hd`.`house_id`=`h`.`id` WHERE `b`.`b_type` = '3' AND `b`.`is_rent` = '1' AND `h`.`house_tags` LIKE '%4%' LIMIT 1 [ RunTime:0.000459s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_buildings` `b` LEFT JOIN `fls_house` `h` ON `b`.`b_house_id`=`h`.`id` LEFT JOIN `fls_house_tags` `ht` ON `h`.`house_tags`=`ht`.`id` LEFT JOIN `fls_house_detail` `hd` ON `hd`.`house_id`=`h`.`id` WHERE `b`.`b_type` = '3' AND `b`.`is_rent` = '1' AND `h`.`house_tags` LIKE '%6%' LIMIT 1 [ RunTime:0.000449s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_buildings` `b` LEFT JOIN `fls_house` `h` ON `b`.`b_house_id`=`h`.`id` LEFT JOIN `fls_house_tags` `ht` ON `h`.`house_tags`=`ht`.`id` LEFT JOIN `fls_house_detail` `hd` ON `hd`.`house_id`=`h`.`id` WHERE `b`.`b_type` = '3' AND `b`.`is_rent` = '1' AND `h`.`house_tags` LIKE '%11%' LIMIT 1 [ RunTime:0.000448s ]
[ SQL ] SHOW COLUMNS FROM `fls_ad` [ RunTime:0.001213s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'rent_list_head' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000903s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'rent_list_center' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000902s ]
[ SQL ] SELECT `ad`.* FROM `fls_ad` `ad` LEFT JOIN `fls_ad_position` `ap` ON `ap`.`id`=`position_id` WHERE `ap`.`tag` = 'rent_list_bottom' AND `ad`.`isok` = 0 ORDER BY `ad`.`ordernum` ASC [ RunTime:0.000867s ]
[ SQL ] SELECT `id`,`b_imgs`,`b_name`,`b_market_price`,`b_activity_price`,`b_acreage` FROM `fls_buildings` WHERE `b_type` <> '4' AND `b_isspecial_price` = 1 LIMIT 5 [ RunTime:0.000371s ]
[ SQL ] SHOW COLUMNS FROM `fls_comment` [ RunTime:0.001334s ]
[ SQL ] SELECT *,count(object_id) as counts FROM `fls_comment` WHERE ( type=1 ) GROUP BY `object_id` ORDER BY `counts` ASC [ RunTime:0.001460s ]
[ SQL ] SHOW COLUMNS FROM `fls_house` [ RunTime:0.001718s ]
[ SQL ] SELECT * FROM `fls_house` WHERE ( id in (4,6,23,31,38,40,47,58,65,67,69,92,96,103,106,110,113,127,130,136,148,149,193,222,301,308,639,1214,5,8,30,51,55,75,80,120,144,173,174,451,452,453,146,280,21,43,36) and status=0 ) ORDER BY `sort` ASC,`create_time` DESC LIMIT 8 [ RunTime:0.000815s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =113 ) LIMIT 1 [ RunTime:0.000363s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =96 ) LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =173 ) LIMIT 1 [ RunTime:0.000297s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =174 ) LIMIT 1 [ RunTime:0.000302s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =146 ) LIMIT 1 [ RunTime:0.000379s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =120 ) LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =148 ) LIMIT 1 [ RunTime:0.000307s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fls_comment` WHERE ( type=1 and status=1 and object_id =110 ) LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] SELECT * FROM `fls_seo_list` WHERE `s_type` = '4' AND `s_status` = 1 LIMIT 1 [ RunTime:0.000322s ]
[ SQL ] SHOW COLUMNS FROM `fls_theme_file` [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'house/house/index' LIMIT 1 [ RunTime:0.000373s ]
[ 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.000437s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000331s ]
[ 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.000356s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000350s ]
[ 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.000380s ]
[ SQL ] SELECT * FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000300s ]
[ SQL ] SHOW COLUMNS FROM `fls_theme` [ RunTime:0.001197s ]
[ SQL ] SELECT `more` FROM `fls_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'house/index_buildings/index' ) [ RunTime:0.000341s ]
[ SQL ] SHOW COLUMNS FROM `fls_ad_position` [ RunTime:0.001215s ]
[ SQL ] SELECT `id`,`name`,`tag`,`url` FROM `fls_ad_position` WHERE ( class_id=14 ) ORDER BY `ordernum` ASC [ RunTime:0.000409s ]
[ 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.000850s ]
[ 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.000993s ]
[ 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.000979s ]
[ 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.000965s ]
[ 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.001024s ]
[ 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.000955s ]
[ 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.000998s ]
[ 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.000872s ]
[ 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.000918s ]
[ SQL ] SELECT * FROM `fls_area` WHERE ( pid=4209 ) [ RunTime:0.000317s ]
