SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN('3527')) ORDER BY FIELD(e.entity_id, 3527), `e`.`entity_id` asc
<pre/>3527 - Multi color shirt 1