**テントサイト | 野反湖キャンプ場, hotel in 群馬県, 吾妻郡中之条町大字入山**

テントサイト予約はこちら

テントサイト

群馬県吾妻郡中之条町大字入山国有林内, 377-1701, 吾妻郡中之条町大字入山, 群馬県, Japan

施設情報

要予約
チェックイン	午後　0時～午後5時15分
チェックアウト	午前11時
宿泊料金	敷地代　テント1張1泊 2,200円/2,370円休前日連休料金/税込（普通テント）入場料1人1泊 660円/税込（0歳から一律）タープ1張り1泊770円/税込 ※延長料金220円税込/1人（1時間） ※アーリーチェックイン　550円税込/1人（午前10時～） ※アーリーチェックイン　1100円税込/1人（午前8時30～） ※レイトチェックインは有料となります。　17：15～19：00まで550円/1人　　（19：00以降のチェックインはお断りいたします）
※ 草地・礫混じり地 ※ 要予約ですが、サイトはフリーサイトです。敷地は広大ですが、広々快適に過ごしていただきたいので１日の張数限定です。 ※ 受付事務所からサイトまで徒歩約10分。荷物運搬用のリヤカーを無料貸出しております。（荷物運搬用リヤカーを除く車両は入れません） ※ テントサイトまでの道路は外灯等ありません。他のお客様の迷惑となるため時間外のチェックインは出来ません。 ※ ご利用は、ネット予約または電話でのご予約をお願いします。 ※ チェックインは午後　0時～午後5時15分までです。受付事務所で受付していただいた後、受付証をお渡しいたしますので、その後設営をお願いします。 ※ チェックアウトはご出発日の午前11時までです。受付証を受付事務所フロントまたは回収ボックスまでお返しください。 ※ トイレ・炊事場は共同でご利用ください。炊事場については22:00に消灯となります。 ※ テント近隣の空きスペースにおいて炊事・調理する場合はコンロや焚き火台などをご使用ください。（直火禁止） ※ 打上げ花火・爆竹等は禁止です。また、手持ち花火やタバコは火災の原因になりやすい場所ではおやめください。 ※ ゴミ類は場内案内に従って、分別廃棄をお願いします。なお食材や生ゴミは放置しますと、カラスや動物によって荒らされるおそれがありますので、特に注意し、放置しないようにしてください。 ※ ペットをお連れの場合は、施設内ではノーリード（放し飼い）にしないでください。フンなどの後始末は、飼い主の責任で処理してください。 ※ 荷物運搬用リヤカーは無料貸し出しですが、数に限りがあります。ご利用方法・返却方法などは当キャンプ場の指示に従ってご利用ください。 ※ソロテント1張1泊 1,700円/1,870円休前日連休料金/税込（短辺1ｍまでのテント） ※大型テント1張1泊 4,400円/4,740円休前日連休料金/税込（長辺6ｍ以上の大型テント）　6名以上の大型テント・タープをご使用の場合には施設（テント・タープ）を２施設でご予約してください。　（大人、1張り６名以上は大型テント扱いとなります。予約数を ≪ 2 ≫ でお願いします。） ※大型テント使用の場合は、現地で判断し追加料金頂く場合がございます。

2026 3月 21日 : **# 宿泊日数**:1, **人数**:2, **予約数**: 1

**予約数**

**許容人数**

**宿泊金額**

**予約**

テントサイト | **空き状況・詳細を見る**

**Capacity**

**宿泊金額**

About

野反湖は、2,000ｍ級の山々に囲まれた山岳、湖水、湿原、草原など変化に富んだ環境にあり、上信越高原国立公園の特別地域及び自然休養林に指定されています。群馬・長野・新潟の県境に位置し、周囲12km、標高1,513ｍのダム湖で、その湖水は魚野川から信濃川に合流し日本海にそそいでいます。2019年より株式会社カナイが運営管理業務をおこなっております。

Latest News

2024年度営業終了 **2024年11月07日**

10月7日は臨時休業いたします **2024年10月06日**

台風接近のため臨時休業いたします2（訂正） **2024年08月29日**

Our Partners

Quick Link

Joomla!デバッグコンソール

セッション

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1774101311,
                "last": 1774101311,
                "now": 1774101311
            },
            "client": {
                "forwarded": "216.73.216.208"
            },
            "token": "dMRhcTpkeDjMZJYvPsu8QqJjZaBC1fTI"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "ja-JP"
        },
        "menuId": "1079"
    }
}

プロフィール情報

時間

メモリ

**時間**: 3.54 ms / 3.54 ms **メモリ**: 0.410 MB / 0.75 MB Application: afterLoad

**時間**: 21.62 ms / 25.16 ms **メモリ**: 0.980 MB / 1.73 MB Application: afterInitialise

**時間**: 4.66 ms / 29.82 ms **メモリ**: 0.189 MB / 1.92 MB Application: afterRoute

**時間**: 2.41 ms / 32.24 ms **メモリ**: 0.064 MB / 1.98 MB Application: beforeRenderComponent com_jhotelreservation

**時間**: 54.19 ms / 86.43 ms **メモリ**: 1.108 MB / 3.09 MB Application: Before Access::preloadComponents (all components)

**時間**: 1.40 ms / 87.83 ms **メモリ**: 0.060 MB / 3.15 MB Application: After Access::preloadComponents (all components)

**時間**: 0.02 ms / 87.85 ms **メモリ**: -0.002 MB / 3.14 MB Application: Before Access::getAssetRules (id:1 name:root.1)

**時間**: 0.16 ms / 88.00 ms **メモリ**: 0.008 MB / 3.15 MB Application: After Access::getAssetRules (id:1 name:root.1)

**時間**: 15.04 ms / 103.04 ms **メモリ**: 0.254 MB / 3.41 MB Application: afterRenderComponent com_jhotelreservation

**時間**: 1.22 ms / 104.26 ms **メモリ**: 0.032 MB / 3.44 MB Application: afterDispatch

**時間**: 17.48 ms / 121.74 ms **メモリ**: 0.242 MB / 3.68 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

**時間**: 1.22 ms / 122.96 ms **メモリ**: 0.043 MB / 3.72 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

**時間**: 0.06 ms / 123.02 ms **メモリ**: -0.003 MB / 3.72 MB Application: beforeRenderModule mod_menu (Quick Link)

**時間**: 0.23 ms / 123.25 ms **メモリ**: 0.011 MB / 3.73 MB Application: afterRenderModule mod_menu (Quick Link)

**時間**: 0.03 ms / 123.28 ms **メモリ**: -0.002 MB / 3.73 MB Application: beforeRenderModule mod_menu (Our Partners)

**時間**: 0.28 ms / 123.56 ms **メモリ**: 0.017 MB / 3.75 MB Application: afterRenderModule mod_menu (Our Partners)

**時間**: 0.03 ms / 123.59 ms **メモリ**: -0.004 MB / 3.74 MB Application: beforeRenderModule mod_articles_latest (Latest News)

**時間**: 0.61 ms / 124.20 ms **メモリ**: 0.043 MB / 3.78 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**時間**: 0.04 ms / 124.24 ms **メモリ**: 0.007 MB / 3.79 MB Application: After Access::getAssetRules (id:8 name:com_content)

**時間**: 6.00 ms / 130.24 ms **メモリ**: 0.048 MB / 3.84 MB Application: afterRenderModule mod_articles_latest (Latest News)

**時間**: 0.04 ms / 130.29 ms **メモリ**: -0.024 MB / 3.82 MB Application: beforeRenderModule mod_custom (About )

**時間**: 0.25 ms / 130.54 ms **メモリ**: 0.005 MB / 3.82 MB Application: afterRenderModule mod_custom (About )

**時間**: 0.04 ms / 130.57 ms **メモリ**: -0.001 MB / 3.82 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

**時間**: 0.54 ms / 131.12 ms **メモリ**: 0.014 MB / 3.83 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

