現在、こちらのお部屋は募集をしておりません。
該当物件の掲載は終了しました。
| 所在地 | 〒1500043 東京都渋谷区 | ||||||
|---|---|---|---|---|---|---|---|
| 交通 | |||||||
| 間取り | 3SLDK | 専有面積 | 22.00m2 | 築年月 | 1967年11月築 | 建物構造 | テラスハウス/鉄筋コンクリート造 |
| 所在階 / 階数 | 2階/ 地上4階 地下3階 建 | 駐車場 | 駐車場なし | バイク置き場 | バイク置き場なし | 駐輪場 | 駐輪場なし |
10
Console |
1.413 s
Load Time |
118 Queries
Database |
5.55 MB
Memory Used |
163 Files
Included |
684 Config
items loaded |
4 Session
vars loaded |
0 GET
vars loaded |
0 POST
vars loaded |
3Logs |
0 Errors |
0 Memory |
7 Speed |
| speed | 1.102 msFuel\Core\Profiler::init Start |
| speed | 4.383 msFuel\Core\Fuel::init End |
| speed | 4.460 msFuel\Core\Uri::__construct Start |
| speed | 4.526 msFuel\Core\Uri::__construct End |
| log | Fuel\Core\Request::__construct - Creating a new Request with URI = "chintai/kanto/tokyo/13113/b11674/r29513" |
| speed | 5.369 msFuel\Core\Request::execute Start |
| log | Fuel\Core\Request::execute - Called |
| log | Fuel\Core\Request::execute - Setting main Request |
| speed | 445.714 msFuel\Core\Request::execute End |
| speed | 1.116 sEnd of Fuel Execution |
1.413 sLoad Time |
240 s Max Execution Time |
1.102 msFuel\Core\Profiler::init Start |
4.383 msFuel\Core\Fuel::init End |
4.460 msFuel\Core\Uri::__construct Start |
4.526 msFuel\Core\Uri::__construct End |
5.369 msFuel\Core\Request::execute Start |
445.714 msFuel\Core\Request::execute End |
1.116 sEnd of Fuel Execution |
118Total Queries |
293.614 ms Total Time |
32 Duplicates |
| 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, 1, 3, 4) AND `r`.`id` = '29513' ORDER BY `room_name` ASCSpeed: 2.283 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('29513') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.231 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('29513') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.196 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('29513')Speed: 1.958 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('11674') ORDER BY `r1`.`updated_at` DESCSpeed: 2.878 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 1 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('11674') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.175 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('11674') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.298 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 56File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('11674') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.246 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 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 56File: APPPATH/modules/client/classes/controller/room.php, line 123File: 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 ('47063')Speed: 1.947 ms Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 56File: APPPATH/modules/client/classes/controller/room.php, line 123File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b 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 b.id=11674Speed: 2.185 ms Query analysis: · 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 416File: APPPATH/modules/client/classes/controller/room.php, line 129File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT `b`.`use_flg` AS `building_use_flg`, `r`.`use_flg` AS `room_use_flg`, `owner`.`del_flg` AS `owner_del_flg`, `agent`.`del_flg` AS `agent_del_flg`, `agent`.`agent_approval` AS `agent_approval`, `b`.`owner_id` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `owner` ON (`b`.`owner_id` = `owner`.`id`) LEFT JOIN `mst_user` AS `agent` ON (`b`.`agent_id` = `agent`.`id`) WHERE `r`.`id` = '29513'Speed: 2.204 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/controller/room.php, line 55File: APPPATH/modules/client/classes/controller/room.php, line 141File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT COUNT(e.id) FROM `event_log` AS `e` WHERE `log_ptn` = '2' AND `e`.`room_id` = '29513'Speed: 2.114 ms Query analysis: · Query: SIMPLE on e · Possible keys: log_ptn,room_id · Key Used: room_id · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/model/event/log.php, line 68File: APPPATH/modules/client/classes/controller/room.php, line 245File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT `t0`.`id` AS `t0_c0`, `t0`.`client_id` AS `t0_c1`, `t0`.`room_id` AS `t0_c2`, `t0`.`created_at` AS `t0_c3` FROM `favorite` AS `t0` WHERE `t0`.`room_id` = '29513'Speed: 2.138 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: room_id · Key Used: room_id · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/model/favorite.php, line 42File: APPPATH/modules/client/classes/controller/room.php, line 246File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT `r`.`id` FROM `buildings` AS `b` JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id`) WHERE `b`.`id` != '11674' AND `b`.`owner_id` = '47063' AND `b`.`use_flg` = 0 AND (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) ORDER BY RAND() LIMIT 4 OFFSET 0Speed: 2.523 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: owner_id · Type: range · Rows: 11 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on r · 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/room.php, line 474File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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`.`id` = '29512' ORDER BY `room_name` ASCSpeed: 2.274 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29512') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.259 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29512') 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: 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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29512')Speed: 2.031 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 4 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11624') ORDER BY `r1`.`updated_at` DESCSpeed: 2.944 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 4 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11624') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.278 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11624') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 6.053 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11624') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.317 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 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('47063')Speed: 1.992 ms · DUPLICATE Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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`.`id` = '29494' ORDER BY `room_name` ASCSpeed: 2.258 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29494') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.225 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29494') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.165 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29494')Speed: 2.019 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 2 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11656') ORDER BY `r1`.`updated_at` DESCSpeed: 2.890 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 1 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11656') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.213 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11656') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.312 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11656') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.220 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 11 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('47063')Speed: 1.963 ms · DUPLICATE Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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`.`id` = '29552' ORDER BY `room_name` ASCSpeed: 2.241 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29552') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.210 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29552') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.204 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29552')Speed: 2.011 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11702') ORDER BY `r1`.`updated_at` DESCSpeed: 2.875 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11702') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.213 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11702') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.196 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 74File: APPPATH/modules/client/classes/model/buildings.php, line 657File: APPPATH/modules/client/classes/model/buildings.php, line 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11702') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.130 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('47063')Speed: 1.958 ms · DUPLICATE Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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`.`id` = '29453' ORDER BY `room_name` ASCSpeed: 2.207 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29453') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.424 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 29 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29453') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.289 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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('29453')Speed: 1.991 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 51File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11631') ORDER BY `r1`.`updated_at` DESCSpeed: 2.819 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 1 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11631') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.146 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11631') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 6.063 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11631') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.325 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 13 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('47063')Speed: 1.988 ms · DUPLICATE Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 56File: APPPATH/modules/client/classes/controller/room.php, line 478File: APPPATH/modules/client/classes/controller/room.php, line 250File: 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 ('11674') ORDER BY `r1`.`updated_at` DESCSpeed: 3.005 ms · DUPLICATE Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 1 (Using where) · 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 187File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: 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 ('11674') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.389 ms · DUPLICATE Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 187File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: 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 ('11674') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.311 ms · DUPLICATE Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 187File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: 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 ('11674') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.242 ms · DUPLICATE 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 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: 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 ('47063')Speed: 1.973 ms · DUPLICATE Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 187File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: 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` = '11674' AND `r`.`id` != '29513' ORDER BY `room_name` ASCSpeed: 2.426 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id,use_flg · Key Used: building_id · Type: range · 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 194File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: 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` = '11674'Speed: 2.240 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 197File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: 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, 1, 3, 4) AND `r`.`building_id` = '11674' AND `r`.`id` != '29513' ORDER BY `room_name` ASCSpeed: 2.409 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id,use_flg · Key Used: building_id · Type: range · 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 224File: APPPATH/modules/client/classes/model/buildings.php, line 40File: APPPATH/modules/client/classes/controller/room.php, line 261File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT COUNT(id) AS `cnt` FROM `owner_attributes` WHERE `del_flg` = 0 AND `id` = '47063'Speed: 2.164 ms Query analysis: · Query: SIMPLE on owner_attributes · Possible keys: PRIMARY,owner_attributes_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/model/owner/attribute.php, line 124File: APPPATH/classes/model/owner/attribute.php, line 133File: APPPATH/modules/client/classes/controller/room.php, line 278File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT `t0`.`id` AS `t0_c0`, `t0`.`nickname` AS `t0_c1`, `t0`.`birthday` AS `t0_c2`, `t0`.`sex` AS `t0_c3`, `t0`.`history` AS `t0_c4`, `t0`.`pref` AS `t0_c5`, `t0`.`area_cd` AS `t0_c6`, `t0`.`shop` AS `t0_c7`, `t0`.`live_people_kind` AS `t0_c8`, `t0`.`ques1` AS `t0_c9`, `t0`.`ques2` AS `t0_c10`, `t0`.`ques3` AS `t0_c11`, `t0`.`ques4` AS `t0_c12`, `t0`.`ques5` AS `t0_c13`, `t0`.`ques5_note` AS `t0_c14`, `t0`.`ques6` AS `t0_c15`, `t0`.`ques6_note` AS `t0_c16`, `t0`.`ques7` AS `t0_c17`, `t0`.`ques7_note` AS `t0_c18`, `t0`.`ques8` AS `t0_c19`, `t0`.`ques8_note` AS `t0_c20`, `t0`.`ques9` AS `t0_c21`, `t0`.`ques9_note` AS `t0_c22`, `t0`.`ques10` AS `t0_c23`, `t0`.`ques10_note` AS `t0_c24`, `t0`.`ques11` AS `t0_c25`, `t0`.`ques11_note` AS `t0_c26`, `t0`.`ques12` AS `t0_c27`, `t0`.`ques12_note` AS `t0_c28`, `t0`.`ques13` AS `t0_c29`, `t0`.`ques13_note` AS `t0_c30`, `t0`.`ques14` AS `t0_c31`, `t0`.`ques14_note` AS `t0_c32`, `t0`.`ques15` AS `t0_c33`, `t0`.`ques15_note` AS `t0_c34`, `t0`.`ques16` AS `t0_c35`, `t0`.`ques16_note` AS `t0_c36`, `t0`.`ques17` AS `t0_c37`, `t0`.`ques17_note` AS `t0_c38`, `t0`.`ques18` AS `t0_c39`, `t0`.`ques18_note` AS `t0_c40`, `t0`.`ques19` AS `t0_c41`, `t0`.`ques19_note` AS `t0_c42`, `t0`.`ques20` AS `t0_c43`, `t0`.`ques20_note` AS `t0_c44`, `t0`.`ques21` AS `t0_c45`, `t0`.`ques21_note` AS `t0_c46`, `t0`.`ques22` AS `t0_c47`, `t0`.`ques22_note` AS `t0_c48`, `t0`.`ques23` AS `t0_c49`, `t0`.`ques23_note` AS `t0_c50`, `t0`.`del_flg` AS `t0_c51`, `t0`.`created_at` AS `t0_c52`, `t0`.`updated_at` AS `t0_c53` FROM `owner_attributes` AS `t0` WHERE `t0`.`id` = '47063' AND `t0`.`del_flg` = 0 LIMIT 1Speed: 2.425 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY,owner_attributes_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/owner/attribute.php, line 137File: APPPATH/modules/client/classes/controller/room.php, line 278File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT `agent`.`id`, `agent`.`company_name`, `agent`.`corporation_zip_code`, `agent`.`corporation_address`, `agent`.`corporation_tel`, `agent`.`takken_license_no`, `agent`.`takken_license_no_num`, `agent`.`takken_license_kbn` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `agent` ON (`b`.`agent_id` = `agent`.`id`) WHERE `b`.`use_flg` = 0 AND `agent`.`del_flg` = 0 AND `r`.`id` = '29513'Speed: 2.265 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,agent_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/controller/room.php, line 338File: 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, 1, 3, 4) AND `r`.`id` = '29513' ORDER BY `room_name` ASCSpeed: 2.358 ms · DUPLICATE Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29513') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.231 ms · DUPLICATE Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29513') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.157 ms · DUPLICATE Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29513')Speed: 1.961 ms · DUPLICATE Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11674') ORDER BY `r1`.`updated_at` DESCSpeed: 2.968 ms · DUPLICATE Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 1 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11674') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.174 ms · DUPLICATE Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11674') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.242 ms · DUPLICATE Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 56File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11674') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.244 ms · DUPLICATE 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 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 56File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('47063')Speed: 1.956 ms · DUPLICATE Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 56File: APPPATH/modules/client/classes/controller/room.php, line 647File: APPPATH/modules/client/classes/controller/room.php, line 427File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT DISTINCT `r`.`id` FROM `buildings` AS `b` JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id`) WHERE `b`.`use_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`id` != '29513' AND `b`.`pref_id` = '13' AND `b`.`area_cd` = '13113' ORDER BY RAND() ASC LIMIT 5Speed: 2.782 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg,pref_id,area_cd · Key Used: area_cd,use_flg · Type: index_merge · Rows: 3 (Using intersect(area_cd,use_flg); Using where; Using temporary; Using filesort) · Query: SIMPLE on r · Possible keys: PRIMARY,building_id,use_flg,contract_flg,lease_type,lease_year,arrange,floor_cnt,sikikin_tani,reikin_tani,hosyokin_tani,syoukyakukin_tani,in_tax · Key Used: building_id · Type: ref · Rows: 2 (Using index condition; Using where) Call trace for this query:File: APPPATH/modules/client/classes/controller/room.php, line 658File: APPPATH/modules/client/classes/controller/room.php, line 427File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT DISTINCT `r`.`id` FROM `buildings` AS `b` JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id`) WHERE `b`.`use_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`id` != '29513' AND `b`.`pref_id` = '13' AND `r`.`rent_price` >= 217222 AND `r`.`rent_price` <= 227222 ORDER BY RAND() ASC LIMIT 5Speed: 5.604 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg,pref_id · Key Used: use_flg,pref_id · Type: index_merge · Rows: 151 (Using intersect(use_flg,pref_id); Using where; Using index; Using temporary; Using filesort) · Query: SIMPLE on r · Possible keys: PRIMARY,building_id,use_flg,contract_flg,lease_type,lease_year,arrange,floor_cnt,sikikin_tani,reikin_tani,hosyokin_tani,syoukyakukin_tani,in_tax · Key Used: building_id · Type: ref · Rows: 2 (Using index condition; Using where) Call trace for this query:File: APPPATH/modules/client/classes/controller/room.php, line 667File: APPPATH/modules/client/classes/controller/room.php, line 427File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
| SELECT DISTINCT `r`.`id` FROM `buildings` AS `b` JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id`) WHERE `b`.`use_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`id` != '29513' AND `b`.`pref_id` = '13' AND `r`.`arrange` = '18' ORDER BY RAND() ASC LIMIT 5Speed: 19.006 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id,use_flg,contract_flg,lease_type,lease_year,arrange,floor_cnt,sikikin_tani,reikin_tani,hosyokin_tani,syoukyakukin_tani,in_tax · Key Used: arrange · Type: range · Rows: 94 (Using index condition; Using where; Using temporary; Using filesort) · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg,pref_id · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where; Distinct) Call trace for this query:File: APPPATH/modules/client/classes/controller/room.php, line 692File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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, 1, 3, 4) AND `r`.`id` = '29494' ORDER BY `room_name` ASCSpeed: 2.293 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29494') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.221 ms · DUPLICATE Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29494') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.116 ms · DUPLICATE Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29494')Speed: 1.983 ms · DUPLICATE Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 2 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11656') ORDER BY `r1`.`updated_at` DESCSpeed: 2.766 ms · DUPLICATE Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 1 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11656') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.139 ms · DUPLICATE Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11656') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.215 ms · DUPLICATE Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11656') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.124 ms · DUPLICATE Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 11 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('47063')Speed: 1.907 ms · DUPLICATE Query analysis: · Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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, 1, 3, 4) AND `r`.`id` = '29460' ORDER BY `room_name` ASCSpeed: 2.164 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29460') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.131 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29460') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.077 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29460')Speed: 1.918 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 4 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') ORDER BY `r1`.`updated_at` DESCSpeed: 2.759 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.140 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.182 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 11 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.125 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 6 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('33127')Speed: 1.902 ms Query analysis: · Query: SIMPLE (no matching row in const table) 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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, 1, 3, 4) AND `r`.`id` = '29472' ORDER BY `room_name` ASCSpeed: 2.220 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29472') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.146 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29472') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.284 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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29472')Speed: 1.925 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 2 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11634') ORDER BY `r1`.`updated_at` DESCSpeed: 2.769 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11634') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.145 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11634') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.177 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 74File: APPPATH/modules/client/classes/model/buildings.php, line 657File: APPPATH/modules/client/classes/model/buildings.php, line 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11634') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.215 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 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('33127')Speed: 1.906 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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, 1, 3, 4) AND `r`.`id` = '29461' ORDER BY `room_name` ASCSpeed: 2.145 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29461') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.148 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29461') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.092 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29461')Speed: 1.952 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 4 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') ORDER BY `r1`.`updated_at` DESCSpeed: 2.876 ms · DUPLICATE Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.188 ms · DUPLICATE Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.231 ms · DUPLICATE Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 11 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11635') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.204 ms · DUPLICATE Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 6 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('33127')Speed: 1.959 ms · DUPLICATE Query analysis: · Query: SIMPLE (no matching row in const table) 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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, 1, 3, 4) AND `r`.`id` = '29473' ORDER BY `room_name` ASCSpeed: 2.214 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: const · Rows: 0 (unique row not found) Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29473') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.232 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29473') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 3.036 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 1 (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 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('29473')Speed: 2.001 ms Query analysis: · Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 2 Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 51File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11640') ORDER BY `r1`.`updated_at` DESCSpeed: 2.833 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort) · Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · 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: const · 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: 1 (Using where) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11640') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.217 ms Query analysis: · Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary) · 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11640') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.270 ms Query analysis: · Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id,article_type · Type: index_merge · Rows: 1 (Using intersect(article_id,article_type); 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('11640') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.185 ms Query analysis: · Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 12 (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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: 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 ('50059')Speed: 1.932 ms Query analysis: · Query: SIMPLE (no matching row in const table) 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 56File: APPPATH/modules/client/classes/controller/room.php, line 754File: APPPATH/modules/client/classes/controller/room.php, line 427File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
6Finder Paths |
163Total Files |
1.68 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 |
| 31.25 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/controller/room.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 |
| 33.00 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/model/buildings.php |
| 367 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/notfound.php |
| 10.24 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/db.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 |
| 5.22 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/database/query.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 |
| 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 |
| 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 |
| 4.37 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache.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 |
| 56.85 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/common/list_cache.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 |
| 1.41 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/mst/pref.php |
| 470 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/classes/cache/handler/string.php |
| 2.72 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/common/clinetHistoryUrl.php |
| 943 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/core/config/date.php |
| 428 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/date.php |
| 14.16 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/common/file.php |
| 6.23 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/common/accountConfig.php |
| 405 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/config/staging/account.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 |
| 144 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/view/room/soft404.php |
| 3.99 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/view/base.php |
| 2.26 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/event/log.php |
| 1.47 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/favorite.php |
| 33.06 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/core/orm/query.php |
| 141.27 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/classes/controller/statics/senden.php |
| 3.08 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/owner/attribute.php |
| 12.80 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/orm/classes/observer/typing.php |
| 7.14 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/orm/classes/hasone.php |
| 3.98 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/packages/orm/classes/relation.php |
| 4.30 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/feature.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 |
| 20.44 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/room/soft404.php |
| 64 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/layout/pankuzu_home.php |
| 229 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/mst/roomarrange.php |
| 220 bytes /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/model/mst/roomtype.php |
| 5.12 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/classes/common/webp.php |
| 7.72 kB /var/www/html/dev2.uchicomi.biz/uchicomi/fuel/app/modules/client/views/2017_pc/mypage/message/_form2.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 |
| 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 |
| 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 |
684 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 |
| cookie |
| 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-20› › 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 |
| db |
| 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 |
| 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 |
| date |
| › patterns |
| %c› › local |
| %Y-%m-%d %H:%M:%S› › mysql |
| %Y-%m-%d› › mysql_date |
| %m/%d/%Y› › us |
| %m/%d› › us_short |
| %B %d %Y› › us_named |
| %I:%M %p, %B %d %Y› › us_full |
| %d/%m/%Y› › eu |
| %d/%m› › eu_short |
| %d %B %Y› › eu_named |
| %H:%M, %d %B %Y› › eu_full |
| %H:%M› › 24h |
| %I:%M %p› › 12h |
| %Y› › y |
| %m› › m |
| %d› › d |
| %H› › h |
| %Y/%月› › ym |
| %Y/%m/%d› › ymd |
| %Y年%m月%d日› › wymd |
| %Y/%m/%d %H:%M› › time |
| %Y/%m/%d %H:%M:%S› › timestamp |
| %H:%M› › hm |
| %H時%M分› › whm |
| %H時› › wh |
| %H:%M:%S› › hms |
| 507apple |
| 14468owner_ad |
| agent_id_ulti |
| 17› 0 |
| 24684› 1 |
| 40579› 2 |
| 50050› 3 |
| owner_test |
| 445› 0 |
| 486› 1 |
| ichiba_preview |
| 50059› 0 |
| 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 |
4 Session variables |
| nullapl_string |
| chintai/kansai/kyoto/26101/b8735/r20943#METHOD#GETclient_beforeUri |
| chintai/kanto/tokyo/13113/b11674/r29513#METHOD#GETclient_currentUri |
| false |
| Based on PHP Quick Profiler | Close Height Bottom |