[ BEHAVIOR ] Run \addons\cms\Cms @response_send [ RunTime:0.000206s ]
[ DB ] CONNECT:[ UseTime:0.001320s ] mysql:host=rm-uf61btl93c9wcwhe4.mysql.rds.aliyuncs.com;port=3306;dbname=fangchan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fcw_search_keyword` [ RunTime:0.000959s ]
[ SQL ] SELECT * FROM `fcw_search_keyword` ORDER BY `number` DESC LIMIT 10 [ RunTime:0.004985s ]
[ SQL ] SHOW COLUMNS FROM `fcw_property` [ RunTime:0.001033s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_property` WHERE `property_code` <> '' LIMIT 1 [ RunTime:0.001269s ]
[ SQL ] SHOW COLUMNS FROM `fcw_office` [ RunTime:0.000968s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_office` WHERE `property_code` <> '' LIMIT 1 [ RunTime:0.010243s ]
[ SQL ] SHOW COLUMNS FROM `fcw_sharework` [ RunTime:0.000965s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_sharework` WHERE `property_code` <> '' LIMIT 1 [ RunTime:0.001633s ]
[ SQL ] SHOW COLUMNS FROM `fcw_area` [ RunTime:0.000788s ]
[ SQL ] SELECT * FROM `fcw_area` WHERE `pid` = 802 [ RunTime:0.000740s ]
[ SQL ] SHOW COLUMNS FROM `fcw_metro` [ RunTime:0.000796s ]
[ SQL ] SELECT * FROM `fcw_metro` WHERE `city` = '802' ORDER BY `order` [ RunTime:0.000740s ]
[ SQL ] SHOW COLUMNS FROM `fcw_business_zone` [ RunTime:0.000797s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `id` = 139 LIMIT 1 [ RunTime:0.000556s ]
[ SQL ] SELECT `business_code` FROM `fcw_business_zone` WHERE `id` = 139 LIMIT 1 [ RunTime:0.000558s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fcw_office` `o` LEFT JOIN `fcw_property` `p` ON `o`.`property_code`=`p`.`property_code` LEFT JOIN `fcw_business_zone` `z` ON `z`.`business_code`=`p`.`business_code` WHERE `z`.`business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.002722s ]
[ SQL ] SELECT `o`.* FROM `fcw_office` `o` LEFT JOIN `fcw_property` `p` ON `o`.`property_code`=`p`.`property_code` LEFT JOIN `fcw_business_zone` `z` ON `z`.`business_code`=`p`.`business_code` WHERE `z`.`business_code` = 'BZ2019112357208' ORDER BY `o`.`update_time` DESC,`o`.`id` DESC LIMIT 0,30 [ RunTime:0.002873s ]
[ SQL ] SELECT * FROM `fcw_area` WHERE `pid` = 802 [ RunTime:0.000678s ]
[ SQL ] SELECT * FROM `fcw_business_zone` WHERE `city` = '802' [ RunTime:0.001357s ]
[ SQL ] SHOW COLUMNS FROM `fcw_cms_archives` [ RunTime:0.000921s ]
[ SQL ] SELECT * FROM `fcw_cms_archives` WHERE `fcw_cms_archives`.`deletetime` IS NULL ORDER BY `createtime` DESC LIMIT 10 [ RunTime:0.001170s ]
[ SQL ] SHOW COLUMNS FROM `fcw_office_images` [ RunTime:0.000751s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000630s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000614s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000589s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000621s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000644s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000599s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000639s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000598s ]
[ SQL ] SELECT `id` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000619s ]
[ SQL ] SELECT `business_name` FROM `fcw_business_zone` WHERE `business_code` = 'BZ2019112357208' LIMIT 1 [ RunTime:0.000592s ]
上海
办公楼共计2817套