**時間**: 1.26 ms / 132.38 ms **メモリ**: 0.120 MB / 3.95 MB Application: afterRender

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

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

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	*下の行にあるコールと同じです。*
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_session	const	PRIMARY	PRIMARY	194	const	1	100.00	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 `z6j4s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'74676e61723436707267306230386f733635677370746d367530', 1, 1774101311, 0, '', 0)**

**プロフィール**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.11 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 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 ファイルに追加します。**]

**クエリ時間: 0.79 ms** **最後のクエリ以降: 0.41 ms** **クエリメモリ: 0.024 MB Memory before query: 1.078 MB** **返された行: 40**

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

  FROM `z6j4s_extensions`

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

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_extensions	ref	extension	extension	82	const	40	100.00	Using index condition; Using where

**プロフィール**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 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.44 ms** **最後のクエリ以降: 0.49 ms** **クエリメモリ: 0.021 MB Memory before query: 1.106 MB** **返された行: 6**

SELECT id, rules

  FROM `z6j4s_viewlevels`

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
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 ファイルに追加します。**]

**クエリ時間: 0.54 ms** **最後のクエリ以降: 0.06 ms** **クエリメモリ: 0.021 MB Memory before query: 1.118 MB** **返された行: 2**

SELECT b.id

  FROM z6j4s_usergroups AS a

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

  WHERE a.id = 13

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
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 ファイルに追加します。**]

**クエリ時間: 0.94 ms** **最後のクエリ以降: 0.11 ms** **クエリメモリ: 0.030 MB Memory before query: 1.140 MB** **返された行: 86**

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

  FROM z6j4s_extensions

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

  ORDER BY ordering

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_extensions	ref	extension	extension	82	const	110	100.00	Using index condition; Using where; filesortレコードの使用

**プロフィール**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.52 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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 ファイルに追加します。**]

**クエリ時間: 0.52 ms** **最後のクエリ以降: 3.95 ms** **クエリメモリ: 0.021 MB Memory before query: 1.546 MB** **返された行: 1**

SELECT *

  FROM z6j4s_languages

  WHERE published=1

  ORDER BY ordering ASC

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__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 ファイルに追加します。**]

**クエリ時間: 0.37 ms** **最後のクエリ以降: 0.09 ms** **クエリメモリ: 0.021 MB Memory before query: 1.555 MB** **返された行: 10**

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `z6j4s_extensions`

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

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_extensions	ref	extension	extension	82	const	10	100.00	Using index condition; Using where

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__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.24 ms** **最後のクエリ以降: 5.26 ms** **クエリメモリ: 0.049 MB Memory before query: 1.643 MB** **返された行: 24**

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

  LEFT JOIN z6j4s_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	90	100.00	Using index condition; Using where; filesortレコードの使用
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.m.component_id	1	100.00	Using where

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	*下の行にあるコールと同じです。*
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	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:668
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 ファイルに追加します。**]

**クエリ時間: 0.92 ms** **最後のクエリ以降: 2.55 ms** **クエリメモリ: 0.039 MB Memory before query: 1.890 MB** **返された行: 1**

SELECT * 
  FROM z6j4s_hotelreservation_applicationsettings fas
						
  inner join  z6j4s_hotelreservation_date_formats df 
  on fas.date_format_id=df.id

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fas	system	NULL	使用可能なインデックスキーがありません	NULL	NULL	1	100.00	NULL
1	SIMPLE	df	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/helpers/utils.php:60
9	JHotelUtil::getApplicationSettings()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:42
8	plgSystemHotelUrlTranslator->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 ファイルに追加します。**]

**クエリ時間: 0.78 ms** **最後のクエリ以降: 0.10 ms** **クエリメモリ: 0.021 MB Memory before query: 1.907 MB** **返された行: 0**

select * 
  from z6j4s_hotelreservation_offers of
					
  inner join z6j4s_hotelreservation_offers_vouchers hov 
  on of.offer_id = hov.offerId  
					
  where REPLACE(hov.voucher,'-',' ') = 'tent site' 
					
  group by of.offer_id 
  LIMIT 0, 1

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:230
9	plgSystemHotelUrlTranslator->getVoucherParams()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:78
8	plgSystemHotelUrlTranslator->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 ファイルに追加します。**]

**クエリ時間: 0.67 ms** **最後のクエリ以降: 0.02 ms** **クエリメモリ: 0.021 MB Memory before query: 1.912 MB** **返された行: 0**

SELECT * 
  FROM `z6j4s_hotelreservation_hotels`  
  WHERE REPLACE(hotel_city,'-',' ') = 'tent-site'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:137
9	plgSystemHotelUrlTranslator->getHotelCityParams()	JROOT/plugins/system/hotelurltranslator/hotelurltranslator.php:80
8	plgSystemHotelUrlTranslator->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 ファイルに追加します。**]

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

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

  FROM `z6j4s_extensions`

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

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*下の行にあるコールと同じです。*
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.48 ms** **最後のクエリ以降: 0.09 ms** **クエリメモリ: 0.005 MB Memory before query: 1.927 MB**

UPDATE `z6j4s_extensions`

  SET `params` = '{\"mediaversion\":\"b3ee4d0c95b4835e4be4b76e15071a7e\"}'

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

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where; Using temporary

**プロフィール**

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.05 ms
Searching rows for update	0.03 ms
updating	0.04 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.18 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms

**コールスタック**

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.77 ms** **最後のクエリ以降: 0.35 ms** **クエリメモリ: 0.019 MB Memory before query: 1.951 MB** **返された行: 4**

SELECT id, home, template, s.params

  FROM z6j4s_template_styles as s

  LEFT JOIN z6j4s_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	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	4	100.00	NULL
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	LAA1125550-hanamametest.s.template,const	1	100.00	Using index condition; Using where

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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.49 ms** **最後のクエリ以降: 2.93 ms** **クエリメモリ: 0.021 MB Memory before query: 2.043 MB** **返された行: 0**

SELECT `c2`.`language`,`c2`.`id`

  FROM `z6j4s_menu` AS `c`

  INNER JOIN `z6j4s_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `z6j4s_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `z6j4s_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 1079

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
8	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_jhotelreservation/helpers/utils.php:919
7	JHotelUtil::setExtensionMenuId()	JROOT/components/com_jhotelreservation/jhotelreservation.php:74
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.91 ms** **最後のクエリ以降: 6.04 ms** **クエリメモリ: 0.024 MB Memory before query: 2.506 MB** **返された行: 1**

SELECT
					h.*,
					c1.country_name,
					c2.description	AS hotel_currency, c2.currency_symbol AS currency_symbol
					
  FROM z6j4s_hotelreservation_hotels 			h
					
  LEFT JOIN z6j4s_hotelreservation_countries 	c1 USING (country_id)
					
  LEFT JOIN z6j4s_hotelreservation_currencies 	c2 USING (currency_id)
					
  WHERE h.hotel_id = 35 
  AND h.is_available = 1

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c1	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c2	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:119
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.87 ms** **最後のクエリ以降: 0.05 ms** **クエリメモリ: 0.026 MB Memory before query: 2.518 MB** **返された行: 5**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_language_translations`

**説明**

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

**プロフィール**

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.10 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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_jhotelreservation/tables/hoteltranslations.php:27
16	TableHotelTranslations->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:29
14	JHotelReservationLanguageTranslations->__construct()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:131
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.29 ms** **最後のクエリ以降: 0.16 ms** **クエリメモリ: 0.024 MB Memory before query: 2.535 MB** **返された行: 1**

select * 
  from  z6j4s_hotelreservation_language_translations 
  where type=1 
  and object_id=35 
  and language_tag='ja-JP'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:55
15	TableHotelTranslations->getObjectTranslation()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:43
14	JHotelReservationLanguageTranslations->getObjectTranslation()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:132
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.46 ms** **最後のクエリ以降: 0.03 ms** **クエリメモリ: 0.023 MB Memory before query: 2.551 MB** **返された行: 1**

SELECT	*
				
  FROM z6j4s_hotelreservation_hotel_pictures
				
  WHERE hotel_id = 35 
  AND hotel_picture_enable = 1
				
  ORDER BY hotel_picture_id

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_hotelreservation_hotel_pictures	ref	Index 2,2	Index 2	4	const	1	100.00	Using where; filesortレコードの使用

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:145
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.80 ms** **最後のクエリ以降: 0.02 ms** **クエリメモリ: 0.023 MB Memory before query: 2.559 MB** **返された行: 0**

SELECT	hf.*
					
  FROM z6j4s_hotelreservation_hotel_facilities hf
					
  inner join  z6j4s_hotelreservation_hotel_facility_relation hfc 
  on hf.id = hfc.facilityId
					
  WHERE hfc.hotelId = 35
					
  ORDER BY hf.name

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hfc	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; filesortレコードの使用
1	SIMPLE	hf	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.hfc.facilityId	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:154
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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** **最後のクエリ以降: 0.02 ms** **クエリメモリ: 0.023 MB Memory before query: 2.566 MB** **返された行: 0**

SELECT	hf.*
					
  FROM z6j4s_hotelreservation_hotel_types hf
					
  inner join  z6j4s_hotelreservation_hotel_type_relation hfc 
  on hf.id = hfc.typeId
					
  WHERE hfc.hotelId = 35
					
  ORDER BY hf.name

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:163
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.74 ms** **最後のクエリ以降: 0.02 ms** **クエリメモリ: 0.023 MB Memory before query: 2.573 MB** **返された行: 0**

SELECT	* 
  from z6j4s_hotelreservation_hotel_channel_manager 
  where hotel_id = 35

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:169
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.37 ms** **最後のクエリ以降: 0.02 ms** **クエリメモリ: 0.023 MB Memory before query: 2.580 MB** **返された行: 1**

SELECT	hc.booking_email 
  from z6j4s_hotelreservation_hotel_contacts as hc 
  where hotel_id = 35

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:174
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.23 ms** **最後のクエリ以降: 0.73 ms** **クエリメモリ: 0.029 MB Memory before query: 2.592 MB** **返された行: 18**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_points_of_interest`

**説明**

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

**プロフィール**

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.13 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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_jhotelreservation/tables/poi.php:30
16	JTablePOI->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:286
14	HotelService::getActivePOIs()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:184
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.41 ms** **最後のクエリ以降: 0.05 ms** **クエリメモリ: 0.024 MB Memory before query: 2.621 MB** **返された行: 0**

