Performance Profiling

Total processing time: 48 ms; Peak memory: 4.947 MB. Show Profiling Timeline

总计41条数据

Time	Duration	Category	Info

11:18:24.132	3.4 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (3851, 1001) RETURNING "id"
11:18:24.127	3.2 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 2)
11:18:24.123	2.3 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "reminded") VALUES (3851, '2025-07-04', '800', FALSE) RETURNING "id"
11:18:24.106	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:18:24.104	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:18:24.118	1.2 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContracts', 3851, 'a:2:{s:31:"payment_collection_remind_ahead";s:5:"0 day";s:18:"save_collection_at";s:5:"now()";}', '', 1001, '114.254.1.137')
11:18:24.109	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:18:24.139	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE ("contract_id"=3851) AND (amount > 0) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
11:18:24.148	1.0 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', 1001, 5, 'vue/purchase-contract/save-remind-date', '{"PurchaseContracts":{"id":"3851","budget":"867867","purchaseContractPaymentCollectionRemindDates":{"2025-07-04":"800"},"purchaseContractPaymentCollectionRemindReceivers":["1001"],"payment_collection_remind_ahead":""},"web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-07-04 11:18:24') RETURNING "id"
11:18:24.117	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "updated_at"='now()', "payment_collection_remind_ahead"='0 day', "save_collection_at"='now()' WHERE "id"=3851
11:18:24.137	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='0' WHERE "contract_id"=3851
11:18:24.126	0.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=2)
11:18:24.145	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContractPaymentCollectionRemindDates', 628, 'a:0:{}', '', 1001, '114.254.1.137')
11:18:24.135	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContractPaymentCollectionRemindReceivers', 1027, 'a:3:{s:2:"id";i:1027;s:11:"contract_id";i:3851;s:7:"user_id";s:4:"1001";}', '', 1001, '114.254.1.137')
11:18:24.141	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContractPaymentCollectionRemindDates', 628, 'a:1:{s:11:"paid_amount";i:1;}', '', 1001, '114.254.1.137')
11:18:24.143	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContractPayments', 2101, 'a:1:{s:11:"paid_amount";s:1:"0";}', '', 1001, '114.254.1.137')
11:18:24.125	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\PurchaseContractPaymentCollectionRemindDates', 628, 'a:8:{s:2:"id";i:628;s:11:"contract_id";i:3851;s:11:"remind_date";s:10:"2025-07-04";s:8:"reminded";b:0;s:6:"amount";i:800;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;}', '', 1001, '114.254.1.137')
11:18:24.131	0.7 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=3851
11:18:24.121	0.7 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=3851
11:18:24.138	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=3851
11:18:24.140	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='1' WHERE "id"=628
11:18:24.147	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\PurchaseContractPayments', 2102, 'a:1:{s:11:"paid_amount";i:799;}', '', 1001, '114.254.1.137')
11:18:24.145	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='800', "overdue_days"=0, "status"=1 WHERE "id"=628
11:18:24.142	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='1' WHERE "id"=2101
11:18:24.146	0.6 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contract_payments" SET "paid_amount"='799' WHERE "id"=2102
11:18:24.112	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3851'
11:18:24.144	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE ("contract_id"=3851) AND (amount > 0) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
11:18:24.115	0.4 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689)
11:18:24.120	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689
11:18:24.120	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=3851
11:18:24.131	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=3851
11:18:24.140	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=3851) AND (amount > paid_amount) ORDER BY "remind_date"
11:18:24.115	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
11:18:24.144	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=3851) AND (amount > paid_amount) ORDER BY "remind_date"
11:18:24.148	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=3851) AND (amount > paid_amount) ORDER BY "remind_date"
11:18:24.123	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3851)
11:18:24.117	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
11:18:24.116	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=689)
11:18:24.115	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
11:18:24.136	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=3851
11:18:24.116	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)