上海

[切换]

首页
装修公司
装修效果图
装修攻略
设计与报价
更多

上海装修 > 上海装修公司 > 红蚂蚁

红蚂蚁

13套: 案例数

2家: 在建工地

上海杨浦区上海市杨浦区黄兴路1661号-1675号(大润发对面)

查看联系方式

免费预约

红蚂蚁装修案例

多类型实景装修效果，设计与工艺的结合！查看更多

金元大厦 50-100万
400㎡办公室/写现代简约
剑桥别墅 30-50万
220㎡别墅欧式风格
新梅莘苑 7-10万
120㎡普通户型中式风格
花好月圆 15-20万
130㎡普通户型欧式风格
荣盛名邸 7-10万
106㎡普通户型现代简约
畹町路99弄 4万以下
90㎡普通户型现代简约

红蚂蚁公司荣誉

公司的荣誉与传承，值得你信赖！

最新申请设计服务

我要申请

业主
小区
面积
类型
预算

未先生世纪佳园 130.5平米普通户型 4-7万
未先生世纪佳园 100150平米普通户型 4-7万
未先生世纪佳园 113平米普通户型 4-7万
未先生世纪佳园 100平米普通户型 4-7万
未先生世纪佳园 350平米普通户型 4-7万

红蚂蚁口碑

看看装修过的业主怎么说？让您对装修公司多一分了解！

晚饭呵呵

晚饭呵呵

东原逸墅水电阶段

2019-05-28 17:20:02

线路管路布局走位都非常满意，服务态度非常好

服务区域：: 黄浦区,徐汇区,长宁区,静安区,普陀区,闸北区,虹口区,杨浦区,闵行区

服务专长：: 店面/商铺/厂房装修,办公室/写字楼装修,所有家装

承接价位：: 6万元以上

专长风格：: 现代简约,欧式风格,中式风格,古典风格,田园风格,地中海风格,美式风格,混搭风格,其他

上海红蚂蚁装潢设计有限公司成立于2003年,是经上海市工商局注册具有独立法人资格的实体单位，一家集设计,施工为一体的专业*装饰企业.公司主要承接商业空间,居家空间的设计和施工.公司经营装饰设计,施工行业多年，积累了丰富的装饰经验，汇集了大批装饰行业精英;公司多年本着"连接"为原则，把我们的专业知识与...

查看详情

免费申领4套设计方案 优质方案大PK，装修立省30%

我已阅读并同意齐装网的《免责声明》和《通讯授权服务》

本月推荐装修公司

8秒估算装修报价

123456 元

m²

我已阅读并同意齐装网的《免责声明》和《通讯授权服务》

立即计算

您的装修预算为

元

客厅元

卧室元

厨房元

卫生间元

水电元

其它元

*因材料品牌及工程量不同,具体的价格由实际工程为准;稍后齐装网客服会给您提供更多的报价详情

去APP写评价

×

扫码看新家
随时随地看装修进度

最新入驻的装修公司服务项目

上海装饰觉雅装饰上海百分装饰上海尚层装饰安科瑞电气一装欧湃家居好美家维舟装饰涟云局改上海紫苹果匠妙邦宁装饰设计钦乔装饰优创智家装饰匠大师装饰尚品源装饰鑫之奕装饰美好家整装羽世装饰

上海别墅装修上海新房装修上海店面装修上海写字楼装修上海办公室装修上海旧房改造上海婚房装修上海厂房装修上海豪宅装修上海商场装修

齐装网简介

企业文化

诚聘英才

业主口碑

法律声明

战略合作

客服中心

城市导航

商家入驻

免责声明：任何单位或个人认为本网站转载信息涉及版权或有侵权嫌疑等问题的，敬请立即通知，齐装网将在第一时间予以更改或删除

版权所有Copyright ©2025 www.qizuang.com All Rights Reserved 有房要装，就上齐装！法律顾问：江苏新苏律师事务所张茜茜律师

苏州云网通信息科技有限公司苏ICP备12045334号-1 增值电信业务经营许可证：苏B2-20160417

