6a1d30c2ab353: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/get-filter at 2026-06-01 03:12:02 pm by 43.224.72.82
Database Queries
总计9条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:12:02.703 | 1.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5495 |
| 15:12:02.706 | 0.4 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495 |
| 15:12:02.709 | 0.6 ms | SELECT | SELECT "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort" |
| 15:12:02.710 | 1.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id" IN (SELECT "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "user_status"='1') ORDER BY "order" |
| 15:12:02.712 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE ("user_status"='1') AND ("department_id" IN (1, 4)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 15:12:02.714 | 1.1 ms | SELECT | SELECT "g"."id", "g"."id" AS "key", "g"."name" FROM "o6a13e2c574d5a"."tbl_groups" "g" LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.group_id = g.id WHERE ("sgr"."sales_id"=5493) AND (g.id != 999999) AND ("sgr"."sales_id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "user_status"='1')) GROUP BY "g"."id" ORDER BY "sort" |
| 15:12:02.716 | 0.2 ms | SELECT | SELECT * FROM "o6a13e2c574d5a"."tbl_sales_group_relationships" WHERE "group_id"=1 |
| 15:12:02.716 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "user_status", "pinyin_shortcut" FROM "o6a13e2c574d5a"."tbl_users" WHERE ("id"=5493) AND ("user_status"='1') AND ("id" IN (5493, 5495)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 15:12:02.717 | 1.2 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/erp-sales-outbound/get-filter', '{"web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"ErpSalesOutboundSearch[erp_store_id]":{"key":"ErpSalesOutboundSearch[erp_store_id]","name":"\u53d1\u8d27\u4ed3\u5e93","value":[{"key":1,"name":"\u4e3b\u4ed3\u5e93"}],"default":""},"ErpSalesOutboundSearch[wrote_date_period]":{"custom":"1","key":"ErpSalesOutboundSearch[wrote_date_period]","name":"\u5f55\u5355\u65e5\u671f","value":[{"key":"thisweek","name":"\u672c\u5468"},{"key":"lastweek","name":"\u4e0a\u5468"},{"key":"thismonth","name":"\u672c\u6708"},{"key":"lastmonth","name":"\u4e0a\u6708"},{"key":"currentfascalyear","name":"\u672c\u8d22\u5e74"}],"default":""},"ErpSalesOutboundSearch[is_sales_order_ready]":{"custom":"1","key":"ErpSalesOutboundSearch[is_sales_order_ready]","name":"\u9500\u552e\u8bb0\u5f55","value":[{"key":"1","name":"\u5df2\u751f\u6210\u9500\u552e\u8bb0\u5f55"},{"key":"0","name":"\u672a\u751f\u6210\u9500\u552e\u8bb0\u5f55"}],"default":""},"ErpSalesOutboundSearch[status]":{"key":"ErpSalesOutboundSearch[status]","name":"\u5ba1\u6279\u72b6\u6001","value":[{"key":1,"name":"\u5ba1\u6838\u4e2d"},{"key":2,"name":"\u5df2\u901a\u8fc7"},{"key":4,"name":"\u5df2\u62d2\u7edd"},{"key":5,"name":"\u7ea2\u5b57\u53cd\u51b2\u5ba1\u6838\u4e2d"},{"key":6,"name":"\u7ea2\u5b57\u53cd\u51b2"}],"default":""},"ErpSalesOutboundSearch[created_by]":{"key":"ErpSalesOutboundSearch[created_by]","itemKey":"ErpSalesOutboundSearch[created_by]","name":"\u521b\u5efa\u4eba","value":[{"id":1,"key":1,"name":"\u603b\u7ecf\u7406","child":[{"id":5493,"key":5493,"name":"97289742","department_id":1}]},{"id":4,"key":4,"name":"\u5546\u52a1\u90e8","child":[{"id":5495,"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","department_id":4}]}],"default":"","type":"CascadeMultiple"},"ErpSalesOutboundSearch[handler]":{"key":"ErpSalesOutboundSearch[handler]","itemKey":"ErpSalesOutboundSearch[handler]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"id":1,"key":1,"name":"\u672a\u5206\u7ec4","child":[{"id":5493,"key":5493,"name":"97289742","user_status":"1","pinyin_shortcut":"97289742"}]}],"default":"","type":"CascadeMultiple"},"ErpSalesOutboundSearch[created_at_period]":{"custom":"1","key":"ErpSalesOutboundSearch[created_at_period]","name":"\u521b\u5efa\u65f6\u95f4","value":[{"key":"thisweek","name":"\u672c\u5468"},{"key":"lastweek","name":"\u4e0a\u5468"},{"key":"thismonth","name":"\u672c\u6708"},{"key":"lastmonth","name":"\u4e0a\u6708"},{"key":"currentfascalyear","name":"\u672c\u8d22\u5e74"},{"key":"custom","name":"\u81ea\u5b9a\u4e49"}],"default":""},"Filter[name]":{"key":"Filter[name]","name":"\u65f6\u95f4\u6392\u5e8f","value":[{"key":"default","name":"\u9ed8\u8ba4\u6392\u5e8f"},{"key":"verify_at","name":"\u5ba1\u6279\u65f6\u95f4"},{"key":"updated_at","name":"\u66f4\u65b0\u65f6\u95f4"},{"key":"created_at","name":"\u521b\u5efa\u65f6\u95f4"},{"key":"amount","name":"\u91c7\u8d2d\u603b\u989d"}],"default":"default"},"Filter[sort]":{"key":"Filter[sort]","name":"\u6392\u5e8f\u65b9\u5f0f","value":[{"key":"ASC","name":"\u6b63\u5e8f"},{"key":"DESC","name":"\u5012\u5e8f"}],"default":""}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 15:12:02', 15767040) RETURNING "id" |