跳至主要內容
:::

11-4 上傳影片並產生縮圖

一、安裝所需環境

  1. 上傳影片必須要注意 php.ini 中的一些設定(一樣編輯php.ini,修改後重啟即可):
    1. file_uploads=On:支持 HTTP 上傳
    2. upload_max_filesize=600M:允許上傳檔案容量的上限
    3. max_file_uploads=20:允許一次上傳的最大檔案數量
    4. post_max_size=620M:表單發送資料容量的上限(需>=upload_max_filesize
    5. max_execution_time=300:設定程式被解析器終止之前允許的最大執行時間,防止程式寫得不好而耗盡伺服器資源,單位: 秒(-1 為不限制)。
    6. memory_limit=128M:一個 Web 請求,給予該執行緒記憶體使用量的上限。
       
  2. 要從影片擷取出圖檔,必須借助 FFMpegPHP-FFMpeg
  3. 請先安裝 FFMpeg,這裡以 https://www.gyan.dev/ffmpeg/builds/ffmpeg-release-full.7z 為例
  4. 下載後,解壓縮至專案目錄下的ffmpeg目錄,像這樣:
  5. PHP-FFMpeg可透過Composer安裝之,按 Ctrl+` 開啟終端機,並貼上 :
    composer require php-ffmpeg/php-ffmpeg

     

二、產生影片縮圖

  1. 先上傳影片後產生截圖,最後在產生縮圖即可。
  2. 產生縮圖的基本用法(這裡直接使用完整命名空間,所以無須事先 use),其中路徑的地方記得用絕對路徑:
    // 建立物件
    $ffmpeg = FFMpeg\FFMpeg::create(array(
        'ffmpeg.binaries' => _PATH . '/ffmpeg/bin/ffmpeg.exe',
        'ffprobe.binaries' => _PATH . '/ffmpeg/bin/ffprobe.exe',
        'timeout' => 3600, // 底層進程的時間上限
        'ffmpeg.threads' => 12, // FFMpeg 應該使用的線程數
    ));
    // 開啟影片
    $video = $ffmpeg->open(影片檔來源);
    // 擷取第N秒的話格,並存檔
    $video
        ->frame(FFMpeg\Coordinate\TimeCode::fromSeconds(秒數))
        ->save(圖片位置及檔名);
    

     

  3. 影片一律只接受 mp4,因為相容性最高
  4. 修改上傳部份如下:
    // 依序讀出檔案
    foreach ($_FILES['files']['name'] as $i => $filename) {
        ...略...
    
        // 檢查檔案是否上傳成功
        if ($_FILES['files']['error'][$i] === UPLOAD_ERR_OK) {
    
            ...略...
    
            // 原圖欲放置到哪裡
            $dest = _PATH . "/uploads/{$id}/{$prefix}-{$i}.{$ext}";
    
            if ($ext == 'mp4') {
                // 縮圖欲放置到哪裡
                $thumb_dest = _PATH . "/uploads/{$id}/thumbs/{$prefix}-{$i}.jpg";
    
                // 將檔案移至指定位置
                if (move_uploaded_file($file, $dest)) {
                    // 物件設定
                    $ffmpeg = FFMpeg\FFMpeg::create(array(
                        'ffmpeg.binaries' => _PATH . '/ffmpeg/bin/ffmpeg.exe',
                        'ffprobe.binaries' => _PATH . '/ffmpeg/bin/ffprobe.exe',
                        'timeout' => 3600, // The timeout for the underlying process
                        'ffmpeg.threads' => 12, // The number of threads that FFMpeg should use
                    ));
                    // 開啟影片
                    $video = $ffmpeg->open($dest);
                    // 擷取畫面
                    $video
                        ->frame(FFMpeg\Coordinate\TimeCode::fromSeconds(10))
                        ->save($thumb_dest);
                    // 製作縮圖 
                    $image = Image::make($thumb_dest)->resize(480, 480, function ($constraint) {
                        $constraint->aspectRatio();
                        $constraint->upsize();
                    })->save($thumb_dest);
                } else {
                    die("無法將檔案{$file}上傳至指定位置{$dest}");
                }
            } else {
                ...略...
            }
    
        } else {
            die("上傳錯誤:{$_FILES['files']['error'][$i]}");
        }
    }

     

    1. 由於影片沒有所謂的原圖,只有原檔,所以,仍用move_uploaded_file()的方式將影片移到上傳目錄下。
    2. 影片的縮圖一律為 jpg,因此,縮圖檔名部份的設定,我們依據副檔名不同,分開處理
    3. 可利用 TimeCode::fromSeconds(10) 來設定要抓取第幾秒的畫面
    4. 抓到畫面後,用剛剛的縮圖工具來做縮圖

:::

書籍目錄

展開 | 闔起

快速登入


https%3A%2F%2Fcampus-xoops.tn.edu.tw%2Fmodules%2Ftad_book3%2Fpage.php%3Ftbdsn%3D1818%26tbsn%3D52

計數器

今天: 453453453
昨天: 4310431043104310
總計: 9137624913762491376249137624913762491376249137624
全部 錯誤訊息 (73) 已棄用 (0) 資料庫語法 (38) 區塊 (9) 額外資訊 (2) 計時(6)
錯誤訊息
未知: Creation of dynamic property Smarty_Internal_Extension_Handler::$assignByRef is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php 列 182
未知: Creation of dynamic property Smarty_Internal_Extension_Handler::$loadPlugin is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php 列 182
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Extension_Handler::$_foreach is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php 列 182
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_logcounterx_school2022_default^82ef57587fa6739f25bec43c4a8b75b0fec1cb14_0.db.lcxblockdisplay.html.php 列 27
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_logcounterx_school2022_default^82ef57587fa6739f25bec43c4a8b75b0fec1cb14_0.db.lcxblockdisplay.html.php 列 42
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_logcounterx_school2022_default^82ef57587fa6739f25bec43c4a8b75b0fec1cb14_0.db.lcxblockdisplay.html.php 列 42
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_logcounterx_school2022_default^82ef57587fa6739f25bec43c4a8b75b0fec1cb14_0.db.lcxblockdisplay.html.php 列 42
未知: Creation of dynamic property XoopsModules/Tadtools/Dtree::$title_opt is deprecated 在檔案中的第 /modules/tadtools/class/Dtree.php 列 16
未知: Creation of dynamic property XoopsModules/Tadtools/Dtree::$cate_opt is deprecated 在檔案中的第 /modules/tadtools/class/Dtree.php 列 17
未知: Creation of dynamic property XoopsModules/Tadtools/Dtree::$url_opt is deprecated 在檔案中的第 /modules/tadtools/class/Dtree.php 列 18
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
警告: Undefined array key 2 在檔案中的第 /modules/tad_login/blocks/tad_login.php 列 22
警告: Undefined array key 2 在檔案中的第 /modules/tad_login/blocks/tad_login.php 列 56
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_login_school2022_default^9a36fe6b7ef2d97043df58e0037061e72053376e_0.db.tadlogin.tpl.php 列 27
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
警告: Undefined array key "next" 在檔案中的第 /modules/tad_book3/page.php 列 84
未知: explode(): Passing null to parameter #2 ($string) of type string is deprecated 在檔案中的第 /modules/tad_book3/page.php 列 84
未知: Creation of dynamic property Smarty_Internal_Extension_Handler::$getTemplateVars is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_extension_handler.php 列 182
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_book3_school2022_default^84539fe8acd40c5f378f06891603c382520ffd84_0.file.theme_css_blocks.tpl.php 列 25
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_book3_school2022_default^8769a883ca1ac623e41162c9d54b2ce8411757a6_0.file.menu_my.tpl.php 列 25
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
警告: Undefined array key "tlogin" 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_book3_school2022_default^4b700abaeaf1cda7df0a719b7b2be562ca91d32a_0.file.menu_login.tpl.php 列 102
警告: Attempt to read property "value" on null 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_book3_school2022_default^4b700abaeaf1cda7df0a719b7b2be562ca91d32a_0.file.menu_login.tpl.php 列 102
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_book3_school2022_default^eeb059e288a364212fc4e3c5217e3ce0a98cc7cf_0.file.leftBlock.tpl.php 列 50
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_book3_school2022_default^595b03a20f1630ce88f70eb9ec2ebfacab28ac31_0.file.rightBlock.tpl.php 列 27
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Variable::$do_else is deprecated 在檔案中的第 /www/wwwroot/campus/xoops_data/caches/smarty_compile/e5b8b7fe_tad_book3_school2022_default^c3b372c147783809409e53366a84afc38a02d392_0.file.footerBlock.tpl.php 列 51
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
未知: Creation of dynamic property Smarty_Internal_Template::$compiled is deprecated 在檔案中的第 /class/libraries/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php 列 719
已棄用
資料庫語法
0.000069 - SET SQL_BIG_SELECTS = 1
0.000415 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC
0.000204 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '6o324m5v760ahvhl080mc6c5kl'
0.000297 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '31')
0.000189 - SELECT * FROM config WHERE (`conf_modid` = '31') ORDER BY conf_order ASC
0.000227 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC
0.000212 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC
0.000913 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3)
0.000583 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,31) AND b.bid IN (1,4,5,6,7,8,9,10,11,13,14,15,16,17,18,19,20,21,22,23,24,25,26,179,178,98,97,150,177,78,176,99,94,175,59,96,173,67,83,84,85,86,87,170,88,154,171,90,91,93,168,95,100,104,3,102,107,111,112,113,114,115,116,117,122,130,131,139,140,141,144,174,147,148,149,151,152,153,160,161,162,163,164) ORDER BY b.weight, m.block_id
0.000198 - SELECT cfgname, cfgvalue FROM logcounterx_cfg
0.002312 - DELETE FROM logcounterx_ip WHERE acctime < 1773173428
0.000132 - SELECT accip FROM logcounterx_ip WHERE accip = '216.73.216.210'
0.000113 - UPDATE logcounterx_ip SET acctime = 1773174028 WHERE accip = '216.73.216.210'
0.000301 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_dummy.tpl') ORDER BY tpl_refid
0.000250 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tadtools_qrcode_block.tpl') ORDER BY tpl_refid
0.000196 - SELECT cfgname, cfgvalue FROM logcounterx_cfg
0.000140 - SELECT cnt FROM logcounterx_count WHERE ymd = '2026-03-11'
0.000138 - SELECT cnt FROM logcounterx_count WHERE ymd = '2026-03-10'
0.000112 - SELECT cnt FROM logcounterx_count WHERE (ymd = '1111-11-11') OR (ymd = '1111/11/11')
0.000318 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'lcx_block_display.html') ORDER BY tpl_refid
0.000349 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tad_book3_block_index.tpl') ORDER BY tpl_refid
0.000195 - SELECT * FROM config WHERE (`conf_modid` = '37') ORDER BY conf_order ASC
0.000253 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tad_login.tpl') ORDER BY tpl_refid
0.000650 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '33' AND (`gperm_groupid` = '3') AND `gperm_name` = 'forum_read')
0.000345 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tad_discuss_cbox.tpl') ORDER BY tpl_refid
0.000294 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_search.tpl') ORDER BY tpl_refid
0.000680 - SELECT `conf_value` FROM `config` WHERE `conf_name` = 'allow_register'
0.000232 - SELECT `mid`, `name`, `dirname` FROM `modules` WHERE `isactive` = 1 AND `hasmain` = 1 AND `weight` != 0 ORDER BY `weight`
0.000118 - SELECT `conf_value` FROM `config` WHERE `conf_title` = '_MD_AM_DEBUGMODE'
0.000139 - SELECT COUNT(*) FROM `priv_msgs` WHERE `to_userid` = 0 AND `read_msg`=0 GROUP BY `to_userid`
0.000161 - SELECT `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group`, `of_level` FROM `tad_themes_menu` WHERE `status` = 1 ORDER BY `of_level`, `position`
0.000968 - desc `tad_book3_data_center` `sort`
0.000256 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tad_book3_data_center` where `mid`= '31' and `col_name`='read_tbdsn_date' and `col_sn`='1818' order by `sort` , `data_sort`
0.000214 - SELECT * FROM config WHERE (`conf_modid` = '3') ORDER BY conf_order ASC
0.000878 - desc `tad_book3_data_center` `sort`
0.000243 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tad_book3_data_center` where `mid`= '31' and `col_name`='video_tbdsn_date' and `col_sn`='1818' order by `sort` , `data_sort`
0.000125 - SELECT `groupid`,`name` FROM `groups`
0.000293 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tadbook3_index.tpl') ORDER BY tpl_refid
總計: 38
區塊
紀錄區塊: 沒有快取
自訂區塊(HTML): 沒有快取
本頁面行動條碼: 沒有快取
自訂區塊(HTML): 沒有快取
計數器: 沒有快取
書籍目錄: 沒有快取
快速登入: 沒有快取
即時留言簿: 沒有快取
搜尋: 沒有快取
總計: 9
額外資訊
包含檔案: 261 檔案
使用記憶體: 1781648 bytes
計時
XOOPS 使用 0.080 秒來載入。
XOOPS Boot 使用 0.006 秒來載入。
Module init 使用 0.002 秒來載入。
XOOPS output init 使用 0.048 秒來載入。
Module display 使用 0.017 秒來載入。
Page rendering 使用 0.007 秒來載入。