**YOSHIKIs Underground OC

Joomla!デバッグコンソール

セッション

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1695295551,
                "last": 1695295551,
                "now": 1695295551
            },
            "client": {
                "forwarded": "3.236.46.172"
            },
            "token": "0pzHTlH6u3q7ilBk4of9aOEzzVA3zO0Q"
        },
        "registry": {
            "com_slogin": {
                "return_url": "aHR0cHM6Ly95dWctb2MuanAv"
            }
        },
        "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
        },
        "gantry-current-template": "rt_dominion",
        "dominion-7bd01f134e720d7feb93a58e362ca68a-backgroundlevel": null,
        "dominion-7bd01f134e720d7feb93a58e362ca68a-bodylevel": null,
        "dominion-7bd01f134e720d7feb93a58e362ca68a-cssstyle": null,
        "dominion-7bd01f134e720d7feb93a58e362ca68a-linkcolor": null,
        "dominion-7bd01f134e720d7feb93a58e362ca68a-font-family": null,
        "dominion-7bd01f134e720d7feb93a58e362ca68a-font-size-is": null,
        "dominion-7bd01f134e720d7feb93a58e362ca68a-menu-type": null
    }
}

プロファイル情報

時間

メモリ

**時間**: 4.37 ms / 4.37 ms **メモリ**: 0.341 MB / 0.67 MB Application: afterLoad

**時間**: 69.61 ms / 73.98 ms **メモリ**: 0.703 MB / 1.38 MB Application: afterInitialise

**時間**: 23.32 ms / 97.30 ms **メモリ**: 0.261 MB / 1.64 MB Application: afterRoute

**時間**: 2.28 ms / 99.59 ms **メモリ**: 0.033 MB / 1.67 MB Application: beforeRenderComponent com_content

**時間**: 3.97 ms / 103.55 ms **メモリ**: 0.135 MB / 1.81 MB Application: Before Access::preloadComponents (all components)

**時間**: 2.06 ms / 105.62 ms **メモリ**: 0.056 MB / 1.86 MB Application: After Access::preloadComponents (all components)

**時間**: 0.04 ms / 105.66 ms **メモリ**: 0.000 MB / 1.86 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**時間**: 0.47 ms / 106.13 ms **メモリ**: 0.012 MB / 1.87 MB Application: After Access::getAssetRules (id:8 name:com_content)

**時間**: 66.84 ms / 172.97 ms **メモリ**: 0.763 MB / 2.64 MB Application: afterRenderComponent com_content

**時間**: 214.57 ms / 387.54 ms **メモリ**: 4.669 MB / 7.31 MB Application: afterDispatch

**時間**: 10.43 ms / 397.97 ms **メモリ**: 0.065 MB / 7.37 MB Application: beforeRenderModule mod_roknavmenu ()

**時間**: 8.86 ms / 406.83 ms **メモリ**: 0.174 MB / 7.54 MB Application: afterRenderModule mod_roknavmenu ()

**時間**: 11.91 ms / 418.74 ms **メモリ**: 0.012 MB / 7.56 MB Application: beforeRenderModule mod_custom (koukoku)

**時間**: 0.60 ms / 419.34 ms **メモリ**: 0.006 MB / 7.56 MB Application: afterRenderModule mod_custom (koukoku)

**時間**: 0.82 ms / 420.16 ms **メモリ**: 0.004 MB / 7.57 MB Application: beforeRenderModule mod_slogin (SLogin)

**時間**: 1.43 ms / 421.59 ms **メモリ**: 0.027 MB / 7.59 MB Application: afterRenderModule mod_slogin (SLogin)

**時間**: 0.60 ms / 422.19 ms **メモリ**: 0.019 MB / 7.61 MB Application: beforeRenderModule mod_articles_latest (最新記事)

**時間**: 9.07 ms / 431.26 ms **メモリ**: 0.188 MB / 7.80 MB Application: afterRenderModule mod_articles_latest (最新記事)

**時間**: 0.64 ms / 431.90 ms **メモリ**: -0.132 MB / 7.67 MB Application: beforeRenderModule mod_custom (Adsence縦長&access解析)

**時間**: 0.16 ms / 432.06 ms **メモリ**: 0.003 MB / 7.67 MB Application: afterRenderModule mod_custom (Adsence縦長&access解析)

