初期費用分割相談可特集 2/8ページ

この物件は大家さんの直接募集だから仲介手数料無料です

フレンチカントリーの白いお部屋（南ドイツグローエセキュリティー）: 完全セキュリティーの本格デザイナーズにようこそ!! ・スイス製ICオートロックにて共有玄関開錠(スイス銀行納品メーカー) ・スイス製デュ…

建物名	ＣｌａｉｒｅＨａｇｉｙａｍａ
住所	東京都東村山市萩山町1-9-5
最寄駅	西武新宿線小平駅徒歩5分
物件種別	マンション
築年月、所在階	1994年5月築、 1階/4階建

この賃貸マンションの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
ＣｌａｉｒｅＨａｇｉｙａｍａ南ドイツグローエセキュリティーフリーレント初期費用分割可インターネット無料駅近セキュリティ				詳細・内見はこちら
39,000円	11,000円	敷金0/礼金0	1K（20.10m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

大家さんの
プロフィール

2018年リフォーム済み。日当たり良好（201）: ＝＝＝＝＝＝＝＝＝＝＝＝＝＝所在地・・堺市堺区寺地町東４丁交通・・・寺地町駅　徒歩3分　　　　　堺東駅　徒歩15分　　　　　…

建物名	寺地文化２
住所	大阪府堺市堺区寺地町東4-1-4
最寄駅	阪堺電軌阪堺線寺地町駅徒歩5分
物件種別	アパート
築年月、所在階	1972年7月築、 2階/2階建

この賃貸アパートの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
寺地文化２201 ペット相談可初期費用分割可駅近 2人以上入居可能				詳細・内見はこちら
19,000円	1,000円	敷金0/礼金0	2K（19.00m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

大家さんの
プロフィール

☆４６㎡２ＤＫ残１戸☆『東・西・南・北、湘南リゾート』湘南周回行動派の拠点♪　　　Wi-fi込み♪/湘南無農薬野菜サービス/IH2口/便利＆うれしいがもりだくさん♪＾＾（1F）: ◎南・東・北側に窓ありの角部屋で、採光も良好♪ ◎オールフローリング…

建物名	リディアエムズ鎌倉
住所	神奈川県鎌倉市手広3丁目
最寄駅	JR東海道本線藤沢駅バス8分　バス停下車徒歩2分
物件種別	アパート
築年月、所在階	1997年9月築、 1階/2階建

この賃貸アパートの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
リディアエムズ鎌倉1F 初期費用分割可インターネット無料 2人以上入居可能				詳細・内見はこちら
85,000円	4,000円	敷金0/礼金1ヶ月	2DK（45.95m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

駅から4分、インターネット&デジタルチューナー無料、始発電車多く、都内どこへでも可能なサラリーマン、学生向け、アパート。（203）: 駅から近く(徒歩4分)、始発電車多く、都内どこでも通勤可能です。イ…

建物名	ルミエハイツ
住所	東京都日野市豊田3-37-25
最寄駅	JR中央線(快速)豊田駅徒歩4分
物件種別	アパート
築年月、所在階	1985年7月築、 2階/2階建

この賃貸アパートの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
ルミエハイツ203 初期費用分割可インターネット無料駅近				詳細・内見はこちら
29,000円	0円	敷金1ヶ月/礼金0	1K（17.40m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

大家さんの
プロフィール

ファミリー向けのペットも飼える物件です!: 8帖ほどの広いバルコニーのある､ペット可のファミリー向け物件です｡新しいフローリングが貼られました｡ 3面からの日当たり、風通しが良好…

建物名	松戸・中根戸建貸家
住所	千葉県松戸市中根160番地
最寄駅	JR常磐線(上野～取手)北松戸駅徒歩7分
物件種別	戸建
築年月、所在階	1974年8月築、 2階建

この賃貸戸建の空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
松戸・中根戸建貸家ペット相談可初期費用分割可 2人以上入居可能				詳細・内見はこちら
75,000円	0円	敷金0/礼金0	3DK（47.91m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

大家さんの
プロフィール

✨あと一部屋！早い者勝ち✨✨新築✨横浜駅まで徒歩19分！駅まで平坦！！初期費用抑えるプランあり！！！】（101）: 平成30年1月築です。横浜駅まで19分ですが、平坦です。徒歩3分圏内…

建物名	アーヴェル浅間台
住所	神奈川県横浜市西区浅間台71-30
最寄駅	JR東海道本線横浜駅徒歩19分
物件種別	アパート
築年月、所在階	2018年1月築、 1階/2階建

この賃貸アパートの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
アーヴェル浅間台101 初期費用分割可インターネット無料				詳細・内見はこちら
56,000円	5,000円	敷金0/礼金0	ワンルーム（13.03m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

大家さんの
プロフィール

【初期費用0円、更新料0円、インターネット無料、家具付き、即入居可能!】（１０３号室）: ＜初期費用＞・賃料：28000円・管理費：4000円(水道代込み) ・火…

建物名	ラフィーネ秋ヶ瀬
住所	埼玉県さいたま市桜区下大久保1699-3
最寄駅	JR埼京線南与野駅バス14分　バス停下車徒歩8分
物件種別	アパート
築年月、所在階	1990年2月築、 1階/2階建

この賃貸アパートの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
ラフィーネ秋ヶ瀬１０３号室フリーレント初期費用分割可インターネット無料				詳細・内見はこちら
28,000円	4,000円	敷金0/礼金0	ワンルーム（16.00m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

京成本線大和田駅徒歩15分（201号室）: 静かで見晴らしが良いです。 PayPayでのお支払い可能。(賃料、管理料などの可能) クレジットの利用は可。（大家のクレジットカード機械に…

建物名	ノエルガーデン(高津東)
住所	千葉県八千代市高津東3-8-5
最寄駅	京成本線京成大和田駅徒歩15分
物件種別	アパート
築年月、所在階	1999年6月築、 2階/2階建

この賃貸アパートの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
ノエルガーデン(高津東)201号室初期費用分割可 2人以上入居可能				詳細・内見はこちら
42,000円	4,000円	敷金1.1ヶ月/礼金0	1LDK（34.78m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

大家さんの
プロフィール

【多頭飼育Ok!初期費用がなんと０円？】戸建(テラス)【DIY可物件】＿狭山市根岸（Girasol　狭山２）: 多頭飼育ok!！！今なら初期費用がなんと０円？ DIY可！【物件情…

建物名	Girasol 狭山２
住所	埼玉県狭山市根岸1-3-5
最寄駅	西武新宿線狭山市駅バス10分　バス停下車徒歩2分
物件種別	テラスハウス
築年月、所在階	1976年5月築、 1階/2階建

この賃貸テラスハウスの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
Girasol 狭山２Girasol　狭山２ペット相談可初期費用分割可 2人以上入居可能				詳細・内見はこちら
59,000円	6,000円	敷金0/礼金0	3DK（57.13m²）	詳細・内見はこちら

この物件は大家さんの直接募集だから仲介手数料無料です

大家さんの
プロフィール

南向き角部屋日当たり良好！デザインリノベーション！スーパー徒歩1分！ペット要相談☆セキュリティー強化（101）: オシャレな北欧系をイメージしたデザインリノベーションをしました。 …

建物名	スカイハイツ久米川
住所	東京都東村山市美住町1-14-22
最寄駅	西武新宿線久米川駅徒歩12分
物件種別	アパート
築年月、所在階	1990年3月築、 1階/2階建

この賃貸アパートの空室情報

賃料	管理費	敷金/礼金	間取り（専有面積）
スカイハイツ久米川101 ペット相談可初期費用分割可インターネット無料セキュリティ 2人以上入居可能				詳細・内見はこちら
63,000円	2,000円	敷金1ヶ月/礼金0	2DK（31.39m²）	詳細・内見はこちら

10

Console

1.369 s

Load Time

68 Queries

Database

10.10 MB

Memory Used

165 Files

Included

743 Config

items loaded

18 Session

vars loaded

1 GET

vars loaded

0 POST

vars loaded

`3` Logs	`0` Errors
`0` Memory	`7` Speed

speed	0.862 ms Fuel\Core\Profiler::init Start
speed	2.928 ms Fuel\Core\Fuel::init End
speed	2.982 ms Fuel\Core\Uri::__construct Start
speed	3.031 ms Fuel\Core\Uri::__construct End
log	Fuel\Core\Request::__construct - Creating a new Request with URI = "chintai/feature/installment"
speed	3.512 ms Fuel\Core\Request::execute Start
log	Fuel\Core\Request::execute - Called
log	Fuel\Core\Request::execute - Setting main Request
speed	485.283 ms Fuel\Core\Request::execute End
speed	1.193 s End of Fuel Execution

1.369 s

Load Time

240 s

Max Execution Time

0.862 ms

Fuel\Core\Profiler::init Start

2.928 ms

Fuel\Core\Fuel::init End

2.982 ms

Fuel\Core\Uri::__construct Start

3.031 ms

Fuel\Core\Uri::__construct End

3.512 ms

Fuel\Core\Request::execute Start

485.283 ms

Fuel\Core\Request::execute End

1.193 s

End of Fuel Execution

68

Total Queries

273.010 ms

Total Time

0

Duplicates

