SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    102019, 102018, 102017, 102016, 102015, 
    102014, 102013, 102012, 102011, 102010, 
    102009, 102008, 102007, 102006, 102005, 
    102004, 102003, 102002, 102031, 102030
  )

Query time 0.00049

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
102002 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 GBKQU2209425 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130603 Y 2022-01-25 18:10:03 0
102003 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 GBKQU2209426 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130603 Y 2022-01-25 18:10:03 0
102004 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 GBKQU2209427 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130604 Y 2022-01-25 18:10:04 0
102005 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 GBKQU2209428 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130604 Y 2022-01-25 18:10:04 0
102006 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 GBKQU2209429 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130604 Y 2022-01-25 18:10:04 0
102007 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 GBKQU2209430 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130605 Y 2022-01-25 18:10:05 0
102008 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 GBKQU2209431 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130605 Y 2022-01-25 18:10:05 0
102009 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 GBKQU2209432 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130605 Y 2022-01-25 18:10:05 0
102010 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 GBKQU2209433 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130605 Y 2022-01-25 18:10:05 0
102011 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 GBKQU2209434 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130605 Y 2022-01-25 18:10:05 0
102012 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 GBKQU2209435 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130606 Y 2022-01-25 18:10:06 0
102013 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 GBKQU2209436 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130606 Y 2022-01-25 18:10:06 0
102014 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 GBKQU2209437 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130606 Y 2022-01-25 18:10:06 0
102015 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 GBKQU2209438 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130606 Y 2022-01-25 18:10:06 0
102016 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 GBKQU2209439 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130607 Y 2022-01-25 18:10:07 0
102017 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 GBKQU2209440 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130607 Y 2022-01-25 18:10:07 0
102018 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 GBKQU2209441 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130607 Y 2022-01-25 18:10:07 0
102019 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 GBKQU2209442 N 102024 Jose Francisco Sendra Medina Jose Francisco Sendra Medina 1643130607 Y 2022-01-25 18:10:07 0
102030 CR227 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 5054286441069 GBKQU2209774 N Contagious Records William & Kinnair & Richard Bridgeman 1643130613 Y 2022-01-25 18:10:13 0
102031 CR227 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 5054286441069 GBKQU2209775 N Contagious Records William & Kinnair & Richard Bridgeman 1643130613 Y 2022-01-25 18:10:13 0