[ BEHAVIOR ] Run \addons\cms\Cms @response_send [ RunTime:0.000339s ]
[ DB ] CONNECT:[ UseTime:0.003949s ] mysql:host=rm-uf61btl93c9wcwhe4.mysql.rds.aliyuncs.com;port=3306;dbname=fangchan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fcw_search_keyword` [ RunTime:0.000939s ]
[ SQL ] SELECT * FROM `fcw_search_keyword` ORDER BY `number` DESC LIMIT 10 [ RunTime:0.004952s ]
[ SQL ] SHOW COLUMNS FROM `fcw_property` [ RunTime:0.001046s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_property` WHERE `property_code` <> '' LIMIT 1 [ RunTime:0.001309s ]
[ SQL ] SHOW COLUMNS FROM `fcw_office` [ RunTime:0.000960s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_office` WHERE `property_code` <> '' LIMIT 1 [ RunTime:0.009815s ]
[ SQL ] SHOW COLUMNS FROM `fcw_sharework` [ RunTime:0.000906s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_sharework` WHERE `property_code` <> '' LIMIT 1 [ RunTime:0.001594s ]
[ SQL ] SHOW COLUMNS FROM `fcw_area` [ RunTime:0.000840s ]
[ SQL ] SELECT * FROM `fcw_area` WHERE `pid` = 802 [ RunTime:0.000721s ]
[ SQL ] SHOW COLUMNS FROM `fcw_metro` [ RunTime:0.000864s ]
[ SQL ] SELECT * FROM `fcw_metro` WHERE `city` = '802' ORDER BY `order` [ RunTime:0.000746s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `id` = 817 LIMIT 1 [ RunTime:0.000578s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_property` WHERE `area` = '817' LIMIT 1 [ RunTime:0.002245s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_office` WHERE `property_code` IN ( SELECT `property_code` FROM `fcw_property` WHERE `area` = '817' ) LIMIT 1 [ RunTime:0.002526s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_sharework` WHERE `property_code` IN ( SELECT `property_code` FROM `fcw_property` WHERE `area` = '817' ) LIMIT 1 [ RunTime:0.010577s ]
[ SQL ] SHOW COLUMNS FROM `fcw_business_zone` [ RunTime:0.000842s ]
[ SQL ] SELECT * FROM `fcw_business_zone` WHERE `area` = '817' [ RunTime:0.000922s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `pid` = 802 LIMIT 1 [ RunTime:0.000620s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `id` = 817 AND `pid` = 802 LIMIT 1 [ RunTime:0.000586s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `pid` = 802 LIMIT 1 [ RunTime:0.000643s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `id` = 817 AND `pid` = 802 LIMIT 1 [ RunTime:0.000563s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `pid` = 802 LIMIT 1 [ RunTime:0.000646s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `id` = 817 AND `pid` = 802 LIMIT 1 [ RunTime:0.000623s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `pid` = 802 LIMIT 1 [ RunTime:0.000598s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `id` = 817 AND `pid` = 802 LIMIT 1 [ RunTime:0.000557s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `pid` = 802 LIMIT 1 [ RunTime:0.000559s ]
[ SQL ] SELECT `shortname` FROM `fcw_area` WHERE `id` = 817 AND `pid` = 802 LIMIT 1 [ RunTime:0.000593s ]
[ SQL ] SELECT * FROM `fcw_area` WHERE `pid` = 802 [ RunTime:0.000662s ]
[ SQL ] SELECT * FROM `fcw_business_zone` WHERE `city` = '802' [ RunTime:0.001322s ]
[ SQL ] SHOW COLUMNS FROM `fcw_cms_archives` [ RunTime:0.000987s ]
[ SQL ] SELECT * FROM `fcw_cms_archives` WHERE `fcw_cms_archives`.`deletetime` IS NULL ORDER BY `createtime` DESC LIMIT 10 [ RunTime:0.001140s ]
[ SQL ] SHOW COLUMNS FROM `fcw_office_images` [ RunTime:0.000773s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000667s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000629s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000652s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000619s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000608s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000638s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000608s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000643s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000617s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000578s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000576s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000590s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000632s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000596s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000598s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000564s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000669s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000672s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000652s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112337254' LIMIT 1 [ RunTime:0.000602s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000610s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000569s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000646s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000644s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000628s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000614s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000699s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000618s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000680s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000649s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000621s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000688s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000646s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000611s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000662s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000686s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000669s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000606s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000629s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000627s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000648s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000588s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000601s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000571s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000586s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000578s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000613s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000602s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000598s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000570s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000641s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000655s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000646s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000584s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000606s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000572s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000639s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000587s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000607s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112360312' LIMIT 1 [ RunTime:0.000553s ]
上海
办公楼共计39套
