SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN('2643', '2916', '3049', '3161', '3268', '3426', '3435')) ORDER BY FIELD(e.entity_id, 2643,2916,3049,3161,3268,3426,3435), `e`.`entity_id` asc
<pre/>2643 - new mob ng pr
2916 - New ODOP 002
3049 - Test GI  odop new
3161 - Gi and odop product
3268 - Mlti color product
3426 - Product Name
3435 - Test new warejouse product