ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6865d49941079: POST https://beta.jinchangxiao.com/vue/analysis/sales-status-counts at 2025-07-03 08:53:45 am by 115.171.251.24

Database Queries

总计25条数据
TimeDurationTypeQuery
  
08:53:45.2712.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5016

[+] Explain
08:53:45.2801.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016

[+] Explain
08:53:45.28610.2 msSELECTSELECT sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then 1 else 0 end) count1new, sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then p.budget else 0 end) count1newsum, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then 1 else 0 end) count1in, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then p.budget else 0 end) count1insum, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then 1 else 0 end) count1out, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then p.budget else 0 end) count1outsum, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then 1 else 0 end) count2new, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then p.budget else 0 end) count2newsum, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then 1 else 0 end) count2in, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then p.budget else 0 end) count2insum, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then 1 else 0 end) count2out, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then p.budget else 0 end) count2outsum, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then 1 else 0 end) count3new, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then p.budget else 0 end) count3newsum, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then 1 else 0 end) count3in, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then p.budget else 0 end) count3insum, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then 1 else 0 end) count3out, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then p.budget else 0 end) count3outsum, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then 1 else 0 end) count4new, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then p.budget else 0 end) count4newsum, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then 1 else 0 end) count4in, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then p.budget else 0 end) count4insum, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then 1 else 0 end) count4out, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then p.budget else 0 end) count4outsum, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then 1 else 0 end) count5new, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then p.budget else 0 end) count5newsum, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then 1 else 0 end) count5in, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then p.budget else 0 end) count5insum, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then 1 else 0 end) count5out, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then p.budget else 0 end) count5outsum, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then 1 else 0 end) count0new, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then p.budget else 0 end) count0newsum, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then 1 else 0 end) count0in, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then p.budget else 0 end) count0insum, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then 1 else 0 end) count0out, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then p.budget else 0 end) count0outsum FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT min(subpsl.id) AS min_id, max(subpsl.id) AS max_id, project_id FROM "a57be577deb434"."tbl_project_status_logs" "subpsl" WHERE subpsl.created_at >= '2025-07-03 00:00:00' AND subpsl.created_at < timestamp '2025-07-03 23:59:59' + interval '1 second' GROUP BY "subpsl"."project_id") "sub" ON sub.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "minpsl" ON sub.min_id = minpsl.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "maxpsl" ON sub.max_id = maxpsl.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (sub.min_id is not null and sub.max_id is not null)

[+] Explain
08:53:45.3012.0 msSELECTSELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (daterange(start_from::date, end_at::date, '[)') && '[2025-07-03 00:00:00, 2025-07-03 23:59:59]'::daterange) AND ("user_id" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first

[+] Explain
08:53:45.3041.3 msSELECTSELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2025-07-03 00:00:00') AND ("bargain_date" <= '2025-07-03 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) GROUP BY "created_by"

[+] Explain
08:53:45.30611.0 msSELECTSELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-07-03 00:00:00') AND (start_at < timestamp '2025-07-03 23:59:59' + interval '1 second') AND ("w"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)

[+] Explain
08:53:45.3175.2 msSELECTSELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-07-03 00:00:00') AND (start_at < timestamp '2025-07-03 23:59:59' + interval '1 second') AND ("w"."created_by" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)

[+] Explain
08:53:45.33822.8 msSELECTSELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("ir"."arrived_at" >= '2025-07-03 00:00:00') AND ("ir"."arrived_at" <= '2025-07-03 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("ps"."start_at" >= '2025-07-03 00:00:00') AND ("ps"."start_at" <= '2025-07-03 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"

[+] Explain
08:53:45.3623.0 msSELECTSELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) AND ("ir"."arrived_at" >= '2025-07-03 00:00:00') AND ("ir"."arrived_at" <= '2025-07-03 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) AND ("ps"."start_at" >= '2025-07-03 00:00:00') AND ("ps"."start_at" <= '2025-07-03 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"

[+] Explain
08:53:45.3673.7 msSELECTSELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("ir"."arrived_at" >= '2025-07-03 00:00:00') AND ("ir"."arrived_at" <= '2025-07-03 23:59:59') AND ("ir"."is_draft"=FALSE)

[+] Explain
08:53:45.3711.3 msSELECTSELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) AND ("ir"."arrived_at" >= '2025-07-03 00:00:00') AND ("ir"."arrived_at" <= '2025-07-03 23:59:59') AND ("ir"."is_draft"=FALSE)

[+] Explain
08:53:45.3741.9 msSELECTSELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("ps"."start_at" >= '2025-07-03 00:00:00') AND ("ps"."start_at" <= '2025-07-03 23:59:59') AND ("ps"."is_draft"=FALSE)

