ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68999642c2688: POST https://beta.jinchangxiao.com/v2/project/save-edit at 2025-08-11 03:05:38 pm by 39.107.117.60

Performance Profiling

Total processing time: 102 ms; Peak memory: 6.178 MB. Show Profiling Timeline

总计87条数据
TimeDurationCategoryInfo
  
15:05:38.87316.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:05:38.8386.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=3935
15:05:38.7992.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='lFICiryH6q1PKzl6ykU2iPsev0bYyy6d'
15:05:38.7981.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:05:38.8211.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:05:38.8031.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:05:38.8551.3 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"=4082) AND ("t"."status" IN (2, 5, 1))
15:05:38.8581.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:05:38.8691.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:05:38.8901.2 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id"
15:05:38.8271.2 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_architects" ("project_id", "engineer_id", "contribution", "created_by") VALUES (3935, 1017, '0.6', 1001), (3935, 5085, '0.4', 1001)
15:05:38.8171.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (3935, 4, '网络设备 ', '35558', 11, '3911.38')
15:05:38.8951.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, NULL, NULL, 'v2/project/save-edit', '{"Projects":{"payment_collection_remind_ahead":"","bargain_date":"2025-08-11","client_id":"982","comment":"\u4eac\u6d25\u5180","contract_type":"1","from_contact":"4640","id":"3935","projectArchitects":{"1017":"0.6","5085":"0.4"},"projectProductTypes":{"4":{"budget":"35558","pct":"11"}},"projectRemindReceivers":["1001"],"project_progress":"9","project_status":"3","project_title":"\u5feb\u5feb\u5feb","purchaseType":"165","salesContractPaymentCollectionRemindDates":{"2025-08-11":"35558"},"salesForecast":"181","used_client":""},"access_token":"lFICiryH6q1PKzl6ykU2iPsev0bYyy6d","device_type":"2","posttime":"1754895938","version_code":"1148","token":"4b6ce100049e4e9584d900596e4e8f2b"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5546\u673a\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-08-11 15:05:38') RETURNING "id"
15:05:38.8201.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "client_id"=982, "project_status"=3, "project_progress"=9, "budget"='35558', "profit_pct"='11', "updated_at"='now()', "contract_type"=1, "used_client"=NULL, "from_contact"=4640 WHERE "id"=3935
15:05:38.8311.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (9, 165, 3935)
15:05:38.8231.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\Projects', 3935, 'a:0:{}', '', 1001, '39.107.117.60')
15:05:38.8451.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "amount"='35558', "contract_type"=1, "save_collection_at"='now()' WHERE "id"=4082
15:05:38.8361.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_project_remind_receivers" ("project_id", "user_id") VALUES (3935, 1001) RETURNING "id"
15:05:38.8150.9 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3935
15:05:38.8510.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" ("contract_id", "remind_date", "amount", "pct", "reminded") VALUES (4082, '2025-08-11', '35558', 1, FALSE) RETURNING "id"
15:05:38.8350.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3935
15:05:38.8680.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=3935
15:05:38.8650.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\SalesContracts', 4082, 'a:0:{}', '', 1001, '39.107.117.60')
15:05:38.8640.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='35558' WHERE "id"=4082
15:05:38.8060.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3935'
15:05:38.8460.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\SalesContracts', 4082, 'a:1:{s:18:"save_collection_at";s:5:"now()";}', '', 1001, '39.107.117.60')
15:05:38.8620.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"=4082) AND ("t"."status" IN (2, 5, 1))
15:05:38.8270.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3935
15:05:38.8590.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', 3935, 'a:0:{}', '', 1001, '39.107.117.60')
15:05:38.8910.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', 177452, 'a:5:{s:2:"id";i:177452;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '39.107.117.60')
15:05:38.8370.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', 1701, 'a:3:{s:2:"id";i:1701;s:10:"project_id";i:3935;s:7:"user_id";s:4:"1001";}', '', 1001, '39.107.117.60')
15:05:38.8340.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (13, 181, 3935)
15:05:38.8530.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4082
15:05:38.8520.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\SalesContractPaymentCollectionRemindDates', 2551, 'a:9:{s:2:"id";i:2551;s:11:"contract_id";i:4082;s:11:"remind_date";s:10:"2025-08-11";s:8:"reminded";b:0;s:6:"amount";i:35558;s:11:"paid_amount";N;s:12:"overdue_days";N;s:6:"status";N;s:3:"pct";d:1;}', '', 1001, '39.107.117.60')
15:05:38.8490.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082
15:05:38.8700.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', 3935, 'a:0:{}', '', 1001, '39.107.117.60')
15:05:38.8920.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', 982, 'a:0:{}', '', 1001, '39.107.117.60')
15:05:38.8300.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3935) AND ("term_id"=9)
15:05:38.8330.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=3935) AND ("term_id"=13)
15:05:38.8090.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (2, 165, 181, 184, 189, 349)) ORDER BY "sort"
15:05:38.8240.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982'
15:05:38.8540.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"=4082) AND ("t"."status" IN (2, 5, 1))
15:05:38.8940.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id"=3935)
15:05:38.8120.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982')
15:05:38.8140.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=3935
15:05:38.8940.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935
15:05:38.8080.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3935
15:05:38.8450.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3935)
15:05:38.8610.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"=4082) AND ("t"."status" IN (2, 5, 1))
15:05:38.8640.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"=4082) AND ("t"."status"=1))
15:05:38.8630.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"=4082) AND ("t"."status"=1))
15:05:38.8110.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE ("client_id"='982') AND ("project_title"='快快快') AND ("id" != 3935))
15:05:38.8490.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082
15:05:38.8600.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
15:05:38.8260.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=3935
15:05:38.8720.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"=982)
15:05:38.8160.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=4
15:05:38.8140.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='4640')
15:05:38.8180.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:05:38.8470.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
15:05:38.8110.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1')
15:05:38.8180.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:05:38.8560.3 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4082
15:05:38.8250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:05:38.8610.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"=4082) AND ("t"."status" IN (2, 5, 1))
15:05:38.8710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
15:05:38.8660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
15:05:38.8350.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id"=3935
15:05:38.8710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982'
15:05:38.8290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (2, 165, 181, 184, 189, 349)) ORDER BY "sort"
15:05:38.8600.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082
15:05:38.8630.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"=4082) AND ("t"."status"=1))
15:05:38.8480.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_contract_default_remind_users" WHERE ("user_id"=1001) AND ("type"=1)
15:05:38.8670.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935
15:05:38.8130.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='3')
15:05:38.8120.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"='9')
15:05:38.8500.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082)
15:05:38.8520.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4082
15:05:38.8130.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
15:05:38.8300.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=165
15:05:38.8480.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935
15:05:38.8660.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935
15:05:38.8560.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935
15:05:38.8290.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=3935
15:05:38.8320.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=181
15:05:38.8300.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='165'
15:05:38.8330.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='181'