1 | SHOW FULL COLUMNS FROM `view_casts` | | 45 | 45 | 2 |
2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_general_ci'; | | 1 | 1 | 1 |
3 | SHOW FULL COLUMNS FROM `cast_appeal_tags` | | 7 | 7 | 2 |
4 | SHOW FULL COLUMNS FROM `appeal_tags` | | 8 | 8 | 2 |
5 | SHOW FULL COLUMNS FROM `cast_reviews` | | 19 | 19 | 2 |
6 | SHOW FULL COLUMNS FROM `view_schedules` | | 18 | 18 | 2 |
7 | SHOW FULL COLUMNS FROM `cast_profile_plays` | | 7 | 7 | 2 |
8 | SHOW FULL COLUMNS FROM `profile_plays` | | 10 | 10 | 2 |
9 | SHOW FULL COLUMNS FROM `profile_play_categories` | | 9 | 9 | 2 |
10 | SHOW FULL COLUMNS FROM `cast_photo_diary_articles` | | 13 | 13 | 2 |
11 | SHOW FULL COLUMNS FROM `cast_movies` | | 10 | 10 | 2 |
12 | SHOW FULL COLUMNS FROM `cast_used_cast_image_roles` | | 10 | 10 | 2 |
13 | SHOW FULL COLUMNS FROM `cast_free_contents` | | 9 | 9 | 2 |
14 | SHOW FULL COLUMNS FROM `costumes` | | 11 | 11 | 2 |
15 | SHOW FULL COLUMNS FROM `maps` | | 13 | 13 | 2 |
16 | SHOW FULL COLUMNS FROM `map_pin_points` | | 14 | 14 | 2 |
17 | SHOW FULL COLUMNS FROM `site_pages` | | 15 | 15 | 2 |
18 | SHOW FULL COLUMNS FROM `site_page_items` | | 8 | 8 | 2 |
19 | SHOW FULL COLUMNS FROM `site_template_codes` | | 9 | 9 | 2 |
20 | SHOW FULL COLUMNS FROM `shops` | | 94 | 94 | 3 |
21 | SHOW FULL COLUMNS FROM `corporations` | | 38 | 38 | 2 |
22 | SHOW FULL COLUMNS FROM `announce_banners` | | 10 | 10 | 2 |
23 | SELECT `Shop`.`id`, `Shop`.`corporation_id`, `Shop`.`group_id`, `Shop`.`shop_type`, `Shop`.`delivery_type`, `Shop`.`business_type_id`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`short_name`, `Shop`.`name_kana`, `Shop`.`shop_tel`, `Shop`.`check_in_tel`, `Shop`.`man_recruit_tel`, `Shop`.`woman_recruit_tel`, `Shop`.`talent_contact_tel`, `Shop`.`shop_tel_hyphen`, `Shop`.`check_in_tel_hyphen`, `Shop`.`man_recruit_tel_hyphen`, `Shop`.`woman_recruit_tel_hyphen`, `Shop`.`talent_contact_tel_hyphen`, `Shop`.`site_domain`, `Shop`.`mail_domain`, `Shop`.`shop_email`, `Shop`.`recruit_email`, `Shop`.`cast_contact_email`, `Shop`.`offical_site_pc_url`, `Shop`.`offical_site_sp_url`, `Shop`.`offical_site_mb_url`, `Shop`.`line_id`, `Shop`.`line_url`, `Shop`.`open_time`, `Shop`.`close_time`, `Shop`.`reception_start_time`, `Shop`.`reception_end_time`, `Shop`.`alert_schedule_minute`, `Shop`.`alert_driver_minute`, `Shop`.`uncollect_display_flag`, `Shop`.`exam_after_day_notice`, `Shop`.`exam_after_day_warning`, `Shop`.`exam_after_schedule_notice`, `Shop`.`exam_after_schedule_warning`, `Shop`.`exam_after_reservation_notice`, `Shop`.`exam_after_reservation_warning`, `Shop`.`media_send_flag`, `Shop`.`media_login_id`, `Shop`.`media_login_password`, `Shop`.`act_media_send_flag`, `Shop`.`act_media_login_id`, `Shop`.`limit_display_schedule_days`, `Shop`.`new_face_schedule_days`, `Shop`.`new_face_switch_judgment_type`, `Shop`.`pickup_campaign_display_flag`, `Shop`.`cast_sort_random_display_flag`, `Shop`.`shop_default_thumbnail_set_id`, `Shop`.`limit_pickup_cast`, `Shop`.`limit_shop_background_image`, `Shop`.`appeal_tag_number`, `Shop`.`use_terms`, `Shop`.`card_fee`, `Shop`.`timetable_newface_exam_check_flag`, `Shop`.`timetable_address_display_type`, `Shop`.`timetable_time_limit_alert_flag`, `Shop`.`timetable_shop_line_color`, `Shop`.`timetable_display_work_limit`, `Shop`.`reservation_contact_cast_tel_non_notification_flag`, `Shop`.`reservation_contact_driver_tel_non_notification_flag`, `Shop`.`reservation_contact_customer_tel_hide_flag`, `Shop`.`shop_color`, `Shop`.`sort_no`, `Shop`.`web_member_site_joined_flag`, `Shop`.`site_member_site_public_flag`, `Shop`.`inbound_site_public_flag`, `Shop`.`concept`, `Shop`.`min_course_minute`, `Shop`.`min_course_money`, `Shop`.`average_usage_money`, `Shop`.`service_content_tag1`, `Shop`.`service_content_tag2`, `Shop`.`service_content_tag3`, `Shop`.`service_content_tag4`, `Shop`.`site_member_site_reservation_play_time_comment`, `Shop`.`site_member_site_reservation_option_comment`, `Shop`.`site_member_site_reservation_place_use_comment`, `Shop`.`site_member_site_reservation_confirm_template_home`, `Shop`.`site_member_site_reservation_confirm_template_hotel`, `Shop`.`cybozu_template`, `Shop`.`dispatch_area_description`, `Shop`.`registration_button_warning`, `Shop`.`standby_corporation_facility_id`, `Shop`.`closed_flag`, `Shop`.`ranking_display_type`, `Shop`.`deleted_at`, `Shop`.`created_at`, `Shop`.`updated_at`, `Corporation`.`id`, `Corporation`.`name`, `Corporation`.`short_name`, `Corporation`.`area_name`, `Corporation`.`company_name`, `Corporation`.`company_postal_code`, `Corporation`.`company_address`, `Corporation`.`company_tel`, `Corporation`.`date_switch_time`, `Corporation`.`cashbox_id`, `Corporation`.`driver_group_id`, `Corporation`.`timetable_cast_memo_sort_no`, `Corporation`.`timetable_schedule_confirmed_sync_flag`, `Corporation`.`timetable_reception_end_sync_flag`, `Corporation`.`timetable_money_lend_sync_flag`, `Corporation`.`timetable_next_schedule_sync_flag`, `Corporation`.`timetable_personal_belongins_sync_flag`, `Corporation`.`gasoline_subsidy_fee`, `Corporation`.`money_lend_value`, `Corporation`.`star_payment_key`, `Corporation`.`inbound_star_payment_key`, `Corporation`.`before_shop_entry_check_sheet`, `Corporation`.`waiting_place_address`, `Corporation`.`invoice_registration_number`, `Corporation`.`auto_driver_active_flag`, `Corporation`.`closed_flag`, `Corporation`.`notice_chat_flag`, `Corporation`.`notice_sos_flag`, `Corporation`.`notice_black_flag`, `Corporation`.`notice_schedule_flag`, `Corporation`.`notice_news_flag`, `Corporation`.`notice_profile_flag`, `Corporation`.`notice_reservation_flag`, `Corporation`.`notice_exam_flag`, `Corporation`.`notice_place_change_flag`, `Corporation`.`deleted_at`, `Corporation`.`created_at`, `Corporation`.`updated_at` FROM `shops` AS `Shop` LEFT JOIN `corporations` AS `Corporation` ON (`Shop`.`corporation_id` = `Corporation`.`id`) WHERE `Shop`.`id` = 61 LIMIT 1 | | 1 | 1 | 1 |
24 | SELECT `Shop`.`id`, `Shop`.`corporation_id`, `Shop`.`group_id`, `Shop`.`shop_type`, `Shop`.`delivery_type`, `Shop`.`business_type_id`, `Shop`.`area_id`, `Shop`.`name`, `Shop`.`short_name`, `Shop`.`name_kana`, `Shop`.`shop_tel`, `Shop`.`check_in_tel`, `Shop`.`man_recruit_tel`, `Shop`.`woman_recruit_tel`, `Shop`.`talent_contact_tel`, `Shop`.`shop_tel_hyphen`, `Shop`.`check_in_tel_hyphen`, `Shop`.`man_recruit_tel_hyphen`, `Shop`.`woman_recruit_tel_hyphen`, `Shop`.`talent_contact_tel_hyphen`, `Shop`.`site_domain`, `Shop`.`mail_domain`, `Shop`.`shop_email`, `Shop`.`recruit_email`, `Shop`.`cast_contact_email`, `Shop`.`offical_site_pc_url`, `Shop`.`offical_site_sp_url`, `Shop`.`offical_site_mb_url`, `Shop`.`line_id`, `Shop`.`line_url`, `Shop`.`open_time`, `Shop`.`close_time`, `Shop`.`reception_start_time`, `Shop`.`reception_end_time`, `Shop`.`alert_schedule_minute`, `Shop`.`alert_driver_minute`, `Shop`.`uncollect_display_flag`, `Shop`.`exam_after_day_notice`, `Shop`.`exam_after_day_warning`, `Shop`.`exam_after_schedule_notice`, `Shop`.`exam_after_schedule_warning`, `Shop`.`exam_after_reservation_notice`, `Shop`.`exam_after_reservation_warning`, `Shop`.`media_send_flag`, `Shop`.`media_login_id`, `Shop`.`media_login_password`, `Shop`.`act_media_send_flag`, `Shop`.`act_media_login_id`, `Shop`.`limit_display_schedule_days`, `Shop`.`new_face_schedule_days`, `Shop`.`new_face_switch_judgment_type`, `Shop`.`pickup_campaign_display_flag`, `Shop`.`cast_sort_random_display_flag`, `Shop`.`shop_default_thumbnail_set_id`, `Shop`.`limit_pickup_cast`, `Shop`.`limit_shop_background_image`, `Shop`.`appeal_tag_number`, `Shop`.`use_terms`, `Shop`.`card_fee`, `Shop`.`timetable_newface_exam_check_flag`, `Shop`.`timetable_address_display_type`, `Shop`.`timetable_time_limit_alert_flag`, `Shop`.`timetable_shop_line_color`, `Shop`.`timetable_display_work_limit`, `Shop`.`reservation_contact_cast_tel_non_notification_flag`, `Shop`.`reservation_contact_driver_tel_non_notification_flag`, `Shop`.`reservation_contact_customer_tel_hide_flag`, `Shop`.`shop_color`, `Shop`.`sort_no`, `Shop`.`web_member_site_joined_flag`, `Shop`.`site_member_site_public_flag`, `Shop`.`inbound_site_public_flag`, `Shop`.`concept`, `Shop`.`min_course_minute`, `Shop`.`min_course_money`, `Shop`.`average_usage_money`, `Shop`.`service_content_tag1`, `Shop`.`service_content_tag2`, `Shop`.`service_content_tag3`, `Shop`.`service_content_tag4`, `Shop`.`site_member_site_reservation_play_time_comment`, `Shop`.`site_member_site_reservation_option_comment`, `Shop`.`site_member_site_reservation_place_use_comment`, `Shop`.`site_member_site_reservation_confirm_template_home`, `Shop`.`site_member_site_reservation_confirm_template_hotel`, `Shop`.`cybozu_template`, `Shop`.`dispatch_area_description`, `Shop`.`registration_button_warning`, `Shop`.`standby_corporation_facility_id`, `Shop`.`closed_flag`, `Shop`.`ranking_display_type`, `Shop`.`deleted_at`, `Shop`.`created_at`, `Shop`.`updated_at`, `Corporation`.`id`, `Corporation`.`name`, `Corporation`.`short_name`, `Corporation`.`area_name`, `Corporation`.`company_name`, `Corporation`.`company_postal_code`, `Corporation`.`company_address`, `Corporation`.`company_tel`, `Corporation`.`date_switch_time`, `Corporation`.`cashbox_id`, `Corporation`.`driver_group_id`, `Corporation`.`timetable_cast_memo_sort_no`, `Corporation`.`timetable_schedule_confirmed_sync_flag`, `Corporation`.`timetable_reception_end_sync_flag`, `Corporation`.`timetable_money_lend_sync_flag`, `Corporation`.`timetable_next_schedule_sync_flag`, `Corporation`.`timetable_personal_belongins_sync_flag`, `Corporation`.`gasoline_subsidy_fee`, `Corporation`.`money_lend_value`, `Corporation`.`star_payment_key`, `Corporation`.`inbound_star_payment_key`, `Corporation`.`before_shop_entry_check_sheet`, `Corporation`.`waiting_place_address`, `Corporation`.`invoice_registration_number`, `Corporation`.`auto_driver_active_flag`, `Corporation`.`closed_flag`, `Corporation`.`notice_chat_flag`, `Corporation`.`notice_sos_flag`, `Corporation`.`notice_black_flag`, `Corporation`.`notice_schedule_flag`, `Corporation`.`notice_news_flag`, `Corporation`.`notice_profile_flag`, `Corporation`.`notice_reservation_flag`, `Corporation`.`notice_exam_flag`, `Corporation`.`notice_place_change_flag`, `Corporation`.`deleted_at`, `Corporation`.`created_at`, `Corporation`.`updated_at` FROM `shops` AS `Shop` LEFT JOIN `corporations` AS `Corporation` ON (`Shop`.`corporation_id` = `Corporation`.`id`) WHERE `Shop`.`id` = 61 LIMIT 1 | | 1 | 1 | 1 |
25 | SELECT `SitePage`.`page_key`, `SitePage`.`name`, `SitePage`.`request_url`, `SitePage`.`breadcrumb` FROM `site_pages` AS `SitePage` WHERE `SitePage`.`site_device_id` = 41 AND `SitePage`.`shop_id` = 61 AND `SitePage`.`deleted_at` IS NULL | | 35 | 35 | 1 |
26 | SELECT `AnnounceBanner`.`id`, `AnnounceBanner`.`shop_id`, `AnnounceBanner`.`name`, `AnnounceBanner`.`url`, `AnnounceBanner`.`image_filename`, `AnnounceBanner`.`sort_no`, `AnnounceBanner`.`public_flag`, `AnnounceBanner`.`deleted_at`, `AnnounceBanner`.`created_at`, `AnnounceBanner`.`updated_at` FROM `announce_banners` AS `AnnounceBanner` WHERE `AnnounceBanner`.`shop_id` = 61 AND `AnnounceBanner`.`public_flag` = 1 AND `AnnounceBanner`.`deleted_at` IS NULL ORDER BY `AnnounceBanner`.`sort_no` ASC | | 0 | 0 | 1 |