聯(lián)系官方銷(xiāo)售客服
1835022288
028-61286886
插件名稱(chēng) | 建站系統(tǒng) V3.19 |
插件作者 | 迅睿官方團(tuán)隊(duì) |
最近更新 | 2025-04-24 15:41:23 |
[高級(jí)版]內(nèi)容聚合欄目,增加滾動(dòng)條效果 [高級(jí)版]module標(biāo)簽優(yōu)化catid查詢(xún)條件效率 修復(fù)多網(wǎng)站時(shí)偶爾存在其他站點(diǎn)緩存丟失的情況 |
求教一下,想調(diào)用當(dāng)天的總瀏覽量,用了下面這段代碼怎么不管用
{sum sum=hits action=module module=all DAY_updatetime=0}
參考文檔:《求和/累計(jì)運(yùn)算標(biāo)簽 sum標(biāo)簽》
Debug標(biāo)簽輸出一下,看看數(shù)據(jù)。{$debug_sum}
回復(fù)@開(kāi)源社區(qū)插件技術(shù)-小鵬 標(biāo)簽解析:{list sum sum=hits action=module module=all DAY_updatetime=0}錯(cuò)誤提示:在[my]表中字段[updatetime]不存在(可用字段:id、hits),字段不存在還有辦法嗎
加一個(gè)field=updatetime參數(shù)
回復(fù)@開(kāi)源社區(qū)插件技術(shù)-小鵬
{sum sum=hits action=module module=all DAY_updatetime=0 field=updatetime}
是這樣嗎,加上了,調(diào)出來(lái)數(shù)據(jù)一直是0
要看debug數(shù)據(jù)才能知道原因
回復(fù)@開(kāi)源社區(qū)插件技術(shù)-小鵬
標(biāo)簽解析:{list sum sum=hits action=module module=all DAY_updatetime=0 field=updatetime}
查詢(xún)解析: SELECT sum(hits) as ct FROM (SELECT updatetime,id,hits,'news' AS mid FROM `zcga_1_news` UNION ALL SELECT updatetime,id,hits,'zhuanti' AS mid FROM `zcga_1_zhuanti` UNION ALL SELECT updatetime,id,hits,'zddh' AS mid FROM `zcga_1_zddh` UNION ALL SELECT updatetime,id,hits,'jzemail' AS mid FROM `zcga_1_jzemail` UNION ALL SELECT updatetime,id,hits,'ztzl' AS mid FROM `zcga_1_ztzl` UNION ALL SELECT updatetime,id,hits,'fjzj' AS mid FROM `zcga_1_fjzj` UNION ALL SELECT updatetime,id,hits,'wlxxaq' AS mid FROM `zcga_1_wlxxaq` UNION ALL SELECT updatetime,id,hits,'fzgajsn' AS mid FROM `zcga_1_fzgajsn` UNION ALL SELECT updatetime,id,hits,'qjszlb' AS mid FROM `zcga_1_qjszlb` UNION ALL SELECT updatetime,id,hits,'sjwj' AS mid FROM `zcga_1_sjwj` UNION ALL SELECT updatetime,id,hits,'wzggw' AS mid FROM `zcga_1_wzggw` UNION ALL SELECT updatetime,id,hits,'gajb' AS mid FROM `zcga_1_gajb` UNION ALL SELECT updatetime,id,hits,'tztb' AS mid FROM `zcga_1_tztb` UNION ALL SELECT updatetime,id,hits,'zddb' AS mid FROM `zcga_1_zddb` UNION ALL SELECT updatetime,id,hits,'qzrb' AS mid FROM `zcga_1_qzrb` UNION ALL SELECT updatetime,id,hits,'mrqw' AS mid FROM `zcga_1_mrqw` UNION ALL SELECT updatetime,id,hits,'yyxtdh' AS mid FROM `zcga_1_yyxtdh` UNION ALL SELECT updatetime,id,hits,'qjszlba' AS mid FROM `zcga_1_qjszlba` UNION ALL SELECT updatetime,id,hits,'fzgajsna' AS mid FROM `zcga_1_fzgajsna` UNION ALL SELECT updatetime,id,hits,'yycx' AS mid FROM `zcga_1_yycx` UNION ALL SELECT updatetime,id,hits,'zbbqb' AS mid FROM `zcga_1_zbbqb` UNION ALL SELECT updatetime,id,hits,'zfjd' AS mid FROM `zcga_1_zfjd` UNION ALL SELECT updatetime,id,hits,'xxfw' AS mid FROM `zcga_1_xxfw` UNION ALL SELECT updatetime,id,hits,'zhibanbiao' AS mid FROM `zcga_1_zhibanbiao`) as my WHERE (`my`.`updatetime` BETWEEN 1711900800 AND 1711952812) ORDER BY NULL
查詢(xún)耗時(shí): 0.00093793869018555s
當(dāng)前路由:home/index
動(dòng)態(tài)地址:index.php?
變量前綴:t
運(yùn)算數(shù)量:
運(yùn)算變量:自動(dòng)輸出
出現(xiàn)這些,沒(méi)看出錯(cuò)誤來(lái)