ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6943aa01206d5: POST https://beta.jinchangxiao.com/vue/erp-sales-gift/save-new-sn at 2025-12-18 03:15:13 pm by 223.72.15.22

Performance Profiling

Total processing time: 156 ms; Peak memory: 3.967 MB. Show Profiling Timeline

总计40条数据
TimeDurationCategoryInfo
  
15:15:13.14018.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:15:13.20011.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" ("erp_purchase_inbound_product_id", "sn") VALUES (171, '阿文企鹅')
15:15:13.2668.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-12-18')
15:15:13.1586.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:15:13.1746.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:15:13.2594.2 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', 2094, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.2533.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='142' WHERE "id"=185
15:15:13.2503.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id"=171
15:15:13.2433.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2094
15:15:13.2222.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (226, 16, '阿文企鹅') RETURNING "id"
15:15:13.2802.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-gift/save-new-sn', '{"id":"226","sns":["\u963f\u6587\u4f01\u9e45"],"web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 15:15:13') RETURNING "id"
15:15:13.2772.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1056, "last_visit_at"='now()' WHERE "id"=59588
15:15:13.1832.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:15:13.2572.0 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', 185, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.2401.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2094
15:15:13.2361.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id"=1624
15:15:13.2181.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', 226, 'a:1:{s:9:"inventory";s:3:"139";}', '', 1001, '223.72.15.22')
15:15:13.2161.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='142', "inventory"='142', "total_amount"='143704' WHERE "id"=226
15:15:13.2271.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='139' WHERE "id"=226
15:15:13.1951.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"='226'
15:15:13.2311.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='140668' WHERE "id"=226
15:15:13.2291.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
15:15:13.2320.9 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', 226, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.2130.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=87
15:15:13.2340.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='3', "inventory"='139' WHERE "id"=171
15:15:13.2380.9 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', 87, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.2280.9 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', 226, 'a:1:{s:9:"inventory";d:139;}', '', 1001, '223.72.15.22')
15:15:13.2350.9 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', 171, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.2250.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSns', 19, 'a:21:{s:2:"id";i:19;s:24:"erp_inventory_product_id";i:226;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:16;s:2:"sn";s:12:"阿文企鹅";s:7:"is_used";N;s:11:"description";N;s:22:"erp_inventory_start_id";N;s:33:"erp_inventory_start_product_sn_id";N;s:22:"erp_inventory_build_id";N;s:33:"erp_inventory_build_product_sn_id";N;s:26:"used_erp_inventory_lost_id";N;s:27:"used_erp_inventory_build_id";N;s:37:"used_erp_inventory_lost_product_sn_id";N;s:44:"used_erp_inventory_build_spent_product_sn_id";N;s:26:"used_erp_sales_outbound_id";N;s:43:"used_erp_sales_outbound_spent_product_sn_id";N;s:31:"erp_purchase_gift_product_sn_id";N;s:20:"erp_purchase_gift_id";N;s:22:"used_erp_sales_gift_id";N;s:39:"used_erp_sales_gift_spent_product_sn_id";N;}', '', 1001, '223.72.15.22')
15:15:13.1970.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=171
15:15:13.2200.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=226) AND ("erp_purchase_inbound_product_sn_id" NOT IN (13, 16))
15:15:13.2260.6 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=226
15:15:13.2210.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=226
15:15:13.2490.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=87
15:15:13.2140.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_inbound_id"=87
15:15:13.2150.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=171
15:15:13.2470.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id"=185
15:15:13.2390.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0' WHERE ("erp_purchase_inbound_id"=87) AND ("erp_purchase_inbound_product_id"<>171)
15:15:13.2190.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=171
15:15:13.2310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'