I have implemented the elasticsuite module with elasticsearch 7, to query the site to the cluster and not directly to the Database, but the following query is coming out on the front server:
SELECT
u
.* FROM ( (SELECTt
.value
,t
.attribute_id
,t
.store_id
FROMcatalog_category_entity_varchar
ASt
WHERE (entity_id = ‘3’) AND (attribute_id IN (’51’, ‘179’, ‘130’, ’54’, ’55’, ’58’, ’66’, ‘131’, ‘149’, ‘163’, ‘150’, ‘164’, ‘151’, ‘165’, ’69’, ’74’, ‘152’, ‘202’, ‘153’, ‘154’, ‘155’, ‘157’, ‘159’)) AND (store_id
IN (1, 0)))UNION ALL(SELECTt
.value
,t
.attribute_id
,t
.store_id
FROMcatalog_category_entity_int
ASt
WHERE (entity_id = ‘3’) AND (attribute_id IN (’52’, ’76’, ’77’, ’75’, ‘148’, ‘162’, ’59’, ’60’, ‘192’, ‘170’, ‘171’, ‘172’, ‘180’)) AND (store_id
IN (1, 0)))UNION ALL(SELECTt
.value
,t
.attribute_id
,t
.store_id
FROMcatalog_category_entity_text
ASt
WHERE (entity_id = ‘3’) AND (attribute_id IN (’53’, ’56’, ’57’, ’63’, ’64’, ’65’, ’73’, ‘166’, ’70’, ‘156’, ‘158’, ‘160’, ‘161’, ‘173’)) AND (store_id
IN (1, 0)))UNION ALL(SELECTt
.value
,t
.attribute_id
,t
.store_id
FROMcatalog_category_entity_datetime
ASt
WHERE (entity_id = ‘3’) AND (attribute_id IN (’67’, ’68’)) AND (store_id
IN (1, 0)))UNION ALL(SELECTt
.value
,t
.attribute_id
,t
.store_id
FROMcatalog_category_entity_decimal
ASt
WHERE (entity_id = ‘3’) AND (attribute_id IN (’78’)) AND (store_id
IN (1, 0))) ) ASu
ORDER BYstore_id
ASC;
I know it refers to the categories, but it should not, since the categories are also indexed in Elasticsearch, Is this because the menu doesn’t use elasticsuite on the front or is it for another reason?
Here is the query result:
I greatly appreciate if someone can help me solve this question, it is something very general
Thanks!!