SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    110277, 110260, 110259, 110253, 111636, 
    110353, 110352, 110347, 110225, 110224, 
    110355, 110192, 110188, 110187, 110344, 
    110321, 110251, 110134, 110128, 110127
  )

Query time 0.00037

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
110127 PTR219 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667520000 0 Y N N B N R Y N N Y 10 1667520000 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 5054286828549 GBKQU2272108 N Power Tracks Records Isaac Sanchez & Jaime Guerrero 1664948703 Y 2022-10-05 06:45:03 0
110128 PTR219 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667520000 0 Y N N B N R Y N N Y 10 1667520000 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 5054286828549 GBKQU2272109 N Power Tracks Records Isaac Sanchez & Jaime Guerrero 1664948704 Y 2022-10-05 06:45:04 0
110134 KKV017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667520000 0 Y N N B N R Y N N Y 10 1667520000 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 5054286951346 GBKQU2291309 N Copyright Control Giovanni Hernandez 1664948713 Y 2022-10-05 06:45:13 0
110187 KKE023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667779200 0 Y N N B N R Y N N Y 10 1667779200 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 5054286943891 GBKQU2290230 N Copyright Control Justin Jay Battermann 1665207913 Y 2022-10-08 06:45:13 0
110188 KKE023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667779200 0 Y N N B N R Y N N Y 10 1667779200 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 5054286943891 GBKQU2290231 N Copyright Control Justin Jay Battermann 1665207914 Y 2022-10-08 06:45:14 0
110192 KKV018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667779200 0 Y N N B N R Y N N Y 10 1667779200 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 5054286951377 GBKQU2291313 N Copyright Control Paul Lattermann 1665208802 Y 2022-10-08 07:00:02 0
110224 KKR157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667952000 0 Y N N B N R Y N N Y 10 1667952000 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 5054286942191 GBKQU2289946 N Copyright Control Joel Bertell 1665378920 Y 2022-10-10 06:15:20 0
110225 KKR157 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667952000 0 Y N N B N R Y N N Y 10 1667952000 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 5054286942191 GBKQU2289947 N Copyright Control Joel Bertell 1665378921 Y 2022-10-10 06:15:21 0
110251 A4T202212 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667520000 0 Y N N B N R Y N N Y 10 1667520000 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 5054286971085 GBKQU2294168 N Copyright Control Oriol Botam 1665553502 Y 2022-10-12 06:45:02 0
110253 HMR111 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286963424 SKC832211101 N Hard Music Records Michael Ban 1665554401 Y 2022-10-12 07:00:01 0
110259 NUTTY094b P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286857297 UK9E92200310 N Nutty Traxx Bart Sloot 1665554427 Y 2022-10-12 07:00:27 0
110260 NUTTY094b P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286857297 UK9E92200313 N Nutty Traxx Bart Sloot 1665554427 Y 2022-10-12 07:00:27 0
110277 MQDRHRD008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668124800 0 Y N N B N R Y N N Y 10 1668124800 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 5054286948797 GBKQU2290981 N +QDance Records David Almarcha Fernandez 1665554452 Y 2022-10-12 07:00:52 0
110321 AWK016E P A 1 1.69 1 0.000 0 0 0 0.00 0 1667520000 0 Y N N B N R Y N N Y 10 1667520000 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 5054286976042 GBKQU2295112 N Akkros Records Sten Boogaard 1665767706 Y 2022-10-14 18:15:06 0
110344 UPR211 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667520000 0 Y N N B N R Y N N Y 10 1667520000 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 5054286983644 NL3TA2208801 N Copyright Control Tiede van der Steege 1666026919 Y 2022-10-17 18:15:19 0
110347 KKR158 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667952000 0 Y N N B N R Y N N Y 10 1667952000 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 5054286986096 GBKQU2296647 N Copyright Control Silvan Thieme 1666113326 Y 2022-10-18 18:15:26 0
110352 KKV019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667952000 0 Y N N B N R Y N N Y 10 1667952000 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 5054286986034 GBKQU2296642 N Copyright Control Mickael Vermeiren 1666113328 Y 2022-10-18 18:15:28 0
110353 KKV019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667952000 0 Y N N B N R Y N N Y 10 1667952000 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 5054286986034 GBKQU2296643 N Copyright Control Mickael Vermeiren 1666113328 Y 2022-10-18 18:15:28 0
110355 KKR156T P A 1 1.69 1 0.000 0 0 0 0.00 0 1667779200 0 Y N N B N R Y N N Y 10 1667779200 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 5054286984122 GBKQU2296358 N Copyright Control Julian de Vries 1666113329 Y 2022-10-18 18:15:29 0
111636 INFEXRAW007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668100521 0 Y N N B N R Y N N Y 10 1668038400 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 5054286993216 GBKQU2297650 N Copyright Control Andrew Currie, Liam Ballantyne 1668102049 Y 2022-11-10 18:15:21 0