SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    93322, 93321, 93320, 93319, 93318, 93307, 
    93306, 93304, 93223, 93189, 93095, 
    93009, 92836, 92462, 92450, 92448, 
    92447, 92434, 92433, 91822
  )

Query time 0.00044

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
91822 FD041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 Nick Hayward 1608390406 Y 2021-12-17 17:37:27 0
92433 Cheek510 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 1614297600 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 5054285492680 GBKQU2092542 N Copyright Control Rob Yellowley, Andrew Holmes 1610514901 Y 2021-12-17 17:37:27 0
92434 Cheek510 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 1614297600 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 5054285492680 GBLV62023785 N Copyright Control Rob Yellowley, Andrew Holmes 1610514902 Y 2021-12-17 17:37:27 0
92447 DLI040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 1614297600 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 5054285554548 GBLV62035383 N Hatfish Amber Haslam, Charlie Goddard, Adam Taylor 1610514905 Y 2021-12-17 17:37:27 0
92448 DLI039 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 1614297600 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 5054285554524 GBLV62035382 N Copyright Control Jake Surgey 1610514906 Y 2021-12-17 17:37:27 0
92450 ED008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 1614297600 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 5054285599211 GBKQU2102081 N Epidemic Digital The Unseen 1610514907 Y 2021-12-17 17:37:27 0
92462 INR062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 1614297600 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 5054285613252 GBKQU2104112 N Copyright Control Spyndl 1610557501 Y 2021-12-17 17:37:27 0
92836 TMP170 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 Gary orton & Matt Clarkson 1611774443 Y 2021-12-17 17:37:27 0
93009 VR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 Ross Farley/Matt Clarkson 1612292841 Y 2021-12-17 17:37:27 0
93095 UBT046 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 Unbounded Traxx Neil Bee 1612424381 Y 2021-12-17 17:37:27 0
93189 TD006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 Kirk Povey 1646336432 Y 12/02/2021 14/03/2021 2021-12-17 17:37:27 0
93223 FLY009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 UNIT DVSN & Wellybob 1624430186 Y 2021-12-17 17:37:27 0
93304 VRC003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 G.W.R./NUROGL 1613004854 Y 2021-12-17 17:37:27 0
93306 FR121 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 Troy Gustini 1613047189 Y 2021-12-17 17:37:27 0
93307 FR122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 Troy Gustini 1613047188 Y 2021-12-17 17:37:27 0
93318 BB015B P A 1 1.69 1 0.000 0 0 0 0.00 0 1613113225 0 Y N N B N R Y N N Y 10 1613088000 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 Jared Nes 1637669881 Y 2021-12-17 17:37:27 0
93319 BB015A P A 1 1.69 1 0.000 0 0 0 0.00 0 1613113298 0 Y N N B N R Y N N Y 10 1613088000 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, Tara Nicholson, Jared Nes 1613114139 Y 2021-12-17 17:37:27 0
93320 TERBWRC P A 1 1.69 1 0.000 0 0 0 0.00 0 1613127839 0 Y N N B N R Y N N Y 10 1613088000 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 1613128520 Y 2021-12-17 17:37:27 0
93321 TERBWRC P A 1 1.69 1 0.000 0 0 0 0.00 0 1613127896 0 Y N N B N R Y N N Y 10 1613088000 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 1613128540 Y 2021-12-17 17:37:27 0
93322 TERBWRC P A 1 1.69 1 0.000 0 0 0 0.00 0 1613127951 0 Y N N B N R Y N N Y 10 1613088000 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 1613128559 Y 2021-12-17 17:37:27 0