ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6882ef8f347ba: POST https://beta.jinchangxiao.com/v2/sales-contract/get-edit at 2025-07-25 10:44:31 am by 117.176.187.42

Database Queries

总计43条数据
TimeDurationTypeQuery
  
10:44:31.2254.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'

[+] Explain
10:44:31.2311.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

[+] Explain
10:44:31.2351.0 msSELECTSELECT "c".* FROM "a57be577deb434"."tbl_sales_contracts" "c" WHERE "c"."id"='3830'

[+] Explain
10:44:31.2370.8 msSELECTSELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2032

[+] Explain
10:44:31.2380.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

[+] Explain
10:44:31.2390.5 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)

[+] Explain
10:44:31.2390.6 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3800

[+] Explain
10:44:31.2402.3 msSELECTSELECT "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"=3800

[+] Explain
10:44:31.2430.9 msSELECTSELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3800

[+] Explain
10:44:31.2440.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3800

[+] Explain
10:44:31.2450.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1956, 1954, 1955, 1953, 1952)

[+] Explain
10:44:31.2460.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (2, 10, 3, 7)

[+] Explain
10:44:31.2470.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (5, 2, 199, 39, 41)

[+] Explain
10:44:31.2470.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (7, 24, 208, 6, 12)

[+] Explain
10:44:31.2480.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1607, 627, 1609, 1608, 1610)

[+] Explain
10:44:31.2490.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 3, 2)

[+] Explain
10:44:31.2491.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3800

[+] Explain
10:44:31.2512.8 msSELECTSELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id"=3800)

[+] Explain
10:44:31.2543.5 msSELECTSELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id"=3800) GROUP BY "project_id"

[+] Explain
10:44:31.2590.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=3830

[+] Explain
10:44:31.2600.5 msSELECTSELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1

[+] Explain
10:44:31.2600.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

[+] Explain
10:44:31.2610.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250)

[+] Explain
10:44:31.2620.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
10:44:31.2620.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

[+] Explain
10:44:31.2630.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)

[+] Explain
10:44:31.2630.6 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id"=3830) ORDER BY "remind_date"

[+] Explain
10:44:31.2640.2 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=3830

[+] Explain
10:44:31.2640.5 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=3830

[+] Explain
10:44:31.2650.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=3830

[+] Explain
10:44:31.2664.6 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=3830

[+] Explain
10:44:31.2720.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

[+] Explain
10:44:31.2730.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)

[+] Explain
10:44:31.2730.5 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=3830 ORDER BY "remind_date"

[+] Explain
10:44:31.2740.7 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id"=3830 ORDER BY "id"

[+] Explain
10:44:31.2750.7 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=3830 ORDER BY "id"

[+] Explain
10:44:31.2752.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=3830)

[+] Explain
10:44:31.2781.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id"=3830)

[+] Explain
10:44:31.2811.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id"=3830)

[+] Explain
10:44:31.28328.6 msSELECTSELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id"=3830) GROUP BY "object_id"

[+] Explain
10:44:31.31217.6 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id"=3830) GROUP BY "object_id"

[+] Explain
10:44:31.3341.4 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (5295, 5311)) AND ("user_status"='1') ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first

