Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT "MtBillingData"."id" AS "MtBillingData__id" FROM "public"."mt_billing_datas" AS "MtBillingData" WHERE "user_id" IS NULL AND "effect_flg" = '0' GROUP BY "MtBillingData"."id" | 0 | 0 | 0 | |
select distinct to_char(use_date, 'YYYY/MM/01') as month From view_booking_all_datas where use_date between current_date + cast('-13 month' as INTERVAL) and current_date + cast('2 years' as INTERVAL) order by to_char(use_date, 'YYYY/MM/01') | 27 | 27 | 2602 | maybe slow |
SELECT kaijo_cd FROM conditions_kaijo_setting_datas WHERE key_word = '体育館' | 1 | 1 | 0 | |
SELECT kaijo_cd FROM conditions_kaijo_setting_datas WHERE kaijo_type = '2' AND kaijo_type_detail = '2' AND key_word = 'A' | 1 | 1 | 0 | |
SELECT kaijo_cd FROM conditions_kaijo_setting_datas WHERE kaijo_type = '2' AND kaijo_type_detail = '2' AND key_word = 'B' | 1 | 1 | 0 | |
SELECT kaijo_cd FROM conditions_kaijo_setting_datas WHERE key_word = 'トレーニング' | 1 | 1 | 0 | |
SELECT kaijo_cd FROM conditions_kaijo_setting_datas WHERE kaijo_type = '2' AND kaijo_type_detail = '2' AND kaijo_count = '2' | 1 | 1 | 0 | |
SELECT kaijo_cd FROM conditions_kaijo_setting_datas WHERE kaijo_type = '2' AND kaijo_type_detail = '2' AND key_word = 'A' AND kaijo_count = '1' | 1 | 1 | 0 | |
SELECT kaijo_cd FROM conditions_kaijo_setting_datas WHERE kaijo_type = '2' AND kaijo_type_detail = '2' AND key_word = 'B' AND kaijo_count = '1' | 1 | 1 | 0 | |
SELECT "MtVenueData"."id" AS "MtVenueData__id", "MtVenueData"."kaijo_cd" AS "MtVenueData__kaijo_cd", "MtVenueData"."kaijo_nm" AS "MtVenueData__kaijo_nm", "MtVenueData"."area" AS "MtVenueData__area", "MtVenueData"."capacity" AS "MtVenueData__capacity", "MtVenueData"."kaijo_type" AS "MtVenueData__kaijo_type", "MtVenueData"."student_flg" AS "MtVenueData__student_flg", "MtVenueData"."split_flg" AS "MtVenueData__split_flg", "MtVenueData"."original_cd" AS "MtVenueData__original_cd", "MtVenueData"."order_no" AS "MtVenueData__order_no", "MtVenueData"."manage_only_flg" AS "MtVenueData__manage_only_flg", "MtVenueData"."regist_user" AS "MtVenueData__regist_user", "MtVenueData"."regist_time" AS "MtVenueData__regist_time", "MtVenueData"."update_user" AS "MtVenueData__update_user", "MtVenueData"."update_time" AS "MtVenueData__update_time" FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE 1 = 1 ORDER BY "MtVenueData"."order_no" ASC | 12 | 12 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '001' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '002' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '003' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '004' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '005' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '006' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '007' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '008' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '009' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '010' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '011' LIMIT 1 | 1 | 1 | 0 | |
SELECT count(*) FROM "public"."mt_venue_datas" AS "MtVenueData" WHERE "original_cd" = '012' LIMIT 1 | 1 | 1 | 0 | |
SELECT "ViewBookingData"."id" AS "ViewBookingData__id", "ViewBookingData"."booking_no" AS "ViewBookingData__booking_no", "ViewBookingData"."user_id" AS "ViewBookingData__user_id", "ViewBookingData"."user_nm" AS "ViewBookingData__user_nm", "ViewBookingData"."comp_nm" AS "ViewBookingData__comp_nm", "ViewBookingData"."busyo" AS "ViewBookingData__busyo", "ViewBookingData"."addno" AS "ViewBookingData__addno", "ViewBookingData"."add" AS "ViewBookingData__add", "ViewBookingData"."member_flg" AS "ViewBookingData__member_flg", "ViewBookingData"."request_date" AS "ViewBookingData__request_date", "ViewBookingData"."use_purpose" AS "ViewBookingData__use_purpose", "ViewBookingData"."mokuteki" AS "ViewBookingData__mokuteki", "ViewBookingData"."guide_plate" AS "ViewBookingData__guide_plate", "ViewBookingData"."use_type" AS "ViewBookingData__use_type", "ViewBookingData"."use_purpose_other" AS "ViewBookingData__use_purpose_other", "ViewBookingData"."event_content" AS "ViewBookingData__event_content", "ViewBookingData"."open_disp" AS "ViewBookingData__open_disp", "ViewBookingData"."open_flg" AS "ViewBookingData__open_flg", "ViewBookingData"."meeting_number" AS "ViewBookingData__meeting_number", "ViewBookingData"."visitor_number" AS "ViewBookingData__visitor_number", "ViewBookingData"."parking_number" AS "ViewBookingData__parking_number", "ViewBookingData"."payment" AS "ViewBookingData__payment", "ViewBookingData"."contact" AS "ViewBookingData__contact", "ViewBookingData"."note" AS "ViewBookingData__note", "ViewBookingData"."billing_cd" AS "ViewBookingData__billing_cd", "ViewBookingData"."billing_date" AS "ViewBookingData__billing_date", "ViewBookingData"."billing_no" AS "ViewBookingData__billing_no", "ViewBookingData"."payment_plan_date" AS "ViewBookingData__payment_plan_date", "ViewBookingData"."payment_date" AS "ViewBookingData__payment_date", "ViewBookingData"."status" AS "ViewBookingData__status", "ViewBookingData"."approval_flg" AS "ViewBookingData__approval_flg", "ViewBookingData"."cancel_flg" AS "ViewBookingData__cancel_flg", "ViewBookingData"."use_date" AS "ViewBookingData__use_date", "ViewBookingData"."kaijo_cd" AS "ViewBookingData__kaijo_cd", "ViewBookingData"."kaijo_nm" AS "ViewBookingData__kaijo_nm", "ViewBookingData"."kaijo_order_no" AS "ViewBookingData__kaijo_order_no", "ViewBookingData"."use_kbn" AS "ViewBookingData__use_kbn", "ViewBookingData"."start_time" AS "ViewBookingData__start_time", "ViewBookingData"."end_time" AS "ViewBookingData__end_time", "ViewBookingData"."setting" AS "ViewBookingData__setting", "ViewBookingData"."cleaning" AS "ViewBookingData__cleaning", "ViewBookingData"."time_between" AS "ViewBookingData__time_between", "ViewBookingData"."dt_ryokin" AS "ViewBookingData__dt_ryokin", "ViewBookingData"."dt_ryokin_tax" AS "ViewBookingData__dt_ryokin_tax", "ViewBookingData"."ryokin" AS "ViewBookingData__ryokin", "ViewBookingData"."ryokin_tax" AS "ViewBookingData__ryokin_tax", "ViewBookingData"."cancel_date" AS "ViewBookingData__cancel_date", "ViewBookingData"."cancel_ryokin" AS "ViewBookingData__cancel_ryokin", "ViewBookingData"."cancel_ryokin_tax" AS "ViewBookingData__cancel_ryokin_tax", "ViewBookingData"."dt_cancel_ryokin" AS "ViewBookingData__dt_cancel_ryokin", "ViewBookingData"."dt_cancel_ryokin_tax" AS "ViewBookingData__dt_cancel_ryokin_tax", "ViewBookingData"."parent_booking_no" AS "ViewBookingData__parent_booking_no", "ViewBookingData"."update_user" AS "ViewBookingData__update_user", "ViewBookingData"."update_time" AS "ViewBookingData__update_time" FROM "public"."view_booking_datas" AS "ViewBookingData" WHERE "ViewBookingData"."kaijo_cd" IN ('001', '011', '012') AND "ViewBookingData"."cancel_flg" = '0' AND "ViewBookingData"."use_date" >= '2023/09/26' AND "ViewBookingData"."use_date" <= '2023/09/30' ORDER BY "ViewBookingData"."use_date" ASC, "ViewBookingData"."start_time" ASC, "ViewBookingData"."end_time" ASC, "ViewBookingData"."kaijo_cd" ASC | 34 | 34 | 378 | maybe slow |
SELECT "MtAvailableData"."kaijo_cd" AS "MtAvailableData__kaijo_cd", "MtAvailableData"."busi_date" AS "MtAvailableData__busi_date", TO_CHAR(start_time, 'HH24:MI') as time__start_time, TO_CHAR(end_time, 'HH24:MI') as time__end_time, "MtAvailableData"."busi_flg" AS "MtAvailableData__busi_flg" FROM "public"."mt_available_datas" AS "MtAvailableData" WHERE "kaijo_cd" IN ('001', '011', '012', '000') AND "busi_date" >= '2023/09/26' AND "busi_date" <= '2023/09/30' ORDER BY "busi_date" ASC, "start_time" ASC | 0 | 0 | 1 | maybe slow |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032425'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032442'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032822'; | 1 | 1 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032601'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032578'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032564'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032595'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032426'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032443'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032765'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000030221'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032427'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032444'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000030841'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000030307'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032704'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032755'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000030304'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032412'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032429'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000031465'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032823'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000031102'; | 0 | 0 | 0 | |
SELECT booking_no , receipt_flg FROM request_receipt_datas WHERE booking_no = '0000032088'; | 0 | 0 | 0 | |