SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    97981, 97980, 97979, 97978, 97665, 92933, 
    98075, 89237, 98522, 98518, 97905, 
    98481, 98480, 98479, 98478, 98477, 
    98476, 98475, 98474, 98473
  )

Query time 0.00040

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
89237 RRR027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629846000 0 Y N N B N R Y N N Y 10 1629846000 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 1642008759 Y 25/08/2021 24/09/2021 2021-12-17 17:37:27 0
92933 VCR331 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Paul Glazby 1612124301 Y 2021-12-17 17:37:27 0
97665 DS036 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 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 Emma fournere/Casey Fournere 1627032120 Y 2021-12-17 17:37:27 0
97905 INR077 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629586800 0 Y N N B N R Y N N Y 10 1629586800 1632006000 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 5054286061489 GBKQU2182570 N Copyright Control Spyndl 1627059904 Y 2021-12-17 17:37:27 0
97978 Cheek541 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 1631228400 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 5054285775974 GBKQU2132535 N Copyright Control Danny Gibson 1627449005 Y 2021-12-17 17:37:27 0
97979 Cheek541 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 1631228400 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 5054285775974 GBKQU2132536 N Copyright Control Danny Gibson 1627449006 Y 2021-12-17 17:37:27 0
97980 Cheek541 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 1631228400 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 5054285775974 GBKQU2132537 N Copyright Control Danny Gibson 1627449006 Y 2021-12-17 17:37:27 0
97981 Cheek541 P A 1 1.69 1 0.000 0 0 0 0.00 0 1630018800 0 Y N N B N R Y N N Y 10 1630018800 1631228400 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 5054285775974 GBKQU2132538 N Copyright Control Danny Gibson 1627449006 Y 2021-12-17 17:37:27 0
98075 TT016D P A 1 1.69 1 0.000 0 0 0 0.00 0 1629846000 0 Y N N B N R Y N N Y 10 1629846000 1631055600 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 5054286072539 GBKQU2184517 N Tuff Trax Nick Georgiadis 1627578303 Y 2021-12-17 17:37:27 0
98473 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454320 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454711 Y 2021-12-17 17:37:27 0
98474 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454358 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454730 Y 2021-12-17 17:37:27 0
98475 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454482 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629454750 Y 2021-12-17 17:37:27 0
98476 TERBDF1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629454546 0 Y N N B N R Y N N Y 10 1629414000 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 Ross Homson 1629455437 Y 2021-12-17 17:37:27 0
98477 TBHH035B_U P A 1 1.69 1 0.000 0 0 0 0.00 0 1629455235 0 Y N N B N R Y N N Y 10 1629414000 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 Richard Senior / Ben Miles / James Nardi 1629455456 Y 2021-12-17 17:37:27 0
98478 IA017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629458066 0 Y N N B N R Y N N Y 10 1629414000 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 1629458127 Y 2021-12-17 17:37:27 0
98479 PDR050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629464588 0 Y N N B N R Y N N Y 10 1629414000 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 1629465326 Y 2021-12-17 17:37:27 0
98480 FCP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629464607 0 Y N N B N R Y N N Y 10 1629414000 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 Zillin Redeker 1629465346 Y 2021-12-17 17:37:27 0
98481 PDR050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629466400 0 Y N N B N R Y N N Y 10 1629414000 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 1629467126 Y 2021-12-17 17:37:27 0
98518 HF052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629700951 0 Y N N B N R Y N N Y 10 1629673200 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 The Sopranos/Nick Hayward 1629701127 Y 2021-12-17 17:37:27 0
98522 ESP078 P A 1 1.69 1 0.000 0 0 0 0.00 0 1629751537 0 Y N N B N R Y N N Y 10 1629673200 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 1629752431 Y 2021-12-17 17:37:27 0