**時間**: 2.03 ms / 434.09 ms **メモリ**: 0.029 MB / 7.70 MB Application: beforeRenderModule mod_custom (観覧方法について)

**時間**: 0.19 ms / 434.28 ms **メモリ**: 0.003 MB / 7.70 MB Application: afterRenderModule mod_custom (観覧方法について)

**時間**: 1.44 ms / 435.72 ms **メモリ**: 0.023 MB / 7.73 MB Application: beforeRenderModule mod_custom (Link Free)

**時間**: 0.21 ms / 435.92 ms **メモリ**: 0.003 MB / 7.73 MB Application: afterRenderModule mod_custom (Link Free)

**時間**: 1.54 ms / 437.46 ms **メモリ**: 0.022 MB / 7.75 MB Application: beforeRenderModule mod_custom (ブログシステム移行のお知らせ)

**時間**: 0.16 ms / 437.63 ms **メモリ**: 0.003 MB / 7.76 MB Application: afterRenderModule mod_custom (ブログシステム移行のお知らせ)

**時間**: 17.76 ms / 455.39 ms **メモリ**: -0.015 MB / 7.74 MB Application: afterRender

**合計データベースクエリ: 52.83 ms**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	コーラー	ファイルと行番号
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

**次のクエリではEXPLAINの使用不可: INSERT INTO `YUG_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'336533343939366d746630636574676e3873636d67363537716b', 1, 1695295551, 0, '', 0)**

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.08 ms
Waiting for query cache lock	0.04 ms
Update	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.47 ms
Writing to binlog	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.50 ms** **最後のクエリ以降: 1.51 ms** **クエリメモリ: 0.021 MB Memory before query: 0.791 MB** **返された行: 43**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `YUG_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_extensions	ref	extension	extension	82	const	43	Using index condition; Using where

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.38 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.08 ms

**コールスタック**

#	コーラー	ファイルと行番号
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	*下の行にあるコールと同じです。*
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 0.96 ms** **最後のクエリ以降: 1.01 ms** **クエリメモリ: 0.020 MB Memory before query: 0.802 MB** **返された行: 6**

SELECT id, rules

  FROM `YUG_viewlevels`

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_viewlevels	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	6

**プロファイル**

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.08 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.16 ms** **最後のクエリ以降: 0.16 ms** **クエリメモリ: 0.020 MB Memory before query: 0.812 MB** **返された行: 2**

SELECT b.id

  FROM YUG_usergroups AS a

  LEFT JOIN YUG_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

**説明**

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

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.06 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.21 ms** **最後のクエリ以降: 0.72 ms** **クエリメモリ: 0.022 MB Memory before query: 0.836 MB** **返された行: 118**

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM YUG_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_extensions	ALL	extension	使用可能なインデックスキーがありません	NULL	NULL	287	Using where; filesortレコードの使用

**プロファイル**

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.04 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	*下の行にあるコールと同じです。*
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.08 ms** **最後のクエリ以降: 12.02 ms** **クエリメモリ: 0.022 MB Memory before query: 1.177 MB** **返された行: 1**

**重複クエリ**: #8

SELECT template

  FROM YUG_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	使用可能なインデックスキーがありません	NULL	NULL	14	Using where

**プロファイル**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.05 ms** **最後のクエリ以降: 0.12 ms** **クエリメモリ: 0.022 MB Memory before query: 1.184 MB** **返された行: 1**

**重複クエリ**: #7

SELECT template

  FROM YUG_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	使用可能なインデックスキーがありません	NULL	NULL	14	Using where

**プロファイル**

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.03 ms** **最後のクエリ以降: 1.91 ms** **クエリメモリ: 0.020 MB Memory before query: 1.290 MB** **返された行: 4**

SELECT extension, file, type

  FROM YUG_rokcommon_configs

  ORDER BY priority

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_rokcommon_configs	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	4	filesortレコードの使用

**プロファイル**

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.05 ms** **最後のクエリ以降: 25.96 ms** **クエリメモリ: 0.039 MB Memory before query: 1.402 MB** **返された行: 19**

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 YUG_menu AS m

  LEFT JOIN YUG_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	49	Using index condition; Using where; filesortレコードの使用
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.m.component_id	1	Using where