select * 
  from( 
		    		select id,name,description,poi_latitude,poi_longitude,activity_radius,poi_address,poi_city,poi_zipcode,poi_county,
		    			 111.1111 * DEGREES(ACOS(COS(RADIANS(36.717905))
			             * COS(RADIANS(poi_latitude))
			             * COS(RADIANS(138.63865 - poi_longitude))
			             + SIN(RADIANS(36.717905))
			               * SIN(RADIANS(poi_latitude)))) AS distance
		    		  
  from z6j4s_hotelreservation_points_of_interest  
		    		  
  where publish = 1 ) a 
			      
  where a.distance <= a.activity_radius
		          
  order by name asc

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/poi.php:104
15	JTablePOI->getActivePOIs()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:287
14	HotelService::getActivePOIs()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:184
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.71 ms** **最後のクエリ以降: 0.12 ms** **クエリメモリ: 0.026 MB Memory before query: 2.631 MB** **返された行: 3**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_review_answers`

**説明**

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

**プロフィール**

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.10 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 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_jhotelreservation/tables/reviewanswers.php:27
16	TableReviewAnswers->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:257
14	HotelService::getHotelReviewScore()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:198
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.62 ms** **最後のクエリ以降: 0.03 ms** **クエリメモリ: 0.024 MB Memory before query: 2.646 MB** **返された行: 0**

select rq.review_question_id,rq.review_question_desc as question, avg(rs.weight) as average
					
  from z6j4s_hotelreservation_review_answers ra 
					
  inner join z6j4s_hotelreservation_review_customers rc 
  on ra.review_id = rc.review_id
					
  inner join z6j4s_hotelreservation_review_questions rq 
  on ra.review_question_id = rq.review_question_id 
					
  inner join z6j4s_hotelreservation_review_rating_scale rs 
  on rs.rating_scale_id = ra.rating_scale_id
					
  where rc.hotel_id = 35 
  and rs.weight<>0 
					
  group by rq.review_question_id 
  ORDER BY rq.review_question_nr

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/reviewanswers.php:50
15	TableReviewAnswers->getAverageReviewAnswersScoreByHotel()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:258
14	HotelService::getHotelReviewScore()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:198
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.94 ms** **最後のクエリ以降: 0.04 ms** **クエリメモリ: 0.024 MB Memory before query: 2.655 MB** **返された行: 0**

select * 
  from z6j4s_hotelreservation_language_translations 
  where type=13 
  and language_tag = 'ja-JP'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:63
16	TableHotelTranslations->getAllTranslationtByLanguage()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:74
15	JHotelReservationLanguageTranslations->getAllTranslationtByLanguage()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:262
14	HotelService::getHotelReviewScore()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:198
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.29 ms** **最後のクエリ以降: 0.15 ms** **クエリメモリ: 0.029 MB Memory before query: 2.665 MB** **返された行: 23**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_hotel_informations`

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jhotelreservation/tables/hotelinformations.php:19
15	JTableHotelInformations->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:203
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.43 ms** **最後のクエリ以降: 0.05 ms** **クエリメモリ: 0.024 MB Memory before query: 2.698 MB** **返された行: 1**

select * 
  FROM z6j4s_hotelreservation_hotel_informations 
  where hotel_id=35

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_hotelreservation_hotel_informations	const	informations	informations	4	const	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/tables/hotelinformations.php:31
14	JTableHotelInformations->getHotelInformations()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:204
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.69 ms** **最後のクエリ以降: 0.16 ms** **クエリメモリ: 0.025 MB Memory before query: 2.720 MB** **返された行: 1**

select * 
  from  z6j4s_hotelreservation_language_translations 
  where type=11 
  and object_id=26 
  and language_tag='ja-JP'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:55
15	TableHotelTranslations->getObjectTranslation()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:43
14	JHotelReservationLanguageTranslations->getObjectTranslation()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:240
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.53 ms** **最後のクエリ以降: 0.04 ms** **クエリメモリ: 0.024 MB Memory before query: 2.732 MB** **返された行: 1**

select * 
  from  z6j4s_hotelreservation_language_translations 
  where type=12 
  and object_id=26 
  and language_tag='ja-JP'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:55
15	TableHotelTranslations->getObjectTranslation()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:43
14	JHotelReservationLanguageTranslations->getObjectTranslation()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:246
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.48 ms** **最後のクエリ以降: 0.05 ms** **クエリメモリ: 0.023 MB Memory before query: 2.741 MB** **返された行: 1**

select * 
  FROM z6j4s_hotelreservation_hotel_payment_options hpo
		
  inner join z6j4s_hotelreservation_hotel_payment_option_relation hpor 
  on hpo.id=hpor.paymentOptionId 
		
  where hotelId=35

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hpor	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	hpo	eq_ref	PRIMARY	PRIMARY	1	LAA1125550-hanamametest.hpor.paymentOptionId	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/hotelinformations.php:40
14	JTableHotelInformations->getHotelPaymentOptions()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:250
13	HotelService::getHotel()	JROOT/components/com_jhotelreservation/models/hotel.php:42
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.65 ms** **最後のクエリ以降: 0.05 ms** **クエリメモリ: 0.040 MB Memory before query: 2.744 MB** **返された行: 0**

