Performance Profiling

Total processing time: 53 ms; Peak memory: 5.130 MB. Show Profiling Timeline

总计31条数据

Time	Duration	Category	Info

14:01:19.440	7.6 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_erp_cost_tickets" ("need_handler", "wrote_date", "serial_no", "abstract", "description", "client_id", "project_id", "supplier_id", "purchase_contract_id", "contact_id", "verify_type", "created_by", "created_at", "status", "is_resubmitted", "amount", "settle_amount") VALUES (FALSE, '2025-09-15', 'FY-20250915-00002', '', '', NULL, 1111, NULL, NULL, 3649, 2, 1001, 'now()', 1, FALSE, '0', '0') RETURNING "id"
14:01:19.469	3.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
14:01:19.449	2.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\ErpCostTickets', 13, 'a:28:{s:2:"id";i:13;s:9:"serial_no";s:17:"FY-20250915-00002";s:10:"wrote_date";s:10:"2025-09-15";s:9:"client_id";N;s:17:"sales_contract_id";N;s:11:"supplier_id";N;s:20:"purchase_contract_id";s:0:"";s:6:"status";i:1;s:8:"abstract";s:0:"";s:11:"description";s:0:"";s:11:"verify_type";s:1:"2";s:16:"next_verify_user";N;s:21:"next_stop_verify_user";N;s:9:"verify_at";N;s:7:"stop_at";N;s:18:"refuse_description";N;s:14:"is_resubmitted";b:0;s:6:"amount";i:0;s:13:"settle_amount";i:0;s:10:"created_by";i:1001;s:16:"stop_description";N;s:9:"is_settle";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:11:"paid_amount";N;s:10:"contact_id";s:4:"3649";s:10:"project_id";s:4:"1111";s:12:"need_handler";s:1:"0";}', '', 1001, '114.246.237.213')
14:01:19.428	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:01:19.452	2.0 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20026) AND ("object_id"=13)
14:01:19.455	1.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, 9, 386, '55', '', 13, 385)
14:01:19.426	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:01:19.464	1.7 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at") VALUES (2, 20014, 'FY-20250915-00002', '2025-09-15', '', '', '55', NULL, NULL, NULL, NULL, 1001, '2025-09-15 14:01:19', '2025-09-15 14:01:19', 13, '2025-09-15 14:01:19.461384+08') RETURNING "id"
14:01:19.431	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:01:19.474	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-cost-ticket/save-new', '{"ErpCostTickets":{"id":"","auto_id":"3649","auto_name":"\u59da\u96ea\u7eaf(\u5ba2\u6237\uff1a\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240)","auto_type":"clientContact","need_handler":"0","auto_search_id":"1111","auto_search_name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf (2019-09-23)","contact_name":"\u59da\u96ea\u7eaf(\u5ba2\u6237\uff1a\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240)","wrote_date":"2025-09-15","serial_no":"FY-20250915-00002","abstract":"","description":"","client_id":"","client_name":"","project_id":"1111","project_name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf (2019-09-23)","supplier_id":"","supplier_name":"","purchase_contract_id":"","purchase_contract_name":"","contact_id":"3649","files":"","erpCostTicketVerifyRels":"","erpCostTicketAmounts":[{"id":"386","amount":"55","description":"","parent_id":"385"}],"erpCostTicketHandlers":""},"web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"id":13},"status":1,"msg":[{"name":"success","success":"\u65b0\u8d39\u7528\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-09-15 14:01:19') RETURNING "id"
14:01:19.467	1.1 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 13, 20014, 1001, '2025-09-15 14:01:19', '{"id":13,"serial_no":"FY-20250915-00002","wrote_date":"2025-09-15","client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"55","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 14:01:19","updated_at":"1970-01-01 08:00:00","paid_amount":null,"contact_id":3649,"project_id":1111,"need_handler":false}', '{"id":13,"serial_no":"FY-20250915-00002","wrote_date":"2025-09-15","client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"55","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 14:01:19","updated_at":"1970-01-01 08:00:00","paid_amount":null,"contact_id":3649,"project_id":1111,"need_handler":false}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5355\u7533\u8bf7","d4":[]}') RETURNING "id"
14:01:19.436	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_tickets" WHERE ("created_at" >= '2025-09-15 00:00:00') AND ("created_at" <= '2025-09-15 23:59:59') AND ("serial_no" ILIKE '%FY-20250915-%') AND (LENGTH(serial_no) = 17) ORDER BY "serial_no" DESC
14:01:19.458	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cost_tickets" SET "amount"='55', "next_verify_user"=NULL WHERE "id"=13
14:01:19.454	0.9 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=13) AND ("term_id"=18) AND ("object_type"=9)
14:01:19.473	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=720, "last_visit_at"='now()' WHERE "id"=56557
14:01:19.462	0.8 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\ErpCostTickets', 13, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.246.237.213')
14:01:19.459	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\ErpCostTickets', 13, 'a:1:{s:6:"amount";i:55;}', '', 1001, '114.246.237.213')
14:01:19.468	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\ObjectChangeLogs', 565369, 'a:13:{s:2:"id";i:565369;s:9:"object_id";i:13;s:11:"object_type";i:20014;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:591:"{"id":13,"serial_no":"FY-20250915-00002","wrote_date":"2025-09-15","client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"55","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 14:01:19","updated_at":"1970-01-01 08:00:00","paid_amount":null,"contact_id":3649,"project_id":1111,"need_handler":false}";s:9:"new_value";s:591:"{"id":13,"serial_no":"FY-20250915-00002","wrote_date":"2025-09-15","client_id":null,"sales_contract_id":null,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":"","description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"now()","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"55","settle_amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 14:01:19","updated_at":"1970-01-01 08:00:00","paid_amount":null,"contact_id":3649,"project_id":1111,"need_handler":false}";s:11:"description";s:99:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-15 14:01:19";s:9:"is_delete";N;}', '', 1001, '114.246.237.213')
14:01:19.465	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\ErpTicketChangeLogs', 518, 'a:17:{s:2:"id";i:518;s:9:"serial_no";s:17:"FY-20250915-00002";s:11:"ticket_type";i:20014;s:10:"wrote_date";s:10:"2025-09-15";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";N;s:8:"abstract";s:0:"";s:11:"description";s:0:"";s:9:"verify_at";s:29:"2025-09-15 14:01:19.461384+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-15 14:01:19";s:10:"updated_at";s:19:"2025-09-15 14:01:19";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:2:"55";s:9:"object_id";i:13;}', '', 1001, '114.246.237.213')
14:01:19.461	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cost_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=13
14:01:19.437	0.6 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_cost_tickets" WHERE "serial_no"='FY-20250915-00002')
14:01:19.439	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1111')
14:01:19.457	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_ticket_id"=13) ORDER BY "id"
14:01:19.439	0.4 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='3649')
14:01:19.460	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:01:19.466	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:01:19.463	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" WHERE "erp_cost_ticket_id"=13
14:01:19.438	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
14:01:19.463	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_tickets" WHERE "id"=13
14:01:19.460	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_tickets" WHERE "id"=13
14:01:19.460	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_ticket_id"=13) ORDER BY "id"