齊裝網(wǎng) > 裝修攻略 > 精選問答 > 燈關了還一閃一閃怎么解決

裝修計算器 8秒免費獲取報價

我已閱讀并同意齊裝網(wǎng)的《免責聲明》和《通訊授權服務》

您的裝修預算為：元

臥室：元

客廳：元

衛(wèi)生間：元

廚房：元

水電：元

其他：元

燈關了還一閃一閃怎么解決

2021-02-04 08:49:26

來源：齊裝網(wǎng)

537

5461

　　燈關了還一閃一閃這丫不能夠會顯著非常的詭異，相信很多的人都會有這樣的一個疑問吧，而且也是想要及時解決的，畢竟這樣也會讓我們很不舒適，接下來小編就帶著大家來了解下，燈關了還一閃一閃怎么解決?

燈關了還一閃一閃怎么解決

　　1、或許是因為零線跟火線接反，因為零線是接通電燈接線盒，而火線是接通開關接線盒的，這樣才可以讓開關更好地控制電燈，這個時候需要更改零火線的方向，因為零火線反接，不僅會造成電燈閃爍，如果對著方面不是很懂一定要在燈具維修時對維修人員造成傷害。

　　2、感應電流也是其中的一個原因，當出現(xiàn)這樣情況的時候，主要發(fā)生在電線比較密集的地方，因為電線之間隔得比較近，特別是在使用大功率電器的時候，就會產(chǎn)生一定的感應電流，這個時候可以在電燈位置串聯(lián)一個接觸器線圈，這樣自然就可以消除線路中的微弱電流。

　　3、開關上有指示，目前有很多的開關，在上面都是帶有一個指示燈的，可是這樣的開關并不是很好，因為就算是將燈關掉之后，那么指示燈依然是亮著的，這樣就表示開關依然是接通狀態(tài)，在這個時候我們只要把開關內(nèi)的指示燈拆下或更換開關即可。

　　4、與電源接觸不良，這樣的狀況是由于線路老化所導致的，在這個時候我們有一定要及時更換新的電路即可。

想要獲取專業(yè)設計師免費量房設計？

點擊獲取

聲明：所有來源為“齊裝網(wǎng)”的內(nèi)容信息，未經(jīng)本網(wǎng)許可，不得轉(zhuǎn)載！本網(wǎng)轉(zhuǎn)載的其他文字、圖片、音視頻等信息，內(nèi)容均來源于網(wǎng) 絡，并不代表本網(wǎng)觀點，其版權歸原作者所有，如果您發(fā)現(xiàn)本網(wǎng)轉(zhuǎn)載信息侵害了您的權益，請與我們聯(lián)系，我們將及時核實處理。

相關標簽：

相關攻略

墻布甲醛含量高嗎

墻布甲醛含量高嗎？墻布的甲醛含量主要看你買的產(chǎn)品質(zhì)量，一些質(zhì)量較差的墻布不僅含有甲醛更有甚者甲醛超標，不止是墻布還有墻紙，在安裝的過程中都會用到膠水，膠水的質(zhì)量也會影響室內(nèi)的甲醛含量高低，所以墻布到底

了解詳情 >

5尺床是1.5還是1.8

5尺床是1.5還是1.8？經(jīng)常有人提起“床不離七”的說法，那么老一輩常說的5尺床是什么意思呢？5尺床是怎么來的？5尺床的尺寸大概是多少呢？接下來我們了解一下5尺床。一、5尺床是1.5還是1.85尺床是

了解詳情 >

暖氣片的溫度一般是多少度

暖氣片的溫度一般是多少度？根據(jù)國家規(guī)定室內(nèi)暖氣片一般溫度在18~23攝氏度之間，但是不能低于18攝氏度，人體對溫度的感應有所差異，所以令人舒適的暖氣片溫度是因人而異的。接下來為大家介紹一些暖氣片溫度的

了解詳情 >

