ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1e9085a5da4: POST https://beta.jinchangxiao.com/vue/analysis/sales-status-counts at 2026-06-02 04:12:53 pm by 221.216.117.119

Performance Profiling

Total processing time: 156 ms; Peak memory: 5.479 MB. Show Profiling Timeline

总计24条数据
TimeDurationCategoryInfo
  
16:12:53.73013.0 msyii\db\Command::querySELECT 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 >= '2026-06-02 00:00:00') AND (start_at < timestamp '2026-06-02 23:59:59' + interval '1 second') AND ("w"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)
16:12:53.75112.4 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND ("ir"."arrived_at" >= '2026-06-02 00:00:00') AND ("ir"."arrived_at" <= '2026-06-02 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', '5332', '5449', '5467', '5476')) AND ("ps"."start_at" >= '2026-06-02 00:00:00') AND ("ps"."start_at" <= '2026-06-02 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"
16:12:53.78611.0 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND ("otc"."complete_at" >= '2026-06-02 00:00:00') AND ("otc"."complete_at" <= '2026-06-02 23:59:59')
16:12:53.8178.4 msyii\db\Command::querySELECT 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" < '2026-06-02 16:12:53' ) ) ) 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', '5332', '5449', '5467', '5476')) AND ("sub"."status" IN (0, 2)) GROUP BY "sub"."status"
16:12:53.8097.3 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND (("w"."start_at" >= '2026-06-02 00:00:00') AND ("w"."start_at" <= '2026-06-02 23:59:59'))
16:12:53.7187.2 msyii\db\Command::querySELECT 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 >= '2026-06-02 00:00:00' AND subpsl.created_at < timestamp '2026-06-02 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', '5332', '5449', '5467', '5476')) AND (sub.min_id is not null and sub.max_id is not null)
16:12:53.7766.8 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND ("c"."closed_at" >= '2026-06-02 00:00:00') AND ("c"."closed_at" <= '2026-06-02 23:59:59')
16:12:53.8036.0 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND (("w"."start_at" >= '2026-06-02 00:00:00') AND ("w"."start_at" <= '2026-06-02 23:59:59')) GROUP BY "w"."scenario_option_id", "wso"."name"
16:12:53.7445.0 msyii\db\Command::querySELECT 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 >= '2026-06-02 00:00:00') AND (start_at < timestamp '2026-06-02 23:59:59' + interval '1 second') AND ("w"."created_by" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)
16:12:53.7073.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:12:53.7643.2 msyii\db\Command::querySELECT 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 (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2026-06-02 00:00:00') AND ("ir"."arrived_at" <= '2026-06-02 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 (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2026-06-02 00:00:00') AND ("ps"."start_at" <= '2026-06-02 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"
16:12:53.7672.3 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND ("ir"."arrived_at" >= '2026-06-02 00:00:00') AND ("ir"."arrived_at" <= '2026-06-02 23:59:59') AND ("ir"."is_draft"=FALSE)
16:12:53.8252.2 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_schedules" WHERE ("created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("is_public"=1) AND ("is_complete"=FALSE)
16:12:53.7702.0 msyii\db\Command::querySELECT 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 (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2026-06-02 00:00:00') AND ("ir"."arrived_at" <= '2026-06-02 23:59:59') AND ("ir"."is_draft"=FALSE)
16:12:53.7831.8 msyii\db\Command::querySELECT 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 (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("c"."closed_at" >= '2026-06-02 00:00:00') AND ("c"."closed_at" <= '2026-06-02 23:59:59')
16:12:53.7721.7 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND ("ps"."start_at" >= '2026-06-02 00:00:00') AND ("ps"."start_at" <= '2026-06-02 23:59:59') AND ("ps"."is_draft"=FALSE)
16:12:53.7971.3 msyii\db\Command::querySELECT 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 (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("otc"."complete_at" >= '2026-06-02 00:00:00') AND ("otc"."complete_at" <= '2026-06-02 23:59:59')
16:12:53.7271.2 msyii\db\Command::querySELECT "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, '[)') && '[2026-06-02 00:00:00, 2026-06-02 23:59:59]'::daterange) AND ("user_id" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5467, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 5476, 1004, 5072, 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
16:12:53.7291.1 msyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-06-02 00:00:00') AND ("bargain_date" <= '2026-06-02 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
16:12:53.8301.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/analysis/sales-status-counts', '{"period":"today","dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5332,5449,5467,5476","alert":"false","web_access_token":"XCAEbWuf3Inx1dER3Vvh_p6Z1GIx614R"}', '{"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":179,"name":"\u8fdb\u884c\u4e2d","y":63.7},{"status":2,"value":102,"name":"\u5df2\u903e\u671f","y":36.3}],"schedulesCounts":281,"statusCounts":[],"projectCounts":0}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 16:12:53', 150341120) RETURNING "id"
16:12:53.7740.9 msyii\db\Command::querySELECT 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 (5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2026-06-02 00:00:00') AND ("ps"."start_at" <= '2026-06-02 23:59:59') AND ("ps"."is_draft"=FALSE)
16:12:53.8280.9 msyii\db\Command::querySELECT 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', '5332', '5449', '5467', '5476')) AND (project_status != 1) AND ("p"."bargain_date" >= '2026-06-02 00:00:00') AND ("p"."bargain_date" <= '2026-06-02 23:59:59')) "sub" GROUP BY "sub"."project_status"
16:12:53.7100.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1011
16:12:53.7130.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011