SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN('2589')) ORDER BY FIELD(e.entity_id, 2589), `e`.`entity_id` asc
<pre/>2589 - shoes men