**プロファイル**

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.76 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.05 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	*下の行にあるコールと同じです。*
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.64 ms** **最後のクエリ以降: 6.99 ms** **クエリメモリ: 0.052 MB Memory before query: 1.533 MB** **返された行: 12**

**重複クエリ**: #26

SELECT id, home, template, s.params

  FROM YUG_template_styles as s

  LEFT JOIN YUG_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	使用可能なインデックスキーがありません	NULL	NULL	14	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	yugocjp-trial_twitools.s.template,const	1	Using index condition; Using where

**プロファイル**

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.09 ms
Executing	0.01 ms
Sending data	0.43 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:123
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:56
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.11 ms** **最後のクエリ以降: 3.67 ms** **クエリメモリ: 0.023 MB Memory before query: 1.611 MB** **返された行: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `YUG_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.04 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*下の行にあるコールと同じです。*
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.48 ms** **最後のクエリ以降: 0.40 ms** **クエリメモリ: 0.006 MB Memory before query: 1.602 MB**

UPDATE `YUG_extensions`

  SET `params` = '{\"mediaversion\":\"4441400049c8478b31147730f4ddf37d\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**説明**

**次のクエリではEXPLAINの使用不可: UPDATE `YUG_extensions` SET `params` = '{\"mediaversion\":\"4441400049c8478b31147730f4ddf37d\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.13 ms
Updating	0.10 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	1.37 ms
Writing to binlog	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.28 ms** **最後のクエリ以降: 1.58 ms** **クエリメモリ: 0.024 MB Memory before query: 1.633 MB** **返された行: 91**

SELECT *

  FROM `YUG_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_jcomments_settings	ref	PRIMARY	PRIMARY	214	const,const	91	Using where

**プロファイル**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.06 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
14	JCommentsCfg::_load()	*下の行にあるコールと同じです。*
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/classes/config.php:159
11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.10 ms** **最後のクエリ以降: 1.24 ms** **クエリメモリ: 0.019 MB Memory before query: 1.652 MB** **返された行: 2**

SELECT *

  FROM YUG_languages

  WHERE published=1

  ORDER BY ordering ASC

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_languages	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	2	Using where; filesortレコードの使用

**プロファイル**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.77 ms** **最後のクエリ以降: 4.74 ms** **クエリメモリ: 0.025 MB Memory before query: 1.809 MB** **返された行: 42**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `YUG_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry','com_gantry5','com_installer','com_j2xml','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokgallery','com_search','com_slogin','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_assets	ALL	idx_asset_name	使用可能なインデックスキーがありません	NULL	NULL	244	Using where

**プロファイル**

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.52 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.25 ms** **最後のクエリ以降: 1.62 ms** **クエリメモリ: 0.040 MB Memory before query: 1.902 MB** **返された行: 3**

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM YUG_content AS a

  LEFT JOIN YUG_categories AS c 
  ON c.id = a.catid

  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN YUG_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN YUG_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN YUG_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-21 11:25:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-21 11:25:51')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END , a.created DESC  
  LIMIT 4

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	3	Using where; filesortレコードの使用
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.modified_by	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	yugocjp-trial_twitools.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.id	1	Using where

**プロファイル**

Status	Duration
Starting	0.32 ms
checking permissions	0.06 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.14 ms
Optimizing	0.11 ms
Statistics	0.19 ms
Preparing	0.08 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.34 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.51 ms** **最後のクエリ以降: 1.02 ms** **クエリメモリ: 0.023 MB Memory before query: 1.960 MB** **返された行: 1**

SELECT COUNT(*)

  FROM YUG_content AS a

  LEFT JOIN YUG_categories AS c 
  ON c.id = a.catid

  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN YUG_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN YUG_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN YUG_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-21 11:25:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-21 11:25:51')

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	3	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	yugocjp-trial_twitools.a.catid	1	Using where

**プロファイル**

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.68 ms** **最後のクエリ以降: 3.43 ms** **クエリメモリ: 0.025 MB Memory before query: 2.028 MB** **返された行: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `YUG_categories` AS `s`

  INNER JOIN `YUG_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 8

  ORDER BY c.lft

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	8 (28%)	Using index condition; Using where; Using rowid filter

**プロファイル**

Status	Duration
Starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.24 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.06 ms

**コールスタック**