正規(guī)臺球桌的尺寸是多少的

正規(guī)臺球桌的尺寸是多少的？臺球又叫桌球、彈子球，是當下比較流行的球類運動項目之一，作為2030年多哈亞運會的項目之一，臺球運動已經(jīng)深入人心，那么買臺球桌需要注意什么？臺球桌尺寸標準是什么？我們一起來看

了解詳情 >

裝修手冊

裝修準備
裝修報價
公司選擇
設計方案
材料選購
裝修施工
裝修驗收
入住階段

新文章

心系定日，羅萊生...

[詳細]

“設計上海2025”正式啟動，人...

“設計上海202...

[詳細]

設計論道｜第三屆家居產(chǎn)業(yè)時尚發(fā)展...

設計論道｜第三屆...

[詳細]

萬耀企龍與漢諾威米蘭成立合資公司...

萬耀企龍與漢諾威...

今日(2025年1月8日)，上海萬... [詳細]

2025新篇入座，杜鵑代言CAL...

2025新篇入座...

2025年開年，慕思集團旗下品牌C... [詳細]

冰雪經(jīng)濟遇上生活美學直播派對，林...

冰雪經(jīng)濟遇上生活...

[詳細]

深度好眠的秘密！康姿百德豪華款磁...

深度好眠的秘密！...

[詳細]

看懂皇派門窗如何布局「創(chuàng)造需求」...

看懂皇派門窗如何...

[詳細]

我已閱讀并同意齊裝網(wǎng)的《免責聲明》和《通訊授權服務》

設計報價在線咨詢

設計報價客服

專業(yè)設計報價團隊，歷時三年的數(shù)據(jù)分析，根據(jù)上百萬條案例數(shù)據(jù)分析，為您打造最適宜的設計報價方案

您好，您已進入設計報價專線，請問有什么可以幫助您？

你好，我想知道報價怎么操作？

請輸入您的問題或截圖

發(fā)送

客服在線

設計報價
裝修服務
家居建材
工程質(zhì)檢
商務合作
投訴反饋

計算報價

二維碼

齊裝網(wǎng)APP

微信公眾號

回到頂部

基本文件流程錯誤 SQL 調(diào)試服務器控制器模板

