ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a584adebac4e: POST https://beta.jinchangxiao.com/vue/project/product-list at 2026-07-16 11:07:10 am by 114.244.130.25

Performance Profiling

Total processing time: 85 ms; Peak memory: 5.569 MB. Show Profiling Timeline

总计19条数据
TimeDurationCategoryInfo
  
11:07:10.78025.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" 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 WHERE (lower(p.name) ILIKE '%vo%') OR ("p"."pinyin_shortcut" ILIKE '%vo%') OR (lower(pt.name) ILIKE '%vo%') OR (lower(pb.name) ILIKE '%vo%') OR (lower(ps.name) ILIKE '%vo%') OR (lower(pc.name) ILIKE '%vo%') OR (lower(p.description) ILIKE '%vo%') ORDER BY "updated_at" DESC) "c"
11:07:10.80619.7 msyii\db\Command::querySELECT "p".* FROM "a57be577deb434"."tbl_products" "p" 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 WHERE (lower(p.name) ILIKE '%vo%') OR ("p"."pinyin_shortcut" ILIKE '%vo%') OR (lower(pt.name) ILIKE '%vo%') OR (lower(pb.name) ILIKE '%vo%') OR (lower(ps.name) ILIKE '%vo%') OR (lower(pc.name) ILIKE '%vo%') OR (lower(p.description) ILIKE '%vo%') ORDER BY "updated_at" DESC LIMIT 20
11:07:10.8423.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/product-list', '{"ProductSearch":{"keyword":"VO "},"page":"1","web_access_token":"--xxX6Gmp9PXF1XHWWwlXiYIP9-yVx7F"}', '{"code":2000,"result":{"list":[{"id":2265,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2","product_type":23,"product_component":195,"product_brand":284,"product_serie":1775,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:34:40","updated_at":"2026-07-10 11:34:39","pinyin_shortcut":"olwlOlivoilagly500MLx2jxlh","product_unit":9,"is_renew":false,"in_out_at":"2026-07-10 11:34:39.019714+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":284,"key":284,"name":"\u6b27\u4e3d\u8587\u5170"},"productSerie":{"id":1775,"key":1775,"name":"\u98df\u7528\u6cb9"},"productMisc":{},"productUnit":{"id":9,"key":9,"name":"\u76d2"},"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"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2265,"erp_store_id":1,"outbound":"51","number":"62","purchase_inbound":"51","gift_inbound":"10","sales_outbound":"50","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"1","transfer_spent_outbound":"1","inventory":"11","avg_amount":"4474.9750000000000000","avg_total_amount":"2225.0000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}},{"product_id":2265,"erp_store_id":2,"outbound":"1","number":"1","purchase_inbound":"0","gift_inbound":"0","sales_outbound":"0","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"1","transfer_spent_outbound":"1","inventory":"0","avg_amount":"9450.0000000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":2,"key":2,"name":"\u96f6\u914d\u4ef6"}}],"erpInventoryCount":{"product_id":2265,"outbound":"52","number":"63","purchase_inbound":"51","gift_inbound":"10","sales_outbound":"50","overflow_inbound":"0","lost_outbound":"0","disassemble_inbound":"0","disassemble_spent_outbound":"0","sales_gift_outbound":"0","build_inbound":"0","build_spent_outbound":"0","transfer_inbound":"2","transfer_spent_outbound":"2","inventory":"11","avg_amount":"6133.3166666666666667","avg_total_amount":"1483.3333333333333333","amount":"8900.0"},"bgcolor":"#89c541","last_amount":"53534","can_update":true,"can_delete":true},{"id":1234,"name":"\u56fd\u7a961573 52%vol\uff08500mL \uff09","product_type":23,"product_component":194,"product_brand":196,"product_serie":818,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 17:09:38","updated_at":"2026-03-09 14:17:13","pinyin_shortcut":"gj157352vol500mL","product_unit":11,"is_renew":false,"in_out_at":"2026-03-09 14:17:13.804067+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":196,"key":196,"name":"\u6cf8\u5dde\u8001\u7a96"},"productSerie":{"id":818,"key":818,"name":"\u56fd\u7a961573 52%vol"},"productMisc":{},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"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"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1234,"erp_store_id":1,"outbound":"9","number":"13","purchase_inbound":"8","gift_inbound":"0","sales_outbound":"9","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"889.5105555555333333","avg_total_amount":"1182.8022222221333333","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1234,"outbound":"9","number":"13","purchase_inbound":"8","gift_inbound":"0","sales_outbound":"9","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"889.5105555555333333","avg_total_amount":"1182.8022222221333333","amount":"3548.4066666664"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":1224,"name":"\u98de\u5929\u8305\u53f0\u9152 53%vol\uff08500ml\uff09","product_type":23,"product_component":194,"product_brand":187,"product_serie":809,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2024-01-12 16:04:37","updated_at":"2026-02-04 17:35:47","pinyin_shortcut":"ftmtj53vol500ml","product_unit":11,"is_renew":false,"in_out_at":"2026-02-04 17:35:47.741012+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":187,"key":187,"name":"\u8305\u53f0"},"productSerie":{"id":809,"key":809,"name":"\u98de\u5929\u8305\u53f0\u9152 53%vol"},"productMisc":{},"productUnit":{"id":11,"key":11,"name":"\u74f6"},"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"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":1224,"erp_store_id":1,"outbound":"6","number":"10","purchase_inbound":"10","gift_inbound":"0","sales_outbound":"6","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"1829.3275000000000000","avg_total_amount":"3599.3100000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":1224,"outbound":"6","number":"10","purchase_inbound":"10","gift_inbound":"0","sales_outbound":"6","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"4","avg_amount":"1829.3275000000000000","avg_total_amount":"3599.3100000000000000","amount":"7198.620"},"bgcolor":"#89c541","last_amount":"0","can_update":true,"can_delete":true},{"id":2254,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u7279\u7ea7\u521d\u69a8\u6a44\u6984\u6cb9 750ml*2\u74f6\u793c\u76d2","product_type":23,"product_component":195,"product_brand":284,"product_serie":1775,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-02-03 09:29:59","updated_at":"2026-02-04 09:24:43","pinyin_shortcut":"olwlOlivoilatjczgly750ml2plh","product_unit":9,"is_renew":false,"in_out_at":"2026-02-04 09:24:43.242587+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":284,"key":284,"name":"\u6b27\u4e3d\u8587\u5170"},"productSerie":{"id":1775,"key":1775,"name":"\u98df\u7528\u6cb9"},"productMisc":{},"productUnit":{"id":9,"key":9,"name":"\u76d2"},"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"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2254,"erp_store_id":1,"outbound":"6","number":"6","purchase_inbound":"6","gift_inbound":"0","sales_outbound":"6","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"197.5750000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2254,"outbound":"6","number":"6","purchase_inbound":"6","gift_inbound":"0","sales_outbound":"6","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"197.5750000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.000"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":2234,"name":"\u98de\u5929\u8305\u53f0\u9152 53%volX6\u74f6\uff08500ML\uff09","product_type":23,"product_component":194,"product_brand":187,"product_serie":1761,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-01-16 17:21:00","updated_at":"2026-02-04 09:20:29","pinyin_shortcut":"ftmtj53volX6p500ML","product_unit":10,"is_renew":false,"in_out_at":"2026-02-04 09:20:29.135139+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":187,"key":187,"name":"\u8305\u53f0"},"productSerie":{"id":1761,"key":1761,"name":"\u98de\u5929\u8305\u53f0\u9152 53%vol\uff08\u6574\u7bb1\uff09"},"productMisc":{},"productUnit":{"id":10,"key":10,"name":"\u7bb1"},"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"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2234,"erp_store_id":1,"outbound":"3","number":"3","purchase_inbound":"3","gift_inbound":"0","sales_outbound":"3","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"10481.5550000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2234,"outbound":"3","number":"3","purchase_inbound":"3","gift_inbound":"0","sales_outbound":"3","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"10481.5550000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":2144,"name":"\u56fd\u7a961573 38\u5ea6 \u661f\u6cb3\u7480\u74a8\u793c\u76d2\uff08500MLX2\uff09","product_type":23,"product_component":194,"product_brand":196,"product_serie":1713,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-09-24 11:05:10","updated_at":"2025-09-24 15:16:32","pinyin_shortcut":"gj157338dxhcclh500MLX2","product_unit":9,"is_renew":false,"in_out_at":"2025-09-24 15:16:32+08","productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":196,"key":196,"name":"\u6cf8\u5dde\u8001\u7a96"},"productSerie":{"id":1713,"key":1713,"name":"\u56fd\u7a961573 38%vol"},"productMisc":{},"productUnit":{"id":9,"key":9,"name":"\u76d2"},"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"}},"productQa":"","everyStoreErpInventoryCount":[{"product_id":2144,"erp_store_id":1,"outbound":"1","number":"1","purchase_inbound":"1","gift_inbound":"0","sales_outbound":"1","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"1300.3900000000000000","avg_total_amount":"0.00000000000000000000","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"}}],"erpInventoryCount":{"product_id":2144,"outbound":"1","number":"1","purchase_inbound":"1","gift_inbound":"0","sales_outbound":"1","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"1300.3900000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"},"bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":1999,"name":"31110976","product_type":2,"product_component":5,"product_brand":4,"product_serie":42,"product_misc":"","product_qa":"","pn":"","description":"Lenovo 2.5\" ESS5600 960GB SATA SSD\u8054\u60f3\u56fa\u6001\u786c\u76d8","created_by":1013,"created_at":"2025-06-10 14:10:45","updated_at":"2025-06-10 14:10:45","pinyin_shortcut":"31110976","product_unit":3,"is_renew":false,"in_out_at":"","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":42,"key":42,"name":"960G SATA SSD 2.5 \u56fa\u6001\u786c\u76d8"},"productMisc":{},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"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"}},"productQa":"","everyStoreErpInventoryCount":[],"erpInventoryCount":"","bgcolor":"#89c541","last_amount":"1600","can_update":true,"can_delete":true},{"id":1656,"name":"Lenovo ThinkSystem SR658","product_type":2,"product_component":2,"product_brand":4,"product_serie":510,"product_misc":"","product_qa":"","pn":"","description":"Lenovo ThinkSystem SR658\uff0c2U\u673a\u67b6\u5f0f\u670d\u52a1\u5668\uff0c\u914d2\u4e2a\u82f1\u7279\u5c14\u00ae \u81f3\u5f3a\u00ae 8163 \u5904\u7406\u5668\uff0c\u6700\u5927\u53ef\u652f\u63012\u9897CPU\uff0c\u914d8\u4e2a32GB TruDDR4 \u5185\u5b58\uff0c \u6807\u914d\u652f\u63018\u4e2a2.5\"\u786c\u76d8\u80cc\u677f\u63d2\u69fd\uff0c\u6807\u914dRAID 730-8i 1G PCIe 12Gbps\u9635\u5217\u5361\uff0c\u914d3*1.92TSSD \u652f\u6301RAID0\/1\/10\/5\/50\uff0c\u6807\u914d4\u4e2a\u96c6\u62101GbE RJ-45\u7f51\u53e3(LOM\u5361)\u548c1\u4e2a\u7ba1\u7406\u7f51\u7edc\u7aef\u53e3\uff0c\u6700\u5927\u652f\u63016\u4e2aPCIe 3.0\u63d2\u69fd\uff0c\u914d 2\u4e2a550W\u767d\u91d1\u7ea7\u70ed\u63d2\u62d4\u7535\u6e90\u6a21\u5757\uff0c\u6700\u5927\u652f\u63012\u4e2a\uff0c\u524d\u7f6e1\u4e2aUSB2.0(XClarity\u7ba1\u7406\u63a5\u53e3)\uff0c1\u4e2aUSB3.0\u63a5\u53e3\uff0c\u5149\u901a\u8def\u8bca\u65adLED\u62a5\u8b66\u706f\uff0c\u5de5\u4f5c\u6e29\u5ea65 \u00b0C - 45 \u00b0C\uff08\u7b26\u5408ASHRAE Class A4\u3001A3\u3001A2\u6807\u51c6\uff09","created_by":1013,"created_at":"2024-06-26 09:25:27","updated_at":"2024-06-26 09:25:27","pinyin_shortcut":"LenovoThinkSystemSR658","product_unit":1,"is_renew":false,"in_out_at":"","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":510,"key":510,"name":"\u8054\u60f3 SR658 \u670d\u52a1\u5668"},"productMisc":{},"productUnit":{"id":1,"key":1,"name":"\u53f0"},"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"}},"productQa":"","everyStoreErpInventoryCount":[],"erpInventoryCount":"","bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true},{"id":1517,"name":"7S090002WW","product_type":7,"product_component":69,"product_brand":4,"product_serie":1312,"product_misc":"","product_qa":"","pn":"","description":"Lenovo HPC AI LiCO Software W\/3Yr S&S \n2\u4e2a\u8282\u70b9\u7684AI\u8d44\u6e90\u7ba1\u7406\u6388\u6743license","created_by":1013,"created_at":"2024-03-19 10:07:21","updated_at":"2024-03-19 10:07:21","pinyin_shortcut":"7S090002WW","product_unit":8,"is_renew":false,"in_out_at":"","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":69,"key":69,"name":"\u96c6\u7fa4\u7ba1\u7406\u7cfb\u7edf"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1312,"key":1312,"name":"\u8054\u60f3\u667a\u80fd\u8d85\u7b97\u5e73\u53f0LiCO AI\u8d44\u6e90\u7ba1\u7406\u6388\u6743license"},"productMisc":{},"productUnit":{"id":8,"key":8,"name":"\u5e74"},"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"}},"productQa":"","everyStoreErpInventoryCount":[],"erpInventoryCount":"","bgcolor":"#89c541","last_amount":"","can_update":true,"can_delete":true}],"can_create":true,"can_update":true,"can_delete":true,"can_manage":true,"pagenation":{"totalcount":9,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.0.0 Safari\/537.36"}', FALSE, '2026-07-16 11:07:10', 75993856) RETURNING "id"
11:07:10.8373.0 msyii\db\Command::querySELECT DISTINCT ON (lp.product_id) lp.product_id AS product_id, "ppr"."amount" AS "amount" FROM (SELECT DISTINCT ON (ppr.product_id) ppr.product_id AS product_id, "p"."id" AS "project_id" FROM "a57be577deb434"."tbl_project_product_rels" "ppr" INNER JOIN "a57be577deb434"."tbl_projects" "p" ON ppr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON p.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id WHERE (("ppr"."product_id" IN (2265, 1234, 1224, 2254, 2234, 2144, 1999, 1656, 1517)) AND ("p"."project_status"=3)) AND (ppr.amount is not null) ORDER BY "ppr"."product_id", "p"."created_at" DESC, "p"."id" DESC) "lp" INNER JOIN "a57be577deb434"."tbl_project_product_rels" "ppr" ON ppr.project_id = lp.project_id AND ppr.product_id = lp.product_id WHERE ppr.amount is not null ORDER BY "lp"."product_id", "ppr"."id" DESC
11:07:10.8311.5 msyii\db\Command::querySELECT product_id, erp_store_id, sum(outbound) as outbound, sum(number) as number, sum(CASE WHEN erp_purchase_inbound_id IS NOT NULL THEN number ELSE 0 END) as purchase_inbound, sum(CASE WHEN erp_purchase_gift_id IS NOT NULL THEN number ELSE 0 END) as gift_inbound, sum(sales_outbound) as sales_outbound, sum(CASE WHEN erp_inventory_overflow_id IS NOT NULL THEN number ELSE 0 END) as overflow_inbound, sum(lost_outbound) as lost_outbound, sum(CASE WHEN erp_inventory_disassemble_id IS NOT NULL THEN number ELSE 0 END) as disassemble_inbound, sum(disassemble_spent_outbound) as disassemble_spent_outbound, sum(sales_gift_outbound) as sales_gift_outbound, sum(CASE WHEN erp_inventory_build_id IS NOT NULL THEN number ELSE 0 END) as build_inbound, sum(build_spent_outbound) as build_spent_outbound, sum(CASE WHEN erp_inventory_transfer_id IS NOT NULL THEN number ELSE 0 END) as transfer_inbound, sum(transfer_spent_outbound) as transfer_spent_outbound, sum(inventory) as inventory, avg(amount) as avg_amount, avg(amount * inventory) as avg_total_amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (2265, 1234, 1224, 2254, 2234, 2144, 1999, 1656, 1517) GROUP BY "product_id", "erp_store_id"
11:07:10.7700.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5461
11:07:10.8340.8 msyii\db\Command::querySELECT eip.product_id, sum(outbound) as outbound, sum(number) as number, sum(CASE WHEN eip.erp_purchase_inbound_id IS NOT NULL THEN eip.number ELSE 0 END) as purchase_inbound, sum(CASE WHEN eip.erp_purchase_gift_id IS NOT NULL THEN eip.number ELSE 0 END) as gift_inbound, sum(sales_outbound) as sales_outbound, sum(CASE WHEN eip.erp_inventory_overflow_id IS NOT NULL THEN eip.number ELSE 0 END) as overflow_inbound, sum(lost_outbound) as lost_outbound, sum(CASE WHEN eip.erp_inventory_disassemble_id IS NOT NULL THEN eip.number ELSE 0 END) as disassemble_inbound, sum(disassemble_spent_outbound) as disassemble_spent_outbound, sum(sales_gift_outbound) as sales_gift_outbound, sum(CASE WHEN eip.erp_inventory_build_id IS NOT NULL THEN eip.number ELSE 0 END) as build_inbound, sum(build_spent_outbound) as build_spent_outbound, sum(CASE WHEN eip.erp_inventory_transfer_id IS NOT NULL THEN eip.number ELSE 0 END) as transfer_inbound, sum(transfer_spent_outbound) as transfer_spent_outbound, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id" IN (2265, 1234, 1224, 2254, 2234, 2144, 1999, 1656, 1517) GROUP BY "eip"."product_id"
11:07:10.7720.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:07:10.8300.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=7
11:07:10.8290.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (9, 11, 10, 3, 1, 8)
11:07:10.8330.5 msyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id" IN (1, 2)
11:07:10.7690.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:07:10.7740.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:07:10.8260.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (23, 2, 7)
11:07:10.8290.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
11:07:10.8300.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)
11:07:10.8280.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1775, 818, 809, 1761, 1713, 42, 510, 1312)
11:07:10.8280.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (284, 196, 187, 4)
11:07:10.8270.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (195, 194, 5, 2, 69)