supesite完美實現(xiàn)調用資訊顯示縮略圖

1、supesite完美實現(xiàn)調用資訊顯示縮略圖本調用代碼用于放置在首頁中，列表模塊帶緩存，每個分頁的緩存時間相差20秒，避免同一時間所有緩存全部失效，某一時刻非常緩慢的問題。列表數(shù)量統(tǒng)計的模塊也帶緩存。取所有頻道的資訊文章，有縮略圖顯示縮略圖，無縮略圖顯示無縮略圖的文件。對比嵌套循環(huán)查詢，極大減少數(shù)據(jù)庫查詢次數(shù)(嵌套查詢可能達到11次數(shù)據(jù)庫查詢)，本方法只需查詢一次數(shù)據(jù)庫。列表模塊對應的sql語句為select i.itemid,i.catid,i.uid,i.username,i.subject,i.dateline,i.viewnum,i.replynum,i.digest,i.top,i.p

2、icid,,n.message,a.thumbpath,a.subject as a_subject from supe_spaceitems iinner join supe_spacenews non i.itemid=n.itemid inner join supe_categories con i.catid=c.catid left join supe_attachments aon i.picid=a.aid where i.type=newsorder by i.top desc,i.itemid desc兩個inner join內聯(lián)一個left join左連接做四表

3、聯(lián)查，全部為主鍵或者索引查詢，相對效率高。由于用了聯(lián)查，block模塊中的perpage分頁代碼無效，只能自己調用multi函數(shù)處理分頁內容。分頁數(shù)量統(tǒng)計對應的sql語句為select count(itemid)as total fromsupe_spaceitemswhere type=newscachename緩存以mynews_pagexx命名的變量，解決緩存覆蓋問題。supesite 7.5，256m內存vps服務器在每秒1000次并發(fā)壓力下，關閉緩存平均頁面執(zhí)行時間為0.08秒，開啟緩存平均0.006秒執(zhí)行時間。完整調用代碼如下：！-article begin-div class=a

4、rticle！-eval$basecachetime=3500；/*設置本頁面基礎緩存時間*/-！-eval$baseperpage=10；/*設置本頁面的單頁文章數(shù)量*/-！-eval$mypage=$_sgetpage?$_sgetpage：1；-！-eval$mystart=($mypage-1)*$baseperpage-！-eval$mycachename=mynews_page.$mypage-！-eval$mycachetime=$basecachetime+$mystart*2-！-block name=spacenewsparameter=type/news/sql/sele

5、ct%20i.itemid%2c%20i.catid%2c%20i.uid%2c%20i.username%2c%20i.subject%2c%20i.dateline%2c%20i.viewnum%2c%20i.replynum%2c%20i.digest%2c%20i.top%2c%20i.picid%2c%20%2c%20n.message%2c%20a.thumbpath%2c%20a.subject%20as%20a_subject%0d%0afrom%20supe_spaceitems%20i%0d%0ainner%20join%20supe_spacenews%20n

6、%20on%20i.itemid%20%3d%20n.itemid%0d%0ainner%20join%20supe_categories%20c%20on%20i.catid%20%3d%20c.catid%0d%0aleft%20join%20supe_attachments%20a%20on%20i.picid%20%3d%20a.aid%0d%0aorder%20by%20i.top%20desc%2c%20i.itemid%20desc/limit/$mystart,$baseperpage/cachename/$mycachename/cachetime/$mycachetime/

7、tpl/data-！-thiese block had cached in dollar_sblock$mycachename-！-loop$_sblock$mycachename$value-！-eval$valuemessage=trim(strip_tags($valuemessage)；-！-eval$valuemessage=trim(cutstr($valuemessage,290,1)；-！-if$valuetop-！-eval$valuesubject=置頂.$valuetop.$valuesubject；-！-/if-！-if$valuedigest-！-eval$value

8、subject.=精華.$valuedigest.；-！-/if-div class=posth2 ahref=title=$valuesubject$valuesubject/a/h2 span class=pcommentsem$valuereplynum/em個評論/span div class=clear/div！-if$valuethumbpath-a href=img src=title=$valuea_subjectalt=$valuea_subjectclass=thumb_image/a！-else-a href=img src=title=$valuesubjectalt=

9、$valuesubjectclass=thumb_image/a！-/if-div class=pcontent$valuemessage/div div class=clear/div div class=pmeta#date(y-m-d,$valuedateline)#/a href=title=$valuename$valuename/a/$valueviewnum瀏覽/div ahref=title=閱讀全文class=readmore閱讀全文/a/div！-/loop-！-navigation begin-div class=page_navi！-翻頁輸出控制-！-eval$myli

10、stcount=1；-！-block name=categoryparameter=sql/select%20count%28%20itemid%20%29%20as%20total%20from%20%60supe_spaceitems%60/limit/1/cachetime/$basecachetime/cachename/indexcount/tpl/data-！-index listcount has cached in mylistcount-！-eval$mylistcount=$_sblockindexcount0total；-！-if$mylistcount-！-eval$_sgetaction=index；-！-eval$myurlarr=$_sget；-！-eval unset($myurlarrpage)；-！-eval$_sblockmynews_multi