Database Queries

总计8条数据
TimeDurationTypeQuery
  
15:54:06.5052.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='hLtdglndkreOmfJjmOe7Mve0kQO2lAQu'

15:54:06.5091.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

15:54:06.5190.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)

15:54:06.5201.3 msINSERTINSERT INTO "a57be577deb434"."tbl_attachments" ("path", "name", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('/var/www/beta/web/files/protected/a57be577deb434/2025/09/', 'c070e48f-c943-376b-8c39-0cdb4e34880a', 'img_20250918_155350.jpg', 'jpg', 'application/octet-stream', 2721056, '114.244.128.96', 1000) RETURNING "id"

15:54:06.5221.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Attachments', 28230, 'a:10:{s:2:"id";i:28230;s:9:"orig_name";s:23:"img_20250918_155350.jpg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"c070e48f-c943-376b-8c39-0cdb4e34880a";s:9:"extension";s:3:"jpg";s:9:"file_size";i:2721056;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"file_type";s:24:"application/octet-stream";}', '', 1000, '114.244.128.96')

15:54:06.9990.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28230

15:54:07.9720.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='11100208115114867884')

15:54:07.9731.1 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/reimbursement/recognize', '{"access_token":"hLtdglndkreOmfJjmOe7Mve0kQO2lAQu","posttime":"1758182047","version_code":"266","device_type":"0","token":"bf3c1caf6117067ab961595bec3c809f"}', '{"code":200,"data":{"summary":{"invoice_count":1,"amount_count":5},"list":[{"saler_name":"","purchaser_name":"","serial_no":"11100208115114867884","occurrence_at":"","type":"\u5b9a\u989d\u53d1\u7968","op":"quota_invoice","amount":"5.00","invoice_duplicated":true,"attachment_id":28230,"x0":159,"y0":635,"x1":1467,"y1":630,"x2":1511,"y2":1493,"x3":84,"y3":1494}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-18 15:54:07') RETURNING "id"