select SQL_CALC_FOUND_ROWS rc.*,hc.*, avg(rs.weight) as average
						
  from z6j4s_hotelreservation_review_answers ra 
						
  inner join z6j4s_hotelreservation_review_customers rc 
  on ra.review_id = rc.review_id
						
  inner join z6j4s_hotelreservation_review_questions rq 
  on ra.review_question_id = rq.review_question_id 
						
  inner join z6j4s_hotelreservation_review_rating_scale rs 
  on rs.rating_scale_id = ra.rating_scale_id
						
  inner join z6j4s_hotelreservation_confirmations hc 
  on rc.confirmation_id=hc.confirmation_id
						
  where rc.hotel_id = 35 
  and rc.published=1 
  and rs.weight<>0 
  group by rc.review_id 
  ORDER BY rc.review_id desc 
  LIMIT 0, 20

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/reviewanswers.php:65
14	TableReviewAnswers->getHotelReviews()	JROOT/components/com_jhotelreservation/models/hotel.php:451
13	JHotelReservationModelHotel->getHotelReviews()	JROOT/components/com_jhotelreservation/models/hotel.php:46
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.28 ms** **最後のクエリ以降: 2.60 ms** **クエリメモリ: 0.033 MB Memory before query: 2.840 MB** **返された行: 37**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_hotels`

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jhotelreservation/tables/hotels.php:54
15	TableHotels->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:2257
13	HotelService::getHotelNearByHotels()	JROOT/components/com_jhotelreservation/models/hotel.php:66
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.12 ms** **最後のクエリ以降: 0.18 ms** **クエリメモリ: 0.007 MB Memory before query: 2.898 MB**


  SET SESSION group_concat_max_len = 1000000

**説明**

**次のクエリではEXPLAINの使用不可: SET SESSION group_concat_max_len = 1000000**

**プロフィール**

Status	Duration
starting	0.03 ms
Opening tables	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/administrator/components/com_jhotelreservation/tables/hotels.php:575
14	TableHotels->getHotels()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:2258
13	HotelService::getHotelNearByHotels()	JROOT/components/com_jhotelreservation/models/hotel.php:66
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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 ファイルに追加します。**]

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

select
					h.hotel_id, h.hotel_name,h.hotel_alias,h.hotel_short_description as hotel_description, h.hotel_county, h.hotel_city, h.hotel_address, h.hotel_zipcode, h.hotel_website, h.hotel_stars, h.hotel_rating_score, h.featured, h.hotel_selling_points, h.recommended, h.hotel_phone, h.hotel_number,h.hotel_latitude,h.hotel_longitude,
					h.hotel_stars as hstars,hh10.room_min_rate,hh9.totalRoomsAvailable,hh9.searchRoomIds,hc.totalReserved,
					(hh9.totalRoomsAvailable-IFNULL(hc.totalReserved,0)) as roomsLeft,
					IF(hh11.min_offer_price IS NULL OR hh10.room_min_rate IS NULL, COALESCE(hh11.min_offer_price, hh10.room_min_rate), LEAST(hh11.min_offer_price,hh10.room_min_rate))  as lowest_hotel_price, 
					hh11.offer_available,hh11.hotelOffersIds,
					1.609344*3956 * 2 * ASIN(SQRT( POWER(SIN((36.717905 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(36.717905 * pi()/180 ) * COS( abs(h.hotel_latitude) *  pi()/180) * POWER(SIN((138.63865 - h.hotel_longitude) *  pi()/180 / 2), 2) )) as distance ,
				
					currency_symbol,
					hc.noBookings,
					offer_details,	
					noReviews,
					c1.country_name,
					c2.description	AS hotel_currency,
					hotel_picture_path,hotel_picture_info,hotel_pictures_count,
					hlt.content as hotel_description,
					 hh8.* 
  from (
				 SELECT h.hotel_id, facilities, types,accommodationTypes, enviroments,regions,1 as room_available,themes,noReviews
                 
  from 
                     (select h.hotel_id 
  from z6j4s_hotelreservation_hotels as h
                             
  where 1    
  and LOCATE('2026-03-21', ignored_dates)=0  
  and (h.start_date <= '2026-03-21' or h.start_date='0000-00-00')
  and (h.end_date >= '2026-03-21' or h.end_date='0000-00-00') 
  and h.is_available = 1) h 
                	 
  left join (select hotelId, GROUP_CONCAT(facilityId) as facilities
                	            
  from z6j4s_hotelreservation_hotel_facility_relation
                	            
  where 1 
                	            
  group by hotelId 
                	            ) as fr 
  on h.hotel_id = fr.hotelId
               		 
  left join (select hotelId, GROUP_CONCAT(tr.typeId) as types
               		            
  from z6j4s_hotelreservation_hotel_type_relation as tr 
                 			    
  left join z6j4s_hotelreservation_hotel_types ht 
  on ht.id=tr.typeId 
                 			    
  where 1 
                 			    
  group by hotelId 
				 			    ) tr 
  on h.hotel_id = tr.hotelId
				     
  left join  (select  atr.hotelId, GROUP_CONCAT(atr.accommodationTypeId) as accommodationTypes  
				                 
  from z6j4s_hotelreservation_hotel_accommodation_type_relation atr
				                 
  left join z6j4s_hotelreservation_hotel_accommodation_types as hat 
  on hat.id = atr.accommodationtypeId
				                 
  where 1 
				                 
  group by atr.hotelId 
				                ) as atr 
  on h.hotel_id = atr.hotelId
					
  left join (  select hotelId, GROUP_CONCAT(environmentId) as enviroments 
					             
  from z6j4s_hotelreservation_hotel_environment_relation 
					             
  where 1   
					             
  group by hotelId ) as er 
  on h.hotel_id=er.hotelId 
				    
  left join ( select  rl.hotelId, GROUP_CONCAT(rl.regionId) as regions 
				                 
  from z6j4s_hotelreservation_hotel_region_relation as rl 
							     
  left  join z6j4s_hotelreservation_hotel_regions as hr 
  on hr.id = rl.regionId 
							     
  where 1   
							     
  group by hotelId
							   ) as rl  
  on h.hotel_id=rl.hotelId   
					 
					
  left join ( select hotel_id, GROUP_CONCAT(hotr.themeId) as themes
					            
  from z6j4s_hotelreservation_offers hof 
						 		
  left join z6j4s_hotelreservation_offers_themes_relation hotr 
  on hotr.offerId=hof.offer_id 
								
  left join z6j4s_hotelreservation_offers_themes hot 
  on hot.id = hotr.themeId
								
								
  group by hotel_id           
					    	  ) hof 
  on h.hotel_id = hof.hotel_id 
				 
  left join
						(select hotel_id, count(hrt.review_id) as noReviews 
						     
  from z6j4s_hotelreservation_review_customers hrt
							 
  group by hotel_id
						) as hrc 
  on h.hotel_id = hrc.hotel_id
					 
  where  1      ) as hh8 
  inner join z6j4s_hotelreservation_hotels h 
  on hh8.hotel_id=h.hotel_id 
  left join z6j4s_hotelreservation_countries c1 USING (country_id)  
  left join z6j4s_hotelreservation_currencies c2 USING (currency_id)  
  left join
							( select hc.hotel_id,count(hcr.confirmation_room_id) as totalReserved,count(distinct hc.confirmation_id) as noBookings
							  
  from z6j4s_hotelreservation_confirmations hc
							  
  inner join z6j4s_hotelreservation_confirmations_rooms hcr 
  on hc.confirmation_id = hcr.confirmation_id
							  
  where ((hc.start_date <'2026-03-21' 
  and '2026-03-21' <=  hc.end_date) or (hc.start_date <='2026-03-21' 
  and '2026-03-21' < hc.end_date))  
  and hc.reservation_status NOT IN (2)
							  
  group by hc.hotel_id
					        )as hc 
  on h.hotel_id=hc.hotel_id 
  left join (
                             		select a.hotel_id,a.hotel_picture_path, a.hotel_picture_info,b.hotel_pictures_count
					       		    
  from z6j4s_hotelreservation_hotel_pictures a
					       		    
  inner join
					       				 (SELECT hp.hotel_id, min(hp.hotel_picture_id) as hotel_main_picture_id, count(hp.hotel_picture_id) as hotel_pictures_count
								  		 
  FROM z6j4s_hotelreservation_hotel_pictures AS hp 
								      	 
  group by hotel_id
					       			) b 
  on a.hotel_picture_id = b.hotel_main_picture_id
						)as hh12 
  on hh12.hotel_id = h.hotel_id
					
  left join (
							select * 
							
  from z6j4s_hotelreservation_language_translations
							
  where type = 1
							
  and language_tag = ''
						)as hlt 
  on hlt.object_id = h.hotel_id
				
  left join (
	                select hotel_id,
	                min(room_rate) as room_min_rate,
	                GROUP_CONCAT(room_name,'|',room_id,'|',room_rate) as room_details 
	                
  from (
	                	select  
	                	hr.room_name,
	                	hr.room_id,
	                	hr.hotel_id,
	                	if(min(hrrp.price), min(hrrp.price), min(least(hrr.price_1, hrr.price_2, hrr.price_3, hrr.price_4, hrr.price_5, hrr.price_6, hrr.price_7))) as room_rate
	               		
  from z6j4s_hotelreservation_rooms as hr 
	               		
  left join z6j4s_hotelreservation_rooms_rates as hrr 
  on hr.room_id=hrr.room_id
                    	
  left join z6j4s_hotelreservation_rooms_rate_prices as hrrp 
  on hrr.id=hrrp.rate_id  
  and hrrp.date between '2026-03-21' 
  and '2026-03-21'
                    	
  where hr.front_display = 1 
  and hr.is_available=1
                    	
  group by hr.room_id
                    ) hh110 
                    
  group by hotel_id
	             ) as hh10 
  on h.hotel_id=hh10.hotel_id
				
  left join (
	                select hotel_id,
	                sum(hh19.availability) as totalRoomsAvailable, 
	                GROUP_CONCAT(hh19.room_id) as searchRoomIds
	                
  from(
	                	select  
	                	hr.room_id,
	                	sum(IFNULL(hra.availability,hr.availability*1)) availability,
	                	max(IFNULL(hrrp.rate_closed,0)) rate_closed,
	                	hr.hotel_id
	                	
  from z6j4s_hotelreservation_rooms as hr 
                    	
  left join z6j4s_hotelreservation_rooms_rates as hrr 
  on hr.room_id=hrr.room_id
						
  left join (select room_id,availability 
  from z6j4s_hotelreservation_room_availability 
  where date between '2026-03-21' 
  and '2026-03-20') hra 
  on hr.room_id = hra.room_id
                    	
  left join (select rate_id,rate_closed  
  from z6j4s_hotelreservation_rooms_rate_prices 
  where date between '2026-03-21' 
  and '2026-03-20') as hrrp 
  on hrr.id=hrrp.rate_id 
                    	
  where hr.is_available=1
                    	
  group by hr.room_id
                    	
  having rate_closed<>1
                    ) hh19
                    
  group by hotel_id
	             ) as hh9 
  on h.hotel_id=hh9.hotel_id
			
  left join (
               select hotel_id,1 as offer_available,hh111.rate_closed,GROUP_CONCAT(hh111.offer_id) as hotelOffersIds,
               		  GROUP_CONCAT(offer_name,'||',offer_id,'||',offer_rate,'||',offer_min_nights,'||',base_adults,'||',price_type,'||',price_type_day,'||',offer_room_id,'||',offer_content,'||',last_minute,'||',ifnull(offer_initial_price,'') separator '##') as offer_details,
				      min(offer_rate) as min_offer_price
              
  from (
             		select
             		hof.offer_name,
             		hof.offer_content,
             		hof.offer_id,
             		hof.hotel_id as hotel_id,
             		IFNULL(max(orp.min_days),hof.offer_min_nights) as offer_min_nights,
             		IFNULL(min(if(orp.max_days=0,999,orp.max_days)),hof.offer_max_nights) as offer_max_nights,
             		hof.last_minute as last_minute,
             		hof.offer_initial_price as offer_initial_price,
					ofr.base_adults, ofr.price_type,  ofr.price_type_day, ofrr.room_id as offer_room_id,
					max(IFNULL(orp.rate_closed,0)) rate_closed,
					if(ofr.price_type_day=1 , 
						if ( min(orp.price),  min(orp.price), min(least(ofr.price_1, ofr.price_2, ofr.price_3, ofr.price_4, ofr.price_5, ofr.price_6, ofr.price_7))) ,
						if ( min(orp.price),  min(orp.price), min(least(ofr.price_1, ofr.price_2, ofr.price_3, ofr.price_4, ofr.price_5, ofr.price_6, ofr.price_7))) * hof.offer_min_nights )
						 as offer_rate
				    
  from z6j4s_hotelreservation_offers hof 
                    
  inner join z6j4s_hotelreservation_offers_rooms ofrr 
  on ofrr.offer_id = hof.offer_id
                    
					
  inner join z6j4s_hotelreservation_offers_rates ofr 
  on ofr.offer_id = hof.offer_id 
  and ofr.room_id = ofrr.room_id
					
  left join (select *  
  from z6j4s_hotelreservation_offers_rate_prices orp 
  where 1  
  and orp.date between '2026-03-21' 
  and '2026-03-20' 
  and orp.date>='2026-03-21' ) orp 
  on orp.rate_id = ofr.id 
			        
  left join z6j4s_hotelreservation_offers_vouchers hov 
  on hof.offer_id = hov.offerId  
  	                
  where hof.is_available = 1 
  	                
  and ('2026-03-20' between hof.offer_datas 
  and hof.offer_datae) 
  	                
  and (CURDATE() between hof.offer_datasf 
  and hof.offer_dataef) 
  	                 
  and  (hov.voucher is null or hov.voucher='' or hof.public=1)
		            
  group by hof.offer_id
  	                
  order by hotel_id,offer_rate asc
  	              ) hh111 
  	            
  where 1  
  and rate_closed<>1  
  and (1 between hh111.offer_min_nights 
  and hh111.offer_max_nights)
                
  group by hotel_id
            )  as hh11 
  on h.hotel_id= hh11.hotel_id 
  WHERE 1    
  and hh9.totalRoomsAvailable-IFNULL(hc.totalReserved,0)>= 1*1 
  and (offer_available=1 or room_available=1)   
  and h.hotel_id not in (35)    
  having distance < 100  
  ORDER BY distance asc 
  LIMIT 0, 45

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	h	ALL	PRIMARY	使用可能なインデックスキーがありません	NULL	NULL	3	100.00	Using where; Using temporary; filesortレコードの使用
1	PRIMARY	<derived21>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	c1	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.h.country_id	1	100.00	NULL
1	PRIMARY	c2	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.h.currency_id	1	100.00	NULL
1	PRIMARY	<derived11>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived12>	ref	<auto_key0>	<auto_key0>	4	LAA1125550-hanamametest.h.hotel_id	2	100.00	NULL
1	PRIMARY	<derived14>	ref	<auto_key0>	<auto_key0>	4	LAA1125550-hanamametest.h.hotel_id	22	100.00	NULL
1	PRIMARY	<derived15>	ref	<auto_key0>	<auto_key0>	4	LAA1125550-hanamametest.h.hotel_id	7	100.00	NULL
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	LAA1125550-hanamametest.h.hotel_id	11	100.00	Using index condition
1	PRIMARY	<derived17>	ref	<auto_key0>	<auto_key0>	4	LAA1125550-hanamametest.h.hotel_id	6047	100.00	Using where
21	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
22	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
23	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
17	DERIVED	<derived18>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	604763	100.00	filesortレコードの使用
18	DERIVED	hr	ALL	PRIMARY	使用可能なインデックスキーがありません	NULL	NULL	76	100.00	Using where; Using temporary; filesortレコードの使用
18	DERIVED	hrr	eq_ref	ROOM_INDEX	ROOM_INDEX	4	LAA1125550-hanamametest.hr.room_id	1	100.00	NULL
18	DERIVED	<derived19>	ref	<auto_key0>	<auto_key0>	4	LAA1125550-hanamametest.hr.room_id	25	100.00	NULL
18	DERIVED	<derived20>	ref	<auto_key0>	<auto_key0>	4	LAA1125550-hanamametest.hrr.id	317	100.00	NULL
20	DERIVED	z6j4s_hotelreservation_rooms_rate_prices	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	58697	100.00	Using where
19	DERIVED	z6j4s_hotelreservation_room_availability	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	2508	100.00	Using where
15	DERIVED	<derived16>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	76	100.00	filesortレコードの使用
16	DERIVED	hr	ALL	PRIMARY	使用可能なインデックスキーがありません	NULL	NULL	76	100.00	Using where; Using temporary; filesortレコードの使用
16	DERIVED	hrr	eq_ref	ROOM_INDEX	ROOM_INDEX	4	LAA1125550-hanamametest.hr.room_id	1	100.00	NULL
16	DERIVED	hrrp	ref	roomrateprices_rateid_idx	roomrateprices_rateid_idx	7	LAA1125550-hanamametest.hrr.id,const	1	100.00	Using where
14	DERIVED	z6j4s_hotelreservation_language_translations	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	2237	100.00	Using where
12	DERIVED	<derived13>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	11	100.00	Using where
12	DERIVED	a	eq_ref	PRIMARY	PRIMARY	4	b.hotel_main_picture_id	1	100.00	NULL
13	DERIVED	hp	ALL	Index 2,2	使用可能なインデックスキーがありません	NULL	NULL	11	100.00	Using temporary; filesortレコードの使用
11	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
2	DERIVED	<derived3>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	3	100.00	NULL
2	DERIVED	<derived4>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	7	85.71	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	<derived5>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	8	75.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	<derived6>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	<derived7>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	<derived8>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	<derived9>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	<derived10>	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
10	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
9	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
8	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
7	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
6	DERIVED	atr	index	PRIMARY	PRIMARY	8	NULL	3	100.00	Using index; filesortレコードの使用
6	DERIVED	hat	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.atr.accommodationtypeId	1	100.00	Using index
5	DERIVED	ht	system	PRIMARY	使用可能なインデックスキーがありません	NULL	NULL	0	0.00	const row not found
5	DERIVED	tr	index	PRIMARY	PRIMARY	8	NULL	8	100.00	Using index
4	DERIVED	z6j4s_hotelreservation_hotel_facility_relation	index	PRIMARY	PRIMARY	8	NULL	7	100.00	Using index
3	DERIVED	h	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	3	100.00	Using where

**プロフィール**

Status	Duration
optimizing	0.01 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.02 ms
statistics	0.11 ms
executing	0.03 ms
statistics	0.08 ms
executing	0.04 ms
statistics	0.26 ms
preparing	0.05 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.38 ms
Sending data	0.09 ms
executing	0.02 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.86 ms
Creating sort index	0.03 ms
removing tmp table	0.01 ms
Creating sort index	0.08 ms
executing	0.01 ms
Sending data	0.76 ms
executing	0.02 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.96 ms
Creating sort index	0.11 ms
removing tmp table	0.01 ms
Creating sort index	0.01 ms
Creating sort index	0.13 ms
removing tmp table	0.01 ms
Creating sort index	0.01 ms
executing	0.27 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
removing tmp table	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.17 ms
Creating sort index	0.03 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.02 ms
removing tmp table	0.01 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.02 ms

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/hotels.php:579
14	TableHotels->getHotels()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:2258
13	HotelService::getHotelNearByHotels()	JROOT/components/com_jhotelreservation/models/hotel.php:66
12	JHotelReservationModelHotel->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:40
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.13 ms** **最後のクエリ以降: 0.21 ms** **クエリメモリ: 0.033 MB Memory before query: 2.913 MB** **返された行: 36**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_offers`

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jhotelreservation/tables/offers.php:29
15	JTableOffers->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:704
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.66 ms** **最後のクエリ以降: 0.19 ms** **クエリメモリ: 0.027 MB Memory before query: 2.963 MB** **返された行: 12**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_offers_rate_prices`

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jhotelreservation/tables/offerrateprices.php:31
15	JTableOfferRatePrices->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:705
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.70 ms** **最後のクエリ以降: 0.16 ms** **クエリメモリ: 0.027 MB Memory before query: 2.988 MB** **返された行: 12**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_rooms_rate_prices`

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jhotelreservation/tables/roomrateprices.php:31
15	JTableRoomRatePrices->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:706
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.56 ms** **最後のクエリ以降: 0.13 ms** **クエリメモリ: 0.026 MB Memory before query: 3.014 MB** **返された行: 4**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_room_availability`

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jhotelreservation/tables/roomavailability.php:31
15	JTableRoomAvailability->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:707
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.34 ms** **最後のクエリ以降: 0.06 ms** **クエリメモリ: 0.057 MB Memory before query: 3.033 MB** **返された行: 0**

select o.* ,hrc.country_id,hc.currency_id,hc.currency_symbol,ot.*, ot.id as rate_id,
	    			IFNULL(r.room_id,ot.room_id) room_id,r.room_name,r.is_available,IFNULL(r.max_adults,ot.base_adults) max_adults,IF(1=1,r.room_capacity,IFNULL(r.max_adults,ot.base_adults)) as room_capacity,
			    	oftr.offerTags,GROUP_CONCAT(hov.voucher) as vouchers,
			    	r.availability as availability, rr.id as room_rate_id
		    	
  from z6j4s_hotelreservation_offers o
	    		
  inner join z6j4s_hotelreservation_offers_rates ot 
  ON ot.offer_id = o.offer_id
		    	
  left join z6j4s_hotelreservation_offers_rooms hor 
  ON ot.offer_id = hor.offer_id 
  and ot.room_id = hor.room_id	
		    	
  left join (select * 
  from z6j4s_hotelreservation_rooms 
  where 1 
  and is_available = 1) r 
  ON hor.room_id = r.room_id
		    	
  left join z6j4s_hotelreservation_rooms_rates rr 
  on r.room_id = rr.room_id
	    		
  left join z6j4s_hotelreservation_offers_vouchers hov 
  on hov.offerId = o.offer_id
	    		
  left join z6j4s_hotelreservation_hotels h	
  ON h.hotel_id = o.hotel_id
	    		
  left join z6j4s_hotelreservation_currencies hc 
  on h.currency_id= hc.currency_id
	    		
  left join z6j4s_hotelreservation_countries hrc 
  on h.country_id= hrc.country_id
	    		
  left join
			    	(select distinct oftr.offerId, GROUP_CONCAT(oft.name 
  order by ordering) as offerTags
			    		
  from z6j4s_hotelreservation_offers_tags_relation oftr
			    		
  left join z6j4s_hotelreservation_offers_tags  oft 
  ON  oft.id 	= oftr.tagId
			    		
  group by oftr.offerId
			    		
  order by oftr.ordering
			    	) oftr	
  ON oftr.offerId = o.offer_id
		    	
  where o.hotel_id = 35 
		    	
  and o.is_available = 1
		    	
  and	IF(o.offer_datasf <> '0000-00-00' 
  AND o.offer_dataef <> '0000-00-00',
		    		DATE(now()) BETWEEN o.offer_datasf  
  AND o.offer_dataef,
			    	IF(o.offer_datasf <> '0000-00-00',
			    		DATE(now()) >= o.offer_datasf,
			    		DATE(now()) <=o.offer_dataef
			    	)
		    	)
		    	
  group by o.offer_id
		    	
  order by o.ordering

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
3	DERIVED	NULL	NULL	NULL	使用可能なインデックスキーがありません	NULL	NULL	NULL	NULL	no matching row in const table
2	DERIVED	z6j4s_hotelreservation_rooms	ALL	NULL	使用可能なインデックスキーがありません	NULL	NULL	76	100.00	Using where

**プロフィール**

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
executing	0.04 ms
statistics	0.05 ms
executing	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/offers.php:299
14	JTableOffers->getHotelOffers()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:718
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.12 ms** **最後のクエリ以降: 0.05 ms** **クエリメモリ: 0.042 MB Memory before query: 3.041 MB** **返された行: 185**

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

select * 
  from z6j4s_hotelreservation_language_translations 
  where type=14 
  and language_tag = 'ja-JP'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:71
15	TableHotelTranslations->getAllTranslationtByLanguageArray()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:82
14	JHotelReservationLanguageTranslations->getAllTranslationtByLanguageArray()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:724
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.65 ms** **最後のクエリ以降: 0.11 ms** **クエリメモリ: 0.025 MB Memory before query: 3.156 MB** **返された行: 1**

**重複クエリ**: #50 #60

select h.*,c.*,c2.description as hotel_currency 
        		  
  from z6j4s_hotelreservation_hotels h
 				  
  left join z6j4s_hotelreservation_countries c 
  on h.country_id=c.country_id
        		  
  left join z6j4s_hotelreservation_currencies 	c2 using (currency_id)
				  
  where  h.hotel_id=35

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c2	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/helpers/utils.php:1006
15	JHotelUtil::getHotel()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:14
14	HotelService::isHotelAvailable()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:727
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.08 ms** **最後のクエリ以降: 0.16 ms** **クエリメモリ: 0.029 MB Memory before query: 3.168 MB** **返された行: 21**

SHOW FULL COLUMNS 
  FROM `z6j4s_hotelreservation_discounts`

**説明**

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

**プロフィール**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.15 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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_jhotelreservation/tables/roomdiscounts.php:30
16	JTableRoomDiscounts->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:622
14	HotelService::applyDiscounts()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:994
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.35 ms** **最後のクエリ以降: 0.14 ms** **クエリメモリ: 0.024 MB Memory before query: 3.197 MB** **返された行: 0**

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

select hcr.room_id,hcr.offer_id,c.start_date, c.end_date
					
  from z6j4s_hotelreservation_confirmations_rooms hcr
					
  inner join z6j4s_hotelreservation_confirmations c 
  on c.confirmation_id= hcr.confirmation_id
					
  where (c.start_date <'2026-03-22' 
  and c.end_date >='2026-03-21') 
						
  and c.reservation_status <> 2 
						 
  and c.hotel_id = 35

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/BookingService.php:58
15	BookingService::getNumberOfBookingsPerDay()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:1346
14	HotelService::checkRoomAvailability()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:996
13	HotelService::getHotelOffers()	JROOT/components/com_jhotelreservation/models/hotel.php:126
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.28 ms** **最後のクエリ以降: 0.19 ms** **クエリメモリ: 0.028 MB Memory before query: 3.094 MB** **返された行: 40**

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

  FROM `z6j4s_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_ffexplorer','com_fields','com_finder','com_installer','com_jhotelreservation','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