齐装网APP

微信公众号

齐装网APP

微信公众号

×

设计报价在线咨询

设计报价客服

专业设计报价团队，历时三年的数据分析，根据上百万条案例数据分析，为您打造最适宜的设计报价方案

您好，您已进入设计报价专线，请问有什么可以帮助您？

你好，我想知道报价怎么操作？

请输入您的问题或截图

发送

客服在线

设计报价
装修服务
家居建材
工程质检
商务合作
投诉反馈

计算报价

二维码

齐装网APP

微信公众号

回到顶部

基本文件流程错误 SQL 调试服务器控制器模板

/www/sites/www.qizuang.com/index/qzwww/web/index.php ( 1.52 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/autoload.php ( 0.17 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/composer/autoload_real.php ( 2.57 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/composer/platform_check.php ( 0.90 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/composer/ClassLoader.php ( 15.69 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/composer/autoload_static.php ( 4.41 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/symfony/polyfill-intl-normalizer/bootstrap.php ( 0.62 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/symfony/polyfill-php70/bootstrap.php ( 0.85 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/symfony/polyfill-php72/Php72.php ( 6.52 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.50 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/guzzlehttp/psr7/src/functions.php ( 13.09 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/sites/www.qizuang.com/index/qzwww/vendor/qizuang/infra/src/functions.php ( 4.59 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/ThinkPHP.php ( 4.61 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Think.class.php ( 12.01 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Storage.class.php ( 1.34 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Storage/Driver/File.class.php ( 3.44 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Runtime/common~runtime.php ( 101.56 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Sub/Conf/config.php ( 11.74 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Behavior/ReadHtmlCacheBehavior.class.php ( 5.51 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Sub/Controller/CompanyhomeController.class.php ( 80.69 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Sub/Common/Controller/SubBaseController.class.php ( 0.27 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Controller/BaseController.class.php ( 11.85 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Behavior/FilterErrorUrlBehavior.class.php ( 0.45 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Behavior.class.php ( 0.86 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Home/Behavior/BrowserScanCheckBehavior.class.php ( 1.19 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Library/Org/Util/App.class.php ( 13.32 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Behavior/MarkTrackingOrderSourceCheckBehavior.class.php ( 11.67 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Cache.class.php ( 3.72 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Cache/Driver/Redis.class.php ( 3.73 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/OptionsModel.class.php ( 4.24 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/BizMarketingModel.class.php ( 0.41 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Model.class.php ( 65.83 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Db.class.php ( 5.56 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Db/Driver/Mysql.class.php ( 9.09 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Db/Driver.class.php ( 40.95 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Think/Cache/Driver/File.class.php ( 5.73 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Library/Org/Tool/Mobile_Detect.php ( 80.07 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Logic/BizMarketing/CompanyLogicModel.class.php ( 21.12 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/CompanyModel.class.php ( 66.11 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/UserModel.class.php ( 39.82 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Enums/BaseDecoConfigEnum.class.php ( 0.44 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Library/Org/Util/Fiftercontact.class.php ( 28.25 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/OrdersModel.class.php ( 12.37 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/OrderInfoModel.class.php ( 0.18 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/UserCompanyEmployeeModel.class.php ( 7.86 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/CasesModel.class.php ( 69.72 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/CommentModel.class.php ( 22.31 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Library/Org/Page/LitePage.class.php ( 45.42 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/AskModel.class.php ( 29.96 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/AskAnwserModel.class.php ( 0.19 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/CompanyActivityModel.class.php ( 4.36 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/CompanyTagsModel.class.php ( 1.40 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/CompanyImgModel.class.php ( 0.42 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/UserCompanyRankModel.class.php ( 1.77 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Logic/BizMarketing/ZxsRoomcasesLogicModel.class.php ( 19.14 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/ZxsRoomcasesModel.class.php ( 3.64 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/ZxsRoomCasesTagModel.class.php ( 1.12 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/ZxsRoomCasesImgModel.class.php ( 1.27 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Logic/BizMarketing/CardLogicModel.class.php ( 4.29 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/CardModel.class.php ( 6.25 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Logic/BizMarketing/SubthematicLogicModel.class.php ( 5.07 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/SubthematicModel.class.php ( 6.19 KB )
/www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php ( 150.94 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Behavior/WriteHtmlCacheBehavior.class.php ( 1.40 KB )
/www/sites/www.qizuang.com/index/qzwww/Core2015/Library/Behavior/ShowPageTraceBehavior.class.php ( 7.43 KB )

[8] Undefined index: LOCAL_ADDR /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/common~runtime.php 第 1 行.
[8] Undefined index: LOCAL_PORT /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/common~runtime.php 第 1 行.
[8] Undefined index: HTTP_REFERER /www/sites/www.qizuang.com/index/qzwww/Application/Common/Behavior/MarkTrackingOrderSourceCheckBehavior.class.php 第 44 行.
[8] Undefined index: HTTP_REFERER /www/sites/www.qizuang.com/index/qzwww/Application/Common/Behavior/MarkTrackingOrderSourceCheckBehavior.class.php 第 208 行.
[8] Undefined index: center_password_token /www/sites/www.qizuang.com/index/qzwww/Application/Common/Controller/BaseController.class.php 第 234 行.
[8] Undefined index: avgcuont /www/sites/www.qizuang.com/index/qzwww/Application/Sub/Controller/CompanyhomeController.class.php 第 1613 行.
[8] Undefined variable: query_string /www/sites/www.qizuang.com/index/qzwww/Application/Library/Org/Page/LitePage.class.php 第 77 行.
[8] Undefined variable: query_string /www/sites/www.qizuang.com/index/qzwww/Application/Library/Org/Page/LitePage.class.php 第 77 行.
[8] Undefined index: non_id /www/sites/www.qizuang.com/index/qzwww/Application/Common/Model/Db/BizMarketing/ZxsRoomcasesModel.class.php 第 48 行.
[8] Undefined variable: topbanner /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 47 行.
[8] Undefined variable: ifIndex /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 137 行.
[8] Undefined index: hotTags /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: hotCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: link /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: zhuanti /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: provinceCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: recentCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: tags /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: areaCompany /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: newestMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: hottestMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: sameTagList /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 971 行.
[8] Undefined index: recommendCompany /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 974 行.
[8] Undefined index: tags /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 975 行.
[8] Undefined index: link /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 976 行.
[8] Undefined index: zhuanti /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 977 行.
[8] Undefined index: hotCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 978 行.
[8] Undefined index: hotTags /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 979 行.
[8] Undefined index: recentCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 980 行.
[8] Undefined index: areaCompany /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 981 行.
[8] Undefined index: provinceCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 982 行.
[8] Undefined index: hotMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 983 行.
[8] Undefined index: newestMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 984 行.
[8] Undefined index: hottestMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 985 行.
[8] Undefined index: sameTagList /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 986 行.
[8] Undefined index: recommendCompany /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 992 行.
[8] Undefined index: tags /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 998 行.
[8] Undefined index: link /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1001 行.
[8] Undefined index: zhuanti /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1004 行.
[8] Undefined index: hotCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1007 行.
[8] Undefined index: hotTags /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1010 行.
[8] Undefined index: recentCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1013 行.
[8] Undefined index: areaCompany /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1016 行.
[8] Undefined index: provinceCity /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1019 行.
[8] Undefined index: hotMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1023 行.
[8] Undefined index: newestMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1026 行.
[8] Undefined index: hottestMeitu /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1029 行.
[8] Undefined index: sameTagList /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1032 行.
[8] Undefined variable: ssid /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1206 行.
[8] Undefined variable: var /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 1342 行.

SELECT user.id,user.user,user.logo,user.jc,user.qc,user.case_count,company.comment_score,company.is_show,q.bm,company.text as jianjie,a.qz_area FROM qz_user user INNER JOIN qz_user_company as company on company.userid = user.id left join qz_quyu q ON q.cid = user.cs left join qz_area a ON a.qz_areaid = user.qx WHERE user.id = '422668' LIMIT 1 [ RunTime:0.0011s ]
SELECT t2.*,count(g.id) as ccount,count(IF(g.sj <>0,g.id,null)) as newcount,count(IF(g.sj =0,g.id,null)) as oldcount,count(IF(g.count>=9 and g.sj = 0,g.count,null)) as oldgood,count(IF(g.sj>=9 and g.fw>=9 and g.sg >=9,g.id,null)) as good,avg(IF(g.sj<>0,g.sj,null)) avgsj,avg(IF(g.fw<>0,g.fw,null)) avgfw,avg(IF(g.sg<>0,g.sg,null)) avgsg,avg(IF(g.sj=0,g.count,null)) avgcount FROM ( SELECT tt.*,count(ce.id) as dcount2,case when count(ce.id) > 0 or tt.cooperate_mode2 = 2 then 2 else 1 end as cooperate_mode FROM ( SELECT t.id,t.classid,t.on,t.chengli,t.cs,t.qx,t.cityname,t.area_name,t.qc,t.jc,t.kouhao,t.img_host,t.logo,t.video,t.pv,t.jianjie,t.jiawei,t.fake,t.nickname,t.nickname1,t.hengfu,t.qq,t.qq1,t.cal,t.cals,t.dz,t.tel,t.casecount,GROUP_CONCAT(DISTINCT c.qz_area ORDER BY c.qz_areaid) as area,GROUP_CONCAT(DISTINCT d.name order by d.sort DESC) as fw,GROUP_CONCAT(DISTINCT e.name order by e.sort ) as fg,f.name as gm,t.cooperate_mode2 FROM ( SELECT a.id,a.classid,a.on,a.cs,a.qx,e.cname as cityname,z.qz_area as area_name,a.qc,a.jc,a.kouhao,a.logo,a.pv,a.video,a.qq,a.qq1,a.cal,a.cals,a.dz,a.tel,a.case_count as casecount,b.text as jianjie,b.jiawei,b.fuwu,b.fengge,b.quyu,b.fake,b.nickname,b.nickname1,b.hengfu,b.guimo,b.chengli,b.img_host,b.cooperate_mode as cooperate_mode2 FROM qz_user a left join qz_user_company as b on a.id = b.userid inner join qz_quyu as e on e.cid = a.cs left join qz_area as z on a.qx = z.qz_areaid WHERE a.id = '422668' AND a.classid IN (3,6) AND a.cs = '310100' ) t LEFT JOIN qz_area as c on FIND_IN_SET(c.qz_areaid,t.quyu) LEFT JOIN qz_base_deco_config as d on FIND_IN_SET(d.biz_id,t.fuwu) and d.type = 'leixing' LEFT JOIN qz_base_deco_config as e on FIND_IN_SET(e.biz_id,t.fengge) and e.type = 'fengge' LEFT JOIN qz_base_deco_config as f on f.biz_id = t.guimo and f.type = 'guimo' GROUP BY t.id ) tt LEFT JOIN qz_user_company_employee ce on ce.company_id = tt.id and ce.state = 1 and ce.position in (2,3,4) ) t2 LEFT JOIN qz_comment as g on g.comid = t2.id and g.isveritfy = 0 [ RunTime:0.0166s ]
SHOW COLUMNS FROM `qz_company_branchstore` [ RunTime:0.0016s ]
SELECT id as hid,`shortname`,tel as htel,`addr`,qq as qq3,qq1 as qq4,nickname as nickname2,nickname1 as nickname3 FROM qz_company_branchstore WHERE `comid` = '422668' LIMIT 1 [ RunTime:0.0022s ]
SHOW COLUMNS FROM `qz_user_company_rank` [ RunTime:0.0015s ]
SELECT `ping`,`haoping` FROM qz_user_company_rank WHERE `comid` = '422668' AND `day` BETWEEN '2024-12-27' AND '2025-01-27' ORDER BY day desc LIMIT 1 [ RunTime:0.0010s ]
SELECT t1.*,c.name as huxing,d.name as yusuan FROM ( SELECT a.addtime,b.`name`,b.mianji,b.lx,b.huxing,b.yusuan,b.xiaoqu FROM qz_order_info a INNER JOIN qz_orders as b on a.`order` = b.id WHERE a.com = '422668' ORDER BY a.addtime desc LIMIT 5 ) t1 LEFT JOIN qz_base_deco_config as c on c.biz_id = t1.huxing and c.type = 'huxing' LEFT JOIN qz_base_deco_config as d on d.biz_id = t1.yusuan and d.type = 'jiage' ORDER BY addtime desc [ RunTime:0.0024s ]
SELECT count(b.id) as casecount,t.* FROM ( SELECT ce.id,ce.account as user,ce.nick_name as name,ce.logo,ce.description,ce.position as zw,ce.experience,ce.honor,ce.state,ce.created_at,ds.sort px,if(ds.id is null,2,1) as hassort FROM qz_user_company_employee ce INNER JOIN qz_user_des as d on d.userid = ce.id and d.company_id = ce.company_id LEFT JOIN qz_user_company_designer_sorting ds on ds.employee_id = ce.id and ds.company_id = 422668 WHERE ce.company_id = 422668 AND ce.position IN (2,3,4) AND ce.state = 1 ORDER BY hassort,ds.sort,ce.id desc LIMIT 5 ) t LEFT JOIN qz_cases as b on t.id = b.userid and b.uid =422668 and b.isdelete = 1 and b.on = 1 and b.status=2 and b.classid <= 3 GROUP BY t.id ORDER BY t.hassort,t.px,t.id desc [ RunTime:0.0013s ]
SELECT * FROM ( SELECT t1.id as id,t1.name as huxing,t1.lx as leixing,t1.on,t1.mianji,t1.title,t1.fg,t1.time,d.img,d.img_host,d.img_path,t1.dname,t1.logo,t1.userid,t1.isdelete,t1.classid,t1.thumb,t1.zaojia,t1.jiage FROM ( SELECT t.*,c.name as fg,d.name as dname,d.logo,h.name,f.name as lx,j.name as jiage FROM ( SELECT `id`,`title`,`mianji`,`fengge`,`zaojia`,`time`,`userid`,`huxing`,`leixing`,`isdelete`,`on`,`status`,`classid`,`thumb` FROM qz_cases WHERE `uid` = '422668' AND `isdelete` = 1 AND `on` = 1 AND `status` = 2 AND `classid` <= 3 ORDER BY time desc LIMIT 6 ) t INNER JOIN qz_base_deco_config as c on c.biz_id = t.fengge and c.type = 'fengge' LEFT JOIN qz_user as d on d.id = t.userid LEFT JOIN qz_base_deco_config as h on h.biz_id = t.huxing and h.type = 'huxing' LEFT JOIN qz_base_deco_config as f on f.biz_id = t.leixing and f.type = 'leixing' LEFT JOIN qz_base_deco_config as j on t.zaojia=j.biz_id and j.type= 'jiage' ) t1 LEFT JOIN qz_case_img as d on d.caseid = t1.id AND d.status < 3 ORDER BY d.img_on desc,d.px asc ) t2 GROUP BY t2.id ORDER BY time desc [ RunTime:0.0018s ]
SHOW COLUMNS FROM `qz_user_company_rank` [ RunTime:0.0015s ]
SELECT t.* FROM ( SELECT * FROM qz_user_company_rank WHERE `comid` IN ('422668') AND `day` BETWEEN '2025-01-22' AND '2025-01-27' ORDER BY day desc ) t join qz_user_company b on b.userid = t.comid and b.is_show = 1 GROUP BY t.comid [ RunTime:0.0012s ]
SELECT COUNT(*) AS tp_count FROM qz_cases WHERE `uid` = '422668' AND `isdelete` = 1 AND `on` = 1 LIMIT 1 [ RunTime:0.0010s ]
SELECT count(c.id) as zj_num FROM qz_user t LEFT JOIN qz_cases as c on c.uid=t.id and c.isdelete in(1,3) and c.on=1 and c.classid=3 WHERE c.uid = '422668' GROUP BY t.id [ RunTime:0.0011s ]
SELECT COUNT(*) AS tp_count FROM qz_comment a WHERE a.comid = '422668' AND a.cs = 310100 AND a.isveritfy = 0 LIMIT 1 [ RunTime:0.0009s ]
SELECT t1.*,c.rptxt FROM ( SELECT t.*,b.nickname as bname,b.avatar as logo FROM ( SELECT * FROM qz_comment a WHERE a.comid = '422668' AND a.cs = 310100 AND a.isveritfy = 0 ORDER BY time desc ) t LEFT JOIN qz_ucenter_profile as b on t.userid = b.uuid LIMIT 0,3 ) t1 LEFT JOIN qz_reply as c on c.commid = t1.id [ RunTime:0.0012s ]
SHOW COLUMNS FROM `qz_comment_img` [ RunTime:0.0015s ]
SELECT `imgurl` FROM qz_comment_img WHERE `commentid` = '231721' [ RunTime:0.0009s ]
SELECT `id`,`name`,`logo` FROM qz_user WHERE `id` IN ('123765') [ RunTime:0.0021s ]
SELECT b.id,b.title,a.post_time,a.content FROM qz_ask_anwser a left join qz_ask as b on b.id = a.qid WHERE a.uid = '422668' ORDER BY a.post_time DESC LIMIT 0,3 [ RunTime:0.0010s ]
SELECT t2.* FROM ( SELECT t.id,uc1.haoping,uc1.casesnum,uc1.designnum,uc1.ping FROM qz_user t left join qz_user_company_rank uc1 on uc1.comid = t.id and uc1.day = '2025-01-26' WHERE uc1.comid = '422668' ORDER BY day desc ) t2 GROUP BY t2.id [ RunTime:0.0010s ]
SELECT `comment_score`,`comment_count` FROM qz_user t left join qz_user_company uc on uc.userid = t.id WHERE uc.userid = '422668' LIMIT 1 [ RunTime:0.0010s ]
SELECT COUNT(*) AS tp_count FROM qz_company_activity c WHERE `cid` = 422668 AND `check` = '1' AND `del` = '1' AND `types` = '1' AND `start` < 1737981729 AND `end` > 1737981729 LIMIT 1 [ RunTime:0.0010s ]
SELECT `id`,`cid`,`title`,`text`,`start`,`end`,`time`,`check`,`types`,`del`,`state` FROM qz_company_activity c WHERE `cid` = 422668 AND `check` = '1' AND `del` = '1' AND `types` = '1' AND `start` < 1737981729 AND `end` > 1737981729 ORDER BY types desc,time desc LIMIT 0,5 [ RunTime:0.0010s ]
SELECT a.tag as tag_id,t.tag as tag_name FROM qz_company_tags a LEFT JOIN qz_company_relation_tag t on t.id = a.tag WHERE a.company_id = '422668' ORDER BY t.tag_mode DESC,t.id DESC [ RunTime:0.0010s ]
SELECT `id`,img as img_path,`img_host` FROM qz_company_img WHERE `userid` = 422668 ORDER BY id desc [ RunTime:0.0010s ]
SELECT u.id,u.logo,u.qc,u.jc,q.bm,CASE WHEN u.`on` = 2 AND uc.fake = 0 THEN 1 WHEN u.`on` <> 2 AND uc.fake = 0 THEN 2 ELSE 3 END paixu FROM qz_user u inner join qz_user_company as uc on u.id=uc.userid inner join qz_quyu as q on q.cid=u.cs WHERE u.cs = '310100' AND uc.is_show = 1 AND u.classid IN (3,6) AND u.qc <> '' ORDER BY paixu, u.register_time LIMIT 6 [ RunTime:0.0072s ]
SELECT (haoping/ping) as haoping_lv,`comid` FROM qz_user_company_rank WHERE `comid` IN ('737174','835178','835903','840047','842711','852402') AND `day` = '2025-01-26' [ RunTime:0.0010s ]
SHOW COLUMNS FROM `qz_company_banners` [ RunTime:0.0014s ]
SELECT `id`,`userid`,`img_path` FROM qz_company_banners WHERE `userid` = '422668' AND `status` = 1 ORDER BY sorted,id DESC LIMIT 5 [ RunTime:0.0016s ]
SELECT user.jc,user.qc,user.id FROM qz_user user INNER JOIN qz_user_company as company on company.userid = user.id WHERE user.cs = '310100' AND user.classid = 3 AND user.account_chk = 1 AND company.is_show = 1 ORDER BY user.register_time DESC LIMIT 20 [ RunTime:0.0027s ]
SELECT a.id,a.title,a.case_from,a.tag_id,a.views,a.fake_views,a.collects,a.fake_collects,a.room_mianji,count(zpi.id) as img_num,zp.id as pic_id,zpi.url as img_url,zpi.width as img_width,zpi.height as img_height,a.owner_name,a.owner_logo,a.tag_id FROM ( SELECT a.id,a.title,a.case_from,a.views,a.fake_views,a.collects,a.fake_collects,a.room_mianji,group_concat(t.tag_id) as tag_id,a.publish_time,up.nickname as owner_name,up.avatar as owner_logo FROM qz_zxs_room_cases a inner join qz_zxs_room_cases_tag t on a.id = t.room_case_id left join qz_ucenter_profile up on up.uuid = a.owner_uuid WHERE a.publish = 1 AND a.is_delete = 2 AND a.company_id = 422668 GROUP BY a.id ORDER BY a.publish_time desc,a.id desc ) a inner join qz_zxs_picture zp on zp.room_case_id = a.id and zp.is_delete=2 inner join qz_zxs_picture_info zpi on zpi.pic_id = zp.id GROUP BY a.id ORDER BY a.publish_time desc,a.id desc,zpi.px asc,zpi.id LIMIT 0,3 [ RunTime:0.0014s ]
UPDATE qz_user SET `pv`=pv+1 WHERE `id` = 422668 [ RunTime:0.0063s ]
SHOW COLUMNS FROM `qz_card_com_record` [ RunTime:0.0016s ]
SELECT k.*,count(u.id) as usenum FROM ( SELECT c.name,r.start,r.end,c.type,c.active_type,c.money1,c.money2,c.money3,c.gift,c.img2,c.module,r.id,r.amount FROM qz_card_com_record r INNER JOIN qz_card_com com on com.id = r.card_com_id INNER JOIN qz_card c on c.id = com.card_id WHERE com.com_id = '422668' AND r.check = 2 AND r.activity_start < 1737981729 AND r.activity_end > 1737981729 AND r.apply_state = 1 AND ( (c.enable =1 or (c.enable = 2 and c.disable_time >1737981729)) ) LIMIT 4 ) k left join qz_card_user u ON u.record_id = k.id GROUP BY k.id [ RunTime:0.0012s ]
SHOW COLUMNS FROM `qz_sub_tag_company` [ RunTime:0.0014s ]
SELECT `tag_id` FROM qz_sub_tag_company a INNER JOIN qz_sub_tag as b on b.id = a.tag_id WHERE a.company_id = '422668' AND b.enabled = 1 ORDER BY a.created_at desc LIMIT 10 [ RunTime:0.0011s ]
SHOW COLUMNS FROM `qz_sub_tag` [ RunTime:0.0014s ]
SELECT b.url,a.name as tag_name FROM qz_sub_tag a left join qz_subthematic as b on a.id = b.sub_tagid and b.cs=310100 WHERE a.id IN ('2565','2564','1947','1948','570','572','571','573','569','568') [ RunTime:0.0014s ]

0.1278s

4246bee615e5