ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68afc306646d4: POST https://beta.jinchangxiao.com/vue/erp-sales-gift/search-inventory-product-list at 2025-08-28 10:46:30 am by 221.194.148.30

Database Queries

总计29条数据
TimeDurationTypeQuery
  
10:46:30.4142.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
10:46:30.4171.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
10:46:30.4222.5 msSELECTSELECT 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 WHERE ("eip"."product_id"='2068') AND ((eip.inventory > 0) OR (0=1)) GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC) "c"

[+] Explain
10:46:30.4250.9 msSELECTSELECT 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 WHERE ("eip"."product_id"='2068') AND ((eip.inventory > 0) OR (0=1)) GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC LIMIT 20

[+] Explain
10:46:30.4260.4 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name", "supplier_id", "purchase_contract_id" FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id" IN (1, 13)

[+] Explain
10:46:30.4270.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (678, 431)

[+] Explain
10:46:30.4280.4 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4078, 4097)

[+] Explain
10:46:30.4280.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_projects" WHERE "erp_purchase_inbound_id" IN (1, 13)

[+] Explain
10:46:30.4290.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2136

[+] Explain
10:46:30.4290.5 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "created_by", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3846

[+] Explain
10:46:30.4300.4 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_erp_inventory_builds" WHERE "id"=3

[+] Explain
10:46:30.4300.4 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name", "supplier_id", "purchase_contract_id" FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=2

[+] Explain
10:46:30.4310.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2068

[+] Explain
10:46:30.4310.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4

[+] Explain
10:46:30.4320.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=51

[+] Explain
10:46:30.4320.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=12

[+] Explain
10:46:30.4320.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=231

[+] Explain
10:46:30.4330.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2

[+] Explain
10:46:30.4330.8 msSELECTSELECT 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 WHERE ("eip"."product_id"='2068') AND ((eip.inventory > 0) OR (0=1)) GROUP BY "eip"."id" ORDER BY eip.wrote_date ASC, eip.created_at ASC

[+] Explain
10:46:30.4340.2 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name", "supplier_id", "purchase_contract_id" FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id" IN (1, 13)

[+] Explain
10:46:30.4350.2 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_erp_inventory_builds" WHERE "id"=3

[+] Explain
10:46:30.4350.2 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name", "supplier_id", "purchase_contract_id" FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=2

[+] Explain
10:46:30.4350.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2068

[+] Explain
10:46:30.4350.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4

[+] Explain
10:46:30.4360.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=51

[+] Explain
10:46:30.4360.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=12

[+] Explain
10:46:30.4360.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=231

[+] Explain
10:46:30.4360.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2

