Database Queries

总计6条数据
TimeDurationTypeQuery
  
11:07:06.2810.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5461

11:07:06.2830.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

11:07:06.2840.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

11:07:06.28920.8 msSELECTSELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id WHERE (lower(p.name) ILIKE '%vo 实施服务%') OR ("p"."pinyin_shortcut" ILIKE '%vo 实施服务%') OR (lower(pt.name) ILIKE '%vo 实施服务%') OR (lower(pb.name) ILIKE '%vo 实施服务%') OR (lower(ps.name) ILIKE '%vo 实施服务%') OR (lower(pc.name) ILIKE '%vo 实施服务%') OR (lower(p.description) ILIKE '%vo 实施服务%') ORDER BY "updated_at" DESC) "c"

11:07:06.31020.2 msSELECTSELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id WHERE (lower(p.name) ILIKE '%vo 实施服务%') OR ("p"."pinyin_shortcut" ILIKE '%vo 实施服务%') OR (lower(pt.name) ILIKE '%vo 实施服务%') OR (lower(pb.name) ILIKE '%vo 实施服务%') OR (lower(ps.name) ILIKE '%vo 实施服务%') OR (lower(pc.name) ILIKE '%vo 实施服务%') OR (lower(p.description) ILIKE '%vo 实施服务%') ORDER BY "updated_at" DESC LIMIT 20

11:07:06.3341.5 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/project/product-list', '{"ProductSearch":{"keyword":"VO \u5b9e\u65bd\u670d\u52a1"},"page":"1","web_access_token":"--xxX6Gmp9PXF1XHWWwlXiYIP9-yVx7F"}', '{"code":2000,"result":{"list":[],"can_create":true,"can_update":true,"can_delete":true,"can_manage":true,"pagenation":{"totalcount":0,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.0.0 Safari\/537.36"}', FALSE, '2026-07-16 11:07:06', 55026944) RETURNING "id"