我有一个查询,选择当前类别的过滤器,并显示每个过滤器中有多少产品是Atm,我有20k产品和10k过滤器供测试,大约需要1秒。执行这一点对我没有好处,我能做些什么来优化这个查询吗?SELECT SQL_NO_CACHE sd.filter_group_id, pf.filter_id AS filter_id, COUNT(DISTINCT p2c.product_id) AS total
FROM
强文本可以有人告诉我这个Elasticsearch错误是什么意思,它抛出了一个解释查询192.132.4.43:9200/search/_search& explain =true "errorinvalid_type_name_exception",
"reason": "Document mapping type name can't start with '_', found: [_s