Database Queries

总计8条数据
TimeDurationTypeQuery
  
16:56:38.4613.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'

16:56:38.4662.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

16:56:38.4771.4 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/', 'b4e1d910-69af-3547-b825-8dc8c5ea1ba6', 'IMG_20250917_165627.jpg', 'jpg', 'application/octet-stream', 3220667, '114.244.128.96', NULL) RETURNING "id"

16:56:38.4791.2 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Attachments', 28163, 'a:10:{s:2:"id";i:28163;s:9:"orig_name";s:23:"IMG_20250917_165627.jpg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"b4e1d910-69af-3547-b825-8dc8c5ea1ba6";s:9:"extension";s:3:"jpg";s:9:"file_size";i:3220667;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";N;s:10:"created_at";N;s:9:"file_type";s:24:"application/octet-stream";}', '', 1000, '114.244.128.96')

16:56:38.8470.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28163

16:56:39.5622.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='110023313048853392'))

16:56:39.5640.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"=''))

16:56:39.5651.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":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","posttime":"1758099399","version_code":"266","device_type":"0","token":"23c502609e8713fce15a8274a18e8217"}', '{"code":200,"data":{"summary":{"invoice_count":2,"amount_count":15000},"list":[{"saler_name":"\u5317\u4eac\u5929\u9a70\u541b\u6cf0\u5f8b\u5e08\u4e8b\u52a1\u6240","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"110023313048853392","occurrence_at":"2024-08-06 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"15000.00","invoice_duplicated":false,"attachment_id":28163,"x0":280,"y0":270,"x1":1318,"y1":258,"x2":1318,"y2":873,"x3":232,"y3":884},{"saler_name":"","purchaser_name":"\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u4eba\u6c11\u653f\u5e9c\u65b0\u6751\u8857\u9053\u529e\u4e8b\u5904","serial_no":"","occurrence_at":"","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"0.00","invoice_duplicated":false,"attachment_id":28163,"x0":1420,"y0":318,"x1":1598,"y1":316,"x2":1600,"y2":1147,"x3":1428,"y3":1166}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-17 16:56:39') RETURNING "id"