聯(lián)系官方銷售客服
1835022288
028-61286886
插件名稱 | 建站系統(tǒng) V3.17 |
插件作者 | 迅睿官方團(tuán)隊(duì) |
最近更新 | 2024-12-19 10:00:07 |
[高級(jí)版]針對(duì)達(dá)夢(mèng)數(shù)據(jù)庫(kù)的搜索參數(shù)優(yōu)化 手機(jī)模板自動(dòng)識(shí)別模式下,增加將平板端排除開關(guā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ù)@開源社區(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ù)@開源社區(qū)插件技術(shù)-小鵬
{sum sum=hits action=module module=all DAY_updatetime=0 field=updatetime}
是這樣嗎,加上了,調(diào)出來數(shù)據(jù)一直是0
要看debug數(shù)據(jù)才能知道原因
回復(fù)@開源社區(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)這些,沒看出錯(cuò)誤來