[+] Explain
10:44:31.3372.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1143, 'v2/sales-contract/get-edit', '{"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","id":"3830","posttime":"1753411456","token":"ba1e3af7b605d7796dedab9c788c1733","version_code":"1143"}', '{"code":200,"data":{"model":{"id":3830,"client_id":2032,"signed_at":"2025-03-17","amount":"615615","handler":5295,"description":"","created_by":5250,"created_at":"2025-04-11 11:00:39","updated_at":"2025-04-11 11:00:39","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3800,"valid_date":null,"expire_date":null,"sla":null,"remind_ahead":null,"expire_remind_ahead":null,"expire_reminded":false,"serial_no":null,"payment_collection_remind_ahead":null,"from_project":3800,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":"2025-06-28 17:41:05.610438+08","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8)","logo":null,"sales_rep":5295,"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":3800,"key":3800,"name":"26\u5e74\u9632\u706b\u5899\u7eed\u4fdd"},"fromProject":{"id":3800,"key":3800,"name":"26\u5e74\u9632\u706b\u5899\u7eed\u4fdd","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":807,"bargain_date":"2025-03-17","collected":"0","profit_pct":"19.98","budget":"615615","projectProductTypes":[{"id":6265,"product_type_id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9","budget":"123123","pct":"0","project_id":3800,"profit":"0"},{"id":6266,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"246246","pct":"0","project_id":3800,"profit":"0"},{"id":6267,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"123123","pct":"0","project_id":3800,"profit":"0"},{"id":6268,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"123123","pct":"99.9","project_id":3800,"profit":"122999.877"}],"projectProductRels":[{"id":9039,"project_id":3800,"product_id":1956,"amount":"123123.00","number":1,"cost":"123.00","description":"","supplier_id":null,"hardware_from":"2025-04-17","software_from":"2025-04-23","maintenance_from":"2025-04-17","hardware_to":"2025-05-23","software_to":"2025-05-16","maintenance_to":"2025-05-22","total_amount":"123123","total_cost":"123","supplier":null,"product":{"id":1956,"name":"\u6df1\u4fe1\u670d\u7aef\u70b9\u5b89\u5168\u8f6f\u4ef6V6.0\uff08PC\u5168\u91cf\u7248\uff09","product_type":7,"product_component":41,"product_brand":12,"product_serie":1610,"product_misc":null,"product_qa":null,"pn":"","description":"\u6df1\u4fe1\u670d\u7edf\u4e00\u7aef\u70b9\u5b89\u5168\u7ba1\u7406\u7cfb\u7edfV6.0\uff08aES\uff09","created_by":1013,"created_at":"2025-03-10 09:19:22","updated_at":"2025-03-10 09:19:22","pinyin_shortcut":"sxfddaqrjV60PCqlb","product_unit":2,"is_renew":false,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1610,"key":1610,"name":"\u6df1\u4fe1\u670d\u7aef\u70b9\u5b89\u5168\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":9040,"project_id":3800,"product_id":1954,"amount":"123123.00","number":1,"cost":"123123.00","description":"","supplier_id":null,"hardware_from":"2025-04-09","software_from":"2025-04-18","maintenance_from":"2025-04-18","hardware_to":"2025-05-16","software_to":"2025-05-07","maintenance_to":"2025-05-22","total_amount":"123123","total_cost":"123123","supplier":null,"product":{"id":1954,"name":"114-00087+C0","product_type":3,"product_component":39,"product_brand":6,"product_serie":1608,"product_misc":null,"product_qa":null,"pn":"","description":"NetApp FAS2XXX 750W\u7535\u6e90","created_by":1013,"created_at":"2025-03-06 10:01:07","updated_at":"2025-03-07 17:56:13","pinyin_shortcut":"11400087C0","product_unit":3,"is_renew":false,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":6,"key":6,"name":"NetAPP"},"productSerie":{"id":1608,"key":1608,"name":"NetApp FAS\u7cfb\u5217\u7535\u6e90"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":9041,"project_id":3800,"product_id":1955,"amount":"123123.00","number":1,"cost":"123123.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"123123","total_cost":"123123","supplier":null,"product":{"id":1955,"name":"NVIDIA RTX A4090","product_type":10,"product_component":199,"product_brand":208,"product_serie":1609,"product_misc":null,"product_qa":null,"pn":"","description":"NVIDIA RTX A4090 48G \u663e\u5361","created_by":1013,"created_at":"2025-03-07 14:01:45","updated_at":"2025-03-07 14:01:45","pinyin_shortcut":"NVIDIARTXA4090","product_unit":3,"is_renew":false,"productType":{"id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},"productComponent":{"id":199,"key":199,"name":"\u5de5\u4f5c\u7ad9\u914d\u4ef6"},"productBrand":{"id":208,"key":208,"name":"NVIDIA"},"productSerie":{"id":1609,"key":1609,"name":"NVIDIA RTX A4090 48G \u56fe\u5f62\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":9042,"project_id":3800,"product_id":1953,"amount":"123123.00","number":1,"cost":"123123.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"123123","total_cost":"123123","supplier":null,"product":{"id":1953,"name":"CS5260H2","product_type":2,"product_component":2,"product_brand":24,"product_serie":627,"product_misc":null,"product_qa":null,"pn":"","description":"2*\u6d77\u51495380 32\u6838 2.5G CPU\/4*32G\u5185\u5b58\/2*8T SATA\u786c\u76d8\/\u9635\u5217\u5361 PM8204 2G\/\u96c6\u6210\u53cc\u53e3\u5343\u5146\/2*800W \u7535\u6e90","created_by":1013,"created_at":"2025-03-04 14:48:05","updated_at":"2025-03-04 14:48:05","pinyin_shortcut":"CS5260H2","product_unit":null,"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":24,"key":24,"name":"\u6d6a\u6f6e"},"productSerie":{"id":627,"key":627,"name":"CS5260H\u670d\u52a1\u5668"},"productUnit":null}},{"id":9043,"project_id":3800,"product_id":1952,"amount":"123123.00","number":1,"cost":"123123.00","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"123123","total_cost":"123123","supplier":null,"product":{"id":1952,"name":"02311HAN","product_type":2,"product_component":5,"product_brand":7,"product_serie":1607,"product_misc":null,"product_qa":null,"pn":"","description":"1200GB-SAS 12Gb\/s-10K-128MB\u53ca\u4ee5\u4e0a-2.5\u82f1\u5bf8(2.5\u82f1\u5bf8\u6258\u67b6)","created_by":1013,"created_at":"2025-03-04 09:41:51","updated_at":"2025-03-04 09:41:51","pinyin_shortcut":"02311HAN","product_unit":4,"is_renew":false,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":7,"key":7,"name":"\u534e\u4e3a"},"productSerie":{"id":1607,"key":1607,"name":"SAS\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":122999.877,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractScan":null,"receiptScan":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8071,"user_id":5295,"key":5295,"contract_id":3830,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"commentCount":null,"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":615615,"projectProductAllAmount":true,"projectProductTotalCost":492615,"projectProductAllCost":true,"projectProductTotalCount":5,"invoiced":0,"un_invoiced":615615,"collected":0,"un_collected":615615,"is_collected":false,"handlerPerson":{"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"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":false,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},"options":[{"key":"SalesContracts[contract_type]","name":"\u5408\u540c\u7c7b\u578b","value":[{"key":"1","name":"\u4ea7\u54c1\u9500\u552e"},{"key":"2","name":"\u8fd0\u7ef4\u670d\u52a1"}]},{"key":"SalesContracts[handler]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5311,"name":"\u62d3\u5c0f\u6587"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"key":0,"name":"\u516c\u6d77\u5ba2\u6237"}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-25 10:44:31') RETURNING "id"

[+] Explain