Database Queries

总计16条数据
TimeDurationTypeQuery
  
22:43:53.2862.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'

22:43:53.2891.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

22:43:53.2920.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_comments" WHERE "id"='191300')

22:43:53.2920.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)

22:43:53.2930.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_comments" WHERE "id"='191300')

22:43:53.2930.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)

22:43:53.2931.4 msINSERTINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_id", "parent", "description", "object_type", "description2", "is_system") VALUES (1000, 17942, 191300, '', '9', '', FALSE) RETURNING "id"

22:43:53.2951.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 191301, 'a:11:{s:2:"id";i:191301;s:9:"object_id";s:5:"17942";s:11:"object_type";s:1:"9";s:6:"parent";s:6:"191300";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, '39.157.26.122')

22:43:53.2962.0 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id"=191301)

22:43:53.2981.0 msINSERTINSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (310, 191301, 28148)

22:43:53.2990.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_comments" WHERE "id"='191300'

22:43:53.30016.5 msSELECTSELECT "remind_user_id" FROM "a57be577deb434"."tbl_unread_comments" WHERE "comment_id"='191300' GROUP BY "remind_user_id"

22:43:53.3171.0 msINSERTINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES ('17942', '9', 191301, 5250)

22:43:53.3180.2 msSELECTSELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5250) AND (channel_id IS NOT NULL)

22:43:53.3180.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

22:43:53.3201.8 msINSERTINSERT 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":["28148"],"object_id":"17942","parent":"191300","description":"","object_type":"9"},"device_type":"0","version_code":"266","token":"1ef33479acaa701ac7c4ee6b075a5156","posttime":"1757688233"}', '{"code":200,"data":{"id":191301},"status":1,"msg":[{"name":"success","success":"\u65b0\u7559\u8a00\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-09-12 22:43:53') RETURNING "id"