SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    110125, 110123, 110441, 110065, 110387, 
    110143, 110062, 110060, 110058, 110057, 
    110056, 110055, 110157, 110118, 110030, 
    110029, 109951, 109950, 109948, 109947
  )

Query time 0.00048

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
109947 FE457 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286933038 GBKQU2288595 N Fatal Energy Records Leigh Diction, Aaron Williams 1664343002 Y 2022-09-28 06:30:02 0
109948 KKE021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286943860 GBKQU2290228 N Copyright Control Medvedev Artem Alexandrovich, Asker Mashukov Timurovich 1664343003 Y 2022-09-28 06:30:03 0
109950 KKR152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286942085 GBKQU2289930 N Copyright Control Justin Jay Battermann 1664344810 Y 2022-09-28 07:00:10 0
109951 KKR152 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286942085 GBKQU2289931 N Copyright Control Justin Jay Battermann 1664344811 Y 2022-09-28 07:00:11 0
110029 KKV016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286947530 GBKQU2290793 N Copyright Control Ivan Perez 1664471708 Y 2022-09-29 18:15:08 0
110030 KKV016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286947530 GBKQU2290794 N Copyright Control Ivan Perez 1664471708 Y 2022-09-29 18:15:08 0
110055 KKR155 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667174400 0 Y N N B N R Y N N Y 10 1667174400 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 5054286942122 GBKQU2289936 N Copyright Control Ryan Benjamins 1664602205 Y 2022-10-01 06:30:05 0
110056 KKR155 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667174400 0 Y N N B N R Y N N Y 10 1667174400 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 5054286942122 GBKQU2289937 N Copyright Control Ryan Benjamins 1664602208 Y 2022-10-01 06:30:08 0
110057 KKR153 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667174400 0 Y N N B N R Y N N Y 10 1667174400 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 5054286942108 GBKQU2289934 N Copyright Control Takuma Hitomi 1664603102 Y 2022-10-01 06:45:02 0
110058 FE458 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667174400 0 Y N N B N R Y N N Y 10 1667174400 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 5054286933045 GBKQU2288596 N Fatal Energy Records Leigh Diction, Luke Howells 1664604902 Y 2022-10-01 07:15:02 0
110060 KKRHS2022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667174400 0 Y N N B N R Y N N Y 10 1667174400 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 5054286894988 GBKQU2282626 N Copyright Control Tom Schadow 1664604904 Y 2022-10-01 07:15:04 0
110062 BBD099 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667260800 0 Y N N B N R Y N N Y 10 1667260800 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 5054286933342 GBKQU2288668 N We Distribute Nils Weinandy 1664688602 Y 2022-10-02 06:30:02 0
110065 FE459 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667347200 0 Y N N B N R Y N N Y 10 1667347200 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 5054286933076 GBKQU2288599 N Fatal Energy Records Leigh Diction, Curtis Perkins, Sam Lee 1664774106 Y 2022-10-03 06:15:06 0
110118 RAR084 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286958772 QZJRB2205816 N Rapture Recordings Paul Pollard, Steve Haddy 1664946966 Y 2022-10-05 06:16:06 0
110123 KKR154 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 5054286942115 GBKQU2289935 N Copyright Control Reno Adhiyoso 1664946971 Y 2022-10-05 06:16:11 0
110125 KKE022 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 5054286943877 GBKQU2290229 N Copyright Control Gabriel Da Silva Oliveira 1664947803 Y 2022-10-05 06:30:03 0
110143 Ycore48 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667260800 0 Y N N B N R Y N N Y 10 1667260800 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 5054286957324 GBKQU2292181 N Copyright Control D Deakin 1664991004 Y 2022-10-05 18:30:04 0
110157 HARSH201 P A 1 1.69 1 0.000 0 0 0 0.00 0 1666911600 0 Y N N B N R Y N N Y 10 1666911600 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 5054286961550 GBKQU2292844 N Harsh Records Adrian Alcocer Marques, Daniel Fernandez, Luis Enrique Montero Estrada 1665162906 Y 2022-10-07 18:15:06 0
110387 UPR210 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667260800 0 Y N N B N R Y N N Y 10 1667260800 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 5054286987734 NL3TA2208701 N Copyright Control Nicolas Vilet 1666200601 Y 2022-10-19 18:30:01 0
110441 SPOON247 P A 1 1.69 1 0.000 0 0 0 0.00 0 1667433600 0 Y N N B N R Y N N Y 10 1667433600 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 5054286993285 NL4AW2224701 N Copyright Control Rowan de Jong, Silke Bosma 1666415702 Y 2022-10-22 06:15:02 0