Category SQL

[Genaker]

SELECT catalog_category_product.category_id, catalog_category_product.position FROM catalog_category_product WHERE (product_id = 109340) - > []

SELECT catalog_category_entity.entity_id FROM catalog_category_entity WHERE ((entity_id = :entity_id)) AND (catalog_category_entity.created_in <= '1630438980') AND (catalog_category_entity.updated_in > '1630438980') - > [2] SQL time [0.00021600723266602] SELECT catalog_category_entity.* FROM catalog_category_entity WHERE ((catalog_category_entity.entity_id = '2')) AND (catalog_category_entity.created_in <= '1630438980') AND (catalog_category_entity.updated_in > '1630438980') - > [] SQL time [0.00021696090698242] SELECT catalog_category_entity.* FROM catalog_category_entity WHERE ((catalog_category_entity.path LIKE '1/2/%')) AND (catalog_category_entity.created_in <= '1630438980') AND (catalog_category_entity.updated_in > '1630438980') ORDER BY catalog_category_entity.position ASC - > [] SQL time [0.0004429817199707] SELECT e.entity_id FROM catalog_category_entity AS e LEFT JOIN catalog_category_entity_varchar AS at_name_default ON (at_name_default.row_id = e.row_id) AND (at_name_default.attribute_id = '41') AND at_name_default.store_id = 0 LEFT JOIN catalog_category_entity_varchar AS at_name ON (at_name.row_id = e.row_id) AND (at_name.attribute_id = '41') AND (at_name.store_id = 1) INNER JOIN catalog_category_entity_int AS d ON e.row_id = d.row_id LEFT JOIN catalog_category_entity_int AS c ON c.attribute_id = :attribute_id AND c.store_id = :store_id AND c.row_id = d.row_id WHERE ((e.entity_id IN('286', '116', )) AND (d.attribute_id = :attribute_id) AND (d.store_id = :zero_store_id) AND (IF(c.value_id > 0, c.value, d.value) = :cond)) AND (e.created_in <= '1630438980') AND (e.updated_in > '1630438980') - > [42 - 1 - 0 - 0]

EAV:

SELECT t_d.attribute_id, e.entity_id, t_d.value AS default_value, t_s.value AS store_value, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS value FROM catalog_category_entity_varchar AS t_d INNER JOIN catalog_category_entity AS e ON e.row_id = t_d.row_id AND (e.created_in <= '1630438980' AND e.updated_in > '1630438980') LEFT JOIN catalog_category_entity_varchar AS t_s ON t_s.attribute_id = t_d.attribute_id AND t_s.row_id = t_d.row_id AND t_s.store_id = 1 WHERE (e.entity_id IN (