Performance Profiling

Total processing time: 274 ms; Peak memory: 5.491 MB. Show Profiling Timeline

总计30条数据

Time	Duration	Category	Info

13:33:56.922	21.3 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20001) AND ("object_id"=2222) AND ("remind_user_id"=1001) AND ("is_read"=FALSE)
13:33:56.716	17.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\Comments', 220963, 'a:11:{s:2:"id";i:220963;s:9:"object_id";i:2222;s:11:"object_type";s:5:"20001";s:6:"parent";N;s:11:"description";s:43:"刘人诚有一个采购订单需要审批";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:19:"CGDD-20260623-00001";}', '', 1001, '221.216.117.25')
13:33:56.695	9.6 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\ErpPurchaseOrderVerifyRels', 272, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '221.216.117.25')
13:33:56.946	1.4 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-purchase-order/verify', '{"id":"2222","description":"","web_access_token":"sHKfFzpC6AXRHThWzDm5OfadRXFFX-oO"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u8ba2\u5355\u5ba1\u6279\u901a\u8fc7","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-23 13:33:56', 266925568) RETURNING "id"
13:33:56.709	1.2 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_purchase_orders" SET "next_verify_user"=5064 WHERE "id"=2222
13:33:56.682	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5252
13:33:56.921	0.9 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (6, 'status', 2222, 20001, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u540c\u610f\u4e86","d3":"\u91c7\u8d2d\u8ba2\u5355\u7533\u8bf7","d4":""}')
13:33:56.919	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:33:56.715	0.8 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20001', 2222, '刘人诚有一个采购订单需要审批', TRUE, 'CGDD-20260623-00001') RETURNING "id"
13:33:56.684	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:33:56.734	0.5 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2222, '20001', 220963, 5064)
13:33:56.920	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:33:56.705	0.5 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_purchase_orders" SET "updated_at"='now()' WHERE "id"=2222
13:33:56.714	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
13:33:56.711	0.5 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\ErpPurchaseOrders', 2222, 'a:1:{s:16:"next_verify_user";i:5064;}', '', 1001, '221.216.117.25')
13:33:56.712	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2222
13:33:56.686	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:33:56.689	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"='2222'
13:33:56.736	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431
13:33:56.694	0.4 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_purchase_order_verify_rels" SET "status"=1, "description"='', "verify_at"='now()' WHERE "id"=272
13:33:56.690	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE ("status"=0) AND ("erp_purchase_order_id"=2222) ORDER BY "id"
13:33:56.681	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:33:56.707	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:33:56.705	0.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE ("status"=0) AND ("erp_purchase_order_id"=2222) ORDER BY "id") "c"
13:33:56.737	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4500
13:33:56.706	0.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\ErpPurchaseOrders', 2222, 'a:0:{}', '', 1001, '221.216.117.25')
13:33:56.707	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2222
13:33:56.708	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE ("status"=0) AND ("erp_purchase_order_id"=2222) ORDER BY "id"
13:33:56.735	0.3 ms	yii\db\Command::query	SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5064) AND ("id" != 1001) AND (channel_id IS NOT NULL)
13:33:56.708	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE ("status"=0) AND ("erp_purchase_order_id"=2222) ORDER BY "id"