Buildings | Tamachi Living

物件タイプ	マンション
最寄り駅	JR山手線　田町　6分都営三田線　三田　4分都営浅草線　三田　4分
所在地	東京都港区芝
構造	鉄筋コンクリート
階建	6階建て
築年月	2001年03月
こだわり条件

物件タイプ

マンション

最寄り駅

JR山手線　田町　6分
都営三田線　三田　4分
都営浅草線　三田　4分

所在地

東京都港区芝

構造

鉄筋コンクリート

階建

6階建て

築年月

2001年03月

こだわり条件

部屋番号	間取り	面積	敷金	礼金	賃料	階
601	1K	0.00㎡	109000ヶ月	109000ヶ月	109,000円	0階

部屋番号

間取り

面積

敷金

礼金

賃料

階

601

0.00㎡

109000ヶ月

109,000円

0階

(default) 17 queries took 9 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Tenant`.`id`, `Tenant`.`email`, `Tenant`.`password`, `Tenant`.`created`, `Tenant`.`modified`, `Tenant`.`display_name`, `Tenant`.`deleted` FROM `LAA0189369-onetwo`.`tenants` AS `Tenant` WHERE `Tenant`.`id` = 1 LIMIT 1	1	1	1
2	SELECT `Apartment`.`id`, `Apartment`.`tenant_id`, `Apartment`.`building_id`, `Apartment`.`no`, `Apartment`.`comment`, `Apartment`.`attention`, `Apartment`.`room_no`, `Apartment`.`floor`, `Apartment`.`status_id`, `Apartment`.`layout_id`, `Apartment`.`layout_detail`, `Apartment`.`floor_space`, `Apartment`.`price`, `Apartment`.`key_money`, `Apartment`.`deposit`, `Apartment`.`renewal_fee`, `Apartment`.`management_fee`, `Apartment`.`shared_fee`, `Apartment`.`mode_of_transaction_id`, `Apartment`.`security_deposit`, `Apartment`.`insurance_fee`, `Apartment`.`insurance_no_flg`, `Apartment`.`conditions`, `Apartment`.`lease_for_year`, `Apartment`.`lease_for_month`, `Apartment`.`for_until_id`, `Apartment`.`fixed_term_flg`, `Apartment`.`contract_note`, `Apartment`.`next_update_at`, `Apartment`.`youtube_link`, `Apartment`.`memo`, `Apartment`.`view_room_no_flg`, `Apartment`.`photo_1_file_name`, `Apartment`.`photo_2_file_name`, `Apartment`.`photo_3_file_name`, `Apartment`.`photo_4_file_name`, `Apartment`.`photo_5_file_name`, `Apartment`.`photo_6_file_name`, `Apartment`.`photo_7_file_name`, `Apartment`.`caption_1`, `Apartment`.`caption_2`, `Apartment`.`caption_3`, `Apartment`.`caption_4`, `Apartment`.`caption_5`, `Apartment`.`caption_6`, `Apartment`.`caption_7`, `Apartment`.`panorama_src`, `Apartment`.`view_panorama_list_flg`, `Apartment`.`panorama_comment`, `Apartment`.`view_panorama_sidebat_flg`, `Apartment`.`last_change_status_date`, `Apartment`.`created`, `Apartment`.`modified` FROM `LAA0189369-onetwo`.`apartments` AS `Apartment` WHERE `Apartment`.`tenant_id` = (1)	6	6	1
3	SELECT `Building`.`id`, `Building`.`tenant_id`, `Building`.`building_kind_id`, `Building`.`construction_kind_id`, `Building`.`floors`, `Building`.`build_at`, `Building`.`ekidata_station_id`, `Building`.`ekidata_station_2_id`, `Building`.`ekidata_station_3_id`, `Building`.`time_to_bus`, `Building`.`time_to_bus_2`, `Building`.`time_to_bus_3`, `Building`.`time_to_walk`, `Building`.`time_to_walk_2`, `Building`.`time_to_walk_3`, `Building`.`bus_station_name`, `Building`.`bus_station_2_name`, `Building`.`bus_station_3_name`, `Building`.`zipcode`, `Building`.`pref_id`, `Building`.`address1`, `Building`.`address2`, `Building`.`name`, `Building`.`catchcopy`, `Building`.`comment`, `Building`.`youtube_link`, `Building`.`memo`, `Building`.`view_name_no_flg`, `Building`.`view_flg`, `Building`.`photo_1_file_name`, `Building`.`photo_2_file_name`, `Building`.`photo_3_file_name`, `Building`.`photo_4_file_name`, `Building`.`photo_5_file_name`, `Building`.`caption_1`, `Building`.`caption_2`, `Building`.`caption_3`, `Building`.`caption_4`, `Building`.`caption_5`, `Building`.`created`, `Building`.`modified` FROM `LAA0189369-onetwo`.`buildings` AS `Building` WHERE `Building`.`tenant_id` = (1)	6	6	1
4	SELECT `BusinessCondminium`.`id`, `BusinessCondminium`.`tenant_id`, `BusinessCondminium`.`building_id`, `BusinessCondminium`.`no`, `BusinessCondminium`.`name`, `BusinessCondminium`.`name_kana`, `BusinessCondminium`.`comment`, `BusinessCondminium`.`room_no`, `BusinessCondminium`.`floor`, `BusinessCondminium`.`households`, `BusinessCondminium`.`use_type_id`, `BusinessCondminium`.`status_id`, `BusinessCondminium`.`layout_id`, `BusinessCondminium`.`floor_space`, `BusinessCondminium`.`balcony_space`, `BusinessCondminium`.`price`, `BusinessCondminium`.`management_fee`, `BusinessCondminium`.`maintenance_fee`, `BusinessCondminium`.`maintenance_fund_fee`, `BusinessCondminium`.`car_parking_premium`, `BusinessCondminium`.`car_parking_price`, `BusinessCondminium`.`delivery_date_type_id`, `BusinessCondminium`.`delivery_date`, `BusinessCondminium`.`mode_of_transaction_id`, `BusinessCondminium`.`brokerage_fee`, `BusinessCondminium`.`transaction_company_id`, `BusinessCondminium`.`next_update_at`, `BusinessCondminium`.`photo_layout_file_name`, `BusinessCondminium`.`photo_1_file_name`, `BusinessCondminium`.`photo_2_file_name`, `BusinessCondminium`.`photo_3_file_name`, `BusinessCondminium`.`photo_4_file_name`, `BusinessCondminium`.`photo_5_file_name`, `BusinessCondminium`.`photo_6_file_name`, `BusinessCondminium`.`memo`, `BusinessCondminium`.`created`, `BusinessCondminium`.`modified` FROM `LAA0189369-onetwo`.`business_condminia` AS `BusinessCondminium` WHERE `BusinessCondminium`.`tenant_id` = (1)	0	0	0
5	SELECT `BusinessHouse`.`id`, `BusinessHouse`.`tenant_id`, `BusinessHouse`.`building_id`, `BusinessHouse`.`no`, `BusinessHouse`.`name`, `BusinessHouse`.`name_kana`, `BusinessHouse`.`comment`, `BusinessHouse`.`division_no`, `BusinessHouse`.`use_type_id`, `BusinessHouse`.`status_id`, `BusinessHouse`.`layout_id`, `BusinessHouse`.`price`, `BusinessHouse`.`right_of_site_id`, `BusinessHouse`.`land_rent_type_id`, `BusinessHouse`.`land_rent_fee`, `BusinessHouse`.`land_rent_term_years`, `BusinessHouse`.`land_rent_term_type_id`, `BusinessHouse`.`delivery_date_type_id`, `BusinessHouse`.`delivery_date`, `BusinessHouse`.`mode_of_transaction_id`, `BusinessHouse`.`brokerage_fee`, `BusinessHouse`.`transaction_company_id`, `BusinessHouse`.`land_space`, `BusinessHouse`.`land_space_type_id`, `BusinessHouse`.`road_of_expence_type_id`, `BusinessHouse`.`road_space`, `BusinessHouse`.`class_of_land_id`, `BusinessHouse`.`use_distinct_id`, `BusinessHouse`.`building_land_ratio_1`, `BusinessHouse`.`floor_area_ratio_1`, `BusinessHouse`.`class_of_land_2_id`, `BusinessHouse`.`use_distinct_2_id`, `BusinessHouse`.`building_land_ratio_2`, `BusinessHouse`.`floor_area_ratio_2`, `BusinessHouse`.`setback_space`, `BusinessHouse`.`road_kind_id_1`, `BusinessHouse`.`road_direction_id_1`, `BusinessHouse`.`road_width_1`, `BusinessHouse`.`connecting_road_width_1`, `BusinessHouse`.`road_kind_id_2`, `BusinessHouse`.`road_direction_id_2`, `BusinessHouse`.`road_width_2`, `BusinessHouse`.`connecting_road_width_2`, `BusinessHouse`.`road_kind_id_3`, `BusinessHouse`.`road_direction_id_3`, `BusinessHouse`.`road_width_3`, `BusinessHouse`.`connecting_road_width_3`, `BusinessHouse`.`road_kind_id_4`, `BusinessHouse`.`road_direction_id_4`, `BusinessHouse`.`road_width_4`, `BusinessHouse`.`connecting_road_width_4`, `BusinessHouse`.`photo_layout_file_name`, `BusinessHouse`.`photo_1_file_name`, `BusinessHouse`.`photo_2_file_name`, `BusinessHouse`.`photo_3_file_name`, `BusinessHouse`.`photo_4_file_name`, `BusinessHouse`.`photo_5_file_name`, `BusinessHouse`.`photo_6_file_name`, `BusinessHouse`.`next_update_at`, `BusinessHouse`.`memo`, `BusinessHouse`.`created`, `BusinessHouse`.`modified` FROM `LAA0189369-onetwo`.`business_houses` AS `BusinessHouse` WHERE `BusinessHouse`.`tenant_id` = (1)	0	0	1
6	SELECT `Condminium`.`id`, `Condminium`.`tenant_id`, `Condminium`.`building_id`, `Condminium`.`no`, `Condminium`.`name`, `Condminium`.`name_kana`, `Condminium`.`comment`, `Condminium`.`room_no`, `Condminium`.`floor`, `Condminium`.`households`, `Condminium`.`use_type_id`, `Condminium`.`status_id`, `Condminium`.`layout_id`, `Condminium`.`floor_space`, `Condminium`.`balcony_space`, `Condminium`.`price`, `Condminium`.`management_fee`, `Condminium`.`maintenance_fee`, `Condminium`.`maintenance_fund_fee`, `Condminium`.`car_parking_premium`, `Condminium`.`car_parking_price`, `Condminium`.`delivery_date_type_id`, `Condminium`.`delivery_date`, `Condminium`.`mode_of_transaction_id`, `Condminium`.`right_of_site_id`, `Condminium`.`management_type_id`, `Condminium`.`brokerage_fee`, `Condminium`.`transaction_company_id`, `Condminium`.`photo_layout_file_name`, `Condminium`.`photo_1_file_name`, `Condminium`.`photo_2_file_name`, `Condminium`.`photo_3_file_name`, `Condminium`.`photo_4_file_name`, `Condminium`.`photo_5_file_name`, `Condminium`.`photo_6_file_name`, `Condminium`.`next_update_at`, `Condminium`.`memo`, `Condminium`.`created`, `Condminium`.`modified` FROM `LAA0189369-onetwo`.`condminia` AS `Condminium` WHERE `Condminium`.`tenant_id` = (1)	0	0	1
7	SELECT `House`.`id`, `House`.`tenant_id`, `House`.`building_id`, `House`.`no`, `House`.`name`, `House`.`name_kana`, `House`.`comment`, `House`.`division_no`, `House`.`use_type_id`, `House`.`status_id`, `House`.`layout_id`, `House`.`price`, `House`.`right_of_site_id`, `House`.`land_rent_type_id`, `House`.`land_rent_fee`, `House`.`land_rent_term_years`, `House`.`land_rent_term_type_id`, `House`.`delivery_date_type_id`, `House`.`delivery_date`, `House`.`mode_of_transaction_id`, `House`.`brokerage_fee`, `House`.`transaction_company_id`, `House`.`land_space`, `House`.`land_space_type_id`, `House`.`road_of_expence_type_id`, `House`.`road_space`, `House`.`class_of_land_id`, `House`.`use_distinct_id`, `House`.`building_land_ratio_1`, `House`.`floor_area_ratio_1`, `House`.`class_of_land_2_id`, `House`.`use_distinct_2_id`, `House`.`building_land_ratio_2`, `House`.`floor_area_ratio_2`, `House`.`setback_space`, `House`.`road_kind_id_1`, `House`.`road_direction_id_1`, `House`.`road_width_1`, `House`.`connecting_road_width_1`, `House`.`road_kind_id_2`, `House`.`road_direction_id_2`, `House`.`road_width_2`, `House`.`connecting_road_width_2`, `House`.`road_kind_id_3`, `House`.`road_direction_id_3`, `House`.`road_width_3`, `House`.`connecting_road_width_3`, `House`.`road_kind_id_4`, `House`.`road_direction_id_4`, `House`.`road_width_4`, `House`.`connecting_road_width_4`, `House`.`photo_layout_file_name`, `House`.`photo_1_file_name`, `House`.`photo_2_file_name`, `House`.`photo_3_file_name`, `House`.`photo_4_file_name`, `House`.`photo_5_file_name`, `House`.`photo_6_file_name`, `House`.`next_update_at`, `House`.`memo`, `House`.`created`, `House`.`modified` FROM `LAA0189369-onetwo`.`houses` AS `House` WHERE `House`.`tenant_id` = (1)	0	0	1
8	SELECT `Land`.`id`, `Land`.`tenant_id`, `Land`.`building_id`, `Land`.`no`, `Land`.`name`, `Land`.`name_kana`, `Land`.`comment`, `Land`.`division_no`, `Land`.`use_type_id`, `Land`.`status_id`, `Land`.`price`, `Land`.`right_of_site_id`, `Land`.`land_rent_type_id`, `Land`.`land_rent_fee`, `Land`.`land_rent_term_years`, `Land`.`land_rent_term_type_id`, `Land`.`delivery_date_type_id`, `Land`.`delivery_date`, `Land`.`mode_of_transaction_id`, `Land`.`brokerage_fee`, `Land`.`transaction_company_id`, `Land`.`land_space`, `Land`.`land_space_type_id`, `Land`.`road_of_expence_type_id`, `Land`.`road_space`, `Land`.`class_of_land_id`, `Land`.`use_distinct_id`, `Land`.`building_land_ratio_1`, `Land`.`floor_area_ratio_1`, `Land`.`class_of_land_2_id`, `Land`.`use_distinct_2_id`, `Land`.`building_land_ratio_2`, `Land`.`floor_area_ratio_2`, `Land`.`setback_space`, `Land`.`road_kind_id_1`, `Land`.`road_direction_id_1`, `Land`.`road_width_1`, `Land`.`connecting_road_width_1`, `Land`.`road_kind_id_2`, `Land`.`road_direction_id_2`, `Land`.`road_width_2`, `Land`.`connecting_road_width_2`, `Land`.`road_kind_id_3`, `Land`.`road_direction_id_3`, `Land`.`road_width_3`, `Land`.`connecting_road_width_3`, `Land`.`road_kind_id_4`, `Land`.`road_direction_id_4`, `Land`.`road_width_4`, `Land`.`connecting_road_width_4`, `Land`.`photo_layout_file_name`, `Land`.`photo_1_file_name`, `Land`.`photo_2_file_name`, `Land`.`photo_3_file_name`, `Land`.`photo_4_file_name`, `Land`.`photo_5_file_name`, `Land`.`photo_6_file_name`, `Land`.`next_update_at`, `Land`.`memo`, `Land`.`created`, `Land`.`modified` FROM `LAA0189369-onetwo`.`lands` AS `Land` WHERE `Land`.`tenant_id` = (1)	0	0	1
9	SELECT `TenantInformation`.`id`, `TenantInformation`.`tenant_id`, `TenantInformation`.`business_name`, `TenantInformation`.`zipcode`, `TenantInformation`.`address`, `TenantInformation`.`tel`, `TenantInformation`.`fax`, `TenantInformation`.`license`, `TenantInformation`.`contact_name`, `TenantInformation`.`email`, `TenantInformation`.`site_url`, `TenantInformation`.`open`, `TenantInformation`.`close`, `TenantInformation`.`regular_holiday`, `TenantInformation`.`homepage`, `TenantInformation`.`google_profile_url`, `TenantInformation`.`introduction_text`, `TenantInformation`.`now_leasing_photo_file_name`, `TenantInformation`.`contracted_photo_file_name`, `TenantInformation`.`Introduction`, `TenantInformation`.`concept_text`, `TenantInformation`.`management_text`, `TenantInformation`.`job_text`, `TenantInformation`.`logo_file_name`, `TenantInformation`.`photo1_file_name`, `TenantInformation`.`photo2_file_name`, `TenantInformation`.`created`, `TenantInformation`.`modified` FROM `LAA0189369-onetwo`.`tenant_informations` AS `TenantInformation` WHERE `TenantInformation`.`tenant_id` = (1)	1	1	0
10	select * from tenant_informations as TenantInformations where TenantInformations.id = 1	1	1	0
11	SELECT Building.*, BuildingKind.name, ConstructionKind.name, Pref.name FROM buildings As Building INNER JOIN building_kinds AS BuildingKind ON Building.building_kind_id = BuildingKind.id INNER JOIN construction_kinds AS ConstructionKind ON Building.construction_kind_id = ConstructionKind.id INNER JOIN prefs AS Pref ON Building.pref_id = Pref.id WHERE Building.id = 8	1	1	1
12	SELECT EkidataStation.name, EkidataLine.name FROM ekidata_joins As EkidataJoin INNER JOIN ekidata_lines As EkidataLine On EkidataLine.code = EkidataJoin.line_code INNER JOIN ekidata_stations As EkidataStation On EkidataStation.code = EkidataJoin.station_code1 WHERE EkidataJoin.id = 1451	1	1	1
13	SELECT EkidataStation.name, EkidataLine.name FROM ekidata_joins As EkidataJoin INNER JOIN ekidata_lines As EkidataLine On EkidataLine.code = EkidataJoin.line_code INNER JOIN ekidata_stations As EkidataStation On EkidataStation.code = EkidataJoin.station_code1 WHERE EkidataJoin.id = 7315	1	1	0
14	SELECT EkidataStation.name, EkidataLine.name FROM ekidata_joins As EkidataJoin INNER JOIN ekidata_lines As EkidataLine On EkidataLine.code = EkidataJoin.line_code INNER JOIN ekidata_stations As EkidataStation On EkidataStation.code = EkidataJoin.station_code1 WHERE EkidataJoin.id = 7300	1	1	0
15	SELECT * FROM buildings_equips As BuildingsEquips INNER JOIN equips As Equips On BuildingsEquips.equip_id = Equips.id WHERE BuildingsEquips.building_id = 8	0	0	0
16	SELECT Apartment.*, Layout.name FROM apartments AS Apartment INNER JOIN layouts AS Layout ON Apartment.layout_id = Layout.id WHERE building_id = 8	1	1	0
17	SELECT `Document`.`status`, `Document`.`menu_title`, `Document`.`url`, `Document`.`type`, `Document`.`target` FROM `LAA0189369-onetwo`.`documents` AS `Document` WHERE `status` = 'published' AND `tenant_id` = 1 AND `location` = 'top' AND `Document`.`tenant_id` = 1 ORDER BY `Document`.`position` ASC	7	7	0

(default) 17 queries took 9 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Tenant`.`id`, `Tenant`.`email`, `Tenant`.`password`, `Tenant`.`created`, `Tenant`.`modified`, `Tenant`.`display_name`, `Tenant`.`deleted` FROM `LAA0189369-onetwo`.`tenants` AS `Tenant` WHERE `Tenant`.`id` = 1 LIMIT 1