SELECT DISTINCT sub.building_id AS id FROM (SELECT b.id AS building_id,r.id AS room_id,r.updated_at,(SELECT COUNT(1) FROM rooms WHERE building_id=b.id AND (use_flg=0 OR use_flg=3 OR ( use_flg=4 AND seiyaku_date>(NOW()-INTERVAL 72 HOUR)))) AS room_count FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id AND ( r.use_flg = 0 OR r.use_flg = 3 OR ( r.use_flg = 4 AND r.seiyaku_date > (NOW() - INTERVAL 72 HOUR) ) OR (r.building_id IN (SELECT DISTINCT building_id FROM wait_room WHERE del_flg=0 AND enabled=1)) ) INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 INNER JOIN mst_user AS agent ON agent.id=b.agent_id AND agent.del_flg=0 AND agent.agent_approval=2 LEFT JOIN mst_city AS mc ON mc.area_cd=b.area_cd LEFT JOIN buildings_root AS br ON br.building_id=b.id LEFT JOIN buildings_word AS bw ON bw.building_id=b.id LEFT JOIN rooms_word AS rw ON rw.room_id=r.id LEFT JOIN rooms_discount AS rd ON rd.room_id=r.id AND rd.del_flg=0 AND rd.legal_check<>2 AND rd.legal_check<>3 LEFT JOIN (SELECT room_id,COUNT(room_id) AS favorite_count FROM favorite GROUP BY room_id) AS fv ON fv.room_id=r.id LEFT JOIN wait_room AS wr ON wr.building_id=b.id AND wr.del_flg=0 AND wr.enabled=1 WHERE b.use_flg = 0 AND mc.is_target_city = 1 AND r.id IN (SELECT room_id FROM room_feature WHERE feature_id = 7) ORDER BY (SELECT COUNT(1) FROM rooms WHERE building_id=b.id AND (use_flg=0 OR use_flg=3 OR ( use_flg=4 AND seiyaku_date>(NOW()-INTERVAL 72 HOUR))))=0 ASC, r.updated_at DESC) AS sub LIMIT 10 OFFSET 10Speed: 30.972 ms
Query analysis:
· Query: PRIMARY on <derived2> · Type: ALL · Rows: 335 (Using temporary)
· Query: DERIVED on room_feature · Possible keys: room_feature_idx1,room_feature_idx2 · Key Used: room_feature_idx1 · Type: ref · Rows: 94 (Using temporary; Using filesort; Start temporary)
· Query: DERIVED on r · Possible keys: PRIMARY,building_id,use_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg,area_cd · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on mc · Possible keys: mst_city_idx2,is_target_city · Key Used: mst_city_idx2 · Type: ref · Rows: 1 (Using where)
· Query: DERIVED on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where; End temporary)
· Query: DERIVED on br · Possible keys: building_id · Key Used: building_id · Type: ref · Rows: 2 (Using index)
· Query: DERIVED on bw · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index)
· Query: DERIVED on rw · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index)
· Query: DERIVED on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on <derived5> · Possible keys: · Key Used: · Type: ref · Rows: 10 (Using where)
· Query: DERIVED on wr · Type: ALL · Rows: 99 (Using where; Using join buffer (hash join))
· Query: DEPENDENT SUBQUERY on rooms · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where)
· Query: DERIVED on favorite · Possible keys: room_id · Key Used: room_id · Type: index · Rows: 17888 (Using index)
· Query: SUBQUERY on wait_room · Type: ALL · Rows: 99 (Using where)
· Query: DEPENDENT SUBQUERY on rooms · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/controller/buildings.php, line 333File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(*) AS `total_rows` FROM (SELECT DISTINCT sub.building_id AS id FROM (SELECT b.id AS building_id,r.id AS room_id,r.updated_at,(SELECT COUNT(1) FROM rooms WHERE building_id=b.id AND (use_flg=0 OR use_flg=3 OR ( use_flg=4 AND seiyaku_date>(NOW()-INTERVAL 72 HOUR)))) AS room_count FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id AND ( r.use_flg = 0 OR r.use_flg = 3 OR ( r.use_flg = 4 AND r.seiyaku_date > (NOW() - INTERVAL 72 HOUR) ) OR (r.building_id IN (SELECT DISTINCT building_id FROM wait_room WHERE del_flg=0 AND enabled=1)) ) INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 INNER JOIN mst_user AS agent ON agent.id=b.agent_id AND agent.del_flg=0 AND agent.agent_approval=2 LEFT JOIN mst_city AS mc ON mc.area_cd=b.area_cd LEFT JOIN buildings_root AS br ON br.building_id=b.id LEFT JOIN buildings_word AS bw ON bw.building_id=b.id LEFT JOIN rooms_word AS rw ON rw.room_id=r.id LEFT JOIN rooms_discount AS rd ON rd.room_id=r.id AND rd.del_flg=0 AND rd.legal_check<>2 AND rd.legal_check<>3 LEFT JOIN (SELECT room_id,COUNT(room_id) AS favorite_count FROM favorite GROUP BY room_id) AS fv ON fv.room_id=r.id LEFT JOIN wait_room AS wr ON wr.building_id=b.id AND wr.del_flg=0 AND wr.enabled=1 WHERE b.use_flg = 0 AND mc.is_target_city = 1 AND r.id IN (SELECT room_id FROM room_feature WHERE feature_id = 7) ORDER BY (SELECT COUNT(1) FROM rooms WHERE building_id=b.id AND (use_flg=0 OR use_flg=3 OR ( use_flg=4 AND seiyaku_date>(NOW()-INTERVAL 72 HOUR))))=0 ASC, r.updated_at DESC) AS sub ) AS `counted_results`Speed: 29.925 ms
Query analysis:
· Query: PRIMARY on <derived2> · Type: ALL · Rows: 335
· Query: DERIVED on <derived3> · Type: ALL · Rows: 335 (Using temporary)
· Query: DERIVED on room_feature · Possible keys: room_feature_idx1,room_feature_idx2 · Key Used: room_feature_idx1 · Type: ref · Rows: 94 (Using temporary; Using filesort; Start temporary)
· Query: DERIVED on r · Possible keys: PRIMARY,building_id,use_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg,area_cd · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on mc · Possible keys: mst_city_idx2,is_target_city · Key Used: mst_city_idx2 · Type: ref · Rows: 1 (Using where)
· Query: DERIVED on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where; End temporary)
· Query: DERIVED on br · Possible keys: building_id · Key Used: building_id · Type: ref · Rows: 2 (Using index)
· Query: DERIVED on bw · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index)
· Query: DERIVED on rw · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index)
· Query: DERIVED on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DERIVED on <derived6> · Possible keys: · Key Used: · Type: ref · Rows: 10 (Using where)
· Query: DERIVED on wr · Type: ALL · Rows: 99 (Using where; Using join buffer (hash join))
· Query: DEPENDENT SUBQUERY on rooms · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where)
· Query: DERIVED on favorite · Possible keys: room_id · Key Used: room_id · Type: index · Rows: 17888 (Using index)
· Query: SUBQUERY on wait_room · Type: ALL · Rows: 99 (Using where)
· Query: DEPENDENT SUBQUERY on rooms · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where)
Call trace for this query:File: COREPATH/classes/db.php, line 334File: APPPATH/modules/client/classes/controller/buildings.php, line 335File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `b`.`id`, `b`.`owner_id`, `b`.`agent_id`, `b`.`use_flg`, `b`.`building_name`, `b`.`zip_code`, `b`.`pref_id`, `b`.`area_cd`, `c`.`address2` AS `address`, `b`.`address_other`, `b`.`construction_year`, `b`.`construction_month`, `b`.`floor_max`, `b`.`floor_under_max`, `b`.`type`, `b`.`structure`, `b`.`ownership_type`, `b`.`car_parking`, `b`.`car_space`, `b`.`car_price`, `b`.`motorcycle_parking`, `b`.`motorcycle_space`, `b`.`motorcycle_price`, `b`.`bicycles_parking`, `b`.`bicycles_space`, `b`.`bicycles_price`, `b`.`movie_url`, `b`.`lat`, `b`.`lng`, `b`.`initial_cost`, `b`.`created_at`, `b`.`updated_at`, `o`.`id` AS `owner_id`, `o`.`face_image` AS `owner_face_image`, `o`.`building_checked_at` AS `owner_building_checked_at`, `o`.`is_card_read_agree`, `o`.`card_agree_date`, `o`.`is_appealed`, `oa`.`nickname`, `agent`.`id` AS `agent_id`, `agent`.`del_flg` AS `agent_del_flg`, `agent`.`agent_approval` AS `agent_approval`, `wr`.`id` AS `wait_room_id`, `wr`.`lower_limit` AS `wait_room_lower_limit`, `wr`.`upper_limit` AS `wait_room_upper_limit`, `wr`.`pr_building_title` AS `wait_room_pr_building_title`, `wr`.`pr_building_comment` AS `wait_room_pr_building_comment` FROM `buildings` AS `b` LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id` AND `o`.`del_flg` = 0) LEFT JOIN `mst_user` AS `agent` ON (`b`.`agent_id` = `agent`.`id`) LEFT JOIN `mst_city` AS `c` ON (`b`.`area_cd` = `c`.`area_cd`) LEFT JOIN `owner_attributes` AS `oa` ON (`b`.`owner_id` = `oa`.`id` AND `oa`.`del_flg` = 0) LEFT JOIN `wait_room` AS `wr` ON (`b`.`id` = `wr`.`building_id` AND `wr`.`del_flg` = 0 AND `wr`.`enabled` = 1) LEFT JOIN `rooms` AS `r1` ON (`b`.`id` = `r1`.`building_id`) LEFT JOIN `rooms` AS `r2` ON (`r1`.`id` = `r2`.`id` AND `r1`.`updated_at` < `r2`.`updated_at` AND `r1`.`use_flg` IN (0,3,4)) WHERE `b`.`use_flg` = 0 AND `b`.`id` IN ('3156', '11603', '151', '724', '8664', '8969', '10946', '11095', '10392', '5873') ORDER BY `r1`.`updated_at` DESCSpeed: 7.379 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: range · Rows: 10 (Using where; Using temporary; Using filesort)
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1
· Query: SIMPLE on c · Possible keys: mst_city_idx2 · Key Used: mst_city_idx2 · Type: ref · Rows: 1
· Query: SIMPLE on oa · Possible keys: PRIMARY,owner_attributes_idx1 · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on wr · Type: ALL · Rows: 99 (Using where; Using join buffer (hash join))
· Query: SIMPLE on r1 · Possible keys: building_id · Key Used: building_id · Type: ref · Rows: 2
· Query: SIMPLE on r2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 607File: APPPATH/modules/client/classes/model/buildings.php, line 67File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT DISTINCT `ln`.`line_cd`, `ln`.`line_name`, `st`.`station_cd`, `st`.`station_g_cd`, `st`.`station_name`, `br`.`move_kbn`, `br`.`walk_time`, `br`.`bus_time`, `br`.`building_id` FROM `buildings_root` AS `br` LEFT JOIN `mst_station` AS `st` ON (`br`.`station_cd` = `st`.`station_cd`) LEFT JOIN `mst_line` AS `ln` ON (`st`.`line_cd` = `ln`.`line_cd`) WHERE `br`.`building_id` IN ('3156', '11603', '151', '724', '8664', '8969', '10946', '11095', '10392', '5873') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.934 ms
Query analysis:
· Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: range · Rows: 30 (Using index condition; Using temporary; Using filesort)
· Query: SIMPLE on st · Possible keys: station_cd · Key Used: station_cd · Type: ref · Rows: 1 (Using index condition)
· Query: SIMPLE on ln · Possible keys: line_cd · Key Used: line_cd · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 642File: APPPATH/modules/client/classes/model/buildings.php, line 67File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 1 AND `af`.`article_id` IN ('3156', '11603', '151', '724', '8664', '8969', '10946', '11095', '10392', '5873') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 8.000 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: range · Rows: 122 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 74File: APPPATH/modules/client/classes/model/buildings.php, line 657File: APPPATH/modules/client/classes/model/buildings.php, line 67File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 1 AND `ai`.`article_id` IN ('3156', '11603', '151', '724', '8664', '8969', '10946', '11095', '10392', '5873') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 18.169 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: range · Rows: 155 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 67File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `id` FROM `owner_search` WHERE `del_flg` = 0 AND `id` IN ('21978', '46970', '647', '14436', '16971', '35979', '44057', '44713', '26112', '28207')Speed: 2.186 ms
Query analysis:
· Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: owner_search_idx1 · Type: range · Rows: 10 (Using where; Using index)
Call trace for this query:File: APPPATH/classes/model/owner/search.php, line 49File: APPPATH/modules/client/classes/model/buildings.php, line 708File: APPPATH/modules/client/classes/model/buildings.php, line 67File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '3156'Speed: 2.327 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 10 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '3156' ORDER BY `room_name` ASCSpeed: 2.496 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 10 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('7616') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.433 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('7616') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.338 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 16 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('7616')Speed: 2.036 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 9
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '11603'Speed: 2.160 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '11603' ORDER BY `room_name` ASCSpeed: 2.402 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('29375') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.319 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 12 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('29375') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.268 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('29375')Speed: 2.044 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 10
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '151'Speed: 2.192 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 8 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '151' ORDER BY `room_name` ASCSpeed: 2.486 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 8 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('306') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.342 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 19 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('306') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.257 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('306')Speed: 1.973 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 8
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '724'Speed: 2.200 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 5 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '724' ORDER BY `room_name` ASCSpeed: 2.390 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 5 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('1032') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 3.250 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 8 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('1032') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 8.046 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 20 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('1032')Speed: 2.067 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 5
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '8664'Speed: 2.221 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '8664' ORDER BY `room_name` ASCSpeed: 2.509 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('20707') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.368 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('20707') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.276 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('20707')Speed: 2.027 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 11
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '8969'Speed: 2.140 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '8969' ORDER BY `room_name` ASCSpeed: 2.323 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('21510') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.297 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('21510') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.308 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('21510')Speed: 2.009 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 7
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '10946'Speed: 2.253 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 4 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '10946' ORDER BY `room_name` ASCSpeed: 2.429 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 4 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('27836') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.280 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 10 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('27836') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.261 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('27836')Speed: 2.017 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 9
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '11095'Speed: 2.162 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '11095' ORDER BY `room_name` ASCSpeed: 2.350 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('27997') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.313 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 16 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('27997') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.239 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('27997')Speed: 1.996 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 5
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '10392'Speed: 2.139 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '10392' ORDER BY `room_name` ASCSpeed: 2.320 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('25179') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.287 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('25179') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.206 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('25179')Speed: 1.967 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 6
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '5873'Speed: 2.171 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 4 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 77File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '5873' ORDER BY `room_name` ASCSpeed: 2.378 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 4 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('29300') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.352 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 20 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('29300') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.260 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('29300')Speed: 2.025 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 9
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 83File: APPPATH/modules/client/classes/controller/buildings.php, line 350File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT DISTINCT c.pref_cd AS pref_id, c.area_cd, p.pref_name_j AS pref_name, c.address2, p.disp_rank FROM mst_city AS c LEFT JOIN mst_pref AS p ON c.pref_cd=p.id WHERE c.is_target_city=1 AND p.disp_flg=0 AND p.building_regist_date<=NOW()ORDER BY p.disp_rank ASC, c.area_cd ASCSpeed: 9.503 ms
Query analysis:
· Query: SIMPLE on p · Possible keys: PRIMARY,disp_flg · Type: ALL · Rows: 47 (Using where; Using temporary; Using filesort)
· Query: SIMPLE on c · Possible keys: mst_city_idx1,is_target_city · Key Used: mst_city_idx1 · Type: ref · Rows: 40 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/area.php, line 50File: APPPATH/modules/client/classes/model/area.php, line 27File: APPPATH/modules/client/classes/controller/buildings.php, line 387File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT b.id, b.area_cd, ( SELECT COUNT(id) FROM rooms WHERE building_id=b.id AND ( use_flg = 0 OR use_flg = 3 OR ( use_flg = 4 AND seiyaku_date > (NOW() - INTERVAL 72 HOUR) ) ) ) AS room_count FROM buildings AS b INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 INNER JOIN mst_user AS agent ON agent.id=b.agent_id AND agent.del_flg=0 AND agent.agent_approval=2 LEFT JOIN mst_pref AS p ON b.pref_id=p.id WHERE b.use_flg = 0 AND b.area_cd IN (1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1233,1234,1235,1236,1303,1304,1331,1332,1333,1334,1337,1343,1345,1346,1347,1361,1362,1363,1364,1370,1371,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1423,1424,1425,1427,1428,1429,1430,1431,1432,1433,1434,1436,1437,1438,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1468,1469,1470,1471,1472,1481,1482,1483,1484,1485,1486,1487,1511,1512,1513,1514,1516,1520,1543,1544,1545,1546,1547,1549,1550,1552,1555,1559,1560,1561,1562,1563,1564,1571,1575,1578,1581,1584,1585,1586,1601,1602,1604,1607,1608,1609,1610,1631,1632,1633,1634,1635,1636,1637,1638,1639,1641,1642,1643,1644,1645,1646,1647,1648,1649,1661,1662,1663,1664,1665,1667,1668,1691,1692,1693,1694,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2301,2303,2304,2307,2321,2323,2343,2361,2362,2367,2381,2384,2387,2401,2402,2405,2406,2408,2411,2412,2423,2424,2425,2426,2441,2442,2443,2445,2446,2450,3201,3202,3203,3205,3206,3207,3208,3209,3210,3211,3213,3214,3215,3216,3301,3302,3303,3321,3322,3366,3381,3402,3441,3461,3482,3483,3484,3485,3501,3503,3506,3507,3524,5201,5202,5203,5204,5206,5207,5209,5210,5211,5212,5213,5214,5215,5303,5327,5346,5348,5349,5361,5363,5366,5368,5434,5463,5464,4101,4102,4103,4104,4105,4202,4203,4205,4206,4207,4208,4209,4211,4212,4213,4214,4215,4216,4301,4302,4321,4322,4323,4324,4341,4361,4362,4401,4404,4406,4421,4422,4424,4444,4445,4501,4505,4581,4606,6201,6202,6203,6204,6205,6206,6207,6208,6209,6210,6211,6212,6213,6301,6302,6321,6322,6323,6324,6341,6361,6362,6363,6364,6365,6366,6367,6381,6382,6401,6402,6403,6426,6428,6461,7201,7202,7203,7204,7205,7207,7208,7209,7210,7211,7212,7213,7214,7301,7303,7308,7322,7342,7344,7362,7364,7367,7368,7402,7405,7407,7408,7421,7422,7423,7444,7445,7446,7447,7461,7464,7465,7466,7481,7482,7483,7484,7501,7502,7503,7504,7505,7521,7522,7541,7542,7543,7544,7545,7546,7547,7548,7561,7564,13101,13102,13103,13104,13105,13106,13107,13108,13109,13110,13111,13112,13113,13114,13115,13116,13117,13118,13119,13120,13121,13122,13123,13201,13202,13203,13204,13205,13206,13207,13208,13209,13210,13211,13212,13213,13214,13215,13218,13219,13220,13221,13222,13223,13224,13225,13227,13228,13229,13303,13305,13307,13308,14101,14102,14103,14104,14105,14106,14107,14108,14109,14110,14111,14112,14113,14114,14115,14116,14117,14118,14131,14132,14133,14134,14135,14136,14137,14151,14152,14153,14201,14203,14204,14205,14206,14207,14208,14210,14211,14212,14213,14214,14215,14216,14217,14218,14301,14321,14341,14342,14361,14362,14363,14364,14366,14382,14383,14384,14401,14402,12101,12102,12103,12104,12105,12106,12202,12203,12204,12205,12206,12207,12208,12210,12211,12212,12213,12215,12216,12217,12218,12219,12220,12221,12222,12223,12224,12225,12226,12227,12228,12229,12230,12231,12232,12233,12234,12235,12236,12237,12238,12239,12322,12329,12342,12347,12349,12403,12409,12410,12421,12422,12423,12424,12426,12427,12441,12443,12463,11101,11102,11103,11104,11105,11106,11107,11108,11109,11110,11201,11202,11203,11206,11207,11208,11209,11210,11211,11212,11214,11215,11216,11217,11218,11219,11221,11222,11223,11224,11225,11227,11228,11229,11230,11231,11232,11233,11234,11235,11237,11238,11239,11240,11241,11242,11243,11245,11246,11301,11324,11326,11327,11341,11342,11343,11346,11347,11348,11349,11361,11362,11363,11365,11369,11381,11383,11385,11408,11442,11464,11465,8201,8202,8203,8204,8205,8207,8208,8210,8211,8212,8214,8215,8216,8217,8219,8220,8221,8222,8223,8224,8225,8226,8227,8228,8229,8230,8231,8232,8233,8234,8235,8236,8302,8309,8310,8341,8364,8442,8443,8447,8521,8542,8546,8564,9201,9202,9203,9204,9205,9206,9208,9209,9210,9211,9213,9214,9215,9216,9301,9342,9343,9344,9345,9361,9364,9384,9386,9407,9411,10201,10202,10203,10204,10205,10206,10207,10208,10209,10210,10211,10212,10344,10345,10366,10367,10382,10383,10384,10421,10424,10425,10426,10428,10429,10443,10444,10448,10449,10464,10521,10522,10523,10524,10525,19201,19202,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19346,19364,19365,19366,19368,19384,19422,19423,19424,19425,19429,19430,19442,19443,20201,20202,20203,20204,20205,20206,20207,20208,20209,20210,20211,20212,20213,20214,20215,20217,20218,20219,20220,20303,20304,20305,20306,20307,20309,20321,20323,20324,20349,20350,20361,20362,20363,20382,20383,20384,20385,20386,20388,20402,20403,20404,20407,20409,20410,20411,20412,20413,20414,20415,20416,20417,20422,20423,20425,20429,20430,20432,20446,20448,20450,20451,20452,20481,20482,20485,20486,20521,20541,20543,20561,20562,20563,20583,20588,20590,20602,17201,17202,17203,17204,17205,17206,17207,17209,17210,17211,17212,17324,17361,17365,17384,17386,17407,17461,17463,15101,15102,15103,15104,15105,15106,15107,15108,15202,15204,15205,15206,15208,15209,15210,15211,15212,15213,15216,15217,15218,15222,15223,15225,15226,15227,15307,15342,15361,15385,15405,15461,15482,15504,15581,16201,16202,16204,16205,16206,16207,16208,16209,16210,16211,16321,16322,16323,16342,16343,18201,18202,18204,18205,18206,18207,18208,18209,18210,18322,18382,18404,18423,18442,18481,18483,18501,23101,23102,23103,23104,23105,23106,23107,23108,23109,23110,23111,23112,23113,23114,23115,23116,23201,23202,23203,23204,23205,23206,23207,23208,23209,23210,23211,23212,23213,23214,23215,23216,23217,23219,23220,23221,23222,23223,23224,23225,23226,23227,23228,23229,23230,23231,23232,23233,23234,23235,23236,23237,23238,23302,23342,23361,23362,23424,23425,23427,23441,23442,23445,23446,23447,23501,23561,23562,23563,22101,22102,22103,22131,22132,22133,22134,22135,22136,22137,22203,22205,22206,22207,22208,22209,22210,22211,22212,22213,22214,22215,22216,22219,22220,22221,22222,22223,22224,22225,22226,22301,22302,22304,22305,22306,22325,22341,22342,22344,22424,22429,22461,21201,21202,21203,21204,21205,21206,21207,21208,21209,21210,21211,21212,21213,21214,21215,21216,21217,21218,21219,21220,21221,21302,21303,21341,21361,21362,21381,21382,21383,21401,21403,21404,21421,21501,21502,21503,21504,21505,21506,21507,21521,21604,24201,24202,24203,24204,24205,24207,24208,24209,24210,24211,24212,24214,24215,24216,24303,24324,24341,24343,24344,24441,24442,24443,24461,24470,24471,24472,24543,24561,24562,27102,27103,27104,27106,27107,27108,27109,27111,27113,27114,27115,27116,27117,27118,27119,27120,27121,27122,27123,27124,27125,27126,27127,27128,27141,27142,27143,27144,27145,27146,27147,27202,27203,27204,27205,27206,27207,27208,27209,27210,27211,27212,27213,27214,27215,27216,27217,27218,27219,27220,27221,27222,27223,27224,27225,27226,27227,27228,27229,27230,27231,27232,27301,27321,27322,27341,27361,27362,27366,27381,27382,27383,28101,28102,28105,28106,28107,28108,28109,28110,28111,28201,28202,28203,28204,28205,28206,28207,28208,28209,28210,28212,28213,28214,28215,28216,28217,28218,28219,28220,28221,28222,28223,28224,28225,28226,28227,28228,28229,28301,28365,28381,28382,28442,28443,28446,28464,28481,28501,28585,28586,26101,26102,26103,26104,26105,26106,26107,26108,26109,26110,26111,26201,26202,26203,26204,26205,26206,26207,26208,26209,26210,26211,26212,26213,26214,26303,26322,26343,26344,26364,26365,26366,26367,26407,26463,26465,25201,25202,25203,25204,25206,25207,25208,25209,25210,25211,25212,25213,25214,25383,25384,25425,25441,25442,25443,29201,29202,29203,29204,29205,29206,29207,29208,29209,29210,29211,29212,29322,29342,29343,29344,29345,29361,29362,29363,29385,29386,29401,29402,29424,29425,29426,29427,29441,29442,29443,29444,29446,29447,29449,29450,29451,29452,29453,30201,30202,30203,30204,30205,30206,30207,30208,30209,30304,30341,30343,30344,30361,30362,30366,30381,30382,30383,30390,30391,30392,30401,30404,30406,30421,30422,30424,30427,30428,33101,33102,33103,33104,33202,33203,33204,33205,33207,33208,33209,33210,33211,33212,33213,33214,33215,33216,33346,33423,33445,33461,33586,33606,33622,33623,33643,33663,33666,33681,34101,34102,34103,34104,34105,34106,34107,34108,34202,34203,34204,34205,34207,34208,34209,34210,34211,34212,34213,34214,34215,34302,34304,34307,34309,34368,34369,34462,34545,32201,32202,32203,32204,32205,32206,32207,32209,32343,32386,32441,32448,32449,32501,32505,31201,31202,31203,31204,31302,31325,31328,31329,31364,31370,31371,31372,31384,31386,31389,31390,31401,31402,31403,35201,35202,35203,35204,35206,35207,35208,35210,35211,35212,35213,35215,35216,35305,35321,35341,35343,35344,35502,38201,38202,38203,38204,38205,38206,38207,38210,38213,38214,38215,38386,38401,38402,38422,38442,38484,38488,38506,37201,37202,37203,37204,37205,37206,37207,37208,37341,37386,37387,37403,37404,37406,39201,39202,39203,39204,39205,39206,39208,39209,39210,39211,39212,39301,39302,39303,39304,39305,39306,39307,39341,39344,39363,39364,39386,39387,39401,39402,39403,39405,39410,39411,39412,39424,39427,39428,36201,36202,36203,36204,36205,36206,36207,36208,36301,36302,36321,36341,36342,36368,36383,36387,36388,36401,36402,36403,36404,36405,36468,36489,40101,40103,40105,40106,40107,40108,40109,40131,40132,40133,40134,40135,40136,40137,40202,40203,40204,40205,40206,40207,40210,40211,40212,40213,40214,40215,40216,40217,40218,40219,40220,40221,40223,40224,40225,40226,40227,40228,40229,40230,40231,40341,40342,40343,40344,40345,40348,40349,40381,40382,40383,40384,40401,40402,40421,40447,40448,40503,40522,40544,40601,40602,40604,40605,40608,40609,40610,40621,40625,40642,40646,40647,41201,41202,41203,41204,41205,41206,41207,41208,41209,41210,41327,41341,41345,41346,41387,41401,41423,41424,41425,41441,42201,42202,42203,42204,42205,42207,42208,42212,42213,42214,42307,42308,42321,42322,42323,42391,43101,43102,43103,43104,43105,43202,43203,43204,43205,43206,43208,43210,43211,43212,43213,43214,43215,43216,43348,43364,43367,43368,43369,43403,43404,43423,43424,43425,43428,43432,43433,43441,43442,43443,43444,43447,43468,43482,43484,43501,43505,43506,43507,43510,43511,43512,43513,43514,43531,44201,44202,44203,44204,44205,44206,44207,44208,44209,44210,44211,44212,44213,44214,44341,44461,44462,45201,45202,45203,45204,45205,45206,45207,45208,45209,45341,45361,45382,45383,45401,45402,45403,45404,45405,45406,45421,45429,45430,45431,45441,45442,45443,46201,46203,46204,46206,46208,46210,46214,46215,46216,46217,46218,46219,46220,46221,46223,46224,46225,46392,46404,46452,46468,46482,46490,46491,46492,47201,47205,47208,47209,47210,47211,47212,47213,47215,47301,47302,47303,47306,47308,47311,47313,47314,47324,47325,47326,47327,47328,47329,47348,47350,47362)Speed: 17.321 ms
Query analysis:
· Query: PRIMARY on b · Possible keys: owner_id,agent_id,use_flg,area_cd · Key Used: use_flg · Type: ref · Rows: 495 (Using where)
· Query: PRIMARY on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: PRIMARY on p · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where; Using index)
· Query: PRIMARY on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: DEPENDENT SUBQUERY on rooms · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/area.php, line 77File: APPPATH/modules/client/classes/model/area.php, line 27File: APPPATH/modules/client/classes/controller/buildings.php, line 387File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT wr.id AS wait_room_id, b.id, b.area_cd, ( SELECT COUNT(id) FROM rooms WHERE building_id=b.id AND ( use_flg = 0 OR use_flg = 3 OR ( use_flg = 4 AND seiyaku_date > (NOW() - INTERVAL 72 HOUR) ) ) ) AS room_count FROM buildings AS b INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 INNER JOIN mst_user AS agent ON agent.id=b.agent_id AND agent.del_flg=0 AND agent.agent_approval=2 INNER JOIN mst_zip AS z ON b.zip_code=z.zip LEFT JOIN mst_pref AS p ON b.pref_id=p.id INNER JOIN wait_room AS wr ON wr.building_id=b.id AND wr.del_flg=0 AND wr.enabled=1 WHERE b.use_flg = 0 AND z.area_cd IN (1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1233,1234,1235,1236,1303,1304,1331,1332,1333,1334,1337,1343,1345,1346,1347,1361,1362,1363,1364,1370,1371,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1423,1424,1425,1427,1428,1429,1430,1431,1432,1433,1434,1436,1437,1438,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1468,1469,1470,1471,1472,1481,1482,1483,1484,1485,1486,1487,1511,1512,1513,1514,1516,1520,1543,1544,1545,1546,1547,1549,1550,1552,1555,1559,1560,1561,1562,1563,1564,1571,1575,1578,1581,1584,1585,1586,1601,1602,1604,1607,1608,1609,1610,1631,1632,1633,1634,1635,1636,1637,1638,1639,1641,1642,1643,1644,1645,1646,1647,1648,1649,1661,1662,1663,1664,1665,1667,1668,1691,1692,1693,1694,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2301,2303,2304,2307,2321,2323,2343,2361,2362,2367,2381,2384,2387,2401,2402,2405,2406,2408,2411,2412,2423,2424,2425,2426,2441,2442,2443,2445,2446,2450,3201,3202,3203,3205,3206,3207,3208,3209,3210,3211,3213,3214,3215,3216,3301,3302,3303,3321,3322,3366,3381,3402,3441,3461,3482,3483,3484,3485,3501,3503,3506,3507,3524,5201,5202,5203,5204,5206,5207,5209,5210,5211,5212,5213,5214,5215,5303,5327,5346,5348,5349,5361,5363,5366,5368,5434,5463,5464,4101,4102,4103,4104,4105,4202,4203,4205,4206,4207,4208,4209,4211,4212,4213,4214,4215,4216,4301,4302,4321,4322,4323,4324,4341,4361,4362,4401,4404,4406,4421,4422,4424,4444,4445,4501,4505,4581,4606,6201,6202,6203,6204,6205,6206,6207,6208,6209,6210,6211,6212,6213,6301,6302,6321,6322,6323,6324,6341,6361,6362,6363,6364,6365,6366,6367,6381,6382,6401,6402,6403,6426,6428,6461,7201,7202,7203,7204,7205,7207,7208,7209,7210,7211,7212,7213,7214,7301,7303,7308,7322,7342,7344,7362,7364,7367,7368,7402,7405,7407,7408,7421,7422,7423,7444,7445,7446,7447,7461,7464,7465,7466,7481,7482,7483,7484,7501,7502,7503,7504,7505,7521,7522,7541,7542,7543,7544,7545,7546,7547,7548,7561,7564,13101,13102,13103,13104,13105,13106,13107,13108,13109,13110,13111,13112,13113,13114,13115,13116,13117,13118,13119,13120,13121,13122,13123,13201,13202,13203,13204,13205,13206,13207,13208,13209,13210,13211,13212,13213,13214,13215,13218,13219,13220,13221,13222,13223,13224,13225,13227,13228,13229,13303,13305,13307,13308,14101,14102,14103,14104,14105,14106,14107,14108,14109,14110,14111,14112,14113,14114,14115,14116,14117,14118,14131,14132,14133,14134,14135,14136,14137,14151,14152,14153,14201,14203,14204,14205,14206,14207,14208,14210,14211,14212,14213,14214,14215,14216,14217,14218,14301,14321,14341,14342,14361,14362,14363,14364,14366,14382,14383,14384,14401,14402,12101,12102,12103,12104,12105,12106,12202,12203,12204,12205,12206,12207,12208,12210,12211,12212,12213,12215,12216,12217,12218,12219,12220,12221,12222,12223,12224,12225,12226,12227,12228,12229,12230,12231,12232,12233,12234,12235,12236,12237,12238,12239,12322,12329,12342,12347,12349,12403,12409,12410,12421,12422,12423,12424,12426,12427,12441,12443,12463,11101,11102,11103,11104,11105,11106,11107,11108,11109,11110,11201,11202,11203,11206,11207,11208,11209,11210,11211,11212,11214,11215,11216,11217,11218,11219,11221,11222,11223,11224,11225,11227,11228,11229,11230,11231,11232,11233,11234,11235,11237,11238,11239,11240,11241,11242,11243,11245,11246,11301,11324,11326,11327,11341,11342,11343,11346,11347,11348,11349,11361,11362,11363,11365,11369,11381,11383,11385,11408,11442,11464,11465,8201,8202,8203,8204,8205,8207,8208,8210,8211,8212,8214,8215,8216,8217,8219,8220,8221,8222,8223,8224,8225,8226,8227,8228,8229,8230,8231,8232,8233,8234,8235,8236,8302,8309,8310,8341,8364,8442,8443,8447,8521,8542,8546,8564,9201,9202,9203,9204,9205,9206,9208,9209,9210,9211,9213,9214,9215,9216,9301,9342,9343,9344,9345,9361,9364,9384,9386,9407,9411,10201,10202,10203,10204,10205,10206,10207,10208,10209,10210,10211,10212,10344,10345,10366,10367,10382,10383,10384,10421,10424,10425,10426,10428,10429,10443,10444,10448,10449,10464,10521,10522,10523,10524,10525,19201,19202,19204,19205,19206,19207,19208,19209,19210,19211,19212,19213,19214,19346,19364,19365,19366,19368,19384,19422,19423,19424,19425,19429,19430,19442,19443,20201,20202,20203,20204,20205,20206,20207,20208,20209,20210,20211,20212,20213,20214,20215,20217,20218,20219,20220,20303,20304,20305,20306,20307,20309,20321,20323,20324,20349,20350,20361,20362,20363,20382,20383,20384,20385,20386,20388,20402,20403,20404,20407,20409,20410,20411,20412,20413,20414,20415,20416,20417,20422,20423,20425,20429,20430,20432,20446,20448,20450,20451,20452,20481,20482,20485,20486,20521,20541,20543,20561,20562,20563,20583,20588,20590,20602,17201,17202,17203,17204,17205,17206,17207,17209,17210,17211,17212,17324,17361,17365,17384,17386,17407,17461,17463,15101,15102,15103,15104,15105,15106,15107,15108,15202,15204,15205,15206,15208,15209,15210,15211,15212,15213,15216,15217,15218,15222,15223,15225,15226,15227,15307,15342,15361,15385,15405,15461,15482,15504,15581,16201,16202,16204,16205,16206,16207,16208,16209,16210,16211,16321,16322,16323,16342,16343,18201,18202,18204,18205,18206,18207,18208,18209,18210,18322,18382,18404,18423,18442,18481,18483,18501,23101,23102,23103,23104,23105,23106,23107,23108,23109,23110,23111,23112,23113,23114,23115,23116,23201,23202,23203,23204,23205,23206,23207,23208,23209,23210,23211,23212,23213,23214,23215,23216,23217,23219,23220,23221,23222,23223,23224,23225,23226,23227,23228,23229,23230,23231,23232,23233,23234,23235,23236,23237,23238,23302,23342,23361,23362,23424,23425,23427,23441,23442,23445,23446,23447,23501,23561,23562,23563,22101,22102,22103,22131,22132,22133,22134,22135,22136,22137,22203,22205,22206,22207,22208,22209,22210,22211,22212,22213,22214,22215,22216,22219,22220,22221,22222,22223,22224,22225,22226,22301,22302,22304,22305,22306,22325,22341,22342,22344,22424,22429,22461,21201,21202,21203,21204,21205,21206,21207,21208,21209,21210,21211,21212,21213,21214,21215,21216,21217,21218,21219,21220,21221,21302,21303,21341,21361,21362,21381,21382,21383,21401,21403,21404,21421,21501,21502,21503,21504,21505,21506,21507,21521,21604,24201,24202,24203,24204,24205,24207,24208,24209,24210,24211,24212,24214,24215,24216,24303,24324,24341,24343,24344,24441,24442,24443,24461,24470,24471,24472,24543,24561,24562,27102,27103,27104,27106,27107,27108,27109,27111,27113,27114,27115,27116,27117,27118,27119,27120,27121,27122,27123,27124,27125,27126,27127,27128,27141,27142,27143,27144,27145,27146,27147,27202,27203,27204,27205,27206,27207,27208,27209,27210,27211,27212,27213,27214,27215,27216,27217,27218,27219,27220,27221,27222,27223,27224,27225,27226,27227,27228,27229,27230,27231,27232,27301,27321,27322,27341,27361,27362,27366,27381,27382,27383,28101,28102,28105,28106,28107,28108,28109,28110,28111,28201,28202,28203,28204,28205,28206,28207,28208,28209,28210,28212,28213,28214,28215,28216,28217,28218,28219,28220,28221,28222,28223,28224,28225,28226,28227,28228,28229,28301,28365,28381,28382,28442,28443,28446,28464,28481,28501,28585,28586,26101,26102,26103,26104,26105,26106,26107,26108,26109,26110,26111,26201,26202,26203,26204,26205,26206,26207,26208,26209,26210,26211,26212,26213,26214,26303,26322,26343,26344,26364,26365,26366,26367,26407,26463,26465,25201,25202,25203,25204,25206,25207,25208,25209,25210,25211,25212,25213,25214,25383,25384,25425,25441,25442,25443,29201,29202,29203,29204,29205,29206,29207,29208,29209,29210,29211,29212,29322,29342,29343,29344,29345,29361,29362,29363,29385,29386,29401,29402,29424,29425,29426,29427,29441,29442,29443,29444,29446,29447,29449,29450,29451,29452,29453,30201,30202,30203,30204,30205,30206,30207,30208,30209,30304,30341,30343,30344,30361,30362,30366,30381,30382,30383,30390,30391,30392,30401,30404,30406,30421,30422,30424,30427,30428,33101,33102,33103,33104,33202,33203,33204,33205,33207,33208,33209,33210,33211,33212,33213,33214,33215,33216,33346,33423,33445,33461,33586,33606,33622,33623,33643,33663,33666,33681,34101,34102,34103,34104,34105,34106,34107,34108,34202,34203,34204,34205,34207,34208,34209,34210,34211,34212,34213,34214,34215,34302,34304,34307,34309,34368,34369,34462,34545,32201,32202,32203,32204,32205,32206,32207,32209,32343,32386,32441,32448,32449,32501,32505,31201,31202,31203,31204,31302,31325,31328,31329,31364,31370,31371,31372,31384,31386,31389,31390,31401,31402,31403,35201,35202,35203,35204,35206,35207,35208,35210,35211,35212,35213,35215,35216,35305,35321,35341,35343,35344,35502,38201,38202,38203,38204,38205,38206,38207,38210,38213,38214,38215,38386,38401,38402,38422,38442,38484,38488,38506,37201,37202,37203,37204,37205,37206,37207,37208,37341,37386,37387,37403,37404,37406,39201,39202,39203,39204,39205,39206,39208,39209,39210,39211,39212,39301,39302,39303,39304,39305,39306,39307,39341,39344,39363,39364,39386,39387,39401,39402,39403,39405,39410,39411,39412,39424,39427,39428,36201,36202,36203,36204,36205,36206,36207,36208,36301,36302,36321,36341,36342,36368,36383,36387,36388,36401,36402,36403,36404,36405,36468,36489,40101,40103,40105,40106,40107,40108,40109,40131,40132,40133,40134,40135,40136,40137,40202,40203,40204,40205,40206,40207,40210,40211,40212,40213,40214,40215,40216,40217,40218,40219,40220,40221,40223,40224,40225,40226,40227,40228,40229,40230,40231,40341,40342,40343,40344,40345,40348,40349,40381,40382,40383,40384,40401,40402,40421,40447,40448,40503,40522,40544,40601,40602,40604,40605,40608,40609,40610,40621,40625,40642,40646,40647,41201,41202,41203,41204,41205,41206,41207,41208,41209,41210,41327,41341,41345,41346,41387,41401,41423,41424,41425,41441,42201,42202,42203,42204,42205,42207,42208,42212,42213,42214,42307,42308,42321,42322,42323,42391,43101,43102,43103,43104,43105,43202,43203,43204,43205,43206,43208,43210,43211,43212,43213,43214,43215,43216,43348,43364,43367,43368,43369,43403,43404,43423,43424,43425,43428,43432,43433,43441,43442,43443,43444,43447,43468,43482,43484,43501,43505,43506,43507,43510,43511,43512,43513,43514,43531,44201,44202,44203,44204,44205,44206,44207,44208,44209,44210,44211,44212,44213,44214,44341,44461,44462,45201,45202,45203,45204,45205,45206,45207,45208,45209,45341,45361,45382,45383,45401,45402,45403,45404,45405,45406,45421,45429,45430,45431,45441,45442,45443,46201,46203,46204,46206,46208,46210,46214,46215,46216,46217,46218,46219,46220,46221,46223,46224,46225,46392,46404,46452,46468,46482,46490,46491,46492,47201,47205,47208,47209,47210,47211,47212,47213,47215,47301,47302,47303,47306,47308,47311,47313,47314,47324,47325,47326,47327,47328,47329,47348,47350,47362)Speed: 5.810 ms
Query analysis:
· Query: PRIMARY on wr · Type: ALL · Rows: 99 (Using where)
· Query: PRIMARY on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg,zip_code · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: PRIMARY on p · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where; Using index)
· Query: PRIMARY on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: PRIMARY on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: PRIMARY on z · Possible keys: area_cd,zip · Key Used: zip · Type: ref · Rows: 1 (Using index condition; Using where)
· Query: DEPENDENT SUBQUERY on rooms · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/area.php, line 103File: APPPATH/modules/client/classes/model/area.php, line 27File: APPPATH/modules/client/classes/controller/buildings.php, line 387File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT `b`.`pref_id`, COUNT(b.id) AS cnt FROM `buildings` AS `b` INNER JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id`) INNER JOIN `mst_user` AS `owner` ON (`owner`.`id` = `b`.`owner_id` AND `owner`.`del_flg` = 0) INNER JOIN `mst_user` AS `agent` ON (`agent`.`id` = `b`.`agent_id` AND `agent`.`del_flg` = 0 AND `agent`.`agent_approval` = 2) LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` <> 2 AND `rd`.`legal_check` <> 3) WHERE `b`.`use_flg` = 0 AND (`r`.`use_flg` = 0 OR `r`.`use_flg` = 3 OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`id` IN (SELECT `room_id` FROM `room_feature` WHERE `feature_id` = 7) GROUP BY `b`.`pref_id`Speed: 5.724 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx1,room_feature_idx2 · Key Used: room_feature_idx1 · Type: ref · Rows: 94 (Using temporary; Start temporary)
· Query: SIMPLE on r · Possible keys: PRIMARY,building_id,use_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg,pref_id · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where; End temporary)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/controller/buildings.php, line 1008File: APPPATH/modules/client/classes/controller/buildings.php, line 417File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139

SELECT l.line_cd, l.line_name, s.station_cd, station_g_cd, s.station_name FROM mst_station AS s LEFT JOIN mst_line AS l ON s.line_cd=l.line_cd WHERE s.station_cd='9962925'Speed: 2.166 ms
Query analysis:
· Query: SIMPLE on s · Possible keys: station_cd · Key Used: station_cd · Type: ref · Rows: 1
· Query: SIMPLE on l · Possible keys: line_cd · Key Used: line_cd · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/classes/common/list_cache.php, line 1035File: APPPATH/classes/core/view.php, line 469File: APPPATH/modules/client/views/2017_pc/buildings/_row.php, line 72File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/buildings/index.php, line 98File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172

SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29375Speed: 2.194 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/buildings/_row.php, line 113File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/buildings/index.php, line 98File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172

SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=1032Speed: 2.297 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/buildings/_row.php, line 113File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/buildings/index.php, line 98File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172

SELECT l.line_cd, l.line_name, s.station_cd, station_g_cd, s.station_name FROM mst_station AS s LEFT JOIN mst_line AS l ON s.line_cd=l.line_cd WHERE s.station_cd='2300130'Speed: 2.412 ms
Query analysis:
· Query: SIMPLE on s · Possible keys: station_cd · Key Used: station_cd · Type: ref · Rows: 1
· Query: SIMPLE on l · Possible keys: line_cd · Key Used: line_cd · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/classes/common/list_cache.php, line 1035File: APPPATH/classes/core/view.php, line 469File: APPPATH/modules/client/views/2017_pc/buildings/_row.php, line 72File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/buildings/index.php, line 98File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172

SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=27997Speed: 2.446 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/buildings/_row.php, line 113File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/buildings/index.php, line 98File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172

SELECT l.line_cd, l.line_name, s.station_cd, station_g_cd, s.station_name FROM mst_station AS s LEFT JOIN mst_line AS l ON s.line_cd=l.line_cd WHERE s.station_cd='2200720'Speed: 2.388 ms
Query analysis:
· Query: SIMPLE on s · Possible keys: station_cd · Key Used: station_cd · Type: ref · Rows: 1
· Query: SIMPLE on l · Possible keys: line_cd · Key Used: line_cd · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/classes/common/list_cache.php, line 1035File: APPPATH/classes/core/view.php, line 469File: APPPATH/modules/client/views/2017_pc/buildings/_row.php, line 72File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/buildings/index.php, line 98File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172

SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29300Speed: 2.275 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/buildings/_row.php, line 113File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/buildings/index.php, line 98File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172

This panel has no log items.

6

Finder Paths

165

Total Files

1.56 MB

Total Size

145.37 kB

Largest

Finder paths:

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/pushnotifications/

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/web-debug/

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/email/

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/orm/

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/

Loaded files:

5.24 kB /var/www/html/dev2.uchicomi.biz/uchicomi/public/index.php

5.83 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/bootstrap.php

8.30 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/autoloader.php

12.44 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/bootstrap.php

9.60 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/base.php

183 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/autoload.php

1.37 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/composer/autoload_real.php

12.14 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/composer/ClassLoader.php

349 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/composer/autoload_namespaces.php

309 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/composer/autoload_psr4.php

156 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/composer/autoload_classmap.php

10.20 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/FacebookSession.php

9.05 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/FacebookRedirectLoginHelper.php

7.58 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/FacebookRequest.php

5.16 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/FacebookResponse.php

1.18 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/FacebookSDKException.php

5.48 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/FacebookRequestException.php

1.22 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/FacebookAuthorizationException.php

4.62 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/src/Facebook/GraphObject.php

2.44 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/php-sdk-v4/autoload.php

142.63 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/phpmailer/class.phpmailer.php

41.07 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/vendor/phpmailer/class.smtp.php

7.68 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/fuel.php

5.75 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/config.php

814 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/config/php.php

4.45 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/config/file.php

163 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/config/interface.php

11.81 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/finder.php

29.60 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/arr.php

1.49 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/file.php

9.09 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/config.php

9.54 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/config.php

48 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/staging/config.php

1.75 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/profiler.php

2.46 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/vendor/phpquickprofiler/console.php

6.54 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/vendor/phpquickprofiler/phpquickprofiler.php

12.53 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/input.php

10.13 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/security.php

2.14 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/event.php

4.82 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/event/instance.php

3.27 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/package.php

2.03 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/orm/bootstrap.php

1.75 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/email/bootstrap.php

1.02 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/web-debug/bootstrap.php

10.26 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/web-debug/vendor/chromephp/ChromePhp.php

62.21 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/web-debug/vendor/firephp/lib/FirePHPCore/FirePHP.class.php

7.24 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/web-debug/vendor/firephp/lib/FirePHPCore/fb.php

1.00 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/pushnotifications/bootstrap.php

3.17 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/module.php

7.40 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/system-config.php

145.37 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/common/ddlist.php

7.84 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/staging/system-config.php

1.90 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/pushnotifications/config/pushnotification.php

2.01 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/pushnotification.php

630 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/routes.php

16.99 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/routes/client.php

6.56 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/router.php

4.88 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/route.php

12.83 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/request.php

6.63 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/uri.php

11.38 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/inflector.php

52.16 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/controller/buildings.php

21.62 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/controller/template.php

1.11 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/controller/template.php

2.30 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/controller.php

24.91 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/core/view.php

13.11 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/view.php

6.97 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/core/agent.php

14.33 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/agent.php

2.58 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/agent.php

299 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/agent.php

4.95 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Cache/File.php

2.59 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Cache/AbstractCache.php

7.47 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Browscap.php

2.19 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Updater/None.php

5.02 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Updater/AbstractUpdater.php

4.56 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Parser/Ini.php

23.89 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Parser/IniLt55.php

4.98 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Parser/AbstractParser.php

2.59 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Formatter/PhpGetBrowser.php

2.20 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/vendor/crossjoin/browscap/src/Crossjoin/Browscap/Formatter/AbstractFormatter.php

7.71 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/session.php

4.13 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/session.php

110 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/session.php

8.89 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/session/file.php

15.81 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/session/driver.php

1.14 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/core/date.php

10.18 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/date.php

3.59 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cookie.php

4.73 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/crypt.php

22.10 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/vendor/phpseclib/Crypt/AES.php

53.77 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/vendor/phpseclib/Crypt/Rijndael.php

28.67 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/vendor/phpseclib/Crypt/Hash.php

158 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/crypt.php

571 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/const/session.php

52.04 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/mst/user.php

48.05 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/orm/classes/model.php

6.22 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/controller/ac.php

11.84 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/controller/rest.php

56.85 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/common/list_cache.php

4.37 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache.php

367 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/notfound.php

2.10 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/cache.php

8.25 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/storage/file.php

11.14 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/storage/driver.php

482 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/handler/serialized.php

554 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/handler/driver.php

4.30 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/feature.php

3.99 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/core/pagination.php

14.51 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/pagination.php

3.80 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/pagination.php

1.55 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/pagination.php

7.15 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/lang.php

810 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/lang/php.php

4.43 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/lang/file.php

174 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/lang/interface.php

75 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/lang/en/pagination.php

10.24 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/db.php

5.22 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/query.php

18.63 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/connection.php

1.47 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/db.php

494 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/db.php

3.51 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/staging/db.php

9.45 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/pdo/connection.php

881 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/result/cached.php

5.88 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/result.php

33.00 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/model/buildings.php

9.15 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/query/builder/select.php

3.75 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/query/builder/where.php

4.38 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/query/builder.php

3.25 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/query/builder/join.php

1.22 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/expression.php

9.90 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/model/article/facility.php

4.73 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/model/article/image.php

1.13 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/owner/search.php

5.02 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/model/area.php

1.41 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/mst/pref.php

280 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/core/viewmodel.php

6.00 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/viewmodel.php

149 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/view/buildings/index.php

3.99 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/view/base.php

7.59 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/response.php

8.77 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/layout_simple.php

4.24 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/buildings/index.php

64 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/layout/pankuzu_home.php

11.99 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/buildings/_row.php

5.99 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/asset.php

2.46 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/asset.php

613 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/asset.php

608 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/assets/client.php

12.56 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/asset/instance.php

5.12 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/common/webp.php

220 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/mst/roomtype.php

470 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/handler/string.php

229 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/mst/roomarrange.php

402 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/layout/pager.php

3.08 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/layout/navi/search_feature.php

7.44 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/form.php

1.81 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/form.php

20.98 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/fieldset.php

18.71 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/form/instance.php

147 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/view/layout/header.php

4.51 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/layout/header.php

135 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/view/layout/footer.php

4.42 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/layout/footer.php

743

Configuration items

file

› base_config

null› › basedir

null› › extensions

null› › url

null› › use_locks

› › file_handlers

› areas

null› magic_file

› chmod

438› › files

511› › folders

https://dev2.uchicomi.biz/base_url

url_suffix

falseindex_file

trueprofiling

profiling_paths

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/› APPPATH

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/› COREPATH

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/› PKGPATH

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/cache/cache_dir

falsecaching

3600cache_lifetime

nullob_callback

errors

› continue_on

8› › 0

10› throttle

false› notices

false› render_prior

jalanguage

enlanguage_fallback

ja_JPlocale

UTF-8encoding

0server_gmt_offset

Asia/Tokyodefault_timezone

300log_threshold

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/logs/log_path

Y-m-d H:i:slog_date_format

security

false› csrf_autoload

› csrf_autoload_methods

post› › 0

put› › 1

delete› › 2

fuel_csrf_token› csrf_token_key

0› csrf_expiration

put your salt value here to make the token more secure› token_salt

false› allow_x_headers

3› htmlentities_flags

false› htmlentities_double_encode

true› auto_filter_output

› whitelisted_classes

Fuel\Core\Response› › 0

Fuel\Core\View› › 1

Fuel\Core\ViewModel› › 2

Closure› › 3

Orm\Query› › 4

Fuel\Core\Pagination› › 5

Model\UCM› › 6

› uri_filter

htmlentities› › 0

› output_filter

Security::htmlentities› › 0

› input_filter

0› expiration

/› path

null› domain

false› secure

false› http_only

validation

true› global_input_fallback

<ul>› open_list

</ul>› close_list

<li>› open_error

</li>› close_error

Controller_controller_prefix

routing

true› case_sensitive

true› strip_extension

module_paths

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/› 0

package_paths

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/› 0

always_load

› packages

orm› › 0

email› › 1

web-debug› › 2

pushnotifications› › 3

› modules

› classes

› config

system-config› › 0

pushnotification› › 1

› language

event

system-config

ウチコミ！› system-name

› external-data

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/area.csv› › area

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/zip.csv› › zip

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/pref.csv› › pref

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/line/company20180424.csv› › lineCompany

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/line/line20180424free.csv› › line

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/line/station20180330free.csv› › station

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/updateZip.csv› › updateZip

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/tmp/external-data/zip/› › zipDir

› cdn

devcf.uchicomi.biz› › host

https://devcf.uchicomi.biz› › url

› twitter-api

false› › twitter_status

NloNY5Es7Y55EvgmFhbiiOrKj› › api_key

Ro8U9jyVuZyVzfLII4ZLMdUCw3MhYWAcwd7sFUWrYRwvbNBzdw› › api_secret

829520911875190784-JWjXU1zpLgXKmhVSnRgX5E3HwU4zX4e› › access_token

I2trJ8CA8100To8DGjMQstaUzAoSU0bUQTSjt7ScOEjxk› › access_token_secret

› sms-send

48cBYva5› › api_key

LP763322› › api_id

SAMPu5pmEkHNn› › api_request

https://api.acrt.jp/ibss/api/sms_reg/LP763322/› › api_send_url

https://api.acrt.jp/ibss/api/sms_dr/LP763322/› › api_result_url

https://api.acrt.jp/ibss/api/us/LP763322/› › api_make_short_url

uchicomi-master› admin_id

uchicomi-master› admin_password

ウチコミ事務局› support_name

uchicomi@uchicomi.biz› support_address

uchicomi@uchicomi.biz› seminar_address

uchicomi@uchicomi.biz› plus_address

kansai@uchicomi.biz› kansai_address

uchicomi@uchicomi.biz› return_address

dev@uchicomi.co.jp› user_approval_address

dev@uchicomi.co.jp› mm_return_address

noreply@uchicomi.biz› noreply_address

dev@uchicomi.co.jp› system_address

dev+campaign@uchicomi.co.jp› campaign_address

dev@uchicomi.co.jp› pr_address

dev+prkanri@uchicomi.co.jp› pr_admin_address

dev+sales@uchicomi.co.jp› sales_address

dev+jss@uchicomi.co.jp› jss_address

https://dev2.uchicomi.biz› url_client

https://dev2owner.uchicomi.biz› url_owner

https://dev2agent.uchicomi.biz› url_agent

https://dev2admin.uchicomi.biz› url_admin

uchicomi.biz› auto_account_route_domain

43200› auto_account_route_expire

dev@uchicomi.co.jp› watanabe_address

› password-hash-key

wp6HuuxEp76Ytu7a› › admin

sLnnJZee3d7B3uxU› › client

ZnJBL_uP_tWhn5SE› › owner

NpSM2xjQ5Yj-Xwx4› › agent

6X-7W4wcyZab3sTt› › company

%$frF@ymzFY2jJLJq5ewr?lqYJ#sMYx.bNmre56rMGk?sf@mIo!r@*oLCPc6M9rBlIel+FFv_2$Bqb@3%IZNMRBV=R%o2ujH4/jh&=%Ia8HOCLKnRam=TG-TydO6e_CXk› admin_login_key

3000› bs_unit

10› 24h_no_send_count

180› message_send_unit

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/data/times› times_dir

› mm_server

2017_pc/› client_view_root

2017_mobile/› client_view_root_m

false› set_old_buildings

› office_ips

113.43.194.206› › 0

202.152.109.51› › 1

61.8.86.81› › 2

202.152.112.194› › 3

202.152.96.183› › 4

125.0.84.24› › 5

121.93.197.48› › 6

175.184.9.51› › 7

113.43.194.206› › 8

202.152.109.51› › 9

61.8.86.81› › 10

202.152.112.194› › 11

202.152.96.183› › 12

AIzaSyAWwkV0lBVEfV1lbGDJAQNW8hXBq5311vs› google_api_key

false› is_curumeru_use

true› is_user_approval_check

0.1› tax_rate

› premium

dev@uchicomi.co.jp› › agency_email

› manager_mail_address

dev@uchicomi.co.jp› › kansai

dev@uchicomi.co.jp› › except_kansai

› blog

2025-06-19› › thumbnail_icon_limit

› server

/var/www/html/uchicomi.com› › docroot

/home/ec2-user/storage/shell/maintenance› › maintenance_shell

› agent

7› › declaration_deadline

› ichiba

› › status

1› › › enabled

2› › › disabled

› › contract_types

1› › › fixed

2› › › inquiry

3› › › click

› webp-cmd

/usr/local/bin/cwebp› › cwebp

/usr/local/bin/gif2webp› › gif2webp

› zbar-cmd

/bin/zbarimg› › img

› google-recaptcha

1› › use

› › v2

6LcsC5keAAAAABvV2PpH0bQ1SP-yuS0t1m099eZa› › › sitekey

6LcsC5keAAAAAIASpInUtpyIiWeE5Jd9WD1Dsri_› › › secretkey

› › v3

6LcAnpceAAAAAG0ZLMUXRxNtTRB6_d7YNsG4zt2u› › › sitekey

6LcAnpceAAAAAHlT45CCNGtlgEklCgDNt2QEJm0L› › › secretkey

› › logging-ips

203.175.12.16› › › 0

38.94.109.163› › › 1

114.37.145.139› › › 2

69.163.46.129› › › 3

64.120.119.68› › › 4

111.249.124.219› › › 5

110.83.19.187› › › 6

172.104.117.154› › › 7

136.175.179.202› › › 8

42.3.54.40› › › 9

58.153.33.111› › › 10

119.236.134.64› › › 11

58.153.32.251› › › 12

185.181.209.188› › › 13

172.105.120.140› › › 14

35.182.72.44› › › 15

210.23.11.34› › › 16

176.58.113.12› › › 17

152.67.214.143› › › 18

221.124.250.62› › › 19

141.164.50.118› › › 20

182.239.114.41› › › 21

182.239.115.68› › › 22

182.239.93.218› › › 23

182.239.92.110› › › 24

112.49.216.57› › › 25

182.239.114.128› › › 26

182.239.115.55› › › 27

112.111.55.136› › › 28

182.239.115.57› › › 29

182.239.93.37› › › 30

182.239.114.10› › › 31

182.239.93.108› › › 32

182.239.114.96› › › 33

133.209.5.65› › › 34

39.110.117.179› › › 35

122.210.150.153› › › 36

60.113.11.114› › › 37

115.177.184.165› › › 38

219.106.193.85› › › 39

114.16.138.180› › › 40

182.239.114.22› › › 41

197.90.173.208› › › 42

98.187.108.252› › › 43

61.230.238.249› › › 44

182.239.92.44› › › 45

pushnotification

› services

Pushnotification_Gcm› › gcm

Pushnotification_Apns› › apns

› Pushnotification_Gcm

› › api_key

https://android.googleapis.com/gcm/send› › send_address

› Pushnotification_Apns

false› › use_sandbox

› › sandbox

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app//config/files/server_certificates_sandbox.pem› › › certificate

› › › certificate_passphrase

ssl://gateway.sandbox.push.apple.com:2195› › › push_gateway

ssl://feedback.sandbox.push.apple.com:2196› › › feedback_gateway

› › production

/var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app//config/files/server_certificates_production.pem› › › certificate

› › › certificate_passphrase

ssl://gateway.push.apple.com:2195› › › push_gateway

ssl://feedback.push.apple.com:2196› › › feedback_gateway

60› › timeout

86400› › expiry

routes

client/top› _root_

error/404› _404_

client/error/404› 404

client/error/error› error

client/top› index

client/top/fsearch› fsearch

client/ac/js› ac/ac

client/ac/image› ac/image

client/ac/index› ac

client/ajax/cc/index/$1› aj/cc/:kind

profile/index/$1› profile/:user_id

index/rule2› rule2

index/rule3› rule3

contact/owner› contact/owner

contact/ownerregister› contact/ownerregister

contact/ownerend› contact/ownerend

contact/agent› contact/agent

contact/agentregister› contact/agentregister

contact/agentend› contact/agentend

client/contact/index› contact

client/contact/index› contact/

client/contact/index› contact/index

client/contact/confirm› contact/confirm

client/contact/regist› contact/regist

client/contact/end› contact/end

client/phone/index› phone

client/statics/guide/index› guide

client/statics/guide/member› guide/member

client/statics/guide/use› guide/use

client/statics/guide/haikei› guide/haikei

client/statics/guide/joukyou› guide/joukyou

client/statics/guide/joukyou/$1› guide/joukyou/:idx

client/statics/guide/voice/index/$1› guide/voice/:page

client/statics/guide/voice/index› guide/voice

client/statics/guide/flow/index› guide/flow

client/statics/guide/reason/index› guide/reason

client/statics/guide/request› guide/request

client/statics/guide/initialcost› guide/initialcost

client/statics/guide/initialcost/detail› guide/initialcost/detail

client/statics/guide/interview› guide/interview

client/account/password/index› account/password

client/account/password/send› account/password/send

client/account/password/relay› account/password/relay

client/account/password/ock› account/password/ock/:ontimecode

client/account/password/input› account/password/input

client/account/password/register› account/password/register

client/account/password/thanks› account/password/thanks

client/statics/information/detail› information/:code

client/statics/information/index› information

client/statics/news/index› news

client/statics/news/detail› news/:y/:md

client/statics/about/company› company

client/statics/about/companymap› company/map

client/statics/about/rule› rule

client/statics/about/privacy› privacy

client/statics/about/privacypolicy› privacypolicy

client/statics/sitemap/index› sitemap

client/statics/campaign/app/ddt› campaign/2015/ddt/app

client/statics/campaign/app/travel› campaign/2018/travel/app

client/statics/campaign/app/ddt2018› campaign/2018/ddt/app

client/statics/campaign/index› campaign/:any

client/statics/senden/index› senden/:any

client/university/pref/$1/$2› chintai/:area_name/:pref_key/university

client/university/list/index/$1/$2› chintai/:area_name/university/list/:key

client/university/top› chintai/university/select

client/university/index/$1/$2› chintai/:area_name/university/:key

client/university/index/$1› chintai/:area_name/university

client/ownersearch/list/$1/$2› chintai/:area_name/:pref_key/owner-search/list

client/ownersearch/index/$1/$2› chintai/:area_name/:pref_key/owner-search

client/ownersearch/list_none/$1› chintai/:area_name/owner-search/list_none

client/ownersearch/list/$1› chintai/:area_name/owner-search/list

client/ownersearch/index/$1› chintai/:area_name/owner-search

client/ownersearch/list› chintai/owner-search/list

client/ownersearch/index› chintai/owner-search/select

client/ownersearch/detail/$1› chintai/owner/:num

client/pickup/list/$1/$2› chintai/:area_name/:pref_key/pickup

client/buildings/index/pickup/$1› chintai/:area_name/pickup

client/feature/index/$1› chintai/:area_name/feature

client/preflist/index/feature/$1/$2/$4/$3› chintai/:area_key/:pref_key/:area_id/feature/:feature_key

client/preflist/index/feature/$1/$2/$3› chintai/:area_key/:pref_key/feature/:feature_key

client/buildings/index/feature2/$1› chintai/feature/:urlkey

client/buildings/index/feature/$1/$2› chintai/:area_name/feature/:urlkey

client/feature/index› chintai/feature

client/ranking/index/$1› chintai/:area_name/ranking

client/list/index› chintai/list

client/list/index/$1› chintai/list/rtp/:room_type

client/pref/area/$1/$2› chintai/:area_key/:pref_key/area

client/area/index/$1› chintai/:area_name/area

client/preflist/index/station/$1/$2/$3/$4› chintai/:area_key/:pref_key/line/:line_cds/station/:station_g_cds

client/pref/stations/$1/$2/$3› chintai/:area_key/:pref_key/line/:line_cds/station

client/preflist/index/line/$1/$2/$3› chintai/:area_key/:pref_key/line/:line_cd

client/pref/lines/$1/$2› chintai/:area_key/:pref_key/line

client/line/index/$1› chintai/:area_name/line

client/line/pref› chintai/line

client/line/pref/$1/$2› chintai/:area_name/:pref_name/line

client/line/list/$1› chintai/:area_name/line/list

client/buildings/index/area/$1› chintai/:area_name/list

client/room/images/$1/$2› chintai/:area_name/:pref_name/:area_id/b:building_id/r:room_id/images/:key

client/room/images/$1/$2› chintai/:area_name/:pref_name/:area_id/b:building_id/r:room_id/images

client/room/comment/$1/$2› chintai/:area_name/:pref_name/:area_id/b:building_id/r:room_id/comment

client/room/index/$1/$2› chintai/:area_name/:pref_name/:area_id/b:building_id/r:room_id

client/building/index/$1› chintai/:area_name/:pref_name/:area_id/b:building_id

client/room/old/$1› chintai/:area_name/:pref_name/:area_id/:room_id

client/buildings/index/area/$1› chintai/:area_name/:pref_name/:area_id

client/buildings/index/area/$1› chintai/:area_name/:pref_name/list

client/pref/index/$1/$2› chintai/:area_key/:pref_key

client/mypage/index› mypage

client/mypage/message› mypage/message

client/mypage/message/$1› mypage/message/:num

client/mypage/message/building_detail/$1› mypage/message/detail/b/:num

client/mypage/message/detail/$1› mypage/message/detail/:num

client/mypage/message/input/$1› mypage/message/input/:room_id

client/mypage/message/input/$1/1› mypage/message/naiken/:room_id

client/mypage/message/sendmessage› mypage/message/sendmessage

client/mypage/message/sendbuildingmessage› mypage/message/sendbuildingmessage

client/mypage/message/thanks/$1/1› mypage/message/created/:room_id

client/mypage/message/thanks/$1/2› mypage/message/thanks/:room_id

client/mypage/message/thanks/$1/3› mypage/message/viewed/:room_id

client/mypage/message/diyrequest› mypage/message/diyrequest

client/mypage/rent/user/request/index› mypage/request

client/mypage/rent/user/request/edit/new› mypage/request/new

client/mypage/rent/user/request/newlist/index/$1› mypage/request/newlist/:request_id

client/mypage/rent/user/request/edit/edit/$1› mypage/request/edit/:request_id

client/mypage/rent/user/request/index/delete/$1› mypage/request/delete/:request_id

client/mypage/rent/user/request/edit/input› mypage/request/input

client/mypage/rent/user/request/edit/input/$1› mypage/request/input/:request_id

client/mypage/rent/user/request/edit/confirm› mypage/request/confirm

client/mypage/rent/user/request/edit/register› mypage/request/register

client/mypage/rent/user/request/edit/thanks› mypage/request/thanks

client/mypage/rent/user/request/edit/thanks› mypage/request/thanks/edit

client/mypage/rent/user/request/detail/proposal/$1/$2› mypage/request/detail/:request_id/:proposal_id

client/mypage/rent/user/request/detail/index/$1› mypage/request/detail/:request_id

client/mypage/news› mypage/news

client/mypage/news/$1› mypage/news/:num

client/mypage/favorite› mypage/favorite

client/mypage/favorite/$1› mypage/favorite/:num

client/mypage/history› mypage/history

client/mypage/history/$1› mypage/history/:num

client/auth/logout› mypage/logout

client/mypage/profile› mypage/profile

client/mypage/profile/input› mypage/profile/input

client/mypage/profile/confirm› mypage/profile/confirm

client/mypage/profile/register› mypage/profile/register

client/mypage/profile/imageviewer› mypage/profile/imageviewer

client/mypage/profile/mail› mypage/profile/mail

client/mypage/email› mypage/email

client/mypage/email› mypage/email/index

client/mypage/email/confirm› mypage/email/confirm

client/mypage/email/send› mypage/email/send

client/mypage/email/ock› mypage/email/ock/:ontimecode

client/mypage/email/finish› mypage/email/finish

client/mypage/questionnaire/confirm/$1› mypage/questionnaire/:ukey/confirm

client/mypage/questionnaire/register/$1› mypage/questionnaire/:ukey/register

client/mypage/questionnaire/thanks/$1› mypage/questionnaire/:ukey/thanks

client/mypage/questionnaire/close/$1› mypage/questionnaire/:ukey/close

client/mypage/questionnaire/index/$1› mypage/questionnaire/:ukey

client/mypage/matching/index› mypage/matching

client/mypage/matching/$1› mypage/matching/:num

client/mypage/campaign/input› mypage/campaign/input

client/mypage/campaign/check› mypage/campaign/check

client/mypage/campaign/end› mypage/campaign/end

client/mypage/moving/input› mypage/moving/input

client/mypage/moving/check› mypage/moving/check

client/mypage/moving/thanx› mypage/moving/thanx

client/mypage/moving/index› mypage/moving/index

client/mypage/enquete/input› mypage/enquete/input

client/mypage/enquete/check› mypage/enquete/check

client/mypage/enquete/thanx› mypage/enquete/thanx

client/mypage/enquete/index› mypage/enquete/index

client/mypage/enquete/index› mypage/enquete

client/blog/index› uchicomi-times

client/blog/index/tool› uchicomi-times/tool

client/blog/article/index/$2› uchicomi-times/category/:category/:alpha/(:num)

client/blog/search/sub/$1/$2› uchicomi-times/category/:category/(:alpha)

client/blog/search/index/$1› uchicomi-times/category/:category

client/blog/search/tag/$1› uchicomi-times/tag/:tag

client/blog/search/keyword/$1› uchicomi-times/search/:keyword

client/blog/article/index/$1› uchicomi-times/article/:article_id

client/blog/ranking› uchicomi-times/ranking

client/blog/author/index› uchicomi-times/author

client/blog/author/detail/$1› uchicomi-times/author/detail/:author_id

client/blog/archive/index/$1/$2› uchicomi-times/archive/:year/:month

client/blog/pickup/index› uchicomi-times/pickup

client/blog/sitemap/index› uchicomi-times/sitemap_news

client/blog/seminar/contact/confirm/$1› uchicomi-times/seminar/:ukey/contact/confirm

client/blog/seminar/contact/register/$1› uchicomi-times/seminar/:ukey/contact/register

client/blog/seminar/contact/thanks/$1› uchicomi-times/seminar/:ukey/contact/thanks

client/blog/seminar/contact/index/$1› uchicomi-times/seminar/:ukey/contact

client/blog/seminar/detail/$1› uchicomi-times/seminar/:ukey

client/blog/seminar/index› uchicomi-times/seminar

client/blog/contact/input/$1› uchicomi-times/contact/:ukey/input

client/blog/contact/confirm/$1› uchicomi-times/contact/:ukey/confirm

client/blog/contact/register/$1› uchicomi-times/contact/:ukey/register

client/blog/contact/thanks/$1› uchicomi-times/contact/:ukey/thanks

client/blog/contact/checkcontactform/$1› uchicomi-times/contact/:ukey/checkcontactform

client/blog/contact/index/$1› uchicomi-times/contact/:ukey

client/leave/index› leave

client/leave/index› leave/index

client/leave/confirm› leave/confirm

client/leave/register› leave/register

client/leave/end› leave/end

client/leave/owner› leave/owner

client/leave/owner/end› leave/owner/end

client/mypage/petit› mypage/petit

client/mypage/petit/$1› mypage/petit/:num

client/aplclose› aplclose

client/api/anshindial/csvdownload› api/anshindial/csvdownload

client/api/anshindial/csvdownload/login› api/anshindial/csvdownload/login

client/api/anshindial/csvdownload/dl› api/anshindial/csvdownload/dl

client/glossary› glossary

client/glossary/article/$1/$2› glossary/:column/:uri

client/glossary/column/$1› glossary/:column

client/mailmagazine/measure/redirect/$1› mailmagazine/measure/redirect/:key

agent

› browscap

true› › enabled

http://browscap.org/stream?q=Lite_PHP_BrowsCapINI› › url

wrapper› › method

/tmp/php_browscap.ini› › file

› cache

› › driver

604800› › expiry

fuel.agent› › identifier

session

true› auto_initialize

file› driver

false› match_ip

false› match_ua

› cookie_domain

/› cookie_path

null› cookie_http_only

true› encrypt_cookie

false› expire_on_close

7200› expiration_time

300› rotation_time

flash› flash_id

true› flash_auto_expire

true› flash_expire_after_get

› post_cookie_name

Session-Id› header_header_name

true› enable_cookie

› cookie

fuelcid› › cookie_name

› file

fuelfid› › cookie_name

/tmp› › path

5› › gc_probability

› memcached

fuelmid› › cookie_name

› › servers

› › › default

127.0.0.1› › › › host

11211› › › › port

100› › › › weight

› db

fueldid› › cookie_name

null› › database

sessions› › table

5› › gc_probability

› redis

fuelrid› › cookie_name

default› › database

true› native_emulation

crypt

Q1smHIRJsKd8zbUNvUzAoj7c› crypto_key

Y7MdmYCMwEoQMZ0ZOQUEQODQ› crypto_iv

qjgYv4yaMJD0w4MzFgAqcmJM› crypto_hmac

cache

file› driver

null› expiration

› file

› › path

› memcached

fuel› › cache_id

› › servers

› › › default

127.0.0.1› › › › host

11211› › › › port

100› › › › weight

› apc

fuel› › cache_id

› redis

default› › database

pagination

mypagination› active

› default

<div class="pagination"> {pagination} </div> › › wrapper

<span class="first"> {link} </span> › › first

««› › first-marker

<a href="{uri}">{page}</a> › › first-link

› › first-inactive

› › first-inactive-link

<span class="previous"> {link} </span> › › previous

«› › previous-marker

<a href="{uri}" rel="prev">{page}</a> › › previous-link

<span class="previous-inactive"> {link} </span> › › previous-inactive

<a href="#" rel="prev">{page}</a> › › previous-inactive-link

<span> {link} </span> › › regular

<a href="{uri}">{page}</a> › › regular-link

<span class="active"> {link} </span> › › active

<a href="#">{page}</a> › › active-link

<span class="next"> {link} </span> › › next

»› › next-marker

<a href="{uri}" rel="next">{page}</a> › › next-link

<span class="next-inactive"> {link} </span> › › next-inactive

<a href="#" rel="next">{page}</a> › › next-inactive-link

<span class="last"> {link} </span> › › last

»»› › last-marker

<a href="{uri}">{page}</a> › › last-link

› › last-inactive

› › last-inactive-link

› bootstrap

<div class="pagination"> <ul>{pagination} </ul> </div> › › wrapper

<li>{link}</li>› › first

««› › first-marker

<a href="{uri}">{page}</a>› › first-link

› › first-inactive

› › first-inactive-link

<li>{link}</li>› › previous

«› › previous-marker

<a href="{uri}" rel="prev">{page}</a>› › previous-link

<li class="disabled">{link}</li>› › previous-inactive

<a href="#" rel="prev">{page}</a>› › previous-inactive-link

<li>{link}</li>› › regular

<a href="{uri}">{page}</a>› › regular-link

<li class="active">{link}</li>› › active

<a href="#">{page}</a>› › active-link

<li>{link}</li>› › next

»› › next-marker

<a href="{uri}" rel="next">{page}</a>› › next-link

<li class="disabled">{link}</li>› › next-inactive

<a href="#" rel="next">{page}</a>› › next-inactive-link

<li>{link}</li>› › last

»»› › last-marker

<a href="{uri}">{page}</a>› › last-link

› › last-inactive

› › last-inactive-link

› mypagination

› › wrapper

{link}› › first

先頭› › first-marker

<a href="{uri}">{page}</a>› › first-link

› › first-inactive

› › first-inactive-link

<li>{link}</li>› › previous

<› › previous-marker

<a href="{uri}">{page}</a>› › previous-link

{link}› › previous-inactive

<a href="#">{page}</a>› › previous-inactive-link

<li>{link}</li>› › regular

<a href="{uri}">{page}</a>› › regular-link

<li class="on">{link}</li>› › active

{page}› › active-link

<li>{link}</li>› › next

>› › next-marker

<a href="{uri}">{page}</a>› › next-link

{link}› › next-inactive

<a href="#">{page}</a>› › next-inactive-link

{link}› › last

最後› › last-marker

<a href="{uri}">{page}</a>› › last-link

› › last-inactive

› › last-inactive-link

default› active

› default

pdo› › type

› › connection

false› › › persistent

false› › › compress

mysql:host=develop-cluster.cluster-c9l2niplkqym.ap-northeast-1.rds.amazonaws.com;dbname=uchicomidev2› › › dsn

uchicomi› › › username

gQG4xvTRJyEg› › › password

`› › identifier

