SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    97107, 92929, 97862, 98142, 98141, 98140, 
    98083, 98082, 98081, 98080, 98079, 
    98071, 98069, 98028, 98027, 98026, 
    98025, 98024, 98023, 98022
  )

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
92929 VCR328 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 Tinrib Music Jon Bell / Barmak Hatamian 1612124117 Y 2021-12-17 17:37:27 0
97107 FD054 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;} 3 N Copyright Control Pete Mac / Rob Tissera 1624354978 Y 2021-12-17 17:37:27 0
97862 BMRMX1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627945200 0 Y N N B N R Y N N Y 10 1627945200 1630364400 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 5054286057864 GBKQU2181987 N Beast Mode Recordings Alexei Reynolds 1626887406 Y 2021-12-17 17:37:27 0
98022 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Gaz Pritchard/The Hoover Jocks 1627463092 Y 2021-12-17 17:37:27 0
98023 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Bizarre Q 1627463097 Y 2021-12-17 17:37:27 0
98024 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Mickey G 1627463100 Y 2021-12-17 17:37:27 0
98025 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Gaz Pritchard/Dean Richardson 1627463103 Y 2021-12-17 17:37:27 0
98026 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Dan Dyson 1627463106 Y 2021-12-17 17:37:27 0
98027 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Lance 1627463109 Y 2021-12-17 17:37:27 0
98028 SUP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 1627463111 Y 2021-12-17 17:37:27 0
98069 VRC005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Tara N/Lok_E 1627535107 Y 2021-12-17 17:37:27 0
98071 FCP002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 Alan James 1627619230 Y 2021-12-17 17:37:27 0
98079 BB028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627612314 0 Y N N B N R Y N N Y 10 1627599600 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 1627613124 Y 2021-12-17 17:37:27 0
98080 XA020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627634355 0 Y N N B N R Y N N Y 10 1627599600 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 xxxx N Copy Control Dion Phillips 1627634761 Y 2021-12-17 17:37:27 0
98081 IA016E P A 1 1.69 1 0.000 0 0 0 0.00 0 1627636375 0 Y N N B N R Y N N Y 10 1627599600 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 Aaron Higgins 1627636524 Y 2021-12-17 17:37:27 0
98082 BDREP002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627637005 0 Y N N B N R Y N N Y 10 1627599600 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 Tara Nicholson 1643557102 Y 30/07/2021 29/08/2021 2021-12-17 17:37:27 0
98083 BDREP002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627637131 0 Y N N B N R Y N N Y 10 1627599600 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 Tara Nicholson 1643557133 Y 30/07/2021 29/08/2021 2021-12-17 17:37:27 0
98140 HF049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627886786 0 Y N N B N R Y N N Y 10 1627858800 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 Digital Martin Harrison/Josh Foster 1627888280 Y 2021-12-17 17:37:27 0
98141 HF049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627886842 0 Y N N B N R Y N N Y 10 1627858800 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 Digital Martin Harrison/Josh Foster 1627888292 Y 2021-12-17 17:37:27 0
98142 HF049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627886940 0 Y N N B N R Y N N Y 10 1627858800 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 Digital Martin Harrison/Josh Foster 1627888331 Y 2021-12-17 17:37:27 0