SELECT `Apartment`.`id`, `Apartment`.`tenant_id`, `Apartment`.`building_id`, `Apartment`.`no`, `Apartment`.`comment`, `Apartment`.`attention`, `Apartment`.`room_no`, `Apartment`.`floor`, `Apartment`.`status_id`, `Apartment`.`layout_id`, `Apartment`.`layout_detail`, `Apartment`.`floor_space`, `Apartment`.`price`, `Apartment`.`key_money`, `Apartment`.`deposit`, `Apartment`.`renewal_fee`, `Apartment`.`management_fee`, `Apartment`.`shared_fee`, `Apartment`.`mode_of_transaction_id`, `Apartment`.`security_deposit`, `Apartment`.`insurance_fee`, `Apartment`.`insurance_no_flg`, `Apartment`.`conditions`, `Apartment`.`lease_for_year`, `Apartment`.`lease_for_month`, `Apartment`.`for_until_id`, `Apartment`.`fixed_term_flg`, `Apartment`.`contract_note`, `Apartment`.`next_update_at`, `Apartment`.`youtube_link`, `Apartment`.`memo`, `Apartment`.`view_room_no_flg`, `Apartment`.`photo_1_file_name`, `Apartment`.`photo_2_file_name`, `Apartment`.`photo_3_file_name`, `Apartment`.`photo_4_file_name`, `Apartment`.`photo_5_file_name`, `Apartment`.`photo_6_file_name`, `Apartment`.`photo_7_file_name`, `Apartment`.`caption_1`, `Apartment`.`caption_2`, `Apartment`.`caption_3`, `Apartment`.`caption_4`, `Apartment`.`caption_5`, `Apartment`.`caption_6`, `Apartment`.`caption_7`, `Apartment`.`panorama_src`, `Apartment`.`view_panorama_list_flg`, `Apartment`.`panorama_comment`, `Apartment`.`view_panorama_sidebat_flg`, `Apartment`.`last_change_status_date`, `Apartment`.`created`, `Apartment`.`modified` FROM `LAA0189369-onetwo`.`apartments` AS `Apartment` WHERE `Apartment`.`tenant_id` = (1)

