旅のおためしサイト

モニター当選者が旅先で見つけた、新たな発見や率直な感想を、モニター体験記としてご紹介しています。
温泉好きや、美味しいもの好きなど、モニターによってそれぞれ視点が異なるのも見どころ。
リアルな旅情報が満載のモニター体験記を、あなたの旅の参考にしてみては?

旅モニでは、2016年9月より、素敵なモニター体験記を書いていただいた方を表彰する「旅モニ体験記アワード」を実施します。表彰者には、日本各地から選りすぐりしたご当地品や旅モニオリジナルグッズなどの記念品を進呈。旅モニのモニターに当選された方は、モニター体験を思いっきり満喫して、みんなが旅に出たくなるような「うれしい!おいしい!感動!」といった自分流の体験を投稿してください。あなたの体験記が、他の誰かの旅のきっかけになりますように…

キャンペーン概要

第1回 旅モニ体験記アワード
●対象:
2016年9月1日~2017年2月28日の期間内で旅モニの当選者としてモニターに参加し、モニター体験記を提出された方
※宿泊モニター、レジャーモニター、飲食モニター、特別モニターなど全てのモニターを対象とします。
●選出基準:
写真のクオリティや文章の上手さだけではなく、独自の視点、地域との交流など、モニター体験をより魅力的に伝えてくれた方を選出します。
●賞品:
グランプリ 1名(旅モニ事務局セレクトのご当地品1万円相当)
特別賞 若干名(旅モニオリジナルグッズ※非売品)
表彰者は毎年11月に実施予定の旅モニイベントへご招待します。
●発表:2017年4月予定 旅モニ内特別ページにて発表
※当選者へは3月中にご連絡いたします。

  • モニター種別で選ぶ(必須)

  • エリアやその他の情報から絞る

  •  