#	コーラー	ファイルと行番号
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.92 ms** **最後のクエリ以降: 0.44 ms** **クエリメモリ: 0.024 MB Memory before query: 2.045 MB** **返された行: 0**

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM YUG_fields AS a

  LEFT JOIN `YUG_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN YUG_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN YUG_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN YUG_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `YUG_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesortレコードの使用
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	yugocjp-trial_twitools.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.id	1	Using where; Using index; Distinct

**プロファイル**

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.11 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.07 ms
Creating tmp table	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.87 ms
Creating sort index	0.08 ms
Removing tmp table	0.23 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 0.96 ms** **最後のクエリ以降: 3.31 ms** **クエリメモリ: 0.023 MB Memory before query: 2.080 MB** **返された行: 1**

SELECT count(*)

  FROM YUG_jcomments AS c

  WHERE c.object_id = 2 
  AND c.object_group = 'com_content' 
  AND c.published = 1

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
16	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
15	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
14	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:110
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.54 ms** **最後のクエリ以降: 1.59 ms** **クエリメモリ: 0.025 MB Memory before query: 2.092 MB** **返された行: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `YUG_categories` AS `s`

  INNER JOIN `YUG_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right	idx_left_right\|cat_idx	4\|207	NULL	2 (28%)	Using index condition; Using where; Using rowid filter

**プロファイル**

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.10 ms
Optimizing	0.05 ms
Statistics	0.20 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.54 ms** **最後のクエリ以降: 0.27 ms** **クエリメモリ: 0.024 MB Memory before query: 2.100 MB** **返された行: 0**

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM YUG_fields AS a

  LEFT JOIN `YUG_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN YUG_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN YUG_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN YUG_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `YUG_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesortレコードの使用
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	yugocjp-trial_twitools.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.id	1	Using where; Using index; Distinct

**プロファイル**

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.06 ms
Statistics	0.20 ms
Preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.81 ms
Creating sort index	0.07 ms
Removing tmp table	0.16 ms
Creating sort index	0.02 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 0.99 ms** **最後のクエリ以降: 2.87 ms** **クエリメモリ: 0.023 MB Memory before query: 2.121 MB** **返された行: 1**

SELECT count(*)

  FROM YUG_jcomments AS c

  WHERE c.object_id = 303 
  AND c.object_group = 'com_content' 
  AND c.published = 1

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
16	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
15	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
14	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:110
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 0.97 ms** **最後のクエリ以降: 1.97 ms** **クエリメモリ: 0.023 MB Memory before query: 2.137 MB** **返された行: 1**

SELECT count(*)

  FROM YUG_jcomments AS c

  WHERE c.object_id = 327 
  AND c.object_group = 'com_content' 
  AND c.published = 1

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	Using where; Using index

**プロファイル**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
16	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
15	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
14	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:110
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.61 ms** **最後のクエリ以降: 7.02 ms** **クエリメモリ: 0.058 MB Memory before query: 2.203 MB** **返された行: 12**

**重複クエリ**: #11

SELECT id, home, template, s.params

  FROM YUG_template_styles as s

  LEFT JOIN YUG_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	使用可能なインデックスキーがありません	NULL	NULL	14	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	yugocjp-trial_twitools.s.template,const	1	Using index condition; Using where

**プロファイル**

Status	Duration
Starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.41 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
24	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:604
23	GantryTemplate::getTemplateById()	JROOT/libraries/gantry/core/gantrytemplate.class.php:420
22	GantryTemplate->loadParamsContent()	JROOT/libraries/gantry/core/gantrytemplate.class.php:365
21	GantryTemplate->getXMLParams()	JROOT/libraries/gantry/core/gantrytemplate.class.php:205
20	GantryTemplate->init()	JROOT/libraries/gantry/core/gantry.class.php:287
19	Gantry->__construct()	JROOT/libraries/gantry/core/gantry.class.php:62
18	Gantry::getInstance()	JROOT/libraries/gantry/core/utilities/gantrycache.class.php:156
17	GantryCache->call()	JROOT/libraries/gantry/gantry.php:271
16	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
15	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_dominion/html/com_content/featured/default.php:14
14	include JROOT/templates/rt_dominion/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:164
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.01 ms** **最後のクエリ以降: 246.44 ms** **クエリメモリ: 0.023 MB Memory before query: 7.358 MB** **返された行: 7**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM YUG_modules AS m

  LEFT JOIN YUG_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN YUG_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-09-21 11:25:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-21 11:25:51') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	12	Using index condition; Using where; filesortレコードの使用
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	yugocjp-trial_twitools.m.module,const	1	Using index condition; Using where

**プロファイル**

Status	Duration
Starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.09 ms
Statistics	0.12 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.49 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	*下の行にあるコールと同じです。*
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/rt_dominion/index.php:25
7	require JROOT/templates/rt_dominion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.13 ms** **最後のクエリ以降: 5.02 ms** **クエリメモリ: 0.024 MB Memory before query: 7.394 MB** **返された行: 0**

SELECT ts.template

  FROM YUG_template_styles AS ts

  INNER JOIN YUG_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 101 
  AND m.template_style_id != 0

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**プロファイル**

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry/features/fusionmenu.php:65
10	GantryFeatureFusionMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_dominion/index.php:47
7	require JROOT/templates/rt_dominion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.00 ms** **最後のクエリ以降: 0.13 ms** **クエリメモリ: 0.024 MB Memory before query: 7.401 MB** **返された行: 1**

SELECT template

  FROM YUG_template_styles

  WHERE home = 1 
  AND client_id = 0

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_template_styles	ALL	idx_client_id,idx_client_id_home	使用可能なインデックスキーがありません	NULL	NULL	14	Using where

**プロファイル**

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry/features/fusionmenu.php:65
10	GantryFeatureFusionMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_dominion/index.php:47
7	require JROOT/templates/rt_dominion/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 3.31 ms** **最後のクエリ以降: 21.53 ms** **クエリメモリ: 0.086 MB Memory before query: 7.644 MB** **返された行: 5**

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM YUG_content AS a

  LEFT JOIN YUG_categories AS c 
  ON c.id = a.catid

  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN YUG_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN YUG_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN YUG_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.featured = 0 
  AND a.catid IN (14,15,16,17,18,19,20,21,22,23,24,44,25,26,43,27,28,29,30,31) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-21 11:25:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-21 11:25:51')

  ORDER BY a.created DESC 
  LIMIT 5

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	94	Using index condition; Using where; filesortレコードの使用
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	yugocjp-trial_twitools.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	yugocjp-trial_twitools.a.id	1	Using where

**プロファイル**

Status	Duration
Starting	0.34 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.10 ms
Statistics	0.36 ms
Preparing	0.08 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1.35 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.11 ms
Reset for next command	0.05 ms

**コールスタック**

#	コーラー	ファイルと行番号
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	*下の行にあるコールと同じです。*
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:605
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 1.61 ms** **最後のクエリ以降: 1.17 ms** **クエリメモリ: 0.027 MB Memory before query: 7.781 MB** **返された行: 4**

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 `YUG_categories` AS `s`

  INNER JOIN `YUG_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 16

  ORDER BY c.lft

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	使用可能なインデックスキーがありません	NULL	NULL	47	Using where; filesortレコードの使用

