{"__default":{"session":{"counter":1,"timer":{"start":1614649186,"last":1614649186,"now":1614649186}},"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":{"793194a3dfb0eb7a876b75a384b8aa70cafd3fa4":{"link":"http:\/\/wise-boss.com\/index.php\/boss-5\/127-selena-gomez-and-psy-rebound-on-social-50-chart","expiry":1614649188}}}}}

**時間**

**記憶體**

**29 查詢記錄** 21.60 ms

1. **查詢時間: 0.53 ms** **查詢記憶體: 0.019 MB 記憶體於查詢: 5.086 MB 前** **回傳的列: 0**

   SELECT `data`
   
     FROM `yoj8h_session`
   
     WHERE `session_id` = 'hta7a7a3qr80a5n45eru1n3o13'

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yoj8h_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   **側寫**

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.26 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	**與下面行一樣的呼叫**
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

2. **查詢時間: 0.28 ms** **最後的查詢: 46.72 ms 之後** **查詢記憶體: 0.012 MB 記憶體於查詢: 5.411 MB 前** **回傳的列: 0**

   SELECT `session_id`
   
     FROM `yoj8h_session`
   
     WHERE `session_id` = 'hta7a7a3qr80a5n45eru1n3o13' 
     LIMIT 1

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yoj8h_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   **側寫**

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

3. **查詢時間: 0.58 ms** **最後的查詢: 0.18 ms 之後** **查詢記憶體: 0.009 MB 記憶體於查詢: 5.425 MB 前**

   INSERT INTO `yoj8h_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('hta7a7a3qr80a5n45eru1n3o13', 0, 1, '1614649186', 0, '')

   **說明**

   **EXPLAIN 無法被使用於查詢: INSERT INTO `yoj8h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('hta7a7a3qr80a5n45eru1n3o13', 0, 1, '1614649186', 0, '')**

   **側寫**

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.14 ms
   end	0.01 ms
   query end	0.33 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

4. **查詢時間: 0.83 ms** **最後的查詢: 56.90 ms 之後** **查詢記憶體: 0.018 MB 記憶體於查詢: 5.876 MB 前** **回傳的列: 35**

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `yoj8h_extensions`
   
     WHERE `type` = 'component'

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	35	100.00	NULL

   **側寫**

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.25 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.27 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	**與下面行一樣的呼叫**
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

5. **查詢時間: 0.57 ms** **最後的查詢: 16.07 ms 之後** **查詢記憶體: 0.016 MB 記憶體於查詢: 6.169 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

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	100.00	Using where; Using index

   **側寫**

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.26 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.09 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

6. **查詢時間: 0.50 ms** **最後的查詢: 29.97 ms 之後** **查詢記憶體: 0.015 MB 記憶體於查詢: 6.302 MB 前** **回傳的列: 4**

   SELECT id, rules
   
     FROM `yoj8h_viewlevels`

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yoj8h_viewlevels	NULL	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	4	100.00	NULL

   **側寫**

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.21 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.06 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

7. **查詢時間: 0.74 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

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	75	0.52	Using index condition; Using where; **使用filesort**

   **側寫**

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.48 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

8. **查詢時間: 0.44 ms** **最後的查詢: 533.79 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 9.538 MB 前** **回傳的列: 1**

   SELECT `enabled`
   
     FROM `yoj8h_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yoj8h_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

   **側寫**

   Status	Duration
   starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.12 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

9. **查詢時間: 2.40 ms** **最後的查詢: 345.89 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

   **說明**

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	176	10.00	Using index condition; Using where; **使用filesort**
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	vhost13117-3.m.component_id	1	100.00	Using where

   **側寫**

   Status	Duration
   starting	0.06 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.27 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.76 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   **呼叫堆疊**

   #	**Caller**	**檔案與行號**
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

   ---

10. **查詢時間: 1.06 ms** **最後的查詢: 453.71 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 15.264 MB 前** **回傳的列: 0**

    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=127
    
      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

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	NULL	NULL	NULL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	NULL	NULL	no matching row in const table
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	40	100.00	Using index condition; Using temporary; **使用filesort**
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	96	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    **側寫**

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.34 ms
    init	0.11 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.09 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    11	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    10	JCategories->get()	JROOT/components/com_content/router.php:341
    9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

11. **查詢時間: 0.40 ms** **最後的查詢: 0.17 ms 之後** **查詢記憶體: 0.016 MB 記憶體於查詢: 15.274 MB 前** **回傳的列: 1**

    SELECT `alias`,`catid`
    
      FROM `yoj8h_content`
    
      WHERE `id` = 127

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    **側寫**

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.17 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    10	JDatabaseDriver->loadObject()	JROOT/components/com_content/router.php:357
    9	ContentRouter->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

12. **查詢時間: 0.52 ms** **最後的查詢: 0.35 ms 之後** **查詢記憶體: 0.019 MB 記憶體於查詢: 15.276 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

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template	**NO INDEX KEY COULD BE USED**	NULL	NULL	13	10.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	vhost13117-3.s.template,const	1	4.55	Using index condition; Using where

    **側寫**

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.13 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.16 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    11	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:307
    10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
    9	plgSystemT3->onAfterRoute()	**與下面行一樣的呼叫**
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

13. **查詢時間: 0.34 ms** **最後的查詢: 91.33 ms 之後** **查詢記憶體: 0.020 MB 記憶體於查詢: 15.669 MB 前** **回傳的列: 1**

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `yoj8h_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    **側寫**

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	**與下面行一樣的呼叫**
    12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

