博智全球 博智全球
  • 首頁
  • BOSS消息
  • BOSS服務
    • BOSS訓練中心
    • BOSS神秘客專案
    • BOSS輔導
    • BOSS講師
  • BOSS介紹
    • BOSS組織
    • BOSS遠景
  • BOSS聯絡
  • BOSS園地
    • BOSS臉書專頁
    • BOSS論壇

 

 

 

全站檢索

輸入查詢詞

BOSS園地

**詳細內容**
**in BOSS園地**
**點擊數: 535**
  •  **列印** 
  • **Email**

我們提供互動討論的園地

歡迎您提供與眾不同的想法

盼大家多站在多方角度,細細思考。

 


Powered by T3 Framework
**Close**
**Previous** **Next**
**Loading...**
**Loading...**
**Loading...**

**Joomla! 除錯主控台**

**連線階段 (Session)**

{"__default":{"session":{"counter":1,"timer":{"start":1614648408,"last":1614648408,"now":1614648408}},"registry":{"separator":"."},"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},"com_mailto":{"links":{"a54b06b1fa963caa83dfde97692a6897ea341a6a":{"link":"http:\/\/wise-boss.com\/index.php\/boss-6\/153-boss-9","expiry":1614648408}}}}}

**側寫資訊**

**時間**

**記憶體**

**時間**: 8.26 ms / 8.26 ms **記憶體**: 1.174 MB / 1.77 MB Application: afterLoad
**時間**: 87.00 ms / 95.26 ms **記憶體**: 9.207 MB / 10.98 MB Application: afterInitialise
**時間**: 29.89 ms / 125.14 ms **記憶體**: 4.360 MB / 15.34 MB Application: afterRoute
**時間**: 6.46 ms / 131.60 ms **記憶體**: 0.530 MB / 15.87 MB Application: beforeRenderComponent com_content
**時間**: 10.44 ms / 142.05 ms **記憶體**: 1.684 MB / 17.55 MB Application: Start JAccess::getAssetRules Old (1)
**時間**: 0.94 ms / 142.99 ms **記憶體**: 0.086 MB / 17.64 MB Application: Finish JAccess::getAssetRules Old (1)
**時間**: 0.06 ms / 143.04 ms **記憶體**: 0.000 MB / 17.63 MB Application: New JAccess Preloading Process(com_content.category)
**時間**: 1.18 ms / 144.22 ms **記憶體**: 0.171 MB / 17.80 MB Application: After preloadPermissionsParentIdMapping (com_content.category)
**時間**: 2.05 ms / 146.28 ms **記憶體**: 0.339 MB / 18.14 MB Application: After preloadPermissions (com_content.category)
**時間**: 0.02 ms / 146.30 ms **記憶體**: 0.002 MB / 18.14 MB Application: End New JAccess Preloading Process(com_content.category)
**時間**: 0.03 ms / 146.33 ms **記憶體**: 0.002 MB / 18.14 MB Application: Start JAccess::getAssetRules New (com_content.category.99)
**時間**: 0.14 ms / 146.46 ms **記憶體**: 0.012 MB / 18.15 MB Application: Finish JAccess::getAssetRules New (com_content.category.99)
**時間**: 6.00 ms / 152.46 ms **記憶體**: 0.517 MB / 18.67 MB Application: Start JAccess::preload(components)
**時間**: 3.72 ms / 156.18 ms **記憶體**: 0.367 MB / 19.04 MB Application: Finish JAccess::preload(components)
**時間**: 39.77 ms / 195.95 ms **記憶體**: 2.552 MB / 21.59 MB Application: afterRenderComponent com_content
**時間**: 0.42 ms / 196.37 ms **記憶體**: 0.005 MB / 21.59 MB Application: afterDispatch
**時間**: 10.10 ms / 206.47 ms **記憶體**: 0.801 MB / 22.39 MB Application: beforeRenderModule mod_custom (全站檢索)
**時間**: 1.62 ms / 208.09 ms **記憶體**: 0.119 MB / 22.51 MB Application: afterRenderModule mod_custom (全站檢索)
**時間**: 0.07 ms / 208.16 ms **記憶體**: 0.000 MB / 22.51 MB Application: beforeRenderModule mod_search (Search)
**時間**: 1.76 ms / 209.92 ms **記憶體**: 0.040 MB / 22.55 MB Application: afterRenderModule mod_search (Search)
**時間**: 0.13 ms / 210.05 ms **記憶體**: 0.000 MB / 22.54 MB Application: beforeRenderModule mod_languages (Language Switcher)
**時間**: 2.47 ms / 212.51 ms **記憶體**: 0.106 MB / 22.65 MB Application: afterRenderModule mod_languages (Language Switcher)
**時間**: 0.13 ms / 212.64 ms **記憶體**: 0.000 MB / 22.64 MB Application: beforeRenderModule mod_menu (Useful Links)
**時間**: 1.57 ms / 214.22 ms **記憶體**: 0.079 MB / 22.72 MB Application: afterRenderModule mod_menu (Useful Links)
**時間**: 0.12 ms / 214.33 ms **記憶體**: 0.000 MB / 22.72 MB Application: beforeRenderModule mod_menu (JA Fixel's Colors)
**時間**: 0.43 ms / 214.76 ms **記憶體**: 0.008 MB / 22.73 MB Application: afterRenderModule mod_menu (JA Fixel's Colors)
**時間**: 0.09 ms / 214.85 ms **記憶體**: 0.000 MB / 22.72 MB Application: beforeRenderModule mod_menu (Top)
**時間**: 0.39 ms / 215.24 ms **記憶體**: 0.008 MB / 22.73 MB Application: afterRenderModule mod_menu (Top)
**時間**: 0.10 ms / 215.34 ms **記憶體**: 0.000 MB / 22.73 MB Application: beforeRenderModule mod_custom (Social Link)
**時間**: 0.30 ms / 215.64 ms **記憶體**: 0.008 MB / 22.73 MB Application: afterRenderModule mod_custom (Social Link)
**時間**: 28.71 ms / 244.35 ms **記憶體**: 1.582 MB / 24.32 MB Application: afterRender

**資料庫查詢總計: 26.21 ms**

**記憶體使用量**

25.03 MB (26*250*504 **位元組**)

**資料庫查詢**

**29 查詢記錄** 26.21 ms


**2 重覆被找到!**

**2 重覆**: #19  #26
  1. **查詢時間: 0.53 ms** **查詢記憶體: 0.019 MB 記憶體於查詢: 5.085 MB 前** **回傳的列: 0**
    SELECT `data`
    
      FROM `yoj8h_session`
      WHERE `session_id` = 'fji7rh4rrrsd35d9n5qrdgn012'
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_sessionNULLconstPRIMARYPRIMARY766const1100.00NULL
    **側寫**
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.26 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.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. **查詢時間: 0.23 ms** **最後的查詢: 2.42 ms 之後** **查詢記憶體: 0.012 MB 記憶體於查詢: 5.410 MB 前** **回傳的列: 0**
    SELECT `session_id`
    
      FROM `yoj8h_session`
      WHERE `session_id` = 'fji7rh4rrrsd35d9n5qrdgn012'
      LIMIT 1
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_sessionNULLconstPRIMARYPRIMARY766const1100.00Using index
    **側寫**
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.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檔案中來建立檔案的連結**]

  3. **查詢時間: 1.20 ms** **最後的查詢: 0.21 ms 之後** **查詢記憶體: 0.009 MB 記憶體於查詢: 5.425 MB 前**
    INSERT INTO `yoj8h_session`
    (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('fji7rh4rrrsd35d9n5qrdgn012', 0, 1, '1614648408', 0, '')
    **說明**
    **EXPLAIN 無法被使用於查詢: INSERT INTO `yoj8h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('fji7rh4rrrsd35d9n5qrdgn012', 0, 1, '1614648408', 0, '')**
    **側寫**
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    update0.14 ms
    end0.01 ms
    query end0.86 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 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檔案中來建立檔案的連結**]

  4. **查詢時間: 0.98 ms** **最後的查詢: 2.85 ms 之後** **查詢記憶體: 0.018 MB 記憶體於查詢: 5.875 MB 前** **回傳的列: 35**
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `yoj8h_extensions`
      WHERE `type` = 'component'
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_extensionsNULLrefextensionextension82const35100.00NULL
    **側寫**
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.25 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.32 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    9JDatabaseDriver->loadObjectList()**與下面行一樣的呼叫**
    8call_user_func_array()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檔案中來建立檔案的連結**]

  5. **查詢時間: 0.66 ms** **最後的查詢: 2.15 ms 之後** **查詢記憶體: 0.016 MB 記憶體於查詢: 6.168 MB 前** **回傳的列: 1**
    SELECT b.id
    
      FROM yoj8h_usergroups AS a
      LEFT JOIN yoj8h_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL1100.00Using where; Using index
    **側寫**
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.26 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 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檔案中來建立檔案的連結**]

  6. **查詢時間: 0.45 ms** **最後的查詢: 0.87 ms 之後** **查詢記憶體: 0.015 MB 記憶體於查詢: 6.301 MB 前** **回傳的列: 4**
    SELECT id, rules
    
      FROM `yoj8h_viewlevels`
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_viewlevelsNULLALLNULL**NO INDEX KEY COULD BE USED**NULLNULL4100.00NULL
    **側寫**
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.17 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.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檔案中來建立檔案的連結**]

  7. **查詢時間: 1.01 ms** **最後的查詢: 0.21 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 6.320 MB 前** **回傳的列: 55**
    SELECT folder AS type, element AS name, params
    
      FROM yoj8h_extensions
      WHERE enabled = 1
      AND type ='plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_extensionsNULLrefextensionextension82const750.52Using index condition; Using where; **使用filesort**
    **側寫**
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.68 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 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檔案中來建立檔案的連結**]

  8. **查詢時間: 0.40 ms** **最後的查詢: 24.21 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 9.538 MB 前** **回傳的列: 1**
    SELECT `enabled`
    
      FROM `yoj8h_extensions`
      WHERE `element` = 'com_akeeba'
      AND `type` = 'component'
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_extensionsNULLrefelement_clientid,element_folder_clientid,extensionelement_clientid402const110.00Using where
    **側寫**
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.13 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    8JDatabaseDriver->loadResult()JROOT/plugins/system/backuponupdate/backuponupdate.php:50
    7require_once JROOT/plugins/system/backuponupdate/backuponupdate.phpJROOT/libraries/cms/plugin/helper.php:230
    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檔案中來建立檔案的連結**]

  9. **查詢時間: 2.98 ms** **最後的查詢: 30.10 ms 之後** **查詢記憶體: 0.045 MB 記憶體於查詢: 11.370 MB 前** **回傳的列: 130**
    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 yoj8h_menu AS m
      LEFT JOIN yoj8h_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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrangeidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language5NULL17610.00Using index condition; Using where; **使用filesort**
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4vhost13117-3.m.component_id1100.00Using where
    **側寫**
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.36 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index2.07 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    15JDatabaseDriver->loadObjectList()JROOT/libraries/cms/menu/site.php:86
    14JMenuSite->load()JROOT/libraries/cms/menu/menu.php:74
    13JMenu->__construct()JROOT/libraries/cms/menu/site.php:57
    12JMenuSite->__construct()JROOT/libraries/cms/menu/menu.php:145
    11JMenu::getInstance()JROOT/libraries/cms/application/cms.php:439
    10JApplicationCms->getMenu()JROOT/libraries/cms/application/site.php:272
    9JApplicationSite->getMenu()JROOT/libraries/cms/router/site.php:57
    8JRouterSite->__construct()JROOT/libraries/cms/router/router.php:197
    7JRouter::getInstance()JROOT/libraries/cms/application/cms.php:535
    6JApplicationCms::getRouter()JROOT/libraries/cms/application/site.php:407
    5JApplicationSite::getRouter()JROOT/libraries/cms/application/cms.php:1115
    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檔案中來建立檔案的連結**]

  10. **查詢時間: 0.70 ms** **最後的查詢: 17.34 ms 之後** **查詢記憶體: 0.019 MB 記憶體於查詢: 15.030 MB 前** **回傳的列: 11**
    SELECT id, home, template, s.params
    
      FROM yoj8h_template_styles as s
      LEFT JOIN yoj8h_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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLALLidx_template**NO INDEX KEY COULD BE USED**NULLNULL1310.00Using where
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionelement_clientid403vhost13117-3.s.template,const14.55Using index condition; Using where
    **側寫**
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.22 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    13JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    12JDatabaseDriver->loadObjectList()JROOT/libraries/cms/application/site.php:484
    11JApplicationSite->getTemplate()JROOT/plugins/system/t3/includes/core/t3.php:307
    10T3::detect()JROOT/plugins/system/t3/t3.php:81
    9plgSystemT3->onAfterRoute()**與下面行一樣的呼叫**
    8call_user_func_array()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:1125
    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檔案中來建立檔案的連結**]

  11. **查詢時間: 0.31 ms** **最後的查詢: 7.28 ms 之後** **查詢記憶體: 0.020 MB 記憶體於查詢: 15.423 MB 前** **回傳的列: 1**
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `yoj8h_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    **側寫**
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1650
    13JDatabaseDriver->loadObject()**與下面行一樣的呼叫**
    12call_user_func_array()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檔案中來建立檔案的連結**]

  12. **查詢時間: 0.61 ms** **最後的查詢: 0.31 ms 之後** **查詢記憶體: 0.012 MB 記憶體於查詢: 15.401 MB 前**
    UPDATE `yoj8h_extensions`
    
      SET `params` = '{\"mediaversion\":\"157d53a922eb8cc930c51896abfbfeac\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEyoj8h_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    **側寫**
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.05 ms
    updating0.09 ms
    end0.02 ms
    query end0.35 ms
    closing tables0.01 ms
    freeing items0.01 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檔案中來建立檔案的連結**]

  13. **查詢時間: 0.53 ms** **最後的查詢: 2.21 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 15.832 MB 前** **回傳的列: 1**
    SELECT *
    
      FROM yoj8h_languages
      WHERE published=1
      ORDER BY ordering ASC
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_languagesNULLALLNULL**NO INDEX KEY COULD BE USED**NULLNULL1100.00Using where; **使用filesort**
    **側寫**
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.21 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.08 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    6JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/language/helper.php:164
    5JLanguageHelper::getLanguages()JROOT/libraries/cms/application/site.php:329
    4JApplicationSite->getParams()JROOT/libraries/cms/application/site.php:135
    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檔案中來建立檔案的連結**]

  14. **查詢時間: 0.63 ms** **最後的查詢: 10.63 ms 之後** **查詢記憶體: 0.034 MB 記憶體於查詢: 17.443 MB 前** **回傳的列: 8**
    SHOW FULL COLUMNS 
      FROM `yoj8h_assets`
    **說明**
    **EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `yoj8h_assets`**
    **側寫**
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.12 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.01 ms
    Opening tables0.19 ms
    checking permissions0.02 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
    Sending data0.03 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    removing tmp table0.03 ms
    closing tables0.00 ms
    freeing items0.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/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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檔案中來建立檔案的連結**]

  15. **查詢時間: 0.26 ms** **最後的查詢: 0.74 ms 之後** **查詢記憶體: 0.028 MB 記憶體於查詢: 17.530 MB 前** **回傳的列: 1**
    SELECT *
    
      FROM yoj8h_assets
      WHERE `id` = '1'
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_assetsNULLconstPRIMARYPRIMARY4const1100.00NULL
    **側寫**
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 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/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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檔案中來建立檔案的連結**]

  16. **查詢時間: 0.26 ms** **最後的查詢: 0.25 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 17.551 MB 前** **回傳的列: 1**
    SELECT a.rules
    
      FROM yoj8h_assets AS a
      WHERE (a.id = 1 OR a.name = 'root.1')
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLindex_mergePRIMARY,idx_asset_namePRIMARY,idx_asset_name4,202NULL2100.00Using union(PRIMARY,idx_asset_name); Using where
    **側寫**
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.08 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 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/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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檔案中來建立檔案的連結**]

  17. **查詢時間: 0.56 ms** **最後的查詢: 0.73 ms 之後** **查詢記憶體: 0.032 MB 記憶體於查詢: 17.631 MB 前** **回傳的列: 211**
    SELECT a.id, a.parent_id
    
      FROM yoj8h_assets AS a
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLALLPRIMARY,idx_asset_name**NO INDEX KEY COULD BE USED**NULLNULL30720.26Using where
    **側寫**
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.32 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    19JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/access/access.php:332
    18JAccess::preloadPermissionsParentIdMapping()JROOT/libraries/joomla/access/access.php:240
    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/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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.54 ms** **最後的查詢: 0.94 ms 之後** **查詢記憶體: 0.033 MB 記憶體於查詢: 17.833 MB 前** **回傳的列: 211**
    SELECT a.id, a.name, a.rules
    
      FROM yoj8h_assets AS a
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLALLPRIMARY,idx_asset_name**NO INDEX KEY COULD BE USED**NULLNULL30720.26Using where
    **側寫**
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.33 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1255
    19JDatabaseDriver->getIterator()JROOT/libraries/joomla/access/access.php:373
    18JAccess::preloadPermissions()JROOT/libraries/joomla/access/access.php:243
    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/category.php:142
    14ContentModelCategory->populateState()JROOT/libraries/legacy/model/legacy.php:435
    13JModelLegacy->getState()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:114
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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. **查詢時間: 2.40 ms** **最後的查詢: 2.84 ms 之後** **查詢記憶體: 0.030 MB 記憶體於查詢: 18.351 MB 前** **回傳的列: 2**
    **重覆查詢**: #26
    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 yoj8h_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM yoj8h_categories AS cat JOIN yoj8h_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 yoj8h_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) 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)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=99
      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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using temporary; **使用filesort**
    1PRIMARYcNULLrangecat_idx,idx_access,idx_left_rightcat_idx207NULL1255.55Using index condition; Using where
    1PRIMARY<derived2>NULLref<auto_key0><auto_key0>4vhost13117-3.c.id10100.00Using where; Not exists; Using index
    2DERIVEDparentNULLrangecat_idx,idx_left_rightcat_idx203NULL40100.00Using index condition; Using temporary; **使用filesort**
    2DERIVEDcatNULLindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL9611.11Using where; Using index; Using join buffer (Block Nested Loop)
    **側寫**
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.34 ms
    init0.10 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.11 ms
    preparing0.02 ms
    Creating tmp table0.01 ms
    Sorting result0.02 ms
    statistics0.16 ms
    preparing0.03 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.10 ms
    executing0.00 ms
    Sending data0.72 ms
    Creating sort index0.31 ms
    Creating sort index0.05 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    15JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    14JCategories->get()JROOT/components/com_content/models/category.php:354
    13ContentModelCategory->getCategory()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:115
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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.40 ms** **最後的查詢: 2.14 ms 之後** **查詢記憶體: 0.031 MB 記憶體於查詢: 18.666 MB 前** **回傳的列: 35**
    SELECT element
    
      FROM yoj8h_extensions
      WHERE type = 'component'
      AND enabled = '1'
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_extensionsNULLrefextensionextension82const3510.00Using where
    **側寫**
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.18 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1538
    22JDatabaseDriver->loadColumn()JROOT/libraries/joomla/access/access.php:413
    21JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    20JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    19JAccess::check()JROOT/libraries/joomla/user/user.php:394
    18JUser->authorise()JROOT/components/com_content/models/articles.php:466
    17ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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.98 ms** **最後的查詢: 0.27 ms 之後** **查詢記憶體: 0.031 MB 記憶體於查詢: 18.703 MB 前** **回傳的列: 35**
    SELECT a.name, a.rules
    
      FROM yoj8h_assets AS a
      WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jaextmanager','com_joomlaupdate','com_jshopping','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLALLidx_asset_name**NO INDEX KEY COULD BE USED**NULLNULL30711.73Using where
    **側寫**
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.11 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.66 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1494
    22JDatabaseDriver->loadAssocList()JROOT/libraries/joomla/access/access.php:441
    21JAccess::preloadComponents()JROOT/libraries/joomla/access/access.php:213
    20JAccess::preload()JROOT/libraries/joomla/access/access.php:168
    19JAccess::check()JROOT/libraries/joomla/user/user.php:394
    18JUser->authorise()JROOT/components/com_content/models/articles.php:466
    17ContentModelArticles->getListQuery()JROOT/libraries/legacy/model/list.php:129
    16JModelList->_getListQuery()JROOT/libraries/legacy/model/list.php:183
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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. **查詢時間: 2.51 ms** **最後的查詢: 2.12 ms 之後** **查詢記憶體: 0.034 MB 記憶體於查詢: 19.028 MB 前** **回傳的列: 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 yoj8h_content AS a
      LEFT JOIN yoj8h_categories AS c
      ON c.id = a.catid
      LEFT JOIN yoj8h_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN yoj8h_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN yoj8h_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN yoj8h_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM yoj8h_categories AS cat JOIN yoj8h_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)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 99
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-02 01:26:48')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-02 01:26:48')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
      LIMIT 21
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00**使用filesort**
    1PRIMARYaNULLrefidx_access,idx_catididx_catid4const116.00Using index condition; Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4vhost13117-3.a.created_by1100.00Using where
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4vhost13117-3.a.modified_by1100.00Using where
    1PRIMARYparentNULLconstPRIMARYPRIMARY4const1100.00Using where
    1PRIMARYvNULLeq_refPRIMARYPRIMARY4vhost13117-3.a.id1100.00Using where
    1PRIMARY<derived2>NULLref<auto_key0><auto_key0>4const10100.00Using where; Using index
    2DERIVEDparentNULLrangecat_idx,idx_left_rightcat_idx203NULL40100.00Using index condition; Using temporary; **使用filesort**
    2DERIVEDcatNULLindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL9611.11Using where; Using index; Using join buffer (Block Nested Loop)
    **側寫**
    StatusDuration
    starting0.18 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.00 ms
    Opening tables0.73 ms
    init0.12 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    Creating tmp table0.01 ms
    Sorting result0.02 ms
    statistics0.15 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.02 ms
    Creating sort index0.17 ms
    executing0.00 ms
    Sending data0.70 ms
    Creating sort index0.06 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    17JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/model/legacy.php:310
    16JModelLegacy->_getList()JROOT/libraries/legacy/model/list.php:183
    15JModelList->getItems()JROOT/components/com_content/models/articles.php:565
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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. **查詢時間: 0.76 ms** **最後的查詢: 2.07 ms 之後** **查詢記憶體: 0.030 MB 記憶體於查詢: 19.379 MB 前** **回傳的列: 0**
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `yoj8h_contentitem_tag_map` AS m
      INNER JOIN `yoj8h_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 153
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_type**NO INDEX KEY COULD BE USED**NULLNULL362.78Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4vhost13117-3.m.tag_id1100.00Using where
    **側寫**
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.39 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.07 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:435
    15JHelperTags->getItemTags()JROOT/components/com_content/models/articles.php:693
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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. **查詢時間: 1.37 ms** **最後的查詢: 1.28 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 19.593 MB 前** **回傳的列: 1**
    SELECT COUNT(*)
    
      FROM yoj8h_content AS a
      LEFT JOIN yoj8h_categories AS c
      ON c.id = a.catid
      LEFT JOIN yoj8h_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN yoj8h_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN yoj8h_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN yoj8h_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM yoj8h_categories AS cat JOIN yoj8h_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)
      AND c.access IN (1,1)
      AND
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
      AND a.catid = 99
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-02 01:26:48')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-02 01:26:48')
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYcNULLconstPRIMARY,idx_accessPRIMARY4const1100.00NULL
    1PRIMARYaNULLrefidx_access,idx_catididx_catid4const116.00Using where
    1PRIMARYuaNULLeq_refPRIMARYPRIMARY4vhost13117-3.a.created_by1100.00Using where; Using index
    1PRIMARYuamNULLeq_refPRIMARYPRIMARY4vhost13117-3.a.modified_by1100.00Using where; Using index
    1PRIMARYparentNULLconstPRIMARYPRIMARY4const1100.00Using where; Using index
    1PRIMARYvNULLeq_refPRIMARYPRIMARY4vhost13117-3.a.id1100.00Using where; Using index
    1PRIMARY<derived2>NULLref<auto_key0><auto_key0>4const10100.00Using where; Using index
    2DERIVEDparentNULLrangecat_idx,idx_left_rightcat_idx203NULL40100.00Using index condition; Using temporary; **使用filesort**
    2DERIVEDcatNULLindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL9611.11Using where; Using index; Using join buffer (Block Nested Loop)
    **側寫**
    StatusDuration
    starting0.10 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.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    Creating tmp table0.01 ms
    Sorting result0.02 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.05 ms
    executing0.00 ms
    Sending data0.69 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1728
    17JDatabaseDriver->loadResult()JROOT/libraries/legacy/model/legacy.php:337
    16JModelLegacy->_getListCount()JROOT/libraries/legacy/model/list.php:278
    15JModelList->getTotal()JROOT/libraries/legacy/model/list.php:228
    14JModelList->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12JViewLegacy->get()JROOT/libraries/legacy/view/category.php:128
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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檔案中來建立檔案的連結**]

  25. **查詢時間: 0.28 ms** **最後的查詢: 0.45 ms 之後** **查詢記憶體: 0.026 MB 記憶體於查詢: 19.600 MB 前** **回傳的列: 0**
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `yoj8h_contentitem_tag_map` AS m
      INNER JOIN `yoj8h_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 99
      AND `t`.`published` = 1
      AND t.access IN (1,1)
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_type**NO INDEX KEY COULD BE USED**NULLNULL362.78Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4vhost13117-3.m.tag_id1100.00Using where
    **側寫**
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/cms/helper/tags.php:435
    12JHelperTags->getItemTags()JROOT/libraries/legacy/view/category.php:217
    11JViewCategory->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:72
    10ContentViewCategory->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檔案中來建立檔案的連結**]

  26. **查詢時間: 1.92 ms** **最後的查詢: 11.42 ms 之後** **查詢記憶體: 0.035 MB 記憶體於查詢: 21.318 MB 前** **回傳的列: 2**
    **重覆查詢**: #19
    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 yoj8h_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM yoj8h_categories AS cat JOIN yoj8h_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 yoj8h_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) 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)
      AND c.published = 1
      AND badcats.id is null
      AND s.id=99
      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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1PRIMARYsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00Using temporary; **使用filesort**
    1PRIMARYcNULLrangecat_idx,idx_access,idx_left_rightcat_idx207NULL1255.55Using index condition; Using where
    1PRIMARY<derived2>NULLref<auto_key0><auto_key0>4vhost13117-3.c.id10100.00Using where; Not exists; Using index
    2DERIVEDparentNULLrangecat_idx,idx_left_rightcat_idx203NULL40100.00Using index condition; Using temporary; **使用filesort**
    2DERIVEDcatNULLindexPRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_aliasidx_left_right8NULL9611.11Using where; Using index; Using join buffer (Block Nested Loop)
    **側寫**
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.10 ms
    System lock0.01 ms
    optimizing0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    Creating tmp table0.01 ms
    Sorting result0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.07 ms
    executing0.00 ms
    Sending data0.67 ms
    Creating sort index0.27 ms
    Creating sort index0.05 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    20JDatabaseDriver->loadObjectList()JROOT/libraries/legacy/categories/categories.php:309
    19JCategories->_load()JROOT/libraries/legacy/categories/categories.php:184
    18JCategories->get()JROOT/components/com_content/helpers/route.php:44
    17ContentHelperRoute::getArticleRoute()JROOT/templates/ja_fixel/html/com_content/category/blog_item.php:52
    16include JROOT/templates/ja_fixel/html/com_content/category/blog_item.phpJROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    15JViewLegacy->loadTemplate()JROOT/templates/ja_fixel/html/com_content/category/blog.php:62
    14include JROOT/templates/ja_fixel/html/com_content/category/blog.phpJROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
    13JViewLegacy->loadTemplate()JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
    12JViewLegacy->display()JROOT/libraries/legacy/view/category.php:233
    11JViewCategory->display()JROOT/components/com_content/views/category/view.html.php:258
    10ContentViewCategory->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檔案中來建立檔案的連結**]

  27. **查詢時間: 2.00 ms** **最後的查詢: 22.97 ms 之後** **查詢記憶體: 0.028 MB 記憶體於查詢: 22.340 MB 前** **回傳的列: 43**
    SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM yoj8h_modules AS m
      LEFT JOIN yoj8h_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN yoj8h_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 <= '2021-03-02 01:26:48')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-02 01:26:48')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 624 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrangePRIMARY,published,newsfeedspublished5NULL491.60Using index condition; Using where; **使用filesort**
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403vhost13117-3.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4vhost13117-3.m.id340.00Using where; Using index
    **側寫**
    StatusDuration
    starting0.07 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.29 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index1.27 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    16JDatabaseDriver->loadObjectList()JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
    15JModuleHelper::_load()JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
    14JModuleHelper::getModules()JROOT/libraries/joomla/document/html.php:501
    13JDocumentHtml->countModules()JROOT/plugins/system/t3/includes/core/template.php:608
    12T3Template->countModules()JROOT/templates/ja_fixel/tpls/blocks/header.php:53
    11include JROOT/templates/ja_fixel/tpls/blocks/header.phpJROOT/plugins/system/t3/includes/core/template.php:176
    10T3Template->loadBlock()JROOT/templates/ja_fixel/tpls/default.php:31
    9include JROOT/templates/ja_fixel/tpls/default.phpJROOT/plugins/system/t3/includes/core/template.php:200
    8T3Template->loadLayout()JROOT/templates/ja_fixel/index.php:34
    7require JROOT/templates/ja_fixel/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. **查詢時間: 0.36 ms** **最後的查詢: 8.08 ms 之後** **查詢記憶體: 0.020 MB 記憶體於查詢: 22.670 MB 前** **回傳的列: 2**
    SELECT element
    
      FROM yoj8h_extensions
      WHERE type = 'language'
      AND client_id = 0
      AND enabled = 1
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_extensionsNULLrefextensionextension82const41.25Using index condition; Using where
    **側寫**
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.06 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.04 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1689
    13JDatabaseDriver->loadObjectList()JROOT/libraries/cms/language/multilang.php:90
    12JLanguageMultilang::getSiteLangs()JROOT/modules/mod_languages/helper.php:76
    11ModLanguagesHelper::getList()JROOT/modules/mod_languages/mod_languages.php:17
    10include JROOT/modules/mod_languages/mod_languages.phpJROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    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. **查詢時間: 0.39 ms** **最後的查詢: 9.60 ms 之後** **查詢記憶體: 0.036 MB 記憶體於查詢: 23.597 MB 前** **回傳的列: 1**
    SELECT * 
      FROM yoj8h_kunena_configuration
      WHERE id=1
    **說明**
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEyoj8h_kunena_configurationNULLconstPRIMARYPRIMARY4const1100.00NULL
    **側寫**
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.00 ms
    **呼叫堆疊**
    #**Caller****檔案與行號**
    25JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1453
    24JDatabaseDriver->loadAssoc()JROOT/libraries/kunena/config.php:1227
    23KunenaConfig->load()JROOT/libraries/kunena/config.php:1174
    22KunenaConfig::getInstance()JROOT/libraries/kunena/factory.php:28
    21KunenaFactory::getConfig()JROOT/libraries/kunena/route/route.php:429
    20KunenaRoute::initialize()JROOT/libraries/kunena/route/route.php:17
    19include JROOT/libraries/kunena/route/route.phpJROOT/libraries/loader.php:640
    18JLoader::_load()JROOT/libraries/loader.php:595
    17JLoader::_autoload()**與下面行一樣的呼叫**
    16spl_autoload_call()JROOT/components/com_kunena/router.php:38
    15KunenaBuildRoute()JROOT/libraries/cms/component/router/legacy.php:68
    14JComponentRouterLegacy->build()JROOT/libraries/cms/router/site.php:496
    13JRouterSite->buildSefRoute()JROOT/libraries/cms/router/site.php:465
    12JRouterSite->_buildSefRoute()JROOT/libraries/cms/router/router.php:281
    11JRouter->build()JROOT/libraries/cms/router/site.php:147
    10JRouterSite->build()JROOT/libraries/joomla/application/route.php:62
    9JRoute::_()JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8T3MenuMegamenu->__construct()JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7JDocumentRendererMegamenuRender->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檔案中來建立檔案的連結**]

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