SELECT `Building`.`id`, `Building`.`tenant_id`, `Building`.`building_kind_id`, `Building`.`construction_kind_id`, `Building`.`floors`, `Building`.`build_at`, `Building`.`ekidata_station_id`, `Building`.`ekidata_station_2_id`, `Building`.`ekidata_station_3_id`, `Building`.`time_to_bus`, `Building`.`time_to_bus_2`, `Building`.`time_to_bus_3`, `Building`.`time_to_walk`, `Building`.`time_to_walk_2`, `Building`.`time_to_walk_3`, `Building`.`bus_station_name`, `Building`.`bus_station_2_name`, `Building`.`bus_station_3_name`, `Building`.`zipcode`, `Building`.`pref_id`, `Building`.`address1`, `Building`.`address2`, `Building`.`name`, `Building`.`catchcopy`, `Building`.`comment`, `Building`.`youtube_link`, `Building`.`memo`, `Building`.`view_name_no_flg`, `Building`.`view_flg`, `Building`.`photo_1_file_name`, `Building`.`photo_2_file_name`, `Building`.`photo_3_file_name`, `Building`.`photo_4_file_name`, `Building`.`photo_5_file_name`, `Building`.`caption_1`, `Building`.`caption_2`, `Building`.`caption_3`, `Building`.`caption_4`, `Building`.`caption_5`, `Building`.`created`, `Building`.`modified` FROM `LAA0189369-onetwo`.`buildings` AS `Building` WHERE `Building`.`tenant_id` = (1)

SELECT `BusinessCondminium`.`id`, `BusinessCondminium`.`tenant_id`, `BusinessCondminium`.`building_id`, `BusinessCondminium`.`no`, `BusinessCondminium`.`name`, `BusinessCondminium`.`name_kana`, `BusinessCondminium`.`comment`, `BusinessCondminium`.`room_no`, `BusinessCondminium`.`floor`, `BusinessCondminium`.`households`, `BusinessCondminium`.`use_type_id`, `BusinessCondminium`.`status_id`, `BusinessCondminium`.`layout_id`, `BusinessCondminium`.`floor_space`, `BusinessCondminium`.`balcony_space`, `BusinessCondminium`.`price`, `BusinessCondminium`.`management_fee`, `BusinessCondminium`.`maintenance_fee`, `BusinessCondminium`.`maintenance_fund_fee`, `BusinessCondminium`.`car_parking_premium`, `BusinessCondminium`.`car_parking_price`, `BusinessCondminium`.`delivery_date_type_id`, `BusinessCondminium`.`delivery_date`, `BusinessCondminium`.`mode_of_transaction_id`, `BusinessCondminium`.`brokerage_fee`, `BusinessCondminium`.`transaction_company_id`, `BusinessCondminium`.`next_update_at`, `BusinessCondminium`.`photo_layout_file_name`, `BusinessCondminium`.`photo_1_file_name`, `BusinessCondminium`.`photo_2_file_name`, `BusinessCondminium`.`photo_3_file_name`, `BusinessCondminium`.`photo_4_file_name`, `BusinessCondminium`.`photo_5_file_name`, `BusinessCondminium`.`photo_6_file_name`, `BusinessCondminium`.`memo`, `BusinessCondminium`.`created`, `BusinessCondminium`.`modified` FROM `LAA0189369-onetwo`.`business_condminia` AS `BusinessCondminium` WHERE `BusinessCondminium`.`tenant_id` = (1)

