SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (`e`.`entity_id` IN('2589', '2643', '2841', '2850', '2916', '2922', '3028', '3049', '3061', '3077', '3101', '3151', '3157', '3161', '3162', '3176', '3189', '3201', '3268', '3273', '3426', '3435', '3441', '3452', '3527', '3727', '3728', '3738')) ORDER BY FIELD(e.entity_id, 2589,2643,2841,2850,2916,2922,3028,3049,3061,3077,3101,3151,3157,3161,3162,3176,3189,3201,3268,3273,3426,3435,3441,3452,3527,3727,3728,3738), `e`.`entity_id` asc
<pre/>2589 - shoes men
2643 - new mob ng pr
2841 - Gi Product 4
2850 - New ODOP Pro1
2916 - New ODOP 002
2922 - Test 0969
3028 - Testpr012
3049 - Test GI  odop new
3061 - Kurta multi
3077 - New ODOP Product0126
3101 - Testpr multi 
3151 - shwals gi odop
3157 - Multi Kurtas 1
3161 - Gi and odop product
3162 - Gi Odop Simple product
3176 - Test Multi  color product (English)
3189 - Kurta pajama set multi odop gi
3201 - Testpr multi
3268 - Mlti color product
3273 - BedSheet multi
3426 - Product Name
3435 - Test new warejouse product
3441 - kurties multi wrh
3452 - Kurta payjama set multi
3527 - Multi color shirt 1
3727 - kurta m 
3728 - Shwals  simple pr Self
3738 - New Shwals Wrh simple