6a4909bf40a19: POST https://beta.jinchangxiao.com/vue/erp-purchase-inbound/save-sn at 2026-07-04 09:25:19 pm by 111.194.208.14
Performance Profiling
Total processing time: 80 ms; Peak memory: 4.581 MB. Show Profiling Timeline
总计101条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 21:25:19.302 | 1.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0' WHERE "id"=93 |
| 21:25:19.290 | 1.6 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 58, '申请类型') RETURNING "id" |
| 21:25:19.339 | 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", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-purchase-inbound/save-sn', '{"ErpPurchaseInbounds":{"erpPurchaseInboundProducts":{"42":{"product_id":"1943","number":"10","amount":"15","total_amount":"150","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":{"new":[{"sn":"\u7533\u8bf7\u7c7b\u578b"},{"sn":"\u63d0\u524d\u5f00\u53d1\u7968\u7533\u8bf7"},{"sn":"\u4ed8\u6b3e\u7533\u8bf7"},{"sn":"\u6b63\u5e38\u5f00\u7968"},{"sn":"\u5176\u4ed6"},{"sn":"\u8bf7\u5047\u7533\u8bf7"},{"sn":"\u6b63\u5e38\u5907\u8d27"},{"sn":"0\u51fa\u5e93\u7533\u8bf7"},{"sn":"\u63d0\u524d\u5907\u8d27\u7533\u8bf7"}]}},"43":{"product_id":"1373","number":"10","amount":"37.5","total_amount":"375","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":{"new":[{"sn":"79"},{"sn":"78"},{"sn":"77"}]}},"44":{"product_id":"1372","number":"10","amount":"25","total_amount":"250","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":""}},"id":"26"},"web_access_token":"wx4hXh9V-DIrZeBjtGStxgwx5HvDWnxk"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5165\u5e93\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-07-04 21:25:19', 73641984) RETURNING "id" |
| 21:25:19.279 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" ("erp_purchase_inbound_product_id", "sn") VALUES (42, '申请类型'), (42, '提前开发票申请'), (42, '付款申请'), (42, '正常开票'), (42, '其他'), (42, '请假申请'), (42, '正常备货'), (42, '0出库申请'), (42, '提前备货申请') |
| 21:25:19.287 | 0.9 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\ErpInventoryProducts', 93, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.269 | 0.9 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 21:25:19.301 | 0.7 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=93 |
| 21:25:19.271 | 0.7 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 21:25:19.327 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (1943, 1373, 1372) |
| 21:25:19.305 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 21:25:19.296 | 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 ('INSERT', 'app\models\ErpInventoryProductSns', 75, 'a:27:{s:2:"id";i:75;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:62;s:2:"sn";s:6:"其他";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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.329 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2042 |
| 21:25:19.273 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 21:25:19.285 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='10', "inventory"='10', "total_amount"='150' WHERE "id"=93 |
| 21:25:19.314 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0' WHERE "id"=94 |
| 21:25:19.332 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id" IN (42, 44, 43) |
| 21:25:19.316 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='0' WHERE "id"=94 |
| 21:25:19.276 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"='26' |
| 21:25:19.324 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='225' WHERE "id"=95 |
| 21:25:19.322 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='9' WHERE "id"=95 |
| 21:25:19.333 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='10' WHERE "id"=62 |
| 21:25:19.268 | 0.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 21:25:19.292 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 59, '提前开发票申请') RETURNING "id" |
| 21:25:19.278 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=42 |
| 21:25:19.284 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=42 |
| 21:25:19.296 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 62, '其他') RETURNING "id" |
| 21:25:19.330 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2042 |
| 21:25:19.297 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 63, '请假申请') RETURNING "id" |
| 21:25:19.293 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 60, '付款申请') RETURNING "id" |
| 21:25:19.294 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 61, '正常开票') RETURNING "id" |
| 21:25:19.328 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0', "actual_total_amount"='0' WHERE ("erp_purchase_inbound_id"=26) AND ("erp_purchase_inbound_product_id" NOT IN (42, 43, 44)) |
| 21:25:19.332 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=26 |
| 21:25:19.331 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id" IN (62, 63, 64) |
| 21:25:19.311 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (94, 67, '79') RETURNING "id" |
| 21:25:19.308 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=43 |
| 21:25:19.313 | 0.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (94, 69, '77') RETURNING "id" |
| 21:25:19.292 | 0.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\ErpInventoryProductSns', 71, 'a:27:{s:2:"id";i:71;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:58;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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.307 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='10', "inventory"='0' WHERE "id"=42 |
| 21:25:19.312 | 0.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (94, 68, '78') RETURNING "id" |
| 21:25:19.319 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=44 |
| 21:25:19.318 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='10', "inventory"='0' WHERE "id"=43 |
| 21:25:19.293 | 0.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\ErpInventoryProductSns', 72, 'a:27:{s:2:"id";i:72;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:59;s:2:"sn";s:21:"提前开发票申请";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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.300 | 0.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 66, '提前备货申请') RETURNING "id" |
| 21:25:19.288 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=93) AND ("erp_purchase_inbound_product_sn_id" NOT IN (58, 59, 60, 61, 62, 63, 64, 65, 66)) |
| 21:25:19.298 | 0.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 64, '正常备货') RETURNING "id" |
| 21:25:19.295 | 0.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\ErpInventoryProductSns', 74, 'a:27:{s:2:"id";i:74;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:61;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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.334 | 0.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 ('UPDATE', 'app\models\ErpPurchaseOrderProducts', 62, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.294 | 0.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\ErpInventoryProductSns', 73, 'a:27:{s:2:"id";i:73;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:60;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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.312 | 0.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\ErpInventoryProductSns', 81, 'a:27:{s:2:"id";i:81;s:24:"erp_inventory_product_id";i:94;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:68;s:2:"sn";s:2:"78";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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.322 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=95 |
| 21:25:19.314 | 0.3 ms | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=94 |
| 21:25:19.299 | 0.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 65, '0出库申请') RETURNING "id" |
| 21:25:19.320 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='10', "inventory"='10', "total_amount"='250' WHERE "id"=95 |
| 21:25:19.317 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 94, 'a:1:{s:19:"actual_total_amount";s:3:"0.0";}', '', 1001, '111.194.208.14') |
| 21:25:19.282 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" ("erp_purchase_inbound_product_id", "sn") VALUES (43, '79'), (43, '78'), (43, '77') |
| 21:25:19.284 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_inbound_id"=26 |
| 21:25:19.281 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=43 |
| 21:25:19.308 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='10', "inventory"='10', "total_amount"='375' WHERE "id"=94 |
| 21:25:19.328 | 0.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 ('UPDATE', 'app\models\ErpPurchaseInbounds', 26, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.336 | 0.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 ('UPDATE', 'app\models\ErpPurchaseOrders', 2042, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.323 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 95, 'a:1:{s:9:"inventory";d:9;}', '', 1001, '111.194.208.14') |
| 21:25:19.301 | 0.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\ErpInventoryProductSns', 79, 'a:27:{s:2:"id";i:79;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:66;s:2:"sn";s:18:"提前备货申请";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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.311 | 0.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\ErpInventoryProductSns', 80, 'a:27:{s:2:"id";i:80;s:24:"erp_inventory_product_id";i:94;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:67;s:2:"sn";s:2:"79";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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.298 | 0.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\ErpInventoryProductSns', 76, 'a:27:{s:2:"id";i:76;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:63;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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.320 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 95, 'a:1:{s:9:"inventory";s:1:"9";}', '', 1001, '111.194.208.14') |
| 21:25:19.304 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 93, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.289 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=93 |
| 21:25:19.309 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 94, 'a:1:{s:9:"inventory";s:1:"0";}', '', 1001, '111.194.208.14') |
| 21:25:19.310 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=94 |
| 21:25:19.334 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='10' WHERE "id"=63 |
| 21:25:19.279 | 0.3 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=42 |
| 21:25:19.299 | 0.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\ErpInventoryProductSns', 77, 'a:27:{s:2:"id";i:77;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:64;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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.306 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 93, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.300 | 0.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\ErpInventoryProductSns', 78, 'a:27:{s:2:"id";i:78;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:65;s:2:"sn";s:13:"0出库申请";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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.306 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 21:25:19.315 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 94, 'a:1:{s:9:"inventory";i:0;}', '', 1001, '111.194.208.14') |
| 21:25:19.335 | 0.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 ('UPDATE', 'app\models\ErpPurchaseOrderProducts', 63, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.283 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=44 |
| 21:25:19.325 | 0.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 ('UPDATE', 'app\models\ErpInventoryProducts', 95, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.318 | 0.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 ('UPDATE', 'app\models\ErpPurchaseInboundProducts', 43, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.313 | 0.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\ErpInventoryProductSns', 82, 'a:27:{s:2:"id";i:82;s:24:"erp_inventory_product_id";i:94;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:69;s:2:"sn";s:2:"77";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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14') |
| 21:25:19.321 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=95 |
| 21:25:19.326 | 0.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 ('UPDATE', 'app\models\ErpPurchaseInboundProducts', 44, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.315 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 21:25:19.325 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='1', "inventory"='9' WHERE "id"=44 |
| 21:25:19.307 | 0.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 ('UPDATE', 'app\models\ErpPurchaseInboundProducts', 42, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.310 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=94) AND ("erp_purchase_inbound_product_sn_id" NOT IN (67, 68, 69)) |
| 21:25:19.288 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=42 |
| 21:25:19.335 | 0.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 ('UPDATE', 'app\models\ErpPurchaseOrderProducts', 64, 'a:0:{}', '', 1001, '111.194.208.14') |
| 21:25:19.335 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='10' WHERE "id"=64 |
| 21:25:19.323 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 21:25:19.321 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=44 |
| 21:25:19.309 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=43 |
| 21:25:19.281 | 0.2 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=43 |
| 21:25:19.316 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 21:25:19.324 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 21:25:19.281 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1 |
| 21:25:19.321 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=95) |
| 21:25:19.283 | 0.2 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=44 |
| 21:25:19.282 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1 |
| 21:25:19.283 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1 |