ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689af91cbeef0: POST https://beta.jinchangxiao.com/vue/project/save-edit at 2025-08-12 04:19:40 pm by 114.254.2.139

Performance Profiling

Total processing time: 142 ms; Peak memory: 6.953 MB. Show Profiling Timeline

总计178条数据
TimeDurationCategoryInfo
  
16:19:40.89715.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2553) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
16:19:40.7852.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:19:40.7832.0 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:19:40.7891.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:19:40.8391.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3751) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
16:19:40.8031.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3751, 5, '安全设备', '885300', 2.74, '24257.22')
16:19:40.8471.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 182, 3751)
16:19:40.8721.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3751) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
16:19:40.8841.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3751) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
16:19:40.9131.2 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2553, 1001, 'now()', NULL) RETURNING "id"
16:19:40.8591.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_contract_default_remind_users" ("user_id", "remind_user", "type") VALUES (1001, 1001, 1), (1001, 5388, 1), (1001, 1011, 1)
16:19:40.9201.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/save-edit', '{"Projects":{"id":"3751","payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001","5388","1011"],"salesContractPaymentCollectionRemindDates":"","client_name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","client_id":"2553","project_status":"3","project_progress":"9","profit":"24257.22","profit_pct":"2.74","bargain_date":"2025-07-21","project_title":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","from_contact_name":"\u674e\u777f\uff08Rick Li\uff09 (\u4f9b\u5e94\u5546: \u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8)","from_contact":"5957","salesForecast":"172","purchaseType":"182","opportunityFrom":"","contract_type":"1","comment":"\u62db\u6807\u7f16\u53f7\uff1aPOWRCHINA-0120009-250118","projectRemindReceivers":["1001"],"project_product_version_id":"951","projectProductRels":{"10493":{"product_id":"2056","amount":"5365.33","total_amount":"32192.00","number":"6","cost":"800.00","total_cost":"4800","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":"90"},"10494":{"product_id":"2059","amount":"44217.00","total_amount":"442170","number":"10","cost":"6900.00","total_cost":"69000","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":"90"},"10495":{"product_id":"2057","amount":"3312.00","total_amount":"33120","number":"10","cost":"800.00","total_cost":"8000","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":"90"},"10491":{"product_id":"2055","amount":"22137.00","total_amount":"221370","number":"10","cost":"13200.00","total_cost":"132000","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":"90"},"10492":{"product_id":"2058","amount":"15644.80","total_amount":"156448","number":"10","cost":"16764.60","total_cost":"167646","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":"90"},"10496":{"product_id":"2056","amount":"0","total_amount":"0","number":"4","cost":"800.00","total_cost":"3200","description":"\u8c03\u6574\u6295\u6807\u4ef7\u683c\uff0c4\u4e2a\u7535\u6e90\u7b97\u8d60\u9001","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":"90"}},"projectContactPoints":[{"point":"342291.00","contact_id":"5957"}],"projectContactPointRels":"","projectUsedClient":{"used_client":"","budget":"","profit":"","profit_pct":"","projectUsedClientPaymentCollectionRemindReceivers":"","projectUsedClientPaymentCollectionRemindDates":"","remind_ahead":"","projectUsedClientPayments":"","projectUsedClientInvoices":""},"projectProductTypes":{"5":{"budget":"885300","profit":"24257.22","pct":"2.74"}},"projectArchitects":""},"web_access_token":"Hc6bcOPECvJmn-MxoPjAzgccBe0xyT-M"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-12 16:19:40') RETURNING "id"
16:19:40.8381.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=2553, "project_status"=3, "project_progress"=9, "budget"='885300', "profit_pct"='2.74', "updated_at"='now()', "contract_type"=1, "from_contact"=5957, "total_contact_point"='342291', "project_product_version_id"=951 WHERE "id"=3751
16:19:40.8191.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\ProjectProductRels', 10493, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8521.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3751, 1001) RETURNING "id"
16:19:40.8621.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4055, 1001) RETURNING "id"
16:19:40.8251.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2055, "number"=10, "supplier_id"=90, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=10491
16:19:40.8341.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_contact_points" ("project_id", "contact_id", "point") VALUES (3751, 5957, '342291.00')
16:19:40.8020.9 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3751
16:19:40.8550.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='885300', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4055
16:19:40.7950.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (2, 182, 172, 184, 189, 377, 349)) ORDER BY "sort"
16:19:40.8410.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\Projects', 3751, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8540.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3751
16:19:40.8580.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
16:19:40.9180.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3751)
16:19:40.7920.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3751'
16:19:40.8660.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4055, 1011) RETURNING "id"
16:19:40.8830.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3751
16:19:40.8260.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\ProjectProductRels', 10491, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8180.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2056, "number"=6, "supplier_id"=90, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=10493
16:19:40.8790.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='885300' WHERE "id"=4055
16:19:40.8640.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4055, 5388) RETURNING "id"
16:19:40.8280.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', 10492, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.7970.7 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='2553') AND ("project_title"='10台 PA445 设备采购项目（沙特项目）') AND ("id" != 3751))
16:19:40.9190.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\ErpSalesOrders', 1553, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8500.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 172, 3751)
16:19:40.8220.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', 10494, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8870.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_clients" SET "used_client"=NULL, "budget"=NULL, "profit"=NULL, "profit_pct"=NULL WHERE "id"=153
16:19:40.8210.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2059, "number"=10, "supplier_id"=90, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=10494
16:19:40.8300.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', 10496, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8610.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4055
16:19:40.8740.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', 3751, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8880.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\ProjectUsedClients', 153, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8700.7 msyii\db\Command::querySELECT r.amount, t.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"=4055) AND ("t"."status" IN (2, 5, 1))
16:19:40.8240.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', 10495, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8770.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"=4055) AND ("t"."status" IN (2, 5, 1))
16:19:40.8530.7 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', 1711, 'a:3:{s:2:"id";i:1711;s:10:"project_id";i:3751;s:7:"user_id";s:4:"1001";}', '', 1001, '114.254.2.139')
16:19:40.9140.7 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', 177905, 'a:5:{s:2:"id";i:177905;s:9:"client_id";i:2553;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.254.2.139')
16:19:40.8930.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\ProjectUsedClients', 153, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8800.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\SalesContracts', 4055, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8630.7 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', 8863, 'a:3:{s:2:"id";i:8863;s:11:"contract_id";i:4055;s:7:"user_id";s:4:"1001";}', '', 1001, '114.254.2.139')
16:19:40.8270.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2058, "number"=10, "supplier_id"=90, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=10492
16:19:40.8230.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2057, "number"=10, "supplier_id"=90, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=10495
16:19:40.8460.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3751) AND ("term_id"=9)
16:19:40.8490.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3751) AND ("term_id"=13)
16:19:40.8560.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\SalesContracts', 4055, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '114.254.2.139')
16:19:40.8330.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3751
16:19:40.8850.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', 3751, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.9150.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\Clients', 2553, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8890.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\ProjectUsedClients', 153, 'a:0:{}', '', 1001, '114.254.2.139')
16:19:40.8290.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2056, "number"=4, "supplier_id"=90, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=10496
16:19:40.8650.7 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', 8864, 'a:3:{s:2:"id";i:8864;s:11:"contract_id";i:4055;s:7:"user_id";s:4:"5388";}', '', 1001, '114.254.2.139')
16:19:40.8510.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3751
16:19:40.8660.7 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', 8865, 'a:3:{s:2:"id";i:8865;s:11:"contract_id";i:4055;s:7:"user_id";s:4:"1011";}', '', 1001, '114.254.2.139')
16:19:40.8420.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2553'
16:19:40.8690.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"=4055) AND ("t"."status" IN (2, 5, 1))
16:19:40.7990.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2553')
16:19:40.8070.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
16:19:40.8050.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3751
16:19:40.8320.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"=5957
16:19:40.8010.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3751
16:19:40.8940.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE ("project_used_client_id"=153) AND (amount > paid_amount) ORDER BY "collected_date", "created_at"
16:19:40.7950.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3751
16:19:40.8060.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2056
16:19:40.8760.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"=4055) AND ("t"."status" IN (2, 5, 1))
16:19:40.8780.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"=4055) AND ("t"."status"=1))
16:19:40.8440.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3751
16:19:40.8780.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"=4055) AND ("t"."status"=1))
16:19:40.8000.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='5957')
16:19:40.8670.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4055
16:19:40.8350.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3751
16:19:40.8860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id"=3751
16:19:40.8030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5
16:19:40.8360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:19:40.8750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553
16:19:40.8960.3 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("bargain_date" >= '2025-01-01 00:00:00') AND ("bargain_date" <= '2025-12-31 23:59:59') AND ("client_id"=2553)
16:19:40.8810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553
16:19:40.8360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:19:40.8600.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4055
16:19:40.8430.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:19:40.8570.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553
16:19:40.8950.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2553'
16:19:40.7980.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
16:19:40.8310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=3751
16:19:40.8860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553
16:19:40.8710.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4055
16:19:40.8450.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (2, 182, 172, 184, 189, 377, 349)) ORDER BY "sort"
16:19:40.8770.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"=4055) AND ("t"."status"=1))
16:19:40.8750.3 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"=4055) AND ("t"."status" IN (2, 5, 1))
16:19:40.9170.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3751
16:19:40.8500.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3751
16:19:40.8070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8900.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=153
16:19:40.7990.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='9')
16:19:40.8680.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4055
16:19:40.8910.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=153
16:19:40.8750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4055
16:19:40.8580.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3751
16:19:40.8170.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3751
16:19:40.8940.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=153
16:19:40.8810.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3751
16:19:40.8900.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=153
16:19:40.8000.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3')
16:19:40.8710.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3751
16:19:40.8550.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3751)
16:19:40.8000.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:19:40.8330.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='5957'
16:19:40.8080.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2059
16:19:40.8810.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3751
16:19:40.8480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=172
16:19:40.8200.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10494
16:19:40.8450.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3751
16:19:40.8120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
16:19:40.8270.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10492
16:19:40.8440.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3751
16:19:40.8690.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"=4055
16:19:40.8170.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='90'
16:19:40.8230.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10495
16:19:40.8140.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='90'
16:19:40.8140.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2057'
16:19:40.8090.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
16:19:40.8100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
16:19:40.8100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2055
16:19:40.8090.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2057
16:19:40.8110.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
16:19:40.8450.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=182
16:19:40.8680.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4055
16:19:40.8130.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='90'
16:19:40.8250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10491
16:19:40.8150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='90'
16:19:40.8160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='90'
16:19:40.8160.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2058'
16:19:40.8100.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
16:19:40.8150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='90'
16:19:40.8180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10493
16:19:40.8150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2055'
16:19:40.8110.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2058
16:19:40.8290.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=10496
16:19:40.8480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='172'
16:19:40.8460.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='182'
16:19:40.8130.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2059'
16:19:40.8920.2 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=153
16:19:40.8170.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2056'
16:19:40.8120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2056
16:19:40.8120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2056'
16:19:40.8120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8170.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8920.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payments" SET "paid_amount"='0' WHERE "project_used_client_id"=153
16:19:40.8150.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1
16:19:40.8100.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=1
16:19:40.8910.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=153
16:19:40.8080.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8910.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "id"=153
16:19:40.8350.1 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=3751
16:19:40.8090.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8920.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "project_used_client_id"=153
16:19:40.8110.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8140.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8160.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8140.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8130.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
16:19:40.8950.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=153
16:19:40.8900.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=153
16:19:40.8310.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1
16:19:40.8900.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=153
16:19:40.8910.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE 0=1
16:19:40.8950.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE 0=1
16:19:40.8350.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1