SCHEDULE

SEMINAR & SCHOOL LIST

サロン検索

PAGE TOP

(default) 4 queries took 16 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `School`.`id`, `School`.`name` FROM `facialremedy`.`schools` AS `School` WHERE `invalid_flg` = 0 AND `deleted` = 09916
2SELECT `User`.`id`, `User`.`full_name` FROM `facialremedy`.`users` AS `User` WHERE `invalid_flg` = 0 AND `deleted` = 037370
3SELECT `Salon`.`id`, `Salon`.`salon_name` FROM `facialremedy`.`salons` AS `Salon` WHERE `invalid_flg` = 0 AND `deleted` = 030300
4SELECT `Schedule`.`id`, `Schedule`.`school_id`, `Schedule`.`data_id`, `Schedule`.`place`, `Schedule`.`detail_place`, `Schedule`.`how_date`, `Schedule`.`start_date`, `Schedule`.`end_date`, `Schedule`.`start_time`, `Schedule`.`end_time`, `Schedule`.`time_note`, `Schedule`.`seat`, `Schedule`.`detail_url`, `Schedule`.`brush_up`, `Schedule`.`note`, `Schedule`.`invalid_flg`, `Schedule`.`deleted`, `Schedule`.`create_user`, `Schedule`.`created`, `Schedule`.`modified_user`, `Schedule`.`modified`, `Salon`.`id`, `Salon`.`therapist_name`, `Salon`.`sei`, `Salon`.`mei`, `Salon`.`therapist_name_en`, `Salon`.`last_name`, `Salon`.`first_name`, `Salon`.`salon_name`, `Salon`.`area`, `Salon`.`pref`, `Salon`.`address`, `Salon`.`access1`, `Salon`.`access2`, `Salon`.`tel`, `Salon`.`site_url`, `Salon`.`blog_url`, `Salon`.`email`, `Salon`.`open`, `Salon`.`close`, `Salon`.`time_note`, `Salon`.`holiday`, `Salon`.`rush`, `Salon`.`credit_card`, `Salon`.`credit_card_note`, `Salon`.`stuff`, `Salon`.`seat`, `Salon`.`parking`, `Salon`.`pr1`, `Salon`.`pr2`, `Salon`.`campaign`, `Salon`.`note`, `Salon`.`group_id`, `Salon`.`user_id`, `Salon`.`disp_seq`, `Salon`.`invalid_flg`, `Salon`.`deleted`, `Salon`.`create_user`, `Salon`.`created`, `Salon`.`modified_user`, `Salon`.`modified` FROM `facialremedy`.`schedules` AS `Schedule` LEFT JOIN `facialremedy`.`users` AS `User` ON (`Schedule`.`data_id` = `User`.`id`) LEFT JOIN `facialremedy`.`salons` AS `Salon` ON (`Schedule`.`data_id` = `Salon`.`id`) WHERE `Schedule`.`deleted` = 0 AND `Schedule`.`invalid_flg` = 0 AND ((`Schedule`.`id` IS NULL) AND (1)) ORDER BY `Schedule`.`start_date` ASC LIMIT 20000