SELECT `BusinessHouse`.`id`, `BusinessHouse`.`tenant_id`, `BusinessHouse`.`building_id`, `BusinessHouse`.`no`, `BusinessHouse`.`name`, `BusinessHouse`.`name_kana`, `BusinessHouse`.`comment`, `BusinessHouse`.`division_no`, `BusinessHouse`.`use_type_id`, `BusinessHouse`.`status_id`, `BusinessHouse`.`layout_id`, `BusinessHouse`.`price`, `BusinessHouse`.`right_of_site_id`, `BusinessHouse`.`land_rent_type_id`, `BusinessHouse`.`land_rent_fee`, `BusinessHouse`.`land_rent_term_years`, `BusinessHouse`.`land_rent_term_type_id`, `BusinessHouse`.`delivery_date_type_id`, `BusinessHouse`.`delivery_date`, `BusinessHouse`.`mode_of_transaction_id`, `BusinessHouse`.`brokerage_fee`, `BusinessHouse`.`transaction_company_id`, `BusinessHouse`.`land_space`, `BusinessHouse`.`land_space_type_id`, `BusinessHouse`.`road_of_expence_type_id`, `BusinessHouse`.`road_space`, `BusinessHouse`.`class_of_land_id`, `BusinessHouse`.`use_distinct_id`, `BusinessHouse`.`building_land_ratio_1`, `BusinessHouse`.`floor_area_ratio_1`, `BusinessHouse`.`class_of_land_2_id`, `BusinessHouse`.`use_distinct_2_id`, `BusinessHouse`.`building_land_ratio_2`, `BusinessHouse`.`floor_area_ratio_2`, `BusinessHouse`.`setback_space`, `BusinessHouse`.`road_kind_id_1`, `BusinessHouse`.`road_direction_id_1`, `BusinessHouse`.`road_width_1`, `BusinessHouse`.`connecting_road_width_1`, `BusinessHouse`.`road_kind_id_2`, `BusinessHouse`.`road_direction_id_2`, `BusinessHouse`.`road_width_2`, `BusinessHouse`.`connecting_road_width_2`, `BusinessHouse`.`road_kind_id_3`, `BusinessHouse`.`road_direction_id_3`, `BusinessHouse`.`road_width_3`, `BusinessHouse`.`connecting_road_width_3`, `BusinessHouse`.`road_kind_id_4`, `BusinessHouse`.`road_direction_id_4`, `BusinessHouse`.`road_width_4`, `BusinessHouse`.`connecting_road_width_4`, `BusinessHouse`.`photo_layout_file_name`, `BusinessHouse`.`photo_1_file_name`, `BusinessHouse`.`photo_2_file_name`, `BusinessHouse`.`photo_3_file_name`, `BusinessHouse`.`photo_4_file_name`, `BusinessHouse`.`photo_5_file_name`, `BusinessHouse`.`photo_6_file_name`, `BusinessHouse`.`next_update_at`, `BusinessHouse`.`memo`, `BusinessHouse`.`created`, `BusinessHouse`.`modified` FROM `LAA0189369-onetwo`.`business_houses` AS `BusinessHouse` WHERE `BusinessHouse`.`tenant_id` = (1)

SELECT `Condminium`.`id`, `Condminium`.`tenant_id`, `Condminium`.`building_id`, `Condminium`.`no`, `Condminium`.`name`, `Condminium`.`name_kana`, `Condminium`.`comment`, `Condminium`.`room_no`, `Condminium`.`floor`, `Condminium`.`households`, `Condminium`.`use_type_id`, `Condminium`.`status_id`, `Condminium`.`layout_id`, `Condminium`.`floor_space`, `Condminium`.`balcony_space`, `Condminium`.`price`, `Condminium`.`management_fee`, `Condminium`.`maintenance_fee`, `Condminium`.`maintenance_fund_fee`, `Condminium`.`car_parking_premium`, `Condminium`.`car_parking_price`, `Condminium`.`delivery_date_type_id`, `Condminium`.`delivery_date`, `Condminium`.`mode_of_transaction_id`, `Condminium`.`right_of_site_id`, `Condminium`.`management_type_id`, `Condminium`.`brokerage_fee`, `Condminium`.`transaction_company_id`, `Condminium`.`photo_layout_file_name`, `Condminium`.`photo_1_file_name`, `Condminium`.`photo_2_file_name`, `Condminium`.`photo_3_file_name`, `Condminium`.`photo_4_file_name`, `Condminium`.`photo_5_file_name`, `Condminium`.`photo_6_file_name`, `Condminium`.`next_update_at`, `Condminium`.`memo`, `Condminium`.`created`, `Condminium`.`modified` FROM `LAA0189369-onetwo`.`condminia` AS `Condminium` WHERE `Condminium`.`tenant_id` = (1)

SELECT `House`.`id`, `House`.`tenant_id`, `House`.`building_id`, `House`.`no`, `House`.`name`, `House`.`name_kana`, `House`.`comment`, `House`.`division_no`, `House`.`use_type_id`, `House`.`status_id`, `House`.`layout_id`, `House`.`price`, `House`.`right_of_site_id`, `House`.`land_rent_type_id`, `House`.`land_rent_fee`, `House`.`land_rent_term_years`, `House`.`land_rent_term_type_id`, `House`.`delivery_date_type_id`, `House`.`delivery_date`, `House`.`mode_of_transaction_id`, `House`.`brokerage_fee`, `House`.`transaction_company_id`, `House`.`land_space`, `House`.`land_space_type_id`, `House`.`road_of_expence_type_id`, `House`.`road_space`, `House`.`class_of_land_id`, `House`.`use_distinct_id`, `House`.`building_land_ratio_1`, `House`.`floor_area_ratio_1`, `House`.`class_of_land_2_id`, `House`.`use_distinct_2_id`, `House`.`building_land_ratio_2`, `House`.`floor_area_ratio_2`, `House`.`setback_space`, `House`.`road_kind_id_1`, `House`.`road_direction_id_1`, `House`.`road_width_1`, `House`.`connecting_road_width_1`, `House`.`road_kind_id_2`, `House`.`road_direction_id_2`, `House`.`road_width_2`, `House`.`connecting_road_width_2`, `House`.`road_kind_id_3`, `House`.`road_direction_id_3`, `House`.`road_width_3`, `House`.`connecting_road_width_3`, `House`.`road_kind_id_4`, `House`.`road_direction_id_4`, `House`.`road_width_4`, `House`.`connecting_road_width_4`, `House`.`photo_layout_file_name`, `House`.`photo_1_file_name`, `House`.`photo_2_file_name`, `House`.`photo_3_file_name`, `House`.`photo_4_file_name`, `House`.`photo_5_file_name`, `House`.`photo_6_file_name`, `House`.`next_update_at`, `House`.`memo`, `House`.`created`, `House`.`modified` FROM `LAA0189369-onetwo`.`houses` AS `House` WHERE `House`.`tenant_id` = (1)

SELECT `Land`.`id`, `Land`.`tenant_id`, `Land`.`building_id`, `Land`.`no`, `Land`.`name`, `Land`.`name_kana`, `Land`.`comment`, `Land`.`division_no`, `Land`.`use_type_id`, `Land`.`status_id`, `Land`.`price`, `Land`.`right_of_site_id`, `Land`.`land_rent_type_id`, `Land`.`land_rent_fee`, `Land`.`land_rent_term_years`, `Land`.`land_rent_term_type_id`, `Land`.`delivery_date_type_id`, `Land`.`delivery_date`, `Land`.`mode_of_transaction_id`, `Land`.`brokerage_fee`, `Land`.`transaction_company_id`, `Land`.`land_space`, `Land`.`land_space_type_id`, `Land`.`road_of_expence_type_id`, `Land`.`road_space`, `Land`.`class_of_land_id`, `Land`.`use_distinct_id`, `Land`.`building_land_ratio_1`, `Land`.`floor_area_ratio_1`, `Land`.`class_of_land_2_id`, `Land`.`use_distinct_2_id`, `Land`.`building_land_ratio_2`, `Land`.`floor_area_ratio_2`, `Land`.`setback_space`, `Land`.`road_kind_id_1`, `Land`.`road_direction_id_1`, `Land`.`road_width_1`, `Land`.`connecting_road_width_1`, `Land`.`road_kind_id_2`, `Land`.`road_direction_id_2`, `Land`.`road_width_2`, `Land`.`connecting_road_width_2`, `Land`.`road_kind_id_3`, `Land`.`road_direction_id_3`, `Land`.`road_width_3`, `Land`.`connecting_road_width_3`, `Land`.`road_kind_id_4`, `Land`.`road_direction_id_4`, `Land`.`road_width_4`, `Land`.`connecting_road_width_4`, `Land`.`photo_layout_file_name`, `Land`.`photo_1_file_name`, `Land`.`photo_2_file_name`, `Land`.`photo_3_file_name`, `Land`.`photo_4_file_name`, `Land`.`photo_5_file_name`, `Land`.`photo_6_file_name`, `Land`.`next_update_at`, `Land`.`memo`, `Land`.`created`, `Land`.`modified` FROM `LAA0189369-onetwo`.`lands` AS `Land` WHERE `Land`.`tenant_id` = (1)

