java Spring数据JPA本机查询抛出索引：1，大小：1

Question

我有点问题

我刚刚将本机查询添加到spring jpa

但这是idk为什么

以下是我的疑问：

查看创建查询

使用弹簧靴1.5.2和MariaDB 10.1.2

CREATE OR REPLACE VIEW `access_logs_hosts_view` AS
SELECT
    url_id,
    COUNT(0) AS access,
    IFNULL(SUBSTRING_INDEX(REGEXP_REPLACE(referrer,'https?://',''),'/',1),'unknown') AS referrer
FROM
    access_logs
GROUP BY
    url_id
    SUBSTRING_INDEX(REGEXP_REPLACE(`access_logs`.`referrer`,'https?://',''),'/',1)
ORDER BY access DESC

方法：

@Query(value = "SELECT * FROM access_logs_hosts_view ", nativeQuery = true)
List<Map<String, Object>> findCountAndReferrerByURL();

申请。yml

type: org.apache.tomcat.jdbc.pool.DataSource
driver-class-name: org.mariadb.jdbc.Driver

我的最终目标是只使用一个本地查询，在没有视图的情况下获取数据

SELECT 
    COUNT(0) AS access,
    ifnull(SUBSTRING_INDEX(REGEXP_REPLACE(referrer,'https?://',''),'/',1),"unknown") AS referrer
FROM access_logs
WHERE url_id = ?1
GROUP BY SUBSTRING_INDEX(REGEXP_REPLACE(referrer,'https?://',''),'/',1)     
ORDER BY access DESC