› › table_prefix

utf8› › charset

false› › enable_cache

true› › profiling

› redis

› › default

127.0.0.1› › › hostname

6379› › › port

null› › › timeout

› wp

pdo› › type

› › connection

false› › › persistent

`› › identifier

› › table_prefix

utf8› › charset

true› › enable_cache

false› › profiling

› slave

pdo› › type

› › connection

mysql:host=develop-cluster.cluster-c9l2niplkqym.ap-northeast-1.rds.amazonaws.com;dbname=uchicomidev2› › › dsn

uchicomi› › › username

gQG4xvTRJyEg› › › password

false› › › persistent

false› › › compress

`› › identifier

› › table_prefix

utf8› › charset

false› › enable_cache

true› › profiling

asset

› paths

assets/› › 0

img/› img_dir

js/› js_dir

css/› css_dir

› folders

› › css

assets/jquery/css› › › 0

› › js

assets/jquery/js› › › 0

› › img

assets/img_rent› › › 0

assets/img_sell› › › 1

assets/img_profile› › › 2

assets/img_feature› › › 3

assets/img_adminnews› › › 4

assets/img_banner› › › 5

assets/img_adminnews_category› › › 6

assets/img_news› › › 7

assets/img_voices› › › 8

assets/img_seminar› › › 9

