SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    104602, 104601, 102467, 102466, 102192, 
    102058, 102039, 102037, 102035, 102034, 
    104446, 102187, 102001, 101996, 101995, 
    102025, 102023, 102022, 102021, 102020
  )

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
101995 MOK249 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645660800 0 Y N N B N R Y N N Y 10 1645660800 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 5054286430971 NLLB82200010 N Copyright Control S.D.Nielssen 1643087105 Y 2022-01-25 06:05:05 0
101996 MOK249 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645660800 0 Y N N B N R Y N N Y 10 1645660800 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 5054286430971 NLLB82200011 N Copyright Control S.D.Nielssen 1643087105 Y 2022-01-25 06:05:05 0
102001 DARKULLP004t12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645660800 0 Y N N B N R Y N N Y 10 1645660800 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 5054286430919 GBKQU2208298 N Copyright Control Paula Vigara Vives, Mathias Touchard 1643087703 Y 2022-01-25 06:15:03 0
102020 MMT022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645488000 0 Y N N B N R Y N N Y 10 1645488000 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 5054286438526 GBKQU2209443 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130607 Y 2022-01-25 18:10:07 0
102021 MMT022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645488000 0 Y N N B N R Y N N Y 10 1645488000 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 5054286438526 GBKQU2209444 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130608 Y 2022-01-25 18:10:08 0
102022 MMT022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645488000 0 Y N N B N R Y N N Y 10 1645488000 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 5054286438526 GBKQU2209445 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130608 Y 2022-01-25 18:10:08 0
102023 MMT022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645488000 0 Y N N B N R Y N N Y 10 1645488000 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 5054286438526 GBKQU2209446 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130609 Y 2022-01-25 18:10:09 0
102025 NTWO009D P A 1 1.69 1 0.000 0 0 0 0.00 0 1645574400 0 Y N N B N R Y N N Y 10 1645574400 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 5054286440819 GBLV62131498 N Mcps Copyright Control Scott Attrill 1645803458 Y 2022-01-25 18:10:10 0
102034 ONESEVENTY124 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286430384 GBKQU2208179 N Copyright Control Martin Koehler 1645803475 Y 2022-01-26 06:05:03 0
102035 ONESEVENTY124 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286430384 GBKQU2208180 N Copyright Control Martin Koehler 1643173503 Y 2022-01-26 06:05:03 0
102037 DD003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286432760 GBKQU2208577 N Digital Dragon Jay G & Kinn 1643174102 Y 2022-01-26 06:15:02 0
102039 PANDA022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286425632 UKT6B2200134 N Copyright Control M-Project 1645803491 Y 2022-01-26 06:20:02 0
102058 XPN006E P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286446002 GBKQU2210454 N XPN Music Valentin Troha & Tony Horne 1643303106 Y 2022-01-27 18:05:06 0
102187 CRY012D P A 1 1.69 1 0.000 0 0 0 0.00 0 1645660800 0 Y N N B N R Y N N Y 10 1645660800 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 5054286460695 NL5KC2100029 N Copyright Control Douwe Holwerda, Roy Verberne 1643908801 Y 2022-02-03 18:20:01 0
102192 XTR039 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286464013 GBKQU2213351 N Mattia Pasini, Andriy Ursaki, Emanuele Agostinetto Mattia Pasini 1643994301 Y 2022-02-04 18:05:01 0
102466 RID030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286479871 GBKQU2216472 N Copyright Control Lammert Brouwer 1644513143 Y 2022-02-10 18:12:23 0
102467 RID030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286479871 GBKQU2216473 N Copyright Control Lammert Brouwer 1644513143 Y 2022-02-10 18:12:23 0
104446 DNZF1189 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645660800 0 Y N N B N R Y N N Y 10 1645660800 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 5054286495789 GBKQU2219478 N DNZ Records SethroW, Miss B 1645118706 Y 2022-02-17 18:25:06 0
104601 BBR054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286509677 NLS202200040 N 2 Dex Publishing A. Duwa, Q. Thompson 1645722314 Y 2022-02-24 18:05:14 0
104602 BBR054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1645747200 0 Y N N B N R Y N N Y 10 1645747200 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 5054286509677 NLS202200041 N 2 Dex Publishing A. Duwa, Q. Thompson 1645722314 Y 2022-02-24 18:05:14 0