SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    102379, 102378, 102377, 102376, 102375, 
    102374, 102373, 102372, 102371, 102370, 
    102369, 102348, 102346, 102345, 102344, 
    102343, 102342, 102341, 102340, 102339
  )

Query time 0.00043

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
102339 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBLV62029550 N 102349 Copyright Control Various Artists 1644513422 Y 2022-02-10 18:10:04 0
102340 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBKQU2119639 N 102349 Copyright Control Various Artists 1644513445 Y 2022-02-10 18:10:05 0
102341 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBLV62031407 N 102349 Copyright Control Various Artists 1644513469 Y 2022-02-10 18:10:05 0
102342 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBKQU2215074 N 102349 Copyright Control Various Artists 1644513491 Y 2022-02-10 18:10:05 0
102343 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBKQU2105142 N 102349 Copyright Control Various Artists 1644513514 Y 2022-02-10 18:10:06 0
102344 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBKQU2105144 N 102349 Copyright Control Various Artists 1644513535 Y 2022-02-10 18:10:06 0
102345 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBKQU2105352 N 102349 Copyright Control Various Artists 1644513554 Y 2022-02-10 18:10:06 0
102346 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBLV62103415 N 102349 Copyright Control Various Artists 1644513576 Y 2022-02-10 18:10:06 0
102348 TIDYCTA001DB P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473862 GBKQU2178222 N 102349 Copyright Control Various Artists 1644513616 Y 2022-02-10 18:10:07 0
102369 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBLV62022659 N 102384 Copyright Control Various Artists 1644514011 Y 2022-02-10 18:10:36 0
102370 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBLV62031476 N 102384 Copyright Control Various Artists 1644514038 Y 2022-02-10 18:10:36 0
102371 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBLV62031408 N 102384 Copyright Control Various Artists 1644514061 Y 2022-02-10 18:10:36 0
102372 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2092113 N 102384 Copyright Control Various Artists 1644514082 Y 2022-02-10 18:10:36 0
102373 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2107387 N 102384 Copyright Control Various Artists 1644514106 Y 2022-02-10 18:10:36 0
102374 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2105114 N 102384 Copyright Control Various Artists 1644514130 Y 2022-02-10 18:10:37 0
102375 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2105350 N 102384 Copyright Control Various Artists 1644514151 Y 2022-02-10 18:10:37 0
102376 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2105351 N 102384 Copyright Control Various Artists 1644514171 Y 2022-02-10 18:10:37 0
102377 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2136293 N 102384 Copyright Control Various Artists 1644514194 Y 2022-02-10 18:10:38 0
102378 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2105143 N 102384 Copyright Control Various Artists 1644514216 Y 2022-02-10 18:10:38 0
102379 TIDYCTA001DA P A 1 1.69 1 0.000 0 0 0 0.00 0 1608854400 0 Y N N B N R Y N N Y 10 1608854400 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 5054286473848 GBKQU2107383 N 102384 Copyright Control Various Artists 1644514240 Y 2022-02-10 18:10:38 0