Performance Profiling

Total processing time: 69 ms; Peak memory: 5.363 MB. Show Profiling Timeline

总计9条数据

Time	Duration	Category	Info

08:54:11.178	40.1 ms	yii\db\Command::query	SELECT sc., sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.amount - scp.collected) as uncollected, sum(sc.amount - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE ("t1"."collected_date" >= '2025-06-18 00:00:00') AND ("t1"."collected_date" <= '2025-07-03 23:59:59') GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc., case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_sales_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id WHERE sc.need_analysis = true GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-03') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."id" IN (SELECT "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE ("collected_date" >= '2025-06-18 00:00:00') AND ("collected_date" <= '2025-07-03 23:59:59') GROUP BY "contract_id")) GROUP BY "sc"."id" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20
08:54:11.173	5.2 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT sc., sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.amount - scp.collected) as uncollected, sum(sc.amount - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE ("t1"."collected_date" >= '2025-06-18 00:00:00') AND ("t1"."collected_date" <= '2025-07-03 23:59:59') GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_sales_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id WHERE sc.need_analysis = true GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-03') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."id" IN (SELECT "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE ("collected_date" >= '2025-06-18 00:00:00') AND ("collected_date" <= '2025-07-03 23:59:59') GROUP BY "contract_id")) GROUP BY "sc"."id" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC) "c"
08:54:11.223	3.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=23) AND ("visit_date"='2025-07-03')
08:54:11.219	3.1 ms	yii\db\Command::query	SELECT sum(amount) as amount, sum(this_collected) as collected, sum(amount - collected) as uncollected, count(distinct client_id) as client_count, sum(collected_count) as collected_count FROM (SELECT sc., sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.amount - scp.collected) as uncollected, sum(sc.amount - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE ("t1"."collected_date" >= '2025-06-18 00:00:00') AND ("t1"."collected_date" <= '2025-07-03 23:59:59') GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc., case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_sales_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id WHERE sc.need_analysis = true GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-03') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."id" IN (SELECT "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE ("collected_date" >= '2025-06-18 00:00:00') AND ("collected_date" <= '2025-07-03 23:59:59') GROUP BY "contract_id")) GROUP BY "sc"."id" ORDER BY "signed_at" DESC) "sub"
08:54:11.164	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5016
08:54:11.162	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
08:54:11.168	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
08:54:11.227	1.1 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', 5016, 5, 'vue/analysis/sales-collected-payment-collection', '{"status":"","period":"last15days","to":"","from":"","dataUserId":"","group":"","page":"1","web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"code":2000,"result":{"list":[],"count":{"amount":"","collected":"","uncollected":"","client_count":0,"collected_count":""},"pagenation":{"totalcount":0,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 08:54:11') RETURNING "id"
08:54:11.226	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=10, "last_visit_at"='now()' WHERE "id"=49771