Performance Profiling

Total processing time: 82 ms; Peak memory: 4.063 MB. Show Profiling Timeline

总计15条数据

Time	Duration	Category	Info

14:10:01.482	36.1 ms	yii\db\Command::query	SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p., p.budget profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='2')) "final" ORDER BY "bargain_date" DESC LIMIT 20
14:10:01.464	5.0 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final. FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p., p.budget profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='2')) "final" ORDER BY "bargain_date" DESC) "c"
14:10:01.522	3.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')
14:10:01.454	3.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5250
14:10:01.479	2.8 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final. FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p., p.budget profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='2')) "final" ORDER BY "bargain_date" DESC) "c"
14:10:01.452	2.7 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:10:01.469	2.6 ms	yii\db\Command::query	SELECT SUM(budget) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p., p.budget profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='2')) "final" ORDER BY "bargain_date" DESC) "c"
14:10:01.476	2.6 ms	yii\db\Command::query	SELECT SUM(collected) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p., p.budget profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='2')) "final" ORDER BY "bargain_date" DESC) "c"
14:10:01.473	2.6 ms	yii\db\Command::query	SELECT SUM(budget / 100 * profit_pct) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p., p.budget profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='2')) "final" ORDER BY "bargain_date" DESC) "c"
14:10:01.527	1.8 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/project-list', '{"dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420","page":"1","status":"status2","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":1,"reimbursement_amount":"112","id":3811,"client_id":2815,"project_status":2,"project_progress":5,"budget":"50000","profit_pct":"5","bargain_date":"2025-08-21","description":"","created_by":1004,"created_at":"2025-06-21 21:22:14","updated_at":"2025-07-04 11:16:50","engineer_id":null,"project_title":"\u6ef4\u6ef4\u6253\u8f66","collected":"0","status_updated_at":"2025-06-21 21:24:12.913581+08","success_rate":null,"comment":"\u5c31\u653e\u5047\u653e\u5047","contract_type":1,"progress_updated_at":"2025-06-25 14:09:02.71126+08","forecast_updated_at":"2025-06-25 14:09:07.282021+08","end_at":"","pinyin_shortcut":"dddc","creator":1000,"used_client":2815,"from_contact":2782,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"2500.0000000000000000","un_collected":"50000","client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","logo":null,"client_type":6,"client_class":47,"client_industry":10},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"service_time":"4.6","service_count":5,"pscount":4,"ircount":1,"pstime":"2.95","irtime":"1.65","points":"200","work_time":2.07,"work_count":1,"reimbursement_amount":"1220.00","id":3232,"client_id":2136,"project_status":2,"project_progress":3,"budget":"3500000","profit_pct":"25","bargain_date":"2025-06-30","description":"\u4eff\u771f\u8d44\u6e90\u4e0d\u591f\uff0c\u7528\u6237\u81ea\u7b79 \u8d44\u91d1300\u4e07\u4ee5\u5185\u3002","created_by":5087,"created_at":"2023-06-19 10:39:31","updated_at":"2025-03-16 08:31:30","engineer_id":null,"project_title":"\u901f\u77f3\u9ad8\u6027\u80fd\u96c6\u7fa4-K","collected":"0","status_updated_at":"2025-03-09 08:44:15.600061+08","success_rate":null,"comment":"\u4eff\u771f\u8d44\u6e90\u4e0d\u591f\uff0c\u7528\u6237\u81ea\u7b79 \u8d44\u91d1300\u4e07\u4ee5\u5185\u3002\r\n","contract_type":1,"progress_updated_at":"2025-03-09 08:44:15.600061+08","forecast_updated_at":"2025-03-09 08:44:15.600061+08","end_at":"","pinyin_shortcut":"ssgxnjqK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"875000.000000000000","un_collected":"3500000","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","logo":null,"client_type":6,"client_class":47,"client_industry":5},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3798,"client_id":528,"project_status":2,"project_progress":4,"budget":"160000","profit_pct":"10","bargain_date":"2025-06-30","description":null,"created_by":5295,"created_at":"2025-03-10 13:25:16","updated_at":"2025-03-17 09:43:21","engineer_id":null,"project_title":"2025PA\u9632\u706b\u5899\u7eed\u4fdd-K","collected":"0","status_updated_at":"2025-03-10 13:25:16.449758+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-03-10 13:25:16.449758+08","forecast_updated_at":"2025-03-10 14:22:09.582455+08","end_at":"","pinyin_shortcut":"2025PAfhqxbK","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"16000.000000000000","un_collected":"160000","client":{"id":528,"key":528,"name":"\u5317\u4eac\u8bfa\u8bda\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8(\u5357\u4eac\u5929\u5370\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u5929\u8bda\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u6c47\u8bda\u5065\u534e)","logo":null,"client_type":1,"client_class":80,"client_industry":5},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"service_time":"11","service_count":1,"pscount":0,"ircount":1,"pstime":"0","irtime":"11","points":"143","work_time":0,"work_count":0,"reimbursement_amount":"0","id":3695,"client_id":2128,"project_status":2,"project_progress":3,"budget":"950000","profit_pct":"30","bargain_date":"2025-06-30","description":null,"created_by":5087,"created_at":"2024-10-20 19:25:01","updated_at":"2025-03-16 08:33:49","engineer_id":null,"project_title":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3-K","collected":"0","status_updated_at":"2024-10-20 23:24:04.898116+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-10-20 23:24:04.898116+08","forecast_updated_at":"2024-10-20 23:24:04.898116+08","end_at":"","pinyin_shortcut":"bfxtgchtdK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"285000.000000000000","un_collected":"950000","client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u624033\u6240","logo":null,"client_type":6,"client_class":47,"client_industry":20},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3810,"client_id":3304,"project_status":2,"project_progress":9,"budget":"46868","profit_pct":"1.01","bargain_date":"2025-06-11","description":null,"created_by":1001,"created_at":"2025-06-11 11:09:32","updated_at":"2025-06-11 11:09:32","engineer_id":null,"project_title":"\u6d4b\u8bd5\u52a8\u6001","collected":"0","status_updated_at":"2025-06-11 11:09:32.772809+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-06-11 11:09:32.772809+08","forecast_updated_at":"2025-06-11 11:09:32.772809+08","end_at":"","pinyin_shortcut":"csdt","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"473.3668000000000000","un_collected":"46868","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":13},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0.98,"work_count":1,"reimbursement_amount":"0","id":3778,"client_id":97,"project_status":2,"project_progress":3,"budget":"400000","profit_pct":"10","bargain_date":"2025-05-31","description":null,"created_by":5300,"created_at":"2025-02-17 11:25:43","updated_at":"2025-03-17 10:07:19","engineer_id":null,"project_title":"\u670d\u52a1\u5668\u5b58\u50a8\u865a\u62df\u5316\u65b0\u8d2d-K-2025","collected":"0","status_updated_at":"2025-02-17 11:25:43.689565+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-02-17 11:25:43.689565+08","forecast_updated_at":"2025-02-17 18:04:29.130935+08","end_at":"","pinyin_shortcut":"fwqccxnhxgK2025","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"40000.000000000000","un_collected":"400000","client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)","logo":null,"client_type":5,"client_class":43,"client_industry":16},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"service_time":"1.45","service_count":1,"pscount":1,"ircount":0,"pstime":"1.45305555555556","irtime":"0","points":"50","work_time":7.35,"work_count":4,"reimbursement_amount":"270","id":3580,"client_id":3284,"project_status":2,"project_progress":3,"budget":"100000","profit_pct":"10","bargain_date":"2025-04-30","description":null,"created_by":5300,"created_at":"2024-06-28 11:26:20","updated_at":"2025-03-17 10:05:32","engineer_id":null,"project_title":"\u4e91\u684c\u9762","collected":"0","status_updated_at":"2024-09-14 13:01:35.553182+08","success_rate":null,"comment":"\u4e91\u684c\u9762\u89e3\u51b3\u65b9\u6848","contract_type":1,"progress_updated_at":"2024-09-14 13:01:35.553182+08","forecast_updated_at":"2025-03-17 10:04:17.925801+08","end_at":"","pinyin_shortcut":"yzm","creator":5413,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"10000.0000000000000000","un_collected":"100000","client":{"id":3284,"key":3284,"name":"\u5149\u660e\u7f51\u4f20\u5a92\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":43,"client_industry":14},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3758,"client_id":2130,"project_status":2,"project_progress":6,"budget":"250000","profit_pct":"20","bargain_date":"2025-04-30","description":null,"created_by":5087,"created_at":"2025-01-06 11:48:40","updated_at":"2025-03-16 08:24:43","engineer_id":null,"project_title":"\u5907\u4efd\u6269\u5bb9-K","collected":"0","status_updated_at":"2025-02-24 11:09:41.994298+08","success_rate":null,"comment":"\u4ea7\u54c1\uff1a\u58f9\u8fdb\u5236\uff0c\u539f\u6765\u5bb9\u91cf\u7684 5\u500d\uff0c\u9700\u8981\u67e5\u770b\u4e4b\u524d\u5bb9\u91cf\u3002","contract_type":1,"progress_updated_at":"2025-02-24 11:09:41.994298+08","forecast_updated_at":"2025-02-24 11:09:41.994298+08","end_at":"","pinyin_shortcut":"bfkrK","creator":5087,"used_client":2136,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"50000.000000000000","un_collected":"250000","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":null,"client_type":6,"client_class":47,"client_industry":5},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3797,"client_id":2091,"project_status":2,"project_progress":4,"budget":"2150000","profit_pct":"40","bargain_date":"2025-04-30","description":null,"created_by":1004,"created_at":"2025-03-09 21:10:14","updated_at":"2025-03-09 21:11:56","engineer_id":null,"project_title":"2025\u5e74\u865a\u62df\u5316\u5e73\u53f0\u786c\u4ef6\u7eed\u4fdd\u9879\u76ee","collected":"0","status_updated_at":"2025-03-09 21:10:14.780627+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-03-09 21:10:14.780627+08","forecast_updated_at":"2025-03-09 21:10:14.780627+08","end_at":"","pinyin_shortcut":"2025nxnhptyjxbxm","creator":1004,"used_client":5,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"860000.000000000000","un_collected":"2150000","client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8","logo":null,"client_type":2,"client_class":47,"client_industry":20},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"service_time":"2.5","service_count":1,"pscount":0,"ircount":1,"pstime":"0","irtime":"2.5","points":"31","work_time":0,"work_count":0,"reimbursement_amount":"0","id":3665,"client_id":25,"project_status":2,"project_progress":6,"budget":"122640","profit_pct":"20","bargain_date":"2025-04-01","description":null,"created_by":1005,"created_at":"2024-09-22 19:26:17","updated_at":"2025-03-09 19:18:15","engineer_id":null,"project_title":"24\u5e74\u865a\u62df\u5316\u7eed\u4fdd\u53ca\u670d\u52a1","collected":"0","status_updated_at":"2025-02-24 11:10:08.528857+08","success_rate":null,"comment":"vmware\uff0cveeam\uff0c\u4e9a\u4fe1\u7eed\u4fdd","contract_type":1,"progress_updated_at":"2025-02-24 11:10:08.528857+08","forecast_updated_at":"2025-02-24 11:15:42.716969+08","end_at":"","pinyin_shortcut":"24nxnhxbjfw","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"24528.000000000000","un_collected":"122640","client":{"id":25,"key":25,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6559\u5e08\u8fdb\u4fee\u5b66\u6821","logo":null,"client_type":1,"client_class":80,"client_industry":2},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3727,"client_id":3288,"project_status":2,"project_progress":5,"budget":"460000","profit_pct":"35","bargain_date":"2025-03-31","description":null,"created_by":5420,"created_at":"2024-11-29 12:38:46","updated_at":"2024-12-30 10:21:35","engineer_id":null,"project_title":"\u5a01\u80c1\u60c5\u62a5\u9879\u76ee","collected":"0","status_updated_at":"2024-11-29 12:38:46.114698+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-11-29 12:38:46.114698+08","forecast_updated_at":"2024-11-29 12:38:46.114698+08","end_at":"","pinyin_shortcut":"wxqbxm","creator":5420,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"161000.000000000000","un_collected":"460000","client":{"id":3288,"key":3288,"name":"\u56fd\u5bb6\u6863\u6848\u5c40","logo":null,"client_type":1,"client_class":1,"client_industry":1},"createdBy":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","department_id":1,"avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}},{"service_time":"3.5","service_count":2,"pscount":0,"ircount":2,"pstime":"0","irtime":"3.5","points":"93","work_time":0,"work_count":0,"reimbursement_amount":"0","id":3256,"client_id":15,"project_status":2,"project_progress":4,"budget":"339400","profit_pct":"25","bargain_date":"2025-03-31","description":"\u4e09\u53f0\u8054\u60f3SR650\u670d\u52a1\u5668+\u4e00\u5957FAS2750\u5b58\u50a8\uff0c\u505a\u6210\u865a\u62df\u5316\u73af\u5883\uff0c\u505a\u6d4b\u8bd5\u4f7f\u7528\u3002","created_by":1004,"created_at":"2023-07-16 18:28:54","updated_at":"2025-03-17 14:06:28","engineer_id":null,"project_title":"\u865a\u62df\u5316\u6d4b\u8bd5\u96c6\u7fa4","collected":"0","status_updated_at":"2024-05-12 19:16:55.612323+08","success_rate":null,"comment":"\u4e09\u53f0\u8054\u60f3SR650\u670d\u52a1\u5668+\u4e00\u5957FAS2750\u5b58\u50a8\uff0c\u505a\u6210\u865a\u62df\u5316\u73af\u5883\uff0c\u505a\u6d4b\u8bd5\u4f7f\u7528\u3002\r\n","contract_type":1,"progress_updated_at":"2024-05-12 19:16:55.612323+08","forecast_updated_at":"2024-05-12 19:16:55.612323+08","end_at":"","pinyin_shortcut":"xnhcsjq","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"84850.000000000000","un_collected":"339400","client":{"id":15,"key":15,"name":"\u4e2d\u51b6\u4eac\u8bda\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u6c14\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)(\u5317\u4eac\u4eac\u8bda\u8d5b\u745e\u56fe\u6587\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":6,"client_class":47,"client_industry":1},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"service_time":"5.25","service_count":2,"pscount":0,"ircount":2,"pstime":"0","irtime":"5.25","points":"79","work_time":9.07,"work_count":4,"reimbursement_amount":"0","id":3784,"client_id":12,"project_status":2,"project_progress":9,"budget":"89000","profit_pct":"60","bargain_date":"2025-03-31","description":null,"created_by":5300,"created_at":"2025-02-26 18:53:15","updated_at":"2025-05-12 14:01:26","engineer_id":null,"project_title":"\u6570\u636e\u6062\u590d-K-2025","collected":"0","status_updated_at":"2025-03-03 09:42:46.888657+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2025-03-03 09:42:46.888657+08","forecast_updated_at":"2025-03-03 09:42:46.888657+08","end_at":"","pinyin_shortcut":"sjhfK2025","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"53400.000000000000","un_collected":"89000","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":80,"client_industry":5},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3781,"client_id":1172,"project_status":2,"project_progress":9,"budget":"19296","profit_pct":"30","bargain_date":"2025-03-31","description":null,"created_by":1004,"created_at":"2025-02-24 09:32:46","updated_at":"2025-03-17 14:08:45","engineer_id":null,"project_title":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd","collected":"0","status_updated_at":"2025-03-17 14:07:53.123489+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-03-17 14:07:53.123489+08","forecast_updated_at":"2025-03-17 14:07:53.123489+08","end_at":"","pinyin_shortcut":"sxfACxb","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"5788.8000000000000000","un_collected":"19296","client":{"id":1172,"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u7269\u6d41\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3725,"client_id":3324,"project_status":2,"project_progress":5,"budget":"88000","profit_pct":"15","bargain_date":"2025-03-31","description":null,"created_by":1004,"created_at":"2024-11-27 16:06:23","updated_at":"2025-03-17 14:07:23","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u8d1f\u8f7d\u5747\u8861","collected":"0","status_updated_at":"2024-12-01 17:09:01.706856+08","success_rate":null,"comment":"\u6df1\u4fe1\u670d\u8d1f\u8f7d\u5747\u8861","contract_type":1,"progress_updated_at":"2024-12-01 17:09:01.706856+08","forecast_updated_at":"2024-12-01 17:09:01.706856+08","end_at":"","pinyin_shortcut":"sxffzjh","creator":5413,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"13200.000000000000","un_collected":"88000","client":{"id":3324,"key":3324,"name":"\u4e2d\u56fd\u5730\u8d28\u8c03\u67e5\u5c40","logo":null,"client_type":1,"client_class":43,"client_industry":1},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":1,"reimbursement_amount":"0","id":3488,"client_id":93,"project_status":2,"project_progress":6,"budget":"600000","profit_pct":"10","bargain_date":"2025-03-28","description":null,"created_by":1005,"created_at":"2024-03-31 22:49:26","updated_at":"2025-03-16 22:28:17","engineer_id":null,"project_title":"\u591a\u56e0\u7d20\u8ba4\u8bc1","collected":"0","status_updated_at":"2024-08-26 07:49:48.430459+08","success_rate":null,"comment":"\u89e3\u51b3\u7684\u95ee\u9898\uff1a\u5e10\u53f7\u88ab\u52ab\u6301\uff0c\u5185\u90e8\u5458\u5de5\u88ab\u9a97\u94b1","contract_type":1,"progress_updated_at":"2024-08-26 07:49:48.430459+08","forecast_updated_at":"2024-08-26 07:49:48.430459+08","end_at":"","pinyin_shortcut":"dysrz","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"60000.000000000000","un_collected":"600000","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3674,"client_id":3307,"project_status":2,"project_progress":6,"budget":"1370000","profit_pct":"35","bargain_date":"2025-01-24","description":null,"created_by":5420,"created_at":"2024-09-29 16:09:19","updated_at":"2024-12-30 10:20:36","engineer_id":null,"project_title":"\u5a01\u80c1\u60c5\u62a5\u5e73\u53f0\u5efa\u8bbe\u9879\u76ee","collected":"0","status_updated_at":"2024-09-29 16:09:19.464307+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-09-29 16:09:19.464307+08","forecast_updated_at":"2024-09-29 16:09:19.464307+08","end_at":"","pinyin_shortcut":"wxqbptjsxm","creator":5420,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"479500.000000000000","un_collected":"1370000","client":{"id":3307,"key":3307,"name":"\u4e0a\u6d77\u51fa\u5165\u5883\u8fb9\u9632\u68c0\u67e5\u603b\u7ad9","logo":null,"client_type":1,"client_class":1,"client_industry":1},"createdBy":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","department_id":1,"avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3690,"client_id":3292,"project_status":2,"project_progress":6,"budget":"155000","profit_pct":"40","bargain_date":"2024-12-31","description":null,"created_by":5420,"created_at":"2024-10-17 12:35:48","updated_at":"2024-12-30 10:18:21","engineer_id":null,"project_title":"\u5907\u4efd\u6269\u5bb9\u9879\u76ee","collected":"0","status_updated_at":"2024-10-17 12:35:48.208417+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-10-17 12:35:48.208417+08","forecast_updated_at":"2024-10-17 12:35:48.208417+08","end_at":"","pinyin_shortcut":"bfkrxm","creator":5420,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"62000.000000000000","un_collected":"155000","client":{"id":3292,"key":3292,"name":"\u5317\u6c7d\u96c6\u56e2\u8d22\u52a1\u516c\u53f8","logo":null,"client_type":6,"client_class":1,"client_industry":5},"createdBy":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","department_id":1,"avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3713,"client_id":3319,"project_status":2,"project_progress":9,"budget":"90000","profit_pct":"50","bargain_date":"2024-12-31","description":null,"created_by":5420,"created_at":"2024-11-12 15:17:25","updated_at":"2024-12-30 11:36:56","engineer_id":null,"project_title":"\u6570\u5b57\u6863\u6848\u9986\u5b89\u5168\u670d\u52a1\u9879\u76ee","collected":"0","status_updated_at":"2024-12-30 11:36:56.923333+08","success_rate":null,"comment":"\u4e00\u5e74\u6e17\u900f\u6d4b\u8bd5\uff0c 4\u6b21\u5de1\u68c0\uff0c4 \u6b21\u62a5\u544a\u3002","contract_type":2,"progress_updated_at":"2024-12-30 11:36:56.923333+08","forecast_updated_at":"2024-12-30 11:36:56.923333+08","end_at":"","pinyin_shortcut":"szdagaqfwxm","creator":5420,"used_client":3288,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"45000.000000000000","un_collected":"90000","client":{"id":3319,"key":3319,"name":"\u4e2d\u79d1\u4fe1\u606f\u5b89\u5168\u5171\u6027\u6280\u672f\u56fd\u5bb6\u5de5\u7a0b\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":80,"client_industry":13},"createdBy":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","department_id":1,"avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3722,"client_id":3308,"project_status":2,"project_progress":6,"budget":"65000","profit_pct":"55","bargain_date":"2024-12-31","description":null,"created_by":5420,"created_at":"2024-11-25 09:26:38","updated_at":"2024-12-30 10:19:30","engineer_id":null,"project_title":"\u5a01\u80c1\u60c5\u62a5\u7eed\u4fdd","collected":"0","status_updated_at":"2024-11-25 09:26:38.810035+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2024-11-25 09:26:38.810035+08","forecast_updated_at":"2024-11-25 09:26:38.810035+08","end_at":"","pinyin_shortcut":"wxqbxb","creator":5420,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"35750.000000000000","un_collected":"65000","client":{"id":3308,"key":3308,"name":"\u5317\u4eac\u5e02\u519c\u6797\u79d1\u5b66\u9662","logo":null,"client_type":1,"client_class":80,"client_industry":1},"createdBy":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","department_id":1,"avatar":{"id":161,"user_id":5420,"name":"\/files\/cdn\/a57be577deb434\/avatar\/030adffb-15cf-3504-a6fe-49ad56425387.png"}}}],"count":26,"sumBudget":"12353506","sumProfit":3811691.92,"sumCollect":"0","pagenation":{"totalcount":26,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:10:01') RETURNING "id"
14:10:01.459	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
14:10:01.526	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=209, "last_visit_at"='now()' WHERE "id"=49799
14:10:01.519	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2815, 2136, 528, 2128, 3304, 97, 3284, 2130, 2091, 25, 3288, 15, 12, 1172, 3324, 93, 3307, 3292, 3319, 3308)
14:10:01.520	0.7 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5420, 5295, 1005, 5087, 1004, 5300))
14:10:01.520	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5087, 5295, 1001, 5300, 1005, 5420)