SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    95922, 95921, 95839, 94774, 96891, 96733, 
    95876, 96757, 96756, 96755, 96754, 
    96753, 96752, 96751, 96750, 96749, 
    96748, 96743, 96715, 96711
  )

Query time 0.00055

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
94774 FD050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 Jason Briley / Liam McNamara 1617618491 Y 2021-12-17 17:37:27 0
95839 SSD044 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 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 AUTO N Sugar Skull Digital Boris The Noss 1620431252 Y 2021-12-17 17:37:27 0
95876 RRY002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623193200 0 Y N N B N R Y N N Y 10 1623193200 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 Rick James Eastham 1620674686 Y 2021-12-17 17:37:27 0
95921 Cheek529 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285723647 GBKQU2123235 N Copyright Control Steven Thornton, David Jackson 1620796501 Y 2021-12-17 17:37:27 0
95922 Cheek529 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623366000 0 Y N N B N R Y N N Y 10 1623366000 1624575600 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 5054285723647 GBKQU2123236 N Copyright Control Steven Thornton, David Jackson 1620796501 Y 2021-12-17 17:37:27 0
96711 BB024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622777662 0 Y N N B N R Y N N Y 10 1622761200 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 James Dumbrell 1622778324 Y 2021-12-17 17:37:27 0
96715 ESP071 P A 1 1.69 1 0.000 0 0 0 0.00 0 1622817855 0 Y N N B N R Y N N Y 10 1622761200 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 1622817923 Y 2021-12-17 17:37:27 0
96733 ST13 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623279600 0 Y N N B N R Y N N Y 10 1623279600 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 James Nardi & Martyn Harrison 1622907942 Y 2021-12-17 17:37:27 0
96743 HF042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623020400 0 Y N N B N R Y N N Y 10 1623020400 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 David Jackson/David Dobson 1623005282 Y 2021-12-17 17:37:27 0
96748 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623059654 0 Y N N B N R Y N N Y 10 1623020400 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 Paul Norris/Ben Vennard 1623060327 Y 2021-12-17 17:37:27 0
96749 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623059725 0 Y N N B N R Y N N Y 10 1623020400 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 Barney Coombs 1623060324 Y 2021-12-17 17:37:27 0
96750 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623059781 0 Y N N B N R Y N N Y 10 1623020400 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 Matt Clarkson/Dylan Foley 1623060319 Y 2021-12-17 17:37:27 0
96751 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623059891 0 Y N N B N R Y N N Y 10 1623020400 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 Sarah Griffiths/Chris Griffiths/Martin Cook 1623060317 Y 2021-12-17 17:37:27 0
96752 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623059958 0 Y N N B N R Y N N Y 10 1623020400 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 David Jackson/David Dobson 1623060316 Y 2021-12-17 17:37:27 0
96753 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623060013 0 Y N N B N R Y N N Y 10 1623020400 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 Matt Clarkson/Gary Orton 1623060922 Y 2021-12-17 17:37:27 0
96754 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623060139 0 Y N N B N R Y N N Y 10 1623020400 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 Rick James Eastham/Dave Gray 1623060943 Y 2021-12-17 17:37:27 0
96755 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623060216 0 Y N N B N R Y N N Y 10 1623020400 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 James Nardi/Kate Fairbrother/David Pym 1623060964 Y 2021-12-17 17:37:27 0
96756 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623060266 0 Y N N B N R Y N N Y 10 1623020400 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 Nick Hayward 1623060984 Y 2021-12-17 17:37:27 0
96757 HFDC001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623060307 0 Y N N B N R Y N N Y 10 1623020400 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 James Dumbrell 1623061005 Y 2021-12-17 17:37:27 0
96891 PDR043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1623365641 0 Y N N B N R Y N N Y 10 1623279600 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 1642265395 Y 10/06/2021 10/07/2021 2021-12-17 17:37:27 0