ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a55edbecb752: POST https://beta.jinchangxiao.com/v2/purchase-contract/of-supplier at 2026-07-14 04:05:18 pm by 39.156.194.178

Performance Profiling

Total processing time: 259 ms; Peak memory: 5.109 MB. Show Profiling Timeline

总计40条数据
TimeDurationCategoryInfo
  
16:05:18.94954.7 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=13) AND ("object_id"=2114) GROUP BY "object_id"
16:05:19.04523.7 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=13) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=2114) GROUP BY "object_id"
16:05:18.91812.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=8747
16:05:18.93410.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
16:05:18.88710.6 msyii\db\Command::querySELECT c.*, c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("supplier"."id"='431') AND ("cost_type" IN (1, 2)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10 OFFSET 20
16:05:19.0108.2 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "collected_date", "created_at", "created_by", "description" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5) )) "sub") "r" WHERE "contract_id"=2114 ORDER BY "id" DESC
16:05:18.9087.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "account_number" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431
16:05:18.8786.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, c.total_contact_point - c.paid_contact_point as un_paid_contact_point FROM "a57be577deb434"."tbl_purchase_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_suppliers" "supplier" ON supplier.id = c.supplier_id LEFT JOIN "a57be577deb434"."tbl_purchase_client_rels" "pcr" ON pcr.contract_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON pcr.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT "contract_id", sum(amount) as collected_plan FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" GROUP BY "contract_id") "pcpcrd" ON pcpcrd.contract_id = c.id WHERE ("supplier"."id"='431') AND ("cost_type" IN (1, 2)) GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
16:05:18.8496.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:05:19.0233.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=21) AND ("object_id"=1064)
16:05:19.0313.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=108) AND ("object_id"=2114)
16:05:19.0263.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=103) AND ("object_id"=1064)
16:05:19.0353.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=111) AND ("object_id"=2114)
16:05:19.0802.6 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/purchase-contract/of-supplier', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"431","page":"3","token":"48b3ef3b3c85d9cd35b6271f838a72fc","posttime":"1784016318"}', '{"code":200,"data":{"list":[{"id":2114,"supplier_id":431,"contract_type":1,"signed_at":"2021-09-28","amount":"116250.00","handler":1011,"description":"\u540c\u65b9\u4ea7\u54c19\u4e2a\u53f0\u5f0f\u673a+1\u53f0\u670d\u52a1\u5668","contract_scan":8747,"created_by":1011,"created_at":"2021-10-26 11:38:52","updated_at":"2021-11-02 12:48:09","client_id":null,"project_id":null,"sales_rep":null,"serial_no":"BJHLXT-GFJ-20210928","payment_collection_remind_ahead":null,"including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"116250","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":null,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"116250","total_contact_point":null,"paid_contact_point":null,"is_edit_verify":false,"is_chargeback_verify":false,"un_paid_contact_point":null,"client":null,"project":null,"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","account_number":""},"contractScan":{"id":8747,"key":8747,"name":"\/files\/protected\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f609df31-7812-3336-891c-23ed5a4a25a2\/2021_11_02_12_40_16.pdff609df31-7812-3336-891c-23ed5a4a25a2.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f609df31-7812-3336-891c-23ed5a4a25a2\/2021_11_02_12_40_16.pdf","orig_name":"2021_11_02_12_40_16.pdf","download":"\/vue\/attachment\/download?name=f609df31-7812-3336-891c-23ed5a4a25a2"},"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"}},"handlerPerson":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"commentCount":null,"purchaseClientRels":[{"id":873,"contract_id":2114,"client_id":14,"project_id":null,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004,"clickable":1},"project":null}],"purchaseContractPayments":[{"id":"1670","key":"1670","contract_id":2114,"amount":"36015.00","value":"36015.00","collected_date":"2021-11-12 00:00:00","created_at":"2021-11-12 09:39:38","created_by":1011,"description":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"pct":30.98},{"id":"1669","key":"1669","contract_id":2114,"amount":"80235.00","value":"80235.00","collected_date":"2021-11-02 00:00:00","created_at":"2021-11-02 12:48:56","created_by":1011,"description":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"pct":69.02}],"purchaseContractInvoices":[{"id":1064,"key":1064,"contract_id":2114,"amount":"116250.00","value":"116250.00","attachment_id":8748,"from_date":"2021-10-28","description":null,"is_draft":true,"is_cancel":false,"purchaseInvoiceAmounts":[{"id":4027,"purchase_invoice_id":1064,"amount":"116250.00","tax_rate":"13"}],"attachment":{"id":8748,"key":8748,"name":"f3e64ea0-da71-3e3a-91e9-aa873b851e9a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f3e64ea0-da71-3e3a-91e9-aa873b851e9a\/2021_11_02_12_40_03.pdf","orig_name":"2021_11_02_12_40_03.pdf"},"attachmentRelationships":[],"files":[{"id":7598,"object_type":103,"object_id":1064,"attachment_id":8748,"attachment":{"id":8748,"key":8748,"name":"f3e64ea0-da71-3e3a-91e9-aa873b851e9a","extension":"pdf","path":"\/v2\/attachment\/view\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f3e64ea0-da71-3e3a-91e9-aa873b851e9a\/2021_11_02_12_40_03.pdf","orig_name":"2021_11_02_12_40_03.pdf"}}]}],"contractScans":[{"id":14518,"object_type":108,"object_id":2114,"attachment_id":8747,"attachment":{"id":8747,"key":8747,"name":"f609df31-7812-3336-891c-23ed5a4a25a2","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f609df31-7812-3336-891c-23ed5a4a25a2\/2021_11_02_12_40_16.pdf","orig_name":"2021_11_02_12_40_16.pdf"}}],"receiptScans":[],"purchaseContractPaymentCollectionRemindReceivers":[],"purchaseContractPaymentCollectionRemindDates":[],"paymentApproves":[],"costContractAmounts":[],"unreadComments":null,"purchaseContractProductRels":[],"erpPurchaseOrder":{"id":908,"serial_no":"CGDD-20211026-00001","from_date":null,"wrote_date":"2021-09-28","handler":1011,"supplier_id":431,"purchase_contract_id":2114,"erp_store_id":null,"status":2,"abstract":null,"description":"\u540c\u65b9\u4ea7\u54c19\u4e2a\u53f0\u5f0f\u673a+1\u53f0\u670d\u52a1\u5668","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-10-26 11:38:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_used":false,"is_done":true,"is_settle":true,"number":"0","amount":"116250.00","created_by":1011,"stop_description":null,"inventory_status":false,"is_cancel":false,"is_old":true,"created_at":"2021-10-26 11:38:52","updated_at":"2021-11-02 12:48:09","print_times":null,"erpPurchaseOrderVerifyRels":[],"erpPurchaseOrderStopVerifyRels":[],"erpPurchaseOrderCancelVerifyRels":[]},"erpPurchaseCost":null,"purchaseContractContactPoints":[],"invoiced":"116250.00","approve_amount":0,"un_approve_amount":116250,"un_invoiced":0,"payment_collection_remind_ahead_display":"\u65e0","contract_type_display":"\u4ea7\u54c1\u5408\u540c","collected":"116250","un_collected":0,"collected_plan":0,"is_collected":true,"can_update":true,"can_update_cost":false,"can_update_file":true,"can_delete":true,"can_resubmit":false,"unread":0,"bgcolor":"#89c541","product_amount":0,"product_number":0,"is_done":true,"cost_done_display":false,"cost_un_done_display":false,"done_display":true,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"erp_all_un_settle_amount":0,"advance_purchase":false}],"pagenation":{"totalcount":21,"thispage":3,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-14 16:05:19', 244951808) RETURNING "id"
16:05:19.0422.3 msyii\db\Command::querySELECT "pt".*, "taxonomy_id" AS "key", "tt"."name" AS "name", "out_amount" AS "amount", "value" AS "description", "extra_int" AS "parent_id", "tt"."serial_no" FROM "a57be577deb434"."tbl_term_taxonomy_relationships" "pt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON taxonomy_id = tt.id WHERE ("pt"."term_id"=18) AND ("pt"."object_type"=8) AND ("pt"."object_id"=2114) ORDER BY "id"
16:05:19.0402.2 msyii\db\Command::querySELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) AND ("r"."purchase_contract_id"=2114) GROUP BY "r"."id"
16:05:18.8381.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
16:05:19.0701.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "purchase_contract_id"=2114
16:05:19.0761.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2114) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))
16:05:19.0201.1 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "contract_id"=2114 ORDER BY "id"
16:05:19.0210.8 msyii\db\Command::querySELECT "id", "purchase_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_purchase_invoice_amounts" WHERE "purchase_invoice_id"=1064 ORDER BY "id"
16:05:19.0690.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_product_rels" WHERE "purchase_contract_id"=2114
16:05:19.0080.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=2114 ORDER BY "id"
16:05:19.0740.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=2114
16:05:19.0380.6 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_receivers" WHERE "contract_id"=2114
16:05:19.0390.6 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id"=2114 ORDER BY "remind_date"
16:05:19.0720.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_verify_rels" WHERE "erp_purchase_order_id"=908 ORDER BY "id"
16:05:18.9470.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
16:05:19.0740.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_cancel_verify_rels" WHERE "erp_purchase_order_id"=908 ORDER BY "id"
16:05:19.0090.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=14
16:05:19.0730.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_stop_verify_rels" WHERE "erp_purchase_order_id"=908 ORDER BY "id"
16:05:18.9490.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
16:05:19.0190.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
16:05:19.0750.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_contact_points" WHERE "purchase_contract_id"=2114
16:05:18.8370.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:05:19.0300.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=8748
16:05:18.9480.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
16:05:18.9480.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
16:05:19.0340.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=8747
16:05:19.0220.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=8748