ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a5712ffeacf6: POST https://beta.jinchangxiao.com/vue/sales-contract/confirm-products at 2026-07-15 12:56:31 pm by 114.244.130.61

Performance Profiling

Total processing time: 29 ms; Peak memory: 5.307 MB. Show Profiling Timeline

总计21条数据
TimeDurationCategoryInfo
  
12:56:31.9842.3 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/sales-contract/confirm-products', '{"id":"4486","products":[{"name":"W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee","product_id":"2261","number":"1","amount":"99600.00","total_amount":"99600.00","description":"CPU\u3001\u663e\u5361\u4f9b\u5e94\u5546\u63d0\u4f9b3\u5e74\u4fdd\u4fee","supplier_id":"","hardware_from":"","hardware_to":"2029-06-26","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""}],"web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":{"model":[{"id":12144,"project_id":4174,"product_id":2171,"amount":"18000","number":9,"cost":"","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"162000","total_cost":"","erp_sales_order_product_id":2260,"supplier":"","product":{"id":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","product_type":7,"product_component":159,"product_brand":270,"product_serie":1724,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2025-11-24 16:16:45","updated_at":"2026-06-23 13:48:49","pinyin_shortcut":"jcxCRMrjfw","product_unit":2,"is_renew":false,"in_out_at":"2026-06-23 13:48:49.894578+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":270,"key":270,"name":"\u91d1\u7545\u900d"},"productSerie":{"id":1724,"key":1724,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2260,"erp_sales_order_id":1711,"erp_store_id":"","product_id":2171,"description":"","number":"9","outbound":"0","amount":"18000","total_amount":"162000","last_number":"","last_amount":"","last_total_amount":"","cost":"","total_cost":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":12145,"project_id":4174,"product_id":870,"amount":"1200","number":9,"cost":"0","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"10800","total_cost":"0","erp_sales_order_product_id":2261,"supplier":"","product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":"","product_qa":"","pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2261,"erp_sales_order_id":1711,"erp_store_id":"","product_id":870,"description":"","number":"9","outbound":"9","amount":"1200","total_amount":"10800","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":12146,"project_id":4174,"product_id":2232,"amount":"210375","number":9,"cost":"0","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"1893375","total_cost":"0","erp_sales_order_product_id":2262,"supplier":"","product":{"id":2232,"name":"PAN-SVC-BKLN-3440-3YR","product_type":5,"product_component":214,"product_brand":8,"product_serie":1760,"product_misc":"","product_qa":"","pn":"","description":"Partner enabled premium support 3-year term, PA-3440","created_by":1013,"created_at":"2026-01-12 11:15:06","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANSVCBKLN34403YR","product_unit":2,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1760,"key":1760,"name":"\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2262,"erp_sales_order_id":1711,"erp_store_id":"","product_id":2232,"description":"","number":"9","outbound":"9","amount":"210375","total_amount":"1893375","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":12147,"project_id":4174,"product_id":868,"amount":"1400","number":9,"cost":"0","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"12600","total_cost":"0","erp_sales_order_product_id":2263,"supplier":"","product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":"","product_qa":"","pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2263,"erp_sales_order_id":1711,"erp_store_id":"","product_id":868,"description":"","number":"9","outbound":"9","amount":"1400","total_amount":"12600","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":12148,"project_id":4174,"product_id":2232,"amount":"210375","number":7,"cost":"0","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"1472625","total_cost":"0","erp_sales_order_product_id":2264,"supplier":"","product":{"id":2232,"name":"PAN-SVC-BKLN-3440-3YR","product_type":5,"product_component":214,"product_brand":8,"product_serie":1760,"product_misc":"","product_qa":"","pn":"","description":"Partner enabled premium support 3-year term, PA-3440","created_by":1013,"created_at":"2026-01-12 11:15:06","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANSVCBKLN34403YR","product_unit":2,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1760,"key":1760,"name":"\u4e09\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2264,"erp_sales_order_id":1711,"erp_store_id":"","product_id":2232,"description":"","number":"7","outbound":"7","amount":"210375","total_amount":"1472625","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":12149,"project_id":4174,"product_id":870,"amount":"1200","number":8,"cost":"0","description":"","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","total_amount":"9600","total_cost":"0","erp_sales_order_product_id":2265,"supplier":"","product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":"","product_qa":"","pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2265,"erp_sales_order_id":1711,"erp_store_id":"","product_id":870,"description":"","number":"8","outbound":"8","amount":"1200","total_amount":"9600","last_number":"","last_amount":"","last_total_amount":"","cost":"0","total_cost":"0","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":""}},{"id":"","project_id":4174,"product_id":2261,"amount":"99600.00","number":"1","cost":"","description":"CPU\u3001\u663e\u5361\u4f9b\u5e94\u5546\u63d0\u4f9b3\u5e74\u4fdd\u4fee","supplier_id":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"2029-06-26","software_to":"","maintenance_to":"","total_amount":"99600.00","total_cost":"","erp_sales_order_product_id":"","supplier":"","product":{"id":2261,"name":"MK-MC300","product_type":4,"product_component":52,"product_brand":4,"product_serie":1769,"product_misc":"","product_qa":"","pn":"","description":"MK-MC300\u62fe\u97f3\u9ea6\u514b\u98ce\uff0c\u542b5\u7c73\u7ebf","created_by":1013,"created_at":"2026-03-16 10:07:43","updated_at":"2026-07-15 11:48:19","pinyin_shortcut":"MKMC300","product_unit":3,"is_renew":false,"in_out_at":"2026-07-15 11:48:19.040077+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":""}]},"status":1,"msg":[{"name":"success","success":"\u4ea7\u54c1\u786e\u8ba4\u5b8c\u6210","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-15 12:56:31', 21979136) RETURNING "id"
12:56:31.9730.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4174 ORDER BY "id"
12:56:31.9720.8 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4174
12:56:31.9740.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2171, 870, 2232, 868)
12:56:31.9650.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:56:31.9710.6 msyii\db\Command::querySELECT "c".* FROM "a57be577deb434"."tbl_sales_contracts" "c" WHERE "c"."id"=4486
12:56:31.9780.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (2260, 2261, 2262, 2263, 2264, 2265)
12:56:31.9660.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:56:31.9680.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:56:31.9780.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8)
12:56:31.9810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2261
12:56:31.9760.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (7, 5)
12:56:31.9640.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:56:31.9760.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (159, 214, 35)
12:56:31.9770.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (270, 8, 20)
12:56:31.9770.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1724, 1760, 551, 1223)
12:56:31.9830.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1769
12:56:31.9810.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
12:56:31.9820.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=52
12:56:31.9820.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=4
12:56:31.9830.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3