SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    99275, 99272, 99262, 99261, 99258, 99217, 
    99132, 99129, 99124, 98903, 98630, 
    98626, 98625, 98566, 97667, 99274, 
    89234, 99131, 98519, 99123
  )

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
89234 RRR029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632265200 0 Y N N B N R Y N N Y 10 1632265200 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 / Steve Ricketts / Dave The Elf 1642008526 Y 22/09/2021 22/10/2021 2021-12-17 17:37:27 0
97667 DS038 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Tanya Sly/Gary Sly 1629111043 Y 2021-12-17 17:37:27 0
98519 BTN019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632092400 0 Y N N B N R Y N N Y 10 1632092400 1633302000 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 5054286124054 GBKQU2192675 N Bring the noise recordings Dan Carter 1629738602 Y 2021-12-17 17:37:27 0
98566 ED014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 1633647600 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 5054286084952 GBKQU2186508 N Copyright Control D-Fi and Miss Vixen 1629869702 Y 2021-12-17 17:37:27 0
98625 TB20R008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Hatfish Music / 23rd Precinct Dave Owens / Frank Farrell 1630082875 Y 2021-12-17 17:37:27 0
98626 TB20R009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Ross Homson 1630082918 Y 2021-12-17 17:37:27 0
98630 SS094 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Slingshot Recordings Paul Norris 1630104647 Y 2021-12-17 17:37:27 0
98903 WLHH030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Welovehardhouse Damien Blanes / Fabio Seramota 1631225366 Y 2021-12-17 17:37:27 0
99123 TMP185 P A 1 1.69 1 0.000 0 0 0 0.00 0 1631919600 0 Y N N B N R Y N N Y 10 1631919600 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 Dom Sweeten 1631902027 Y 2021-12-17 17:37:27 0
99124 TMP186 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Matt Clarkson/James Lowe 1631902126 Y 2021-12-17 17:37:27 0
99129 GAR019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Bennett, Pat Glenny 1642253468 Y 24/09/2021 24/10/2021 2021-12-17 17:37:27 0
99131 HF055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632120636 0 Y N N B N R Y N N Y 10 1632092400 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 Karl Davies/Jase H House 1632121226 Y 2021-12-17 17:37:27 0
99132 KD-001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 K-Zone Digital Aaron James/Seanie Jackson/Adam Butler 1634885305 Y 2021-12-17 17:37:27 0
99217 UBT054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Damien Blanes 1632295351 Y 2021-12-17 17:37:27 0
99258 ESP078 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 1632344050 Y 2021-12-17 17:37:27 0
99261 PDR055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 1632385909 Y 2021-12-17 17:37:27 0
99262 PDR054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Stu Angus 1632385992 Y 2021-12-17 17:37:27 0
99272 FCP011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632438000 0 Y N N B N R Y N N Y 10 1632438000 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 Full Circle Productions Tara Nichols & Graham Jenkins 1632418924 Y 2021-12-17 17:37:27 0
99274 RPR197 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632426777 0 Y N N B N R Y N N Y 10 1632351600 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/Toolbox Publishing/Toolbox Publishing Wes Hull/Toby Bowen/Dave Owens 1632427295 Y 2021-12-17 17:37:27 0
99275 IA020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1632474284 0 Y N N B N R Y N N Y 10 1632438000 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 1632474923 Y 2021-12-17 17:37:27 0