(default) 15 queries took 31 ms
Nr Query Error Affected Num. rows Took (ms)
1 DESCRIBE `M_Mi_phtodir` 1 1 0
2 DESCRIBE `M_Mi_whom` 4 4 0
3 DESCRIBE `M_Mi_album` 4 4 1
4 DESCRIBE `M_Mi_access` 4 4 0
5 DESCRIBE `M_Mi_oshi` 4 4 0
6 SELECT `MMiPhtodir`.`dir` FROM `M_Mi_phtodir` AS `MMiPhtodir` WHERE 1 = 1 LIMIT 1 1 1 0
7 SELECT `MCmFeature`.`id`, `MCmFeature`.`feature_title`, `MCmFeature`.`feature_caption`, `MCmFeature`.`feature_content`, `MCmFeature`.`feature_pic`, `MCmFeature`.`feature_comment`, `MCmFeature`.`banner_url`, `MCmFeature`.`external_flag`, `MCmFeature`.`window`, `MCmFeature`.`link_url`, `MCmFeature`.`navigator_flag`, `MCmFeature`.`topics_caption1`, `MCmFeature`.`topics_content1`, `MCmFeature`.`topics_pic_url1`, `MCmFeature`.`topics_link_url1`, `MCmFeature`.`topics_genre1`, `MCmFeature`.`topics_caption2`, `MCmFeature`.`topics_content2`, `MCmFeature`.`topics_pic_url2`, `MCmFeature`.`topics_link_url2`, `MCmFeature`.`topics_genre2`, `MCmFeature`.`topics_caption3`, `MCmFeature`.`topics_content3`, `MCmFeature`.`topics_pic_url3`, `MCmFeature`.`topics_link_url3`, `MCmFeature`.`topics_genre3`, `MCmFeature`.`disp_from`, `MCmFeature`.`disp_to`, `MCmFeature`.`editing_flag`, `MCmFeature`.`schedule_disp_to`, `MCmFeature`.`created`, `MCmFeature`.`modified` FROM `M_Cm_feature` AS `MCmFeature` WHERE `MCmFeature`.`disp_from` <= '2016-10-17 15:11:16' AND `MCmFeature`.`editing_flag` = 0 AND `MCmFeature`.`external_flag` = 0 ORDER BY `MCmFeature`.`disp_from` DESC LIMIT 1 1 1 1
8 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`, `MMiElection`.`id`, `MMiElection`.`institution_id`, `MMiElection`.`group_no`, `MMiElection`.`candidate_id`, `MMiElection`.`experience_day`, `MMiElection`.`reg_experience_day`, `MMiElection`.`noof_experience`, `MMiElection`.`report_day`, `MMiElection`.`report_regday`, `MMiElection`.`report_upday`, `MMiElection`.`reserve_id`, `MMiElection`.`reserve_day`, `MMiElection`.`notice_prizewinner`, `MMiElection`.`notice_deadline`, `MMiElection`.`notice_limit_deadline`, `MMiElection`.`notice_process`, `MMiElection`.`notice_rem_decision`, `MMiElection`.`notice_limit_rem_decision`, `MMiElection`.`notice_voucher`, `MMiElection`.`notice_1week`, `MMiElection`.`notice_1day`, `MMiElection`.`notice_gohome`, `MMiElection`.`notice_rem_report`, `MMiElection`.`notice_thankyou`, `MMiElection`.`mail_prizewinner`, `MMiElection`.`mail_process`, `MMiElection`.`mail_rem_decision`, `MMiElection`.`mail_voucher`, `MMiElection`.`mail_1week`, `MMiElection`.`mail_previous`, `MMiElection`.`mail_home`, `MMiElection`.`mail_unsubmitted`, `MMiElection`.`mail_thankyou`, `MMiElection`.`mail_cl_prizewinner`, `MMiElection`.`mail_cl_prizewinner_pw`, `MMiElection`.`mail_cl_voucher`, `MMiElection`.`mail_cl_voucher_pw`, `MMiElection`.`mail_cl_reminder`, `MMiElection`.`register_button`, `MMiElection`.`ticket_button`, `MMiElection`.`report_button`, `MMiElection`.`status` FROM `T_Mi_report` AS `TMiReport` LEFT JOIN `M_Mi_election` AS `MMiElection` ON (`TMiReport`.`moni_id` = `MMiElection`.`id` AND `TMiReport`.`hotel_id` = `MMiElection`.`institution_id` AND `TMiReport`.`member_id` = `MMiElection`.`candidate_id`) WHERE `TMiReport`.`evaluation` = 5 AND `MMiElection`.`report_upday` <= '2016-10-17' ORDER BY md5(concat(now(), `TMiReport`.`moni_id`)) ASC LIMIT 10 10 10 20
9 SELECT `TMtReport`.`moni_id`, `TMtReport`.`hotel_id`, `TMtReport`.`member_id`, `TMtReport`.`contribution_day`, `TMtReport`.`hotel_name`, `TMtReport`.`sta_day`, `TMtReport`.`nickname`, `TMtReport`.`sex`, `TMtReport`.`age`, `TMtReport`.`prefectures`, `TMtReport`.`occupation`, `TMtReport`.`transportation`, `TMtReport`.`theme`, `TMtReport`.`companion_id`, `TMtReport`.`monitor_pic`, `TMtReport`.`moni_comment`, `TMtReport`.`oshi_id`, `TMtReport`.`oshi_pic`, `TMtReport`.`oshi_title`, `TMtReport`.`oshi_memo`, `TMtReport`.`whom_id`, `TMtReport`.`whom_mem`, `TMtReport`.`album1_id`, `TMtReport`.`album1_pic`, `TMtReport`.`album1_mem`, `TMtReport`.`album2_id`, `TMtReport`.`album2_pic`, `TMtReport`.`album2_mem`, `TMtReport`.`album3_id`, `TMtReport`.`album3_pic`, `TMtReport`.`album3_mem`, `TMtReport`.`album4_id`, `TMtReport`.`album4_pic`, `TMtReport`.`album4_mem`, `TMtReport`.`album5_id`, `TMtReport`.`album5_pic`, `TMtReport`.`album5_mem`, `TMtReport`.`album6_id`, `TMtReport`.`album6_pic`, `TMtReport`.`album6_mem`, `TMtReport`.`see1_pic`, `TMtReport`.`see1_name`, `TMtReport`.`see1_access`, `TMtReport`.`see1_from`, `TMtReport`.`see1_mem`, `TMtReport`.`see2_pic`, `TMtReport`.`see2_name`, `TMtReport`.`see2_access`, `TMtReport`.`see2_from`, `TMtReport`.`see2_mem`, `TMtReport`.`see3_pic`, `TMtReport`.`see3_name`, `TMtReport`.`see3_access`, `TMtReport`.`see3_from`, `TMtReport`.`see3_mem`, `TMtReport`.`location_id`, `TMtReport`.`location_god`, `TMtReport`.`location_bad`, `TMtReport`.`reception_id`, `TMtReport`.`reception_god`, `TMtReport`.`reception_bad`, `TMtReport`.`supper_id`, `TMtReport`.`supper_god`, `TMtReport`.`supper_bad`, `TMtReport`.`breakfast_id`, `TMtReport`.`breakfast_god`, `TMtReport`.`breakfast_bad`, `TMtReport`.`room_id`, `TMtReport`.`room_god`, `TMtReport`.`room_bad`, `TMtReport`.`bath_id`, `TMtReport`.`bath_god`, `TMtReport`.`bath_bad`, `TMtReport`.`inside_id`, `TMtReport`.`inside_god`, `TMtReport`.`inside_bad`, `TMtReport`.`others`, `TMtReport`.`seo_description`, `TMtReport`.`evaluation`, `TMtReport`.`seo_title`, `TMtReport`.`seo_keyword`, `MMtElection`.`id`, `MMtElection`.`institution_id`, `MMtElection`.`group_no`, `MMtElection`.`candidate_id`, `MMtElection`.`experience_day`, `MMtElection`.`reg_experience_day`, `MMtElection`.`noof_experience`, `MMtElection`.`report_day`, `MMtElection`.`report_regday`, `MMtElection`.`report_upday`, `MMtElection`.`reserve_id`, `MMtElection`.`reserve_day`, `MMtElection`.`notice_prizewinner`, `MMtElection`.`notice_deadline`, `MMtElection`.`notice_limit_deadline`, `MMtElection`.`notice_process`, `MMtElection`.`notice_rem_decision`, `MMtElection`.`notice_limit_rem_decision`, `MMtElection`.`notice_voucher`, `MMtElection`.`notice_1week`, `MMtElection`.`notice_1day`, `MMtElection`.`notice_gohome`, `MMtElection`.`notice_rem_report`, `MMtElection`.`notice_thankyou`, `MMtElection`.`mail_prizewinner`, `MMtElection`.`mail_process`, `MMtElection`.`mail_rem_decision`, `MMtElection`.`mail_voucher`, `MMtElection`.`mail_1week`, `MMtElection`.`mail_previous`, `MMtElection`.`mail_home`, `MMtElection`.`mail_unsubmitted`, `MMtElection`.`mail_thankyou`, `MMtElection`.`mail_cl_prizewinner`, `MMtElection`.`mail_cl_prizewinner_pw`, `MMtElection`.`mail_cl_voucher`, `MMtElection`.`mail_cl_voucher_pw`, `MMtElection`.`mail_cl_reminder`, `MMtElection`.`register_button`, `MMtElection`.`ticket_button`, `MMtElection`.`report_button`, `MMtElection`.`status` FROM `T_Mt_report` AS `TMtReport` LEFT JOIN `M_Mt_election` AS `MMtElection` ON (`TMtReport`.`moni_id` = `MMtElection`.`id` AND `TMtReport`.`hotel_id` = `MMtElection`.`institution_id` AND `TMtReport`.`member_id` = `MMtElection`.`candidate_id`) WHERE `TMtReport`.`evaluation` = 5 AND `MMtElection`.`report_upday` <= '2016-10-17' ORDER BY md5(concat(now(), `TMtReport`.`moni_id`)) ASC LIMIT 10 2 2 1
10 SELECT `TMaReport`.`moni_id`, `TMaReport`.`hotel_id`, `TMaReport`.`member_id`, `TMaReport`.`contribution_day`, `TMaReport`.`hotel_name`, `TMaReport`.`sta_day`, `TMaReport`.`nickname`, `TMaReport`.`sex`, `TMaReport`.`age`, `TMaReport`.`prefectures`, `TMaReport`.`occupation`, `TMaReport`.`transportation`, `TMaReport`.`theme`, `TMaReport`.`companion_id`, `TMaReport`.`monitor_pic`, `TMaReport`.`moni_comment`, `TMaReport`.`oshi_id`, `TMaReport`.`oshi_pic`, `TMaReport`.`oshi_title`, `TMaReport`.`oshi_memo`, `TMaReport`.`whom_id`, `TMaReport`.`whom_mem`, `TMaReport`.`album1_id`, `TMaReport`.`album1_pic`, `TMaReport`.`album1_mem`, `TMaReport`.`album2_id`, `TMaReport`.`album2_pic`, `TMaReport`.`album2_mem`, `TMaReport`.`album3_id`, `TMaReport`.`album3_pic`, `TMaReport`.`album3_mem`, `TMaReport`.`album4_id`, `TMaReport`.`album4_pic`, `TMaReport`.`album4_mem`, `TMaReport`.`album5_id`, `TMaReport`.`album5_pic`, `TMaReport`.`album5_mem`, `TMaReport`.`album6_id`, `TMaReport`.`album6_pic`, `TMaReport`.`album6_mem`, `TMaReport`.`see1_pic`, `TMaReport`.`see1_name`, `TMaReport`.`see1_access`, `TMaReport`.`see1_from`, `TMaReport`.`see1_mem`, `TMaReport`.`see2_pic`, `TMaReport`.`see2_name`, `TMaReport`.`see2_access`, `TMaReport`.`see2_from`, `TMaReport`.`see2_mem`, `TMaReport`.`see3_pic`, `TMaReport`.`see3_name`, `TMaReport`.`see3_access`, `TMaReport`.`see3_from`, `TMaReport`.`see3_mem`, `TMaReport`.`location_id`, `TMaReport`.`location_god`, `TMaReport`.`location_bad`, `TMaReport`.`reception_id`, `TMaReport`.`reception_god`, `TMaReport`.`reception_bad`, `TMaReport`.`supper_id`, `TMaReport`.`supper_god`, `TMaReport`.`supper_bad`, `TMaReport`.`breakfast_id`, `TMaReport`.`breakfast_god`, `TMaReport`.`breakfast_bad`, `TMaReport`.`room_id`, `TMaReport`.`room_god`, `TMaReport`.`room_bad`, `TMaReport`.`bath_id`, `TMaReport`.`bath_god`, `TMaReport`.`bath_bad`, `TMaReport`.`inside_id`, `TMaReport`.`inside_god`, `TMaReport`.`inside_bad`, `TMaReport`.`others`, `TMaReport`.`seo_description`, `TMaReport`.`evaluation`, `TMaReport`.`seo_title`, `TMaReport`.`seo_keyword`, `MMaElection`.`id`, `MMaElection`.`institution_id`, `MMaElection`.`group_no`, `MMaElection`.`candidate_id`, `MMaElection`.`experience_day`, `MMaElection`.`reg_experience_day`, `MMaElection`.`noof_experience`, `MMaElection`.`report_day`, `MMaElection`.`report_regday`, `MMaElection`.`report_upday`, `MMaElection`.`reserve_id`, `MMaElection`.`reserve_day`, `MMaElection`.`notice_prizewinner`, `MMaElection`.`notice_deadline`, `MMaElection`.`notice_limit_deadline`, `MMaElection`.`notice_process`, `MMaElection`.`notice_rem_decision`, `MMaElection`.`notice_limit_rem_decision`, `MMaElection`.`notice_voucher`, `MMaElection`.`notice_1week`, `MMaElection`.`notice_1day`, `MMaElection`.`notice_gohome`, `MMaElection`.`notice_rem_report`, `MMaElection`.`notice_thankyou`, `MMaElection`.`mail_prizewinner`, `MMaElection`.`mail_process`, `MMaElection`.`mail_rem_decision`, `MMaElection`.`mail_voucher`, `MMaElection`.`mail_1week`, `MMaElection`.`mail_previous`, `MMaElection`.`mail_home`, `MMaElection`.`mail_unsubmitted`, `MMaElection`.`mail_thankyou`, `MMaElection`.`mail_cl_prizewinner`, `MMaElection`.`mail_cl_prizewinner_pw`, `MMaElection`.`mail_cl_voucher`, `MMaElection`.`mail_cl_voucher_pw`, `MMaElection`.`mail_cl_reminder`, `MMaElection`.`register_button`, `MMaElection`.`ticket_button`, `MMaElection`.`report_button`, `MMaElection`.`status` FROM `T_Ma_report` AS `TMaReport` LEFT JOIN `M_Ma_election` AS `MMaElection` ON (`TMaReport`.`moni_id` = `MMaElection`.`id` AND `TMaReport`.`hotel_id` = `MMaElection`.`institution_id` AND `TMaReport`.`member_id` = `MMaElection`.`candidate_id`) WHERE `TMaReport`.`evaluation` = 5 AND `MMaElection`.`report_upday` <= '2016-10-17' ORDER BY md5(concat(now(), `TMaReport`.`moni_id`)) ASC LIMIT 10 5 5 2
11 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`, `MMiElection`.`id`, `MMiElection`.`institution_id`, `MMiElection`.`group_no`, `MMiElection`.`candidate_id`, `MMiElection`.`experience_day`, `MMiElection`.`reg_experience_day`, `MMiElection`.`noof_experience`, `MMiElection`.`report_day`, `MMiElection`.`report_regday`, `MMiElection`.`report_upday`, `MMiElection`.`reserve_id`, `MMiElection`.`reserve_day`, `MMiElection`.`notice_prizewinner`, `MMiElection`.`notice_deadline`, `MMiElection`.`notice_limit_deadline`, `MMiElection`.`notice_process`, `MMiElection`.`notice_rem_decision`, `MMiElection`.`notice_limit_rem_decision`, `MMiElection`.`notice_voucher`, `MMiElection`.`notice_1week`, `MMiElection`.`notice_1day`, `MMiElection`.`notice_gohome`, `MMiElection`.`notice_rem_report`, `MMiElection`.`notice_thankyou`, `MMiElection`.`mail_prizewinner`, `MMiElection`.`mail_process`, `MMiElection`.`mail_rem_decision`, `MMiElection`.`mail_voucher`, `MMiElection`.`mail_1week`, `MMiElection`.`mail_previous`, `MMiElection`.`mail_home`, `MMiElection`.`mail_unsubmitted`, `MMiElection`.`mail_thankyou`, `MMiElection`.`mail_cl_prizewinner`, `MMiElection`.`mail_cl_prizewinner_pw`, `MMiElection`.`mail_cl_voucher`, `MMiElection`.`mail_cl_voucher_pw`, `MMiElection`.`mail_cl_reminder`, `MMiElection`.`register_button`, `MMiElection`.`ticket_button`, `MMiElection`.`report_button`, `MMiElection`.`status` FROM `T_Mi_report` AS `TMiReport` LEFT JOIN `M_Mi_election` AS `MMiElection` ON (`TMiReport`.`moni_id` = `MMiElection`.`id` AND `TMiReport`.`hotel_id` = `MMiElection`.`institution_id` AND `TMiReport`.`member_id` = `MMiElection`.`candidate_id`) WHERE `MMiElection`.`report_upday` >= '2016-09-17' AND `MMiElection`.`report_upday` <= '2016-10-17' ORDER BY md5(concat(now(), `TMiReport`.`moni_id`)) ASC LIMIT 10 3 3 4
12 SELECT `TMtReport`.`moni_id`, `TMtReport`.`hotel_id`, `TMtReport`.`member_id`, `TMtReport`.`contribution_day`, `TMtReport`.`hotel_name`, `TMtReport`.`sta_day`, `TMtReport`.`nickname`, `TMtReport`.`sex`, `TMtReport`.`age`, `TMtReport`.`prefectures`, `TMtReport`.`occupation`, `TMtReport`.`transportation`, `TMtReport`.`theme`, `TMtReport`.`companion_id`, `TMtReport`.`monitor_pic`, `TMtReport`.`moni_comment`, `TMtReport`.`oshi_id`, `TMtReport`.`oshi_pic`, `TMtReport`.`oshi_title`, `TMtReport`.`oshi_memo`, `TMtReport`.`whom_id`, `TMtReport`.`whom_mem`, `TMtReport`.`album1_id`, `TMtReport`.`album1_pic`, `TMtReport`.`album1_mem`, `TMtReport`.`album2_id`, `TMtReport`.`album2_pic`, `TMtReport`.`album2_mem`, `TMtReport`.`album3_id`, `TMtReport`.`album3_pic`, `TMtReport`.`album3_mem`, `TMtReport`.`album4_id`, `TMtReport`.`album4_pic`, `TMtReport`.`album4_mem`, `TMtReport`.`album5_id`, `TMtReport`.`album5_pic`, `TMtReport`.`album5_mem`, `TMtReport`.`album6_id`, `TMtReport`.`album6_pic`, `TMtReport`.`album6_mem`, `TMtReport`.`see1_pic`, `TMtReport`.`see1_name`, `TMtReport`.`see1_access`, `TMtReport`.`see1_from`, `TMtReport`.`see1_mem`, `TMtReport`.`see2_pic`, `TMtReport`.`see2_name`, `TMtReport`.`see2_access`, `TMtReport`.`see2_from`, `TMtReport`.`see2_mem`, `TMtReport`.`see3_pic`, `TMtReport`.`see3_name`, `TMtReport`.`see3_access`, `TMtReport`.`see3_from`, `TMtReport`.`see3_mem`, `TMtReport`.`location_id`, `TMtReport`.`location_god`, `TMtReport`.`location_bad`, `TMtReport`.`reception_id`, `TMtReport`.`reception_god`, `TMtReport`.`reception_bad`, `TMtReport`.`supper_id`, `TMtReport`.`supper_god`, `TMtReport`.`supper_bad`, `TMtReport`.`breakfast_id`, `TMtReport`.`breakfast_god`, `TMtReport`.`breakfast_bad`, `TMtReport`.`room_id`, `TMtReport`.`room_god`, `TMtReport`.`room_bad`, `TMtReport`.`bath_id`, `TMtReport`.`bath_god`, `TMtReport`.`bath_bad`, `TMtReport`.`inside_id`, `TMtReport`.`inside_god`, `TMtReport`.`inside_bad`, `TMtReport`.`others`, `TMtReport`.`seo_description`, `TMtReport`.`evaluation`, `TMtReport`.`seo_title`, `TMtReport`.`seo_keyword`, `MMtElection`.`id`, `MMtElection`.`institution_id`, `MMtElection`.`group_no`, `MMtElection`.`candidate_id`, `MMtElection`.`experience_day`, `MMtElection`.`reg_experience_day`, `MMtElection`.`noof_experience`, `MMtElection`.`report_day`, `MMtElection`.`report_regday`, `MMtElection`.`report_upday`, `MMtElection`.`reserve_id`, `MMtElection`.`reserve_day`, `MMtElection`.`notice_prizewinner`, `MMtElection`.`notice_deadline`, `MMtElection`.`notice_limit_deadline`, `MMtElection`.`notice_process`, `MMtElection`.`notice_rem_decision`, `MMtElection`.`notice_limit_rem_decision`, `MMtElection`.`notice_voucher`, `MMtElection`.`notice_1week`, `MMtElection`.`notice_1day`, `MMtElection`.`notice_gohome`, `MMtElection`.`notice_rem_report`, `MMtElection`.`notice_thankyou`, `MMtElection`.`mail_prizewinner`, `MMtElection`.`mail_process`, `MMtElection`.`mail_rem_decision`, `MMtElection`.`mail_voucher`, `MMtElection`.`mail_1week`, `MMtElection`.`mail_previous`, `MMtElection`.`mail_home`, `MMtElection`.`mail_unsubmitted`, `MMtElection`.`mail_thankyou`, `MMtElection`.`mail_cl_prizewinner`, `MMtElection`.`mail_cl_prizewinner_pw`, `MMtElection`.`mail_cl_voucher`, `MMtElection`.`mail_cl_voucher_pw`, `MMtElection`.`mail_cl_reminder`, `MMtElection`.`register_button`, `MMtElection`.`ticket_button`, `MMtElection`.`report_button`, `MMtElection`.`status` FROM `T_Mt_report` AS `TMtReport` LEFT JOIN `M_Mt_election` AS `MMtElection` ON (`TMtReport`.`moni_id` = `MMtElection`.`id` AND `TMtReport`.`hotel_id` = `MMtElection`.`institution_id` AND `TMtReport`.`member_id` = `MMtElection`.`candidate_id`) WHERE `MMtElection`.`report_upday` >= '2016-09-17' AND `MMtElection`.`report_upday` <= '2016-10-17' ORDER BY md5(concat(now(), `TMtReport`.`moni_id`)) ASC LIMIT 10 0 0 1
13 SELECT `TMaReport`.`moni_id`, `TMaReport`.`hotel_id`, `TMaReport`.`member_id`, `TMaReport`.`contribution_day`, `TMaReport`.`hotel_name`, `TMaReport`.`sta_day`, `TMaReport`.`nickname`, `TMaReport`.`sex`, `TMaReport`.`age`, `TMaReport`.`prefectures`, `TMaReport`.`occupation`, `TMaReport`.`transportation`, `TMaReport`.`theme`, `TMaReport`.`companion_id`, `TMaReport`.`monitor_pic`, `TMaReport`.`moni_comment`, `TMaReport`.`oshi_id`, `TMaReport`.`oshi_pic`, `TMaReport`.`oshi_title`, `TMaReport`.`oshi_memo`, `TMaReport`.`whom_id`, `TMaReport`.`whom_mem`, `TMaReport`.`album1_id`, `TMaReport`.`album1_pic`, `TMaReport`.`album1_mem`, `TMaReport`.`album2_id`, `TMaReport`.`album2_pic`, `TMaReport`.`album2_mem`, `TMaReport`.`album3_id`, `TMaReport`.`album3_pic`, `TMaReport`.`album3_mem`, `TMaReport`.`album4_id`, `TMaReport`.`album4_pic`, `TMaReport`.`album4_mem`, `TMaReport`.`album5_id`, `TMaReport`.`album5_pic`, `TMaReport`.`album5_mem`, `TMaReport`.`album6_id`, `TMaReport`.`album6_pic`, `TMaReport`.`album6_mem`, `TMaReport`.`see1_pic`, `TMaReport`.`see1_name`, `TMaReport`.`see1_access`, `TMaReport`.`see1_from`, `TMaReport`.`see1_mem`, `TMaReport`.`see2_pic`, `TMaReport`.`see2_name`, `TMaReport`.`see2_access`, `TMaReport`.`see2_from`, `TMaReport`.`see2_mem`, `TMaReport`.`see3_pic`, `TMaReport`.`see3_name`, `TMaReport`.`see3_access`, `TMaReport`.`see3_from`, `TMaReport`.`see3_mem`, `TMaReport`.`location_id`, `TMaReport`.`location_god`, `TMaReport`.`location_bad`, `TMaReport`.`reception_id`, `TMaReport`.`reception_god`, `TMaReport`.`reception_bad`, `TMaReport`.`supper_id`, `TMaReport`.`supper_god`, `TMaReport`.`supper_bad`, `TMaReport`.`breakfast_id`, `TMaReport`.`breakfast_god`, `TMaReport`.`breakfast_bad`, `TMaReport`.`room_id`, `TMaReport`.`room_god`, `TMaReport`.`room_bad`, `TMaReport`.`bath_id`, `TMaReport`.`bath_god`, `TMaReport`.`bath_bad`, `TMaReport`.`inside_id`, `TMaReport`.`inside_god`, `TMaReport`.`inside_bad`, `TMaReport`.`others`, `TMaReport`.`seo_description`, `TMaReport`.`evaluation`, `TMaReport`.`seo_title`, `TMaReport`.`seo_keyword`, `MMaElection`.`id`, `MMaElection`.`institution_id`, `MMaElection`.`group_no`, `MMaElection`.`candidate_id`, `MMaElection`.`experience_day`, `MMaElection`.`reg_experience_day`, `MMaElection`.`noof_experience`, `MMaElection`.`report_day`, `MMaElection`.`report_regday`, `MMaElection`.`report_upday`, `MMaElection`.`reserve_id`, `MMaElection`.`reserve_day`, `MMaElection`.`notice_prizewinner`, `MMaElection`.`notice_deadline`, `MMaElection`.`notice_limit_deadline`, `MMaElection`.`notice_process`, `MMaElection`.`notice_rem_decision`, `MMaElection`.`notice_limit_rem_decision`, `MMaElection`.`notice_voucher`, `MMaElection`.`notice_1week`, `MMaElection`.`notice_1day`, `MMaElection`.`notice_gohome`, `MMaElection`.`notice_rem_report`, `MMaElection`.`notice_thankyou`, `MMaElection`.`mail_prizewinner`, `MMaElection`.`mail_process`, `MMaElection`.`mail_rem_decision`, `MMaElection`.`mail_voucher`, `MMaElection`.`mail_1week`, `MMaElection`.`mail_previous`, `MMaElection`.`mail_home`, `MMaElection`.`mail_unsubmitted`, `MMaElection`.`mail_thankyou`, `MMaElection`.`mail_cl_prizewinner`, `MMaElection`.`mail_cl_prizewinner_pw`, `MMaElection`.`mail_cl_voucher`, `MMaElection`.`mail_cl_voucher_pw`, `MMaElection`.`mail_cl_reminder`, `MMaElection`.`register_button`, `MMaElection`.`ticket_button`, `MMaElection`.`report_button`, `MMaElection`.`status` FROM `T_Ma_report` AS `TMaReport` LEFT JOIN `M_Ma_election` AS `MMaElection` ON (`TMaReport`.`moni_id` = `MMaElection`.`id` AND `TMaReport`.`hotel_id` = `MMaElection`.`institution_id` AND `TMaReport`.`member_id` = `MMaElection`.`candidate_id`) WHERE `MMaElection`.`report_upday` >= '2016-09-17' AND `MMaElection`.`report_upday` <= '2016-10-17' ORDER BY md5(concat(now(), `TMaReport`.`moni_id`)) ASC LIMIT 10 1 1 1
14 SELECT `MMiCompanion`.`id`, `MMiCompanion`.`i_name`, `MMiCompanion`.`d_order`, `MMiCompanion`.`del_flag` FROM `M_Mi_companion` AS `MMiCompanion` WHERE `MMiCompanion`.`del_flag` = 0 ORDER BY `MMiCompanion`.`d_order` asc 9 9 0
15 SELECT `MMiOshi`.`id`, `MMiOshi`.`i_name`, `MMiOshi`.`d_order`, `MMiOshi`.`del_flag` FROM `M_Mi_oshi` AS `MMiOshi` WHERE `MMiOshi`.`del_flag` = 0 ORDER BY `MMiOshi`.`d_order` asc 6 6 0
(marche) 7 queries took 5 ms
Nr Query Error Affected Num. rows Took (ms)
1 SELECT `MHotel`.`hotel_id`, `MHotel`.`hotel_attr`, `MHotel`.`corp_attr`, `MHotel`.`corp_name`, `MHotel`.`hotel_name`, `MHotel`.`name_yomi`, `MHotel`.`tel1`, `MHotel`.`tel2`, `MHotel`.`tel3`, `MHotel`.`fax1`, `MHotel`.`fax2`, `MHotel`.`fax3`, `MHotel`.`URL`, `MHotel`.`post1`, `MHotel`.`post2`, `MHotel`.`prefectures`, `MHotel`.`city`, `MHotel`.`adress`, `MHotel`.`building`, `MHotel`.`latitude`, `MHotel`.`longitude`, `MHotel`.`area_code`, `MHotel`.`state_code`, `MHotel`.`local_code`, `MHotel`.`city_code`, `MHotel`.`town_code`, `MHotel`.`del_flag`, `MHotel`.`note`, `MHotel`.`company_name`, `MHotel`.`company_post1`, `MHotel`.`company_post2`, `MHotel`.`company_tel1`, `MHotel`.`company_tel2`, `MHotel`.`company_tel3`, `MHotel`.`company_fax1`, `MHotel`.`company_fax2`, `MHotel`.`company_fax3`, `MHotel`.`company_prefectures`, `MHotel`.`company_municipality`, `MHotel`.`company_town`, `MHotel`.`company_house_number`, `MHotel`.`company_building`, `MHotel`.`company_url`, `MHotel`.`company_fb_url` FROM `M_hotel` AS `MHotel` WHERE `MHotel`.`hotel_id` = 201606290001 AND `MHotel`.`del_flag` = 0 LIMIT 1 1 1 0
2 SELECT `MHotel`.`hotel_id`, `MHotel`.`hotel_attr`, `MHotel`.`corp_attr`, `MHotel`.`corp_name`, `MHotel`.`hotel_name`, `MHotel`.`name_yomi`, `MHotel`.`tel1`, `MHotel`.`tel2`, `MHotel`.`tel3`, `MHotel`.`fax1`, `MHotel`.`fax2`, `MHotel`.`fax3`, `MHotel`.`URL`, `MHotel`.`post1`, `MHotel`.`post2`, `MHotel`.`prefectures`, `MHotel`.`city`, `MHotel`.`adress`, `MHotel`.`building`, `MHotel`.`latitude`, `MHotel`.`longitude`, `MHotel`.`area_code`, `MHotel`.`state_code`, `MHotel`.`local_code`, `MHotel`.`city_code`, `MHotel`.`town_code`, `MHotel`.`del_flag`, `MHotel`.`note`, `MHotel`.`company_name`, `MHotel`.`company_post1`, `MHotel`.`company_post2`, `MHotel`.`company_tel1`, `MHotel`.`company_tel2`, `MHotel`.`company_tel3`, `MHotel`.`company_fax1`, `MHotel`.`company_fax2`, `MHotel`.`company_fax3`, `MHotel`.`company_prefectures`, `MHotel`.`company_municipality`, `MHotel`.`company_town`, `MHotel`.`company_house_number`, `MHotel`.`company_building`, `MHotel`.`company_url`, `MHotel`.`company_fb_url` FROM `M_hotel` AS `MHotel` WHERE `MHotel`.`hotel_id` = 201601280001 AND `MHotel`.`del_flag` = 0 LIMIT 1 1 1 0
3 SELECT `MHotel`.`hotel_id`, `MHotel`.`hotel_attr`, `MHotel`.`corp_attr`, `MHotel`.`corp_name`, `MHotel`.`hotel_name`, `MHotel`.`name_yomi`, `MHotel`.`tel1`, `MHotel`.`tel2`, `MHotel`.`tel3`, `MHotel`.`fax1`, `MHotel`.`fax2`, `MHotel`.`fax3`, `MHotel`.`URL`, `MHotel`.`post1`, `MHotel`.`post2`, `MHotel`.`prefectures`, `MHotel`.`city`, `MHotel`.`adress`, `MHotel`.`building`, `MHotel`.`latitude`, `MHotel`.`longitude`, `MHotel`.`area_code`, `MHotel`.`state_code`, `MHotel`.`local_code`, `MHotel`.`city_code`, `MHotel`.`town_code`, `MHotel`.`del_flag`, `MHotel`.`note`, `MHotel`.`company_name`, `MHotel`.`company_post1`, `MHotel`.`company_post2`, `MHotel`.`company_tel1`, `MHotel`.`company_tel2`, `MHotel`.`company_tel3`, `MHotel`.`company_fax1`, `MHotel`.`company_fax2`, `MHotel`.`company_fax3`, `MHotel`.`company_prefectures`, `MHotel`.`company_municipality`, `MHotel`.`company_town`, `MHotel`.`company_house_number`, `MHotel`.`company_building`, `MHotel`.`company_url`, `MHotel`.`company_fb_url` FROM `M_hotel` AS `MHotel` WHERE `MHotel`.`hotel_id` = 201605230001 AND `MHotel`.`del_flag` = 0 LIMIT 1 1 1 0
4 SELECT `MLeisure`.`leisure_id`, `MLeisure`.`c1_code`, `MLeisure`.`c2_code`, `MLeisure`.`c3_code`, `MLeisure`.`c1_code2`, `MLeisure`.`c2_code2`, `MLeisure`.`c3_code2`, `MLeisure`.`c1_code3`, `MLeisure`.`c2_code3`, `MLeisure`.`c3_code3`, `MLeisure`.`company_id`, `MLeisure`.`leisure_name`, `MLeisure`.`name_yomi`, `MLeisure`.`tel1`, `MLeisure`.`tel2`, `MLeisure`.`tel3`, `MLeisure`.`fax1`, `MLeisure`.`fax2`, `MLeisure`.`fax3`, `MLeisure`.`URL`, `MLeisure`.`mail`, `MLeisure`.`post1`, `MLeisure`.`post2`, `MLeisure`.`prefectures`, `MLeisure`.`municipality`, `MLeisure`.`town`, `MLeisure`.`house_number`, `MLeisure`.`building`, `MLeisure`.`latitude`, `MLeisure`.`longitude`, `MLeisure`.`area_code`, `MLeisure`.`state_code`, `MLeisure`.`local_code`, `MLeisure`.`city_code`, `MLeisure`.`town_code`, `MLeisure`.`recognition`, `MLeisure`.`del_flag`, `MLeisure`.`note`, `MLeisure`.`company_name`, `MLeisure`.`company_post1`, `MLeisure`.`company_post2`, `MLeisure`.`company_tel1`, `MLeisure`.`company_tel2`, `MLeisure`.`company_tel3`, `MLeisure`.`company_fax1`, `MLeisure`.`company_fax2`, `MLeisure`.`company_fax3`, `MLeisure`.`company_prefectures`, `MLeisure`.`company_municipality`, `MLeisure`.`company_town`, `MLeisure`.`company_house_number`, `MLeisure`.`company_building`, `MLeisure`.`company_url`, `MLeisure`.`company_fb_url` FROM `M_leisure` AS `MLeisure` WHERE `MLeisure`.`leisure_id` = 201606280001 AND `MLeisure`.`del_flag` = 0 LIMIT 1 1 1 0
5 SELECT `MState`.`area_code`, `MState`.`state_code`, `MState`.`state_name`, `MState`.`d_order`, `MState`.`del_flag` FROM `M_state` AS `MState` WHERE `MState`.`del_flag` = 0 ORDER BY `MState`.`area_code` asc, `MState`.`d_order` asc 47 47 0
6 SELECT `MArea`.`area_code`, `MArea`.`aria_name`, `MArea`.`d_order`, `MArea`.`del_flag` FROM `M_area` AS `MArea` WHERE `MArea`.`del_flag` = 0 ORDER BY `MArea`.`d_order` asc 12 12 0
7 SELECT `MLocal`.`area_code`, `MLocal`.`stat_code`, `MLocal`.`local_code`, `MLocal`.`local_name`, `MLocal`.`del_flag`, `MArea`.`area_code`, `MArea`.`aria_name`, `MArea`.`d_order`, `MArea`.`del_flag`, `MState`.`area_code`, `MState`.`state_code`, `MState`.`state_name`, `MState`.`d_order`, `MState`.`del_flag` FROM `M_local` AS `MLocal` LEFT JOIN `M_area` AS `MArea` ON (`MLocal`.`area_code` = `MArea`.`area_code`) LEFT JOIN `M_state` AS `MState` ON (`MLocal`.`stat_code` = `MState`.`state_code`) WHERE `MLocal`.`del_flag` = 0 ORDER BY `MLocal`.`area_code` ASC, `MLocal`.`stat_code` ASC, `MLocal`.`local_code` ASC 310 310 5