url: =绿通设计 营该公司营业执照已认证 认 合作商家认证合作有效期至2022年05月29日\n2021-12-23 - 2022-01-31\n46m² / LOFT / 现代简约 / 全包\n黄浦区 / 卢湾区 / 徐汇区 / 长宁区 / 静安区 / 普陀区 / 闸北区 / 虹口区 / 杨浦区 / 闵行区 / 宝山区 / 嘉定区 / 浦东新区 / 金山区 / 松江区 / 青浦区 / 南汇区 / 奉贤区\n半包 / 全包 / 纯设计\n一居 / 二居 / 三居 / 四居及以上 / LOFT\n请求信息 : 2022-01-22 07:01:13 HTTP/1.1 GET : http://mzw669.xsmzw.com/company/225/\n运行时间 : 0.046125s [ 吞吐率：21.68req/s ] 内存消耗：4,369.27kb 文件加载：139\n会话信息 : SESSION_ID=9176143dcb90e9b8c2b302a3de12de77\nSELECT * FROM `tp_biz_banners` WHERE `bid` = 225 AND `status` = 1 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.000153s ]\nSELECT b.id, b.company_name, b.show_name, b.order_count, b.shop_tag, b.logo_url, b.baogongfangshi, b.huxing, b.gongzhuangkongjian, (select count(*) from tp_biz_cases where bid = b.id) as case_count, (select count(*) from tp_biz_designers where bid = b.id) as designer_count, (select count(*) from tp_biz_construction where bid = b.id) as construction_count, (select count(*) from tp_biz_constructors where bid = b.id) as constructor_count FROM `tp_biz` `b` WHERE `id` = 225 LIMIT 1 [ RunTime:0.000419s ]\nSHOW FULL COLUMNS FROM `tp_fields_setting` [ RunTime:0.000450s ]\nSELECT `text` FROM `tp_fields_setting` WHERE `type` = 'baogongfangshi' AND `value` IN (2,3,4) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000131s ]\nSELECT `text` FROM `tp_fields_setting` WHERE `type` = 'huxing' AND `value` IN (1,2,3,4,8) ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000119s ]\nSHOW FULL COLUMNS FROM `tp_biz_region_service` [ RunTime:0.000417s ]\nSELECT `rs`.*,`rl`.`region_showname`,`rl`.`regionStr` FROM `tp_biz_region_service` `rs` INNER JOIN `tp_region_list` `rl` ON `rs`.`regionCode`=`rl`.`regionCode` WHERE `rs`.`bid` = '225' [ RunTime:0.000150s ]\nSELECT `text`,`description`,`status`,`id` FROM `tp_fields_setting` WHERE `type` = 'shoptag' AND `status` > 0 ORDER BY `sort` DESC [ RunTime:0.000111s ]\nSELECT `value`,`text` FROM `tp_fields_setting` WHERE `type` = 'fengge' ORDER BY `sort` DESC,`id` ASC LIMIT 9 [ RunTime:0.000157s ]\nSHOW FULL COLUMNS FROM `tp_system_news_cate` [ RunTime:0.000434s ]\nSELECT * FROM `tp_region_list` WHERE `substation_status` = 1 AND `recommond_status` = 1 ORDER BY `id` ASC LIMIT 30 [ RunTime:0.000122s ]\nSHOW FULL COLUMNS FROM `tp_site_info` [ RunTime:0.000438s ]\nSELECT * FROM `tp_site_info` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000141s ]\nUPDATE `tp_biz` SET `visiter` = `visiter` + 1 WHERE `id` = 225 [ RunTime:0.001880s ]\nSHOW FULL COLUMNS FROM `tp_biz_promotion` [ RunTime:0.000497s ]\nSELECT * FROM `tp_biz_promotion` WHERE `bid` = 225 ORDER BY `sort` DESC,`id` DESC LIMIT 2 [ RunTime:0.000139s ]\nSELECT `text`,`value` FROM `tp_fields_setting` WHERE `type` = 'huxing' AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000109s ]\nSELECT `text`,`value` FROM `tp_fields_setting` WHERE `type` = 'fengge' AND `status` = 1 ORDER BY `sort` DESC [ RunTime:0.000101s ]\nSELECT `text`,`value` FROM `tp_fields_setting` WHERE `type` = 'baogongfangshi' ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000096s ]\nSHOW FULL COLUMNS FROM `tp_biz_cases` [ RunTime:0.000568s ]\nSELECT `id`,`title`,`type`,`yusuan`,`mianji`,`huxing`,`fengge`,`fangshi`,`gongzhuangkongjian`,`picture` FROM `tp_biz_cases` WHERE `bid` = 225 ORDER BY `id` DESC LIMIT 6 [ RunTime:0.000150s ]\nSHOW FULL COLUMNS FROM `tp_biz_designers` [ RunTime:0.000477s ]\nSELECT d.id, d.name, d.avatar, d.jingyan, d.zhiwei, (select count(*) from tp_biz_cases where shejishi = d.id) as cases_count FROM `tp_biz_designers` `d` WHERE `d`.`status` = '1' AND `d`.`bid` = '225' ORDER BY `sort` DESC LIMIT 5 [ RunTime:0.000149s ]\nSHOW FULL COLUMNS FROM `tp_biz_construction` [ RunTime:0.000499s ]\nSELECT c.id, c.xiaoqu, c.huxing, c.fengge, c.fangshi, c.mianji, (select pictures from tp_biz_construction_process where cid = c.id order by date desc limit 1) as pictures, (select count(*) from tp_biz_construction_process where cid = c.id) as process_count FROM `tp_biz_construction` `c` WHERE `c`.`xianshi_zt` = '1' AND `c`.`bid` = '225' LIMIT 3 [ RunTime:0.000169s ]\nSHOW FULL COLUMNS FROM `tp_biz_constructors` [ RunTime:0.000474s ]\nSELECT `c`.`id`,`c`.`name`,`c`.`avatar`,`c`.`jingyan`,`c`.`zhiwei` FROM `tp_biz_constructors` `c` WHERE `c`.`status` = '1' AND `c`.`bid` = '225' ORDER BY `c`.`sort` DESC LIMIT 5 [ RunTime:0.000128s ]\nSHOW FULL COLUMNS FROM `tp_user_diary` [ RunTime:0.000458s ]\nSELECT `d`.*,`u`.`username`,`u`.`avatar_url` FROM `tp_user_diary` `d` INNER JOIN `tp_users` `u` ON `u`.`id`=`d`.`uid` WHERE `d`.`zhuangxiugongsi` = '上海绿通装饰设计有限公司' ORDER BY `d`.`id` DESC LIMIT 10 [ RunTime:0.000158s ]\nSELECT COUNT(*) AS think_count FROM `tp_user_diary` WHERE `zhuangxiugongsi` = '上海绿通装饰设计有限公司' [ RunTime:0.000160s ]