SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    50247, 50246, 50245, 50244, 50243, 50242, 
    50241, 50220, 50219, 50218, 50217, 
    50216, 50215, 50214, 50213, 50212, 
    50211, 50210, 50209, 50208
  )

Query time 0.00034

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 Using where

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since exclusive_end_date out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params final_category aggregator aggregator_id ean isrc tbid is_album from_album publisher writers updated_timestamp available_worldwide stream_release_date download_release_date added_timestamp parent_product_id
50208 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBKQU1602260 N 50220 Copyright Control Various Artists 1463025831 Y 2021-12-17 17:37:27 0
50209 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBKQU1602402 N 50220 Copyright Control Various Artists 1463025834 Y 2021-12-17 17:37:27 0
50210 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBLV61501267 N 50220 Copyright Control Various Artists 1463025837 Y 2021-12-17 17:37:27 0
50211 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBLV61505182 N 50220 Copyright Control Various Artists 1463025839 Y 2021-12-17 17:37:27 0
50212 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBLV61502411 N 50220 Copyright Control Various Artists 1463025841 Y 2021-12-17 17:37:27 0
50213 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBLV61502563 N 50220 Copyright Control Various Artists 1463025844 Y 2021-12-17 17:37:27 0
50214 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBLV61513343 N 50220 Copyright Control Various Artists 1463025855 Y 2021-12-17 17:37:27 0
50215 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 AU8N01100068 N 50220 Copyright Control Various Artists 1463025858 Y 2021-12-17 17:37:27 0
50216 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBLV61511577 N 50220 Copyright Control Various Artists 1463025860 Y 2021-12-17 17:37:27 0
50217 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBKQU1595002 N 50220 Copyright Control Various Artists 1463025863 Y 2021-12-17 17:37:27 0
50218 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBKQU1600039 N 50220 Copyright Control Various Artists 1463025865 Y 2021-12-17 17:37:27 0
50219 LWWHAHC13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 GBLV61515675 N 50220 Copyright Control Various Artists 1463025870 Y 2021-12-17 17:37:27 0
50220 LWWHAHC13 P A 1 8.99 1 0.000 0 0 0 0.00 0 1463612400 0 Y N N B N R Y N N Y 10 1463612400 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282309073 Y 1463025873 Y 2021-12-17 17:37:27 0
50241 LWEGHH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1464562800 0 Y N N B N R Y N N Y 10 1464562800 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282321105 GBKQU1609149 N 50266 Copyright Control Various Artists 1478687819 Y 2021-12-17 17:37:27 0
50242 LWEGHH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1464562800 0 Y N N B N R Y N N Y 10 1464562800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282321105 GBLV61527402 N 50266 Copyright Control Various Artists 1463112159 Y 2021-12-17 17:37:27 0
50243 LWEGHH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1464562800 0 Y N N B N R Y N N Y 10 1464562800 0 B 0 0 0 0 6 N 0 P F default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282321105 GBKQU1614235 N 50266 Copyright Control Various Artists 1478688474 Y 2021-12-17 17:37:27 0
50244 LWEGHH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1464562800 0 Y N N B N R Y N N Y 10 1464562800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282321105 GBKQU1616820 N 50266 Copyright Control Various Artists 1463112164 Y 2021-12-17 17:37:27 0
50245 LWEGHH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1464562800 0 Y N N B N R Y N N Y 10 1464562800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282321105 GBKQU1605022 N 50266 Copyright Control Various Artists 1463112167 Y 2021-12-17 17:37:27 0
50246 LWEGHH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1464562800 0 Y N N B N R Y N N Y 10 1464562800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282321105 GBLV61507108 N 50266 Copyright Control Various Artists 1463112170 Y 2021-12-17 17:37:27 0
50247 LWEGHH04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1464562800 0 Y N N B N R Y N N Y 10 1464562800 0 B 0 0 0 0 6 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} labelworx 5054282321105 GBLV61515056 N 50266 Copyright Control Various Artists 1463112178 Y 2021-12-17 17:37:27 0