**説明**

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

**プロフィール**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.43 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

**コールスタック**

#	コーラー	ファイルと行番号
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_jhotelreservation/helpers/userAccess.php:37
13	isSuperUser()	JROOT/components/com_jhotelreservation/models/hotel.php:189
12	JHotelReservationModelHotel->getOffers()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:43
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.63 ms** **最後のクエリ以降: 0.29 ms** **クエリメモリ: 0.025 MB Memory before query: 3.155 MB** **返された行: 1**

**重複クエリ**: #46 #60

select h.*,c.*,c2.description as hotel_currency 
        		  
  from z6j4s_hotelreservation_hotels h
 				  
  left join z6j4s_hotelreservation_countries c 
  on h.country_id=c.country_id
        		  
  left join z6j4s_hotelreservation_currencies 	c2 using (currency_id)
				  
  where  h.hotel_id=35

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c2	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/helpers/utils.php:1006
15	JHotelUtil::getHotel()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:14
14	HotelService::isHotelAvailable()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:377
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.91 ms** **最後のクエリ以降: 0.04 ms** **クエリメモリ: 0.066 MB Memory before query: 3.164 MB** **返された行: 1**

select *, rr.id as rate_id ,h.reservation_cost_val AS reservation_cost_val,h.reservation_cost_multiple_nights, h.reservation_cost_proc AS reservation_cost_proc,hc.currency_symbol
				
  from z6j4s_hotelreservation_rooms r
				
  inner join z6j4s_hotelreservation_rooms_rates rr 
  on r.room_id = rr.room_id
				
  inner join z6j4s_hotelreservation_hotels h	
  ON h.hotel_id = r.hotel_id
				
  left join z6j4s_hotelreservation_currencies hc 
  on h.currency_id= hc.currency_id
				
  left join z6j4s_hotelreservation_countries hrc 
  on h.country_id= hrc.country_id
				
  where 1  
  and r.is_available = 1 
  and
				#r.front_display=1 
  and
				r.hotel_id= 35 
		        
  order by r.ordering

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	const	PRIMARY	PRIMARY	4	const	1	100.00	filesortレコードの使用
1	SIMPLE	hc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	hrc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	r	ALL	PRIMARY	使用可能なインデックスキーがありません	NULL	NULL	76	100.00	Using where
1	SIMPLE	rr	eq_ref	ROOM_INDEX	ROOM_INDEX	4	LAA1125550-hanamametest.r.room_id	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:400
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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 ファイルに追加します。**]

