ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68838d8005c71: POST https://beta.jinchangxiao.com/v2/user/get-edit at 2025-07-25 09:58:24 pm by 39.157.26.18

Database Queries

总计11条数据
TimeDurationTypeQuery
  
21:58:24.0292.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je'

[+] Explain
21:58:24.0326.5 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_users' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
21:58:24.0399.6 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_users' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
21:58:24.0500.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5300

[+] Explain
21:58:24.0510.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5300

[+] Explain
21:58:24.0540.4 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1

[+] Explain
21:58:24.0550.2 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id"=2

[+] Explain
21:58:24.0550.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=5300

[+] Explain
21:58:24.0560.6 msSELECTSELECT "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('AccountManager', 'Operator'))

[+] Explain
21:58:24.0570.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_user_meta" WHERE "user_id"=5300

[+] Explain
21:58:24.0591.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5300, 2, 1144, 'v2/user/get-edit', '{"access_token":"GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je","device_type":"2","posttime":"1753451904","token":"e05a25ac4199be17cddda8b98d273a00","version_code":"1144"}', '{"code":200,"data":{"model":{"id":5300,"email":"suqingyun@toast.com.cn","name":"\u82cf\u6e05\u4e91","user_status":"1","pinyin_shortcut":"sqy","sex":"F","birth_date":"1988-11-27","entry_date":"2021-06-28","department_id":1,"department_position_id":2,"mobile":"13889570890","telephone":"88864628","created_at":"2021-06-28 09:26:03","updated_at":"2021-11-29 16:30:12","id_number":"230231198811274721","native_place":"\u9ed1\u9f99\u6c5f\u7701\u62dc\u6cc9\u53bf","graduate_school":"\u9ed1\u9f99\u6c5f\u519c\u4e1a\u7ecf\u6d4e\u804c\u4e1a\u5b66\u9662","specialty":"\u5546\u52a1\u82f1\u8bed","education":"\u5927\u4e13","telephone_area_code":"010","telephone_extension_number":"","leave_date":null,"pinyin1":"su","pinyin2":"qing","pinyin3":"yun","pinyin4":null,"namecut1":"\u82cf","namecut2":"\u6e05","namecut3":"\u4e91","namecut4":null,"budget_count":"115895","profit_count":"62331.860700000000000000","bargain_count":"12","opportunity_budget_count":"598952","opportunity_count":"4","work_log_score":"14","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":true,"client_lock":true,"view_public":true,"client_remind_alarm_before":3,"work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"key":1,"name":"\u9500\u552e\u90e8"},"departmentPosition":{"key":2,"name":"\u5ba2\u6237\u7ecf\u7406"},"userRoles":[{"key":175,"name":"Operator","display_name":"\u5ba2\u6237\u8fd0\u8425"},{"key":81,"name":"AccountManager","display_name":"\u5ba2\u6237\u7ecf\u7406"}],"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"options":[{"key":"Users[sex]","name":"sex","value":[{"key":"M","name":"\u7537"},{"key":"F","name":"\u5973"}]}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-25 21:58:24') RETURNING "id"

[+] Explain