SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    106778, 106777, 106776, 106775, 106774, 
    106313, 106760, 106759, 106369, 106368, 
    106273, 106271, 106270, 106269, 106260, 
    106243, 106242, 106241, 106240, 106239
  )

Query time 0.00039

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
106239 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBLV61816080 N 106244 Black Reverb Various Artists 1649138419 Y 2022-04-05 07:00:19 0
106240 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBKQU2059722 N 106244 Black Reverb Various Artists 1649138420 Y 2022-04-05 07:00:20 0
106241 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBKQU2045154 N 106244 Black Reverb Various Artists 1649138420 Y 2022-04-05 07:00:20 0
106242 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBKQU2071297 N 106244 Black Reverb Various Artists 1649138420 Y 2022-04-05 07:00:20 0
106243 BRR194 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651705200 0 Y N N B N R Y N N Y 10 1651705200 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 5054286549147 GBKQU1894580 N 106244 Black Reverb Various Artists 1649138420 Y 2022-04-05 07:00:20 0
106260 TWORC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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;} labelworx 5054286572329 GBKQU2232382 N Tidy Publishing Scott Attrill 1651821276 Y 2022-04-06 06:15:02 0
106269 DD004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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;} labelworx 5054286592075 GBKQU2235344 N Digital Dragon Jay G & Arnie 1651821293 Y 2022-04-06 07:15:07 0
106270 ONESEVENTY129 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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;} labelworx 5054286564911 GBKQU2231149 N Copyright Control Daniel Candy 1651821310 Y 2022-04-06 07:30:02 0
106271 ONESEVENTY129 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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 5054286564911 GBKQU2231150 N Copyright Control Daniel Candy 1649226603 Y 2022-04-06 07:30:03 0
106273 VDH052 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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 5054286559160 GBKQU2230383 N Various Digital Hardcore Infinite, Rikston 1649226605 Y 2022-04-06 07:30:05 0
106313 STI296 P A 1 1.69 1 0.000 0 0 0 0.00 0 1652050800 0 Y N N B N R Y N N Y 10 1652050800 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 5054286547389 GBKQU2228676 N Copyright Control R. Gallagher 1649481302 Y 2022-04-09 06:15:02 0
106368 247HC270 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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;} labelworx 5054286612162 UKT6B2200249 N Copyright Control L.Jungkeit 1651821325 Y 2022-04-12 19:00:03 0
106369 247HC270 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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 5054286612162 UKT6B2200248 N Copyright Control L.Jungkeit 1649786403 Y 2022-04-12 19:00:03 0
106759 XTR046 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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 5054286657040 GBKQU2245762 N Tygo Ouwerkerk, Andriy Ursaki, Emanuele Agostinetto, Mattia Pasini Tygo Ouwerkerk, Mattia Pasini 1651773601 Y 2022-05-05 19:00:01 0
106760 XTR046 P A 1 1.69 1 0.000 0 0 0 0.00 0 1651791600 0 Y N N B N R Y N N Y 10 1651791600 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 5054286657040 GBKQU2245763 N Tygo Ouwerkerk, Andriy Ursaki, Emanuele Agostinetto, Mattia Pasini Tygo Ouwerkerk, Mattia Pasini 1651773603 Y 2022-05-05 19:00:03 0
106774 LWHTS01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1652050800 0 Y N N B N R Y N N Y 10 1652050800 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 5054286659662 GBLV62135401 N 106789 Copyright Control Various Artists 1651857304 Y 2022-05-06 18:15:04 0
106775 LWHTS01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1652050800 0 Y N N B N R Y N N Y 10 1652050800 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 5054286659662 GBLV62114238 N 106789 Copyright Control Various Artists 1651857306 Y 2022-05-06 18:15:06 0
106776 LWHTS01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1652050800 0 Y N N B N R Y N N Y 10 1652050800 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 5054286659662 GBLV62136839 N 106789 Copyright Control Various Artists 1651857307 Y 2022-05-06 18:15:07 0
106777 LWHTS01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1652050800 0 Y N N B N R Y N N Y 10 1652050800 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 5054286659662 GBLV62133706 N 106789 Copyright Control Various Artists 1651857309 Y 2022-05-06 18:15:09 0
106778 LWHTS01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1652050800 0 Y N N B N R Y N N Y 10 1652050800 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 5054286659662 GBKQU2200999 N 106789 Copyright Control Various Artists 1651857309 Y 2022-05-06 18:15:09 0