Database Queries

总计5条数据
TimeDurationTypeQuery
  
14:23:02.7162.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'

14:23:02.7201.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

14:23:02.7251.2 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/', '1e8c5063-a6bd-3646-b3df-920ebb9bdf6a', 'screenshot_20250908_142245.jpg', 'jpg', 'image', 589529, '114.254.3.114', NULL) RETURNING "id"

14:23:02.7261.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Attachments', 28050, 'a:10:{s:2:"id";i:28050;s:9:"orig_name";s:30:"screenshot_20250908_142245.jpg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"1e8c5063-a6bd-3646-b3df-920ebb9bdf6a";s:9:"extension";s:3:"jpg";s:9:"file_size";i:589529;s:10:"ip_address";s:13:"114.254.3.114";s:10:"created_by";N;s:10:"created_at";N;s:9:"file_type";s:5:"image";}', '', 1000, '114.254.3.114')

14:23:07.8731.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 170, 'v2/reimbursement/recognize', '{"posttime":"1757312581.915","access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"6","version_code":"170","token":"7d7c22696920281f35d5709ad631dcc0"}', '{"code":200,"data":{"summary":{"invoice_count":6,"amount_count":2227.97},"list":[{"saler_name":"saler_name_0","purchaser_name":"purchaser_name_0","serial_no":"46241009816298252799","occurrence_at":"2025-09-05 00:00:00","type":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968","amount":422.02,"invoice_duplicated":true,"attachment_id":323,"x0":39,"y0":12,"x1":438,"y1":12,"x2":39,"y2":451,"x3":438,"y3":451},{"saler_name":"saler_name_1","purchaser_name":"purchaser_name_1","serial_no":"46893769562570590078","occurrence_at":"2025-09-02 00:00:00","type":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968","amount":360.05,"invoice_duplicated":false,"attachment_id":132,"x0":47,"y0":39,"x1":434,"y1":39,"x2":47,"y2":413,"x3":434,"y3":413},{"saler_name":"saler_name_2","purchaser_name":"purchaser_name_2","serial_no":"16149858795090257997","occurrence_at":"2025-09-04 00:00:00","type":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968","amount":328.7,"invoice_duplicated":false,"attachment_id":465,"x0":50,"y0":14,"x1":436,"y1":14,"x2":50,"y2":479,"x3":436,"y3":479},{"saler_name":"saler_name_3","purchaser_name":"purchaser_name_3","serial_no":"61700802272478070647","occurrence_at":"2025-09-07 00:00:00","type":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968","amount":336.09,"invoice_duplicated":true,"attachment_id":363,"x0":28,"y0":44,"x1":466,"y1":44,"x2":28,"y2":409,"x3":466,"y3":409},{"saler_name":"saler_name_4","purchaser_name":"purchaser_name_4","serial_no":"39138231061789111391","occurrence_at":"2025-09-05 00:00:00","type":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968","amount":290.25,"invoice_duplicated":true,"attachment_id":199,"x0":32,"y0":14,"x1":434,"y1":14,"x2":32,"y2":412,"x3":434,"y3":412},{"saler_name":"saler_name_5","purchaser_name":"purchaser_name_5","serial_no":"29915262171956231167","occurrence_at":"2025-09-06 00:00:00","type":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968","amount":490.86,"invoice_duplicated":false,"attachment_id":408,"x0":43,"y0":28,"x1":478,"y1":28,"x2":43,"y2":442,"x3":478,"y3":442}],"data1":[{"id":28050,"path":"\/v2\/attachment\/view\/gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om\/1e8c5063-a6bd-3646-b3df-920ebb9bdf6a\/screenshot_20250908_142245.jpg"}],"data2":[{"id":28050,"path":"\/files\/protected\/a57be577deb434\/2025\/09\/1e8c5063-a6bd-3646-b3df-920ebb9bdf6a.jpg"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-08 14:23:07') RETURNING "id"