Performance Profiling

Total processing time: 59 ms; Peak memory: 5.581 MB. Show Profiling Timeline

总计46条数据

Time	Duration	Category	Info

20:08:03.075	3.4 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\ErpCashCostTickets', 7333, 'a:0:{}', '', 1001, '114.246.236.177')
20:08:03.096	2.9 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "out_amount", "value", "object_id", "extra_int") VALUES (18, 11, 386, '111', '', 7333, 385)
20:08:03.058	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
20:08:03.085	2.1 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" ("erp_cash_cost_ticket_id", "user_id", "status") VALUES (7333, 1001, 0)
20:08:03.091	2.1 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" ("erp_cash_cost_ticket_id", "user_id", "amount", "pct") VALUES (7333, 1001, '111', '100')
20:08:03.078	2.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20032) AND ("object_id"=7333)
20:08:03.056	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:08:03.069	1.8 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "serial_no"='XJFYD-20250811-00001' LIMIT 2
20:08:03.066	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_cash_cost_ticket_id"=7333) ORDER BY "id"
20:08:03.080	1.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20032) AND ("object_id"=7333)
20:08:03.084	1.5 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" WHERE "erp_cash_cost_ticket_id"=7333
20:08:03.061	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
20:08:03.107	1.3 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\ErpCashCostTicketPurchaseContractSettles', 10, 'a:5:{s:2:"id";i:10;s:23:"erp_cash_cost_ticket_id";i:7333;s:20:"purchase_contract_id";s:4:"4080";s:6:"amount";s:3:"111";s:11:"description";N;}', '', 1001, '114.246.236.177')
20:08:03.111	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', 1001, 5, 'vue/erp-cash-cost-ticket/save-edit', '{"ErpCashCostTickets":{"id":"7333","auto_id":"431","auto_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","auto_type":"supplier","auto_search_id":"4080","auto_search_name":"222222","wrote_date":"2025-08-11","serial_no":"XJFYD-20250811-00001","erpCashCostTicketVerifyRels":["1001"],"abstract":"\u65b9\u5f0f\u5730\u65b9","description":"","client_id":"","client_name":"","sales_contract_id":"","sales_contract_name":"","supplier_id":"431","supplier_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","purchase_contract_id":"4080","purchase_contract_name":"222222","files":"","erpCashCostTicketAmounts":[{"id":"386","amount":"111","description":"","parent_id":"385"}],"erpCashCostTicketBankOuts":[{"amount":"111","id":"1","description":""}],"erpCashCostTicketHandlers":[{"user_id":"1001","amount":"111","pct":"100"}],"erpCashCostTicketSalesContractSettles":"","erpCashCostTicketPurchaseContractSettles":[{"id":"","purchase_contract_id":"4080","amount":"111"}]},"web_access_token":"J23LUPtW6VCG7IfkCPCVdqFa_zEBghkd"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u73b0\u91d1\u8d39\u7528\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-11 20:08:03') RETURNING "id"
20:08:03.082	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_verify_rels" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id"
20:08:03.073	1.0 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "client_id"=NULL, "sales_contract_id"=NULL, "supplier_id"=431, "purchase_contract_id"=4080 WHERE "id"=7333
20:08:03.106	1.0 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" ("erp_cash_cost_ticket_id", "purchase_contract_id", "amount") VALUES (7333, 4080, '111') RETURNING "id"
20:08:03.090	1.0 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" WHERE "erp_cash_cost_ticket_id"=7333
20:08:03.101	0.9 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" ("erp_cash_cost_ticket_id", "erp_bank_id", "amount", "description") VALUES (7333, 1, '111', '')
20:08:03.105	0.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333
20:08:03.109	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\ErpCashCostTickets', 7333, 'a:0:{}', '', 1001, '114.246.236.177')
20:08:03.108	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "amount"='111' WHERE "id"=7333
20:08:03.095	0.7 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7333) AND ("term_id"=18) AND ("object_type"=11)
20:08:03.088	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" WHERE "erp_cash_cost_ticket_id"=7333
20:08:03.101	0.6 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=7333
20:08:03.064	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"='7333'
20:08:03.094	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=11) AND ("object_id"=7333) ORDER BY "id"
20:08:03.071	0.4 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431')
20:08:03.072	0.4 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4080')
20:08:03.104	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4080
20:08:03.094	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=386
20:08:03.100	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
20:08:03.089	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
20:08:03.103	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id"
20:08:03.073	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
20:08:03.090	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001'
20:08:03.102	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id"
20:08:03.099	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=7333 ORDER BY "id"
20:08:03.088	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_carbon_copy_rels" WHERE "erp_cash_cost_ticket_id"=7333
20:08:03.072	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
20:08:03.110	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=7333
20:08:03.104	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4080'
20:08:03.095	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='386'
20:08:03.100	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='1'
20:08:03.103	0.1 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=7333
20:08:03.088	0.1 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_carbon_copy_rels" WHERE "erp_cash_cost_ticket_id"=7333