Database Queries

总计9条数据
TimeDurationTypeQuery
  
15:39:38.7072.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='jHlpO8y0vHBbQ6l37r2-YY8AcmS4s8X9'

15:39:38.7111.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

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

15:39:38.7231.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/', '19e540e4-e75c-35dd-b873-7f559dd601d0', '20250918153926.jpeg', 'jpeg', 'image/jpeg', 12545535, '117.176.186.24', 1000) RETURNING "id"

15:39:38.7241.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', 28214, 'a:10:{s:2:"id";i:28214;s:9:"orig_name";s:19:"20250918153926.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"19e540e4-e75c-35dd-b873-7f559dd601d0";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:12545535;s:10:"ip_address";s:14:"117.176.186.24";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1000, '117.176.186.24')

15:39:39.1800.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28214

15:39:40.0940.6 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='11100208115114867885')

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

15:39:40.0951.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, 2, 1149, 'v2/reimbursement/recognize', '{"access_token":"jHlpO8y0vHBbQ6l37r2-YY8AcmS4s8X9","device_type":"2","posttime":"1758181120","token":"5198ed3268b36fba04cab33e293c1120","version_code":"1149"}', '{"code":200,"data":{"summary":{"invoice_count":2,"amount_count":5},"list":[{"saler_name":"","purchaser_name":"","serial_no":"11100208115114867885","occurrence_at":"","type":"\u5b9a\u989d\u53d1\u7968","op":"quota_invoice","amount":"5.00","invoice_duplicated":false,"attachment_id":28214,"x0":542,"y0":56,"x1":1238,"y1":68,"x2":1222,"y2":1171,"x3":541,"y3":1152},{"saler_name":"","purchaser_name":"","serial_no":"11100208115114867884","occurrence_at":"","type":"\u5b9a\u989d\u53d1\u7968","op":"quota_invoice","amount":"","invoice_duplicated":false,"attachment_id":28214,"x0":1250,"y0":66,"x1":1598,"y1":80,"x2":1597,"y2":1157,"x3":1231,"y3":1145}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-18 15:39:40') RETURNING "id"