ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2593edd6cf5: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2026-06-07 11:53:17 pm by 111.9.5.86

Performance Profiling

Total processing time: 192 ms; Peak memory: 5.739 MB. Show Profiling Timeline

总计66条数据
TimeDurationCategoryInfo
  
23:53:17.92235.6 msyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (4324, 4323)) GROUP BY "object_id"
23:53:18.03229.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (4324, 4323)) GROUP BY "object_id"
23:53:17.89113.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='3432' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
23:53:17.90412.1 msyii\db\Command::querySELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='3432' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
23:53:18.0207.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4324, 4323))
23:53:18.0164.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4324, 4323))
23:53:18.0043.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (2253, 2255, 2260, 2261))
23:53:17.9983.8 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_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_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at 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 (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4324, 4323) ORDER BY "id" DESC
23:53:17.9803.6 msyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (4079, 4078))
23:53:18.0083.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (2253, 2255, 2260, 2261))
23:53:18.0132.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4324, 4323))
23:53:17.9842.2 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (4079, 4078)) GROUP BY "project_id"
23:53:17.9591.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4079, 4078))
23:53:18.0681.8 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, 2, 1159, 'v2/sales-contract/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"3432","page":"1","posttime":"1780847616","token":"c1f721283b5327dc7ca75e57ac63fa59","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":4324,"client_id":3432,"signed_at":"2025-11-11","amount":"291000","handler":1001,"description":"","created_by":1001,"created_at":"2025-12-19 13:53:25","updated_at":"2026-01-07 11:36:54","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":4079,"valid_date":null,"expire_date":"2026-12-31","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"2025-12-19-002","payment_collection_remind_ahead":"1 day","from_project":4079,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-12-25 10:07:08","is_verify":false,"is_draft":false,"erp_settle_amount":"0","erp_un_settle_amount":"291000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":207,"passed":2,"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","logo":null,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":4324,"comment":7},"project":{"id":4079,"key":4079,"name":"\u6c11\u822a\u5b89\u5168\u6cd5\u5f8b\u6cd5\u89c4\u6570\u636e\u5e93\u4f18\u5316\u4e0e\u5b89\u5168\u80dc\u4efb\u529b\u6d4b\u8bc4\u7cfb\u7edf\u5f00\u53d1\u9879\u76ee","erpSalesOrder":{"id":1652,"serial_no":"XSDD-20251219-00002","from_date":null,"wrote_date":"2025-11-11","handler":1001,"client_id":3432,"purchase_contract_id":null,"project_id":4079,"sales_contract_id":4324,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:25","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"291000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5360\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-12-25\",\"amount\":\"291000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 13:38:43","updated_at":"2025-12-19 13:53:25","print_times":null,"erpSalesOrderVerifyRels":[{"id":90,"erp_sales_order_id":1652,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-19 13:53:25"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1652,"serial_no":"XSDD-20251219-00002","from_date":null,"wrote_date":"2025-11-11","handler":1001,"client_id":3432,"purchase_contract_id":null,"project_id":4079,"sales_contract_id":4324,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:25","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"291000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5360\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-12-25\",\"amount\":\"291000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 13:38:43","updated_at":"2025-12-19 13:53:25","print_times":null,"erpSalesOrderVerifyRels":[{"id":90,"erp_sales_order_id":1652,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-19 13:53:25"}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4079,"key":4079,"name":"\u6c11\u822a\u5b89\u5168\u6cd5\u5f8b\u6cd5\u89c4\u6570\u636e\u5e93\u4f18\u5316\u4e0e\u5b89\u5168\u80dc\u4efb\u529b\u6d4b\u8bc4\u7cfb\u7edf\u5f00\u53d1\u9879\u76ee","description":"","total_contact_point":"226980","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1131,"bargain_date":"2025-11-11","collected":"0","profit_pct":"3.3","budget":"291000","erpSalesOrder":{"id":1652,"serial_no":"XSDD-20251219-00002","from_date":null,"wrote_date":"2025-11-11","handler":1001,"client_id":3432,"purchase_contract_id":null,"project_id":4079,"sales_contract_id":4324,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:25","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"291000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5360\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-12-25\",\"amount\":\"291000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 13:38:43","updated_at":"2025-12-19 13:53:25","print_times":null},"projectProductTypes":[{"id":8016,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"291000","pct":"3.3","project_id":4079,"profit":"9603"}],"projectProductRels":[{"id":11337,"project_id":4079,"product_id":941,"amount":"291000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"291000","total_cost":"0","erp_sales_order_product_id":2074,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":2074,"erp_sales_order_id":1652,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"1","amount":"291000","total_amount":"291000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[{"id":1321,"project_id":4079,"contact_id":6209,"point":"226980.00","paid_point":null,"contact":{"id":6209,"key":6209,"name":"\u5f20\u79b9","client_id":3432,"supplier_id":null,"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":13815,"project_id":4079}],"reimbursementAmountSum":{"project_id":4079,"sum":"5"},"profit":9603,"contact_points_status_display":"\u672a\u6838\u9500","total_contact_paid_point":0,"total_contact_un_paid_point":226980},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8600,"user_id":1001,"key":1001,"contract_id":4324,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9640,"user_id":1001,"key":1001,"contract_id":4324,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":9641,"user_id":1011,"key":1011,"contract_id":4324,"user":{"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"}}},{"id":9642,"user_id":5360,"key":5360,"contract_id":4324,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2696,"key":2696,"contract_id":4324,"name":"2026-03-31","value":"291000","overdue_days":68,"status":0,"remind_date":"2026-03-31","pct":100,"overdue_display":"\u903e\u671f68\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":2253,"key":2253,"contract_id":4324,"value":"291000.00","attachment_id":null,"from_date":"2025-12-19","description":"","is_draft":false,"is_cancel":true,"salesInvoiceAmounts":[{"id":1092,"sales_invoice_id":2253,"amount":"291000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":54013,"object_type":102,"object_id":2253,"attachment_id":30697,"attachment":{"id":30697,"key":30697,"name":"cd08bcef-7823-3f2d-8e9a-9fe6c669029e","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/cd08bcef-7823-3f2d-8e9a-9fe6c669029e\/dzfp_25112000000288224562_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251219145326.pdf","orig_name":"dzfp_25112000000288224562_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251219145326.pdf"}}]},{"id":2261,"key":2261,"contract_id":4324,"value":"-291000.00","attachment_id":null,"from_date":"2025-12-25","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":1093,"sales_invoice_id":2261,"amount":"-291000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":54228,"object_type":102,"object_id":2261,"attachment_id":30836,"attachment":{"id":30836,"key":30836,"name":"7a3e6f53-168c-3ce0-9573-0c19d00dd069","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/7a3e6f53-168c-3ce0-9573-0c19d00dd069\/dzfp_25112000000293688355_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251225102125.pdf","orig_name":"dzfp_25112000000293688355_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251225102125.pdf"}}]}],"contractScans":[{"id":55091,"object_type":105,"object_id":4324,"attachment_id":30695,"attachment":{"id":30695,"key":30695,"name":"67f3a13c-c9d8-3716-a040-ee662cf3e9c4","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/67f3a13c-c9d8-3716-a040-ee662cf3e9c4\/\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662\u53cc\u7ae0\u5408\u540c.pdf","orig_name":"\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662\u53cc\u7ae0\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":291000,"projectProductTotalAmount":291000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":"0.00","un_invoiced":291000,"collected":"0","un_collected":291000,"is_collected":false,"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":291000},{"id":4323,"client_id":3432,"signed_at":"2025-11-11","amount":"63000","handler":1001,"description":"","created_by":1001,"created_at":"2025-12-19 13:53:15","updated_at":"2026-01-07 11:37:07","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":4078,"valid_date":null,"expire_date":"2026-12-31","sla":"","remind_ahead":"","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"2025-12-19-001","payment_collection_remind_ahead":"1 day","from_project":4078,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2025-12-25 10:07:31","is_verify":false,"is_draft":false,"erp_settle_amount":"0","erp_un_settle_amount":"63000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":207,"passed":2,"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","logo":null,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":4323,"comment":9},"project":{"id":4078,"key":4078,"name":"2025\u5e74\u6c11\u94f6\u884c\u5b89\u5168\u80fd\u529b\u5efa\u8bbe\u9879\u76ee","erpSalesOrder":{"id":1653,"serial_no":"XSDD-20251219-00003","from_date":null,"wrote_date":"2025-11-11","handler":1001,"client_id":3432,"purchase_contract_id":null,"project_id":4078,"sales_contract_id":4323,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:15","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"63000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5360\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-12-25\",\"amount\":\"63000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 13:39:18","updated_at":"2025-12-19 13:53:15","print_times":null,"erpSalesOrderVerifyRels":[{"id":91,"erp_sales_order_id":1653,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-19 13:53:15"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1653,"serial_no":"XSDD-20251219-00003","from_date":null,"wrote_date":"2025-11-11","handler":1001,"client_id":3432,"purchase_contract_id":null,"project_id":4078,"sales_contract_id":4323,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:15","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"63000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5360\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-12-25\",\"amount\":\"63000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 13:39:18","updated_at":"2025-12-19 13:53:15","print_times":null,"erpSalesOrderVerifyRels":[{"id":91,"erp_sales_order_id":1653,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-19 13:53:15"}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":4078,"key":4078,"name":"2025\u5e74\u6c11\u94f6\u884c\u5b89\u5168\u80fd\u529b\u5efa\u8bbe\u9879\u76ee","description":"","total_contact_point":"49140","paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1130,"bargain_date":"2025-11-11","collected":"0","profit_pct":"3.3","budget":"63000","erpSalesOrder":{"id":1653,"serial_no":"XSDD-20251219-00003","from_date":null,"wrote_date":"2025-11-11","handler":1001,"client_id":3432,"purchase_contract_id":null,"project_id":4078,"sales_contract_id":4323,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-19 13:53:15","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"63000","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5360\",\"5388\"],\"salesContractPaymentCollectionRemindDates\":[{\"remind_date\":\"2025-12-25\",\"amount\":\"63000\",\"pct\":\"100\"}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-19 13:39:18","updated_at":"2025-12-19 13:53:15","print_times":null},"projectProductTypes":[{"id":8017,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"63000","pct":"3.3","project_id":4078,"profit":"2079"}],"projectProductRels":[{"id":11336,"project_id":4078,"product_id":941,"amount":"63000","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"63000","total_cost":"0","erp_sales_order_product_id":2075,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":2075,"erp_sales_order_id":1653,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"1","amount":"63000","total_amount":"63000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[{"id":1322,"project_id":4078,"contact_id":6209,"point":"49140.00","paid_point":null,"contact":{"id":6209,"key":6209,"name":"\u5f20\u79b9","client_id":3432,"supplier_id":null,"client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"buildSalesOrderItems":[{"id":13816,"project_id":4078}],"reimbursementAmountSum":null,"profit":2079,"contact_points_status_display":"\u672a\u6838\u9500","total_contact_paid_point":0,"total_contact_un_paid_point":49140},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8601,"user_id":1001,"key":1001,"contract_id":4323,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9644,"user_id":1001,"key":1001,"contract_id":4323,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":9645,"user_id":1011,"key":1011,"contract_id":4323,"user":{"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"}}},{"id":9646,"user_id":5360,"key":5360,"contract_id":4323,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2697,"key":2697,"contract_id":4323,"name":"2026-03-31","value":"63000","overdue_days":68,"status":0,"remind_date":"2026-03-31","pct":100,"overdue_display":"\u903e\u671f68\u5929"}],"salesContractPayments":[],"salesContractInvoices":[{"id":2255,"key":2255,"contract_id":4323,"value":"63000.00","attachment_id":null,"from_date":"2025-12-19","description":"","is_draft":false,"is_cancel":true,"salesInvoiceAmounts":[{"id":1091,"sales_invoice_id":2255,"amount":"63000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":54012,"object_type":102,"object_id":2255,"attachment_id":30699,"attachment":{"id":30699,"key":30699,"name":"c9bf5256-645f-38e1-ae29-f31ad73d7542","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/c9bf5256-645f-38e1-ae29-f31ad73d7542\/dzfp_25112000000288169454_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251219145537.pdf","orig_name":"dzfp_25112000000288169454_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251219145537.pdf"}}]},{"id":2260,"key":2260,"contract_id":4323,"value":"-63000.00","attachment_id":null,"from_date":"2025-12-25","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":1081,"sales_invoice_id":2260,"amount":"-63000","tax_rate":"6"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":54227,"object_type":102,"object_id":2260,"attachment_id":30835,"attachment":{"id":30835,"key":30835,"name":"8a453a15-771c-3878-9676-e8c34a3f3488","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/8a453a15-771c-3878-9676-e8c34a3f3488\/dzfp_25112000000293748065_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251225102047.pdf","orig_name":"dzfp_25112000000293748065_\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662_20251225102047.pdf"}}]}],"contractScans":[{"id":55092,"object_type":105,"object_id":4323,"attachment_id":30696,"attachment":{"id":30696,"key":30696,"name":"fb3d8f01-2129-38e7-87cc-a13d4663242b","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/fb3d8f01-2129-38e7-87cc-a13d4663242b\/\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662-\u62d3\u5b9e\u5408\u540c63000\u5143.pdf","orig_name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662-\u62d3\u5b9e\u5408\u540c63000\u5143.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":63000,"projectProductTotalAmount":63000,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":1,"invoiced":"0.00","un_invoiced":63000,"collected":"0","un_collected":63000,"is_collected":false,"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":63000}],"pagenation":{"totalcount":2,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.86","ua":"jinchangxiao\/2.3.156 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-06-07 23:53:18', 187283200) RETURNING "id"
23:53:17.9751.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=133
23:53:17.9901.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
23:53:17.9711.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=941
23:53:17.9181.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3432
23:53:17.9580.9 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4079, 4078)
23:53:17.9690.9 msyii\db\Command::querySELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (4079, 4078)
23:53:18.0020.9 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4324, 4323) ORDER BY "id"
23:53:17.9700.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (4079, 4078) ORDER BY "id"
23:53:17.8820.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
23:53:17.9680.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4079, 4078))
23:53:17.9650.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (4324, 4323) ORDER BY "id" DESC
23:53:18.0030.8 msyii\db\Command::querySELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (2253, 2255, 2260, 2261) ORDER BY "id"
23:53:17.9930.6 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (4324, 4323)
23:53:17.9970.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_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4324, 4323) ORDER BY "remind_date"
23:53:17.9740.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=19
23:53:17.9770.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (2075, 2074)
23:53:17.8870.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='3432') AND ("deleted"=FALSE)
23:53:17.9890.6 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=2
23:53:18.0620.6 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4324
23:53:17.8840.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
23:53:17.9870.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4324, 4323)
23:53:18.0120.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (30699, 30697, 30835, 30836)
23:53:17.9950.5 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (4324, 4323)
23:53:17.9630.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1652, 1653) ORDER BY "id"
23:53:17.9670.5 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" IN (4079, 4078)
23:53:17.9920.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (4324, 4323)) ORDER BY "remind_date"
23:53:17.9800.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((6209, 4079), (6209, 4078))
23:53:17.9780.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (4079, 4078)
23:53:17.9640.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1652, 1653) ORDER BY "id"
23:53:18.0640.4 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4323
23:53:17.9660.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1653, 1652) ORDER BY "id"
23:53:17.9740.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=151
23:53:17.9760.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=592
23:53:17.9770.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=7
23:53:17.9950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (4324, 4323)
23:53:17.9200.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
23:53:17.9660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1653, 1652) ORDER BY "id"
23:53:17.9790.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=6209
23:53:17.9960.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 5360)
23:53:17.9210.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
23:53:17.9890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
23:53:18.0150.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (30695, 30696)
23:53:17.9970.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5360, 1011))
23:53:17.9930.2 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (4324, 4323)
23:53:17.9190.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
23:53:17.9950.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
23:53:17.9200.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
23:53:17.9790.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3432
23:53:17.9660.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1653, 1652) ORDER BY "id"
23:53:17.9940.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
23:53:17.9210.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
23:53:17.8820.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta