ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a589f0f797a2: POST https://beta.jinchangxiao.com/vue/sales-contract/save-edit at 2026-07-16 05:06:23 pm by 114.244.130.25

Performance Profiling

Total processing time: 212 ms; Peak memory: 7.074 MB. Show Profiling Timeline

总计172条数据
TimeDurationCategoryInfo
  
17:06:23.61522.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3465) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:06:23.7004.8 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/save-edit', '{"SalesContracts":{"id":"4505","client_id":"3465","project_id":"4183","project_name":"\u96f6\u552e001","amount":"385200","contract_scan":"","receipt_scan":"","contract_type":"1","serial_no":"TSKJ&KTJT20260626001","signed_at":"2026-06-26","budget":"385200","profit":"38520","profit_pct":"10","description":"","expire_date":"2026-07-16","expire_remind_ahead":"","project_product_version_id":"1390","salesContractPayments":{"new":[""]},"salesContractPaymentCollectionRemindDates":{"2026-06-09":"18000"},"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001"],"sla":"","including_tax":"1","remind_ahead":"","contractFileList":{"32809":"xs.pdf"},"contractScans":["32843","32842"],"is_draft":"0","is_settle":"0","is_deliver":"0","is_outbound":"0","client_name":"\u96f6\u552e001","projectContactPoints":"","projectContactPointRels":"","serviceContractRemindDates":"","salesSupplierRels":"","projectProductRels":{"12211":{"product_id":"2171","amount":"18000","total_amount":"18000","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12212":{"product_id":"2267","amount":"42000","total_amount":"84000","number":"2","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12213":{"product_id":"2267","amount":"99600","total_amount":"99600","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12214":{"product_id":"868","amount":"42000","total_amount":"84000","number":"2","description":"GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12215":{"product_id":"2232","amount":"99600","total_amount":"99600","number":"1","description":"W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}},"salesContractInvoices":"","projectProductTypes":{"7":{"budget":"18000","profit":"1800","pct":"10"},"23":{"budget":"183600","profit":"18360","pct":"10"},"5":{"budget":"183600","profit":"18360","pct":"10"}},"salesContractRemindReceivers":"","serviceContractRemindReceivers":""},"web_access_token":"8xqSDHkpxFShwMjatgql1iJNjJHyfMBa"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9500\u552e\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-16 17:06:23', 201978880) RETURNING "id"
17:06:23.5993.5 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4505)
17:06:23.5543.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:06:23.5833.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4505)
17:06:23.6833.0 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=106))
17:06:23.6862.9 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=107))
17:06:23.6892.9 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=105))
17:06:23.6451.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:06:23.5671.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:06:23.6681.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:06:23.6781.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:06:23.6131.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3465
17:06:23.5131.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "serial_no"='TSKJ&KTJT20260626001' LIMIT 2
17:06:23.5651.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "contract_type"=1 WHERE "id"=4183
17:06:23.6541.2 msyii\db\Command::querySELECT SUM(r.amount) 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"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
17:06:23.5601.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC
17:06:23.6561.1 msyii\db\Command::querySELECT SUM(r.amount) 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"=4505) AND ("t"."status" IN (2, 5))
17:06:23.5691.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5081.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4505'
17:06:23.6721.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4183 ORDER BY "created_at" DESC
17:06:23.5291.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id"
17:06:23.6521.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 4183, 1, 4505, 7, 1001, '4505', '4505', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ&KTJT20260626001"]}') RETURNING "id"
17:06:23.6571.0 msyii\db\Command::querySELECT SUM(r.amount) 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"=4505) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
17:06:23.5941.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.6381.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3465, 1001, 'now()', NULL) RETURNING "id"
17:06:23.5961.0 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
17:06:23.5770.9 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1721)
17:06:23.5250.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4183, 7, '软件', '18000', 10, '1800'), (4183, 23, '礼品', '183600', 10, '18360'), (4183, 5, '安全设备', '183600', 10, '18360')
17:06:23.6630.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='385200', "erp_all_settle_amount"='0' WHERE "id"=4505
17:06:23.5580.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.5210.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4183
17:06:23.6820.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4505) AND (amount > paid_amount) ORDER BY "remind_date"
17:06:23.6030.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (105, 4505, 32843), (105, 4505, 32842)
17:06:23.5740.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_invoices" WHERE "project_id"=4183
17:06:23.5520.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "budget"='385200', "profit_pct"='10', "project_product_version_id"=1390 WHERE "id"=4183
17:06:23.5880.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'contractScans', 4505, 7, 1001, 'now()', '[["32843","32842"]]', '"32809"', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c","d4":[""]}')
17:06:23.5430.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12211, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.6070.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4505, 1001) RETURNING "id"
17:06:23.5010.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1013
17:06:23.5150.7 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465')
17:06:23.5970.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "is_system", "description", "description2") VALUES (1001, '7', 4505, TRUE, '刘人诚上传了合同', '商机：零售001；客户：零售001') RETURNING "id"
17:06:23.6670.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4183
17:06:23.5760.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC
17:06:23.5200.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183
17:06:23.5810.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4505
17:06:23.5830.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=4183
17:06:23.6440.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=4183
17:06:23.5780.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "client_id"=3465, "amount"='385200', "updated_at"='now()', "contract_scan"=NULL, "receipt_scan"=NULL, "contract_type"=1, "project_id"=4183, "remind_ahead"='0 day', "expire_remind_ahead"='0 day', "including_tax"=TRUE, "is_settle"=FALSE, "is_deliver"=FALSE, "is_draft"=FALSE WHERE "id"=4505
17:06:23.6610.6 msyii\db\Command::querySELECT SUM(r.amount) 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"=4505) AND ("t"."status" IN (1, 2, 5))
17:06:23.5030.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:06:23.5900.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4505
17:06:23.6760.6 msyii\db\Command::querySELECT r.amount, t.wrote_date as created_at 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"=4505) AND ("t"."status" IN (2, 5, 1))
17:06:23.6740.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4505
17:06:23.5260.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4183
17:06:23.6620.6 msyii\db\Command::querySELECT SUM(r.amount) 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"=4505) AND ("t"."status" IN (1, 2, 5))
17:06:23.5170.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183')
17:06:23.6050.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4505
17:06:23.5410.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183
17:06:23.5720.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4505
17:06:23.6600.5 msyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4505) AND ("t"."status"=1))
17:06:23.5220.5 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4183
17:06:23.6590.5 msyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4505) AND ("t"."status"=1))
17:06:23.5710.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.5630.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "number"='7', "amount"='385200' WHERE "id"=1721
17:06:23.5270.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4183
17:06:23.6710.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.5750.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4505
17:06:23.5620.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:06:23.6100.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4505
17:06:23.5040.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:06:23.5580.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5740.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183
17:06:23.6660.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183
17:06:23.6750.4 msyii\db\Command::querySELECT r.amount, t.created_at 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"=4505) AND ("t"."status" IN (2, 5, 1))
17:06:23.6110.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465'
17:06:23.5890.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:06:23.5310.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2171
17:06:23.5160.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
17:06:23.5880.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:06:23.6530.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 172101, 'a:15:{s:2:"id";i:172101;s:9:"object_id";s:4:"4183";s:11:"object_type";i:1;s:9:"target_id";i:4505;s:18:"target_object_type";i:7;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:4:"4505";s:9:"new_value";s:4:"4505";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";s:6:"params";a:0:{}}s:11:"description";s:144:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ&KTJT20260626001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '114.244.130.25')
17:06:23.6110.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505
17:06:23.6410.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3465, 10, 4505, 7, 1001, '[4505]', '[4505]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ&KTJT20260626001"]}') RETURNING "id"
17:06:23.6810.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.6510.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:06:23.6590.4 msyii\db\Command::querySELECT EXISTS(SELECT "r".* 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"=4505) AND ("t"."status"=1))
17:06:23.6930.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.6470.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.5910.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465'
17:06:23.6090.4 msyii\db\Command::querySELECT "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=4505
17:06:23.5920.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505
17:06:23.6610.4 msyii\db\Command::querySELECT SUM(r.amount) 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"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
17:06:23.6400.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:06:23.6500.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465'
17:06:23.5800.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465'
17:06:23.5460.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2267, "amount"='99600', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12213
17:06:23.6040.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4505
17:06:23.5480.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12214, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.6420.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183'
17:06:23.6490.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643568, 'a:13:{s:2:"id";i:643568;s:9:"object_id";s:4:"4183";s:11:"object_type";i:1;s:9:"target_id";i:4505;s:18:"target_object_type";i:7;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4505]";s:9:"new_value";s:6:"[4505]";s:11:"description";s:144:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ&KTJT20260626001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25')
17:06:23.5470.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12213, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.6700.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.6490.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 4183, 1, 4505, 7, 1001, '[4505]', '[4505]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ&KTJT20260626001"]}') RETURNING "id"
17:06:23.6930.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5410.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12211
17:06:23.5990.4 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1001) AND ("id" != 1001) AND (channel_id IS NOT NULL)
17:06:23.6770.4 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4505
17:06:23.5930.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183
17:06:23.5420.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2171, "amount"='18000', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12211
17:06:23.6650.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465
17:06:23.6810.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.6480.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:06:23.6390.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 200065, 'a:5:{s:2:"id";i:200065;s:9:"client_id";i:3465;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.244.130.25')
17:06:23.6730.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505
17:06:23.5500.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12215, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5820.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4505
17:06:23.6070.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4505
17:06:23.5790.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:2:{s:12:"remind_ahead";s:5:"0 day";s:19:"expire_remind_ahead";s:5:"0 day";}', '', 1001, '114.244.130.25')
17:06:23.6050.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4505
17:06:23.5010.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:06:23.5450.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12212, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
17:06:23.5800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183'
17:06:23.6940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183
17:06:23.5340.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2267
17:06:23.5450.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2267, "amount"='42000', "number"=2, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12212
17:06:23.5170.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
17:06:23.5720.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1
17:06:23.6640.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5640.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1721, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.6770.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183
17:06:23.5230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7
17:06:23.5480.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=868, "amount"='42000', "number"=2, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12214
17:06:23.5490.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2232, "amount"='99600', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12215
17:06:23.6650.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183
17:06:23.5980.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 221109, 'a:11:{s:2:"id";i:221109;s:9:"object_id";i:4505;s:11:"object_type";s:1:"7";s:6:"parent";N;s:11:"description";s:24:"刘人诚上传了合同";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:39:"商机：零售001；客户：零售001";}', '', 1001, '114.244.130.25')
17:06:23.6080.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContractPaymentCollectionRemindReceivers', 10189, 'a:3:{s:2:"id";i:10189;s:11:"contract_id";i:4505;s:7:"user_id";s:4:"1001";}', '', 1001, '114.244.130.25')
17:06:23.6470.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5180.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
17:06:23.5490.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12215
17:06:23.6420.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643567, 'a:13:{s:2:"id";i:643567;s:9:"object_id";s:4:"3465";s:11:"object_type";i:10;s:9:"target_id";i:4505;s:18:"target_object_type";i:7;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4505]";s:9:"new_value";s:6:"[4505]";s:11:"description";s:144:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:TSKJ&KTJT20260626001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25')
17:06:23.5440.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12212
17:06:23.5330.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2267
17:06:23.5330.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
17:06:23.5180.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183)
17:06:23.5470.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12214
17:06:23.5370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
17:06:23.5270.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4183
17:06:23.5460.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12213
17:06:23.5340.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=868
17:06:23.5390.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='868'
17:06:23.5380.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2267'
17:06:23.5370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2267'
17:06:23.6400.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 3465, 'a:0:{}', '', 1001, '114.244.130.25')
17:06:23.5400.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
17:06:23.5280.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4183
17:06:23.5350.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2232
17:06:23.5360.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2171'
17:06:23.5340.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
17:06:23.5400.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2232'
17:06:23.5370.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
17:06:23.5240.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23
17:06:23.5730.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1
17:06:23.5380.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
17:06:23.5390.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8
17:06:23.5500.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1
17:06:23.5240.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
17:06:23.5360.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2
17:06:23.5350.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8
17:06:23.6100.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4505
17:06:23.6090.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("contract_id"=4505) AND (0=1)
17:06:23.5280.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1