SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    91821, 92682, 89223, 92807, 92769, 92768, 
    92767, 92760, 92759, 92757, 92256, 
    92572, 92523, 92280, 92259, 92237, 
    92674, 92571, 92524, 92460
  )

Query time 0.00051

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
89223 RRR012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611705600 0 Y N N B N R Y N N Y 10 1611705600 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 Matt Pickup / Steve Ricketts / Mike Booth 1642007151 Y 27/01/2021 26/02/2021 2021-12-17 17:37:27 0
91821 FD040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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 Simon Hill 1608390160 Y 2021-12-17 17:37:27 0
92237 GHH001 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 1612483200 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 labelworx 5054285594780 GBKQU2101301 N Global Hard House Dean Richardson 1609869301 Y 2021-12-17 17:37:27 0
92256 BMR210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611360000 0 Y N N B N R Y N N Y 10 1611360000 1613779200 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;} 3 labelworx 5054285591574 GBKQU2100696 N Beast Mode Recordings Renshi, NuroGL 1609873804 Y 2021-12-17 17:37:27 0
92259 HOT079 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 1612483200 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 labelworx 5054285593554 GBKQU2101019 N Hot Box Digital Team Sly, Bizarre Q 1609874402 Y 2021-12-17 17:37:27 0
92280 FBR335 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;} 4 N Copyright Control Simon Williams 1609961852 Y 2021-12-17 17:37:27 0
92460 SS089 P A 1 1.69 1 0.000 0 0 0 0.00 0 1610928000 0 Y N N B N R Y N N Y 10 1610928000 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 Slingshot Recordings Paul Norris/Jay Lyth 1610550974 Y 2021-12-17 17:37:27 0
92523 SSD033 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 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 AUTO N Sugar Skull Digital G.W.R. 1610951769 Y 2021-12-17 17:37:27 0
92524 HF025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1610954542 0 Y N N B N R Y N N Y 10 1610928000 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;} 3 N Toolbox Digital Bryn Whiting 1610955040 Y 2021-12-17 17:37:27 0
92571 KTI045 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611044143 0 Y N N B N R Y N N Y 10 1611014400 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 Truelove Music Dom Sweeten 1611418847 Y 2021-12-17 17:37:27 0
92572 VCR303 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;} 4 N Copyright Control Andy Naylor 1611055659 Y 2021-12-17 17:37:27 0
92674 VRC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611187054 0 Y N N B N R Y N N Y 10 1611100800 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 Ross Farley 1611187390 Y 2021-12-17 17:37:27 0
92682 DBP004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611792000 0 Y N N B N R Y N N Y 10 1611792000 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 Puddle of Pumping 1611268553 Y 2021-12-17 17:37:27 0
92757 KTI046 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611393884 0 Y N N B N R Y N N Y 10 1611360000 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 Truelove Music Dom Sweeten 1611418835 Y 2021-12-17 17:37:27 0
92759 KTI044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611419255 0 Y N N B N R Y N N Y 10 1611360000 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 Music Dom Sweeten / Owen Swinerd 1611419417 Y 2021-12-17 17:37:27 0
92760 BB013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611434091 0 Y N N B N R Y N N Y 10 1611360000 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 Ben Miles / Richard Senior 1611434720 Y 2021-12-17 17:37:27 0
92767 HFAS003A P A 1 1.69 1 0.000 0 0 0 0.00 0 1611560397 0 Y N N B N R Y N N Y 10 1611532800 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 Nick Hayward/Rick Eastham 1611561451 Y 2021-12-17 17:37:27 0
92768 HFAS003B P A 1 1.69 1 0.000 0 0 0 0.00 0 1611560465 0 Y N N B N R Y N N Y 10 1611532800 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 Nick Hayward/Rick Eastham 1611560739 Y 2021-12-17 17:37:27 0
92769 HFAS003C P A 1 1.69 1 0.000 0 0 0 0.00 0 1611560511 0 Y N N B N R Y N N Y 10 1611532800 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 Nick Hayward/Rick Eastham 1611560760 Y 2021-12-17 17:37:27 0
92807 FR120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611668702 0 Y N N B N R Y N N Y 10 1611619200 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 Rob Yellowley 1641480559 Y 26/01/2021 25/02/2021 2021-12-17 17:37:27 0