ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7cc1144292: POST https://beta.jinchangxiao.com/vue/erp-inventory-build/search-product-list at 2025-09-15 04:19:29 pm by 114.246.237.213

Performance Profiling

Total processing time: 75 ms; Peak memory: 3.918 MB. Show Profiling Timeline

总计19条数据
TimeDurationCategoryInfo
  
16:19:29.31113.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id WHERE ("eip"."is_build"=FALSE) AND ((eip.inventory > 0) OR (0=1)) GROUP BY "eip"."id" ORDER BY eip.created_at DESC) "c"
16:19:29.2966.8 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_inventory_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
16:19:29.3306.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1040, 2095, 1812, 2098, 2097, 2096, 1624, 1372, 2106, 2105, 2099, 1025, 2086, 2085, 39, 672, 2084, 2083)
16:19:29.2915.2 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_inventory_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
16:19:29.3384.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (172, 1685, 1683, 1686, 1684, 1693, 1692, 1578, 421, 80, 714, 1047, 1691, 1523, 1382, 633)
16:19:29.3443.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
16:19:29.3252.7 msyii\db\Command::querySELECT eip.* FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" LEFT JOIN "a57be577deb434"."tbl_products" "p" ON eip.product_id = p.id LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epis" ON epis.id = eip.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_projects" "epips" ON epis.id = epips.erp_purchase_inbound_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_starts" "eiss" ON eiss.id = eip.erp_inventory_start_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eibs" ON eibs.id = eip.erp_inventory_build_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epgs" ON epgs.id = eip.erp_purchase_gift_id WHERE ("eip"."is_build"=FALSE) AND ((eip.inventory > 0) OR (0=1)) GROUP BY "eip"."id" ORDER BY eip.created_at DESC LIMIT 20
16:19:29.2822.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:19:29.2862.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:19:29.2801.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:19:29.3491.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-inventory-build/search-product-list', '{"page":"1","ErpInventoryBuilds":{"erpInventoryBuildSpentProducts":""},"web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"list":[{"id":107,"product_id":1040,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-09-05","number":"6","outbound":"2","inventory":"4","amount":"18","total_amount":"108","actual_amount":"18","actual_total_amount":"72","is_build":false,"created_at":"2025-09-05 15:11:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":2,"erp_inventory_build_product_id":2,"build_spent_outbound":"","sales_outbound":"2","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{"id":2,"key":2,"name":"CZD-20250905-00001"},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":1040,"name":"\u5b81\u76fe\u4ee4\u724c\u8f6f\u4ef6V1.0","product_type":7,"product_component":32,"product_brand":137,"product_serie":633,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-25 16:31:25","updated_at":"2025-09-12 15:58:12","pinyin_shortcut":"ndlprjV10","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":32,"key":32,"name":"\u9632\u75c5\u6bd2\u8f6f\u4ef6"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":633,"key":633,"name":"\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CZD-20250905-00001"},{"id":104,"product_id":2095,"erp_purchase_inbound_id":34,"erp_purchase_order_id":2043,"erp_purchase_inbound_product_id":57,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-09-03","number":"100","outbound":"1","inventory":"99","amount":"849","total_amount":"10000","actual_amount":"849","actual_total_amount":"84051","is_build":false,"created_at":"2025-09-03 17:15:27","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":34,"key":34,"name":"CGRK-20250903-00002","supplier_id":725,"purchase_contract_id":4128},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":"","product_qa":"","pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"serial_no":"CGRK-20250903-00002"},{"id":103,"product_id":2095,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-29","number":"2","outbound":"1","inventory":"1","amount":"849","total_amount":"150000","actual_amount":"849","actual_total_amount":"849","is_build":false,"created_at":"2025-08-29 12:32:29","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":1,"erp_inventory_build_product_id":1,"build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{"id":1,"key":1,"name":"CZD-20250829-00001"},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2095,"name":"SA3610","product_type":3,"product_component":14,"product_brand":27,"product_serie":1691,"product_misc":"","product_qa":"","pn":"","description":"2U\u673a\u67b6\u5f0f12 \u69fd\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0cCPU\uff1aIntel\u00ae Xeon\u00ae D-1567\uff1b\u5185\u5b58\uff1a16 GB DDR4 ECC RDIMM\uff08\u53ef\u6269\u5145\u81f3 128 GB\uff09\uff1b12 x 3.5 \u82f1\u5bf8 Synology SAS\/SATA HDD\u30012.5 \u82f1\u5bf8 Synology SATA SSD \u6216 2.5 \u82f1\u5bf8 SAS SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff1b\u652f\u6301\u70ed\u63d2\u62d4\u786c\u76d8\uff1b2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (Mini-SAS HD)\uff1b5\u5e74\u4fdd\u4fee\u3002","created_by":1013,"created_at":"2025-08-14 09:06:15","updated_at":"2025-09-04 11:02:52","pinyin_shortcut":"SA3610","product_unit":1,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1691,"key":1691,"name":"SA3610 NAS\u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"serial_no":"CZD-20250829-00001"},{"id":102,"product_id":1812,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":54,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"2","outbound":"1","inventory":"1","amount":"550","total_amount":"1100","actual_amount":"550","actual_total_amount":"550","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":32,"key":32,"name":"CGRK-20250828-00002","supplier_id":68,"purchase_contract_id":4092},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":1812,"name":"RKS-02","product_type":3,"product_component":39,"product_brand":27,"product_serie":1523,"product_misc":"","product_qa":"","pn":"","description":"Synology RKS-02 \u53ef\u673a\u67b6\u5b89\u88c5 \u9f7f\u8f68 \u7528\u4e8e \u670d\u52a1\u5668","created_by":1013,"created_at":"2024-10-09 11:33:47","updated_at":"2025-09-15 10:46:14","pinyin_shortcut":"RKS02","product_unit":2,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1523,"key":1523,"name":"\u673a\u67b6\u5bfc\u8f68\u5957\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CGRK-20250828-00002"},{"id":101,"product_id":2098,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":53,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"2","outbound":"0","inventory":"2","amount":"1278","total_amount":"2556","actual_amount":"1278","actual_total_amount":"2556","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":32,"key":32,"name":"CGRK-20250828-00002","supplier_id":68,"purchase_contract_id":4092},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2098,"name":"M2D20","product_type":3,"product_component":39,"product_brand":27,"product_serie":1578,"product_misc":"","product_qa":"","pn":"","description":"M.2 SSD \u9002\u914d\u5668","created_by":1013,"created_at":"2025-08-14 09:09:02","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"M2D20","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1578,"key":1578,"name":"\u5b58\u50a8\u9002\u914d\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"serial_no":"CGRK-20250828-00002"},{"id":100,"product_id":2097,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":52,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"4","outbound":"0","inventory":"4","amount":"2130","total_amount":"8520","actual_amount":"2130","actual_total_amount":"8520","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":32,"key":32,"name":"CGRK-20250828-00002","supplier_id":68,"purchase_contract_id":4092},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2097,"name":"SNV3510-800G","product_type":3,"product_component":15,"product_brand":27,"product_serie":1693,"product_misc":"","product_qa":"","pn":"","description":"800G M.2 NVMe SSD","created_by":1013,"created_at":"2025-08-14 09:08:19","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"SNV3510800G","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1693,"key":1693,"name":"800G SSD\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"serial_no":"CGRK-20250828-00002"},{"id":99,"product_id":2096,"erp_purchase_inbound_id":32,"erp_purchase_order_id":2026,"erp_purchase_inbound_product_id":51,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"20","outbound":"0","inventory":"20","amount":"2990","total_amount":"59800","actual_amount":"2990","actual_total_amount":"59800","is_build":false,"created_at":"2025-08-29 11:30:38","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":32,"key":32,"name":"CGRK-20250828-00002","supplier_id":68,"purchase_contract_id":4092},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2096,"name":"HAT5300-12T","product_type":3,"product_component":15,"product_brand":27,"product_serie":1692,"product_misc":"","product_qa":"","pn":"","description":"12TB 3.5\" SATA HDD","created_by":1013,"created_at":"2025-08-14 09:07:32","updated_at":"2025-08-29 11:30:38","pinyin_shortcut":"HAT530012T","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1692,"key":1692,"name":"12TB 3.5\" SATA \u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"serial_no":"CGRK-20250828-00002"},{"id":97,"product_id":1624,"erp_purchase_inbound_id":31,"erp_purchase_order_id":2038,"erp_purchase_inbound_product_id":49,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"14","outbound":"13","inventory":"1","amount":"1393","total_amount":"19502","actual_amount":"1393","actual_total_amount":"1393","is_build":false,"created_at":"2025-08-28 14:12:06","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"13","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":31,"key":31,"name":"CGRK-20250828-00001","supplier_id":90,"purchase_contract_id":4122},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2025-09-04 11:42:10","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CGRK-20250828-00001"},{"id":95,"product_id":1372,"erp_purchase_inbound_id":26,"erp_purchase_order_id":2042,"erp_purchase_inbound_product_id":44,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-27","number":"10","outbound":"0","inventory":"10","amount":"25","total_amount":"250","actual_amount":"25","actual_total_amount":"250","is_build":false,"created_at":"2025-08-27 13:18:21","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":26,"key":26,"name":"CGRK-20250827-00001","supplier_id":478,"purchase_contract_id":4127},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"serial_no":"CGRK-20250827-00001"},{"id":81,"product_id":2106,"erp_purchase_inbound_id":22,"erp_purchase_order_id":2019,"erp_purchase_inbound_product_id":36,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-21","number":"6","outbound":"0","inventory":"6","amount":"3927.72","total_amount":"23566.32","actual_amount":"3927.72","actual_total_amount":"23566.32","is_build":false,"created_at":"2025-08-21 17:31:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":22,"key":22,"name":"CGRK-20250821-00006","supplier_id":236,"purchase_contract_id":4097},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2106,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:35:15","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B1500","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CGRK-20250821-00006"},{"id":80,"product_id":2105,"erp_purchase_inbound_id":22,"erp_purchase_order_id":2019,"erp_purchase_inbound_product_id":35,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-21","number":"2","outbound":"1","inventory":"1","amount":"33702.84","total_amount":"67405.68","actual_amount":"33702.84","actual_total_amount":"33702.84","is_build":false,"created_at":"2025-08-21 17:31:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":22,"key":22,"name":"CGRK-20250821-00006","supplier_id":236,"purchase_contract_id":4097},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2105,"name":"\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u7cfb\u7edf\u8f6f\u4ef6V13.0\uff08\u9002\u7528\u4e8eAC-1000-B1500\uff09","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-08-19 11:34:25","updated_at":"2025-09-15 10:47:16","pinyin_shortcut":"sxfqwxwglxtrjV130syyAC1000B1500","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CGRK-20250821-00006"},{"id":79,"product_id":2099,"erp_purchase_inbound_id":22,"erp_purchase_order_id":2019,"erp_purchase_inbound_product_id":34,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-21","number":"2","outbound":"0","inventory":"2","amount":"5014","total_amount":"10028","actual_amount":"5014","actual_total_amount":"10028","is_build":false,"created_at":"2025-08-21 17:31:40","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":22,"key":22,"name":"CGRK-20250821-00006","supplier_id":236,"purchase_contract_id":4097},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2099,"name":"AC-1000-B1500","product_type":4,"product_component":23,"product_brand":12,"product_serie":172,"product_misc":"","product_qa":"","pn":"","description":"\u6027\u80fd\u53c2\u6570\uff1a\u7f51\u7edc\u5c42\u541e\u5410\u91cf\uff08\u5927\u5305\uff09\uff1a5.8Gb\uff0c\u5e94\u7528\u5c42\u541e\u5410\u91cf\uff1a750Mb\uff0c\u5e26\u5bbd\u6027\u80fd\uff1a500Mb\uff0cIPSEC VPN\u52a0\u5bc6\u6027\u80fd\uff08\u6700\u9ad8\u6027\u80fd\uff09\uff1a120Mb\uff0c\u652f\u6301\u7528\u6237\u6570\uff1a4000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a2000\uff0c\u51c6\u5165\u7ec8\u7aef\u6570\u7684\u6269\u5bb9\u4e0a\u9650\uff08\u652f\u6301\u5ba2\u6237\u7aef\u6388\u6743-\u9700\u5355\u72ec\u6536\u8d39\uff09\uff1a4000\uff0c\u9632\u6cc4\u5bc6\u7ec8\u7aef\u6570\u4e0a\u9650(\u9700\u5355\u72ec\u6536\u8d39)\uff1a8000\uff0c\u5305\u8f6c\u53d1\u7387\uff1a90Kpps\uff0c\u6bcf\u79d2\u65b0\u5efa\u8fde\u63a5\u6570\uff1a10000\uff0c\u6700\u5927\u5e76\u53d1\u8fde\u63a5\u6570\uff1a500000\u3002\n\u786c\u4ef6\u53c2\u6570\uff1a\u89c4\u683c\uff1a1U\uff0c\u5185\u5b58\u5927\u5c0f\uff1a8G\uff0c\u786c\u76d8\u5bb9\u91cf\uff1a128G SSD+960G SSD\uff0c\u7535\u6e90\uff1a\u5355\u7535\u6e90\uff0c\u63a5\u53e3\uff1a6\u5343\u5146\u7535\u53e3+2\u4e07\u5146\u5149\u53e3SFP+\u3002\n\u529f\u80fd\u63cf\u8ff0\uff1a\u6df1\u4fe1\u670d\u5168\u7f51\u884c\u4e3a\u7ba1\u7406\u805a\u7126\u4f01\u4e8b\u4e1a\u7ec4\u7ec7\u7f51\u7edc\u884c\u4e3a\u5b89\u5168\uff0c\u5b9e\u73b0\u5168\u7f51\u8d44\u4ea7\u3001\u8eab\u4efd\u3001\u884c\u4e3a\u53ef\u89c6\u53ef\u63a7\uff0c\u667a\u80fd\u611f\u77e5\u5185\u90e8\u5a01\u80c1\u98ce\u9669\uff0c\u5e2e\u52a9\u7528\u6237\u6784\u5efa\u6709\u6548\u9632\u5fa1\u4f53\u7cfb\u3002","created_by":1013,"created_at":"2025-08-14 09:11:10","updated_at":"2025-08-21 17:31:40","pinyin_shortcut":"AC1000B1500","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":23,"key":23,"name":"\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":172,"key":172,"name":"\u6df1\u4fe1\u670dAC-1000\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u5668"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"serial_no":"CGRK-20250821-00006"},{"id":45,"product_id":1025,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"2","outbound":"0","inventory":"2","amount":"10","total_amount":"20","actual_amount":"10","actual_total_amount":"20","is_build":false,"created_at":"2025-08-08 18:11:19","lost_outbound":"","erp_inventory_start_id":30,"erp_inventory_start_product_id":45,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":30,"key":30,"name":"QCKC-20250808-00030"},"erpPurchaseGift":{},"product":{"id":1025,"name":"FOC-1010","product_type":4,"product_component":43,"product_brand":152,"product_serie":714,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2023-09-05 11:10:11","updated_at":"2025-08-08 18:11:19","pinyin_shortcut":"FOC1010","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":152,"key":152,"name":"\u80dc\u4e3a"},"productSerie":{"id":714,"key":714,"name":"\u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebfLC-LC 1\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"serial_no":"QCKC-20250808-00030"},{"id":44,"product_id":1372,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"13","outbound":"10","inventory":"3","amount":"25","total_amount":"325","actual_amount":"25","actual_total_amount":"75","is_build":false,"created_at":"2025-08-08 18:11:19","lost_outbound":"","erp_inventory_start_id":30,"erp_inventory_start_product_id":44,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"10","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":30,"key":30,"name":"QCKC-20250808-00030"},"erpPurchaseGift":{},"product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2025-08-27 13:24:36","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"serial_no":"QCKC-20250808-00030"},{"id":41,"product_id":2086,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"3","outbound":"0","inventory":"3","amount":"900","total_amount":"2700","actual_amount":"900","actual_total_amount":"2700","is_build":false,"created_at":"2025-08-08 17:55:30","lost_outbound":"","erp_inventory_start_id":28,"erp_inventory_start_product_id":41,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":28,"key":28,"name":"QCKC-20250808-00028"},"erpPurchaseGift":{},"product":{"id":2086,"name":"INTEL S3520 \u7cfb\u5217\u56fa\u6001\u786c\u76d82.5\u82f1\u5bf8 240G","product_type":2,"product_component":5,"product_brand":5,"product_serie":1686,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:55:14","updated_at":"2025-08-08 17:55:30","pinyin_shortcut":"INTELS3520xlgtyp25yc240G","product_unit":3,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":5,"key":5,"name":"\u82f1\u7279\u5c14"},"productSerie":{"id":1686,"key":1686,"name":"\u56fa\u6001\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"serial_no":"QCKC-20250808-00028"},{"id":40,"product_id":2085,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"3","outbound":"0","inventory":"3","amount":"620","total_amount":"1860","actual_amount":"620","actual_total_amount":"1860","is_build":false,"created_at":"2025-08-08 17:53:59","lost_outbound":"","erp_inventory_start_id":27,"erp_inventory_start_product_id":40,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":27,"key":27,"name":"QCKC-20250808-00027"},"erpPurchaseGift":{},"product":{"id":2085,"name":"HP P22 G4 \u5546\u7528\u6db2\u6676\u663e\u793a\u5668","product_type":11,"product_component":154,"product_brand":2,"product_serie":1685,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:53:41","updated_at":"2025-08-08 17:53:59","pinyin_shortcut":"HPP22G4syyjxsq","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":154,"key":154,"name":"\u663e\u793a\u5668"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":1685,"key":1685,"name":"P22 G4"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"serial_no":"QCKC-20250808-00027"},{"id":39,"product_id":39,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"3","outbound":"0","inventory":"3","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2025-08-08 17:47:38","lost_outbound":"","erp_inventory_start_id":26,"erp_inventory_start_product_id":39,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":26,"key":26,"name":"QCKC-20250808-00026"},"erpPurchaseGift":{},"product":{"id":39,"name":"AIR-AP1832I-H-K9","product_type":4,"product_component":21,"product_brand":3,"product_serie":80,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-13 11:01:04","updated_at":"2025-08-08 17:47:38","pinyin_shortcut":"AIRAP1832IHK9","product_unit":1,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":21,"key":21,"name":"\u65e0\u7ebfAP"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":80,"key":80,"name":"\u601d\u79d1AIR-AP1832I-H-K9\u65e0\u7ebfAP"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"serial_no":"QCKC-20250808-00026"},{"id":38,"product_id":672,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"1","outbound":"0","inventory":"1","amount":"0","total_amount":"0","actual_amount":"0","actual_total_amount":"0","is_build":false,"created_at":"2025-08-08 17:46:44","lost_outbound":"","erp_inventory_start_id":25,"erp_inventory_start_product_id":38,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":25,"key":25,"name":"QCKC-20250808-00025"},"erpPurchaseGift":{},"product":{"id":672,"name":"FAS9000","product_type":3,"product_component":14,"product_brand":6,"product_serie":421,"product_misc":5,"product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2020-03-03 13:43:05","updated_at":"2025-08-08 17:46:44","pinyin_shortcut":"FAS9000","product_unit":2,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":421,"key":421,"name":"NETAPP FAS9000 \u5b58\u50a8\u4e3b\u673a"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"QCKC-20250808-00025"},{"id":37,"product_id":2084,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"17","outbound":"0","inventory":"17","amount":"70.75","total_amount":"1202.75","actual_amount":"70.75","actual_total_amount":"1202.75","is_build":false,"created_at":"2025-08-08 17:45:31","lost_outbound":"","erp_inventory_start_id":24,"erp_inventory_start_product_id":37,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":24,"key":24,"name":"QCKC-20250808-00024"},"erpPurchaseGift":{},"product":{"id":2084,"name":"HP\u7b14\u8bb0\u672c\u53cc\u80a9\u80cc\u5305","product_type":11,"product_component":179,"product_brand":2,"product_serie":1684,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:44:52","updated_at":"2025-08-08 17:45:31","pinyin_shortcut":"HPbjbsjbb","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":1684,"key":1684,"name":"\u80cc\u5305"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"serial_no":"QCKC-20250808-00024"},{"id":36,"product_id":2083,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-08","number":"17","outbound":"0","inventory":"17","amount":"49.08","total_amount":"834.36","actual_amount":"49.08","actual_total_amount":"834.36","is_build":false,"created_at":"2025-08-08 17:45:31","lost_outbound":"","erp_inventory_start_id":24,"erp_inventory_start_product_id":36,"erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{"id":24,"key":24,"name":"QCKC-20250808-00024"},"erpPurchaseGift":{},"product":{"id":2083,"name":"HP \u9ed1\u9cb8 \u65e0\u7ebf\u9f20\u6807","product_type":11,"product_component":179,"product_brand":2,"product_serie":1683,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:44:09","updated_at":"2025-08-08 17:45:31","pinyin_shortcut":"HPhjwxsb","product_unit":3,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":1683,"key":1683,"name":"\u9f20\u6807"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"serial_no":"QCKC-20250808-00024"}],"pagenation":{"totalcount":44,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-15 16:19:29') RETURNING "id"
16:19:29.3290.9 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_erp_inventory_starts" WHERE "id" IN (30, 28, 27, 26, 25, 24)
16:19:29.3480.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1701, "last_visit_at"='now()' WHERE "id"=56557
16:19:29.3280.4 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name", "supplier_id", "purchase_contract_id" FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id" IN (34, 32, 31, 26, 22)
16:19:29.3280.3 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_erp_inventory_builds" WHERE "id" IN (2, 1)
16:19:29.3420.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 1, 3, 6)
16:19:29.3370.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (23, 154, 179, 5, 15, 39, 14, 21, 43, 36, 32)
16:19:29.3360.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (4, 11, 2, 3, 5, 7)
16:19:29.3370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 2, 5, 27, 6, 3, 152, 134, 8, 137)