SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    90484, 89456, 89455, 91443, 90822, 91441, 
    91440, 91439, 91438, 91437, 91436, 
    91433, 91427, 91426, 89707, 91424, 
    91423, 91422, 91400, 91375
  )

Query time 0.00042

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
89455 TBTK019I P A 1 1.69 1 0.000 0 0 0 0.00 0 1607644800 0 Y N N B N R Y N N Y 10 1607644800 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;} 4 N Toolbox Publishing Aaron Crozier 1601406536 Y 2021-12-17 17:37:27 0
89456 TBTK019J P A 1 1.69 1 0.000 0 0 0 0.00 0 1607644800 0 Y N N B N R Y N N Y 10 1607644800 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;} 4 N Toolbox Publishing Aaron Crozier 1601406595 Y 2021-12-17 17:37:27 0
89707 VCR301 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607126400 0 Y N N B N R Y N N Y 10 1607040000 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;} 4 N Copyright Control Andy Naylor 1607075812 Y 2021-12-17 17:37:27 0
90484 WLHH022B P A 1 1.69 1 0.000 0 0 0 0.00 0 1607644800 0 Y N N B N R Y N N Y 10 1607644800 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;} 4 N Truelove Paul King/Chris Brown 1604931828 Y 2021-12-17 17:37:27 0
90822 PDR033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607472000 0 Y N N B N R Y N N Y 10 1607472000 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;} 4 N copyright control p.wale 1605628824 Y 2021-12-17 17:37:27 0
91375 HWR014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607040000 0 Y N N B N R Y N N Y 10 1607040000 0 N 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;} 4 N Hooverweight Records Sean Inside Out / Dark Suspects 1711483540 Y 2021-12-17 17:37:27 0
91400 TD004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607040000 0 Y N N B N R Y N N Y 10 1607040000 0 N 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;} 4 N Copyright Control Matt Feldwick, Rob Hills, Steve Taylor 1646336265 Y 04/12/2020 03/01/2021 2021-12-17 17:37:27 0
91422 ST8 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607068703 0 Y N N B N R Y N N Y 10 1607040000 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;} 4 N Hatfish Music James Nardi 1607068819 Y 2021-12-17 17:37:27 0
91423 HFAS001A P A 1 1.69 1 0.000 0 0 0 0.00 0 1607076649 0 Y N N B N R Y N N Y 10 1607040000 0 N 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;} 4 N Toolbox Digital Andy Barber 1607077651 Y 2021-12-17 17:37:27 0
91424 HFAS001B P A 1 1.69 1 0.000 0 0 0 0.00 0 1607076746 0 Y N N B N R Y N N Y 10 1607040000 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;} 4 N Toolbox Digital Brian Keith 1607076941 Y 2021-12-17 17:37:27 0
91426 TMP164 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607126400 0 Y N N B N R Y N N Y 10 1607126400 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;} 4 N Tempo Trax Craig Dunbar 1607105024 Y 2021-12-17 17:37:27 0
91427 TMP165 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607126400 0 Y N N B N R Y N N Y 10 1607126400 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;} 4 N Tempo Trax Peter Maxwell & Matt Clarkson 1607105113 Y 2021-12-17 17:37:27 0
91433 ESP058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607299200 0 Y N N B N R Y N N Y 10 1607299200 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;} 4 N Energy Source Productions DJ Serenity 1607260841 Y 2021-12-17 17:37:27 0
91436 TERBMC P A 1 1.69 1 0.000 0 0 0 0.00 0 1607340065 0 Y N N B N R Y N N Y 10 1607299200 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;} 4 N Toolbox Ross Homson 1607340619 Y 2021-12-17 17:37:27 0
91437 TERBMC P A 1 1.69 1 0.000 0 0 0 0.00 0 1607340127 0 Y N N B N R Y N N Y 10 1607299200 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;} 4 N Toolbox Ross Homson 1607340636 Y 2021-12-17 17:37:27 0
91438 TERBMC P A 1 1.69 1 0.000 0 0 0 0.00 0 1607340190 0 Y N N B N R Y N N Y 10 1607299200 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;} 4 N Toolbox Ross Homson 1607340653 Y 2021-12-17 17:37:27 0
91439 TERBMC P A 1 1.69 1 0.000 0 0 0 0.00 0 1607340247 0 Y N N B N R Y N N Y 10 1607299200 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;} 4 N Toolbox Ross Homson 1607340672 Y 2021-12-17 17:37:27 0
91440 TERBMC P A 1 1.69 1 0.000 0 0 0 0.00 0 1607340321 0 Y N N B N R Y N N Y 10 1607299200 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;} 4 N Toolbox Ross Homson 1607340690 Y 2021-12-17 17:37:27 0
91441 TERBMC P A 1 1.69 1 0.000 0 0 0 0.00 0 1607340403 0 Y N N B N R Y N N Y 10 1607299200 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;} 4 N Toolbox Ross Homson 1607340709 Y 2021-12-17 17:37:27 0
91443 ESP059 P A 1 1.69 1 0.000 0 0 0 0.00 0 1607558400 0 Y N N B N R Y N N Y 10 1607558400 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;} 4 N Energy Source Productions DJ Serenity 1607365440 Y 2021-12-17 17:37:27 0