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

Performance Profiling

Total processing time: 1,138 ms; Peak memory: 6.900 MB. Show Profiling Timeline

总计153条数据
TimeDurationCategoryInfo
  
11:20:30.038923.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2130) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.88013.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2130') AND ("project_title"='中国人民解放军总参谋部第五十一研究所试制工厂-高性能') AND ("id" != 3957))
11:20:29.9248.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "project_id"=3957
11:20:29.9536.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 128, 3957)
11:20:30.9854.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6
11:20:29.9174.6 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', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.0044.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.9994.0 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', 1717, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u9000\u5355\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}')
11:20:29.9473.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3957, 1015, '1', 1001)
11:20:30.9913.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" ("erp_sales_order_id", "user_id", "status") VALUES (1717, 1001, 0)
11:20:29.9013.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3957, 2, '服务器', '20000000', 20, '4000000')
11:20:29.9763.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4496, 1001) RETURNING "id"
11:20:29.9613.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3957, 1001) RETURNING "id"
11:20:30.0162.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=3957 ORDER BY "created_at" DESC
11:20:29.9722.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 1), (1001, 5087, 1)
11:20:29.9402.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2130, "project_progress"=2, "budget"='20000000', "profit_pct"='20', "updated_at"='now()', "status_updated_at"='now()', "contract_type"=1, "from_contact"=NULL, "change_status_to"=4 WHERE "id"=3957
11:20:30.0002.6 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', 4496, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.9952.4 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"=4496) AND ("t"."status" IN (1, 2, 5))
11:20:29.9652.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3957
11:20:30.0242.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:30.0122.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.9142.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:30.9621.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2130, 5087, 'now()', NULL) RETURNING "id"
11:20:29.9681.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='20000000', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4496
11:20:29.9381.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3957
11:20:30.9831.4 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id"=1717
11:20:30.9811.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1717) AND ("status"=0)
11:20:29.9341.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:30.9761.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.9851.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.9431.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3957) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
11:20:29.9981.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='20000000', "erp_all_settle_amount"='0' WHERE "id"=4496
11:20:30.0290.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE 0=1
11:20:30.0310.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE 0=1
11:20:30.0110.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3957
11:20:30.0340.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE 0=1
11:20:29.8960.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3957)
11:20:31.0040.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/project/save-edit', '{"Projects":{"id":"3957","client_name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","client_id":"2130","project_status":"4","project_progress":"2","profit":"4000000","profit_pct":"20","bargain_date":"2026-06-05","project_title":"\u4e2d\u56fd\u4eba\u6c11\u89e3\u653e\u519b\u603b\u53c2\u8c0b\u90e8\u7b2c\u4e94\u5341\u4e00\u7814\u7a76\u6240\u8bd5\u5236\u5de5\u5382-\u9ad8\u6027\u80fd","from_contact_name":"","from_contact":"","salesForecast":"142","purchaseType":"128","opportunityFrom":"","contract_type":"1","projectArchitects":{"1015":"1"},"comment":"\u9884\u7b972000\u4e07","projectRemindReceivers":["1001"],"payment_collection_remind_ahead":"1 day","project_product_version_id":"","salesContractPaymentCollectionRemindReceivers":["1001","5087"],"projectProductRels":"","projectContactPoints":"","projectContactPointRels":"","projectUsedClient":{"used_client":"","budget":"","profit":"","profit_pct":"","projectUsedClientPaymentCollectionRemindReceivers":"","projectUsedClientPaymentCollectionRemindDates":"","remind_ahead":"","projectUsedClientPayments":"","projectUsedClientInvoices":""},"salesContractPaymentCollectionRemindDates":"","projectProductTypes":{"2":{"budget":"20000000","profit":"4000000","pct":"20"}}},"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:20:31', 1134237952) RETURNING "id"
11:20:29.9900.8 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"=4496) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE)
11:20:29.8740.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3957'
11:20:29.9830.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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:29.9670.7 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id")
11:20:29.9940.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"=4496) AND ("t"."status" IN (1, 2, 5))
11:20:29.9920.7 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"=4496) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5))
11:20:30.9900.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id"='1001') AND ("user_status"='1') ORDER BY array_position(array[1001], id)
11:20:29.9220.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.0210.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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:29.9820.6 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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:29.8790.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 128, 142, 184, 189, 349)) ORDER BY "sort"
11:20:29.8710.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:20:29.9050.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id"
11:20:30.9730.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3957
11:20:29.8990.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3957
11:20:30.0270.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4496) AND (amount > paid_amount) ORDER BY "remind_date"
11:20:30.9720.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3957)
11:20:29.9870.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4496) AND (amount > paid_amount) ORDER BY "remind_date"
11:20:30.9780.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_chargeback_verify"=TRUE WHERE "id"=4496
11:20:29.8940.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130')
11:20:30.9750.5 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "is_verify"=TRUE WHERE "id"=3957
11:20:29.8980.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:30.0360.5 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"=2130)
11:20:30.9740.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4496 ORDER BY "id" DESC
11:20:30.0350.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130'
11:20:30.0150.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.9890.4 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"=4496) AND ("t"."status" IN (2, 5))
11:20:30.0260.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.0280.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=3957
11:20:30.9960.4 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "status"=7, "next_cancel_verify_user"=1001, "updated_at"='now()' WHERE "id"=1717
11:20:29.9920.4 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"=4496) AND ("t"."status"=1))
11:20:29.9910.4 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"=4496) AND ("t"."status"=1))
11:20:30.0330.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE 0=1
11:20:30.0190.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4496
11:20:29.9890.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"=4496) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5))
11:20:30.0210.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"=4496) AND ("t"."status" IN (2, 5, 1))
11:20:29.9000.4 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3957
11:20:29.9810.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:29.8730.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:29.9460.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3957
11:20:29.9750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4496
11:20:29.9000.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=2
11:20:29.9060.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id"
11:20:30.0090.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.9700.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.9910.3 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"=4496) AND ("t"."status"=1))
11:20:30.0220.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:30.0200.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"=4496
11:20:30.0220.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.9870.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.9780.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:30.0100.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.9230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3957 ORDER BY "id"
11:20:29.9360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.9450.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2130'
11:20:30.9720.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.9790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2130
11:20:29.9880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4496
11:20:30.9980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:29.8940.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
11:20:29.9710.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
11:20:29.9460.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:30.9960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
11:20:29.9810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4496
11:20:29.8790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3957
11:20:29.9370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3957
11:20:30.9980.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:20:29.9800.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4496, 5087) RETURNING "id"
11:20:29.8950.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='2')
11:20:29.9350.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', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.9510.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (1, 128, 142, 184, 189, 349)) ORDER BY "sort"
11:20:29.9600.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 142, 3957)
11:20:29.9450.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', 3957, 'a:1:{s:16:"change_status_to";s:1:"4";}', '', 1001, '221.216.117.119')
11:20:29.9230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.0140.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', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.0260.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', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.8950.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='4')
11:20:29.9840.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:29.8950.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087)
11:20:29.9710.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.9640.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\ProjectRemindReceivers', 2194, 'a:3:{s:2:"id";i:2194;s:10:"project_id";i:3957;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119')
11:20:29.9060.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.9700.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', 4496, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '221.216.117.119')
11:20:29.9800.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\SalesContractPaymentCollectionRemindReceivers', 10163, 'a:3:{s:2:"id";i:10163;s:11:"contract_id";i:4496;s:7:"user_id";s:4:"1001";}', '', 1001, '221.216.117.119')
11:20:29.9840.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:30.9800.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.9360.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3957
11:20:29.9470.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3957
11:20:29.9750.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4496
11:20:29.9820.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"=4496
11:20:30.9950.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("erp_sales_order_id"=1717) AND ("status"=0) ORDER BY "id"
11:20:29.9510.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3957
11:20:29.8960.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087)
11:20:29.8710.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:20:29.9600.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3957
11:20:30.9640.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', 199918, 'a:5:{s:2:"id";i:199918;s:9:"client_id";i:2130;s:9:"sales_rep";i:5087;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
11:20:30.9730.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', 1717, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.9590.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=142
11:20:29.9600.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3957
11:20:30.9970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1717) ORDER BY "id"
11:20:30.9770.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', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.9790.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', 4496, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.9640.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', 2130, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.9810.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4496
11:20:29.9520.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='128'
11:20:29.9870.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', 3957, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.9520.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=128
11:20:30.9840.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', 1717, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:29.9520.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3957) AND ("term_id"=9)
11:20:29.9590.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='142'
11:20:30.9980.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', 1717, 'a:0:{}', '', 1001, '221.216.117.119')
11:20:30.9960.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', 1717, 'a:2:{s:6:"status";i:7;s:23:"next_cancel_verify_user";i:1001;}', '', 1001, '221.216.117.119')
11:20:29.9800.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\SalesContractPaymentCollectionRemindReceivers', 10164, 'a:3:{s:2:"id";i:10164;s:11:"contract_id";i:4496;s:7:"user_id";s:4:"5087";}', '', 1001, '221.216.117.119')
11:20:30.9970.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1717) ORDER BY "id"
11:20:29.9590.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3957) AND ("term_id"=13)