• 繁體中文
  • English
TECSTAR

TECSTAR

  • 首頁
  • 關於我們
    • 公司簡介
    • 企業使命
  • 產品一覽
  • 新聞動態
  • 人才招聘
    • 職位信息
    • 應聘流程
  • 聯絡我們
  • 資料下載
winner
yacco
nigr

新聞動態

  • INNOVACAR Authorized Detailer 18-19/9/2023

    INNOVACAR Authorized Detailer 18,19-9-2023 

    意大利美容品牌INNOVACAR一連兩日在洪水橋舉行美容証書課程,本司引入最新自我修服鍍膜,特別邀請意大利INNOVACAR總技術總監作培訓,完成後更可獲証書認証,產品及施工商都可以得到保証!

  • INNOVACAR Open Training Day 17-9-2023

    意大利 INNOVACAR頂級汽車美容產品技術總監來港舉行車主用家Open Training Day 

  • 16-17/9/2023 中山美食兩天團

    德泰有限公司-「識德有著數」一直以來注重與客戶之間的關係,務求達至「以樂會友」,並希望能夠促進業界同業互相交流、增進友誼

<
>

最新動態

與我們聯繫

香港新界沙田火炭山尾街43-47號環球工業中心1307-1308室
電話: (852) 2699-1282
傳真: (852) 2699-0708

電郵: Email住址會使用灌水程式保護機制。你需要啟動Javascript才能觀看它

  • 首頁
  • 關於我們
  • 產品一覽
  • 新聞動態
  • 人才招聘
  • 聯絡我們
  • 資料下載

Follow us

  • Google +
  • Twitter
  • Facebook
  • Pinterest
  • Linkedin

Join our newsletter

And always stay informed of the latest company news and events!
© 2023 TECSTAR Privacy policy

Joomla! 除錯主控台

連線階段 (Session)

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1702155687,
                "last": 1702155687,
                "now": 1702155687
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

側寫資訊

時間

記憶體

時間: 14.94 ms / 14.94 ms 記憶體: 0.550 MB / 0.93 MB Application: afterLoad
時間: 62.66 ms / 77.60 ms 記憶體: 3.394 MB / 4.33 MB Application: JD-Framework-Before-Load
時間: 6.64 ms / 84.24 ms 記憶體: 0.037 MB / 4.37 MB Application: JD-Framework-After-Load
時間: 12.74 ms / 96.97 ms 記憶體: 0.991 MB / 5.36 MB Application: afterInitialise
時間: 25.21 ms / 122.18 ms 記憶體: 1.130 MB / 6.49 MB Application: afterRoute
時間: 6.77 ms / 128.96 ms 記憶體: 0.199 MB / 6.68 MB Application: beforeRenderComponent com_content
時間: 11.97 ms / 140.92 ms 記憶體: 0.699 MB / 7.38 MB Application: Start JAccess::getAssetRules Old (1)
時間: 1.28 ms / 142.21 ms 記憶體: 0.033 MB / 7.42 MB Application: Finish JAccess::getAssetRules Old (1)
時間: 0.04 ms / 142.25 ms 記憶體: 0.000 MB / 7.41 MB Application: Start JAccess::preload(components)
時間: 1.87 ms / 144.11 ms 記憶體: 0.209 MB / 7.62 MB Application: Finish JAccess::preload(components)
時間: 16.08 ms / 160.20 ms 記憶體: 0.351 MB / 7.97 MB Application: afterRenderComponent com_content
時間: 9.47 ms / 169.66 ms 記憶體: 0.499 MB / 8.47 MB Application: afterDispatch
時間: 16.43 ms / 186.10 ms 記憶體: 0.295 MB / 8.76 MB Application: beforeRenderModule mod_articles_single (與我們聯繫)
時間: 22.24 ms / 208.34 ms 記憶體: 1.291 MB / 10.06 MB Application: afterRenderModule mod_articles_single (與我們聯繫)
時間: 0.07 ms / 208.40 ms 記憶體: 0.000 MB / 10.03 MB Application: beforeRenderModule mod_menu (footer link)
時間: 4.72 ms / 213.12 ms 記憶體: 0.048 MB / 10.08 MB Application: afterRenderModule mod_menu (footer link)
時間: 0.05 ms / 213.17 ms 記憶體: 0.000 MB / 10.07 MB Application: beforeRenderModule mod_menu (Follow us)
時間: 3.64 ms / 216.81 ms 記憶體: 0.039 MB / 10.11 MB Application: afterRenderModule mod_menu (Follow us)
時間: 0.05 ms / 216.86 ms 記憶體: 0.000 MB / 10.11 MB Application: beforeRenderModule mod_acymailing (Join our newsletter)
時間: 12.31 ms / 229.17 ms 記憶體: 0.730 MB / 10.84 MB Application: afterRenderModule mod_acymailing (Join our newsletter)
時間: 0.09 ms / 229.25 ms 記憶體: 0.000 MB / 10.83 MB Application: beforeRenderModule mod_caroufredsel (新聞動態)
時間: 8.87 ms / 238.12 ms 記憶體: 0.171 MB / 11.01 MB Application: afterRenderModule mod_caroufredsel (新聞動態)
時間: 0.08 ms / 238.20 ms 記憶體: 0.000 MB / 10.93 MB Application: beforeRenderModule mod_custom (最新動態)
時間: 1.57 ms / 239.77 ms 記憶體: 0.022 MB / 10.95 MB Application: afterRenderModule mod_custom (最新動態)
時間: 0.08 ms / 239.85 ms 記憶體: 0.000 MB / 10.95 MB Application: beforeRenderModule mod_articles_single (首頁品牌LOGO)
時間: 2.98 ms / 242.83 ms 記憶體: 0.048 MB / 11.00 MB Application: afterRenderModule mod_articles_single (首頁品牌LOGO)
時間: 0.09 ms / 242.92 ms 記憶體: 0.000 MB / 10.97 MB Application: beforeRenderModule mod_banners (BANNER)
時間: 8.27 ms / 251.19 ms 記憶體: 0.130 MB / 11.10 MB Application: afterRenderModule mod_banners (BANNER)
時間: 0.10 ms / 251.29 ms 記憶體: 0.000 MB / 11.09 MB Application: beforeRenderModule mod_superfish_menu (主菜单)
時間: 7.75 ms / 259.04 ms 記憶體: 0.048 MB / 11.14 MB Application: afterRenderModule mod_superfish_menu (主菜单)
時間: 0.08 ms / 259.12 ms 記憶體: 0.000 MB / 11.14 MB Application: beforeRenderModule mod_languages (语言切换器)
時間: 5.51 ms / 264.63 ms 記憶體: 0.028 MB / 11.16 MB Application: afterRenderModule mod_languages (语言切换器)
時間: 6.28 ms / 270.92 ms 記憶體: 0.158 MB / 11.32 MB Application: afterRender