SELECT `TenantInformation`.`id`, `TenantInformation`.`tenant_id`, `TenantInformation`.`business_name`, `TenantInformation`.`zipcode`, `TenantInformation`.`address`, `TenantInformation`.`tel`, `TenantInformation`.`fax`, `TenantInformation`.`license`, `TenantInformation`.`contact_name`, `TenantInformation`.`email`, `TenantInformation`.`site_url`, `TenantInformation`.`open`, `TenantInformation`.`close`, `TenantInformation`.`regular_holiday`, `TenantInformation`.`homepage`, `TenantInformation`.`google_profile_url`, `TenantInformation`.`introduction_text`, `TenantInformation`.`now_leasing_photo_file_name`, `TenantInformation`.`contracted_photo_file_name`, `TenantInformation`.`Introduction`, `TenantInformation`.`concept_text`, `TenantInformation`.`management_text`, `TenantInformation`.`job_text`, `TenantInformation`.`logo_file_name`, `TenantInformation`.`photo1_file_name`, `TenantInformation`.`photo2_file_name`, `TenantInformation`.`created`, `TenantInformation`.`modified` FROM `LAA0189369-onetwo`.`tenant_informations` AS `TenantInformation` WHERE `TenantInformation`.`tenant_id` = (1)

select * from tenant_informations as TenantInformations where TenantInformations.id = 1

SELECT Building.*, BuildingKind.name, ConstructionKind.name, Pref.name FROM buildings As Building INNER JOIN building_kinds AS BuildingKind ON Building.building_kind_id = BuildingKind.id INNER JOIN construction_kinds AS ConstructionKind ON Building.construction_kind_id = ConstructionKind.id INNER JOIN prefs AS Pref ON Building.pref_id = Pref.id WHERE Building.id = 8

SELECT EkidataStation.name, EkidataLine.name FROM ekidata_joins As EkidataJoin INNER JOIN ekidata_lines As EkidataLine On EkidataLine.code = EkidataJoin.line_code INNER JOIN ekidata_stations As EkidataStation On EkidataStation.code = EkidataJoin.station_code1 WHERE EkidataJoin.id = 1451

SELECT * FROM buildings_equips As BuildingsEquips INNER JOIN equips As Equips On BuildingsEquips.equip_id = Equips.id WHERE BuildingsEquips.building_id = 8

SELECT Apartment.*, Layout.name FROM apartments AS Apartment INNER JOIN layouts AS Layout ON Apartment.layout_id = Layout.id WHERE building_id = 8

SELECT `Document`.`status`, `Document`.`menu_title`, `Document`.`url`, `Document`.`type`, `Document`.`target` FROM `LAA0189369-onetwo`.`documents` AS `Document` WHERE `status` = 'published' AND `tenant_id` = 1 AND `location` = 'top' AND `Document`.`tenant_id` = 1 ORDER BY `Document`.`position` ASC

Message	Memory use
Component initialization	6.30 MB
Controller action start	11.38 MB
Controller render start	11.51 MB
View render complete	15.09 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	29.20
Event: Controller.initialize	37.69
Event: Controller.startup	1.04
Controller action	3.63
Event: Controller.beforeRender	2.35
» Processing toolbar data	2.16
Rendering View	12.86
» Event: View.beforeRender	0.07
» Rendering APP/View/Buildings/view.ctp	1.26
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	10.26
» » Rendering APP/View/Elements/front/default_topbar.ctp	7.29
» » Rendering APP/View/Elements/front/building_leftbar.ctp	0.47
» » Rendering APP/View/Elements/front/building_rightbar.ctp	0.12
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.55
Event: View.afterLayout	0.00

View Variables

apartments
- 0
  - Apartment
    - id9
    - tenant_id1
    - building_id8
    - no
    - comment
    - attention
    - room_no601
    - floor(null)
    - status_id1
    - layout_id2
    - layout_detail
    - floor_space(null)
    - price109000
    - key_money109000
    - deposit109000
    - renewal_fee(null)
    - management_fee(null)
    - shared_fee8000
    - mode_of_transaction_id5
    - security_deposit(null)
    - insurance_fee(null)
    - insurance_no_flg(false)
    - conditions
    - lease_for_year(null)
    - lease_for_month(null)
    - for_until_id1
    - fixed_term_flg(false)
    - contract_note
    - next_update_at(null)
    - youtube_link
    - memo
    - view_room_no_flg(false)
    - photo_1_file_namecc601.JPG
    - photo_2_file_nameDSC01024.JPG
    - photo_3_file_nameDSC01313.JPG
    - photo_4_file_nameP1170734.JPG
    - photo_5_file_nameP1170735.JPG
    - photo_6_file_nameP1170737.JPG
    - photo_7_file_nameP1170754.JPG
    - caption_1
    - caption_2
    - caption_3
    - caption_4
    - caption_5
    - caption_6
    - caption_7
    - panorama_src(null)
    - view_panorama_list_flg(false)
    - panorama_comment(null)
    - view_panorama_sidebat_flg(false)
    - last_change_status_date2014-02-14
    - created2014-02-14 16:54:01
    - modified2014-02-14 17:04:55
  - Layout
    - name1K
building
- Building
  - id8
  - tenant_id1
  - building_kind_id1
  - construction_kind_id7
  - floors6
  - build_at2001-03-01
  - ekidata_station_id1451
  - ekidata_station_2_id7315
  - ekidata_station_3_id7300
  - time_to_bus-1
  - time_to_bus_2-1
  - time_to_bus_3-1
  - time_to_walk6
  - time_to_walk_24
  - time_to_walk_34
  - bus_station_name(null)
  - bus_station_2_name(null)
  - bus_station_3_name(null)
  - zipcode(null)
  - pref_id13
  - address1港区芝
  - address25-10-6
  - nameリュミエール三田
  - catchcopy三線利用の好立地インターネット常時接続無料（初回3,150円必須）
  - comment
  - youtube_link
  - memo
  - view_name_no_flg(false)
  - view_flg(true)
  - photo_1_file_name(null)
  - photo_2_file_name(null)
  - photo_3_file_name(null)
  - photo_4_file_name(null)
  - photo_5_file_name(null)
  - caption_1
  - caption_2
  - caption_3
  - caption_4
  - caption_5
  - created2014-02-14 16:52:57
  - modified2014-02-14 17:04:55
  - equips
- BuildingKind
  - nameマンション
- ConstructionKind
  - name鉄筋コンクリート
- Pref
  - name東京都
- EkidataStation
  - name田町
- EkidataLine
  - nameJR山手線
- EkidataStation2
  - name三田
- EkidataLine2
  - name都営三田線
- EkidataStation3
  - name三田
- EkidataLine3
  - name都営浅草線
rightbarfront/building_rightbar
leftbarfront/building_leftbar
tenantInformation
- TenantInformations
 - id1
 - tenant_id1
 - business_name株式会社ワンツーホーム
 - zipcode123-4567
 - address東京都港区芝1-2-3テストビル5F
 - tel03-1234-5678
 - fax03-1234-5679
 - license東京都知事(1)第92477号
 - contact_nameテスト太郎
 - emaily-kambayashi@o-en.info
 - site_urlhttp://tamachi-chintai.jp/
 - open09:30:00
 - close18:30:00
 - regular_holiday水曜日
 - homepage
 - google_profile_url
 - introduction_text港区の賃貸マンションを借りたい！のお手伝いをする港区賃貸のワンツーホームです。忙しい借主様の要望をよーく聞き、必ず満足していただけるようなお部屋をご紹介させていただきます。芝税務署の隣りにあるお店は1階でホワイト、グリーン、ブラウン色で親しみやすい、爽やかな癒し系の店内です。是非、一度、遊びにいらして下さい。
 - now_leasing_photo_file_nameico_offer_a.gif
 - contracted_photo_file_nameico_close.gif
 - Introduction(null)
 - concept_text☆what's Tamachi Living?☆
 - management_text・空室期間が長く、早く入居者を探してほしい！
 - job_text 当社は設立3年目を迎える不動産会社｡まだ新しい会社ですが､ 次の店舗展開を計画中！新しく戦力となってくれるスタッフを募集します！
 - logo_file_nameTamachiLiving.jpg
 - photo1_file_namemain.jpg
 - photo2_file_name
 - created2013-07-25 14:15:36
 - modified2014-02-06 13:51:29
