68c11d67743eb: POST https://beta.jinchangxiao.com/v2/comment/save-new at 2025-09-10 02:40:39 pm by 114.246.239.150
Database Queries
总计17条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:40:39.479 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om' |
| 14:40:39.483 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 14:40:39.486 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 14:40:39.486 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 14:40:39.486 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_id", "description", "object_type", "description2", "is_system") VALUES (1000, 38038, '', '19', '', FALSE) RETURNING "id" |
| 14:40:39.488 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 191145, 'a:11:{s:2:"id";i:191145;s:9:"object_id";s:5:"38038";s:11:"object_type";s:2:"19";s:6:"parent";N;s:11:"description";s:0:"";s:10:"created_by";i:1000;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:0;s:8:"for_user";N;s:12:"description2";s:0:"";}', '', 1000, '114.246.239.150') |
| 14:40:39.489 | 2.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id"=191145) |
| 14:40:39.494 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (310, 191145, 28086) |
| 14:40:39.495 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"='38038' |
| 14:40:39.497 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=38038 ORDER BY "id" |
| 14:40:39.498 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\WorkLogs', 38038, 'a:2:{s:6:"end_at";s:19:"2025-09-10 14:14:16";s:8:"start_at";s:19:"2025-09-10 14:14:04";}', '', 1000, '114.246.239.150') |
| 14:40:39.499 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661 |
| 14:40:39.501 | 1.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_comments" SET "for_user"=1000 WHERE "id"=191145 |
| 14:40:39.502 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Comments', 191145, 'a:0:{}', '', 1000, '114.246.239.150') |
| 14:40:39.504 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=38038 |
| 14:40:39.505 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=38038 ORDER BY "id" |
| 14:40:39.509 | 1.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 266, 'v2/comment/save-new', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","Comments":{"attachmentFiles":["28086"],"object_id":"38038","description":"","object_type":"19"},"device_type":"0","version_code":"266","token":"ddfb317c11a93266c83ebc4818905b63","posttime":"1757486439"}', '{"code":200,"data":{"id":191145},"status":1,"msg":[{"name":"success","success":"\u65b0\u7559\u8a00\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-09-10 14:40:39') RETURNING "id" |