資料庫查詢總計: 37.60 ms

記憶體使用量

11.98 MB (12,560,960 位元組)

資料庫查詢

39 查詢記錄 37.60 ms


  1. 查詢時間: 0.51 ms 查詢記憶體: 0.024 MB 記憶體於查詢: 2.608 MB 前 回傳的列: 0
    SELECT `data`
    
      FROM `dt_session`
      WHERE `session_id` = 'rhtg3srj3h0d0q78c9aa6ur6eu'
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_sessionconstPRIMARYPRIMARY575const1
    側寫
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.17 ms
    preparing0.02 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    13JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:44
    12JSessionStorageDatabase->read()與下面行一樣的呼叫
    11session_start()JROOT/libraries/joomla/session/handler/native.php:259
    10JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:49
    9JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:81
    8JSessionHandlerJoomla->start()JROOT/libraries/joomla/session/session.php:636
    7JSession->_start()JROOT/libraries/joomla/session/session.php:596
    6JSession->start()JROOT/libraries/cms/application/cms.php:773
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  2. 查詢時間: 1.23 ms 最後的查詢: 3.28 ms 之後 查詢記憶體: 0.003 MB 記憶體於查詢: 2.743 MB 前
    DELETE 
    
      FROM `dt_session`
      WHERE `time` < '1702154787'
    說明
    EXPLAIN 無法被使用於查詢: DELETE FROM `dt_session` WHERE `time` < '1702154787'
    側寫
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.09 ms
    updating0.09 ms
    end0.01 ms
    query end0.82 ms
    closing tables0.02 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    6JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:790
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  3. 查詢時間: 0.29 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 2.748 MB 前 回傳的列: 0
    SELECT `session_id`
    
      FROM `dt_session`
      WHERE `session_id` = 'rhtg3srj3h0d0q78c9aa6ur6eu'
      LIMIT 1
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_sessionconstPRIMARYPRIMARY575const1Using index
    側寫
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    呼叫堆疊
    #Caller檔案與行號
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    7JDatabaseDriver->loadResult()JROOT/libraries/cms/application/cms.php:176
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  4. 查詢時間: 0.75 ms 最後的查詢: 0.07 ms 之後 查詢記憶體: 0.003 MB 記憶體於查詢: 2.753 MB 前
    INSERT INTO `dt_session`
    (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('rhtg3srj3h0d0q78c9aa6ur6eu', 0, 1, '1702155687', 0, '')
    說明
    EXPLAIN 無法被使用於查詢: INSERT INTO `dt_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('rhtg3srj3h0d0q78c9aa6ur6eu', 0, 1, '1702155687', 0, '')
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After opening tables0.00 ms
    init0.01 ms
    update0.14 ms
    end0.01 ms
    query end0.46 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.00 ms
    呼叫堆疊
    #Caller檔案與行號
    7JDatabaseDriverMysqli->execute()JROOT/libraries/cms/application/cms.php:212
    6JApplicationCms->checkSession()JROOT/libraries/cms/application/cms.php:799
    5JApplicationCms->loadSession()JROOT/libraries/cms/application/cms.php:131
    4JApplicationCms->__construct()JROOT/libraries/cms/application/site.php:63
    3JApplicationSite->__construct()JROOT/libraries/cms/application/cms.php:408
    2JApplicationCms::getInstance()JROOT/libraries/joomla/factory.php:125
    1JFactory::getApplication()JROOT/index.php:46
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  5. 查詢時間: 0.59 ms 最後的查詢: 3.30 ms 之後 查詢記憶體: 0.028 MB 記憶體於查詢: 2.978 MB 前 回傳的列: 35
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `dt_extensions`
      WHERE `type` = 'component'
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_extensionsrefextensionextension62const35Using index condition
    側寫
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.15 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    8JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    7JCacheControllerCallback->get()JROOT/libraries/cms/component/helper.php:448
    6JComponentHelper::load()JROOT/libraries/cms/component/helper.php:43
    5JComponentHelper::getComponent()JROOT/libraries/cms/component/helper.php:120
    4JComponentHelper::getParams()JROOT/libraries/cms/application/site.php:589
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  6. 查詢時間: 0.44 ms 最後的查詢: 1.79 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 3.099 MB 前 回傳的列: 2
    SELECT b.id
    
      FROM dt_usergroups AS a
      LEFT JOIN dt_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where; Using index
    側寫
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    10JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:835
    9JAccess::getGroupsByUser()JROOT/libraries/joomla/access/access.php:904
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  7. 查詢時間: 0.29 ms 最後的查詢: 0.78 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 3.145 MB 前 回傳的列: 5
    SELECT id, rules
    
      FROM `dt_viewlevels`
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_viewlevelsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5
    側寫
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.01 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    9JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:921
    8JAccess::getAuthorisedViewLevels()JROOT/libraries/joomla/user/user.php:454
    7JUser->getAuthorisedViewLevels()JROOT/libraries/cms/plugin/helper.php:296
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  8. 查詢時間: 0.88 ms 最後的查詢: 0.08 ms 之後 查詢記憶體: 0.028 MB 記憶體於查詢: 3.154 MB 前 回傳的列: 65
    SELECT folder AS type, element AS name, params
    
      FROM dt_extensions
      WHERE enabled = 1
      AND type ='plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_extensionsrefextensionextension62const87Using index condition; Using where; 使用filesort
    側寫
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result0.33 ms
    Sending data0.13 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    8JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    7JDatabaseDriver->loadObjectList()JROOT/libraries/cms/plugin/helper.php:310
    6JPluginHelper::load()JROOT/libraries/cms/plugin/helper.php:86
    5JPluginHelper::getPlugin()JROOT/libraries/cms/plugin/helper.php:128
    4JPluginHelper::isEnabled()JROOT/libraries/cms/application/site.php:599
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  9. 查詢時間: 0.34 ms 最後的查詢: 0.87 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 3.214 MB 前 回傳的列: 2
    SELECT *
    
      FROM dt_languages
      WHERE published=1
      ORDER BY ordering ASC
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_languagesALLNULLNO INDEX KEY COULD BE USEDNULLNULL2Using where; 使用filesort
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.02 ms
    executing0.01 ms
    Sorting result0.03 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:164
    5JLanguageHelper::getLanguages()JROOT/libraries/joomla/language/helper.php:85
    4JLanguageHelper::detectLanguage()JROOT/libraries/cms/application/site.php:648
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  10. 查詢時間: 0.38 ms 最後的查詢: 33.60 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 4.548 MB 前 回傳的列: 2
    SELECT element
    
      FROM dt_extensions
      WHERE type = 'language'
      AND client_id = 0
      AND enabled = 1
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_extensionsrefextensionextension62const4Using index condition; Using where
    側寫
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/multilang.php:90
    8JLanguageMultilang::getSiteLangs()JROOT/plugins/system/languagefilter/languagefilter.php:108
    7PlgSystemLanguageFilter->__construct()JROOT/libraries/cms/plugin/helper.php:255
    6JPluginHelper::import()JROOT/libraries/cms/plugin/helper.php:170
    5JPluginHelper::importPlugin()JROOT/libraries/cms/application/cms.php:669
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:681
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  11. 查詢時間: 0.88 ms 最後的查詢: 6.43 ms 之後 查詢記憶體: 0.053 MB 記憶體於查詢: 4.961 MB 前 回傳的列: 34
    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM dt_menu AS m
      LEFT JOIN dt_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const41Using index condition; Using where; 使用filesort
    1SIMPLEeeq_refPRIMARYPRIMARY4tecstar_jm8.m.component_id1Using where
    側寫
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result0.17 ms
    Sending data0.28 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    19JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:86
    18JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    17JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    16JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:145
    15JMenu::getInstance()JROOT/libraries/cms/application/cms.php:439
    14JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    13JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:57
    12JRouterSite->__construct()JROOT/libraries/cms/router/router.php:197
    11JRouter::getInstance()JROOT/libraries/cms/application/cms.php:535
    10JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:407
    9JApplicationSite::getRouter()JROOT/plugins/system/languagefilter/languagefilter.php:130
    8PlgSystemLanguageFilter->onAfterInitialise()JROOT/libraries/joomla/event/event.php:69
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    6JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    5JApplicationBase->triggerEvent()JROOT/libraries/cms/application/cms.php:670
    4JApplicationCms->initialiseApp()JROOT/libraries/cms/application/site.php:681
    3JApplicationSite->initialiseApp()JROOT/libraries/cms/application/site.php:209
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  12. 查詢時間: 0.66 ms 最後的查詢: 13.67 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 6.016 MB 前 回傳的列: 2
    SHOW FULL COLUMNS 
      FROM `dt_komento_configs`
    說明
    EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `dt_komento_configs`
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    Opening tables0.24 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Filling schema table0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.09 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    16JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    15JTable->__construct()JROOT/administrator/components/com_komento/tables/parent.php:18
    14KomentoParentTable->__construct()JROOT/administrator/components/com_komento/tables/configs.php:40
    13KomentoTableConfigs->__construct()JROOT/libraries/joomla/table/table.php:308
    12JTable::getInstance()JROOT/administrator/components/com_komento/tables/parent.php:49
    11KomentoParentTable::getInstance()JROOT/components/com_komento/helpers/helper.php:99
    10Komento::getTable()JROOT/components/com_komento/helpers/helper.php:228
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/cms/router/site.php:738
    6JRouterSite->getComponentRouter()JROOT/libraries/cms/router/site.php:123
    5JRouterSite->parse()JROOT/libraries/cms/application/cms.php:1116
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  13. 查詢時間: 0.24 ms 最後的查詢: 1.08 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 6.045 MB 前 回傳的列: 1
    SELECT *
    
      FROM dt_komento_configs
      WHERE `component` = 'com_komento'
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_komento_configsALLNULLNO INDEX KEY COULD BE USEDNULLNULL5Using where
    側寫
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    11JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:719
    10JTable->load()JROOT/components/com_komento/helpers/helper.php:229
    9Komento::getKonfig()JROOT/components/com_komento/bootstrap.php:30
    8require_once JROOT/components/com_komento/bootstrap.phpJROOT/components/com_komento/router.php:16
    7require_once JROOT/components/com_komento/router.phpJROOT/libraries/cms/router/site.php:738
    6JRouterSite->getComponentRouter()JROOT/libraries/cms/router/site.php:123
    5JRouterSite->parse()JROOT/libraries/cms/application/cms.php:1116
    4JApplicationCms->route()JROOT/libraries/cms/application/site.php:791
    3JApplicationSite->route()JROOT/libraries/cms/application/site.php:215
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  14. 查詢時間: 0.57 ms 最後的查詢: 11.63 ms 之後 查詢記憶體: 0.024 MB 記憶體於查詢: 6.520 MB 前 回傳的列: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `dt_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_extensionsrefelement_clientid,element_folder_clientid,extensionextension364const,const1Using index condition
    側寫
    StatusDuration
    starting0.04 ms
    checking permissions0.03 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.23 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    12JDatabaseDriver->loadObject()JROOT/libraries/joomla/cache/controller/callback.php:152
    11JCacheControllerCallback->get()JROOT/libraries/cms/library/helper.php:156
    10JLibraryHelper::_load()JROOT/libraries/cms/library/helper.php:47
    9JLibraryHelper::getLibrary()JROOT/libraries/cms/library/helper.php:90
    8JLibraryHelper::getParams()JROOT/libraries/cms/version/version.php:274
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  15. 查詢時間: 1.10 ms 最後的查詢: 0.15 ms 之後 查詢記憶體: 0.005 MB 記憶體於查詢: 6.510 MB 前
    UPDATE `dt_extensions`
    
      SET `params` = '{\"mediaversion\":\"fd2d769277776e181398ffadb8cdea00\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    說明
    EXPLAIN 無法被使用於查詢: UPDATE `dt_extensions` SET `params` = '{\"mediaversion\":\"fd2d769277776e181398ffadb8cdea00\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.00 ms
    init0.05 ms
    updating0.05 ms
    end0.01 ms
    query end0.82 ms
    closing tables0.02 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    10JDatabaseDriverMysqli->execute()JROOT/libraries/cms/library/helper.php:119
    9JLibraryHelper::saveParams()JROOT/libraries/cms/version/version.php:325
    8JVersion->setMediaVersion()JROOT/libraries/cms/version/version.php:284
    7JVersion->getMediaVersion()JROOT/libraries/joomla/factory.php:755
    6JFactory::createDocument()JROOT/libraries/joomla/factory.php:216
    5JFactory::getDocument()JROOT/libraries/joomla/application/web.php:977
    4JApplicationWeb->loadDocument()JROOT/libraries/cms/application/site.php:130
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  16. 查詢時間: 1.11 ms 最後的查詢: 2.44 ms 之後 查詢記憶體: 0.021 MB 記憶體於查詢: 6.664 MB 前 回傳的列: 4
    SELECT id, home, template, s.params
    
      FROM dt_template_styles as s
      LEFT JOIN dt_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
      WHERE s.client_id = 0
      AND e.enabled = 1
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsALLidx_templateNO INDEX KEY COULD BE USEDNULLNULL6Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid303tecstar_jm8.s.template,const1Using index condition; Using where
    側寫
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.47 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.28 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    5JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:484
    4JApplicationSite->getTemplate()JROOT/libraries/cms/application/site.php:165
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  17. 查詢時間: 1.79 ms 最後的查詢: 10.30 ms 之後 查詢記憶體: 0.032 MB 記憶體於查詢: 7.349 MB 前 回傳的列: 8
    SHOW FULL COLUMNS 
      FROM `dt_assets`
    說明
    EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `dt_assets`
    側寫
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    Opening tables0.30 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.01 ms
    optimizing0.02 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Filling schema table0.01 ms
    Opening tables0.87 ms
    After opening tables0.03 ms
    checking permissions0.04 ms
    checking permissions0.03 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    closing tables0.01 ms
    executing0.01 ms
    Sending data0.05 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.09 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    23JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:440
    22JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/joomla/table/table.php:241
    21JTable->getFields()JROOT/libraries/joomla/table/table.php:162
    20JTable->__construct()JROOT/libraries/joomla/table/asset.php:60
    19JTableAsset->__construct()JROOT/libraries/joomla/table/table.php:308
    18JTable::getInstance()JROOT/libraries/joomla/access/access.php:696
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  18. 查詢時間: 0.53 ms 最後的查詢: 0.15 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 7.377 MB 前 回傳的列: 1
    SELECT *
    
      FROM dt_assets
      WHERE `id` = '1'
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_assetsconstPRIMARYPRIMARY4const1
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.27 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    19JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/table/table.php:719
    18JTable->load()JROOT/libraries/joomla/access/access.php:697
    17JAccess::getExtensionNameFromAsset()JROOT/libraries/joomla/access/access.php:555
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  19. 查詢時間: 0.38 ms 最後的查詢: 0.09 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 7.384 MB 前 回傳的列: 1
    SELECT a.rules
    
      FROM dt_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaindex_mergePRIMARY,idx_asset_namePRIMARY,idx_asset_name4,152NULL2Using union(PRIMARY,idx_asset_name); Using where
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.14 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    17JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:652
    16JAccess::getAssetRules()JROOT/libraries/joomla/user/user.php:385
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  20. 查詢時間: 0.34 ms 最後的查詢: 0.95 ms 之後 查詢記憶體: 0.028 MB 記憶體於查詢: 7.412 MB 前 回傳的列: 35
    SELECT element
    
      FROM dt_extensions
      WHERE type = 'component'
      AND enabled = '1'
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_extensionsrefextensionextension62const35Using index condition; Using where
    側寫
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.12 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    19JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:413
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  21. 查詢時間: 0.85 ms 最後的查詢: 0.08 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 7.427 MB 前 回傳的列: 35
    SELECT a.name, a.rules
    
      FROM dt_assets AS a
      WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomdownloads','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaALLidx_asset_nameNO INDEX KEY COULD BE USEDNULLNULL211Using where
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.05 ms
    optimizing0.01 ms
    statistics0.12 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.48 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    19JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:441
    18JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    17JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    16JAccess::check()JROOT/libraries/joomla/user/user.php:394
    15JUser->authorise()JROOT/components/com_content/models/articles.php:112
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:42
    13ContentModelFeatured->populateState()JROOT/libraries/legacy/model/legacy.php:435
    12JModelLegacy->getState()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:54
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  22. 查詢時間: 4.61 ms 最後的查詢: 1.22 ms 之後 查詢記憶體: 0.038 MB 記憶體於查詢: 7.657 MB 前 回傳的列: 0
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      ON c.id = a.catid
      LEFT JOIN dt_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dt_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.featured = 1
      AND a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 21:01:27')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 21:01:27')
      AND a.language in ('zh-TW','*')
      ORDER BY c.lft, a.ordering, a.created DESC
      LIMIT 4
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYarefidx_access,idx_catid,idx_featured_catid,idx_languageidx_featured_catid1const2Using where; Using temporary; 使用filesort
    1PRIMARYuaeq_refPRIMARYPRIMARY4tecstar_jm8.a.created_by1Using where
    1PRIMARYuameq_refPRIMARYPRIMARY4tecstar_jm8.a.modified_by1Using where
    1PRIMARYceq_refPRIMARY,idx_accessPRIMARY4tecstar_jm8.a.catid1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4tecstar_jm8.c.parent_id1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4tecstar_jm8.a.id1Using where
    1PRIMARY<derived2>refkey0key05tecstar_jm8.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using index condition; Using temporary; 使用filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL27Using where; Using index; Using join buffer (flat, BNL join)
    側寫
    StatusDuration
    starting0.21 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables1.61 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.02 ms
    init0.12 ms
    optimizing0.01 ms
    optimizing0.03 ms
    statistics0.21 ms
    preparing0.07 ms
    statistics0.42 ms
    preparing0.06 ms
    executing0.01 ms
    Copying to tmp table0.62 ms
    Copying to tmp table0.54 ms
    executing0.01 ms
    Copying to tmp table0.03 ms
    Copying to tmp table0.13 ms
    Sorting result0.01 ms
    Sending data0.02 ms
    removing tmp table0.01 ms
    Sending data0.05 ms
    Sorting result0.04 ms
    Sending data0.03 ms
    end0.01 ms
    removing tmp table0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    15JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    14JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:100
    12ContentModelFeatured->getItems()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  23. 查詢時間: 1.04 ms 最後的查詢: 1.72 ms 之後 查詢記憶體: 0.025 MB 記憶體於查詢: 7.743 MB 前 回傳的列: 1
    SELECT COUNT(*)
    
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      ON c.id = a.catid
      LEFT JOIN dt_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dt_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.featured = 1
      AND a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 21:01:27')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 21:01:27')
      AND a.language in ('zh-TW','*')
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYarefidx_access,idx_catid,idx_featured_catid,idx_languageidx_featured_catid1const2Using where
    1PRIMARYceq_refPRIMARY,idx_accessPRIMARY4tecstar_jm8.a.catid1Using where
    1PRIMARY<derived2>refkey0key05tecstar_jm8.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using index condition; Using temporary; 使用filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL27Using where; Using index; Using join buffer (flat, BNL join)
    側寫
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.06 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.06 ms
    statistics0.11 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.10 ms
    executing0.01 ms
    Copying to tmp table0.02 ms
    Copying to tmp table0.07 ms
    Sorting result0.01 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.03 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    15JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:337
    14JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:278
    13JModelList->getTotal()JROOT/libraries/legacy/model/list.php:228
    12JModelList->getPagination()JROOT/libraries/legacy/view/legacy.php:408
    11JViewLegacy->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/legacy/controller/legacy.php:664
    9JControllerLegacy->display()JROOT/components/com_content/controller.php:113
    8ContentController->display()JROOT/libraries/legacy/controller/legacy.php:702
    7JControllerLegacy->execute()JROOT/components/com_content/content.php:38
    6require_once JROOT/components/com_content/content.phpJROOT/libraries/cms/component/helper.php:405
    5JComponentHelper::executeComponent()JROOT/libraries/cms/component/helper.php:380
    4JComponentHelper::renderComponent()JROOT/libraries/cms/application/site.php:191
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  24. 查詢時間: 0.69 ms 最後的查詢: 8.21 ms 之後 查詢記憶體: 0.022 MB 記憶體於查詢: 7.965 MB 前 回傳的列: 3
    SELECT language,id
    
      FROM `dt_menu`
      WHERE home = 1
      AND published = 1
      AND client_id = 0
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_menurefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const42Using where
    側寫
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.23 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/multilang.php:121
    8JLanguageMultilang::getSiteHomePages()JROOT/plugins/system/languagefilter/languagefilter.php:697
    7PlgSystemLanguageFilter->onAfterDispatch()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/site.php:196
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  25. 查詢時間: 1.02 ms 最後的查詢: 1.29 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 8.013 MB 前 回傳的列: 0
    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `dt_menu` AS `c`
      INNER JOIN `dt_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `dt_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `dt_menu` AS `c2`
      ON a2.id = c2.`id`
      WHERE c.id = 102
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE noticed after reading const tables
    側寫
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.55 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.21 ms
    preparing0.01 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    10JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/associations.php:101
    9JLanguageAssociations::getAssociations()JROOT/administrator/components/com_menus/helpers/menus.php:284
    8MenusHelper::getAssociations()JROOT/plugins/system/languagefilter/languagefilter.php:714
    7PlgSystemLanguageFilter->onAfterDispatch()JROOT/libraries/joomla/event/event.php:69
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:159
    5JEventDispatcher->trigger()JROOT/libraries/joomla/application/base.php:106
    4JApplicationBase->triggerEvent()JROOT/libraries/cms/application/site.php:196
    3JApplicationSite->dispatch()JROOT/libraries/cms/application/site.php:230
    2JApplicationSite->doExecute()JROOT/libraries/cms/application/cms.php:261
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  26. 查詢時間: 0.41 ms 最後的查詢: 7.76 ms 之後 查詢記憶體: 0.023 MB 記憶體於查詢: 8.548 MB 前 回傳的列: 1
    SELECT template 
      FROM dt_template_styles
      WHERE client_id = 1
      AND home = 1
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_template_stylesALLidx_homeNO INDEX KEY COULD BE USEDNULLNULL6Using where
    側寫
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.03 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    9JDatabaseDriver->loadResult()JROOT/templates/theme2062/includes/includes.php:21
    8include_once JROOT/templates/theme2062/includes/includes.phpJROOT/templates/theme2062/index.php:4
    7require JROOT/templates/theme2062/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:640
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1072
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  27. 查詢時間: 2.52 ms 最後的查詢: 1.35 ms 之後 查詢記憶體: 0.029 MB 記憶體於查詢: 8.644 MB 前 回傳的列: 13
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM dt_modules AS m
      LEFT JOIN dt_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN dt_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-12-09 21:01:27')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-09 21:01:27')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 102 OR mm.menuid <= 0)
      AND m.language IN ('zh-TW','*')
      ORDER BY m.position, m.ordering
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeeds,idx_languagepublished1const27Using index condition; Using where; 使用filesort
    1SIMPLEmmrefPRIMARYPRIMARY4tecstar_jm8.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid303tecstar_jm8.m.module,const1Using index condition; Using where
    側寫
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.76 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.06 ms
    optimizing0.03 ms
    statistics0.30 ms
    preparing0.05 ms
    executing0.01 ms
    Sorting result0.59 ms
    Sending data0.43 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    14JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/cache/controller/callback.php:152
    13JCacheControllerCallback->get()JROOT/libraries/cms/module/helper.php:425
    12JModuleHelper::getModuleList()JROOT/libraries/cms/module/helper.php:361
    11JModuleHelper::load()JROOT/libraries/cms/module/helper.php:84
    10JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    9JDocumentHtml->countModules()JROOT/templates/theme2062/includes/includes.php:81
    8include_once JROOT/templates/theme2062/includes/includes.phpJROOT/templates/theme2062/index.php:4
    7require JROOT/templates/theme2062/index.phpJROOT/libraries/joomla/document/html.php:578
    6JDocumentHtml->_loadTemplate()JROOT/libraries/joomla/document/html.php:640
    5JDocumentHtml->_fetchTemplate()JROOT/libraries/joomla/document/html.php:455
    4JDocumentHtml->parse()JROOT/libraries/cms/application/cms.php:1072
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  28. 查詢時間: 1.27 ms 最後的查詢: 13.57 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 8.866 MB 前 回傳的列: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      on c.id = a.catid
      LEFT JOIN dt_users AS u
      on u.id = a.created_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 40
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 21:01:27')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 21:01:27')
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYaconstPRIMARYPRIMARY4const1
    1PRIMARYcconstPRIMARYPRIMARY4const1
    1PRIMARYuconstPRIMARYPRIMARY4const1
    1PRIMARYparentconstPRIMARYPRIMARY4const1
    1PRIMARYvconstPRIMARYPRIMARY4const0unique row not found
    1PRIMARY<derived2>refkey0key05const2Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL1Using index condition; Using temporary; 使用filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL27Using where; Using index; Using join buffer (flat, BNL join)
    側寫
    StatusDuration
    starting0.16 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.10 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.07 ms
    statistics0.26 ms
    preparing0.04 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.00 ms
    Copying to tmp table0.03 ms
    Copying to tmp table0.09 ms
    Sorting result0.03 ms
    Sending data0.02 ms
    removing tmp table0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    updating status0.03 ms
    cleaning up0.03 ms
    呼叫堆疊
    #Caller檔案與行號
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:159
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  29. 查詢時間: 2.13 ms 最後的查詢: 1.70 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 8.962 MB 前 回傳的列: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM dt_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN dt_categories AS s
      ON (s.lft < c.lft
      AND s.rgt > c.rgt
      AND c.language in ('zh-TW','*')) OR (s.lft >= c.lft
      AND s.rgt <= c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=24
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; 使用filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_right,idx_languageNO INDEX KEY COULD BE USEDNULLNULL27Using where
    1PRIMARY<derived2>refkey0key05tecstar_jm8.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using index condition; Using temporary; 使用filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL27Using where; Using index; Using join buffer (flat, BNL join)
    側寫
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.02 ms
    System lock0.02 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.11 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.07 ms
    statistics0.30 ms
    preparing0.06 ms
    executing0.01 ms
    Copying to tmp table0.41 ms
    Copying to tmp table0.08 ms
    executing0.01 ms
    Copying to tmp table0.02 ms
    Copying to tmp table0.11 ms
    Sorting result0.01 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.14 ms
    Sorting result0.03 ms
    Sending data0.06 ms
    end0.01 ms
    removing tmp table0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    14JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    13JCategories->get()JROOT/components/com_content/helpers/route.php:44
    12ContentHelperRoute::getArticleRoute()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  30. 查詢時間: 0.24 ms 最後的查詢: 0.32 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 8.976 MB 前 回傳的列: 1
    SELECT alias
    
      FROM dt_content
      WHERE id=40
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_contentconstPRIMARYPRIMARY4const1
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    18JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:118
    17ContentRouter->build()JROOT/libraries/cms/router/site.php:496
    16JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:465
    15JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:281
    14JRouter->build()JROOT/libraries/cms/router/site.php:147
    13JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    12JRoute::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  31. 查詢時間: 0.78 ms 最後的查詢: 28.08 ms 之後 查詢記憶體: 0.030 MB 記憶體於查詢: 10.604 MB 前 回傳的列: 75
    SELECT * 
      FROM dt_acymailing_config
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_acymailing_configALLNULLNO INDEX KEY COULD BE USEDNULLNULL75
    側寫
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.39 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    14JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    13cpanelClass->load()JROOT/administrator/components/com_acymailing/helpers/helper.php:343
    12acymailing_config()JROOT/administrator/components/com_acymailing/helpers/helper.php:739
    11include_once JROOT/administrator/components/com_acymailing/helpers/helper.phpJROOT/modules/mod_acymailing/mod_acymailing.php:12
    10include JROOT/modules/mod_acymailing/mod_acymailing.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  32. 查詢時間: 0.67 ms 最後的查詢: 3.98 ms 之後 查詢記憶體: 0.028 MB 記憶體於查詢: 10.884 MB 前 回傳的列: 1
    SELECT * 
      FROM dt_acymailing_list
      WHERE type = 'list'
      ORDER BY ordering ASC
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_acymailing_listsystemtypeorderingindex,typeuseridindexNO INDEX KEY COULD BE USEDNULLNULL1
    側寫
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.35 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.03 ms
    optimizing0.03 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.02 ms
    呼叫堆疊
    #Caller檔案與行號
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_acymailing/classes/list.php:29
    11listClass->getLists()JROOT/modules/mod_acymailing/mod_acymailing.php:117
    10include JROOT/modules/mod_acymailing/mod_acymailing.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  33. 查詢時間: 1.89 ms 最後的查詢: 2.58 ms 之後 查詢記憶體: 0.052 MB 記憶體於查詢: 10.906 MB 前 回傳的列: 3
    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      ON c.id = a.catid
      LEFT JOIN dt_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dt_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id ) AS badcats
      ON badcats.id = c.id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid IN (8)
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 21:01:27')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 21:01:27')
      AND a.language in ('zh-TW','*')
      ORDER BY a.ordering ASC
      LIMIT 3
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYcconstPRIMARY,idx_accessPRIMARY4const1使用filesort
    1PRIMARYarefidx_access,idx_catid,idx_languageidx_catid4const19Using where
    1PRIMARYuaeq_refPRIMARYPRIMARY4tecstar_jm8.a.created_by1Using where
    1PRIMARYparenteq_refPRIMARYPRIMARY4const1Using where
    1PRIMARYveq_refPRIMARYPRIMARY4tecstar_jm8.a.id1Using where
    1PRIMARY<derived2>refkey0key05const5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using index condition; Using temporary; 使用filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL27Using where; Using index; Using join buffer (flat, BNL join)
    側寫
    StatusDuration
    starting0.16 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.03 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.10 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.08 ms
    preparing0.06 ms
    statistics0.19 ms
    preparing0.05 ms
    executing0.01 ms
    Sorting result0.58 ms
    Sending data0.12 ms
    executing0.01 ms
    Copying to tmp table0.02 ms
    Copying to tmp table0.08 ms
    Sorting result0.01 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    14JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    12ContentModelArticles->getItems()JROOT/modules/mod_caroufredsel/helper.php:67
    11modCarouFredSelHelper::getList()JROOT/modules/mod_caroufredsel/mod_caroufredsel.php:46
    10include JROOT/modules/mod_caroufredsel/mod_caroufredsel.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  34. 查詢時間: 1.64 ms 最後的查詢: 0.46 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 11.013 MB 前 回傳的列: 2
    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM dt_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      LEFT JOIN dt_categories AS s
      ON (s.lft < c.lft
      AND s.rgt > c.rgt
      AND c.language in ('zh-TW','*')) OR (s.lft >= c.lft
      AND s.rgt <= c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=8
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
      ORDER BY c.lft
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYsconstPRIMARY,idx_left_rightPRIMARY4const1Using temporary; 使用filesort
    1PRIMARYcALLcat_idx,idx_access,idx_left_right,idx_languageNO INDEX KEY COULD BE USEDNULLNULL27Using where
    1PRIMARY<derived2>refkey0key05tecstar_jm8.c.id5Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL2Using index condition; Using temporary; 使用filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL27Using where; Using index; Using join buffer (flat, BNL join)
    側寫
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.02 ms
    init0.10 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.05 ms
    statistics0.13 ms
    preparing0.04 ms
    executing0.01 ms
    Copying to tmp table0.41 ms
    Copying to tmp table0.03 ms
    executing0.01 ms
    Copying to tmp table0.02 ms
    Copying to tmp table0.07 ms
    Sorting result0.01 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.14 ms
    Sorting result0.03 ms
    Sending data0.06 ms
    end0.01 ms
    removing tmp table0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    14JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    13JCategories->get()JROOT/components/com_content/helpers/route.php:44
    12ContentHelperRoute::getArticleRoute()JROOT/modules/mod_caroufredsel/helper.php:77
    11modCarouFredSelHelper::getList()JROOT/modules/mod_caroufredsel/mod_caroufredsel.php:46
    10include JROOT/modules/mod_caroufredsel/mod_caroufredsel.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  35. 查詢時間: 0.91 ms 最後的查詢: 5.92 ms 之後 查詢記憶體: 0.036 MB 記憶體於查詢: 10.977 MB 前 回傳的列: 1
    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      on c.id = a.catid
      LEFT JOIN dt_users AS u
      on u.id = a.created_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 41
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 21:01:27')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 21:01:27')
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYaconstPRIMARYPRIMARY4const1
    1PRIMARYcconstPRIMARYPRIMARY4const1
    1PRIMARYuconstPRIMARYPRIMARY4const1
    1PRIMARYparentconstPRIMARYPRIMARY4const1
    1PRIMARYvconstPRIMARYPRIMARY4const0unique row not found
    1PRIMARY<derived2>refkey0key05const2Using where
    2DERIVEDparentrangecat_idx,idx_left_rightcat_idx153NULL1Using index condition; Using temporary; 使用filesort
    2DERIVEDcatindexidx_left_rightidx_left_right8NULL27Using where; Using index; Using join buffer (flat, BNL join)
    側寫
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.04 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.07 ms
    optimizing0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.05 ms
    statistics0.11 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    executing0.00 ms
    Copying to tmp table0.02 ms
    Copying to tmp table0.06 ms
    Sorting result0.01 ms
    Sending data0.01 ms
    removing tmp table0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    removing tmp table0.01 ms
    closing tables0.02 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    13JDatabaseDriver->loadObject()JROOT/components/com_content/models/article.php:159
    12ContentModelArticle->getItem()JROOT/modules/mod_articles_single/helper.php:26
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  36. 查詢時間: 0.25 ms 最後的查詢: 0.26 ms 之後 查詢記憶體: 0.026 MB 記憶體於查詢: 11.007 MB 前 回傳的列: 1
    SELECT alias
    
      FROM dt_content
      WHERE id=41
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEdt_contentconstPRIMARYPRIMARY4const1
    側寫
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    18JDatabaseDriver->loadResult()JROOT/components/com_content/router.php:118
    17ContentRouter->build()JROOT/libraries/cms/router/site.php:496
    16JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:465
    15JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:281
    14JRouter->build()JROOT/libraries/cms/router/site.php:147
    13JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    12JRoute::_()JROOT/modules/mod_articles_single/helper.php:30
    11modArticlesSingleHelper::getItem()JROOT/modules/mod_articles_single/mod_articles_single.php:13
    10include JROOT/modules/mod_articles_single/mod_articles_single.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  37. 查詢時間: 0.83 ms 最後的查詢: 3.01 ms 之後 查詢記憶體: 0.035 MB 記憶體於查詢: 11.036 MB 前 回傳的列: 0
    SELECT *
    
      FROM dt_banners
      WHERE '2023-12-09 21:01:27' >= 'reset'
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!= NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLNO INDEX KEY COULD BE USEDNULLNULLNULLImpossible WHERE
    側寫
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.56 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.03 ms
    optimizing0.02 ms
    executing0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.03 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    12JDatabaseDriver->loadObjectList()JROOT/administrator/components/com_banners/helpers/banners.php:79
    11BannersHelper::updateReset()JROOT/modules/mod_banners/mod_banners.php:19
    10include JROOT/modules/mod_banners/mod_banners.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  38. 查詢時間: 1.46 ms 最後的查詢: 1.26 ms 之後 查詢記憶體: 0.028 MB 記憶體於查詢: 11.091 MB 前 回傳的列: 3
    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM dt_banners as a
      LEFT JOIN dt_banner_clients AS cl
      ON cl.id = a.cid
      WHERE a.state=1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-09 21:01:27')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-09 21:01:27')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.catid IN (3)
      AND a.language in ('zh-TW','*')
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 5
    說明
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_banner_catid,idx_languageidx_state1const3Using where; 使用filesort
    1SIMPLEcleq_refPRIMARYPRIMARY4tecstar_jm8.a.cid1
    側寫
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.40 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.00 ms
    After opening tables0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.36 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result0.18 ms
    Sending data0.21 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.02 ms
    呼叫堆疊
    #Caller檔案與行號
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    14JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    13JModelList->getItems()JROOT/components/com_banners/models/banners.php:205
    12BannersModelBanners->getItems()JROOT/modules/mod_banners/helper.php:44
    11ModBannersHelper::getList()JROOT/modules/mod_banners/mod_banners.php:20
    10include JROOT/modules/mod_banners/mod_banners.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

  39. 查詢時間: 1.08 ms 最後的查詢: 0.12 ms 之後 查詢記憶體: 0.006 MB 記憶體於查詢: 11.108 MB 前
    UPDATE dt_banners
    
      SET impmade = (impmade + 1)
      WHERE id IN (2,5,6)
    說明
    EXPLAIN 無法被使用於查詢: UPDATE dt_banners SET impmade = (impmade + 1) WHERE id IN (2,5,6)
    側寫
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.01 ms
    Table lock0.01 ms
    After opening tables0.01 ms
    init0.07 ms
    updating0.11 ms
    end0.01 ms
    query end0.71 ms
    closing tables0.02 ms
    freeing items0.01 ms
    updating status0.02 ms
    cleaning up0.01 ms
    呼叫堆疊
    #Caller檔案與行號
    13JDatabaseDriverMysqli->execute()JROOT/components/com_banners/models/banners.php:246
    12BannersModelBanners->impress()JROOT/modules/mod_banners/helper.php:48
    11ModBannersHelper::getList()JROOT/modules/mod_banners/mod_banners.php:20
    10include JROOT/modules/mod_banners/mod_banners.phpJROOT/libraries/cms/module/helper.php:199
    9JModuleHelper::renderModule()JROOT/libraries/joomla/document/renderer/html/module.php:93
    8JDocumentRendererHtmlModule->render()JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7JDocumentRendererHtmlModules->render()JROOT/libraries/joomla/document/html.php:411
    6JDocumentHtml->getBuffer()JROOT/libraries/joomla/document/html.php:702
    5JDocumentHtml->_renderTemplate()JROOT/libraries/joomla/document/html.php:477
    4JDocumentHtml->render()JROOT/libraries/cms/application/cms.php:1086
    3JApplicationCms->render()JROOT/libraries/cms/application/site.php:773
    2JApplicationSite->render()JROOT/libraries/cms/application/cms.php:267
    1JApplicationCms->execute()JROOT/index.php:49
    [加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結]