14. **查詢時間: 0.58 ms** **最後的查詢: 0.30 ms 之後** **查詢記憶體: 0.012 MB 記憶體於查詢: 15.647 MB 前**

    UPDATE `yoj8h_extensions`
    
      SET `params` = '{\"mediaversion\":\"766d0236af593103a265e399c5b2285d\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	yoj8h_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    **側寫**

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.05 ms
    end	0.01 ms
    query end	0.36 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

15. **查詢時間: 0.62 ms** **最後的查詢: 49.91 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 16.065 MB 前** **回傳的列: 1**

    SELECT *
    
      FROM yoj8h_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_languages	NULL	ALL	NULL	**NO INDEX KEY COULD BE USED**	NULL	NULL	1	100.00	Using where; **使用filesort**

    **側寫**

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.28 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.08 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

16. **查詢時間: 0.62 ms** **最後的查詢: 97.92 ms 之後** **查詢記憶體: 0.030 MB 記憶體於查詢: 17.118 MB 前** **回傳的列: 8**

    SHOW FULL COLUMNS 
      FROM `yoj8h_assets`

    **說明**

    **EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `yoj8h_assets`**

    **側寫**

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.18 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

17. **查詢時間: 0.29 ms** **最後的查詢: 52.68 ms 之後** **查詢記憶體: 0.025 MB 記憶體於查詢: 17.202 MB 前** **回傳的列: 1**

    SELECT *
    
      FROM yoj8h_assets
    
      WHERE `id` = '1'

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_assets	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    **側寫**

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

18. **查詢時間: 0.26 ms** **最後的查詢: 0.25 ms 之後** **查詢記憶體: 0.021 MB 記憶體於查詢: 17.220 MB 前** **回傳的列: 1**

    SELECT a.rules
    
      FROM yoj8h_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    **側寫**

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

19. **查詢時間: 0.34 ms** **最後的查詢: 11.32 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 17.295 MB 前** **回傳的列: 35**

    SELECT element
    
      FROM yoj8h_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	35	10.00	Using where

    **側寫**

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.10 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

20. **查詢時間: 1.03 ms** **最後的查詢: 0.21 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 17.324 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')

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	idx_asset_name	**NO INDEX KEY COULD BE USED**	NULL	NULL	307	11.73	Using where

    **側寫**

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.05 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.73 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
    11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

21. **查詢時間: 0.54 ms** **最後的查詢: 2.32 ms 之後** **查詢記憶體: 0.026 MB 記憶體於查詢: 17.796 MB 前** **回傳的列: 30**

    SHOW FULL COLUMNS 
      FROM `yoj8h_content`

    **說明**

    **EXPLAIN 無法被使用於查詢: SHOW FULL COLUMNS FROM `yoj8h_content`**

    **側寫**

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
    11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

22. **查詢時間: 0.30 ms** **最後的查詢: 57.56 ms 之後** **查詢記憶體: 0.024 MB 記憶體於查詢: 18.280 MB 前** **回傳的列: 1**

    SELECT *
    
      FROM yoj8h_content
    
      WHERE `id` = '127'

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    **側寫**

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/components/com_content/models/article.php:265
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

23. **查詢時間: 0.48 ms** **最後的查詢: 0.26 ms 之後** **查詢記憶體: 0.014 MB 記憶體於查詢: 18.293 MB 前**

    UPDATE yoj8h_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '127'

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	yoj8h_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    **側寫**

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.03 ms
    updating	0.06 ms
    end	0.01 ms
    query end	0.29 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
    10	JTable->hit()	JROOT/components/com_content/models/article.php:266
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

24. **查詢時間: 1.96 ms** **最後的查詢: 19.78 ms 之後** **查詢記憶體: 0.028 MB 記憶體於查詢: 18.572 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 yoj8h_content AS a
    
      LEFT JOIN yoj8h_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN yoj8h_users AS u 
      on u.id = a.created_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 <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.id = 127 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-02 01:39:47') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-02 01:39:47') 
      AND (a.state = 1 OR a.state =2)

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using index
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	39	100.00	Using index condition; Using temporary; **使用filesort**
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	96	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    **側寫**

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.33 ms
    init	0.15 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.19 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.72 ms
    Creating sort index	0.06 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
    12	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