**クエリ時間: 4.58 ms** **最後のクエリ以降: 0.05 ms** **クエリメモリ: 0.386 MB Memory before query: 3.185 MB** **返された行: 173**

select * 
  from z6j4s_hotelreservation_language_translations 
  where type=2 
  and language_tag = 'ja-JP'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:71
15	TableHotelTranslations->getAllTranslationtByLanguageArray()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:82
14	JHotelReservationLanguageTranslations->getAllTranslationtByLanguageArray()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:406
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.08 ms** **最後のクエリ以降: 0.32 ms** **クエリメモリ: 0.042 MB Memory before query: 3.636 MB** **返された行: 185**

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

select * 
  from z6j4s_hotelreservation_language_translations 
  where type=14 
  and language_tag = 'ja-JP'

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jhotelreservation/tables/hoteltranslations.php:71
15	TableHotelTranslations->getAllTranslationtByLanguageArray()	JROOT/administrator/components/com_jhotelreservation/helpers/jhotelreservationtranslations.php:82
14	JHotelReservationLanguageTranslations->getAllTranslationtByLanguageArray()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:407
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.46 ms** **最後のクエリ以降: 0.12 ms** **クエリメモリ: 0.023 MB Memory before query: 3.752 MB** **返された行: 0**

SELECT date,price,extra_pers_price,child_price,single_use_price,min_days,max_days,lock_arrival,lock_departure,rate_closed  
		           
  FROM z6j4s_hotelreservation_rooms_rate_prices 
		           
  where rate_id = 62 
		           
  and date between '2026-03-21' 
  and '2026-03-22' 
		           
  order by date asc

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_hotelreservation_rooms_rate_prices	range	roomrateprices_rateid_idx	roomrateprices_rateid_idx	7	NULL	1	100.00	Using index condition

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/roomrateprices.php:47
14	JTableRoomRatePrices->getRateDetailsPerPeriod()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:409
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.41 ms** **最後のクエリ以降: 0.04 ms** **クエリメモリ: 0.023 MB Memory before query: 3.759 MB** **返された行: 0**

SELECT date,availability  
		           
  FROM z6j4s_hotelreservation_room_availability 
		           
  where room_id = 81 
		           
  and date between '2026-03-21' 
  and '2026-03-22' 
		           
  order by date asc

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_hotelreservation_room_availability	range	roomavailability_roomid_idx	roomavailability_roomid_idx	7	NULL	1	100.00	Using index condition

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/roomavailability.php:46
14	JTableRoomAvailability->getAvailabilityDetailsPerPeriod()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:410
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.57 ms** **最後のクエリ以降: 0.12 ms** **クエリメモリ: 0.024 MB Memory before query: 3.767 MB** **返された行: 0**

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

SELECT h.*
				   
  FROM z6j4s_hotelreservation_children_categories h
					
  where h.status =  1
					
  and h.hotel_id = 35
					
  ORDER BY h.id asc

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/ChildrenCategoryService.php:18
15	ChildrenCategoryService::getChildrenCategories()	JROOT/components/com_jhotelreservation/classes/services/ChildrenCategoryService.php:151
14	ChildrenCategoryService::getReservationCategoryPrices()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:479
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.28 ms** **最後のクエリ以降: 0.02 ms** **クエリメモリ: 0.024 MB Memory before query: 3.775 MB** **返された行: 0**

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

SELECT h.*
						
  FROM z6j4s_hotelreservation_children_categories h
						
  where h.status =  1
						
  and h.hotel_id = -1
						
  ORDER BY h.id asc

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/ChildrenCategoryService.php:27
15	ChildrenCategoryService::getChildrenCategories()	JROOT/components/com_jhotelreservation/classes/services/ChildrenCategoryService.php:151
14	ChildrenCategoryService::getReservationCategoryPrices()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:479
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.51 ms** **最後のクエリ以降: 0.06 ms** **クエリメモリ: 0.023 MB Memory before query: 3.784 MB** **返された行: 1**

SELECT *
						
  FROM z6j4s_hotelreservation_rooms_pictures
						
  WHERE room_id = 81 
  AND room_picture_enable = 1
						
  ORDER BY room_picture_id

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_hotelreservation_rooms_pictures	ref	Index 2,2	Index 2	4	const	1	100.00	Using where; filesortレコードの使用

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:568
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.44 ms** **最後のクエリ以降: 0.09 ms** **クエリメモリ: 0.024 MB Memory before query: 3.801 MB** **返された行: 0**