displayTenant
- Tenant
 - id1
 - emailtest@example.com
 - password9108a5950ab049395ee0970896741cf33b4abe54
 - created2013-07-07 23:21:29
 - modified2013-08-07 15:43:32
 - display_name
 - deleted(true)
 - roletenant
- Apartment
 - 0
 - id3
 - tenant_id1
 - building_id2
 - no001
 - comment○6帖フローリングの東向きバルコニーです ★エアコン ★室内洗濯機置場 ★収納 ★オートロック
 - attention
 - room_no101
 - floor-1
 - status_id2
 - layout_id2
 - layout_detail
 - floor_space23.8
 - price70000
 - key_money0
 - deposit1
 - renewal_fee(null)
 - management_fee(null)
 - shared_fee(null)
 - mode_of_transaction_id1
 - security_deposit(null)
 - insurance_fee(null)
 - insurance_no_flg(false)
 - conditions(null)
 - lease_for_year(null)
 - lease_for_month(null)
 - for_until_id0
 - fixed_term_flg(false)
 - contract_note(null)
 - next_update_at(null)
 - youtube_link(null)
 - memo
 - view_room_no_flg(false)
 - photo_1_file_name13218898_2_560_480_3.jpg
 - photo_2_file_name210002_240_2_1377762657.jpg
 - photo_3_file_name13218898_3_560_480_3.jpg
 - photo_4_file_name13218898_5_560_480_3.jpg
 - photo_5_file_name13218898_6_560_480_3.jpg
 - photo_6_file_name13218898_13_560_480_3.jpg
 - photo_7_file_name(null)
 - caption_1間取り
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - caption_6
 - caption_7
 - panorama_src(null)
 - view_panorama_list_flg(true)
 - panorama_commentパノラマ用のコメントその2
 - view_panorama_sidebat_flg(false)
 - last_change_status_date2014-01-21
 - created2013-10-24 18:06:31
 - modified2013-11-28 16:50:02
 - 1
 - id5
 - tenant_id1
 - building_id2
 - no002
 - comment(null)
 - attention(null)
 - room_no102
 - floor1
 - status_id1
 - layout_id2
 - layout_detail(null)
 - floor_space23.8
 - price70000
 - key_money0
 - deposit70000
 - renewal_fee(null)
 - management_fee(null)
 - shared_fee(null)
 - mode_of_transaction_id1
 - security_deposit(null)
 - insurance_fee(null)
 - insurance_no_flg(false)
 - conditions(null)
 - lease_for_year(null)
 - lease_for_month(null)
 - for_until_id0
 - fixed_term_flg(false)
 - contract_note(null)
 - next_update_at(null)
 - youtube_link(null)
 - memo
 - view_room_no_flg(false)
 - photo_1_file_name(null)
 - photo_2_file_name(null)
 - photo_3_file_name(null)
 - photo_4_file_name(null)
 - photo_5_file_name(null)
 - photo_6_file_name(null)
 - photo_7_file_name(null)
 - caption_1(null)
 - caption_2(null)
 - caption_3(null)
 - caption_4(null)
 - caption_5(null)
 - caption_6(null)
 - caption_7(null)
 - panorama_src(null)
 - view_panorama_list_flg(false)
 - panorama_comment(null)
 - view_panorama_sidebat_flg(false)
 - last_change_status_date2014-01-21
 - created2013-11-20 17:59:46
 - modified2013-11-20 17:59:46
 - 2
 - id6
 - tenant_id1
 - building_id4
 - no2225171548
 - comment人に自慢したい物件が見つかりました。デザイナーズマンション「KAMOME」　レインボーブリッジ至近！ ★バルコニー　テラス用のテーブルとチェアが置けるぐらい広々！ ★エアコン ★浴室乾燥機　女性には助かります。 ★給湯追い焚き　やっぱりお風呂が好き！ ★ＢＳ／ＣＳ／ＣＡＴＶ　　スポーツ・映画など見たいチャンネルに合わせて選べちゃう。 ★ガスコンロ・グリル付きキッチン　たくさん料理しちゃいましょう！ ★オートロック ★エレベータ ★シャワートイレ　お尻にやさしい！ ★バストイレ別 ★フローリング ★管理人巡回　安全第1！！芝浦アイランド5分　・ピーコック（スーパー）・保育園・芝浦アイランド内科クリニック・芝浦アイランド歯科などなど　　スーパー、病院、保育園と生活環境充実！近くにコンビニ（ローソン1分・サンクス5分）もありますよ！ JR田町駅まで15分・ゆりかもめ線芝浦ふ頭駅まで10分港区の便利な巡回バス「ちぃバス」のバス停まで5分！！ ※近くに駐車場あり【コメント】目の前がレインボーブリッジでお台場が見えちゃう。お洒落なデザイナーズマンション！天井も高くて広々室内。設備も充実。CMである「ワンランク上のマンション」ってピンとこない感じもありましたけど、こんなマンションのことを言うのでしょうね！
 - attention注意事項
 - room_no201
 - floor2
 - status_id1
 - layout_id3
 - layout_detail
 - floor_space39.71
 - price153000
 - key_money0
 - deposit2
 - renewal_fee1
 - management_fee0
 - shared_fee10000
 - mode_of_transaction_id5
 - security_deposit(null)
 - insurance_fee0
 - insurance_no_flg(true)
 - conditions
 - lease_for_year(null)
 - lease_for_month(null)
 - for_until_id0
 - fixed_term_flg(false)
 - contract_note(null)
 - next_update_at(null)
 - youtube_link
 - memo三井不動産住宅リース03-5381-1079
 - view_room_no_flg(false)
 - photo_1_file_name(null)
 - photo_2_file_name(null)
 - photo_3_file_name(null)
 - photo_4_file_name(null)
 - photo_5_file_name(null)
 - photo_6_file_name(null)
 - photo_7_file_name(null)
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - caption_6
 - caption_7
 - panorama_srcu=u1376373252&p=p1376373343&s=s1376373581
 - view_panorama_list_flg(true)
 - panorama_commentパノラマ用のコメントです
 - view_panorama_sidebat_flg(false)
 - last_change_status_date(null)
 - created2013-12-11 08:48:55
 - modified2013-12-11 09:08:50
 - 3
 - id7
 - tenant_id1
 - building_id5
 - no4294967295
 - commentオートロック、宅配ロッカー。全室エアコン設置済、浴室乾燥機追い焚きオートバス、ウォシュレット、ＴＶモニタ付インターフォン
 - attention注意事項
 - room_no101
 - floor1
 - status_id1
 - layout_id1
 - layout_detailまどり
 - floor_space47.42
 - price210000
 - key_money0
 - deposit1
 - renewal_fee0
 - management_fee0
 - shared_fee0
 - mode_of_transaction_id5
 - security_deposit0
 - insurance_fee0
 - insurance_no_flg(false)
 - conditions現状
 - lease_for_year1
 - lease_for_month4
 - for_until_id1
 - fixed_term_flg(true)
 - contract_note契約備考
 - next_update_at(null)
 - youtube_link
 - memoトータルハウジング
 - view_room_no_flg(false)
 - photo_1_file_name(null)
 - photo_2_file_name(null)
 - photo_3_file_name(null)
 - photo_4_file_name(null)
 - photo_5_file_name(null)
 - photo_6_file_name(null)
 - photo_7_file_name(null)
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - caption_6
 - caption_7
 - panorama_src(null)
 - view_panorama_list_flg(false)
 - panorama_comment(null)
 - view_panorama_sidebat_flg(false)
 - last_change_status_date2013-12-21
 - created2013-12-18 19:28:32
 - modified2013-12-18 19:28:32
 - 4
 - id8
 - tenant_id1
 - building_id5
 - no4294967296
 - commentオートロック、宅配ロッカー。全室エアコン設置済、浴室乾燥機追い焚きオートバス、ウォシュレット、ＴＶモニタ付インターフォン
 - attention注意事項
 - room_no102
 - floor1
 - status_id1
 - layout_id1
 - layout_detail(null)
 - floor_space47.42
 - price210000
 - key_money0
 - deposit1
 - renewal_fee0
 - management_fee0
 - shared_fee0
 - mode_of_transaction_id5
 - security_deposit0
 - insurance_fee0
 - insurance_no_flg(false)
 - conditions現状
 - lease_for_year1
 - lease_for_month4
 - for_until_id1
 - fixed_term_flg(true)
 - contract_note契約備考
 - next_update_at(null)
 - youtube_link
 - memoトータルハウジング
 - view_room_no_flg(false)
 - photo_1_file_name(null)
 - photo_2_file_name(null)
 - photo_3_file_name(null)
 - photo_4_file_name(null)
 - photo_5_file_name(null)
 - photo_6_file_name(null)
 - photo_7_file_name(null)
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - caption_6
 - caption_7
 - panorama_src(null)
 - view_panorama_list_flg(false)
 - panorama_comment(null)
 - view_panorama_sidebat_flg(false)
 - last_change_status_date2013-12-18
 - created2013-12-18 19:44:14
 - modified2013-12-18 19:44:14
 - 5
 - id9
 - tenant_id1
 - building_id8
 - no
 - comment
 - attention
 - room_no601
 - floor(null)
 - status_id1
 - layout_id2
 - layout_detail
 - floor_space(null)
 - price109000
 - key_money109000
 - deposit109000
 - renewal_fee(null)
 - management_fee(null)
 - shared_fee8000
 - mode_of_transaction_id5
 - security_deposit(null)
 - insurance_fee(null)
 - insurance_no_flg(false)
 - conditions
 - lease_for_year(null)
 - lease_for_month(null)
 - for_until_id1
 - fixed_term_flg(false)
 - contract_note
 - next_update_at(null)
 - youtube_link
 - memo
 - view_room_no_flg(false)
 - photo_1_file_namecc601.JPG
 - photo_2_file_nameDSC01024.JPG
 - photo_3_file_nameDSC01313.JPG
 - photo_4_file_nameP1170734.JPG
 - photo_5_file_nameP1170735.JPG
 - photo_6_file_nameP1170737.JPG
 - photo_7_file_nameP1170754.JPG
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - caption_6
 - caption_7
 - panorama_src(null)
 - view_panorama_list_flg(false)
 - panorama_comment(null)
 - view_panorama_sidebat_flg(false)
 - last_change_status_date2014-02-14
 - created2014-02-14 16:54:01
 - modified2014-02-14 17:04:55
