ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4f3b7ae8edb: POST https://beta.jinchangxiao.com/vue/analysis/sales-histogram at 2026-07-09 02:11:06 pm by 114.244.130.61

Performance Profiling

Total processing time: 59 ms; Peak memory: 5.370 MB. Show Profiling Timeline

总计16条数据
TimeDurationCategoryInfo
  
14:11:06.9625.7 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:11:07.0043.3 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/sales-histogram', '{"period":"currentfascalyear","dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5332,5449,5467,5476,5499,5500","GroupId":"","project_status":"3","alert":"false","web_access_token":"sHKfFzpC6AXRHThWzDm5OfadRXFFX-oO"}', '{"code":2000,"result":{"category":{"budgetCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9648\u8c46\u8c46<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6d4b\u8bd5<\/div>"],"profitsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9648\u8c46\u8c46<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6d4b\u8bd5<\/div>"],"clientsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9648\u8c46\u8c46<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6d4b\u8bd5<\/div>"],"projectsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9648\u8c46\u8c46<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6d4b\u8bd5<\/div>"]},"seriesBudget":[{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"998853263.00"},{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"18841550.78"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"6643507.40"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"176680.20"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"132220.00"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"23104.99"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"0.00"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"0.00"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":"0.00"},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5499,"name":"\u9648\u8c46\u8c46","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5500,"name":"\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":"0.00"}],"seriesProfits":[{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"248784968.28"},{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"6199623.20"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"2141036.53"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"577084.81"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"37681.43"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"6523.85"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"0.00"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"0.00"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":"0.00"},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5499,"name":"\u9648\u8c46\u8c46","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5500,"name":"\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":"0.00"}],"seriesClients":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":12},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":9},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":6},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":4},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":3},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":2},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":0},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":0},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":0},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5499,"name":"\u9648\u8c46\u8c46","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5500,"name":"\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":0}],"seriesProjects":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":18},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":9},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":7},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":5},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":3},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":2},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":0},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":0},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":0},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5499,"name":"\u9648\u8c46\u8c46","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5500,"name":"\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":0}],"avg":{"avg_budget":"73190737.60","avg_profit":"18410494.15"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-07-09 14:11:07', 48090880) RETURNING "id"
14:11:06.9682.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5252
14:11:06.9842.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 (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::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
14:11:06.9872.1 msyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
14:11:06.9741.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:11:06.9961.7 msyii\db\Command::querySELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, "created_by" FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND (p.bargain_date < TIMESTAMP '2026-12-31 23:59:59' + INTERVAL '1 second') AND ("created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476', '5499', '5500')) GROUP BY "created_by"
14:11:06.9931.3 msyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
14:11:06.9901.2 msyii\db\Command::querySELECT g.name, string_agg( sgr.sales_id::varchar, ',') AS list FROM "a57be577deb434"."tbl_groups" "g" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.group_id = g.id WHERE "sgr"."sales_id" IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449) GROUP BY "g"."name"
14:11:07.0001.1 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-01-01 00:00:00, 2026-12-31 23:59:59]'::daterange) AND ("user_id" IN (1001, 5049, 5500, 5301, 5499, 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)) 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
14:11:07.0011.0 msyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
14:11:06.9980.9 msyii\db\Command::querySELECT sum(p.budget) AS avg_budget, sum(p.budget /100 * profit_pct) AS avg_profit FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND (p.bargain_date < TIMESTAMP '2026-12-31 23:59:59' + INTERVAL '1 second')
14:11:06.9720.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:11:06.9920.8 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 (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::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
14:11:06.9950.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("id" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476', '5499', '5500')) ORDER BY "created_at"
14:11:06.9960.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1004, 1005, 1013, 5087, 5295, 5300, 5311, 5332, 5449, 5467, 5476, 5499, 5500))