SELECT discount_id,
							hotel_id,
							discount_name,
							discount_datas,
							discount_datae,
							if(price_type = 1 , discount_value * 2 , discount_value) as discount_value,
							percent,
							discount_room_ids,
							minimum_number_days,
							minimum_number_persons,
							maximum_number_days,
							reservation_cost_discount,
							check_full_code,
							price_type,
							code

  FROM `z6j4s_hotelreservation_discounts`

  WHERE `is_available` = 1  
  AND	FIND_IN_SET( 81, discount_room_ids  ) 
  and only_on_offers = 0 
			 
  AND '2026-03-21' BETWEEN discount_datas 
  AND discount_datae
             
  AND IF( minimum_number_persons > 0, minimum_number_persons <=2, 1 ) 
  AND IF( minimum_number_days > 0, minimum_number_days <= IF(discount_type = 0, 1,1), 1 )  
  AND IF( maximum_number_days> 0, maximum_number_days >= IF(discount_type = 0,1,1), 1 )  
  AND IF( minimum_amount> 0, minimum_amount <= IF(discount_type = 0,2370,2370) , 1 ) 

  ORDER BY discount_datas

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jhotelreservation/tables/roomdiscounts.php:327
15	JTableRoomDiscounts->getHotelDiscountCoupons()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:645
14	HotelService::applyDiscounts()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:573
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.67 ms** **最後のクエリ以降: 0.04 ms** **クエリメモリ: 0.025 MB Memory before query: 3.802 MB** **返された行: 1**

**重複クエリ**: #46 #50

select h.*,c.*,c2.description as hotel_currency 
        		  
  from z6j4s_hotelreservation_hotels h
 				  
  left join z6j4s_hotelreservation_countries c 
  on h.country_id=c.country_id
        		  
  left join z6j4s_hotelreservation_currencies 	c2 using (currency_id)
				  
  where  h.hotel_id=35

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	h	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c2	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jhotelreservation/helpers/utils.php:1006
15	JHotelUtil::getHotel()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:1442
14	HotelService::setRoomDisplayPrice()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:574
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.30 ms** **最後のクエリ以降: 0.08 ms** **クエリメモリ: 0.024 MB Memory before query: 3.810 MB** **返された行: 0**

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

select hcr.room_id,hcr.offer_id,c.start_date, c.end_date
					
  from z6j4s_hotelreservation_confirmations_rooms hcr
					
  inner join z6j4s_hotelreservation_confirmations c 
  on c.confirmation_id= hcr.confirmation_id
					
  where (c.start_date <'2026-03-22' 
  and c.end_date >='2026-03-21') 
						
  and c.reservation_status <> 2 
						 
  and c.hotel_id = 35

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/BookingService.php:58
15	BookingService::getNumberOfBookingsPerDay()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:1346
14	HotelService::checkRoomAvailability()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:575
13	HotelService::getHotelRooms()	JROOT/components/com_jhotelreservation/models/hotel.php:200
12	JHotelReservationModelHotel->getRooms()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:44
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.25 ms** **最後のクエリ以降: 0.09 ms** **クエリメモリ: 0.022 MB Memory before query: 3.261 MB** **返された行: 0**

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

SELECT h.*
				   
  FROM z6j4s_hotelreservation_children_categories h
					
  where h.status =  1
					
  and h.hotel_id = 35
					
  ORDER BY h.id asc

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/ChildrenCategoryService.php:18
12	ChildrenCategoryService::getChildrenCategories()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:583
11	HotelService::getChildRateDiscounts()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:45
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.25 ms** **最後のクエリ以降: 0.04 ms** **クエリメモリ: 0.022 MB Memory before query: 3.268 MB** **返された行: 0**

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

SELECT h.*
						
  FROM z6j4s_hotelreservation_children_categories h
						
  where h.status =  1
						
  and h.hotel_id = -1
						
  ORDER BY h.id asc

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/ChildrenCategoryService.php:27
12	ChildrenCategoryService::getChildrenCategories()	JROOT/components/com_jhotelreservation/classes/services/HotelService.php:583
11	HotelService::getChildRateDiscounts()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:45
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.27 ms** **最後のクエリ以降: 0.07 ms** **クエリメモリ: 0.022 MB Memory before query: 3.280 MB** **返された行: 5**

SELECT
					h.*
					
  FROM z6j4s_hotelreservation_currencies h
					
  ORDER BY description asc

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jhotelreservation/classes/services/CurrencyService.php:14
11	CurrencyService::getAllCurrencies()	JROOT/components/com_jhotelreservation/views/hotel/view.html.php:69
10	JHotelReservationViewHotel->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jhotelreservation/controller.php:32
8	JHotelReservationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jhotelreservation/jhotelreservation.php:96
6	require_once JROOT/components/com_jhotelreservation/jhotelreservation.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.52 ms** **最後のクエリ以降: 1.26 ms** **クエリメモリ: 0.026 MB Memory before query: 3.421 MB** **返された行: 1**

SELECT language,id

  FROM `z6j4s_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	z6j4s_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	91	100.00	Using where

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.64 ms** **最後のクエリ以降: 13.78 ms** **クエリメモリ: 0.042 MB Memory before query: 3.675 MB** **返された行: 15**

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

  FROM z6j4s_modules AS m

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

  LEFT JOIN z6j4s_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 <= '2026-03-21 13:55:11') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-21 13:55:11') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1079 OR mm.menuid <= 0) 
  AND m.language IN ('ja-JP','*')

  ORDER BY m.position, m.ordering

**説明**

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

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	*下の行にあるコールと同じです。*
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/j-luxury/index.php:184
7	require JROOT/templates/j-luxury/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.90 ms** **最後のクエリ以降: 5.23 ms** **クエリメモリ: 0.041 MB Memory before query: 3.790 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 z6j4s_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-03-21 13:55:11') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-03-21 13:55:11') 
  AND a.language IN ('ja-JP','*')

  ORDER BY a.created DESC 
  LIMIT 3

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_state	1	const	46	100.00	Using where; Using temporary; filesortレコードの使用
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	LAA1125550-hanamametest.a.catid	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	LAA1125550-hanamametest.c.parent_id	1	100.00	Using where
1	SIMPLE	v	ALL	PRIMARY	使用可能なインデックスキーがありません	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

**プロフィール**

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	1.20 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	1.34 ms
Creating sort index	0.20 ms
end	0.02 ms
removing tmp table	0.09 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

**コールスタック**

#	コーラー	ファイルと行番号
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
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: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.95 ms** **最後のクエリ以降: 0.50 ms** **クエリメモリ: 0.028 MB Memory before query: 3.831 MB** **返された行: 3**

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

  FROM `z6j4s_categories` AS `s`

  INNER JOIN `z6j4s_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ja-JP','*')) 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) 
  AND c.published = 1 
  AND s.id = 80

  ORDER BY c.lft

**説明**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesortレコードの使用
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	207	NULL	6	100.00	Using index condition; Using where

**プロフィール**

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

**コールスタック**

#	コーラー	ファイルと行番号
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	*下の行にあるコールと同じです。*
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
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: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 ファイルに追加します。**]

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

テーブルの選択:

**4 × select * 
  from z6j4s_hotelreservation_language_translations**

**3 × select h.*,c.*,c2.description as hotel_currency              
  from z6j4s_hotelreservation_hotels h        
  left join z6j4s_hotelreservation_countries c 
  on h.country_id=c.country_id             
  left join z6j4s_hotelreservation_currencies  c2 using (currency_id)**

**3 × select * 
  from  z6j4s_hotelreservation_language_translations**

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

**2 × select hcr.room_id,hcr.offer_id,c.start_date, c.end_date
      
  from z6j4s_hotelreservation_confirmations_rooms hcr
      
  inner join z6j4s_hotelreservation_confirmations c 
  on c.confirmation_id= hcr.confirmation_id**

**2 × SELECT h.*
       
  FROM z6j4s_hotelreservation_children_categories h**

**2 × SELECT h.*
        
  FROM z6j4s_hotelreservation_children_categories h**

**1 × SELECT `data` 
  FROM `z6j4s_session`**

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

**1 × select * 
  FROM z6j4s_hotelreservation_hotel_payment_options hpo
   
  inner join z6j4s_hotelreservation_hotel_payment_option_relation hpor 
  on hpo.id=hpor.paymentOptionId**

**1 × select SQL_CALC_FOUND_ROWS rc.*,hc.*, avg(rs.weight) as average
       
  from z6j4s_hotelreservation_review_answers ra 
       
  inner join z6j4s_hotelreservation_review_customers rc 
  on ra.review_id = rc.review_id
       
  inner join z6j4s_hotelreservation_review_questions rq 
  on ra.review_question_id = rq.review_question_id 
       
  inner join z6j4s_hotelreservation_review_rating_scale rs 
  on rs.rating_scale_id = ra.rating_scale_id
       
  inner join z6j4s_hotelreservation_confirmations hc 
  on rc.confirmation_id=hc.confirmation_id**

