Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 34]
Notice (8): Undefined index: MInquiryDial [APP/Controller/AppController.php, line 35]
学校名から探す | 学生賃貸組合

学校を入力

(default) 15 queries took 24 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `MAreaDistrict`.`id`, `MAreaDistrict`.`name` FROM `fudosan`.`app_m_area_districts` AS `MAreaDistrict` WHERE `MAreaDistrict`.`is_disabled` = '0' AND `MAreaDistrict`.`is_deleted` = '0'660
2SELECT `MAreaPrefecture`.`id`, `MAreaPrefecture`.`name` FROM `fudosan`.`app_m_area_prefectures` AS `MAreaPrefecture` WHERE `MAreaPrefecture`.`id` IN (8, 11, 12, 13, 14)550
3SELECT `MAreaCity`.`id`, `MAreaCity`.`name` FROM `fudosan`.`app_m_area_cities` AS `MAreaCity` WHERE `MAreaCity`.`is_disabled` = '0' AND `MAreaCity`.`is_deleted` = '0'2572570
4SELECT `MAreaLine`.`id`, `MAreaLine`.`name` FROM `fudosan`.`app_m_area_lines` AS `MAreaLine` WHERE `MAreaLine`.`is_disabled` = '0' AND `MAreaLine`.`is_deleted` = '0'1321320
5SELECT `MPropertyRentalType`.`id`, `MPropertyRentalType`.`name` FROM `fudosan`.`app_m_property_rental_types` AS `MPropertyRentalType` WHERE `MPropertyRentalType`.`is_disabled` = '0' AND `MPropertyRentalType`.`is_deleted` = '0'220
6SELECT `MPropertyContractType`.`id`, `MPropertyContractType`.`name` FROM `fudosan`.`app_m_property_contract_types` AS `MPropertyContractType` WHERE `MPropertyContractType`.`is_disabled` = '0' AND `MPropertyContractType`.`is_deleted` = '0'550
7SELECT `MPropertyBuildingType`.`id`, `MPropertyBuildingType`.`name` FROM `fudosan`.`app_m_property_building_types` AS `MPropertyBuildingType` WHERE `MPropertyBuildingType`.`is_disabled` = '0' AND `MPropertyBuildingType`.`is_deleted` = '0'440
8SELECT `MPropertyBuildingStructure`.`id`, `MPropertyBuildingStructure`.`name` FROM `fudosan`.`app_m_property_building_structures` AS `MPropertyBuildingStructure` WHERE `MPropertyBuildingStructure`.`is_disabled` = '0' AND `MPropertyBuildingStructure`.`is_deleted` = '0'660
9SELECT `MPropertyInformationModelType`.`id`, `MPropertyInformationModelType`.`name` FROM `fudosan`.`app_m_property_information_model_types` AS `MPropertyInformationModelType` WHERE `MPropertyInformationModelType`.`is_disabled` = '0' AND `MPropertyInformationModelType`.`is_deleted` = '0'10100
10SELECT `MPropertyStatus`.`id`, `MPropertyStatus`.`name` FROM `fudosan`.`app_m_property_statuses` AS `MPropertyStatus` WHERE `MPropertyStatus`.`is_disabled` = '0' AND `MPropertyStatus`.`is_deleted` = '0'330
11SELECT `MPropertyFeatureCategory`.`id`, `MPropertyFeatureCategory`.`name`, `MPropertyFeatureCategory`.`order`, `MPropertyFeatureCategory`.`is_disabled`, `MPropertyFeatureCategory`.`is_deleted`, `MPropertyFeatureCategory`.`created`, `MPropertyFeatureCategory`.`modified` FROM `fudosan`.`app_m_property_feature_categories` AS `MPropertyFeatureCategory` WHERE `MPropertyFeatureCategory`.`id` > 1 ORDER BY `MPropertyFeatureCategory`.`id` asc10100
12SELECT `MPropertyFeature`.`id`, `MPropertyFeature`.`name`, `MPropertyFeature`.`order`, `MPropertyFeature`.`is_disabled`, `MPropertyFeature`.`is_deleted`, `MPropertyFeature`.`m_property_feature_category_id`, `MPropertyFeature`.`created`, `MPropertyFeature`.`modified` FROM `fudosan`.`app_m_property_features` AS `MPropertyFeature` WHERE `MPropertyFeature`.`m_property_feature_category_id` IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)75750
13SELECT `MInquiryDial`.`id`, `MInquiryDial`.`name`, `MInquiryDial`.`display_name`, `MInquiryDial`.`order`, `MInquiryDial`.`is_disabled`, `MInquiryDial`.`is_deleted`, `MInquiryDial`.`created`, `MInquiryDial`.`modified` FROM `fudosan`.`app_m_inquiry_dials` AS `MInquiryDial` WHERE `MInquiryDial`.`is_disabled` = '0' AND `MInquiryDial`.`is_deleted` = '0' AND `MInquiryDial`.`id` = 30 LIMIT 1000
14SELECT `MSchoolCampus`.`id`, `MSchoolCampus`.`name`, `MSchoolCampus`.`pronunciation_of_name`, `MSchoolCampus`.`address`, `MSchoolCampus`.`latitude`, `MSchoolCampus`.`longitude`, `MSchoolCampus`.`order`, `MSchoolCampus`.`url`, `MSchoolCampus`.`is_disabled`, `MSchoolCampus`.`is_deleted`, `MSchoolCampus`.`m_area_prefecture_id`, `MSchoolCampus`.`m_area_city_id`, `MSchoolCampus`.`m_school_university_id`, `MSchoolCampus`.`created`, `MSchoolCampus`.`modified`, `MSchoolUniversity`.`id`, `MSchoolUniversity`.`name`, `MSchoolUniversity`.`pronunciation_of_name`, `MSchoolUniversity`.`order`, `MSchoolUniversity`.`url`, `MSchoolUniversity`.`is_disabled`, `MSchoolUniversity`.`is_deleted`, `MSchoolUniversity`.`m_school_type_id`, `MSchoolUniversity`.`created`, `MSchoolUniversity`.`modified` FROM `fudosan`.`app_m_school_campuses` AS `MSchoolCampus` LEFT JOIN `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` ON (`MSchoolCampus`.`m_school_university_id` = `MSchoolUniversity`.`id`) WHERE `MSchoolCampus`.`is_disabled` = '0' AND `MSchoolCampus`.`is_deleted` = '0' AND `MSchoolUniversity`.`m_school_type_id` = 1 ORDER BY `MSchoolUniversity`.`pronunciation_of_name` asc, `MSchoolCampus`.`id` asc45645611
15SELECT `MSchoolCampus`.`id`, `MSchoolCampus`.`name`, `MSchoolCampus`.`pronunciation_of_name`, `MSchoolCampus`.`address`, `MSchoolCampus`.`latitude`, `MSchoolCampus`.`longitude`, `MSchoolCampus`.`order`, `MSchoolCampus`.`url`, `MSchoolCampus`.`is_disabled`, `MSchoolCampus`.`is_deleted`, `MSchoolCampus`.`m_area_prefecture_id`, `MSchoolCampus`.`m_area_city_id`, `MSchoolCampus`.`m_school_university_id`, `MSchoolCampus`.`created`, `MSchoolCampus`.`modified`, `MSchoolUniversity`.`id`, `MSchoolUniversity`.`name`, `MSchoolUniversity`.`pronunciation_of_name`, `MSchoolUniversity`.`order`, `MSchoolUniversity`.`url`, `MSchoolUniversity`.`is_disabled`, `MSchoolUniversity`.`is_deleted`, `MSchoolUniversity`.`m_school_type_id`, `MSchoolUniversity`.`created`, `MSchoolUniversity`.`modified` FROM `fudosan`.`app_m_school_campuses` AS `MSchoolCampus` LEFT JOIN `fudosan`.`app_m_school_universities` AS `MSchoolUniversity` ON (`MSchoolCampus`.`m_school_university_id` = `MSchoolUniversity`.`id`) WHERE `MSchoolCampus`.`is_disabled` = '0' AND `MSchoolCampus`.`is_deleted` = '0' AND `MSchoolUniversity`.`m_school_type_id` = 2 ORDER BY `MSchoolUniversity`.`pronunciation_of_name` asc, `MSchoolCampus`.`id` asc62762713