SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    121576, 121575, 121574, 121573, 121572, 
    121571, 121570, 104342, 102330, 102329, 
    102328, 102327, 102326, 102325, 102324, 
    102323, 102322, 102321, 102320, 102319
  )

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
102319 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBLV62102757 N 102331 Copyright Control Various Artists 1644469506 Y 2022-02-10 06:05:06 0
102320 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBLV62108249 N 102331 Copyright Control Various Artists 1644469506 Y 2022-02-10 06:05:06 0
102321 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 BR1BO2100102 N 102331 Copyright Control Various Artists 1644469506 Y 2022-02-10 06:05:06 0
102322 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBKQU2194828 N 102331 Copyright Control Various Artists 1644469506 Y 2022-02-10 06:05:06 0
102323 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBLV62101269 N 102331 Copyright Control Various Artists 1644469507 Y 2022-02-10 06:05:07 0
102324 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBKQU2190515 N 102331 Copyright Control Various Artists 1644469507 Y 2022-02-10 06:05:07 0
102325 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 QZ4WR1600438 N 102331 Copyright Control Various Artists 1644469507 Y 2022-02-10 06:05:07 0
102326 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBLV62103759 N 102331 Copyright Control Various Artists 1644469508 Y 2022-02-10 06:05:08 0
102327 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 ITHZ02100760 N 102331 Copyright Control Various Artists 1644469508 Y 2022-02-10 06:05:08 0
102328 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBKQU2191926 N 102331 Copyright Control Various Artists 1644469508 Y 2022-02-10 06:05:08 0
102329 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBLV62115735 N 102331 Copyright Control Various Artists 1644469509 Y 2022-02-10 06:05:09 0
102330 LWDNCD05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286477730 GBLV62100600 N 102331 Copyright Control Various Artists 1644469509 Y 2022-02-10 06:05:09 0
104342 WAOD074 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054286489504 GBKQU2218282 N Copyright Control R.Scott 1644945002 Y 2022-02-15 18:10:02 0
121570 LWDNCD05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054287860678 UK2X22100181 N Copyright Control Various Artists 1705899903 Y 2024-01-22 06:05:03 0
121571 LWDNCD05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054287860678 GBLV62117096 N Copyright Control Various Artists 1705900901 Y 2024-01-22 06:21:42 0
121572 LWDNCD05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054287860678 QZNWS2169359 N Copyright Control Various Artists 1705902313 Y 2024-01-22 06:30:05 0
121573 LWDNCD05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054287860678 UKG4K2100022 N Copyright Control Various Artists 1705902322 Y 2024-01-22 06:30:22 0
121574 LWDNCD05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054287860678 GBLV62117134 N Copyright Control Various Artists 1705902336 Y 2024-01-22 06:30:34 0
121575 LWDNCD05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054287860678 GBLV62104225 N Copyright Control Various Artists 1705902348 Y 2024-01-22 06:30:37 0
121576 LWDNCD05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1645401600 0 Y N N B N R Y N N Y 10 1645401600 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 5054287860678 GBLV62102757 N Copyright Control Various Artists 1705902365 Y 2024-01-22 06:30:56 0