**1 × select      h.hotel_id, h.hotel_name,h.hotel_alias,h.hotel_short_description as hotel_description, h.hotel_county, h.hotel_city, h.hotel_address, h.hotel_zipcode, h.hotel_website, h.hotel_stars, h.hotel_rating_score, h.featured, h.hotel_selling_points, h.recommended, h.hotel_phone, h.hotel_number,h.hotel_latitude,h.hotel_longitude,      h.hotel_stars as hstars,hh10.room_min_rate,hh9.totalRoomsAvailable,hh9.searchRoomIds,hc.totalReserved,      (hh9.totalRoomsAvailable-IFNULL(hc.totalReserved,0)) as roomsLeft,      IF(hh11.min_offer_price IS NULL OR hh10.room_min_rate IS NULL, COALESCE(hh11.min_offer_price, hh10.room_min_rate), LEAST(hh11.min_offer_price,hh10.room_min_rate))  as lowest_hotel_price,       hh11.offer_available,hh11.hotelOffersIds,      1.609344*3956 * 2 * ASIN(SQRT( POWER(SIN((36.717905 -abs( h.hotel_latitude)) * pi()/180 / 2),2) + COS(36.717905 * pi()/180 ) * COS( abs(h.hotel_latitude) *  pi()/180) * POWER(SIN((138.63865 - h.hotel_longitude) *  pi()/180 / 2), 2) )) as distance ,           currency_symbol,      hc.noBookings,      offer_details,       noReviews,      c1.country_name,      c2.description AS hotel_currency,      hotel_picture_path,hotel_picture_info,hotel_pictures_count,      hlt.content as hotel_description,       hh8.* 
  from (      SELECT h.hotel_id, facilities, types,accommodationTypes, enviroments,regions,1 as room_available,themes,noReviews                  
  from                       (select h.hotel_id 
  from z6j4s_hotelreservation_hotels as h**

**1 × select o.* ,hrc.country_id,hc.currency_id,hc.currency_symbol,ot.*, ot.id as rate_id,
         IFNULL(r.room_id,ot.room_id) room_id,r.room_name,r.is_available,IFNULL(r.max_adults,ot.base_adults) max_adults,IF(1=1,r.room_capacity,IFNULL(r.max_adults,ot.base_adults)) as room_capacity,
         oftr.offerTags,GROUP_CONCAT(hov.voucher) as vouchers,
         r.availability as availability, rr.id as room_rate_id
        
  from z6j4s_hotelreservation_offers o
        
  inner join z6j4s_hotelreservation_offers_rates ot 
  ON ot.offer_id = o.offer_id
        
  left join z6j4s_hotelreservation_offers_rooms hor 
  ON ot.offer_id = hor.offer_id 
  and ot.room_id = hor.room_id 
        
  left join (select * 
  from z6j4s_hotelreservation_rooms**

**1 × SELECT date,availability  
              
  FROM z6j4s_hotelreservation_room_availability**

**1 × select *, rr.id as rate_id ,h.reservation_cost_val AS reservation_cost_val,h.reservation_cost_multiple_nights, h.reservation_cost_proc AS reservation_cost_proc,hc.currency_symbol
     
  from z6j4s_hotelreservation_rooms r
     
  inner join z6j4s_hotelreservation_rooms_rates rr 
  on r.room_id = rr.room_id
     
  inner join z6j4s_hotelreservation_hotels h 
  ON h.hotel_id = r.hotel_id
     
  left join z6j4s_hotelreservation_currencies hc 
  on h.currency_id= hc.currency_id
     
  left join z6j4s_hotelreservation_countries hrc 
  on h.country_id= hrc.country_id**

**1 × SELECT date,price,extra_pers_price,child_price,single_use_price,min_days,max_days,lock_arrival,lock_departure,rate_closed  
              
  FROM z6j4s_hotelreservation_rooms_rate_prices**

**1 × SELECT *
       
  FROM z6j4s_hotelreservation_rooms_pictures**

**1 × SELECT discount_id,        hotel_id,        discount_name,        discount_datas,        discount_datae,        if(price_type = 1 , discount_value * 2 , discount_value) as discount_value,        percent,        discount_room_ids,        minimum_number_days,        minimum_number_persons,        maximum_number_days,        reservation_cost_discount,        check_full_code,        price_type,        code 
  FROM `z6j4s_hotelreservation_discounts`**

**1 × SELECT
      h.*
      
  FROM z6j4s_hotelreservation_currencies h**

**1 × SELECT language,id 
  FROM `z6j4s_menu`**

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

**1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN 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 z6j4s_content AS a 
  LEFT JOIN z6j4s_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN z6j4s_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN z6j4s_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN z6j4s_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN z6j4s_content_rating AS v 
  ON a.id = v.content_id**

**1 × select * 
  FROM z6j4s_hotelreservation_hotel_informations**

**1 × select rq.review_question_id,rq.review_question_desc as question, avg(rs.weight) as average
      
  from z6j4s_hotelreservation_review_answers ra 
      
  inner join z6j4s_hotelreservation_review_customers rc 
  on ra.review_id = rc.review_id
      
  inner join z6j4s_hotelreservation_review_questions rq 
  on ra.review_question_id = rq.review_question_id 
      
  inner join z6j4s_hotelreservation_review_rating_scale rs 
  on rs.rating_scale_id = ra.rating_scale_id**

**1 × SELECT `session_id` 
  FROM `z6j4s_session`**

**1 × select * 
  from z6j4s_hotelreservation_offers of
      
  inner join z6j4s_hotelreservation_offers_vouchers hov 
  on of.offer_id = hov.offerId**

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

**1 × SELECT b.id 
  FROM z6j4s_usergroups AS a 
  LEFT JOIN z6j4s_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 z6j4s_extensions**

**1 × SELECT * 
  FROM z6j4s_languages**

**1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `z6j4s_extensions`**

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

**1 × SELECT * 
  FROM z6j4s_hotelreservation_applicationsettings fas       
  inner join  z6j4s_hotelreservation_date_formats df 
  on fas.date_format_id=df.i**

**1 × SELECT * 
  FROM `z6j4s_hotelreservation_hotels`**

**1 × select * 
  from(          select id,name,description,poi_latitude,poi_longitude,activity_radius,poi_address,poi_city,poi_zipcode,poi_county,           111.1111 * DEGREES(ACOS(COS(RADIANS(36.717905))                 * COS(RADIANS(poi_latitude))                 * COS(RADIANS(138.63865 - poi_longitude))                 + SIN(RADIANS(36.717905))                   * SIN(RADIANS(poi_latitude)))) AS distance           
  from z6j4s_hotelreservation_points_of_interest**

**1 × SELECT id, home, template, s.params 
  FROM z6j4s_template_styles as s 
  LEFT JOIN z6j4s_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `z6j4s_menu` AS `c` 
  INNER JOIN `z6j4s_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `z6j4s_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `z6j4s_menu` AS `c2` 
  ON a2.id = c2.`id`**

**1 × SELECT
      h.*,
      c1.country_name,
      c2.description AS hotel_currency, c2.currency_symbol AS currency_symbol
      
  FROM z6j4s_hotelreservation_hotels    h
      
  LEFT JOIN z6j4s_hotelreservation_countries  c1 USING (country_id)
      
  LEFT JOIN z6j4s_hotelreservation_currencies  c2 USING (currency_id)**

**1 × SELECT *
     
  FROM z6j4s_hotelreservation_hotel_pictures**

**1 × SELECT hf.*
      
  FROM z6j4s_hotelreservation_hotel_facilities hf
      
  inner join  z6j4s_hotelreservation_hotel_facility_relation hfc 
  on hf.id = hfc.facilityId**

**1 × SELECT hf.*
      
  FROM z6j4s_hotelreservation_hotel_types hf
      
  inner join  z6j4s_hotelreservation_hotel_type_relation hfc 
  on hf.id = hfc.typeId**

**1 × SELECT * 
  from z6j4s_hotelreservation_hotel_channel_manager**

**1 × SELECT hc.booking_email 
  from z6j4s_hotelreservation_hotel_contacts as hc**

**1 × 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 `z6j4s_categories` AS `s` 
  INNER JOIN `z6j4s_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ja-JP','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)**

その他のテーブル:

**1 × INSERT INTO `z6j4s_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'74676e61723436707267306230386f733635677370746d367530', 1, 1774101311, 0, '', 0**

**1 × UPDATE `z6j4s_extensions` 
  SET `params` = '{\"mediaversion\":\"b3ee4d0c95b4835e4be4b76e15071a7e\"}'**

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

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

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

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

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

**1 × 
  SET SESSION group_concat_max_len = 100000**

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

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

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

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

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

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

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

**読み込みました** : 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_sppagebuilder.ini
**未読み込み** : JROOT/administrator/language/ja-JP/plg_system_sppagebuilder.ini
**未読み込み** : JROOT/plugins/system/sppagebuilder/language/ja-JP/ja-JP.plg_system_sppagebuilder.ini
**未読み込み** : JROOT/plugins/system/sppagebuilder/language/ja-JP/plg_system_sppagebuilder.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_updatenotification.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_logrotation.ini
**未読み込み** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_helix3.ini
**未読み込み** : JROOT/administrator/language/ja-JP/plg_system_helix3.ini
**未読み込み** : JROOT/plugins/system/helix3/language/ja-JP/ja-JP.plg_system_helix3.ini
**未読み込み** : JROOT/plugins/system/helix3/language/ja-JP/plg_system_helix3.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_fields.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_logout.ini
**未読み込み** : JROOT/language/ja-JP/ja-JP.tpl_j-luxury.ini
**未読み込み** : JROOT/language/ja-JP/tpl_j-luxury.ini
**未読み込み** : JROOT/templates/j-luxury/language/ja-JP/ja-JP.tpl_j-luxury.ini
**未読み込み** : JROOT/templates/j-luxury/language/ja-JP/tpl_j-luxury.ini
**未読み込み** : JROOT/language/ja-JP/ja-JP.com_jhotelreservation.ini
**未読み込み** : JROOT/language/ja-JP/com_jhotelreservation.ini
**未読み込み** : JROOT/components/com_jhotelreservation/language/ja-JP/ja-JP.com_jhotelreservation.ini
**未読み込み** : JROOT/components/com_jhotelreservation/language/ja-JP/com_jhotelreservation.ini
**読み込みました** : JROOT/administrator/components/com_jhotelreservation/language/ja-JP/ja-JP.com_jhotelreservation.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.com_users.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.mod_menu.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.mod_articles_latest.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.mod_custom.ini
**読み込みました** : JROOT/language/ja-JP/ja-JP.mod_breadcrumbs.ini
**読み込みました** : JROOT/administrator/language/ja-JP/ja-JP.plg_system_debug.ini

テントサイト予約はこちら