1 |
DESCRIBE `M_Ss_info` |
|
48 |
48 |
1 |
2 |
DESCRIBE `M_Cm_feature` |
|
32 |
32 |
1 |
3 |
DESCRIBE `M_Mt_tabemoni` |
|
68 |
68 |
2 |
4 |
DESCRIBE `M_Ma_asomoni` |
|
68 |
68 |
2 |
5 |
DESCRIBE `T_Mi_report` |
|
81 |
81 |
2 |
6 |
DESCRIBE `T_Ma_report` |
|
81 |
81 |
2 |
7 |
DESCRIBE `T_Mt_report` |
|
81 |
81 |
2 |
8 |
DESCRIBE `M_Mi_tabimoni` |
|
73 |
73 |
2 |
9 |
DESCRIBE `M_Mi_phtodir` |
|
1 |
1 |
0 |
10 |
DESCRIBE `M_Mi_companion` |
|
4 |
4 |
0 |
11 |
DESCRIBE `M_Mi_whom` |
|
4 |
4 |
0 |
12 |
DESCRIBE `M_Mi_album` |
|
4 |
4 |
0 |
13 |
DESCRIBE `M_Mi_access` |
|
4 |
4 |
0 |
14 |
DESCRIBE `M_Mi_oshi` |
|
4 |
4 |
0 |
15 |
SELECT `TMiReport`.`moni_id`, `TMiReport`.`hotel_id`, `TMiReport`.`member_id`, `TMiReport`.`contribution_day`, `TMiReport`.`hotel_name`, `TMiReport`.`sta_day`, `TMiReport`.`nickname`, `TMiReport`.`sex`, `TMiReport`.`age`, `TMiReport`.`prefectures`, `TMiReport`.`occupation`, `TMiReport`.`transportation`, `TMiReport`.`theme`, `TMiReport`.`companion_id`, `TMiReport`.`monitor_pic`, `TMiReport`.`moni_comment`, `TMiReport`.`oshi_id`, `TMiReport`.`oshi_pic`, `TMiReport`.`oshi_title`, `TMiReport`.`oshi_memo`, `TMiReport`.`whom_id`, `TMiReport`.`whom_mem`, `TMiReport`.`album1_id`, `TMiReport`.`album1_pic`, `TMiReport`.`album1_mem`, `TMiReport`.`album2_id`, `TMiReport`.`album2_pic`, `TMiReport`.`album2_mem`, `TMiReport`.`album3_id`, `TMiReport`.`album3_pic`, `TMiReport`.`album3_mem`, `TMiReport`.`album4_id`, `TMiReport`.`album4_pic`, `TMiReport`.`album4_mem`, `TMiReport`.`album5_id`, `TMiReport`.`album5_pic`, `TMiReport`.`album5_mem`, `TMiReport`.`album6_id`, `TMiReport`.`album6_pic`, `TMiReport`.`album6_mem`, `TMiReport`.`see1_pic`, `TMiReport`.`see1_name`, `TMiReport`.`see1_access`, `TMiReport`.`see1_from`, `TMiReport`.`see1_mem`, `TMiReport`.`see2_pic`, `TMiReport`.`see2_name`, `TMiReport`.`see2_access`, `TMiReport`.`see2_from`, `TMiReport`.`see2_mem`, `TMiReport`.`see3_pic`, `TMiReport`.`see3_name`, `TMiReport`.`see3_access`, `TMiReport`.`see3_from`, `TMiReport`.`see3_mem`, `TMiReport`.`location_id`, `TMiReport`.`location_god`, `TMiReport`.`location_bad`, `TMiReport`.`reception_id`, `TMiReport`.`reception_god`, `TMiReport`.`reception_bad`, `TMiReport`.`supper_id`, `TMiReport`.`supper_god`, `TMiReport`.`supper_bad`, `TMiReport`.`breakfast_id`, `TMiReport`.`breakfast_god`, `TMiReport`.`breakfast_bad`, `TMiReport`.`room_id`, `TMiReport`.`room_god`, `TMiReport`.`room_bad`, `TMiReport`.`bath_id`, `TMiReport`.`bath_god`, `TMiReport`.`bath_bad`, `TMiReport`.`inside_id`, `TMiReport`.`inside_god`, `TMiReport`.`inside_bad`, `TMiReport`.`others`, `TMiReport`.`seo_description`, `TMiReport`.`evaluation`, `TMiReport`.`seo_title`, `TMiReport`.`seo_keyword` FROM `T_Mi_report` AS `TMiReport` WHERE `TMiReport`.`moni_id` = 201623 AND `TMiReport`.`hotel_id` = 201605230001 LIMIT 1 |
|
1 |
1 |
1 |
16 |
SELECT `MMiCompanion`.`id`, `MMiCompanion`.`i_name`, `MMiCompanion`.`d_order`, `MMiCompanion`.`del_flag` FROM `M_Mi_companion` AS `MMiCompanion` WHERE `MMiCompanion`.`id` = 4 AND `MMiCompanion`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
17 |
SELECT `MMiWhom`.`id`, `MMiWhom`.`i_name`, `MMiWhom`.`d_order`, `MMiWhom`.`del_flag` FROM `M_Mi_whom` AS `MMiWhom` WHERE `MMiWhom`.`del_flag` = 0 ORDER BY `MMiWhom`.`d_order` asc |
|
9 |
9 |
0 |
18 |
SELECT `MMiPhtodir`.`dir` FROM `M_Mi_phtodir` AS `MMiPhtodir` WHERE 1 = 1 LIMIT 1 |
|
1 |
1 |
0 |
19 |
SELECT `MMiAlbum`.`id`, `MMiAlbum`.`i_name`, `MMiAlbum`.`d_order`, `MMiAlbum`.`del_flag` FROM `M_Mi_album` AS `MMiAlbum` WHERE `MMiAlbum`.`id` = 1 AND `MMiAlbum`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
20 |
SELECT `MMiAlbum`.`id`, `MMiAlbum`.`i_name`, `MMiAlbum`.`d_order`, `MMiAlbum`.`del_flag` FROM `M_Mi_album` AS `MMiAlbum` WHERE `MMiAlbum`.`id` = 2 AND `MMiAlbum`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
21 |
SELECT `MMiAlbum`.`id`, `MMiAlbum`.`i_name`, `MMiAlbum`.`d_order`, `MMiAlbum`.`del_flag` FROM `M_Mi_album` AS `MMiAlbum` WHERE `MMiAlbum`.`id` = 5 AND `MMiAlbum`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
22 |
SELECT `MMiAlbum`.`id`, `MMiAlbum`.`i_name`, `MMiAlbum`.`d_order`, `MMiAlbum`.`del_flag` FROM `M_Mi_album` AS `MMiAlbum` WHERE `MMiAlbum`.`id` = 3 AND `MMiAlbum`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
23 |
SELECT `MMiAlbum`.`id`, `MMiAlbum`.`i_name`, `MMiAlbum`.`d_order`, `MMiAlbum`.`del_flag` FROM `M_Mi_album` AS `MMiAlbum` WHERE `MMiAlbum`.`id` = 4 AND `MMiAlbum`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
24 |
SELECT `MMiAlbum`.`id`, `MMiAlbum`.`i_name`, `MMiAlbum`.`d_order`, `MMiAlbum`.`del_flag` FROM `M_Mi_album` AS `MMiAlbum` WHERE `MMiAlbum`.`id` = 4 AND `MMiAlbum`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
25 |
SELECT `MMiAccess`.`id`, `MMiAccess`.`i_name`, `MMiAccess`.`d_order`, `MMiAccess`.`del_flag` FROM `M_Mi_access` AS `MMiAccess` WHERE `MMiAccess`.`id` = 1 AND `MMiAccess`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
26 |
SELECT `MMiAccess`.`id`, `MMiAccess`.`i_name`, `MMiAccess`.`d_order`, `MMiAccess`.`del_flag` FROM `M_Mi_access` AS `MMiAccess` WHERE `MMiAccess`.`id` = 1 AND `MMiAccess`.`del_flag` = 0 LIMIT 1 |
|
1 |
1 |
0 |
27 |
SELECT `MMiTabimoni`.`id`, `MMiTabimoni`.`hotel_id`, `MMiTabimoni`.`sub_id`, `MMiTabimoni`.`printing_s`, `MMiTabimoni`.`printing_e`, `MMiTabimoni`.`d_order`, `MMiTabimoni`.`plan_pic`, `MMiTabimoni`.`plan_name`, `MMiTabimoni`.`plan_led`, `MMiTabimoni`.`plan_outline`, `MMiTabimoni`.`plan_limit_note`, `MMiTabimoni`.`client_pic`, `MMiTabimoni`.`client_comment`, `MMiTabimoni`.`opening_s`, `MMiTabimoni`.`opening_e`, `MMiTabimoni`.`noof_group`, `MMiTabimoni`.`noof_person`, `MMiTabimoni`.`noof_person_max`, `MMiTabimoni`.`conditions`, `MMiTabimoni`.`stay_days`, `MMiTabimoni`.`stay_start`, `MMiTabimoni`.`stay_end`, `MMiTabimoni`.`stay_note`, `MMiTabimoni`.`election_day`, `MMiTabimoni`.`choice_day`, `MMiTabimoni`.`declaration_day`, `MMiTabimoni`.`dayofchoice1`, `MMiTabimoni`.`dayofchoice2`, `MMiTabimoni`.`dayofchoice3`, `MMiTabimoni`.`dayofchoice4`, `MMiTabimoni`.`dayofchoice5`, `MMiTabimoni`.`experience_day`, `MMiTabimoni`.`gohome_day`, `MMiTabimoni`.`report_day`, `MMiTabimoni`.`report_regday`, `MMiTabimoni`.`report_upday`, `MMiTabimoni`.`candidate_id`, `MMiTabimoni`.`pc_icon_url`, `MMiTabimoni`.`sp_icon_url`, `MMiTabimoni`.`pc_title_url`, `MMiTabimoni`.`sp_title_url`, `MMiTabimoni`.`editing_flag`, `MMiTabimoni`.`schedule_printing_e`, `MMiTabimoni`.`schedule_opening_e`, `MMiTabimoni`.`is_defeat_flag`, `MMiTabimoni`.`send_defeat_flag`, `MMiTabimoni`.`corp_banner_path_pc`, `MMiTabimoni`.`corp_banner_path_sp`, `MMiTabimoni`.`corp_banner_url`, `MMiTabimoni`.`headline`, `MMiTabimoni`.`lead`, `MMiTabimoni`.`fromhotel`, `MMiTabimoni`.`another`, `MMiTabimoni`.`comment`, `MMiTabimoni`.`pic_m`, `MMiTabimoni`.`cap_m`, `MMiTabimoni`.`pic_s1`, `MMiTabimoni`.`cap_s1`, `MMiTabimoni`.`led_s1`, `MMiTabimoni`.`pic_s2`, `MMiTabimoni`.`cap_s2`, `MMiTabimoni`.`led_s2`, `MMiTabimoni`.`pic_s3`, `MMiTabimoni`.`cap_s3`, `MMiTabimoni`.`led_s3`, `MMiTabimoni`.`site_id`, `MMiTabimoni`.`note`, `MMiTabimoni`.`og_img_pic`, `MMiTabimoni`.`monitor_privilege`, `MMiTabimoni`.`entry_privilege`, `MMiTabimoni`.`seo_title`, `MMiTabimoni`.`seo_keyword`, `MMiTabimoni`.`seo_description` FROM `M_Mi_tabimoni` AS `MMiTabimoni` WHERE `MMiTabimoni`.`id` = 201623 AND `MMiTabimoni`.`hotel_id` = 201605230001 AND `MMiTabimoni`.`sub_id` = 1 LIMIT 1 |
|
1 |
1 |
0 |