Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Area`.`id`, `Area`.`url_key` FROM `far1_schedulechat`.`areas` AS `Area` WHERE 1 = 1 GROUP BY `Area`.`url_key` | 63 | 63 | 1 | |
SELECT `Category`.`id`, `Category`.`category_key` FROM `far1_schedulechat`.`categories` AS `Category` WHERE 1 = 1 GROUP BY category_key | 44 | 44 | 1 | |
SELECT COUNT(*) AS `count` FROM `far1_schedulechat`.`report` AS `Report` WHERE `Report`.`report_id` = 595 | 1 | 1 | 0 | |
SELECT `Report`.`report_id`, `Report`.`party_id`, `Report`.`midashi`, `Report`.`image1`, `Report`.`new_image1`, `Report`.`image2`, `Report`.`new_image2`, `Report`.`image3`, `Report`.`new_image3`, `Report`.`report_naiyo`, `Report`.`flag`, `Report`.`image4`, `Report`.`new_image4`, (SELECT `Place`.`kaijo_name` FROM kaijo Place WHERE `Place`.`kaijo_id` = `Party`.`kaijo_id`) AS `Report__kaijo_name`, `Party`.`party_id`, `Party`.`assign_team_id`, `Party`.`disp_m_fee`, `Party`.`disp_f_fee`, `Party`.`pparty`, `Party`.`lup`, `Party`.`club`, `Party`.`home_rich_party`, `Party`.`premium_circle`, `Party`.`celpa`, `Party`.`open_at`, `Party`.`start_at`, `Party`.`end_at`, `Party`.`date`, `Party`.`start_time`, `Party`.`finish_time`, `Party`.`title`, `Party`.`sub_title`, `Party`.`title_for_others`, `Party`.`image`, `Party`.`new_image`, `Party`.`new_image1`, `Party`.`new_image2`, `Party`.`new_image3`, `Party`.`new_image4`, `Party`.`naiyo`, `Party`.`description_for_others`, `Party`.`naiyo_about_payment`, `Party`.`sikaku_male`, `Party`.`sikaku_female`, `Party`.`flag`, `Party`.`is_chat_party`, `Party`.`is_holding`, `Party`.`area`, `Party`.`area_id`, `Party`.`kaijo_id`, `Party`.`party_kubun`, `Party`.`m_fee`, `Party`.`f_fee`, `Party`.`m_early_discount`, `Party`.`f_early_discount`, `Party`.`early_discount_deadline`, `Party`.`use_first_time_discount_rule`, `Party`.`m_first_time_discount`, `Party`.`f_first_time_discount`, `Party`.`use_wdoc_discount_rule`, `Party`.`use_ca_discount_rule`, `Party`.`use_mm_discount_rule`, `Party`.`use_mp_discount_rule`, `Party`.`use_fb_discount_rule`, `Party`.`use_jieitai_discount_rule`, `Party`.`preferential_treatment_slugs`, `Party`.`m_preferential_treatment_discount`, `Party`.`f_preferential_treatment_discount`, `Party`.`use_wp_discount_rule`, `Party`.`pclub`, `Party`.`tparty`, `Party`.`oparty`, `Party`.`nparty`, `Party`.`jclub`, `Party`.`ela`, `Party`.`oz`, `Party`.`pm`, `Party`.`m_age`, `Party`.`f_age`, `Party`.`ages_male`, `Party`.`ages_female`, `Party`.`cancel_pattern`, `Party`.`cancel_text`, `Party`.`party_style`, `Party`.`dress`, `Party`.`m_dress`, `Party`.`f_dress`, `Party`.`shinko`, `Party`.`inshoku`, `Party`.`capacity_text`, `Party`.`enshutsu`, `Party`.`vip`, `Party`.`smoking`, `Party`.`baggege`, `Party`.`cancel_kitei`, `Party`.`point_service`, `Party`.`point_service_for_omikare`, `Party`.`agreement`, `Party`.`others`, `Party`.`shikaku_kubun`, `Party`.`foreign_reservation_url`, `Party`.`top_page`, `Party`.`is_integrate_omikare`, `Party`.`is_stop_accept_male`, `Party`.`is_stop_accept_female`, `Party`.`is_omikare_executive`, `Party`.`is_show_all_area`, `Party`.`is_payment_in_advance`, `Party`.`is_payment_only_cash`, `Party`.`is_payment_only_credit`, `Party`.`is_qr_reception`, `Party`.`is_recommend_male`, `Party`.`is_recommend_female`, `Party`.`yusen`, `Party`.`admin_comment`, `Party`.`is_no_staff`, `Party`.`gathering_at`, `Party`.`dismiss_at`, `Party`.`admin_shift_comment`, `Party`.`is_integrate_ad`, `Party`.`title_for_ad`, `Party`.`image_path_for_ad`, `Party`.`description_for_ad`, `Party`.`party_number_tag`, `Party`.`party_style_tag`, `Party`.`panel_tag`, `Party`.`omikare_title`, `Party`.`omikare_image`, `Party`.`omikare_requirement_man`, `Party`.`omikare_requirement_woman`, `Party`.`omikare_time_table_template_id`, `Party`.`omikare_description_template_party_parts1_id`, `Party`.`omikare_description_template_party_parts2_id`, `Party`.`omikare_description_template_party_parts3_id`, `Party`.`omikare_description_template_party_parts4_id`, `Party`.`omikare_description_template_party_parts5_id`, `Party`.`omikare_description_template_party_parts6_id`, `Party`.`omikare_description_template_party_parts7_id`, `Party`.`omikare_flag_exective`, `Party`.`omikare_flag_tour`, `Party`.`omikare_flag_maticon`, `Party`.`omikare_flag_shumi`, `Party`.`omikare_flag_private`, `Party`.`omikare_flag_online`, `Party`.`omikare_flag_seminar`, `Party`.`omikare_flag_solo`, `Party`.`omikare_flag_civil_servant`, `Party`.`omikare_flag_food`, `Party`.`omikare_flag_activity`, `Party`.`omikare_recruitment_status`, `Party`.`omikare_recruitment_status_input_count1`, `Party`.`omikare_recruitment_status_input_count2`, `Party`.`omikare_party_held`, `Party`.`is_male_photo_screening`, `Party`.`is_female_photo_screening`, `Party`.`created`, `Party`.`modified`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` IN (0,1) AND `Reservation`.`sex` = "m") AS `Party__male_reserver_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` IN (0,1) AND `Reservation`.`sex` = "f") AS `Party__female_reserver_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` = 6 AND `Reservation`.`sex` = "m") AS `Party__male_reviewing_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` = 6 AND `Reservation`.`sex` = "f") AS `Party__female_reviewing_count` FROM `far1_schedulechat`.`report` AS `Report` LEFT JOIN `far1_schedulechat`.`party` AS `Party` ON (`Report`.`party_id` = `Party`.`party_id`) WHERE `Report`.`report_id` = 595 LIMIT 1 | 1 | 1 | 3 | maybe slow |
SELECT `Report`.`report_id`, `Report`.`party_id`, `Report`.`midashi`, `Report`.`image1`, `Report`.`new_image1`, `Report`.`image2`, `Report`.`new_image2`, `Report`.`image3`, `Report`.`new_image3`, `Report`.`report_naiyo`, `Report`.`flag`, `Report`.`image4`, `Report`.`new_image4`, (SELECT `Place`.`kaijo_name` FROM kaijo Place WHERE `Place`.`kaijo_id` = `Party`.`kaijo_id`) AS `Report__kaijo_name`, `Party`.`party_id`, `Party`.`assign_team_id`, `Party`.`disp_m_fee`, `Party`.`disp_f_fee`, `Party`.`pparty`, `Party`.`lup`, `Party`.`club`, `Party`.`home_rich_party`, `Party`.`premium_circle`, `Party`.`celpa`, `Party`.`open_at`, `Party`.`start_at`, `Party`.`end_at`, `Party`.`date`, `Party`.`start_time`, `Party`.`finish_time`, `Party`.`title`, `Party`.`sub_title`, `Party`.`title_for_others`, `Party`.`image`, `Party`.`new_image`, `Party`.`new_image1`, `Party`.`new_image2`, `Party`.`new_image3`, `Party`.`new_image4`, `Party`.`naiyo`, `Party`.`description_for_others`, `Party`.`naiyo_about_payment`, `Party`.`sikaku_male`, `Party`.`sikaku_female`, `Party`.`flag`, `Party`.`is_chat_party`, `Party`.`is_holding`, `Party`.`area`, `Party`.`area_id`, `Party`.`kaijo_id`, `Party`.`party_kubun`, `Party`.`m_fee`, `Party`.`f_fee`, `Party`.`m_early_discount`, `Party`.`f_early_discount`, `Party`.`early_discount_deadline`, `Party`.`use_first_time_discount_rule`, `Party`.`m_first_time_discount`, `Party`.`f_first_time_discount`, `Party`.`use_wdoc_discount_rule`, `Party`.`use_ca_discount_rule`, `Party`.`use_mm_discount_rule`, `Party`.`use_mp_discount_rule`, `Party`.`use_fb_discount_rule`, `Party`.`use_jieitai_discount_rule`, `Party`.`preferential_treatment_slugs`, `Party`.`m_preferential_treatment_discount`, `Party`.`f_preferential_treatment_discount`, `Party`.`use_wp_discount_rule`, `Party`.`pclub`, `Party`.`tparty`, `Party`.`oparty`, `Party`.`nparty`, `Party`.`jclub`, `Party`.`ela`, `Party`.`oz`, `Party`.`pm`, `Party`.`m_age`, `Party`.`f_age`, `Party`.`ages_male`, `Party`.`ages_female`, `Party`.`cancel_pattern`, `Party`.`cancel_text`, `Party`.`party_style`, `Party`.`dress`, `Party`.`m_dress`, `Party`.`f_dress`, `Party`.`shinko`, `Party`.`inshoku`, `Party`.`capacity_text`, `Party`.`enshutsu`, `Party`.`vip`, `Party`.`smoking`, `Party`.`baggege`, `Party`.`cancel_kitei`, `Party`.`point_service`, `Party`.`point_service_for_omikare`, `Party`.`agreement`, `Party`.`others`, `Party`.`shikaku_kubun`, `Party`.`foreign_reservation_url`, `Party`.`top_page`, `Party`.`is_integrate_omikare`, `Party`.`is_stop_accept_male`, `Party`.`is_stop_accept_female`, `Party`.`is_omikare_executive`, `Party`.`is_show_all_area`, `Party`.`is_payment_in_advance`, `Party`.`is_payment_only_cash`, `Party`.`is_payment_only_credit`, `Party`.`is_qr_reception`, `Party`.`is_recommend_male`, `Party`.`is_recommend_female`, `Party`.`yusen`, `Party`.`admin_comment`, `Party`.`is_no_staff`, `Party`.`gathering_at`, `Party`.`dismiss_at`, `Party`.`admin_shift_comment`, `Party`.`is_integrate_ad`, `Party`.`title_for_ad`, `Party`.`image_path_for_ad`, `Party`.`description_for_ad`, `Party`.`party_number_tag`, `Party`.`party_style_tag`, `Party`.`panel_tag`, `Party`.`omikare_title`, `Party`.`omikare_image`, `Party`.`omikare_requirement_man`, `Party`.`omikare_requirement_woman`, `Party`.`omikare_time_table_template_id`, `Party`.`omikare_description_template_party_parts1_id`, `Party`.`omikare_description_template_party_parts2_id`, `Party`.`omikare_description_template_party_parts3_id`, `Party`.`omikare_description_template_party_parts4_id`, `Party`.`omikare_description_template_party_parts5_id`, `Party`.`omikare_description_template_party_parts6_id`, `Party`.`omikare_description_template_party_parts7_id`, `Party`.`omikare_flag_exective`, `Party`.`omikare_flag_tour`, `Party`.`omikare_flag_maticon`, `Party`.`omikare_flag_shumi`, `Party`.`omikare_flag_private`, `Party`.`omikare_flag_online`, `Party`.`omikare_flag_seminar`, `Party`.`omikare_flag_solo`, `Party`.`omikare_flag_civil_servant`, `Party`.`omikare_flag_food`, `Party`.`omikare_flag_activity`, `Party`.`omikare_recruitment_status`, `Party`.`omikare_recruitment_status_input_count1`, `Party`.`omikare_recruitment_status_input_count2`, `Party`.`omikare_party_held`, `Party`.`is_male_photo_screening`, `Party`.`is_female_photo_screening`, `Party`.`created`, `Party`.`modified`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` IN (0,1) AND `Reservation`.`sex` = "m") AS `Party__male_reserver_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` IN (0,1) AND `Reservation`.`sex` = "f") AS `Party__female_reserver_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` = 6 AND `Reservation`.`sex` = "m") AS `Party__male_reviewing_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` = 6 AND `Reservation`.`sex` = "f") AS `Party__female_reviewing_count` FROM `far1_schedulechat`.`report` AS `Report` LEFT JOIN `far1_schedulechat`.`party` AS `Party` ON (`Report`.`party_id` = `Party`.`party_id`) WHERE `Report`.`flag` = 1 ORDER BY `Party`.`date` desc LIMIT 5 | 5 | 5 | 267 | maybe slow |