34 查詢種類已記錄,由呈現記錄儲存。

選擇表格:
  1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `dt_extensions`
  2. 2 × SELECT element 
      FROM dt_extensions
  3. 2 × SELECT alias 
      FROM dt_content
  4. 2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
        c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
        c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
        c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM dt_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  5. 2 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      on c.id = a.catid
      LEFT JOIN dt_users AS u
      on u.id = a.created_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  6. 1 × SELECT `data` 
      FROM `dt_session`
  7. 1 × SELECT language,id 
      FROM `dt_menu`
  8. 1 × SELECT * 
      FROM dt_banners
  9. 1 × SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      ON c.id = a.catid
      LEFT JOIN dt_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dt_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  10. 1 × SELECT * 
      FROM dt_acymailing_list
  11. 1 × SELECT * 
      FROM dt_acymailing_confi
  12. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM dt_modules AS m
      LEFT JOIN dt_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN dt_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  13. 1 × SELECT template 
      FROM dt_template_styles
  14. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `dt_menu` AS `c`
      INNER JOIN `dt_associations` AS `a`
      ON a.id = c.`id`
      AND a.context='com_menus.item'
      INNER JOIN `dt_associations` AS `a2`
      ON a.key = a2.key
      INNER JOIN `dt_menu` AS `c2`
      ON a2.id = c2.`id`
  15. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      ON c.id = a.catid
      LEFT JOIN dt_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dt_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  16. 1 × SELECT COUNT(*) 
      FROM dt_content AS a
      LEFT JOIN dt_categories AS c
      ON c.id = a.catid
      LEFT JOIN dt_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN dt_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN dt_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN dt_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM dt_categories AS cat JOIN dt_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  17. 1 × SELECT `session_id` 
      FROM `dt_session`
  18. 1 × SELECT a.name, a.rules 
      FROM dt_assets AS a
  19. 1 × SELECT a.rules 
      FROM dt_assets AS a
  20. 1 × SELECT * 
      FROM dt_assets
  21. 1 × SELECT id, home, template, s.params 
      FROM dt_template_styles as s
      LEFT JOIN dt_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  22. 1 × SELECT * 
      FROM dt_komento_configs
  23. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
      FROM dt_menu AS m
      LEFT JOIN dt_extensions AS e
      ON m.component_id = e.extension_id
  24. 1 × SELECT * 
      FROM dt_languages
  25. 1 × SELECT folder AS type, element AS name, params 
      FROM dt_extensions
  26. 1 × SELECT id, rules 
      FROM `dt_viewlevels
  27. 1 × SELECT b.id 
      FROM dt_usergroups AS a
      LEFT JOIN dt_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  28. 1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
      FROM dt_banners as a
      LEFT JOIN dt_banner_clients AS cl
      ON cl.id = a.cid
其他表格:
  1. 1 × DELETE  
      FROM `dt_session`
  2. 1 × INSERT INTO `dt_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('rhtg3srj3h0d0q78c9aa6ur6eu', 0, 1, '1702155687', 0, ''
  3. 1 × SHOW FULL COLUMNS 
      FROM `dt_komento_configs
  4. 1 × UPDATE `dt_extensions` 
      SET `params` = '{\"mediaversion\":\"fd2d769277776e181398ffadb8cdea00\"}'
  5. 1 × SHOW FULL COLUMNS 
      FROM `dt_assets
  6. 1 × UPDATE dt_banners 
      SET impmade = (impmade + 1)