ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68999a6970a41: POST https://beta.jinchangxiao.com/vue/sales-order-item/of-supplier at 2025-08-11 03:23:21 pm by 124.64.23.198

Database Queries

总计22条数据
TimeDurationTypeQuery
  
15:23:21.9983.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5388

[+] Explain
15:23:22.0032.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5388

[+] Explain
15:23:22.0080.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431'

[+] Explain
15:23:22.01517.4 msSELECTSELECT COUNT(*) FROM (SELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."sales_rep" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5388))) AND ("s"."supplier_id"=431) GROUP BY "s"."id" ORDER BY "s"."sales_date" DESC, "s"."created_at" DESC) "c"

[+] Explain
15:23:22.0333.2 msSELECTSELECT DISTINCT s.* FROM "a57be577deb434"."tbl_sales_order_items" "s" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "a57be577deb434"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "a57be577deb434"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."sales_rep" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5388))) AND ("s"."supplier_id"=431) GROUP BY "s"."id" ORDER BY "s"."sales_date" DESC, "s"."created_at" DESC LIMIT 20

[+] Explain
15:23:22.0370.3 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=14

[+] Explain
15:23:22.0381.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
15:23:22.0391.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004)

[+] Explain
15:23:22.0410.2 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=2715

[+] Explain
15:23:22.0410.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (833, 832)

[+] Explain
15:23:22.0430.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (2, 11)

[+] Explain
15:23:22.0430.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (2, 33)

[+] Explain
15:23:22.0430.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=121

[+] Explain
15:23:22.0440.9 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (533, 532)

[+] Explain
15:23:22.0450.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431

[+] Explain
15:23:22.0450.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

[+] Explain
15:23:22.0460.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)

[+] Explain
15:23:22.0460.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=7

[+] Explain
15:23:22.0463.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_remind_receivers" WHERE "sales_order_item_id" IN (4344, 4343, 4342, 4341, 4340, 4339, 4338, 4337, 4336, 4335)

[+] Explain
15:23:22.0500.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id" IN (4344, 4343, 4342, 4341, 4340, 4339, 4338, 4337, 4336, 4335) ORDER BY "sales_date", "created_at"

[+] Explain
15:23:22.0501.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=27) AND ("object_id" IN (4344, 4343, 4342, 4341, 4340, 4339, 4338, 4337, 4336, 4335))

[+] Explain
15:23:22.0531.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5388, 5, 'vue/sales-order-item/of-supplier', '{"page":"1","id":"431","web_access_token":"FBi4Q_oGZv9XR5qrTBdj2zrJ1koz6eUS"}', '{"code":2000,"result":{"list":[{"id":4344,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201055","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:45:58","updated_at":"2022-01-11 17:45:58","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4343,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201107","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:45:47","updated_at":"2022-01-11 17:45:47","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4342,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201022","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:45:34","updated_at":"2022-01-11 17:45:34","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4341,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201126","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:45:24","updated_at":"2022-01-11 17:45:24","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4340,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889207535","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:45:14","updated_at":"2022-01-11 17:45:14","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4339,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201775","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:45:05","updated_at":"2022-01-11 17:45:05","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4338,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201846","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:44:56","updated_at":"2022-01-11 17:44:56","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4337,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201884","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:44:45","updated_at":"2022-01-11 17:44:45","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4336,"sales_order_id":"","product_id":833,"parent":"","sn":"E211080002889201974","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:44:33","updated_at":"2022-01-11 17:44:33","pn":"\u8d85\u7fd4SF880-V001-1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u7fd4\u53f0\u5f0f\u673a9\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":833,"name":"SF880-V001-1","product_type":11,"product_component":33,"product_brand":121,"product_serie":532,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:34:04","updated_at":"2024-02-22 17:19:08","pinyin_shortcut":"SF880V0011","product_unit":1,"is_renew":false,"productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":33,"key":33,"name":"\u53f0\u5f0f\u673a\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":532,"key":532,"name":"\u8d85\u7fd4SF880-V001-1\u53f0\u5f0f\u673a"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":4335,"sales_order_id":"","product_id":832,"parent":"","sn":"H211180002919600028","supplier_id":431,"order":0,"created_by":1013,"created_at":"2022-01-11 17:43:40","updated_at":"2022-01-11 17:43:40","pn":"\u8d85\u5f3aF520-S1","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"2021-11-12","software_from":"","maintenance_from":"","hardware_to":"2024-11-11","software_to":"","maintenance_to":"","new_hardware_deadline":"2024-11-11","new_software_deadline":"","new_maintenance_deadline":"","client_id":14,"project_id":2715,"sales_rep":1004,"sales_date":"2021-11-12","description":"\u6e05\u534e\u540c\u65b9\u8d85\u5f3aF520\u670d\u52a1\u5668\u4e00\u53f0","software_reminded":false,"hardware_reminded":true,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":true,"maintenance_advance_reminded":false,"is_system":"","amount":"","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}},"project":{"id":2715,"key":2715,"name":"\u540c\u65b9\u4fe1\u521b\u6d4b\u8bd5\u673a\u3010\u60e0\u8054\u8baf\u901a\u3011"},"product":{"id":832,"name":"F520-S1","product_type":2,"product_component":2,"product_brand":121,"product_serie":533,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2022-01-11 17:33:24","updated_at":"2024-02-22 17:18:19","pinyin_shortcut":"F520S1","product_unit":1,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":121,"key":121,"name":"\u6e05\u534e\u540c\u65b9"},"productSerie":{"id":533,"key":533,"name":"\u6e05\u534e\u540c\u65b9\u98de\u817e\u8d85\u5f3aF520-S1\u670d\u52a1\u5668"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"salesOrderItemRemindReceivers":[],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":false,"can_delete":false,"bgcolor":"#89c541"}],"can_create":false,"pagenation":{"totalcount":10,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-11 15:23:22') RETURNING "id"

[+] Explain