[+] Explain
08:53:45.3760.7 msSELECTSELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) AND ("ps"."start_at" >= '2025-07-03 00:00:00') AND ("ps"."start_at" <= '2025-07-03 23:59:59') AND ("ps"."is_draft"=FALSE)

[+] Explain
08:53:45.3838.2 msSELECTSELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("c"."closed_at" >= '2025-07-03 00:00:00') AND ("c"."closed_at" <= '2025-07-03 23:59:59')

[+] Explain
08:53:45.3911.8 msSELECTSELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) AND ("c"."closed_at" >= '2025-07-03 00:00:00') AND ("c"."closed_at" <= '2025-07-03 23:59:59')

[+] Explain
08:53:45.39513.5 msSELECTSELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE ("ot"."head_of" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("otc"."complete_at" >= '2025-07-03 00:00:00') AND ("otc"."complete_at" <= '2025-07-03 23:59:59')

[+] Explain
08:53:45.4091.6 msSELECTSELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE ("ot"."head_of" IN (5329, 5332, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005)) AND ("otc"."complete_at" >= '2025-07-03 00:00:00') AND ("otc"."complete_at" <= '2025-07-03 23:59:59')

[+] Explain
08:53:45.4117.6 msSELECTSELECT w.scenario_option_id as key, wso.name, count(w.id) as value FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wso" ON w.scenario_option_id = wso.id WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND ("w"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (("w"."start_at" >= '2025-07-03 00:00:00') AND ("w"."start_at" <= '2025-07-03 23:59:59')) GROUP BY "w"."scenario_option_id", "wso"."name"

[+] Explain
08:53:45.4194.7 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND ("w"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (("w"."start_at" >= '2025-07-03 00:00:00') AND ("w"."start_at" <= '2025-07-03 23:59:59'))

[+] Explain
08:53:45.42412.9 msSELECTSELECT sub.status, count(sub.id) as value FROM (SELECT id, created_by, CASE WHEN complete_at IS NOT NULL THEN complete_at ELSE end_at END as day_at, CASE WHEN is_complete = TRUE THEN 1 WHEN ( ( ( "is_complete" = FALSE ) AND ( "end_at" < '2025-07-03 08:53:45' ) ) ) THEN 2 ELSE 0 END as status FROM "a57be577deb434"."tbl_schedules" WHERE "is_public"=1) "sub" WHERE ("sub"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("sub"."status" IN (0, 2)) GROUP BY "sub"."status"

[+] Explain
08:53:45.4382.4 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_schedules" WHERE ("created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("is_public"=1) AND ("is_complete"=FALSE)

[+] Explain
08:53:45.4411.1 msSELECTSELECT sub.project_status as key, count('sub.id') as projects FROM (SELECT p.id, p.project_status FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (project_status != 1) AND ("p"."bargain_date" >= '2025-07-03 00:00:00') AND ("p"."bargain_date" <= '2025-07-03 23:59:59')) "sub" GROUP BY "sub"."project_status"

[+] Explain
08:53:45.4456.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=23) AND ("visit_date"='2025-07-03')

[+] Explain
08:53:45.4520.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=3, "last_visit_at"='now()' WHERE "id"=49771

[+] Explain
08:53:45.4531.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/analysis/sales-status-counts', '{"period":"today","dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420","alert":"false","web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"code":2000,"result":{"statusCounts":[{"id":"1","key":"\u9690\u6027\u9700\u6c42","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"2","key":"\u660e\u786e\u9700\u6c42","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"3","key":"\u5546\u673a\u6210\u4ea4","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"0","key":"\u6536\u6b3e\u5b8c\u6210","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"4","key":"\u5546\u673a\u5931\u8d25","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"5","key":"\u5546\u673a\u6401\u7f6e","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}}],"workCount":{"workTimeList":{"sum":0,"avg":0},"clientVisitList":{"sum":0,"avg":0},"engineerSpentList":{"sum":0,"avg":0},"implementTimes":{"sum":0,"avg":0},"preSalesTimes":{"sum":0,"avg":0},"deductedPoint":{"sum":0,"avg":0},"operationDatas":{"sum":0,"avg":0}},"chart":{"salesTimes":[],"salesTimesCounts":0,"schedules":[{"status":0,"value":151,"name":"\u8fdb\u884c\u4e2d","y":56.77},{"status":2,"value":115,"name":"\u5df2\u903e\u671f","y":43.23}],"schedulesCounts":266,"statusCounts":[],"projectCounts":0}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 08:53:45') RETURNING "id"

[+] Explain