[+] Explain
10:46:30.4371.5 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-gift/search-inventory-product-list', '{"ErpSalesGifts":{"erpSalesGiftProducts":{"new":[{"product_id":"2064","number":"1","amount":"0","total_amount":"","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2064","erp_store_id":"1","is_check":"0","erpSalesGiftSpentProducts":[{"erp_inventory_product_id":"15","number":"1"}]},{"product_id":"2068","number":"1","amount":"0","total_amount":"0","description":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erp_sales_order_product_id":"2068","erp_store_id":"1","is_check":"1","erpSalesGiftSpentProducts":""}]}},"id":"","web_access_token":"a9siHQoxso9RHlziKPGDoUFTVYSgvTsS"}', '{"code":2000,"result":{"list":[{"id":2,"product_id":2068,"erp_purchase_inbound_id":1,"erp_purchase_order_id":2008,"erp_purchase_inbound_product_id":2,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-12","number":"2222","outbound":"134","inventory":"2088","amount":"34343","total_amount":"76310146","actual_amount":"34031.0368","actual_total_amount":"71056804.8384","is_build":false,"created_at":"2025-08-12 14:33:42","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"20","sales_outbound":"114","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":1,"key":1,"name":"CGRK-20250812-00001","supplier_id":678,"purchase_contract_id":4078,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4078,"key":4078,"name":"YTYG20250623"},"erpPurchaseInboundProjects":[{"id":2,"erp_purchase_inbound_id":1,"client_id":2136,"project_id":3846,"client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240"},"project":{"id":3846,"key":3846,"name":"59\u6240\u5927\u6a21\u578b\u79c1\u6709\u5316\u90e8\u7f72","project_status":3,"created_by":5087,"budget":"615000","collected":"0"}}]},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2068,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1100-4D\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7","created_by":1013,"created_at":"2025-07-28 14:46:34","updated_at":"2025-08-28 10:45:03","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CGRK-20250812-00001"},{"id":6,"product_id":2068,"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-14","number":"22","outbound":"0","inventory":"22","amount":"0","total_amount":"0","actual_amount":"34031.0368","actual_total_amount":"748682.8096","is_build":false,"created_at":"2025-08-14 10:38:15","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":2,"erp_purchase_gift_product_id":2,"sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{"id":2,"key":2,"name":"HZD-20250814-00001","supplier_id":"","purchase_contract_id":""},"product":{"id":2068,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1100-4D\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7","created_by":1013,"created_at":"2025-07-28 14:46:34","updated_at":"2025-08-28 10:45:03","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"HZD-20250814-00001"},{"id":11,"product_id":2068,"erp_purchase_inbound_id":"","erp_purchase_order_id":"","erp_purchase_inbound_product_id":"","erp_purchase_order_product_id":"","erp_store_id":"","wrote_date":"2025-08-19","number":"2","outbound":"0","inventory":"2","amount":"234324","total_amount":"468648","actual_amount":"34031.0368","actual_total_amount":"68062.0736","is_build":false,"created_at":"2025-08-19 10:24:17","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":3,"erp_inventory_build_product_id":3,"build_spent_outbound":"","sales_outbound":"","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{},"erpInventoryBuild":{"id":3,"key":3,"name":"CZD-20250819-00001"},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2068,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1100-4D\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7","created_by":1013,"created_at":"2025-07-28 14:46:34","updated_at":"2025-08-28 10:45:03","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CZD-20250819-00001"},{"id":16,"product_id":2068,"erp_purchase_inbound_id":13,"erp_purchase_order_id":2013,"erp_purchase_inbound_product_id":20,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-28","number":"9","outbound":"0","inventory":"9","amount":"333","total_amount":"2997","actual_amount":"34031.0368","actual_total_amount":"306279.3312","is_build":false,"created_at":"2025-08-28 10:45:03","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":13,"key":13,"name":"CGRK-20250828-00001","supplier_id":431,"purchase_contract_id":4097,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4097,"key":4097,"name":"\u6d4b\u8bd5"},"erpPurchaseInboundProjects":[]},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2068,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1100-4D\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7","created_by":1013,"created_at":"2025-07-28 14:46:34","updated_at":"2025-08-28 10:45:03","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CGRK-20250828-00001"}],"checkList":[{"id":2,"product_id":2068,"erp_purchase_inbound_id":1,"erp_purchase_order_id":2008,"erp_purchase_inbound_product_id":2,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2025-08-12","number":"2222","outbound":"134","inventory":"2088","amount":"34343","total_amount":"76310146","actual_amount":"34031.0368","actual_total_amount":"71056804.8384","is_build":false,"created_at":"2025-08-12 14:33:42","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"20","sales_outbound":"114","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erpPurchaseInbound":{"id":1,"key":1,"name":"CGRK-20250812-00001","supplier_id":678,"purchase_contract_id":4078},"erpInventoryBuild":{},"erpInventoryStart":{},"erpPurchaseGift":{},"product":{"id":2068,"name":"\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0\uff08\u9002\u7528\u4e8eAC-1000-B1100-4D\uff09","product_type":4,"product_component":51,"product_brand":12,"product_serie":231,"product_misc":"","product_qa":"","pn":"","description":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7","created_by":1013,"created_at":"2025-07-28 14:46:34","updated_at":"2025-08-28 10:45:03","pinyin_shortcut":"sxfURLxtrjV50syyAC1000B11004D","product_unit":2,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":231,"key":231,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"serial_no":"CGRK-20250812-00001","is_check":true,"used_number":"1"}],"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-28 10:46:30') RETURNING "id"

[+] Explain