ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3cabb0e897d: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-line at 2026-06-25 12:16:48 pm by 221.216.117.25

Database Queries

总计27条数据
TimeDurationTypeQuery
  
12:16:48.9581.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
12:16:48.9600.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
12:16:48.9640.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='1372'

[+] Explain
12:16:48.9660.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4

[+] Explain
12:16:48.9660.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=43

[+] Explain
12:16:48.9670.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134

[+] Explain
12:16:48.9670.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1047

[+] Explain
12:16:48.9680.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=6

[+] Explain
12:16:48.9680.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

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

[+] Explain
12:16:48.9700.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=7

[+] Explain
12:16:48.9711.7 msSELECTSELECT esosps.id, esosps.erp_sales_outbound_id, esosps.product_id, t.created_at, sum(eipss.total_amount) as amount, sum(eipss.actual_total_amount) as cost FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("esosps"."product_id"=1372) AND ("t"."status"=2) GROUP BY "esosps"."id", "t"."created_at" ORDER BY "t"."created_at", "esosps"."id"

[+] Explain
12:16:48.9730.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id" IN (4, 37)

[+] Explain
12:16:48.9741.1 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2762, 304)

[+] Explain
12:16:48.9760.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 5087)

[+] Explain
12:16:48.9760.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5087))

[+] Explain
12:16:48.9770.4 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3910, 3990)

[+] Explain
12:16:48.9780.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011

[+] Explain
12:16:48.9780.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)

[+] Explain
12:16:48.9790.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3

[+] Explain
12:16:48.9790.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1372

[+] Explain
12:16:48.9800.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4

[+] Explain
12:16:48.9800.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=43

[+] Explain
12:16:48.9810.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=134

[+] Explain
12:16:48.9810.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1047

[+] Explain
12:16:48.9821.1 msSELECTSELECT COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esosps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON esosps.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_spent_product_id = esosps.id WHERE ("esosps"."product_id"=1372) AND ("t"."status"=2)

[+] Explain
12:16:48.9851.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-inventory-product/product-line', '{"id":"1372","group":"","web_access_token":"7LgdA-fwaL4edHIby8qzjyOs3PMafGDj"}', '{"code":2000,"result":{"model":{"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":"2026-04-23 16:19:02","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-04-23 16:19:02.133182+08","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"},"productMisc":"","productUnit":{"id":6,"key":6,"name":"\u6761"},"productQa":"","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"}},"sales_cost":"575","sales_amount":"240","profit":-335,"profit_pct":-139.58},"category":{"amountCategory":["2025-08-15 11:06:33","2025-10-16 15:00:43"],"costCategory":["2025-08-15 11:06:33","2025-10-16 15:00:43"]},"seriesAmount":[{"key":11,"name":"2025-08-15 11:06:33","model":{"id":11,"erp_sales_outbound_id":4,"product_id":1372,"created_at":"2025-08-15 11:06:33","amount":"0","cost":"475","erpSalesOutbound":{"id":4,"serial_no":"XSCKD-20250815-00001","from_date":"","wrote_date":"2025-08-15","handler":5087,"erp_sales_order_id":1538,"client_id":2762,"project_id":3910,"erp_store_id":1,"status":2,"erp_send_type_id":2,"abstract":"\u542b\u7a0e","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-08-15 16:51:08","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"83","amount":"2803980","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":true,"is_used":false,"created_at":"2025-08-15 11:06:33","updated_at":"2025-08-15 16:51:08","print_times":"","is_sales_order_ready":true,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":5087,"logo":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","bargain_date":"2025-07-11"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}}},"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":"2026-04-23 16:19:02","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-04-23 16:19:02.133182+08","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"}}},"y":"0"},{"key":105,"name":"2025-10-16 15:00:43","model":{"id":105,"erp_sales_outbound_id":37,"product_id":1372,"created_at":"2025-10-16 15:00:43","amount":"240","cost":"100","erpSalesOutbound":{"id":37,"serial_no":"XSCKD-20251016-00003","from_date":"","wrote_date":"2025-10-16","handler":5295,"erp_sales_order_id":1592,"client_id":304,"project_id":3990,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u542b\u7a0e\uff0c\u5229\u6da6\u738714.46%\uff0c\u6536\u8d27\u4eba\uff1a\u738b\u96ea\u598d","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-10-16 15:36:16","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"21","amount":"15490","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2025-10-16 15:00:43","updated_at":"2025-10-16 15:36:16","print_times":"","is_sales_order_ready":true,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3990,"key":3990,"name":"\u65b0\u8d2d\u534e\u4e3a\u4ea4\u6362\u673a","bargain_date":"2025-09-29"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}}},"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":"2026-04-23 16:19:02","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-04-23 16:19:02.133182+08","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"}}},"y":"240"}],"seriesCost":[{"key":11,"name":"2025-08-15 11:06:33","model":{"id":11,"erp_sales_outbound_id":4,"product_id":1372,"created_at":"2025-08-15 11:06:33","amount":"0","cost":"475","erpSalesOutbound":{"id":4,"serial_no":"XSCKD-20250815-00001","from_date":"","wrote_date":"2025-08-15","handler":5087,"erp_sales_order_id":1538,"client_id":2762,"project_id":3910,"erp_store_id":1,"status":2,"erp_send_type_id":2,"abstract":"\u542b\u7a0e","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-08-15 16:51:08","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"83","amount":"2803980","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":true,"is_used":false,"created_at":"2025-08-15 11:06:33","updated_at":"2025-08-15 16:51:08","print_times":"","is_sales_order_ready":true,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":5087,"logo":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","bargain_date":"2025-07-11"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}}},"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":"2026-04-23 16:19:02","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-04-23 16:19:02.133182+08","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"}}},"y":"475"},{"key":105,"name":"2025-10-16 15:00:43","model":{"id":105,"erp_sales_outbound_id":37,"product_id":1372,"created_at":"2025-10-16 15:00:43","amount":"240","cost":"100","erpSalesOutbound":{"id":37,"serial_no":"XSCKD-20251016-00003","from_date":"","wrote_date":"2025-10-16","handler":5295,"erp_sales_order_id":1592,"client_id":304,"project_id":3990,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u542b\u7a0e\uff0c\u5229\u6da6\u738714.46%\uff0c\u6536\u8d27\u4eba\uff1a\u738b\u96ea\u598d","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2025-10-16 15:36:16","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"21","amount":"15490","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"is_used":false,"created_at":"2025-10-16 15:00:43","updated_at":"2025-10-16 15:36:16","print_times":"","is_sales_order_ready":true,"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3990,"key":3990,"name":"\u65b0\u8d2d\u534e\u4e3a\u4ea4\u6362\u673a","bargain_date":"2025-09-29"},"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}}},"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":"2026-04-23 16:19:02","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-04-23 16:19:02.133182+08","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"}}},"y":"100"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/26.5 Safari\/605.1.15"}', FALSE, '2026-06-25 12:16:48', 31111936) RETURNING "id"

[+] Explain