assets/img_seminar_lecturer› › › 10

assets/img_ques› › › 11

assets/img_rooms_360› › › 12

assets/img_blog_author› › › 13

assets/img_blog_innerlink› › › 14

assets/img_blog_medialibrary› › › 15

assets/img_blog_article› › › 16

https://dev2.uchicomi.biz/› url

true› add_mtime

1› indent_level

› indent_with

true› auto_render

true› fail_silently

form

true› prep_value

true› auto_id

form_› auto_id_prefix

post› form_method

{open} <table> {fields} </table> {close} › form_template

<tr> <td class="{error_class}">{label}{required}</td> <td class="{error_class}">{field} <span>{description}</span> {error_msg}</td> </tr> › field_template

<tr> <td class="{error_class}">{group_label}{required}</td> <td class="{error_class}">{fields} {field} {label}<br /> {fields}<span>{description}</span> {error_msg} </td> </tr> › multi_field_template

<span>{error_msg}</span>› error_template

<span>{label}</span>› group_label

*› required_mark

false› inline_errors

null› error_class

null› label_class

<table>{fields}</table> › tabular_form_template

{field}› tabular_field_template

<tr>{fields}</tr> › tabular_row_template

<td>{label}{required} {field} {error_msg}</td> › tabular_row_field_template

Delete?› tabular_delete_label

18

Session variables

nullapl_string

glossary/a/anchor-bolt#METHOD#GETclient_beforeUri

chintai/feature/installment#METHOD#GETclient_currentUri

false

/chintai/feature/installment/list_url

list_feature_installmentlist_ses_key

list_feature_installment

› price_id

› prefs

› pref_id

› line_cd

› line_cds

› wait_room

› keyword

new› order

2› page

10› limit

10› offset

1

GET variables

2page

初期費用分割相談可特集 2/8ページ

Console

Load Time

Database

Memory Used

Included

items loaded

vars loaded

vars loaded

vars loaded

Logs

Errors

Memory

Speed

Load Time

Max Execution Time

Total Queries

Total Time

Duplicates

This panel has no log items.

Finder Paths

Total Files

Total Size

Largest

Configuration items

Session variables

GET variables

This panel has no POST variables.