SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111794, 111793, 109129, 109032, 109031, 
    109011, 108892, 108891, 108790, 108632, 
    108618, 109040, 108675, 108674, 108610, 
    108901, 108900, 108884, 108883, 108554
  )

Query time 0.00036

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
108554 PUR064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661554800 0 Y N N B N R Y N N Y 10 1661554800 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;} labelworx 5054286798132 GBKQU2267367 N Pink Unicorn Records Aleksandr Pletnev 1658985301 Y 2022-07-28 06:15:01 0
108610 BBD094 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661814000 0 Y N N B N R Y N N Y 10 1661814000 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;} labelworx 5054286821229 GBKQU2270974 N We Distribute Alphachoice, Robin Clark 1659244501 Y 2022-07-31 06:15:01 0
108618 INFEXORI010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661986800 0 Y N N B N R Y N N Y 10 1661986800 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;} labelworx 5054286823315 GBKQU2271367 N Copyright Control Bart Sloot 1659417302 Y 2022-08-02 06:15:02 0
108632 A4T202208 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286834731 GBKQU2273117 N Copyright Control Laurent Kolic 1659503703 Y 2022-08-03 06:15:03 0
108674 UPR192 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661814000 0 Y N N B N R Y N N Y 10 1661814000 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;} labelworx 5054286840947 NL3TA2206601 N Copyright Control Samuele Lauretta, Alex Novara, Veronica Viglino 1659591001 Y 2022-08-04 06:30:01 0
108675 SPOON243 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661900400 0 Y N N B N R Y N N Y 10 1661900400 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;} labelworx 5054286837503 NL4AW2224301 N Copyright Control Mitchell de Jonge, Tim Udo 1659591005 Y 2022-08-04 06:30:05 0
108790 UPR193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286864165 NL3TA2206701 N Copyright Control Nicolas Vilet 1660671007 Y 2022-08-16 18:30:07 0
108883 KKR130 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661727600 0 Y N N B N R Y N N Y 10 1661727600 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;} labelworx 5054286840855 GBKQU2274078 N Copyright Control Carlos Alejandro Navarrete Aguirre 1661189422 Y 2022-08-22 18:30:22 0
108884 KKR130 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661727600 0 Y N N B N R Y N N Y 10 1661727600 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;} labelworx 5054286840855 GBKQU2274079 N Copyright Control Carlos Alejandro Navarrete Aguirre 1661189422 Y 2022-08-22 18:30:22 0
108891 KKR131 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286840862 GBKQU2274080 N Copyright Control Joppe Van Peel 1661189424 Y 2022-08-22 18:30:24 0
108892 KKR131 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286840862 GBKQU2274081 N Copyright Control Joppe Van Peel 1661189424 Y 2022-08-22 18:30:24 0
108900 KKE003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661727600 0 Y N N B N R Y N N Y 10 1661727600 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;} labelworx 5054286844440 GBKQU2274626 N Copyright Control Kumghato K Khala 1661190304 Y 2022-08-22 18:45:04 0
108901 KKE003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661727600 0 Y N N B N R Y N N Y 10 1661727600 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;} labelworx 5054286844440 GBKQU2274627 N Copyright Control Kumghato K Khala 1661190304 Y 2022-08-22 18:45:04 0
109011 KKE004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286844457 GBKQU2274628 N Copyright Control Olav Bosch 1661190365 Y 2022-08-22 18:46:05 0
109031 KKV003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286873099 GBKQU2279066 N Copyright Control Austin Silvas, Siddhant Dhoot 1661190373 Y 2022-08-22 18:46:13 0
109032 KKV003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286873099 GBKQU2279067 N Copyright Control Austin Silvas, Siddhant Dhoot 1661190373 Y 2022-08-22 18:46:13 0
109040 KKV002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1661900400 0 Y N N B N R Y N N Y 10 1661900400 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;} labelworx 5054286873082 GBKQU2279065 N Copyright Control Luis Ramos Espinoza, Aldair Garcia Flores 1661190377 Y 2022-08-22 18:46:17 0
109129 WRD017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286883203 GBKQU2280643 N Copyright Control Matteo Barberis 1661624102 Y 2022-08-27 19:15:02 0
111793 NUTTY094 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286810261 UK9E92200310 N Nutty Traxx Bart Sloot 1668579342 Y 2022-11-16 07:00:04 0
111794 NUTTY094 P A 1 1.69 1 0.000 0 0 0 0.00 0 1662073200 0 Y N N B N R Y N N Y 10 1662073200 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;} labelworx 5054286810261 UK9E92200313 N Nutty Traxx Bart Sloot 1668579352 Y 2022-11-16 07:00:04 0