標(biāo)簽解析:{list sum sum=hits action=module module=all DAY_updatetime=0 field=updatetime}
查詢解析: 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
參考文檔:《求和/累計(jì)運(yùn)算標(biāo)簽 sum標(biāo)簽》
Debug標(biāo)簽輸出一下,看看數(shù)據(jù)。{$debug_sum}
開(kāi)源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(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ù)
開(kāi)源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(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ù)才能知道原因
開(kāi)源是一種精神,但不是義務(wù),幫忙是情分,不幫也不要抱怨,建議大家多研究代碼、多閱讀代碼、多翻閱社區(qū)歷史問(wèn)題!
回復(fù)@開(kāi)源社區(qū)插件技術(shù)-小鵬
標(biāo)簽解析:{list sum sum=hits action=module module=all DAY_updatetime=0 field=updatetime}
查詢解析: 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
查詢耗時(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)