**プロファイル**

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.16 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.23 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	*下の行にあるコールと同じです。*
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
14	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
13	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	*下の行にあるコールと同じです。*
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:605
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 2.05 ms** **最後のクエリ以降: 10.15 ms** **クエリメモリ: 0.024 MB Memory before query: 7.634 MB** **返された行: 8**

SHOW FULL COLUMNS 
  FROM `YUG_template_styles`

**説明**

**次のクエリではEXPLAINの使用不可: SHOW FULL COLUMNS FROM `YUG_template_styles`**

**プロファイル**

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.04 ms
Opening tables	0.65 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.13 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.22 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

**コールスタック**

#	コーラー	ファイルと行番号
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

**クエリ時間: 0.89 ms** **最後のクエリ以降: 0.57 ms** **クエリメモリ: 0.023 MB Memory before query: 7.655 MB** **返された行: 1**

SELECT *

  FROM YUG_template_styles

  WHERE `id` = '28'

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	YUG_template_styles	const	PRIMARY	PRIMARY	4	const	1

**プロファイル**

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**ファイルへのリンクを有するため xdebug.file_link_format ディレクティブを php.ini ファイルに追加します。**]

24クエリの種類を出現頻度順でログに記録しました。

テーブルの選択:

**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 `YUG_categories` AS `s` 
  INNER JOIN `YUG_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)**

**3 × SELECT count(*) 
  FROM YUG_jcomments AS c**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `YUG_extensions`**

**2 × SELECT template 
  FROM YUG_template_styles as s**

**2 × SELECT id, home, template, s.params 
  FROM YUG_template_styles as s 
  LEFT JOIN YUG_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**2 × 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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM YUG_content AS a 
  LEFT JOIN YUG_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN YUG_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN YUG_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN YUG_content_rating AS v 
  ON a.id = v.content_id**

**2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM YUG_fields AS a 
  LEFT JOIN `YUG_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN YUG_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN YUG_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN YUG_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `YUG_fields_categories` AS fc 
  ON fc.field_id = a.id**