**選擇表格: **
  1. **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 yoj8h_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM yoj8h_categories AS cat JOIN yoj8h_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt**
  2. **2 × SELECT element 
      FROM yoj8h_extensions**
  3. **2 × SELECT `m`.`tag_id`,`t`.* 
      FROM `yoj8h_contentitem_tag_map` AS m
      INNER JOIN `yoj8h_tags` AS t
      ON `m`.`tag_id` = `t`.`id`**
  4. **2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `yoj8h_extensions`**
  5. **1 × SELECT * 
      FROM yoj8h_kunena_configuration**
  6. **1 × SELECT a.id, a.name, a.rules 
      FROM yoj8h_assets AS a**
  7. **1 × SELECT a.name, a.rules 
      FROM yoj8h_assets AS a**
  8. **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 yoj8h_content AS a
      LEFT JOIN yoj8h_categories AS c
      ON c.id = a.catid
      LEFT JOIN yoj8h_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN yoj8h_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN yoj8h_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN yoj8h_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM yoj8h_categories AS cat JOIN yoj8h_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt**
  9. **1 × SELECT COUNT(*) 
      FROM yoj8h_content AS a
      LEFT JOIN yoj8h_categories AS c
      ON c.id = a.catid
      LEFT JOIN yoj8h_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN yoj8h_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN yoj8h_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN yoj8h_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM yoj8h_categories AS cat JOIN yoj8h_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt**
  10. **1 × SELECT a.id, a.parent_id 
      FROM yoj8h_assets AS a**
  11. **1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM yoj8h_modules AS m
      LEFT JOIN yoj8h_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN yoj8h_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id**
  12. **1 × SELECT * 
      FROM yoj8h_assets**
  13. **1 × SELECT folder AS type, element AS name, params 
      FROM yoj8h_extensions**
  14. **1 × SELECT id, rules 
      FROM `yoj8h_viewlevels**
  15. **1 × SELECT b.id 
      FROM yoj8h_usergroups AS a
      LEFT JOIN yoj8h_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt**
  16. **1 × SELECT `session_id` 
      FROM `yoj8h_session`**
  17. **1 × SELECT `enabled` 
      FROM `yoj8h_extensions`**
  18. **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 yoj8h_menu AS m
      LEFT JOIN yoj8h_extensions AS e
      ON m.component_id = e.extension_id**
  19. **1 × SELECT `data` 
      FROM `yoj8h_session`**
  20. **1 × SELECT * 
      FROM yoj8h_languages**
  21. **1 × SELECT id, home, template, s.params 
      FROM yoj8h_template_styles as s
      LEFT JOIN yoj8h_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id**
  22. **1 × SELECT a.rules 
      FROM yoj8h_assets AS a**
**其他表格: **
  1. **1 × SHOW FULL COLUMNS 
      FROM `yoj8h_assets**
  2. **1 × UPDATE `yoj8h_extensions` 
      SET `params` = '{\"mediaversion\":\"157d53a922eb8cc930c51896abfbfeac\"}'**
  3. **1 × INSERT INTO `yoj8h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
      VALUES ('fji7rh4rrrsd35d9n5qrdgn012', 0, 1, '1614648408', 0, ''**

**語言檔案解譯錯誤**

  • JROOT/language/en-GB/en-GB.tpl_ja_fixel.ini : error(s) in line(s) 93, 94

**語言檔案已載入**

  • **載入** : JROOT/language/zh-TW/zh-TW.ini
  • **載入** : JROOT/language/zh-TW/zh-TW.lib_joomla.ini
  • **載入** : JROOT/administrator/language/zh-TW/zh-TW.plg_system_kunena.sys.ini
  • **載入** : JROOT/administrator/language/zh-TW/zh-TW.plg_system_updatenotification.ini
  • **載入** : JROOT/administrator/language/zh-TW/zh-TW.plg_system_logout.ini
  • **未載入** : JROOT/administrator/language/zh-TW/zh-TW.plg_system_t3.ini
  • **載入** : JROOT/administrator/language/en-GB/en-GB.plg_system_t3.ini
  • **未載入** : JROOT/language/zh-TW/zh-TW.tpl_ja_fixel.ini
  • **載入** : JROOT/language/en-GB/en-GB.tpl_ja_fixel.ini
  • **未載入** : JROOT/templates/ja_fixel/language/zh-TW/zh-TW.tpl_ja_fixel.ini
  • **載入** : JROOT/language/zh-TW/zh-TW.com_content.ini
  • **載入** : JROOT/language/zh-TW/zh-TW.mod_custom.ini
  • **載入** : JROOT/language/zh-TW/zh-TW.mod_search.ini
  • **載入** : JROOT/language/zh-TW/zh-TW.mod_languages.ini
  • **載入** : JROOT/language/zh-TW/zh-TW.mod_menu.ini
  • **載入** : JROOT/administrator/language/zh-TW/zh-TW.plg_kunena_kunena.sys.ini
  • **載入** : JROOT/administrator/language/zh-TW/zh-TW.plg_kunena_joomla.sys.ini
  • **載入** : JROOT/administrator/language/zh-TW/zh-TW.plg_system_debug.ini

**未翻譯字串**

**無**