- Building
 - 0
 - id2
 - tenant_id1
 - building_kind_id1
 - construction_kind_id5
 - floors2
 - build_at0000-00-00
 - ekidata_station_id5254
 - ekidata_station_2_id5756
 - ekidata_station_3_id1666
 - time_to_bus-1
 - time_to_bus_2-1
 - time_to_bus_3-1
 - time_to_walk7
 - time_to_walk_210
 - time_to_walk_312
 - bus_station_name
 - bus_station_2_name
 - bus_station_3_name
 - zipcode1640002
 - pref_id13
 - address1中野区上高田
 - address24-29-4
 - nameガーデンヒルズ
 - catchcopyキャッチコピー
 - commentPRコメント
 - youtube_link
 - memo
 - view_name_no_flg(false)
 - view_flg(true)
 - photo_1_file_name7137334_1_600_600_3.jpg
 - photo_2_file_name13218898_17_560_480_3.jpg
 - photo_3_file_name7137334_15_600_600_3.jpg
 - photo_4_file_name7137334_14_600_600_3.jpg
 - photo_5_file_name7137334_14_600_600_3.jpg
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - created2013-10-24 17:48:39
 - modified2013-12-21 13:53:27
 - 1
 - id4
 - tenant_id1
 - building_kind_id1
 - construction_kind_id7
 - floors10
 - build_at2020-08-08
 - ekidata_station_id1451
 - ekidata_station_2_id7300
 - ekidata_station_3_id7469
 - time_to_bus0
 - time_to_bus_25
 - time_to_bus_30
 - time_to_walk15
 - time_to_walk_215
 - time_to_walk_310
 - bus_station_name
 - bus_station_2_name三田
 - bus_station_3_name
 - zipcode
 - pref_id13
 - address1港区海岸
 - address23-8-9
 - nameKAMOME(カモメ)
 - catchcopyレインボーブリッジが目の前のデザイナーズ賃貸マンション！KAMOME(カモメ)の物件情報です。田町･三田の賃貸マンションは田町LIVINGでお探し下さい。
 - comment人に自慢したい物件が見つかりました。それはデザイナーズマンション「KAMOME」です　レインボーブリッジ至近！ ★バルコニー　テラス用のテーブルとチェアが置けるぐらい広々！ ★エアコン ★浴室乾燥機　女性には助かります。 ★給湯追い焚き　やっぱりお風呂が好き！ ★ＢＳ／ＣＳ／ＣＡＴＶ　　スポーツ・映画など見たいチャンネルに合わせて選べちゃう。 ★ガスコンロ・グリル付きキッチン　たくさん料理しちゃいましょう！ ★オートロック ★エレベータ ★シャワートイレ　お尻にやさしい！ ★バストイレ別 ★フローリング ★管理人巡回　安全第1！！芝浦アイランド5分　・ピーコック（スーパー）・保育園・芝浦アイランド内科クリニック・芝浦アイランド歯科などなど　　スーパー、病院、保育園と生活環境充実！近くにコンビニ（ローソン1分・サンクス5分）もありますよ！ JR田町駅まで15分・ゆりかもめ線芝浦ふ頭駅まで10分港区の便利な巡回バス「ちぃバス」のバス停まで5分！！ ※近くに駐車場あり【コメント】目の前がレインボーブリッジでお台場が見えちゃう。お洒落なデザイナーズマンション！天井も高くて広々室内。設備も充実。CMである「ワンランク上のマンション」ってピンとこない感じもありましたけど、こんなマンションのことを言うのでしょうね！
 - youtube_linkhttp://localhost/OneTwoHome/1/Pages/home
 - memo4/2宮地
 - view_name_no_flg(false)
 - view_flg(true)
 - photo_1_file_name82692200000342e_01.jpg
 - photo_2_file_name82692200000342e_02.jpg
 - photo_3_file_name82692200000342e_03.jpg
 - photo_4_file_name82692200000342e_04.jpg
 - photo_5_file_name82692200000342e_05.jpg
 - caption_1外観
 - caption_2外観２
 - caption_3エントランス
 - caption_4エントランス２
 - caption_5エントランス３
 - created2013-12-11 08:21:33
 - modified2013-12-13 21:30:12
 - 2
 - id5
 - tenant_id1
 - building_kind_id1
 - construction_kind_id7
 - floors30
 - build_at2007-02-01
 - ekidata_station_id5751
 - ekidata_station_2_id7317
 - ekidata_station_3_id0
 - time_to_bus-1
 - time_to_bus_2-1
 - time_to_bus_3-1
 - time_to_walk8
 - time_to_walk_26
 - time_to_walk_3-1
 - bus_station_name
 - bus_station_2_name
 - bus_station_3_name
 - zipcode
 - pref_id13
 - address1港区西新橋
 - address23-17-7
 - name愛宕山タワー(旧パシフィックタワー愛宕山)
 - catchcopyフロントサービルが充実している仲介手数料無料の愛宕山タワーの物件情報です。仲介手数料が最大無料の港区の賃貸マンションはワンツーホームでお探し下さい。
 - commentドラマティックな雰囲気を纏う上質なタワーマンション「愛宕山タワー」　 SOHO,ペット可の賃貸タワーマンションです。オートロック・全室エアコン・宅配ロッカー・オートバス SOHO,ペットの場合は敷金2ヶ月となります。連帯保証人不要システム利用条件がありますので詳細につきましては担当までお問い合わせください。 ※ペット飼育時はライフアシストクラブへの入会が必要となります。（入会金5,000円　月会費1,000円　別途提出書類有り）
 - youtube_link
 - memo共有めも
 - view_name_no_flg(false)
 - view_flg(true)
 - photo_1_file_name17921100000342e_01.jpg
 - photo_2_file_name17921100000342e_02.jpg
 - photo_3_file_name17928700000342e_03.jpg
 - photo_4_file_name(null)
 - photo_5_file_name(null)
 - caption_1愛宕山タワー外観
 - caption_2愛宕山タワー外観
 - caption_3愛宕山タワーエントランス
 - caption_4
 - caption_5
 - created2013-12-18 00:12:17
 - modified2013-12-18 19:44:14
 - 3
 - id6
 - tenant_id1
 - building_kind_id1
 - construction_kind_id7
 - floors5
 - build_at1995-07-01
 - ekidata_station_id1451
 - ekidata_station_2_id7315
 - ekidata_station_3_id7300
 - time_to_bus-1
 - time_to_bus_2-1
 - time_to_bus_3-1
 - time_to_walk8
 - time_to_walk_26
 - time_to_walk_36
 - bus_station_name(null)
 - bus_station_2_name(null)
 - bus_station_3_name(null)
 - zipcode(null)
 - pref_id13
 - address1港区三田
 - address23-2-22
 - nameエクセル三田聖坂
 - catchcopy人気の三田3丁目。聖坂の高台閑静な住宅街にある高級分譲マンションです。
 - comment第一種住居地区
 - youtube_link
 - memo
 - view_name_no_flg(true)
 - view_flg(true)
 - photo_1_file_nameP1130810.JPG
 - photo_2_file_nameP1130823.JPG
 - photo_3_file_nameP1130836.JPG
 - photo_4_file_nameP1130822.JPG
 - photo_5_file_nameP1130832.JPG
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - created2014-02-14 15:50:23
 - modified2014-02-14 15:51:10
 - 4
 - id7
 - tenant_id1
 - building_kind_id1
 - construction_kind_id7
 - floors11
 - build_at2004-09-01
 - ekidata_station_id1451
 - ekidata_station_2_id7315
 - ekidata_station_3_id7300
 - time_to_bus-1
 - time_to_bus_2-1
 - time_to_bus_3-1
 - time_to_walk5
 - time_to_walk_23
 - time_to_walk_33
 - bus_station_name(null)
 - bus_station_2_name(null)
 - bus_station_3_name(null)
 - zipcode(null)
 - pref_id13
 - address1港区芝
 - address25-16-5
 - nameクリオ三田ラ・モード
 - catchcopy充実のセキュリティ！近隣には24時間営業のスーパーマーケットもあります！
 - comment【セキュリティ設備】 ■オートロック ■テレビモニター付インターホン ■防犯カメラ ■防犯合わせガラス（一部住居のみ） ■ダブルロックシリンダー ■エレベーターモニター ■宅配ボックス ■24時間監視システム ■セキュリティシステム ■マグネット式防犯センサー
 - youtube_link
 - memo
 - view_name_no_flg(false)
 - view_flg(true)
 - photo_1_file_nameDSC01019.JPG
 - photo_2_file_nameDSC01313.JPG
 - photo_3_file_nameP1050574.JPG
 - photo_4_file_name(null)
 - photo_5_file_name(null)
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - created2014-02-14 16:24:20
 - modified2014-02-14 16:24:20
 - 5
 - id8
 - tenant_id1
 - building_kind_id1
 - construction_kind_id7
 - floors6
 - build_at2001-03-01
 - ekidata_station_id1451
 - ekidata_station_2_id7315
 - ekidata_station_3_id7300
 - time_to_bus-1
 - time_to_bus_2-1
 - time_to_bus_3-1
 - time_to_walk6
 - time_to_walk_24
 - time_to_walk_34
 - bus_station_name(null)
 - bus_station_2_name(null)
 - bus_station_3_name(null)
 - zipcode(null)
 - pref_id13
 - address1港区芝
 - address25-10-6
 - nameリュミエール三田
 - catchcopy三線利用の好立地インターネット常時接続無料（初回3,150円必須）
 - comment
 - youtube_link
 - memo
 - view_name_no_flg(false)
 - view_flg(true)
 - photo_1_file_name(null)
 - photo_2_file_name(null)
 - photo_3_file_name(null)
 - photo_4_file_name(null)
 - photo_5_file_name(null)
 - caption_1
 - caption_2
 - caption_3
 - caption_4
 - caption_5
 - created2014-02-14 16:52:57
 - modified2014-02-14 17:04:55
