ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a21337653fb1: POST https://beta.jinchangxiao.com/vue/analysis/filter-clients at 2026-06-04 04:12:38 pm by 221.216.117.119

Performance Profiling

Total processing time: 40 ms; Peak memory: 5.387 MB. Show Profiling Timeline

总计16条数据
TimeDurationCategoryInfo
  
16:12:38.3648.2 msyii\db\Command::querySELECT "eg"."id", "eg"."id" AS "key", "eg"."name" FROM "a57be577deb434"."tbl_engineer_groups" "eg" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_group_id = eg.id WHERE "egr"."engineer_id" IN (5085, 5248, 1015, 1022, 5064, 1023) GROUP BY "eg"."id" ORDER BY "sort"
16:12:38.3763.9 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', 1001, 5, 'vue/analysis/filter-clients', '{"web_access_token":"-ooNs73DKJQ01PCpcbuHx_usnaO5SdwJ"}', '{"code":2000,"result":{"filter":[{"key":"client_type_id","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},{"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},{"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},{"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"}],"default":""},{"key":"client_industry_id","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":57,"name":"EDA\/CAE"},{"key":1,"name":"\u653f\u5e9c"},{"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},{"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"},{"key":24,"name":"\u6559\u80b2\uff08\u666e\u6559\uff09"},{"key":3,"name":"\u533b\u7597"},{"key":4,"name":"\u901a\u4fe1"},{"key":5,"name":"\u5236\u9020"},{"key":58,"name":"\u519b\u5de5"},{"key":6,"name":"\u7535\u5546"},{"key":7,"name":"\u9152\u5e97"},{"key":8,"name":"\u7269\u6d41"},{"key":9,"name":"\u5730\u4ea7"},{"key":10,"name":"\u91d1\u878d"},{"key":11,"name":"\u4ea4\u901a"},{"key":12,"name":"\u5e7f\u544a"},{"key":13,"name":"SI\/ISV"},{"key":14,"name":"\u5e7f\u7535"},{"key":15,"name":"\u7535\u529b"},{"key":16,"name":"\u80fd\u6e90"},{"key":17,"name":"\u96f6\u552e"},{"key":18,"name":"\u5a92\u4f53"},{"key":19,"name":"OTT"},{"key":20,"name":"\u5176\u4ed6"},{"key":59,"name":"\u8d38\u6613"}],"default":""},{"key":"cooperated","name":"\u5408\u4f5c\u72b6\u6001","value":[{"key":"1","name":"\u5df2\u5408\u4f5c"},{"key":"0","name":"\u672a\u5408\u4f5c"}],"default":""},{"key":"group","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"id":80,"key":80,"name":"\u5408\u4f19\u4eba","child":[{"id":5087,"key":5087,"name":"\u5218\u5fae","user_status":"1"},{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","user_status":"1"},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","user_status":"1"},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","user_status":"1"}]},{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","user_status":"1"},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","user_status":"1"},{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","user_status":"1"},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","user_status":"1"}]},{"id":81,"key":81,"name":"\u4f0a\u5cfb\u8fb0\u7ec4","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","user_status":"1"}]},{"id":83,"key":83,"name":"\u91d1\u7545\u900d","child":[{"id":5476,"key":5476,"name":"\u6768\u5dcd","user_status":"1"}]},{"key":0,"name":"\u516c\u6d77\u5ba2\u6237"}],"default":1001,"itemKey":"sales_rep"},{"custom":"1","key":"period","name":"\u65f6\u95f4","value":[{"key":"fascal2027","name":"2027\u8d22\u5e74"},{"key":"fascal2026","name":"2026\u8d22\u5e74"},{"key":"fascal2025","name":"2025\u8d22\u5e74"},{"key":"fascal2024","name":"2024\u8d22\u5e74"},{"key":"fascal2023","name":"2023\u8d22\u5e74"},{"key":"fascal2022","name":"2022\u8d22\u5e74"},{"key":"fascal2021","name":"2021\u8d22\u5e74"},{"key":"fascal2020","name":"2020\u8d22\u5e74"},{"key":"fascal2019","name":"2019\u8d22\u5e74"},{"key":"fascal2018","name":"2018\u8d22\u5e74"},{"key":"fascal2017","name":"2017\u8d22\u5e74"},{"key":"custom","name":"\u81ea\u5b9a\u4e49"}],"default":""},{"key":"engineer_group","name":"\u5de5\u7a0b\u5e08","value":[{"id":1,"key":1,"name":"\u5168\u4f53","child":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","user_status":"1"},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","user_status":"1"},{"id":1015,"key":1015,"name":"\u5434\u660a","user_status":"1"},{"id":1022,"key":1022,"name":"\u5f90\u7855","user_status":"1"},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","user_status":"1"},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","user_status":"1"}]}],"default":"","itemKey":"engineer"},{"key":"Filter[name]","name":"\u65f6\u95f4\u6392\u5e8f","value":[{"key":"sales_rep_time","name":"\u62e5\u6709\u65f6\u957f"},{"key":"cooperated","name":"\u5408\u4f5c\u72b6\u6001"},{"key":"work_time","name":"\u62dc\u8bbf\u5ba2\u6237\u7528\u65f6"},{"key":"work_count","name":"\u62dc\u8bbf\u5ba2\u6237\u6b21\u6570"},{"key":"status3_budgets","name":"\u603b\u6210\u4ea4\u989d"},{"key":"status3_profits","name":"\u603b\u5229\u6da6"},{"key":"status3_pct","name":"\u5229\u6da6\u7387"},{"key":"status3_count","name":"\u6210\u4ea4\u7b14\u6570"},{"key":"status1_count","name":"\u9690\u6027\u9700\u6c42"},{"key":"status2_count","name":"\u660e\u786e\u9700\u6c42"},{"key":"service_time","name":"\u6d88\u8017\u6280\u672f\u5de5\u65f6"},{"key":"service_count","name":"\u6280\u672f\u670d\u52a1\u6b21\u6570"},{"key":"points","name":"\u6d88\u8017\u5de5\u5206"},{"key":"reimbursement_amount","name":"\u8d39\u7528\u62a5\u9500"},{"key":"last_bargain_date","name":"\u6700\u8fd1\u6210\u4ea4\u65e5\u671f"},{"key":"score","name":"\u5ba2\u6237\u4e25\u503c"}]},{"key":"Filter[sort]","name":"\u6392\u5e8f\u65b9\u5f0f","value":[{"key":"ASC","name":"\u6b63\u5e8f"},{"key":"DESC","name":"\u5012\u5e8f"}],"default":""}]},"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-04 16:12:38', 31909888) RETURNING "id"
16:12:38.3611.1 msyii\db\Command::querySELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects"
16:12:38.3581.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "user_status" FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("user_status"='1') AND ("id" IN (5295, 5300, 5087, 5332, 1013, 5311, 1005, 5476, 5064, 1001, 1004)) 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:38.3621.0 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"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-06-04 16:12:38, 2026-06-04 16:12:38]'::tsrange) 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:38.3731.0 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"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-06-04 16:12:38, 2026-06-04 16:12:38]'::tsrange) 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:38.3561.0 msyii\db\Command::querySELECT "g"."id", "g"."id" AS "key", "g"."name" FROM "a57be577deb434"."tbl_groups" "g" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.group_id = g.id WHERE ("sgr"."sales_id" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (g.id != 999999) GROUP BY "g"."id" ORDER BY "sort"
16:12:38.3460.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:12:38.3520.7 msyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "is_delete"=FALSE ORDER BY "order"
16:12:38.3600.6 msyii\db\Command::querySELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
16:12:38.3750.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "user_status" FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (5085, 5248, 1015, 1022, 5064, 1023)) AND ("user_status"='1') AND ("id" IN (1022, 1023, 1015, 5248, 5085, 5311, 1005, 1004, 1001, 5064)) 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:38.3530.5 msyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "is_delete"=FALSE ORDER BY "order"
16:12:38.3490.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:12:38.3740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_engineer_group_relationships" WHERE "engineer_group_id"=1
16:12:38.3580.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "group_id" IN (80, 1, 81, 83)
16:12:38.3460.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta