SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    93222, 93224, 93165, 92338, 92337, 93157, 
    93156, 93104, 93103, 93058, 93036, 
    92955, 92835, 92833, 92522, 92521, 
    92504, 92502, 92344, 92281
  )

Query time 0.00047

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
92281 FBR336 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Jay Goodall 1609961941 Y 2021-12-17 17:37:27 0
92337 BTN003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612742400 0 Y N N B N R Y N N Y 10 1612742400 1613952000 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 5054285606230 GBKQU2102937 N Bring The Noise Recordings Rick James 1610385302 Y 2021-12-17 17:37:27 0
92338 BTN003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612742400 0 Y N N B N R Y N N Y 10 1612742400 1613952000 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 5054285606230 GBKQU2102938 N Bring The Noise Recordings Rick James 1610385303 Y 2021-12-17 17:37:27 0
92344 ENC089 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Adam Butler 1610388436 Y 2021-12-17 17:37:27 0
92502 GHH002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 1613692800 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 5054285619940 GBKQU2105291 N Hot Box Digital Pete Maxwell & Matt Clarkson 1610730303 Y 2021-12-17 17:37:27 0
92504 VCR304 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Jake Surgey 1610739529 Y 2021-12-17 17:37:27 0
92521 WLHH023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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/Truelove Kate Fairbrother/John Evans 1610914272 Y 2021-12-17 17:37:27 0
92522 WLHH023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Kate Fairbrother/John Evans 1610914273 Y 2021-12-17 17:37:27 0
92833 HWR017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Tekneak 1711483428 Y 2021-12-17 17:37:27 0
92835 TMP169 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 1611774379 Y 2021-12-17 17:37:27 0
92955 VR002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Publishing, Copyright Control Slenderman / Rob Yellowley / Ross Farley 1646422801 Y 05/02/2021 07/03/2021 2021-12-17 17:37:27 0
93036 TRI002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Rob Yellowley 1612271770 Y 2021-12-17 17:37:27 0
93058 GAR002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 Andrew Holmes 1642247804 Y 05/02/2021 07/03/2021 2021-12-17 17:37:27 0
93103 KK001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612485402 0 Y N N B N R Y N N Y 10 1612483200 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 , Dave Grabowski 1612485921 Y 2021-12-17 17:37:27 0
93104 SSD034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612488474 0 Y N N B N R Y N N Y 10 1612483200 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 AUTO N Sugar Skull Digital Carl Pearce/Cheryl Pearce 1612488973 Y 2021-12-17 17:37:27 0
93156 TTLFD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612553587 0 Y N N B N R Y N N Y 10 1612483200 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 Jonni Bryant 1639912221 Y 2021-12-17 17:37:27 0
93157 KTI047 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612557467 0 Y N N B N R Y N N Y 10 1612483200 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 1612557923 Y 2021-12-17 17:37:27 0
93165 HF027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612769666 0 Y N N B N R Y N N Y 10 1612742400 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 David Jackson 1612770344 Y 2021-12-17 17:37:27 0
93222 RRR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612915200 0 Y N N B N R Y N N Y 10 1612915200 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 Stuart Angus 1642009048 Y 10/02/2021 12/03/2021 2021-12-17 17:37:27 0
93224 ESP066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612906203 0 Y N N B N R Y N N Y 10 1612828800 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 1612907120 Y 2021-12-17 17:37:27 0