ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868bfc0ef668: POST https://beta.jinchangxiao.com/vue/analysis/view-client-histogram at 2025-07-05 02:01:36 pm by 223.72.35.175

Performance Profiling

Total processing time: 24 ms; Peak memory: 5.360 MB. Show Profiling Timeline

总计11条数据
TimeDurationCategoryInfo
  
14:01:36.9973.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')
14:01:36.9842.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5250
14:01:36.9821.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:01:36.9941.4 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, count(distinct p.used_client) as used_clients, CASE WHEN p.bargain_date >= (to_char(p.bargain_date,'YYYY-') || '01-01') :: DATE THEN to_char( P.bargain_date, 'YYYY')::INTEGER ELSE to_char( P.bargain_date, 'YYYY')::INTEGER - 1 END AS bargain_year FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."client_id"=5) AND (p.bargain_date IS NOT NULL) GROUP BY "bargain_year"
14:01:37.0011.2 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/view-client-histogram', '{"to":"","from":"","user_id":"","project_status":"3","alert":"false","id":"5","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"category":{"budgetCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"profitsCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"clientCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"projectCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"],"usedClientCategory":["2025\u8d22\u5e74","2024\u8d22\u5e74","2023\u8d22\u5e74","2022\u8d22\u5e74","2021\u8d22\u5e74","2020\u8d22\u5e74","2019\u8d22\u5e74","2018\u8d22\u5e74","2017\u8d22\u5e74"]},"seriesBudget":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":1,"arrowNum":"","y":"10010312.00"},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":-1,"arrowNum":0.1814,"y":"8194858.00"},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":-1,"arrowNum":0.0839,"y":"7507512.00"},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":1,"arrowNum":1.7281,"y":"20481061.00"},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":-1,"arrowNum":0.6414,"y":"7343844.00"},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":-1,"arrowNum":0.1798,"y":"6023451.00"}],"seriesProfits":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","y":"0.00"},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":1,"arrowNum":"","y":"2923114.04"},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":1,"arrowNum":0.0931,"y":"3195175.52"},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":-1,"arrowNum":0.0589,"y":"3006851.84"},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":1,"arrowNum":1.3214,"y":"6979986.19"},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":-1,"arrowNum":0.7025,"y":"2076272.33"},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":-1,"arrowNum":0.1953,"y":"1670693.06"}],"seriesClients":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":1,"arrowNum":"","y":1},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":0,"y":1},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":0,"arrowNum":0,"y":1},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":0,"y":1},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":0,"arrowNum":0,"y":1},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":0,"arrowNum":0,"y":1}],"seriesProjects":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":1,"arrowNum":"","y":3},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":0,"y":3},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":1,"arrowNum":2,"y":9},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":0,"y":9},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":-1,"arrowNum":0.4444,"y":5},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":1,"arrowNum":0.2,"y":6}],"seriesUsedClients":[{"key":"fascal2025","name":"2025\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2024","name":"2024\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2023","name":"2023\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2022","name":"2022\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2021","name":"2021\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2020","name":"2020\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2019","name":"2019\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2018","name":"2018\u8d22\u5e74","arrow":0,"arrowNum":"","y":0},{"key":"fascal2017","name":"2017\u8d22\u5e74","arrow":0,"arrowNum":"","y":0}],"totalBudget":59561038,"totalProfits":19852092.9936,"totalClients":6,"totalProjects":35,"totalUsedClients":0,"avg":{"avg_client":"0.11","avg_used_client":"0.00","avg_project":"3.89","avg_budget":"6617893.11","avg_profit":"2205788.11"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:01:37') RETURNING "id"
14:01:36.9871.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
14:01:36.9891.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE ("c"."id"='5') AND ("deleted"=FALSE)
14:01:36.9920.9 msyii\db\Command::querySELECT MIN(bargain_date) FROM "a57be577deb434"."tbl_projects"
14:01:37.0000.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=114, "last_visit_at"='now()' WHERE "id"=49799
14:01:36.9960.4 msyii\db\Command::querySELECT count(distinct p.client_id) as avg_client, count(distinct p.used_client) as avg_used_client, count(distinct p.id) as avg_project, 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"."client_id"=5)
14:01:36.9910.4 msyii\db\Command::querySELECT * FROM "global"."tbl_enterprises" WHERE "id"=2