Performance Profiling

Total processing time: 145 ms; Peak memory: 5.307 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

15:25:08.446	24.4 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko/20100101 Firefox/151.0'
15:25:08.383	23.5 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT final.id, final.name, final.sales_rep, final.status3_budgets, final.status3_profits, final.status3_count, final.status3_pct, final.status1_budgets, final.status1_count, final.status2_budgets, final.status2_count, final.created_at, final.last_bargain_date, final.client_industry, final.client_industry_id, final.client_type, final.client_type_id, final.collected, final.un_collected, final.invoices, final.un_invoices, final.project_count, final.other_budgets, final.status12_budgets, final.status12_profits FROM (SELECT c.id, c.name, c.sales_rep, c.created_at, CASE WHEN tmp1.budgets IS NULL THEN 0 ELSE tmp1.budgets END AS status3_budgets, CASE WHEN tmp1.profits IS NULL THEN 0 ELSE tmp1.profits END AS status3_profits, CASE WHEN tmp1.budgets IS NULL OR tmp1.budgets = 0 THEN 0 ELSE tmp1.profits / tmp1.budgets END AS status3_pct, CASE WHEN tmp1.count IS NULL THEN 0 ELSE tmp1.count END AS status3_count, CASE WHEN tmp1.collected IS NULL THEN 0 ELSE tmp1.collected END AS collected, CASE WHEN tmp1.un_collected IS NULL THEN 0 ELSE tmp1.un_collected END AS un_collected, CASE WHEN tmp2.budgets IS NULL THEN 0 ELSE tmp2.budgets END AS status1_budgets, CASE WHEN tmp2.count IS NULL THEN 0 ELSE tmp2.count END AS status1_count, CASE WHEN tmp3.budgets IS NULL THEN 0 ELSE tmp3.budgets END AS status2_budgets, CASE WHEN tmp3.count IS NULL THEN 0 ELSE tmp3.count END AS status2_count, tmp1.last_bargain_date, CASE WHEN tmp10.invoices IS NULL THEN 0 ELSE tmp10.invoices END AS invoices, CASE WHEN tmp10.un_invoices IS NULL THEN 0 ELSE tmp10.un_invoices END AS un_invoices, tmp1.count AS cooperated, ci.name as client_industry, ci.id as client_industry_id, ct.name as client_type, ct.id as client_type_id, CASE WHEN tmp11.count IS NULL THEN 0 ELSE tmp11.count END AS project_count, CASE WHEN tmp12.budgets IS NULL THEN 0 ELSE tmp12.budgets END AS other_budgets, CASE WHEN tmp13.budgets IS NULL THEN 0 ELSE tmp13.budgets END AS status12_budgets, CASE WHEN tmp13.profits IS NULL THEN 0 ELSE tmp13.profits END AS status12_profits FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT sub1.client_id, sum(sub1.budget) AS budgets, sum(sub1.budget sub1.profit_pct / 100) AS profits, max(sub1.bargain_date) AS last_bargain_date, sum(case when budget >= collected THEN budget - collected ELSE 0 END) AS un_collected, sum(collected) AS collected, count(sub1.id) as count FROM (SELECT p.id, p.used_client as client_id, sum(COALESCE(pucp.amount,0)) as collected, p.budget, p.profit_pct, ps.bargain_date FROM "a57be577deb434"."tbl_project_used_clients" "p" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = p.project_id LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "pucp" ON pucp.project_used_client_id = p.id WHERE ps.project_status = 3 GROUP BY "p"."id", "ps"."id") "sub1" GROUP BY "sub1"."client_id") "tmp1" ON tmp1.client_id = c.id LEFT JOIN (SELECT sub2.client_id, sum(sub2.budget) AS budgets, count(sub2.id) as count FROM (SELECT "p"."id", "p"."used_client" AS "client_id", "p"."budget", "p"."profit_pct", "ps"."bargain_date" FROM "a57be577deb434"."tbl_project_used_clients" "p" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = p.project_id WHERE ps.project_status = 1) "sub2" GROUP BY "sub2"."client_id") "tmp2" ON tmp2.client_id = c.id LEFT JOIN (SELECT sub3.client_id, sum(sub3.budget) AS budgets, count(sub3.id) as count FROM (SELECT "p"."id", "p"."used_client" AS "client_id", "p"."budget", "p"."profit_pct", "ps"."bargain_date" FROM "a57be577deb434"."tbl_project_used_clients" "p" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = p.project_id WHERE ps.project_status = 2) "sub3" GROUP BY "sub3"."client_id") "tmp3" ON tmp3.client_id = c.id LEFT JOIN (SELECT sub10.client_id, sum(sub10.invoices) as invoices, sum(case when sub10.amount >= sub10.invoices THEN sub10.amount - sub10.invoices ELSE 0 END) AS un_invoices FROM (SELECT sc.used_client as client_id, sc.budget as amount, COALESCE(SUM(sci.amount ),0) AS invoices FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = sc.project_id LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "sci" ON sci.project_used_client_id = sc.id WHERE ps.project_status = 3 GROUP BY "sc"."id") "sub10" GROUP BY "sub10"."client_id") "tmp10" ON tmp10.client_id = c.id LEFT JOIN (SELECT sub11.client_id, sum(sub11.budget) AS budgets, count(sub11.id) as count FROM (SELECT "sc"."project_id" AS "id", "sc"."used_client" AS "client_id", "sc"."budget" FROM "a57be577deb434"."tbl_project_used_clients" "sc") "sub11" GROUP BY "sub11"."client_id") "tmp11" ON tmp11.client_id = c.id LEFT JOIN (SELECT sub12.client_id, sum(sub12.budget) AS budgets, count(sub12.id) as count FROM (SELECT "p"."id", "puc"."used_client" AS "client_id", "puc"."budget" FROM "a57be577deb434"."tbl_project_used_clients" "puc" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = puc.project_id WHERE (p.project_status != 3) AND (puc.used_client is not null)) "sub12" GROUP BY "sub12"."client_id") "tmp12" ON tmp12.client_id = c.id LEFT JOIN (SELECT sub13.client_id, sum(sub13.budget) AS budgets, sum(sub13.profit) AS profits FROM (SELECT "puc"."used_client" AS "client_id", "puc"."budget", "puc"."profit" FROM "a57be577deb434"."tbl_project_used_clients" "puc" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = puc.project_id WHERE (p.project_status = 1 or p.project_status = 2) AND (puc.used_client is not null)) "sub13" GROUP BY "sub13"."client_id") "tmp13" ON tmp13.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON "cc"."id" = "c"."client_class" LEFT JOIN "a57be577deb434"."tbl_client_industries" "ci" ON "ci"."id" = "c"."client_industry" LEFT JOIN "a57be577deb434"."tbl_client_types" "ct" ON "ct"."id" = "c"."client_type" WHERE (("c"."sales_rep" 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)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."deleted"=FALSE) AND ("c"."sales_rep"='1001') AND ("sgr"."group_id"='1')) "final" LEFT JOIN "a57be577deb434"."tbl_cases" "cas" ON cas.client_id = final.id LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = cas.id LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id GROUP BY "final"."id", "final"."name", "final"."sales_rep", "final"."status3_budgets", "final"."status3_profits", "final"."status3_count", "final"."status3_pct", "final"."status1_budgets", "final"."status1_count", "final"."status2_budgets", "final"."status2_count", "final"."created_at", "final"."last_bargain_date", "final"."cooperated", "final"."client_industry", "final"."client_industry_id", "final"."client_type", "final"."client_type_id", "final"."collected", "final"."un_collected", "final"."invoices", "final"."un_invoices", "final"."project_count", "final"."other_budgets", "final"."status12_budgets", "final"."status12_profits", "final"."cooperated" ORDER BY "status3_budgets" DESC, "created_at" DESC) "c"
15:25:08.408	22.8 ms	yii\db\Command::query	SELECT final.id, final.name, final.sales_rep, final.status3_budgets, final.status3_profits, final.status3_count, final.status3_pct, final.status1_budgets, final.status1_count, final.status2_budgets, final.status2_count, final.created_at, final.last_bargain_date, final.client_industry, final.client_industry_id, final.client_type, final.client_type_id, final.collected, final.un_collected, final.invoices, final.un_invoices, final.project_count, final.other_budgets, final.status12_budgets, final.status12_profits FROM (SELECT c.id, c.name, c.sales_rep, c.created_at, CASE WHEN tmp1.budgets IS NULL THEN 0 ELSE tmp1.budgets END AS status3_budgets, CASE WHEN tmp1.profits IS NULL THEN 0 ELSE tmp1.profits END AS status3_profits, CASE WHEN tmp1.budgets IS NULL OR tmp1.budgets = 0 THEN 0 ELSE tmp1.profits / tmp1.budgets END AS status3_pct, CASE WHEN tmp1.count IS NULL THEN 0 ELSE tmp1.count END AS status3_count, CASE WHEN tmp1.collected IS NULL THEN 0 ELSE tmp1.collected END AS collected, CASE WHEN tmp1.un_collected IS NULL THEN 0 ELSE tmp1.un_collected END AS un_collected, CASE WHEN tmp2.budgets IS NULL THEN 0 ELSE tmp2.budgets END AS status1_budgets, CASE WHEN tmp2.count IS NULL THEN 0 ELSE tmp2.count END AS status1_count, CASE WHEN tmp3.budgets IS NULL THEN 0 ELSE tmp3.budgets END AS status2_budgets, CASE WHEN tmp3.count IS NULL THEN 0 ELSE tmp3.count END AS status2_count, tmp1.last_bargain_date, CASE WHEN tmp10.invoices IS NULL THEN 0 ELSE tmp10.invoices END AS invoices, CASE WHEN tmp10.un_invoices IS NULL THEN 0 ELSE tmp10.un_invoices END AS un_invoices, tmp1.count AS cooperated, ci.name as client_industry, ci.id as client_industry_id, ct.name as client_type, ct.id as client_type_id, CASE WHEN tmp11.count IS NULL THEN 0 ELSE tmp11.count END AS project_count, CASE WHEN tmp12.budgets IS NULL THEN 0 ELSE tmp12.budgets END AS other_budgets, CASE WHEN tmp13.budgets IS NULL THEN 0 ELSE tmp13.budgets END AS status12_budgets, CASE WHEN tmp13.profits IS NULL THEN 0 ELSE tmp13.profits END AS status12_profits FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT sub1.client_id, sum(sub1.budget) AS budgets, sum(sub1.budget * sub1.profit_pct / 100) AS profits, max(sub1.bargain_date) AS last_bargain_date, sum(case when budget >= collected THEN budget - collected ELSE 0 END) AS un_collected, sum(collected) AS collected, count(sub1.id) as count FROM (SELECT p.id, p.used_client as client_id, sum(COALESCE(pucp.amount,0)) as collected, p.budget, p.profit_pct, ps.bargain_date FROM "a57be577deb434"."tbl_project_used_clients" "p" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = p.project_id LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "pucp" ON pucp.project_used_client_id = p.id WHERE ps.project_status = 3 GROUP BY "p"."id", "ps"."id") "sub1" GROUP BY "sub1"."client_id") "tmp1" ON tmp1.client_id = c.id LEFT JOIN (SELECT sub2.client_id, sum(sub2.budget) AS budgets, count(sub2.id) as count FROM (SELECT "p"."id", "p"."used_client" AS "client_id", "p"."budget", "p"."profit_pct", "ps"."bargain_date" FROM "a57be577deb434"."tbl_project_used_clients" "p" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = p.project_id WHERE ps.project_status = 1) "sub2" GROUP BY "sub2"."client_id") "tmp2" ON tmp2.client_id = c.id LEFT JOIN (SELECT sub3.client_id, sum(sub3.budget) AS budgets, count(sub3.id) as count FROM (SELECT "p"."id", "p"."used_client" AS "client_id", "p"."budget", "p"."profit_pct", "ps"."bargain_date" FROM "a57be577deb434"."tbl_project_used_clients" "p" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = p.project_id WHERE ps.project_status = 2) "sub3" GROUP BY "sub3"."client_id") "tmp3" ON tmp3.client_id = c.id LEFT JOIN (SELECT sub10.client_id, sum(sub10.invoices) as invoices, sum(case when sub10.amount >= sub10.invoices THEN sub10.amount - sub10.invoices ELSE 0 END) AS un_invoices FROM (SELECT sc.used_client as client_id, sc.budget as amount, COALESCE(SUM(sci.amount ),0) AS invoices FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN "a57be577deb434"."tbl_projects" "ps" ON ps.id = sc.project_id LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "sci" ON sci.project_used_client_id = sc.id WHERE ps.project_status = 3 GROUP BY "sc"."id") "sub10" GROUP BY "sub10"."client_id") "tmp10" ON tmp10.client_id = c.id LEFT JOIN (SELECT sub11.client_id, sum(sub11.budget) AS budgets, count(sub11.id) as count FROM (SELECT "sc"."project_id" AS "id", "sc"."used_client" AS "client_id", "sc"."budget" FROM "a57be577deb434"."tbl_project_used_clients" "sc") "sub11" GROUP BY "sub11"."client_id") "tmp11" ON tmp11.client_id = c.id LEFT JOIN (SELECT sub12.client_id, sum(sub12.budget) AS budgets, count(sub12.id) as count FROM (SELECT "p"."id", "puc"."used_client" AS "client_id", "puc"."budget" FROM "a57be577deb434"."tbl_project_used_clients" "puc" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = puc.project_id WHERE (p.project_status != 3) AND (puc.used_client is not null)) "sub12" GROUP BY "sub12"."client_id") "tmp12" ON tmp12.client_id = c.id LEFT JOIN (SELECT sub13.client_id, sum(sub13.budget) AS budgets, sum(sub13.profit) AS profits FROM (SELECT "puc"."used_client" AS "client_id", "puc"."budget", "puc"."profit" FROM "a57be577deb434"."tbl_project_used_clients" "puc" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = puc.project_id WHERE (p.project_status = 1 or p.project_status = 2) AND (puc.used_client is not null)) "sub13" GROUP BY "sub13"."client_id") "tmp13" ON tmp13.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON "cc"."id" = "c"."client_class" LEFT JOIN "a57be577deb434"."tbl_client_industries" "ci" ON "ci"."id" = "c"."client_industry" LEFT JOIN "a57be577deb434"."tbl_client_types" "ct" ON "ct"."id" = "c"."client_type" WHERE (("c"."sales_rep" 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)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."deleted"=FALSE) AND ("c"."sales_rep"='1001') AND ("sgr"."group_id"='1')) "final" LEFT JOIN "a57be577deb434"."tbl_cases" "cas" ON cas.client_id = final.id LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = cas.id LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = ca.engineer_id GROUP BY "final"."id", "final"."name", "final"."sales_rep", "final"."status3_budgets", "final"."status3_profits", "final"."status3_count", "final"."status3_pct", "final"."status1_budgets", "final"."status1_count", "final"."status2_budgets", "final"."status2_count", "final"."created_at", "final"."last_bargain_date", "final"."cooperated", "final"."client_industry", "final"."client_industry_id", "final"."client_type", "final"."client_type_id", "final"."collected", "final"."un_collected", "final"."invoices", "final"."un_invoices", "final"."project_count", "final"."other_budgets", "final"."status12_budgets", "final"."status12_profits", "final"."cooperated" ORDER BY "status3_budgets" DESC, "created_at" DESC LIMIT 20
15:25:08.364	6.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:25:08.433	5.4 ms	yii\db\Command::query	INSERT 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/used-clients', '{"keyword":"","sales_rep":"1001","group":"1","dataUserId":"1001","page":"1","web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"id":3465,"name":"\u96f6\u552e001","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2026-06-09 17:08:39","last_bargain_date":null,"client_industry":"\u7269\u6d41","client_industry_id":8,"client_type":"\u4e2a\u4eba\u6d88\u8d39\u8005","client_type_id":3,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"5\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3463,"name":"3","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2026-06-02 16:54:10","last_bargain_date":null,"client_industry":"EDA\/CAE","client_industry_id":57,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"12\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2026-06-02 16:52:29","last_bargain_date":null,"client_industry":"\u653f\u5e9c","client_industry_id":1,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"12\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3458,"name":"\u800c\u7279\u7279\u70ed\u7279\u70ed","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2026-04-08 15:42:23","last_bargain_date":null,"client_industry":"EDA\/CAE","client_industry_id":57,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"2\u4e2a\u67086\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2026-04-01 11:21:52","last_bargain_date":null,"client_industry":"EDA\/CAE","client_industry_id":57,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"2\u4e2a\u670814\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2026-02-28 17:48:36","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"3\u4e2a\u670814\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2026-01-22 11:50:06","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"4\u4e2a\u670824\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"7000","status2_count":1,"created_at":"2025-12-19 13:31:40","last_bargain_date":null,"client_industry":"\u653f\u5e9c","client_industry_id":1,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","client_type_id":1,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":1,"other_budgets":"7000","status12_budgets":"7000","status12_profits":"8960","sales_rep_time":"5\u4e2a\u670827\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3429,"name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-12-04 15:48:49","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"6\u4e2a\u670810\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3427,"name":"\u4e2d\u592e\u5ba3\u4f20\u90e8\u7535\u5f71\u6570\u5b57\u8282\u76ee\u7ba1\u7406\u4e2d\u5fc3","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-11-26 16:05:45","last_bargain_date":null,"client_industry":"\u653f\u5e9c","client_industry_id":1,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"6\u4e2a\u670818\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3426,"name":"\u6df1\u5733\u5e02\u4fe1\u548c\u9886\u521b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-11-24 16:15:24","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"6\u4e2a\u670820\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-08-21 12:22:51","last_bargain_date":null,"client_industry":"\u5a92\u4f53","client_industry_id":18,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"9\u4e2a\u670825\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-07-02 09:55:22","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"11\u4e2a\u670813\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-05-14 16:30:29","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"1\u5e741\u4e2a\u6708","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3344,"name":"\u5317\u4eac\u4e2d\u795e\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-03-27 14:39:34","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"1\u5e742\u4e2a\u670819\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2025-02-28 16:18:15","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"1\u5e743\u4e2a\u670814\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2024-12-17 16:37:43","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"1\u5e745\u4e2a\u670828\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3315,"name":"\u822a\u5929\u79d1\u5de5206\u6240(\u91cd\u590d)","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2024-10-27 21:53:27","last_bargain_date":null,"client_industry":"\u5176\u4ed6","client_industry_id":20,"client_type":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","client_type_id":6,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"1\u5e747\u4e2a\u670818\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":0,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2024-10-16 11:09:32","last_bargain_date":null,"client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":0,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"1\u5e747\u4e2a\u670830\u5929","sales_rep_display":"\u5218\u4eba\u8bda"},{"id":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1001,"status3_budgets":"0","status3_profits":"0","status3_count":1,"status3_pct":0,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"created_at":"2024-09-19 15:34:42","last_bargain_date":"2023-11-24","client_industry":"SI\/ISV","client_industry_id":13,"client_type":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","client_type_id":5,"collected":"0","un_collected":"0","invoices":"0","un_invoices":"0","project_count":1,"other_budgets":"0","status12_budgets":"0","status12_profits":"0","sales_rep_time":"1\u5e748\u4e2a\u670825\u5929","sales_rep_display":"\u5218\u4eba\u8bda"}],"pagenation":{"totalcount":70,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-15 15:25:08', 90510080) RETURNING "id"
15:25:08.348	3.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:25:08.346	2.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:25:08.353	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:25:08.472	0.6 ms	yii\db\Command::execute	UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=20100 WHERE "id"=285