**1 × SELECT `session_id` 
  FROM `YUG_session`**

**1 × SELECT id, rules 
  FROM `YUG_viewlevels**

**1 × SELECT b.id 
  FROM YUG_usergroups AS a 
  LEFT JOIN YUG_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt**

**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM YUG_extensions**

**1 × SELECT extension, file, type 
  FROM YUG_rokcommon_configs**

**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 YUG_menu AS m 
  LEFT JOIN YUG_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT * 
  FROM `YUG_jcomments_settings`**

**1 × SELECT * 
  FROM YUG_languages**

**1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `YUG_assets`**

**1 × SELECT COUNT(*) 
  FROM YUG_content AS a 
  LEFT JOIN YUG_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN YUG_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN YUG_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN YUG_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN YUG_content_rating AS v 
  ON a.id = v.content_id**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM YUG_modules AS m 
  LEFT JOIN YUG_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN YUG_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT ts.template 
  FROM YUG_template_styles AS ts 
  INNER JOIN YUG_menu AS m 
  ON ts.id=m.template_style_id**

**1 × SELECT template 
  FROM YUG_template_styles**

**1 × SELECT * 
  FROM YUG_template_styles**

その他のテーブル:

**1 × INSERT INTO `YUG_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'336533343939366d746630636574676e3873636d67363537716b', 1, 1695295551, 0, '', 0**

**1 × UPDATE `YUG_extensions` 
  SET `params` = '{\"mediaversion\":\"4441400049c8478b31147730f4ddf37d\"}'**

