SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    98240, 98239, 98238, 98237, 98236, 98234, 
    98233, 98218, 97607, 98225, 98224, 
    98217, 98200, 98179, 98176, 98165, 
    98078, 97968, 97967, 97537
  )

Query time 0.00052

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
97537 BMR217 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 1630623600 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 5054285935880 GBKQU2161803 N Beast Mode Recordings Renshi, NuroGL 1625634602 Y 2021-12-17 17:37:27 0
97607 BTN016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628463600 0 Y N N B N R Y N N Y 10 1628463600 1629673200 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 5054286033974 GBKQU2178282 N Bring The Noise Recordings Martyn 'B' Boswell 1626110108 Y 2021-12-17 17:37:27 0
97967 TBR215 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 Rebel Frequency / Tom Whyld 1627413375 Y 2021-12-17 17:37:27 0
97968 GAR014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 Andrew Holmes / Craig Bywater / Dean Richardson 1642253036 Y 06/08/2021 05/09/2021 2021-12-17 17:37:27 0
98078 TTLFD011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 Karim Fassih 1641760616 Y 06/08/2021 05/09/2021 2021-12-17 17:37:27 0
98165 TRI007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 1628033814 Y 2021-12-17 17:37:27 0
98176 TB20R001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 Alan Thompson 1628075443 Y 2021-12-17 17:37:27 0
98179 FCP003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 Andrew Holmes, Rob Yellowley 1647283676 Y 2021-12-17 17:37:27 0
98200 PDR048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628235827 0 Y N N B N R Y N N Y 10 1628204400 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 adrian hoggbuss 1628663907 Y 2021-12-17 17:37:27 0
98217 TMP183 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628330646 0 Y N N B N R Y N N Y 10 1628290800 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 Carl Hawker/Matt Clarkson 1628331336 Y 2021-12-17 17:37:27 0
98218 ESP077 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628463600 0 Y N N B N R Y N N Y 10 1628463600 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 1628335125 Y 2021-12-17 17:37:27 0
98224 RPR195 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628422046 0 Y N N B N R Y N N Y 10 1628377200 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 AUTOGENERATE N none Michael Costigan/Johnny Pratley/Matt Rains 1628423544 Y 2021-12-17 17:37:27 0
98225 RPR196 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628423031 0 Y N N B N R Y N N Y 10 1628377200 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 AUTOGENERATE N Toolbox Publishing/none Gemma Stapleton 1628423127 Y 2021-12-17 17:37:27 0
98233 HF050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628489908 0 Y N N B N R Y N N Y 10 1628463600 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 Ben Vennard/James Valentine 1628490627 Y 2021-12-17 17:37:27 0
98234 HF050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628489985 0 Y N N B N R Y N N Y 10 1628463600 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 Ben Vennard/Pat Glenny 1628490653 Y 2021-12-17 17:37:27 0
98236 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Ben Stevens/Gary O'Connor 1628596585 Y 2021-12-17 17:37:27 0
98237 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Dave Curtis/Gary O'Connor 1628596604 Y 2021-12-17 17:37:27 0
98238 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor 1628596616 Y 2021-12-17 17:37:27 0
98239 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor 1628596619 Y 2021-12-17 17:37:27 0
98240 DSBC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628550000 0 Y N N B N R Y N N Y 10 1628550000 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 Gary O'Connor 1628596626 Y 2021-12-17 17:37:27 0