6a2a8002bcb79: POST https://beta.jinchangxiao.com/vue/search/client-and-supplier-by-name at 2026-06-11 05:29:38 pm by 221.216.117.119
Database Queries
总计6条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:29:38.777 | 0.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:29:38.780 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:29:38.782 | 7.6 ms | (SELECT id as key, id as client_id, null::integer as supplier_id, sales_rep, name, '客户' as type_display, 'client' as type FROM "a57be577deb434"."tbl_clients" WHERE (("name" ILIKE '%bjhl%') OR ("pinyin_shortcut" ILIKE '%bjhl%')) AND (1 = 1) AND ("deleted"=FALSE)) UNION ALL ( SELECT id as key, null::integer as client_id, id as supplier_id, null::integer as sales_rep, name, '供应商' as type_display, 'supplier' as type FROM "a57be577deb434"."tbl_suppliers" WHERE ("name" ILIKE '%bjhl%') OR ("pinyin_shortcut" ILIKE '%bjhl%') ) | |
| 17:29:38.790 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311 |
| 17:29:38.790 | 0.5 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311) |
| 17:29:38.792 | 1.5 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/search/client-and-supplier-by-name', '{"name":"bjhl","web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":[{"key":2791,"client_id":2791,"supplier_id":null,"sales_rep":null,"name":"PA\u6e20\u9053-\u5317\u4eac\u5408\u529b\u817e\u8fbe\u65b0\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8","type_display":"\u5ba2\u6237","type":"client","salesRep":null},{"key":1076,"client_id":1076,"supplier_id":null,"sales_rep":5311,"name":"\u5317\u4eac\u6c49\u9f99\u601d\u742a\u6570\u7801\u79d1\u6280\u6709\u9650\u516c\u53f8-S","type_display":"\u5ba2\u6237","type":"client","salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},{"key":3274,"client_id":3274,"supplier_id":null,"sales_rep":null,"name":"\u5317\u4eac\u4e92\u8054\u4e92\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8","type_display":"\u5ba2\u6237","type":"client","salesRep":null},{"key":431,"client_id":null,"supplier_id":431,"sales_rep":null,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","type_display":"\u4f9b\u5e94\u5546","type":"supplier","salesRep":null},{"key":80,"client_id":null,"supplier_id":80,"sales_rep":null,"name":"\u5317\u4eac\u8f89\u84dd\u4fdd\u76c8\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","type_display":"\u4f9b\u5e94\u5546","type":"supplier","salesRep":null},{"key":719,"client_id":null,"supplier_id":719,"sales_rep":null,"name":"\u5317\u4eac\u5408\u529b\u521b\u535a\u4fe1\u606f\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8","type_display":"\u4f9b\u5e94\u5546","type":"supplier","salesRep":null}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-11 17:29:38', 18134016) RETURNING "id" |