SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    92499, 92498, 92486, 91950, 91930, 91909, 
    1417, 92477, 91779, 91778, 91777, 91776, 
    91775, 91774, 91773, 91772, 91771, 
    91770, 91769, 91768
  )

Query time 0.00060

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
1417 twistedtraxx74 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B Y R Y N N Y 10 1611273600 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;} N twisted traxx michael smith 1610714615 Y 2021-12-17 17:37:27 0
91768 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033731 N 91780 Truelove Music Sam Townend 1608096007 Y 2021-12-17 17:37:27 0
91769 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033732 N 91780 Truelove Music Sam Townend 1616758268 Y 2021-12-17 17:37:27 0
91770 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033733 N 91780 Truelove Music Sam Townend 1608096008 Y 2021-12-17 17:37:27 0
91771 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033734 N 91780 Truelove Music Sam Townend 1616758271 Y 2021-12-17 17:37:27 0
91772 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033735 N 91780 Truelove Music Sam Townend 1608096008 Y 2021-12-17 17:37:27 0
91773 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033736 N 91780 Truelove Music Sam Townend 1608096008 Y 2021-12-17 17:37:27 0
91774 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033737 N 91780 Truelove Music Sam Townend 1608096008 Y 2021-12-17 17:37:27 0
91775 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033738 N 91780 Truelove Music Sam Townend 1616758274 Y 2021-12-17 17:37:27 0
91776 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033739 N 91780 Truelove Music Sam Townend 1608096009 Y 2021-12-17 17:37:27 0
91777 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033740 N 91780 Truelove Music Sam Townend 1608096009 Y 2021-12-17 17:37:27 0
91778 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033741 N 91780 Truelove Music Sam Townend 1608096009 Y 2021-12-17 17:37:27 0
91779 UNTIDYFRAC01D P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 5054285545836 GBLV62033742 N 91780 Truelove Music Sam Townend 1608096009 Y 2021-12-17 17:37:27 0
91909 ST022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 5054285510506 GBLV62028087 N Copyright Control Marc Daniels 1617959139 Y 2021-12-17 17:37:27 0
91930 BTIDMUSIC087 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 5054285552803 GBLV62035075 N BTID Music Trengove, Hayes 1617959141 Y 2021-12-17 17:37:27 0
91950 CR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 5054285535370 GBLV62031940 N Copyright Control Steve Riggs, Jay Ainsworth 1617959144 Y 2021-12-17 17:37:27 0
92477 DNZF934 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611014400 0 Y N N B N R Y N N Y 10 1611014400 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 5054285615690 GBKQU2104454 N DNZ Records DJ Chris Mac 1610601302 Y 2021-12-17 17:37:27 0
92486 DNZ433 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 5054285616208 GBKQU2104516 N DNZ Records V-Star 1610643901 Y 2021-12-17 17:37:27 0
92498 TIDYBAEP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 5054285620359 GBKQU2105350 N Copyright Control Various Artists 1617959145 Y 2021-12-17 17:37:27 0
92499 TIDYBAEP01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 5054285620359 GBKQU2105351 N Copyright Control Various Artists 1617959148 Y 2021-12-17 17:37:27 0