/www/sites/relief33.cn/index/qzwww/web/index.php ( 1.52 KB )
/www/sites/relief33.cn/index/qzwww/vendor/autoload.php ( 0.17 KB )
/www/sites/relief33.cn/index/qzwww/vendor/composer/autoload_real.php ( 2.57 KB )
/www/sites/relief33.cn/index/qzwww/vendor/composer/platform_check.php ( 0.90 KB )
/www/sites/relief33.cn/index/qzwww/vendor/composer/ClassLoader.php ( 15.69 KB )
/www/sites/relief33.cn/index/qzwww/vendor/composer/autoload_static.php ( 4.41 KB )
/www/sites/relief33.cn/index/qzwww/vendor/symfony/polyfill-intl-normalizer/bootstrap.php ( 0.62 KB )
/www/sites/relief33.cn/index/qzwww/vendor/symfony/polyfill-php70/bootstrap.php ( 0.85 KB )
/www/sites/relief33.cn/index/qzwww/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/sites/relief33.cn/index/qzwww/vendor/symfony/polyfill-php72/Php72.php ( 6.52 KB )
/www/sites/relief33.cn/index/qzwww/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/sites/relief33.cn/index/qzwww/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.50 KB )
/www/sites/relief33.cn/index/qzwww/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/sites/relief33.cn/index/qzwww/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/sites/relief33.cn/index/qzwww/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/sites/relief33.cn/index/qzwww/vendor/guzzlehttp/psr7/src/functions.php ( 13.09 KB )
/www/sites/relief33.cn/index/qzwww/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/sites/relief33.cn/index/qzwww/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/sites/relief33.cn/index/qzwww/vendor/qizuang/infra/src/functions.php ( 4.59 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/ThinkPHP.php ( 4.61 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Think.class.php ( 12.01 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Storage.class.php ( 1.34 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Storage/Driver/File.class.php ( 3.44 KB )
/www/sites/relief33.cn/index/qzwww/Application/Runtime/common~runtime.php ( 101.56 KB )
/www/sites/relief33.cn/index/qzwww/Application/Home/Conf/config.php ( 29.73 KB )
/www/sites/relief33.cn/index/qzwww/Application/Home/Common/function.php ( 2.64 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Behavior/ReadHtmlCacheBehavior.class.php ( 5.51 KB )
/www/sites/relief33.cn/index/qzwww/Application/Home/Controller/ArticleController.class.php ( 38.59 KB )
/www/sites/relief33.cn/index/qzwww/Application/Home/Common/Controller/HomeBaseController.class.php ( 0.43 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php ( 11.85 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Behavior/FilterErrorUrlBehavior.class.php ( 0.45 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Behavior.class.php ( 0.86 KB )
/www/sites/relief33.cn/index/qzwww/Application/Home/Behavior/BrowserScanCheckBehavior.class.php ( 1.19 KB )
/www/sites/relief33.cn/index/qzwww/Application/Library/Org/Util/App.class.php ( 13.32 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Behavior/MarkTrackingOrderSourceCheckBehavior.class.php ( 11.67 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Cache.class.php ( 3.72 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Cache/Driver/Redis.class.php ( 3.73 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/QuyuModel.class.php ( 21.40 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/BizMarketingModel.class.php ( 0.41 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Model.class.php ( 65.83 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Db.class.php ( 5.56 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Db/Driver/Mysql.class.php ( 9.09 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Db/Driver.class.php ( 40.95 KB )
/www/sites/relief33.cn/index/qzwww/Application/Library/Org/ipipdotnet/City.php ( 2.11 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/OptionsModel.class.php ( 4.24 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Cache/Driver/File.class.php ( 5.73 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Behavior/RobotCheckBehavior.class.php ( 1.61 KB )
/www/sites/relief33.cn/index/qzwww/Application/Library/Org/Tool/Mobile_Detect.php ( 80.07 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/WwwArticleModel.class.php ( 51.02 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/NatureSearchVisitLogicModel.class.php ( 3.13 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/BizMarketing/ThematicWordsLogicModel.class.php ( 12.85 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/ThematicWordsModel.class.php ( 10.42 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/BizMarketing/ArticleLogicModel.class.php ( 15.13 KB )
/www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/ff3779ceb910bdc3051b194b43aa3e6b.php ( 2.83 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Behavior/WriteHtmlCacheBehavior.class.php ( 1.40 KB )
/www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/f89211401238cb8627b81acd03c96908.php ( 6.23 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/WwwArticleClassModel.class.php ( 11.47 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/WwwArticlekeywordsModel.class.php ( 1.35 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Service/ElasticSearchServiceModel.class.php ( 17.11 KB )
/www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/4a4c9c5956a671ff27c268ca999d806f.php ( 0.94 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/BizMarketing/CompanyLogicModel.class.php ( 21.12 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/CompanyModel.class.php ( 66.11 KB )
/www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/UserModel.class.php ( 39.82 KB )
/www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/23636641f9f9aca04be711bec13e107f.php ( 8.73 KB )
/www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php ( 92.41 KB )
/www/sites/relief33.cn/index/qzwww/Core2015/Library/Behavior/ShowPageTraceBehavior.class.php ( 7.43 KB )

[8] Undefined index: LOCAL_ADDR /www/sites/relief33.cn/index/qzwww/Application/Runtime/common~runtime.php 第 1 行.
[8] Undefined index: LOCAL_PORT /www/sites/relief33.cn/index/qzwww/Application/Runtime/common~runtime.php 第 1 行.
[8] Undefined index: child /www/sites/relief33.cn/index/qzwww/Application/Common/Model/Db/BizMarketing/QuyuModel.class.php 第 77 行.
[8] Undefined index: cid /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 93 行.
[8192] Function Redis::delete() is deprecated /www/sites/relief33.cn/index/qzwww/Core2015/Library/Think/Cache/Driver/Redis.class.php 第 95 行.
[8] Undefined index: u_userInfo /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 105 行.
[8] Undefined variable: city /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 150 行.
[8] Undefined variable: city /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 159 行.
[8] Undefined index: bm /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 207 行.
[8] Undefined index: oldName /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 208 行.
[8] Undefined index: oldName /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 209 行.
[8] Undefined index: cid /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 210 行.
[8] Undefined index: usercount /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 212 行.
[8] Undefined index: lng /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 213 行.
[8] Undefined index: lat /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 214 行.
[8] Undefined index: province /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 215 行.
[8] Undefined index: center_password_token /www/sites/relief33.cn/index/qzwww/Application/Common/Controller/BaseController.class.php 第 234 行.
[8] Undefined variable: theCityId /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/ff3779ceb910bdc3051b194b43aa3e6b.php 第 51 行.
[8] Undefined variable: theCityId /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/f89211401238cb8627b81acd03c96908.php 第 51 行.
[8] Undefined variable: list /www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/BizMarketing/ArticleLogicModel.class.php 第 163 行.
[2] Invalid argument supplied for foreach() /www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/BizMarketing/ArticleLogicModel.class.php 第 163 行.
[8] Undefined variable: replaceLink /www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/BizMarketing/ArticleLogicModel.class.php 第 176 行.
[2] Invalid argument supplied for foreach() /www/sites/relief33.cn/index/qzwww/Application/Common/Model/Logic/BizMarketing/ArticleLogicModel.class.php 第 176 行.
[2] array_column() expects parameter 1 to be array, null given /www/sites/relief33.cn/index/qzwww/Application/Common/Model/Service/ElasticSearchServiceModel.class.php 第 146 行.
[2] Invalid argument supplied for foreach() /www/sites/relief33.cn/index/qzwww/Application/Home/Controller/ArticleController.class.php 第 229 行.
[8] Undefined variable: topbanner /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 44 行.
[8] Undefined variable: ifIndex /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 134 行.
[8] Undefined index: u_userInfo /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 457 行.
[8] Undefined variable: theCityId /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 835 行.
[8] Undefined variable: source /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 895 行.
[8] Undefined variable: var /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 1048 行.
[8] Undefined variable: ssid /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 1316 行.
[8] Undefined variable: theCityId /www/sites/relief33.cn/index/qzwww/Application/Runtime/Cache/Home/08630ee9b8451d6b403222a70da9028e.php 第 1400 行.

SELECT a.px_abc,a.cid as cid,a.cname,a.uid,a.type,a.bm,a.px,a.px_abc,a.parent_city,a.parent_city1,a.parent_city2,a.parent_city3,a.parent_city4,a.other_city,b.qz_areaid,b.qz_area,b.orders,c.qz_province,c.qz_bigpart,c.qz_bigpart_name,a.lng,a.lat FROM qz_quyu a inner join qz_area as b on a.cid = b.fatherid and b.type = 1 inner join qz_province as c on c.qz_provinceid = a.uid WHERE a.bm = 'www' AND b.type = 1 ORDER BY a.bm,qz_area DESC [ RunTime:0.0012s ]
UPDATE qz_www_article SET `realview`=realview+1 WHERE `id` = 123804 [ RunTime:0.0137s ]
SHOW COLUMNS FROM `qz_thematic_content_related` [ RunTime:0.0016s ]
SELECT b.id,b.`name` FROM qz_thematic_content_related a join qz_thematic_words b on a.thematic_id = b.id and b.is_show = 1 WHERE a.content_id = '123804' AND a.module = 1 AND b.type = 1 AND b.is_delete = 1 LIMIT 5 [ RunTime:0.0010s ]
SELECT * FROM qz_www_article_class WHERE `shortname` = 'jxwd' AND `obsolete` = 0 LIMIT 1 [ RunTime:0.0012s ]
SELECT * FROM qz_www_article_class WHERE `id` = 438 AND `obsolete` = 0 LIMIT 1 [ RunTime:0.0009s ]
SELECT a.*,c.id as cid,c.classname,c.shortname FROM qz_www_article a INNER JOIN qz_www_article_class_rel as b on b.article_id = a.id INNER JOIN qz_www_article_class as c on c.id = b.class_id WHERE a.id = '123804' AND b.class_id = '457' AND a.state = 2 LIMIT 1 [ RunTime:0.0011s ]
SHOW COLUMNS FROM `qz_keyword_relate` [ RunTime:0.0014s ]
SELECT b.name,b.href FROM qz_keyword_relate a INNER JOIN qz_www_article_keywords b on a.keyword_id = b.id WHERE `article_id` = '123804' AND `module` = 'wwwarticle' [ RunTime:0.0011s ]
SHOW COLUMNS FROM `qz_www_article_class` [ RunTime:0.0014s ]
SELECT c.id FROM qz_www_article_class c WHERE c.is_new = 1 AND c.shortname = 'jxwd' [ RunTime:0.0010s ]
SELECT a.id,a.title,c.shortname,c.classname,a.face,a.subtitle,a.likes,a.imgs,a.face,a.pv FROM qz_www_article a force index(idx_state) INNER JOIN qz_www_article_class_rel rel on rel.article_id = a.id INNER JOIN qz_www_article_class c on c.id = rel.class_id WHERE a.state = 2 AND c.id IN ('457') ORDER BY a.id desc LIMIT 0,7 [ RunTime:0.0705s ]
UPDATE qz_www_article SET `pv`=pv+1 WHERE `id` = 123804 [ RunTime:0.0078s ]
SELECT `id`,`name`,`type` FROM qz_thematic_words WHERE `is_delete` = 1 AND `is_show` = 1 AND `type` = 2 ORDER BY id desc LIMIT 30 [ RunTime:0.0207s ]
SELECT `id`,`name`,`type` FROM qz_thematic_words WHERE `is_delete` = 1 AND `is_show` = 1 AND `type` = 2 AND `is_hot` = 1 ORDER BY id desc LIMIT 30 [ RunTime:0.0176s ]
SHOW COLUMNS FROM `qz_thematic_content_related` [ RunTime:0.0014s ]
SELECT b.id,b.`name` FROM qz_thematic_content_related a join qz_thematic_words b on a.thematic_id = b.id and b.is_show = 1 WHERE a.content_id = '123804' AND a.module = 1 AND b.type = 1 AND b.is_delete = 1 LIMIT 5 [ RunTime:0.0010s ]
SELECT a.*,q.bm,q.cname,area.qz_area,(1.5 * a.liangfang + 10 * a.wanzhengdu + 0.5 * a.loginnum + 0.5 * a.answernum) hot,(1 * a.liangfang + 5 * a.qiandan + 0.1 * a.haoping + 10 * a.wanzhengdu) AS `rank` FROM ( SELECT * FROM ( SELECT t.*,`day`,`comid`,`liangfang`,`qiandan`,`haoping`,`wanzhengdu`,`ping`,`casesnum`,`loginnum`,`answernum`,`designnum` FROM ( SELECT a.id,a.qc,a.jc,a.register_time,a.logo,a.activte_score,a.case_count,a.cs,a.qx,a.on,b.fake FROM qz_user a INNER JOIN qz_user_company b on a.id = b.userid and b.fake = 0 WHERE a.classid IN (3,6) AND b.`is_show` = 1 AND a.on = 2 AND b.fake = 0 ) t INNER JOIN qz_user_company_rank c on c.comid = t.id WHERE c.`day` = '2025-01-11' ORDER BY c.day desc ) r GROUP BY comid ) a INNER JOIN qz_quyu as q on a.cs = q.cid left join qz_area area on area.qz_areaid = a.qx ORDER BY `rank` DESC,hot desc,a.register_time LIMIT 0,3 [ RunTime:0.0014s ]
SELECT a.*,q.bm,q.cname,area.qz_area,(1.5 * a.liangfang + 10 * a.wanzhengdu + 0.5 * a.loginnum + 0.5 * a.answernum) hot,(1 * a.liangfang + 5 * a.qiandan + 0.1 * a.haoping + 10 * a.wanzhengdu) AS `rank` FROM ( SELECT * FROM ( SELECT t.*,`day`,`comid`,`liangfang`,`qiandan`,`haoping`,`wanzhengdu`,`ping`,`casesnum`,`loginnum`,`answernum`,`designnum` FROM ( SELECT a.id,a.qc,a.jc,a.register_time,a.logo,a.activte_score,a.case_count,a.cs,a.qx,a.on,b.fake FROM qz_user a INNER JOIN qz_user_company b on a.id = b.userid and b.fake = 0 WHERE a.classid IN (3,6) AND b.`is_show` = 1 AND a.on <> 2 AND b.fake = 0 ) t INNER JOIN qz_user_company_rank c on c.comid = t.id WHERE c.`day` = '2025-01-11' ORDER BY c.day desc ) r GROUP BY comid ) a INNER JOIN qz_quyu as q on a.cs = q.cid left join qz_area area on area.qz_areaid = a.qx ORDER BY `rank` DESC,hot desc,a.register_time LIMIT 0,3 [ RunTime:0.0012s ]
SELECT a.*,q.bm,q.cname,area.qz_area FROM ( SELECT * FROM ( SELECT t.*,`day`,`comid`,`liangfang`,`qiandan`,`haoping`,`wanzhengdu`,`ping`,`casesnum`,`loginnum`,`answernum`,`designnum` FROM ( SELECT a.id,a.qc,a.jc,a.register_time,a.logo,a.activte_score,a.case_count,a.cs,a.qx,a.on,b.fake FROM qz_user a INNER JOIN qz_user_company b on a.id = b.userid and b.fake = 0 WHERE a.classid IN (3,6) AND b.`is_show` = 1 AND a.on = 2 AND b.fake = 0 ) t INNER JOIN qz_user_company_rank c on c.comid = t.id WHERE c.`day` = '2025-01-11' ORDER BY c.day desc ) r GROUP BY comid ) a INNER JOIN qz_quyu as q on a.cs = q.cid left join qz_area area on area.qz_areaid = a.qx ORDER BY a.casesnum DESC,a.register_time LIMIT 0,3 [ RunTime:0.0012s ]
SELECT a.*,q.bm,q.cname,area.qz_area FROM ( SELECT * FROM ( SELECT t.*,`day`,`comid`,`liangfang`,`qiandan`,`haoping`,`wanzhengdu`,`ping`,`casesnum`,`loginnum`,`answernum`,`designnum` FROM ( SELECT a.id,a.qc,a.jc,a.register_time,a.logo,a.activte_score,a.case_count,a.cs,a.qx,a.on,b.fake FROM qz_user a INNER JOIN qz_user_company b on a.id = b.userid and b.fake = 0 WHERE a.classid IN (3,6) AND b.`is_show` = 1 AND a.on <> 2 AND b.fake = 0 ) t INNER JOIN qz_user_company_rank c on c.comid = t.id WHERE c.`day` = '2025-01-11' ORDER BY c.day desc ) r GROUP BY comid ) a INNER JOIN qz_quyu as q on a.cs = q.cid left join qz_area area on area.qz_areaid = a.qx ORDER BY a.casesnum DESC,a.register_time LIMIT 0,3 [ RunTime:0.0012s ]