查询组件文档浏览量

curl --location --request POST 'https://community1.codewave.163.com/api/v1/websql/table/sql' \
--header 'Cookie: wyy_uid=76168f36-3900-4fe7-be80-d7e0a9eeb694; nts_mail_user=15971377112@163.com:-1:1; NTES_P_UTID=9XvSpoOU5XZPVwWly8ui8QrioGJIsdEQ|1754985253; P_INFO=m15971377112@163.com|1754985253|0|mail163|00&99|gud&1754984941&mail163#gud&440100#10#0#0|159112&1|mailmaster_win&mail163|15971377112@163.com; _gcl_au=1.1.1901188342.1757408301; _ga=GA1.1.1734775020.1760085266; _ga_EPDQHDTJH5=GS2.1.s1760087403$o2$g0$t1760087403$j60$l0$h0; urs_t=b-BK2iy0l5vDN9l59AyOafdQ; urs_u=I1LNCnIutfJFdNiYvNUPegjBikgAMB/uaWOCp0UOZSdm0sBG8ZQmWulAbLRPvWW-BeLNFncEwgmwcNZhFpXx3t0zqPTJaR164rpfPq3cIcc/FVmnTMEt1yYu12eTp77pQicPwtRDoFOwwaf46-n5Z4JnSh5JKuAqkhbg-UL2vbLyr7-2939wlotOTp21QuXtSPj/go88bazPMeXZdEbdiUf96Dfo5lNCNQ6ezyRbtAXUo0WmH/gazkhRsVoueO9xT7cwj0OtcaNFnxG8ShBY/3R1UKf8Epn5lX-F5VDqWwGvA5ql6JJHC3yqS2JOLA3z; sf_token_http=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3NjQyNDU2OTIsImlhdCI6MTc2Mjk0OTY5MiwidXNlciI6ImUyODU4NjQ0NmU3NTQ2MzdiMGFmNWViODZmOTM3NGQ0NzYyNTYyNjI2MzUxOTI2NzAzMiJ9.qh-TPE15izzcr6XNJSu4cbPlopq3dvUnJUCTcK-Vlq0; sf_token_https=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3NjQyNDU2OTIsImlhdCI6MTc2Mjk0OTY5MiwidXNlciI6ImUyODU4NjQ0NmU3NTQ2MzdiMGFmNWViODZmOTM3NGQ0NzYyNTYyNjI2MzUxOTI2NzAzMiJ9.qh-TPE15izzcr6XNJSu4cbPlopq3dvUnJUCTcK-Vlq0; authorization=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJJc1NlcnZpY2VBY2NvdW50IjoiZmFsc2UiLCJBdXRoVHlwZVRva2VuRXhwaXJlIjoiODY0MDAiLCJVc2VySWQiOiIyZjk0ZWM2MWEwOWQ0MGJjOTVhZTRhOGIwZDljZDAyYSIsIlRoaXJkVXNlcklkIjoid2Iud2FuZ2ZlbmcwNyIsIkF1dGhUeXBlIjoiTmV0ZWFzZSIsImV4cCI6MTc2MzA4NjIwMSwiSXNUaGlyZFBhcnR5Q29va2llIjoiZmFsc2UiLCJpYXQiOjE3NjI5OTk4MDF9.mVKjtb4xpjoJY31rpzZBUpMVOdY3HUItkLlRkhw7oMM; Hm_lvt_266c1eb59e093c5981d1274d3866bece=1761159751,1762097962,1762308893,1762999868; HMACCOUNT=547D2878E8532E74; Hm_lpvt_266c1eb59e093c5981d1274d3866bece=1763016329; JSESSIONID=AF2861C6B1F6165DE1218964D927B4BF' \
--header 'Content-Type: application/json' \
--data-raw '{
    "appId": "afaec238-82f5-4996-8fdd-0aae42f393de",
    "env": "online",
    "dbName": "community214-online-FchJIO",
    "sql": "SELECT \r\n    CASE \r\n        WHEN fileName LIKE '\''%.%.%'\'' THEN \r\n            SUBSTRING_INDEX(SUBSTRING_INDEX(fileName, '\''.'\'', -2), '\''.'\'', 1)\r\n        ELSE fileName\r\n    END AS 组件名,\r\n    version AS 版本, \r\n    pageView AS 浏览量,\r\n      CASE \r\n    WHEN filePath LIKE '\''%Vue2%'\'' THEN '\''Vue2'\''\r\n    WHEN filePath LIKE '\''%Vue3%'\'' THEN '\''Vue3'\''\r\n    ELSE '\''未知组件库'\''\r\n  END as 组件库,\r\n  CASE \r\n    WHEN filePath LIKE '\''%PC端%'\'' THEN '\''PC'\''\r\n    WHEN filePath LIKE '\''%H5端%'\'' THEN '\''H5'\''\r\n    ELSE '\''未知端'\''\r\n  END as 端,\r\n    CONCAT(\r\n        '\''https://community.codewave.163.com/CommunityParent/fileIndex?filePath='\'',\r\n        filePath,\r\n        '\''&version='\'',\r\n        version,\r\n        '\''&selectType=codewave'\''\r\n    ) AS 链接\r\nFROM Doc \r\nWHERE \r\n    version IN ('\''4.1'\'', '\''4.2'\'')\r\n    AND filePath LIKE '\''%端Vue_组件说明%'\''\r\n    AND filePath NOT LIKE '\''%流程%'\''\r\nORDER BY \r\n    version DESC,\r\n    pageView DESC",
    "limit": 999,
    "offset": 0
}'