SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    99969, 99955, 99968, 99967, 99952, 99948, 
    99923, 99922, 99917, 99915, 99914, 
    99913, 99906, 99867, 99791, 99788, 
    99694, 99678, 99519, 99435
  )

Query time 0.00041

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
99435 FBR345 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Dylan Foley 1632945776 Y 2021-12-17 17:37:27 0
99519 TMP188 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Paul Hunter/Matt Clarkson 1633364201 Y 2021-12-17 17:37:27 0
99678 FRISKY008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Dylan Foley 1634847484 Y 2021-12-17 17:37:27 0
99694 GAR021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Alexie Reynolds 1642253718 Y 22/10/2021 21/11/2021 2021-12-17 17:37:27 0
99788 SS095 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 1634226559 Y 2021-12-17 17:37:27 0
99791 TTLFD014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Leigh Day/Rebecca Phillips 1641760703 Y 22/10/2021 21/11/2021 2021-12-17 17:37:27 0
99867 UBT055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Aron Hammond 1634558228 Y 2021-12-17 17:37:27 0
99906 BDRSE01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Dave Grabowski 1643557687 Y 22/10/2021 21/11/2021 2021-12-17 17:37:27 0
99913 EM009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Liam McNamara 1634837811 Y 2021-12-17 17:37:27 0
99914 FCP014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Alpha A 1634841342 Y 2021-12-17 17:37:27 0
99915 PDR057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634857200 0 Y N N B N R Y N N Y 10 1634857200 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 Dean Richardson 1634844776 Y 2021-12-17 17:37:27 0
99917 BB036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1634877814 0 Y N N B N R Y N N Y 10 1634857200 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 Wade 1634877920 Y 2021-12-17 17:37:27 0
99922 IA023A P A 1 1.69 1 0.000 0 0 0 0.00 0 1634901197 0 Y N N B N R Y N N Y 10 1634857200 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 Graham Jenkins 1634901322 Y 2021-12-17 17:37:27 0
99923 IA023B P A 1 1.69 1 0.000 0 0 0 0.00 0 1634901243 0 Y N N B N R Y N N Y 10 1634857200 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 Graham Jenkins 1634901339 Y 2021-12-17 17:37:27 0
99948 KT012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1635116400 0 Y N N B N R Y N N Y 10 1635116400 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 Kaki Trax Paul Norris 1698923929 Y 2021-12-17 17:37:27 0
99952 ESP079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1635116400 0 Y N N B N R Y N N Y 10 1635116400 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 Energy Source Productions DJ Serenity 1639400499 Y 2021-12-17 17:37:27 0
99955 HFD060 P A 1 1.69 1 0.000 0 0 0 0.00 0 1635150822 0 Y N N B N R Y N N Y 10 1635116400 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 Danny Gibson 1635151520 Y 2021-12-17 17:37:27 0
99967 ESP079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1635116400 0 Y N N B N R Y N N Y 10 1635116400 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 1639400520 Y 2021-12-17 17:37:27 0
99968 ESP079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1635116400 0 Y N N B N R Y N N Y 10 1635116400 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 1636925789 Y 2021-12-17 17:37:27 0
99969 PR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1635202800 0 Y N N B N R Y N N Y 10 1635202800 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 Pulse 8 Records Michael Smith & Gaz West 1635281523 Y 2021-12-17 17:37:27 0