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_idFROMcatalog_category_entity_varcharAStWHERE (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_idIN (1, 0)))UNION ALL(SELECTt.value,t.attribute_id,t.store_idFROMcatalog_category_entity_intAStWHERE (entity_id = ‘3’) AND (attribute_id IN (’52’, ’76’, ’77’, ’75’, ‘148’, ‘162’, ’59’, ’60’, ‘192’, ‘170’, ‘171’, ‘172’, ‘180’)) AND (store_idIN (1, 0)))UNION ALL(SELECTt.value,t.attribute_id,t.store_idFROMcatalog_category_entity_textAStWHERE (entity_id = ‘3’) AND (attribute_id IN (’53’, ’56’, ’57’, ’63’, ’64’, ’65’, ’73’, ‘166’, ’70’, ‘156’, ‘158’, ‘160’, ‘161’, ‘173’)) AND (store_idIN (1, 0)))UNION ALL(SELECTt.value,t.attribute_id,t.store_idFROMcatalog_category_entity_datetimeAStWHERE (entity_id = ‘3’) AND (attribute_id IN (’67’, ’68’)) AND (store_idIN (1, 0)))UNION ALL(SELECTt.value,t.attribute_id,t.store_idFROMcatalog_category_entity_decimalAStWHERE (entity_id = ‘3’) AND (attribute_id IN (’78’)) AND (store_idIN (1, 0))) ) ASuORDER BYstore_idASC;
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!!