**1 × SHOW FULL COLUMNS 
  FROM `YUG_template_styles**

言語ファイルの解析エラー

読み込まれた言語ファイル

**読み込みました** : JROOT/language/ja-JP/ja-JP.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.lib_joomla.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_updatenotification.ini
**未読み込み** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_fields.ini
**未読み込み** : JROOT/administrator/language/ja-JP/plg_system_fields.ini
**未読み込み** : JROOT/plugins/system/fields/language/ja-JP/ja-JP.plg_system_fields.ini
**未読み込み** : JROOT/plugins/system/fields/language/ja-JP/plg_system_fields.ini
**未読み込み** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_j2xml.ini
**未読み込み** : JROOT/administrator/language/ja-JP/plg_system_j2xml.ini
**未読み込み** : JROOT/plugins/system/j2xml/language/ja-JP/ja-JP.plg_system_j2xml.ini
**未読み込み** : JROOT/plugins/system/j2xml/language/ja-JP/plg_system_j2xml.ini
**未読み込み** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_logrotation.ini
**未読み込み** : JROOT/administrator/language/ja-JP/plg_system_logrotation.ini
**未読み込み** : JROOT/plugins/system/logrotation/language/ja-JP/ja-JP.plg_system_logrotation.ini
**未読み込み** : JROOT/plugins/system/logrotation/language/ja-JP/plg_system_logrotation.ini
**未読み込み** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_gantry.ini
**未読み込み** : JROOT/administrator/language/ja-JP/plg_system_gantry.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_logout.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.com_jcomments.ini
**未読み込み** : JROOT/language/ja-JP/ja-JP.tpl_rt_dominion.ini
**未読み込み** : JROOT/language/ja-JP/tpl_rt_dominion.ini
**未読み込み** : JROOT/templates/rt_dominion/language/ja-JP/ja-JP.tpl_rt_dominion.ini
**未読み込み** : JROOT/templates/rt_dominion/language/ja-JP/tpl_rt_dominion.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.com_content.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_content_vote.ini
**未読み込み** : JROOT/language/ja-JP/ja-JP.mod_roknavmenu.ini
**未読み込み** : JROOT/language/ja-JP/mod_roknavmenu.ini
**未読み込み** : JROOT/modules/mod_roknavmenu/language/ja-JP/ja-JP.mod_roknavmenu.ini
**未読み込み** : JROOT/modules/mod_roknavmenu/language/ja-JP/mod_roknavmenu.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.mod_custom.ini
**未読み込み** : JROOT/language/ja-JP/ja-JP.mod_slogin.ini
**未読み込み** : JROOT/language/ja-JP/mod_slogin.ini
**未読み込み** : JROOT/modules/mod_slogin/language/ja-JP/ja-JP.mod_slogin.ini
**未読み込み** : JROOT/modules/mod_slogin/language/ja-JP/mod_slogin.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.mod_articles_latest.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_debug.ini

未翻訳の文字列


# JROOT/libraries/src/Language/Text.php

COM_SLOGIN_PROVIDER_TWITTER="SLOGIN PROVIDER TWITTER"
DEC_FONT_SIZE="FONT SIZE"
DEVELOPED_BY="BY"
DIRECTORY_S_DOES_NOT_EXIST_UNABLE_TO_ADD_TO_CLASS_LOADER="%s does not exist.  Unable to add to Class Loader"
GANTRY_INITIALIZED_FROM="INITIALIZED FROM"
INC_FONT_SIZE="FONT SIZE"
LOADING_CONTAINER_CONFIG_FILE_FOR_S_FROM_S="container config file for %s from %s"
MOD_SLOGIN_FORGOT_YOUR_PASSWORD="SLOGIN FORGOT YOUR PASSWORD"
MOD_SLOGIN_FORGOT_YOUR_USERNAME="SLOGIN FORGOT YOUR USERNAME"
MOD_SLOGIN_REMEMBER_ME="SLOGIN REMEMBER ME"
MOD_SLOGIN_VALUE_USERNAME="SLOGIN VALUE USERNAME"
PLG_SYSTEM_GANTRY_LOG_FOUND_OVERRIDE_FILE="SYSTEM GANTRY LOG FOUND OVERRIDE FILE"
PLG_SYSTEM_GANTRY_LOG_OVERRIDE_SEARCH_PATH="SYSTEM GANTRY LOG OVERRIDE SEARCH PATH"
PLG_SYSTEM_GANTRY_LOG_USING_OVERRRIDE="SYSTEM GANTRY LOG USING OVERRRIDE"
POWERED_BY="BY"
REGISTERING_LIBRARY_PATH_S_FOR_S="library path %s for %s"
RT_UPDATED="UPDATED"
TEXT_SIZE="SIZE"
UNABLE_TO_FIND_REGISTERED_CONTAINER_CONFIG_FILE_S_AT_S="to find registered container config file %s at %s"

観覧方法について

Home

SLogin

最新記事

Joomla!デバッグコンソール

セッション

プロファイル情報

時間

メモリ

メモリ使用量

データベースクエリ

33クエリをログに記録しました 52.83 ms

4 重複が見つかりました！

24クエリの種類を出現頻度順でログに記録しました。

テーブルの選択:

その他のテーブル:

言語ファイルの解析エラー

読み込まれた言語ファイル

未翻訳の文字列

観覧方法について

Home

SLogin

最新記事

**Joomla!デバッグコンソール**

**セッション**

**プロファイル情報**

**時間**

**メモリ**

**メモリ使用量**

**データベースクエリ**

**33クエリをログに記録しました** 52.83 ms

**4 重複が見つかりました！**

**24クエリの種類を出現頻度順でログに記録しました。**

**テーブルの選択:**

**その他のテーブル:**

**言語ファイルの解析エラー**

**読み込まれた言語ファイル**

**未翻訳の文字列**

Joomla!デバッグコンソール

セッション

プロファイル情報

時間

メモリ

メモリ使用量

データベースクエリ

33クエリをログに記録しました 52.83 ms

4 重複が見つかりました！

24クエリの種類を出現頻度順でログに記録しました。

テーブルの選択:

その他のテーブル:

言語ファイルの解析エラー

読み込まれた言語ファイル

未翻訳の文字列