SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    100213, 100212, 100211, 100210, 100208, 
    100207, 100192, 100174, 93464, 100169, 
    100168, 100167, 100138, 100137, 100132, 
    100067, 100046, 100037, 99649, 99639
  )

Query time 0.00056

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
93464 VCR341 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636156800 0 Y N N B N R Y N N Y 10 1636070400 0 B 0 0 0 0 6 N 0 P F default 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 John Newell 1636106254 Y 2021-12-17 17:37:27 0
99639 UTHHT023b P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 1637280000 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 5054286199625 GBLV62105058 N Ultratech Dance Music UK Jay Middleton, Ryan Mercer & Lee Hobson 1633497310 Y 2021-12-17 17:37:27 0
99649 twistedtraxx 96 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 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 sentinelz scott sentinelz 1634461157 Y 2021-12-17 17:37:27 0
100037 GARH007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 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 Publishing, Copyright Control Craig Bywater/Damien Blanes 1642255088 Y 05/11/2021 05/12/2021 2021-12-17 17:37:27 0
100046 SSRR002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 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 1635799431 Y 2021-12-17 17:37:27 0
100067 TTLFD016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 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 Joshua Brown/Pete Ledwidge 1641760724 Y 05/11/2021 05/12/2021 2021-12-17 17:37:27 0
100132 BB037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 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 1635967565 Y 2021-12-17 17:37:27 0
100137 FR138 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 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 Rob Yellowley 1641484406 Y 05/11/2021 05/12/2021 2021-12-17 17:37:27 0
100138 FCP015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636070400 0 Y N N B N R Y N N Y 10 1636070400 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 Tash Tikka/Adam Bennett 1636059177 Y 2021-12-17 17:37:27 0
100167 BDR020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636101927 0 Y N N B N R Y N N Y 10 1636070400 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 Adrian Buss 1643557794 Y 05/11/2021 05/12/2021 2021-12-17 17:37:27 0
100168 BDR2-001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636102036 0 Y N N B N R Y N N Y 10 1636070400 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 Brian Felton 1643557875 Y 05/11/2021 05/12/2021 2021-12-17 17:37:27 0
100169 IA025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636105578 0 Y N N B N R Y N N Y 10 1636070400 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 Ant Roberts 1636106422 Y 2021-12-17 17:37:27 0
100174 HH001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636200190 0 Y N N B N R Y N N Y 10 1636156800 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;} 22 N Ditto Jay Folly 1636299282 Y 2021-12-17 17:37:27 0
100192 HF062 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636352840 0 Y N N B N R Y N N Y 10 1636329600 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 Ricky John/Ben Miles 1636353020 Y 2021-12-17 17:37:27 0
100207 ENCBO004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636475121 0 Y N N B N R Y N N Y 10 1636416000 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 Publishing Seanie Jackson 1636476434 Y 2021-12-17 17:37:27 0
100208 ENCBO004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636475153 0 Y N N B N R Y N N Y 10 1636416000 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 Paul Norris 1636475443 Y 2021-12-17 17:37:27 0
100210 ENCBO004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636475206 0 Y N N B N R Y N N Y 10 1636416000 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 Gav Filthy Plastic 1636475484 Y 2021-12-17 17:37:27 0
100211 ENCBO004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636475241 0 Y N N B N R Y N N Y 10 1636416000 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 Damien Blanes / Tony King 1636475505 Y 2021-12-17 17:37:27 0
100212 ENCBO004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636475439 0 Y N N B N R Y N N Y 10 1636416000 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 Matt Clarkson 1636476322 Y 2021-12-17 17:37:27 0
100213 ENCBO004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1636475596 0 Y N N B N R Y N N Y 10 1636416000 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 Olly Lennox 1636476342 Y 2021-12-17 17:37:27 0