SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111613, 111612, 110723, 111844, 111901, 
    111557, 111556, 110718, 110713, 110712, 
    110711, 124915, 111871, 110687, 110686, 
    110620, 110617, 110651, 112015, 111664
  )

Query time 0.00032

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
110617 KKV023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669939200 0 Y N N B N R Y N N Y 10 1669939200 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 5054286996859 GBKQU2298245 N Copyright Control Markus Peer 1667367902 Y 2022-11-02 06:45:02 0
110620 A4T202214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669939200 0 Y N N B N R Y N N Y 10 1669939200 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 5054287009039 GBLV62200093 N Copyright Control David Lowther 1667369702 Y 2022-11-02 07:15:02 0
110651 SPOON249B P A 1 1.69 1 0.000 0 0 0 0.00 0 1669852800 0 Y N N B N R Y N N Y 10 1669852800 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 5054287015085 NL4AW2224903 N Copyright Control Mitchell de Jonge, Tim Udo, Philipp Pohl 1667410202 Y 2022-11-02 18:30:02 0
110686 KKR169 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669939200 0 Y N N B N R Y N N Y 10 1669939200 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 5054287016754 GBLV62201279 N Copyright Control Ryan Benjamins 1667495716 Y 2022-11-03 18:15:16 0
110687 KKR169 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669939200 0 Y N N B N R Y N N Y 10 1669939200 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 5054287016754 GBLV62201280 N Copyright Control Ryan Benjamins 1667495717 Y 2022-11-03 18:15:17 0
110711 KKR170 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054286997085 GBKQU2298271 N Copyright Control Kasper Funder 1667625362 Y 2022-11-05 06:16:02 0
110712 KKR170 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054286997085 GBKQU2298272 N Copyright Control Kasper Funder 1667625363 Y 2022-11-05 06:16:03 0
110713 KKR171 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054286997092 GBKQU2298273 N Copyright Control Pedro Wittevrongel 1667625363 Y 2022-11-05 06:16:03 0
110718 FE462 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054287008599 GBLV62200053 N Fatal Energy Records Joseph Rooney 1667627108 Y 2022-11-05 06:45:08 0
110723 STI337 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287011636 GBLV62200518 N Copyright Control G.jones, M, Pipper 1667798101 Y 2022-11-07 06:15:01 0
111556 KKR174 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054287018239 GBLV62201469 N Copyright Control Julian de Vries 1668057301 Y 2022-11-10 06:15:01 0
111557 KKR174 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054287018239 GBLV62201470 N Copyright Control Julian de Vries 1668057303 Y 2022-11-10 06:15:03 0
111612 KKRC003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287032532 ATR981234375 N 111635 Copyright Control Various 1668100515 Y 2022-11-10 18:15:15 0
111613 KKRC003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287032532 ATR981234609 N 111635 Copyright Control Various 1668100516 Y 2022-11-10 18:15:16 0
111664 KKRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 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 5054287032501 ATR981232184 N 111665 Copyright Control Various 1668100532 Y 2022-11-10 18:15:32 0
111844 UPR220 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670284800 0 Y N N B N R Y N N Y 10 1670284800 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 5054287045600 NL3TA2209701 N Copyright Control Lachlan Monahan 1668619803 Y 2022-11-16 18:30:03 0
111871 UPR219 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669939200 0 Y N N B N R Y N N Y 10 1669939200 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 5054287047918 NL3TA2209601 N Copyright Control Rick Bultman 1668705302 Y 2022-11-17 18:15:02 0
111901 MQDRHRD009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054287053056 GBLV62206796 N +QDance Records David Almarcha, Guillermo Tormo 1669050901 Y 2022-11-21 18:15:01 0
112015 CNN016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669766400 0 Y N N B N R Y N N Y 10 1669766400 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 5054287063444 GBLV62208447 N Copyright Control Giovanni Schuijers, Maarten van Hout 1669396501 Y 2022-11-25 18:15:01 0
124915 ABC006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1669939200 0 Y N N B N R Y N N Y 10 1669939200 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 5059801084660 GBLLT2254908 N TRI poloski RECORDS Yuri Verlind 1717115589 Y 2024-05-31 01:20:02 0