SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    98339, 97666, 98898, 89236, 98794, 98793, 
    98791, 98393, 98772, 98771, 98769, 
    98736, 98734, 98672, 98622, 98523, 
    98170, 92934, 98770, 98161
  )

Query time 0.00054

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
89236 RRR028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631055600 0 Y N N B N R Y N N Y 10 1631055600 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 / Stevie-Louise Pickup 1642008664 Y 08/09/2021 08/10/2021 2021-12-17 17:37:27 0
92934 VCR332 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 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 Pat Glenny / Gary Cooke 1612124344 Y 2021-12-17 17:37:27 0
97666 DS037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631228400 0 Y N N B N R Y N N Y 10 1631228400 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 Ben Stevens 1629111058 Y 2021-12-17 17:37:27 0
98161 INR078 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630537200 0 Y N N B N R Y N N Y 10 1630537200 1632956400 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 5054286061410 GBKQU2182565 N Copyright Control Spyndl 1627967103 Y 2021-12-17 17:37:27 0
98170 PMD045 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 1631833200 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;} 1 labelworx 5054286046363 GBKQU2180289 N Pumped Joe Longbottom 1628054104 Y 2021-12-17 17:37:27 0
98339 ED013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631228400 0 Y N N B N R Y N N Y 10 1631228400 1632438000 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 5054286084945 GBKQU2186506 N Copyright Control Danny Haynes and Jay Middleton 1628658302 Y 2021-12-17 17:37:27 0
98393 BTN018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630882800 0 Y N N B N R Y N N Y 10 1630882800 1632092400 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;} 1 labelworx 5054286110095 GBKQU2190285 N Bring the noise recordings Paul Clark (CLK) 1629133502 Y 2021-12-17 17:37:27 0
98523 DBP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 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 Random But Raw/Riksta 1629973139 Y 2021-12-17 17:37:27 0
98622 TB20R005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 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 Toolbox Publishing Lucy Grimmer 1630600868 Y 2021-12-17 17:37:27 0
98672 GAR016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 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 Price 1642253233 Y 03/09/2021 03/10/2021 2021-12-17 17:37:27 0
98734 FD056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 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;} 3 N Copyright Control Gaz Fullard 1630657941 Y 2021-12-17 17:37:27 0
98736 BZK082 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 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 James Jackson 1630508503 Y 2021-12-17 17:37:27 0
98769 BB031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630623600 0 Y N N B N R Y N N Y 10 1630623600 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 Rob Yellowley, Ben Miles 1637696049 Y 2021-12-17 17:37:27 0
98770 KK008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630615200 0 Y N N B N R Y N N Y 10 1630537200 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 Alexei Reynolds 1630615542 Y 2021-12-17 17:37:27 0
98771 PDR051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630653553 0 Y N N B N R Y N N Y 10 1630623600 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 karl davies/jase h house 1630654227 Y 2021-12-17 17:37:27 0
98772 PDR052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630653702 0 Y N N B N R Y N N Y 10 1630623600 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 bailey / donna marie 1642266019 Y 03/09/2021 03/10/2021 2021-12-17 17:37:27 0
98791 HFEP007A P A 1 1.69 1 0.000 0 0 0 0.00 0 1630908571 0 Y N N B N R Y N N Y 10 1630882800 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 Jud Roper 1630917795 Y 2021-12-17 17:37:27 0
98793 HFEF007B P A 1 1.69 1 0.000 0 0 0 0.00 0 1630917763 0 Y N N B N R Y N N Y 10 1630882800 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 Jud Roper 1630917924 Y 2021-12-17 17:37:27 0
98794 FCP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630945011 0 Y N N B N R Y N N Y 10 1630882800 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 Full Circle Productions Zillin Redeker & Kev Pickford 1647283736 Y 2021-12-17 17:37:27 0
98898 PDR053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631179090 0 Y N N B N R Y N N Y 10 1631142000 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 Pat Glenny 1631179826 Y 2021-12-17 17:37:27 0