ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a5719fbd773a: POST https://beta.jinchangxiao.com/vue/erp-purchase-inbound/save-sn at 2026-07-15 01:26:19 pm by 114.244.130.61

Performance Profiling

Total processing time: 54 ms; Peak memory: 4.423 MB. Show Profiling Timeline

总计63条数据
TimeDurationCategoryInfo
  
13:26:19.9321.1 msyii\db\Command::queryINSERT 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-inbound/save-sn', '{"ErpPurchaseInbounds":{"erpPurchaseInboundProducts":{"442":{"product_id":"2267","number":"2","amount":"300","total_amount":"600.00","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":{"84":{"sn":"D3200P22"},"83":{"sn":"6978252856697"}}},"443":{"product_id":"2171","number":"1","amount":"600","total_amount":"600.00","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":{"85":{"sn":"6978252856697"}}}},"id":"220"},"web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5165\u5e93\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-15 13:26:19', 48551936) RETURNING "id"
13:26:19.8920.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"='220'
13:26:19.9060.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=550
13:26:19.9190.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInboundProducts', 443, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.8860.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:26:19.8870.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:26:19.9170.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='600' WHERE "id"=551
13:26:19.9050.5 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=550
13:26:19.9200.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (2267, 2171)
13:26:19.8890.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:26:19.9140.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=551
13:26:19.9170.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 551, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9080.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='600' WHERE "id"=550
13:26:19.9210.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0', "actual_total_amount"='0' WHERE ("erp_purchase_inbound_id"=220) AND ("erp_purchase_inbound_product_id" NOT IN (442, 443))
13:26:19.9100.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=443
13:26:19.9070.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 550, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9250.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id" IN (215, 216, 220)
13:26:19.9180.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='0', "inventory"='1' WHERE "id"=443
13:26:19.9260.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_returns" WHERE "id" IN (6, 8)
13:26:19.9010.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=442
13:26:19.9220.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2223
13:26:19.8940.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=442
13:26:19.8960.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInboundProductSns', 84, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9240.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id" IN (447, 448)
13:26:19.9140.4 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=551
13:26:19.9110.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='1', "inventory"='1', "total_amount"='600' WHERE "id"=551
13:26:19.9280.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseOrderProducts', 447, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9020.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='2', "inventory"='2', "total_amount"='600' WHERE "id"=550
13:26:19.9230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2223
13:26:19.9130.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=551
13:26:19.9040.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=550
13:26:19.9160.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
13:26:19.9210.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInbounds', 220, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9090.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='0', "inventory"='2' WHERE "id"=442
13:26:19.9290.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseOrderProducts', 448, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.8970.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInboundProductSns', 83, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9120.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 551, 'a:1:{s:12:"total_amount";s:6:"600.00";}', '', 1001, '114.244.130.61')
13:26:19.9270.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='12' WHERE "id"=447
13:26:19.9000.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_inbound_id"=220
13:26:19.9030.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=550) AND ("erp_purchase_inbound_product_sn_id" NOT IN (83, 84))
13:26:19.9020.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 550, 'a:1:{s:12:"total_amount";s:6:"600.00";}', '', 1001, '114.244.130.61')
13:26:19.8850.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:26:19.9250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id" IN (434, 435, 436, 437, 442, 443)
13:26:19.8990.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInboundProductSns', 85, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9090.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 550, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9150.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
13:26:19.9130.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=551) AND ("erp_purchase_inbound_product_sn_id"<>85)
13:26:19.9290.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='2' WHERE "id"=448
13:26:19.8980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=443
13:26:19.9070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
13:26:19.9300.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseOrders', 2223, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9150.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 551, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9100.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInboundProducts', 442, 'a:0:{}', '', 1001, '114.244.130.61')
13:26:19.9120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=443
13:26:19.9080.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
13:26:19.8950.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=442
13:26:19.9030.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=442
13:26:19.8960.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "id"=84
13:26:19.8970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "id"=83
13:26:19.8990.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=443
13:26:19.8990.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "id"=85
13:26:19.8980.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1
13:26:19.9000.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1