ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a224216673e8: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2026-06-05 11:27:18 am by 221.216.117.119

Performance Profiling

Total processing time: 180 ms; Peak memory: 6.837 MB. Show Profiling Timeline

总计150条数据
TimeDurationCategoryInfo
  
11:27:18.53638.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=93) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.4555.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("project_id"=4146) AND (erp_sales_outbound_id is not null)
11:27:18.5902.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" ("erp_sales_order_id", "user_id", "status") VALUES (1719, 1001, 0)
11:27:18.5052.6 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"=4497) AND ("t"."status"=1))
11:27:18.4482.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4146) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.4612.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4146) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.5132.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='500000', "erp_all_settle_amount"='0' WHERE "id"=4497
11:27:18.5202.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4146) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.4982.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4146) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.4691.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4146) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.5881.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6
11:27:18.5281.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4146) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.5821.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4146) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:27:18.5751.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (93, 1005, 'now()', NULL) RETURNING "id"
11:27:18.4911.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4497
11:27:18.4791.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4146
11:27:18.5191.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4146
11:27:18.4661.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4146
11:27:18.4821.0 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', 4497, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '221.216.117.119')
11:27:18.5991.0 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/project/save-edit', '{"Projects":{"id":"4146","client_name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","client_id":"93","project_status":"5","project_progress":"3","profit":"75000","profit_pct":"15","bargain_date":"2026-06-05","project_title":"\u98de\u5854\u96f6\u4fe1\u4efb\u65b0\u8d2d","from_contact_name":"","from_contact":"","salesForecast":"172","purchaseType":"164","opportunityFrom":"","contract_type":"1","comment":"","payment_collection_remind_ahead":"1 day","project_product_version_id":"","salesContractPaymentCollectionRemindReceivers":["1001","5087","1005"],"projectProductRels":"","projectContactPoints":"","projectContactPointRels":"","projectUsedClient":{"used_client":"","budget":"","profit":"","profit_pct":"","projectUsedClientPaymentCollectionRemindReceivers":"","projectUsedClientPaymentCollectionRemindDates":"","remind_ahead":"","projectUsedClientPayments":"","projectUsedClientInvoices":""},"salesContractPaymentCollectionRemindDates":"","projectProductTypes":{"5":{"budget":"500000","profit":"75000","pct":"15"}},"projectArchitects":"","projectRemindReceivers":""},"web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-05 11:27:18', 175626240) RETURNING "id"
11:27:18.4851.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 1), (1001, 5087, 1), (1001, 1005, 1)
11:27:18.5150.9 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', 4497, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.4250.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:27:18.5320.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE 0=1
11:27:18.5870.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id"=1719
11:27:18.4390.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4146)
11:27:18.5330.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE 0=1
11:27:18.5290.8 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', 4146, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.4760.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 164, 4146)
11:27:18.4680.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=93, "project_progress"=3, "budget"='500000', "profit_pct"='15', "updated_at"='now()', "status_updated_at"='now()', "contract_type"=1, "from_contact"=NULL, "change_status_to"=5 WHERE "id"=4146
11:27:18.5040.7 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"=4497) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
11:27:18.4510.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\Projects', 4146, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5090.7 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"=4497) AND ("t"."status"=1))
11:27:18.4440.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4146, 5, '安全设备', '500000', 15, '75000')
11:27:18.5120.7 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"=4497) AND ("t"."status" IN (1, 2, 5))
11:27:18.4950.7 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"=4497) AND ("t"."status" IN (2, 5, 1))
11:27:18.5240.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4146 ORDER BY "created_at" DESC
11:27:18.5080.7 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"=4497) AND ("t"."status"=1))
11:27:18.5110.7 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"=4497) AND ("t"."status" IN (1, 2, 5))
11:27:18.5030.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"=4497) AND ("t"."status" IN (2, 5))
11:27:18.4880.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4497, 1001) RETURNING "id"
11:27:18.4410.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4146
11:27:18.5790.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4146
11:27:18.4810.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='500000', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4497
11:27:18.4340.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4146
11:27:18.4420.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4146
11:27:18.5010.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4497) AND (amount > paid_amount) ORDER BY "remind_date"
11:27:18.4450.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4146 ORDER BY "id"
11:27:18.5220.5 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', 4146, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5810.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "is_verify"=TRUE WHERE "id"=4146
11:27:18.5030.5 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"=4497) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
11:27:18.4540.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4146 ORDER BY "id"
11:27:18.4270.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:27:18.5840.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_chargeback_verify"=TRUE WHERE "id"=4497
11:27:18.5780.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=4146)
11:27:18.4460.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4146 ORDER BY "id"
11:27:18.4810.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4146 ORDER BY "id")
11:27:18.4350.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 164, 172, 185, 191, 369, 350)) ORDER BY "sort"
11:27:18.5010.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.5160.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.5970.5 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 (15, 'status', 1719, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u9000\u5355\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}')
11:27:18.4940.5 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"=4497) AND ("t"."status" IN (2, 5, 1))
11:27:18.4710.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
11:27:18.4830.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.5930.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=7, "next_cancel_verify_user"=1001, "updated_at"='now()' WHERE "id"=1719
11:27:18.5800.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4497 ORDER BY "id" DESC
11:27:18.5900.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id"='1001') AND ("user_status"='1') ORDER BY array_position(array[1001], id)
11:27:18.5100.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"=4497) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
11:27:18.4520.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.4360.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='93') AND ("project_title"='飞塔零信任新购') AND ("id" != 4146))
11:27:18.4640.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.5020.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4497
11:27:18.4720.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:27:18.4410.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:27:18.5260.4 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"=4497) AND ("t"."status" IN (2, 5, 1))
11:27:18.4730.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=4146
11:27:18.4300.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4146'
11:27:18.4900.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4497, 1005) RETURNING "id"
11:27:18.4930.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4497
11:27:18.4740.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 164, 172, 185, 191, 369, 350)) ORDER BY "sort"
11:27:18.4890.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4497, 5087) RETURNING "id"
11:27:18.5230.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.5960.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:27:18.4960.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.4840.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.4710.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', 4146, 'a:1:{s:16:"change_status_to";s:1:"5";}', '', 1001, '221.216.117.119')
11:27:18.4780.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 172, 4146)
11:27:18.4960.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4497
11:27:18.5170.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.5250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4497
11:27:18.5840.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.4390.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005)
11:27:18.5340.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93'
11:27:18.5310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4497) AND (amount > paid_amount) ORDER BY "remind_date"
11:27:18.4370.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='93')
11:27:18.5170.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.4860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4497
11:27:18.4880.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', 10168, 'a:3:{s:2:"id";i:10168;s:11:"contract_id";i:4497;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119')
11:27:18.4870.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4497
11:27:18.4530.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.5350.3 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("client_id"=93)
11:27:18.5000.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', 4146, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.4650.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.4630.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', 4146, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.4890.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', 10169, 'a:3:{s:2:"id";i:10169;s:11:"contract_id";i:4497;s:7:"user_id";s:4:"5087";}', '', 1001, '221.216.117.119')
11:27:18.4450.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.4940.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4497
11:27:18.5300.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.5960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:27:18.4380.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005)
11:27:18.5860.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1719) AND ("status"=0)
11:27:18.5850.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:27:18.4770.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=172
11:27:18.5260.3 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"=4497) AND ("t"."status" IN (2, 5, 1))
11:27:18.5940.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
11:27:18.4730.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4146
11:27:18.5320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE 0=1
11:27:18.4750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='164'
11:27:18.4740.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=164
11:27:18.4430.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
11:27:18.4850.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
11:27:18.4370.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
11:27:18.4910.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', 10170, 'a:3:{s:2:"id";i:10170;s:11:"contract_id";i:4497;s:7:"user_id";s:4:"1005";}', '', 1001, '221.216.117.119')
11:27:18.4790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=4146
11:27:18.5780.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.4920.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4497
11:27:18.4770.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='172'
11:27:18.4250.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:27:18.4380.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='5')
11:27:18.4750.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4146) AND ("term_id"=9)
11:27:18.5270.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4497
11:27:18.5320.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE 0=1
11:27:18.5270.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.5770.2 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', 199926, 'a:5:{s:2:"id";i:199926;s:9:"client_id";i:93;s:9:"sales_rep";i:1005;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
11:27:18.5860.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4146
11:27:18.4650.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4146
11:27:18.4380.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='3')
11:27:18.5250.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4497
11:27:18.5930.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("erp_sales_order_id"=1719) AND ("status"=0) ORDER BY "id"
11:27:18.4780.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=4146) AND ("term_id"=13)
11:27:18.5850.2 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', 4497, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5790.2 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', 1719, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5830.2 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', 4146, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5880.2 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', 1719, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5770.2 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', 93, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5950.2 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', 1719, 'a:0:{}', '', 1001, '221.216.117.119')
11:27:18.5940.2 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', 1719, 'a:2:{s:6:"status";i:7;s:23:"next_cancel_verify_user";i:1001;}', '', 1001, '221.216.117.119')
11:27:18.5950.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1719) ORDER BY "id"
11:27:18.5310.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=4146
11:27:18.5950.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1719) ORDER BY "id"