25. **查詢時間: 2.01 ms** **最後的查詢: 44.29 ms 之後** **查詢記憶體: 0.027 MB 記憶體於查詢: 18.812 MB 前** **回傳的列: 3**

    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=102
    
      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

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; **使用filesort**
    1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	12	55.55	Using index condition; Using where
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	vhost13117-3.c.id	10	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	40	100.00	Using index condition; Using temporary; **使用filesort**
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	96	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    **側寫**

    Status	Duration
    starting	0.17 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.09 ms
    executing	0.00 ms
    Sending data	0.72 ms
    Creating sort index	0.29 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.03 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

26. **查詢時間: 0.67 ms** **最後的查詢: 1.51 ms 之後** **查詢記憶體: 0.025 MB 記憶體於查詢: 18.866 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` = 127 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	**NO INDEX KEY COULD BE USED**	NULL	NULL	36	2.78	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	vhost13117-3.m.tag_id	1	100.00	Using where

    **側寫**

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.29 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

27. **查詢時間: 1.92 ms** **最後的查詢: 237.25 ms 之後** **查詢記憶體: 0.028 MB 記憶體於查詢: 21.426 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:39:47') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-02 01:39:47') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 652 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	49	1.60	Using index condition; Using where; **使用filesort**
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	vhost13117-3.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	vhost13117-3.m.id	3	40.00	Using where; Using index

    **側寫**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
    15	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
    14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
    12	T3Template->countModules()	JROOT/templates/ja_fixel/tpls/blocks/header.php:53
    11	include JROOT/templates/ja_fixel/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
    10	T3Template->loadBlock()	JROOT/templates/ja_fixel/tpls/default.php:31
    9	include JROOT/templates/ja_fixel/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
    8	T3Template->loadLayout()	JROOT/templates/ja_fixel/index.php:34
    7	require JROOT/templates/ja_fixel/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

28. **查詢時間: 0.31 ms** **最後的查詢: 8.41 ms 之後** **查詢記憶體: 0.020 MB 記憶體於查詢: 21.760 MB 前** **回傳的列: 2**

    SELECT element
    
      FROM yoj8h_extensions
    
      WHERE type = 'language' 
      AND client_id = 0 
      AND enabled = 1

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using index condition; Using where

    **側寫**

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
    12	JLanguageMultilang::getSiteLangs()	JROOT/modules/mod_languages/helper.php:76
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

29. **查詢時間: 0.45 ms** **最後的查詢: 9.42 ms 之後** **查詢記憶體: 0.036 MB 記憶體於查詢: 22.686 MB 前** **回傳的列: 1**

    SELECT * 
      FROM yoj8h_kunena_configuration 
      WHERE id=1

    **說明**

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yoj8h_kunena_configuration	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    **側寫**

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.20 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    **呼叫堆疊**

    #	**Caller**	**檔案與行號**
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    24	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1227
    23	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1174
    22	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
    21	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:429
    20	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
    19	include JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:640
    18	JLoader::_load()	JROOT/libraries/loader.php:595
    17	JLoader::_autoload()	**與下面行一樣的呼叫**
    16	spl_autoload_call()	JROOT/components/com_kunena/router.php:38
    15	KunenaBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    14	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
    13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
    8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [**加入xdebug.file_link_format指示到你的php.ini檔案中來建立檔案的連結**]

    ---

**26 查詢種類已記錄，由呈現記錄儲存。**

**選擇表格: **

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 `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `yoj8h_extensions`**

4. **1 × SELECT a.name, a.rules 
     FROM yoj8h_assets AS a**

5. **1 × SELECT a.rules 
     FROM yoj8h_assets AS a**

6. **1 × SELECT * 
     FROM yoj8h_content**

7. **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 yoj8h_content AS a 
     LEFT JOIN yoj8h_categories AS c 
     on c.id = a.catid 
     LEFT JOIN yoj8h_users AS u 
     on u.id = a.created_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**

8. **1 × SELECT * 
     FROM yoj8h_kunena_configuration**

9. **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**

10. **1 × SELECT `m`.`tag_id`,`t`.* 
      FROM `yoj8h_contentitem_tag_map` AS m  
      INNER JOIN `yoj8h_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`**

11. **1 × SELECT * 
      FROM yoj8h_assets**

12. **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**

13. **1 × SELECT id, rules 
      FROM `yoj8h_viewlevels**

14. **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**

15. **1 × SELECT `session_id` 
      FROM `yoj8h_session`**

16. **1 × SELECT folder AS type, element AS name, params 
      FROM yoj8h_extensions**

17. **1 × SELECT `enabled` 
      FROM `yoj8h_extensions`**

18. **1 × SELECT `data` 
      FROM `yoj8h_session`**

19. **1 × SELECT `alias`,`catid` 
      FROM `yoj8h_content`**

20. **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**

21. **1 × SELECT * 
      FROM yoj8h_languages**