SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    104248, 104288, 104287, 102289, 102288, 
    102287, 102286, 102285, 102284, 102283, 
    102282, 102278, 104481, 104480, 104479, 
    104478, 104477, 104476, 104475, 104474
  )

Query time 0.00036

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
102278 PANDA033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286425670 UKT6B2200159 N Copyright Control A.Taylor, R.Cox, G.May 1646987046 Y 2022-02-09 06:05:03 0
102282 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200066 N Copyright Control L.Garner 1646987065 Y 2022-02-09 06:05:05 0
102283 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200065 N Copyright Control L.Garner 1644383105 Y 2022-02-09 06:05:05 0
102284 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200069 N Copyright Control L.Garner 1644383106 Y 2022-02-09 06:05:06 0
102285 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200070 N Copyright Control L.Garner 1644383106 Y 2022-02-09 06:05:06 0
102286 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200071 N Copyright Control L.Garner 1644383108 Y 2022-02-09 06:05:08 0
102287 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200072 N Copyright Control L.Garner 1644383108 Y 2022-02-09 06:05:08 0
102288 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200073 N Copyright Control L.Garner 1644383108 Y 2022-02-09 06:05:08 0
102289 247HC256 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286415039 UKT6B2200074 N Copyright Control L.Garner 1644383109 Y 2022-02-09 06:05:09 0
104248 Hells058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1647129600 0 Y N N B N R Y N N Y 10 1647129600 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 5054286443735 GBKQU2210129 N copyright control J. Meier 1644555902 Y 2022-02-11 06:05:02 0
104287 ONESEVENTY125 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286484127 GBKQU2217273 N Copyright Control Shan Tambat 1646987080 Y 2022-02-13 06:05:03 0
104288 ONESEVENTY125 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646956800 0 Y N N B N R Y N N Y 10 1646956800 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 5054286484127 GBKQU2217274 N Copyright Control Shan Tambat 1644728704 Y 2022-02-13 06:05:04 0
104474 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU1862654 N 104482 Copyright Control Various Artists 1645247113 Y 2022-02-19 06:05:13 0
104475 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBLV61923906 N 104482 Copyright Control Various Artists 1645247113 Y 2022-02-19 06:05:13 0
104476 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU1989782 N 104482 Copyright Control Various Artists 1645247113 Y 2022-02-19 06:05:13 0
104477 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU1765187 N 104482 Copyright Control Various Artists 1645247113 Y 2022-02-19 06:05:13 0
104478 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2115535 N 104482 Copyright Control Various Artists 1645247114 Y 2022-02-19 06:05:14 0
104479 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU1885667 N 104482 Copyright Control Various Artists 1645247114 Y 2022-02-19 06:05:14 0
104480 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBLV62025984 N 104482 Copyright Control Various Artists 1645247115 Y 2022-02-19 06:05:15 0
104481 MOUTHLP006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1646870400 0 Y N N B N R Y N N Y 10 1646870400 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 5054286489047 GBKQU2171780 N 104482 Copyright Control Various Artists 1645247116 Y 2022-02-19 06:05:16 0