- BusinessCondminium(empty)
- BusinessHouse(empty)
- Condminium(empty)
- House(empty)
- Land(empty)
- TenantInformation
 - 0
 - id1
 - tenant_id1
 - business_name株式会社ワンツーホーム
 - zipcode123-4567
 - address東京都港区芝1-2-3テストビル5F
 - tel03-1234-5678
 - fax03-1234-5679
 - license東京都知事(1)第92477号
 - contact_nameテスト太郎
 - emaily-kambayashi@o-en.info
 - site_urlhttp://tamachi-chintai.jp/
 - open09:30:00
 - close18:30:00
 - regular_holiday水曜日
 - homepage
 - google_profile_url
 - introduction_text港区の賃貸マンションを借りたい！のお手伝いをする港区賃貸のワンツーホームです。忙しい借主様の要望をよーく聞き、必ず満足していただけるようなお部屋をご紹介させていただきます。芝税務署の隣りにあるお店は1階でホワイト、グリーン、ブラウン色で親しみやすい、爽やかな癒し系の店内です。是非、一度、遊びにいらして下さい。
 - now_leasing_photo_file_nameico_offer_a.gif
 - contracted_photo_file_nameico_close.gif
 - Introduction(null)
 - concept_text☆what's Tamachi Living?☆
 - management_text・空室期間が長く、早く入居者を探してほしい！
 - job_text 当社は設立3年目を迎える不動産会社｡まだ新しい会社ですが､ 次の店舗展開を計画中！新しく戦力となってくれるスタッフを募集します！
 - logo_file_nameTamachiLiving.jpg
 - photo1_file_namemain.jpg
 - photo2_file_name
 - created2013-07-25 14:15:36
 - modified2014-02-06 13:51:29
homehttp://onetwohome.o-en-dev.com
$request->data(empty)
$this->validationErrors
- Building(empty)
- Tenant(empty)
- Apartment(empty)
- BusinessCondminium(empty)
- BusinessHouse(empty)
- Condminium(empty)
- House(empty)
- Land(empty)
- TenantInformation(empty)
Loaded Helpers
- 0Session
- 1Html
- 2Form
- 3Paginator
- 4Upload
- 5Navigation
- 6Building
- 7Number
- 8SimpleGraph
- 9DebugTimer
- 10Toolbar
- 11Document
- 12HtmlToolbar

====

Constant	Value
DOMAIN	http://smiletouch.localhost/
BASE_URL	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/webroot/
DB_HOST	mysql006.phy.lolipop.lan
DB_USER	LAA0189369
DB_PASS	onetwohomedb
DB_NAME	LAA0189369-onetwo
PEAR_DB	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/PEAR/DB.php

Constant	Value
APP	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/
APP_DIR	app
APPLIBS	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/Lib/
CACHE	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/tmp/cache/
CAKE	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/lib
CORE_PATH	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/lib/
CAKE_VERSION	2.3.6
CSS	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://onetwohome.o-en-dev.com
IMAGES	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/webroot/img/
IMAGES_URL	img/
JS	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/webroot/js/
JS_URL	js/
LOGS	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/tmp/logs/
ROOT	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome
TESTS	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/Test/
TMP	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/tmp/
VENDORS	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/webroot/

Environment Variable	Value
Php Version	5.3.29
Path	/usr/local/bin:/usr/bin:/bin
Redirect Handler	php5.3-script
Redirect Status	200
Unique Id	aZ7z5TmqQD1AGwaEc5gKIQAAAUA
Nss Sdb Use Cache	YES
Https	on
Ssl Tls Sni	onetwohome.o-en-dev.com
Http Host	onetwohome.o-en-dev.com
Http X Forwarded Host	onetwohome.o-en-dev.com
Http X Forwarded For	216.73.216.38
Http X Forwarded Proto	https
Http X Backend	std725.phy.lolipop.lan
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Server Signature
Server Software	Apache
Server Name	onetwohome.o-en-dev.com
Server Addr	172.19.45.206
Server Port	443
Remote Addr	216.73.216.38
Document Root	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome
Request Scheme	https
Context Prefix	/lolipop-ext-bin/
Context Document Root	/home/users/php-bin/lolipop.jp-3314f5f81b4bfbcb/onetwohome.o-en-dev.com/
Server Admin	https://lolipop.jp/support/
Script Filename	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/webroot/index.php
Remote Port	57774
Redirect Url	/app/webroot/index.php
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/Buildings/view/8
Script Name	/app/webroot/index.php
Orig Script Filename	/home/users/php-bin/lolipop.jp-3314f5f81b4bfbcb/onetwohome.o-en-dev.com/php5.3/php5.3.cgi
Orig Path Info	/app/webroot/index.php
Orig Path Translated	/home/users/1/lolipop.jp-3314f5f81b4bfbcb/web/onetwohome/app/webroot/index.php
Orig Script Name	/lolipop-ext-bin/php5.3/php5.3.cgi
Php Self	/app/webroot/index.php
Request Time	1772024805
Argc	0

default

Total Time: 9 ms
Total Queries: 17 queries

Query Explain:

Memory

Timers

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 9 ms Total Queries: 17 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 9 ms
Total Queries: 17 queries