ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685ba0f872bef: POST https://beta.jinchangxiao.com/v2/reimbursement/save-new at 2025-06-25 03:10:48 pm by 223.104.41.148

Performance Profiling

Total processing time: 61 ms; Peak memory: 3.833 MB. Show Profiling Timeline

总计50条数据
TimeDurationCategoryInfo
  
15:10:48.5128.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:10:48.4813.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_reimbursements" ("amount", "client_id", "description", "implement_record_id", "occurrence_at", "pre_sales_id", "project_id", "work_log_id", "created_by", "status") VALUES ('110', 2815, '', NULL, '2025-06-25 15:00', NULL, NULL, NULL, 1000, 1) RETURNING "id"
15:10:48.4732.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u'
15:10:48.4711.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:10:48.4851.6 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\Reimbursements', 7439, 'a:18:{s:2:"id";i:7439;s:6:"status";i:1;s:6:"amount";s:3:"110";s:13:"occurrence_at";s:19:"2025-06-25 15:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";s:0:"";s:10:"created_by";i:1000;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";s:4:"2815";s:10:"project_id";s:0:"";s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";s:0:"";s:12:"pre_sales_id";s:0:"";s:19:"implement_record_id";s:0:"";}', '', 1000, '223.104.41.148')
15:10:48.4871.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=7439)
15:10:48.5211.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id"
15:10:48.5011.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=7439) ORDER BY "id"
15:10:48.4951.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=7439
15:10:48.4761.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:10:48.5061.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=7439) ORDER BY "id"
15:10:48.5281.0 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', 1000, 2, 1141, 'v2/reimbursement/save-new', '{"Reimbursements":{"amount":"110","attachmentFiles":["24776"],"client_id":"2815","description":"","form_costType":"369","form_reimbursementCarbonCopyRels":["5252"],"form_reimbursementSettleRels":["1000"],"form_reimbursementVerifyRels":["1000"],"form_type":"185","implement_record_id":"","occurrence_at":"2025-06-25 15:00","pre_sales_id":"","project_id":"","work_log_id":""},"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","posttime":"1750835456","token":"4bbc64a435112eb22860c2591b8d0ac6","version_code":"1141"}', '{"code":200,"data":{"id":7439},"status":1,"msg":[{"name":"success","success":"\u65b0\u62a5\u9500\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-06-25 15:10:48') RETURNING "id"
15:10:48.5111.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815
15:10:48.5261.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 2815, 10, 7439, 20, 1000, '[7439]', '[7439]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":["\u62db\u5f85\u8d39"]}') RETURNING "id"
15:10:48.5081.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 7439, 20, 1000, '2025-06-25 15:10:48', '{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}', '{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}', '{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":[]}') RETURNING "id"
15:10:48.4881.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 7439, 24776)
15:10:48.4910.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 185, 7439) RETURNING "id"
15:10:48.4970.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (7439, 1000, 0)
15:10:48.5230.9 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', 164992, 'a:5:{s:2:"id";i:164992;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.41.148')
15:10:48.4980.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (7439, 5252)
15:10:48.5030.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_reimbursements" SET "next_verify_user"=1000 WHERE "id"=7439
15:10:48.5000.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (7439, 1000)
15:10:48.5090.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 509562, 'a:13:{s:2:"id";i:509562;s:9:"object_id";i:7439;s:11:"object_type";i:20;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:405:"{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}";s:9:"new_value";s:405:"{"id":7439,"status":1,"amount":"110","occurrence_at":"2025-06-25 15:00:00","settle_accounts_at":null,"settle_accounts_by":null,"description":"","created_by":1000,"created_at":"2025-06-25 15:10:48","updated_at":"2025-06-25 15:10:48","refuse_description":null,"client_id":2815,"project_id":null,"next_verify_user":1000,"is_resubmited":false,"work_log_id":null,"pre_sales_id":null,"implement_record_id":null}";s:11:"description";s:93:"{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":[]}";s:10:"created_by";i:1000;s:10:"created_at";s:19:"2025-06-25 15:10:48";s:9:"is_delete";N;}', '', 1000, '223.104.41.148')
15:10:48.4920.8 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\TermTaxonomyRelationships', 118037, 'a:7:{s:2:"id";i:118037;s:9:"object_id";i:7439;s:11:"taxonomy_id";s:3:"185";s:7:"term_id";i:15;s:5:"value";N;s:11:"object_type";N;s:9:"extra_int";N;}', '', 1000, '223.104.41.148')
15:10:48.4930.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (18, 369, 7439) RETURNING "id"
15:10:48.4940.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\TermTaxonomyRelationships', 118038, 'a:7:{s:2:"id";i:118038;s:9:"object_id";i:7439;s:11:"taxonomy_id";s:3:"369";s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";N;s:9:"extra_int";N;}', '', 1000, '223.104.41.148')
15:10:48.5040.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\Reimbursements', 7439, 'a:1:{s:13:"occurrence_at";s:19:"2025-06-25 15:00:00";}', '', 1000, '223.104.41.148')
15:10:48.5270.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\ObjectChangeLogs', 509563, 'a:13:{s:2:"id";i:509563;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:7439;s:18:"target_object_type";i:20;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[7439]";s:9:"new_value";s:6:"[7439]";s:11:"description";s:113:"{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u8d39\u7528\u62a5\u9500","d4":["\u62db\u5f85\u8d39"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.41.148')
15:10:48.5240.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', 2815, 'a:0:{}', '', 1000, '223.104.41.148')
15:10:48.5100.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815
15:10:48.4990.5 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=7439
15:10:48.4800.5 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')
15:10:48.5050.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:10:48.4900.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='185')
15:10:48.5070.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:10:48.5260.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:10:48.4800.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
15:10:48.4890.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7439) AND ("term_id"=15)
15:10:48.5250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (185, 369))
15:10:48.4980.3 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=7439
15:10:48.4810.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
15:10:48.5250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=7439
15:10:48.5030.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')
15:10:48.4810.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')
15:10:48.4900.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15)
15:10:48.5020.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
15:10:48.5050.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=7439
15:10:48.4930.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='369')
15:10:48.4930.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18)
15:10:48.4930.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=7439) AND ("term_id"=18)