| 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 | 0 |
| 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 | 1 |
| 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 | 1 |
| 10 | select * from tenant_informations as TenantInformations where TenantInformations.id = 1 | | 1 | 1 | 1 |
| 11 | select * from apartments as Apartment inner join buildings as Building on Apartment.building_id = Building.id inner join layouts as Layout on Apartment.layout_id = Layout.id inner join building_kinds as BuildingKind on Building.building_kind_id = BuildingKind.id left join apartments_equips as ApartmentsEquip on Apartment.id = ApartmentsEquip.apartment_id left join buildings_equips as BuildingsEquip on Building.id = BuildingsEquip.building_id where Apartment.tenant_id = 1 AND ( ( Apartment.layout_id = 3 OR Apartment.layout_id = 4 ) ) | | 25 | 25 | 4 |
| 12 | select * from ekidata_joins as EkidataJoin inner join ekidata_stations as EkidataStation on EkidataStation.code = EkidataJoin.station_code1 inner join ekidata_lines as EkidataLine on EkidataLine.code = EkidataJoin.line_code where EkidataJoin.id = 1451 OR EkidataJoin.id = 7300 OR EkidataJoin.id = 7469 | | 3 | 3 | 1 |
| 13 | select EkidataStation.name from ekidata_stations as EkidataStation where EkidataStation.id = 7820 | | 1 | 1 | 0 |
| 14 | select * from tenant_search_groups as TenantSearchGroup where TenantSearchGroup.search_rule_id = 4 and TenantSearchGroup.tenant_id = 1 and TenantSearchGroup.status = 1 | | 1 | 1 | 0 |
| 15 | select * from apartments as Apartment inner join buildings as Building on Apartment.building_id = Building.id inner join layouts as Layout on Apartment.layout_id = Layout.id inner join building_kinds as BuildingKind on Building.building_kind_id = BuildingKind.id left join apartments_equips as ApartmentsEquip on Apartment.id = ApartmentsEquip.apartment_id left join buildings_equips as BuildingsEquip on Building.id = BuildingsEquip.building_id where Apartment.tenant_id = 1 AND ( ( Apartment.layout_id = 3 OR Apartment.layout_id = 4 ) ) AND exists (select * from buildings where Building.ekidata_station_id=ekidata_station_id or Building.ekidata_station_2_id=ekidata_station_2_id or Building.ekidata_station_3_id=ekidata_station_3_id group by ekidata_station_id,ekidata_station_2_id,ekidata_station_3_id) | | 25 | 25 | 3 |
| 16 | select EkidataLine.name, EkidataLine.id, EkidataStation.name,EkidataStation.id 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 | 0 |
| 17 | select EkidataLine.name, EkidataLine.id, EkidataStation.name,EkidataStation.id 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 |
| 18 | select EkidataLine.name, EkidataLine.id, EkidataStation.name,EkidataStation.id 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 = 7469 | | 1 | 1 | 0 |
| 19 | select * from tenant_search_groups as TenantSearchGroup inner join tenant_search_conditions as TenantSearchCondition on TenantSearchCondition.tenant_search_group_id = TenantSearchGroup.id where TenantSearchGroup.search_rule_id != 4 and TenantSearchGroup.tenant_id = 1 | | 75 | 75 | 1 |
| 20 | select * from feature_pages as FeaturePage inner join icon_kinds as IconKind on IconKind.id = FeaturePage.icon_id inner join tenant_search_conditions as TenantSearchCondition on TenantSearchCondition.id = FeaturePage.search_condition_id inner join display_style_kinds as DisplayStyleKind on DisplayStyleKind.id = FeaturePage.display_style_id where FeaturePage.tenant_id = 1 and FeaturePage.is_show_toppage = 1 and FeaturePage.status = 1 order by FeaturePage.position | | 5 | 5 | 1 |
| 21 | 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 | 1 |
