上海金鑫装饰口碑怎么样-上海金鑫装饰靠谱吗-设计案例-电话地址-齐装网

服务区域：: 黄浦区,徐汇区,长宁区,静安区,普陀区,闸北区,虹口区,杨浦区,闵行区,宝山区,嘉定区,浦东新区,金山区,松江区

服务专长：: 其它,医院/学校装修,KTV/网吧/会所装修,酒店/饭店装修,店面/商铺/厂房装修,办公室/写字楼装修,所有家装,所有公装

承接价位：: 0万元以上

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

上海装饰行业一线品牌"显尚装饰工程设计"成立于1994年，拥有设计乙级,施工二级资质，是一家集空间艺术设计,装潢,家居集成为一体的设计装饰企业，致力于服务成功人士的居家设计装修;凭借一批高水准的专业设计团队和具有多年实战经验的施工技师，以良好的服务，独特的经营理念，在上海的装饰装修行业中取得了很...

查看详情

设计报价在线咨询

设计报价客服

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

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

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

请输入您的问题或截图

发送

客服在线

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

计算报价

二维码

齐装网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 offset: 0 /www/sites/www.qizuang.com/index/qzwww/Application/Sub/Controller/CompanyhomeController.class.php 第 174 行.
[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: haopinglve /www/sites/www.qizuang.com/index/qzwww/Application/Runtime/Cache/Sub/6df608fd93df964a28002a69e29fa366.php 第 409 行.
[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 = '8294' 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 = '8294' 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.0221s ]
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` = '8294' 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` = '8294' AND `day` BETWEEN '2025-01-04' AND '2025-02-04' 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 = '8294' 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.0014s ]
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 = 8294 WHERE ce.company_id = 8294 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 =8294 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.0015s ]
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` = '8294' 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.0026s ]
SHOW COLUMNS FROM `qz_user_company_rank` [ RunTime:0.0018s ]
SELECT t.* FROM ( SELECT * FROM qz_user_company_rank WHERE `comid` IN ('8294') AND `day` BETWEEN '2025-01-30' AND '2025-02-04' 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.0013s ]
SELECT COUNT(*) AS tp_count FROM qz_cases WHERE `uid` = '8294' AND `isdelete` = 1 AND `on` = 1 LIMIT 1 [ RunTime:0.0013s ]
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 = '8294' GROUP BY t.id [ RunTime:0.0014s ]
SELECT COUNT(*) AS tp_count FROM qz_comment a WHERE a.comid = '8294' AND a.cs = 310100 AND a.isveritfy = 0 LIMIT 1 [ RunTime:0.0011s ]
SELECT t1.*,c.rptxt FROM ( SELECT t.*,b.nickname as bname,b.avatar as logo FROM ( SELECT * FROM qz_comment a WHERE a.comid = '8294' 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.0015s ]
SHOW COLUMNS FROM `qz_comment_img` [ RunTime:0.0016s ]
SELECT `imgurl` FROM qz_comment_img WHERE `commentid` = '1954' [ RunTime:0.0010s ]
SHOW COLUMNS FROM `qz_comment_img` [ RunTime:0.0016s ]
SELECT `imgurl` FROM qz_comment_img WHERE `commentid` = '2004' [ RunTime:0.0010s ]
SHOW COLUMNS FROM `qz_comment_img` [ RunTime:0.0015s ]
SELECT `imgurl` FROM qz_comment_img WHERE `commentid` = '2182' [ RunTime:0.0009s ]
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 = '8294' ORDER BY a.post_time DESC LIMIT 0,3 [ RunTime:0.0011s ]
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-02-03' WHERE uc1.comid = '8294' 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 = '8294' LIMIT 1 [ RunTime:0.0010s ]
SELECT COUNT(*) AS tp_count FROM qz_company_activity c WHERE `cid` = 8294 AND `check` = '1' AND `del` = '1' AND `types` = '1' AND `start` < 1738662395 AND `end` > 1738662395 LIMIT 1 [ RunTime:0.0010s ]
SELECT `id`,`cid`,`title`,`text`,`start`,`end`,`time`,`check`,`types`,`del`,`state` FROM qz_company_activity c WHERE `cid` = 8294 AND `check` = '1' AND `del` = '1' AND `types` = '1' AND `start` < 1738662395 AND `end` > 1738662395 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 = '8294' 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` = 8294 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.0092s ]
SELECT (haoping/ping) as haoping_lv,`comid` FROM qz_user_company_rank WHERE `comid` IN ('737174','835178','835903','840047','842711','852402') AND `day` = '2025-02-03' [ RunTime:0.0011s ]
SHOW COLUMNS FROM `qz_company_banners` [ RunTime:0.0016s ]
SELECT `id`,`userid`,`img_path` FROM qz_company_banners WHERE `userid` = '8294' AND `status` = 1 ORDER BY sorted,id DESC LIMIT 5 [ RunTime:0.0022s ]
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.0039s ]
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 = 8294 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.0019s ]
UPDATE qz_user SET `pv`=pv+1 WHERE `id` = 8294 [ RunTime:0.0071s ]
SHOW COLUMNS FROM `qz_card_com_record` [ RunTime:0.0017s ]
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 = '8294' AND r.check = 2 AND r.activity_start < 1738662395 AND r.activity_end > 1738662395 AND r.apply_state = 1 AND ( (c.enable =1 or (c.enable = 2 and c.disable_time >1738662395)) ) LIMIT 4 ) k left join qz_card_user u ON u.record_id = k.id GROUP BY k.id [ RunTime:0.0014s ]
SHOW COLUMNS FROM `qz_sub_tag_company` [ RunTime:0.0016s ]
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 = '8294' AND b.enabled = 1 ORDER BY a.created_at desc LIMIT 10 [ RunTime:0.0012s ]
SHOW COLUMNS FROM `qz_sub_tag` [ RunTime:0.0015s ]
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 ('2566','2565','2564','1947','1948','1949','2093','570','571','572') [ RunTime:0.0019s ]

上海金鑫装饰

上海金鑫装饰装修案例

上海金鑫装饰公司荣誉

上海金鑫装饰口碑