SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62862, 62859, 64467, 62861, 62863, 64468, 
    64470, 62860, 64466, 65503, 65501, 
    65500, 65502
  )

Query time 0.00090

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 13,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (62862,62859,64467,62861,62863,64468,64470,62860,64466,65503,65501,65500,65502)"
    }
  }
}

Result

product_id product_code product_type trustmark_origin trustmark_certified trustmark_leadtime trustmark_location trustmark_return owner_id 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 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 updated_timestamp pricing_note use_new_layout category_image tax_code upc_code product_detail_ids nav_sku sku_columns nav_review_user_id hide_price vendor_fulfilled hide_commercial_price non_returnable ble_basics commercial_hidden allow_configurator enable_customize enable_buy_american base_cost redline_p
62859 BLE-C-SCH-LED P E C M A D 0 A 1 480.00 1000 0.000 0 0 0 0.00 0 1418878800 0 N N N D N P N N N Y 10 1418878800 N 0 0 0 0 13 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;} 1757952652 Price increased 5% from $438 to $460 - DC 6/1/21 Price increased 10% from $460 to $506 - DC 6/1/22 Price decreased from $506 to $410 - DC 11/3/22 Price increased from $410 to $480 - DC 2/24/23 Y none none 1581,1582,1583 BLE-C {"22806":3,"21954":4,"22797":9,"22796":9,"22794":9,"22795":9,"22798":10,"22675":12,"22644":13,"23170":11,"23169":11,"23861":4,"23862":4,"23863":4} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
62860 BLE-G-SCH-LED P E C M A D 0 A 1 515.00 1000 0.000 0 0 0 0.00 0 1418878800 0 N N N D N P N N N Y 10 1418878800 N 0 0 0 0 13 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;} 1765293559 Price increased by $68 - DC 2/18/20 Price increased 5% from $506 to $531 - DC 6/1/21 Price increased 10% from $531 to $585 - DC 6/2/22 Price decreased from $585 to $445 - DC 11/3/22 Price increased from $445 to $515 - DC 2/24/23 Y none none 1663,1664,1665,1666 BLE-G {"22791":3,"22797":9,"22796":9,"22795":9,"22794":9,"23173":11,"23172":11,"23171":11,"22675":12,"22644":13,"22798":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62861 BLE-S-SCH-LED P E C M A D 0 A 1 505.00 1000 0.000 0 0 0 0.00 0 1355979600 0 N N N D N P N N N Y 10 1355979600 N 0 0 0 0 13 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;} 1757952691 Price increased 5% from $475 to $499 - DC 6/2/21 Price increased 10% from $499 to $549 - DC 6/2/22 Price decreased from $549 to $435 - DC 11/3/22 Price increased from $435 to $505 - DC 2/24/23 Y none none 1667,1668,1669,1670 BLE-S {"22823":3,"22797":9,"22796":9,"22795":9,"22794":9,"23176":11,"23175":11,"23174":11,"22675":12,"22644":13,"22798":10} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
62862 BLE-FSF-SCH-LED P E C M A D 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1418878800 0 N N N D N P N N N Y 10 1418878800 N 0 0 0 0 13 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;} 1776715528 Price increased 5% from $462 to $485 - DC 6/1/21 Price increased 10% from $485 to $534 - DC 6/2/22 Price decreased from $534 to $425 - DC 11/3/22 Price increased from $425 to $495 - DC 2/24/23 Y none none 1586,1587,1588 BLE-FSF {"22806":3,"22797":9,"22796":9,"22794":9,"22795":9,"22798":10,"22675":12,"22644":13} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
62863 BLE-C-SCH-CN36-LED P E C M A D 0 A 1 545.00 1000 0.000 0 0 0 0.00 0 1418878800 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1757952737 Price increased 5% from $528 to $554 - DC 6/1/21 Price increased 10% from $554 to $610 - DC 6/2/22 Price decreased from $610 to $475 - DC 11/3/22 Price increased from $475 to $545 - DC 2/24/23 Y none none 1590,1591,1592 BLE-C {"21951":4,"22817":6,"21954":7,"22796":9,"22797":9,"22795":9,"22794":9,"22798":10,"22675":12,"22644":13,"23182":3} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64466 BLE-G-SCH-LED P E C M A D 0 A 1 750.00 1000 0.000 0 0 0 0.00 0 1524488490 0 N N N D N P N N N Y 10 1524456000 N 0 0 0 0 13 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;} 1757953108 Price increased by $68 - DC 2/18/20 Price increased 5% from $649 to $681 - DC 6/1/21 Price increased 10% from $681 to $750 - DC 6/2/22 Y none none 1671,1672,1673 BLE-G {"23179":3} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64467 BLE-C-STU-SCH-LED P E C M A D 0 A 1 750.00 1000 0.000 0 0 0 0.00 0 1524490339 0 N N N D N P N N N Y 10 1524456000 N 0 0 0 0 13 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;} 1757953108 Price increased 5% from $649 to $681 - DC 6/1/21 Price increased 10% from $681 to $750 - DC 6/1/22 Y none none 1680,1681,1682 BLE-C-STU {"23184":3,"21943":4,"22795":7} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64468 BLE-S-SCH-LED P E C M A D 0 A 1 765.00 1000 0.000 0 0 0 0.00 0 1524492009 0 N N N D N P N N N Y 10 1524456000 N 0 0 0 0 13 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;} 1757953108 Price increased 5% from $662 to $695 - DC 6/2/21 Price increased 10% from $695 to $765 - DC 6/2/22 Y none none 1674,1675,1676 BLE-S {"23181":3} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64470 BLE-C-SCH-LED P E C M A D 0 A 1 839.00 1000 0.000 0 0 0 0.00 0 1524493051 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1757953108 Price increased 5% from $726 to $762 - DC 6/1/21 Price increased 10% from $762 to $839 - DC 6/2/22 Y none none 1677,1678,1679 BLE-CN-SCH {"23182":3,"21951":4,"21954":5} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65500 BLE-W-SCH10-LED P E C M A A 0 A 1 555.00 1000 0.000 0 0 0 0.00 0 1603725962 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1774379684 Price increased 5% from $532 to $559 - DC 6/1/21 Price increased 10% from $559 to $615 - DC 6/2/22 Price decreased from $615 to $485 - DC 11/3/22 Price increased from $485 to $555 - DC 2/24/23 Y none none 3331,3332,3333 BLE-W {"22788":1,"22818":2,"22797":3,"22796":3,"22794":3,"22795":3,"22798":4,"22819":5,"22820":6,"21941":7,"22675":5,"22644":6} 1051256 0 0 0 1 0 0 0 0 1 0.00 0
65501 BLE-W-ACN-LED P E C M A A 0 A 1 525.00 1000 0.000 0 0 0 0.00 0 1603730033 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1753110785 Price increased 5% from $565 to $593 - DC 6/1/21 Price increased 10% from $593 to $653 - DC 6/2/22 Price increased from $653 to $525 - DC 11/3/22 Y none none 3334,3335,3336 BLE-W {"22788":1,"22818":2,"22797":3,"22796":3,"22794":3,"22795":3,"22798":4,"22819":5,"22820":6,"21941":7,"22925":1,"22927":3,"22928":3,"22675":5,"22644":6} 1051256 0 0 0 1 0 0 0 0 1 0.00 0
65502 BLE-W-DRM-LED P E C M A A 0 A 1 520.00 1000 0.000 0 0 0 0.00 0 1603733309 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1753110803 Price increased 5% from $558 to $586 - DC 6/1/21 Price increased 10% from $586 to $645 - DC 6/2/22 Price increased from $645 to $520 - DC 11/3/22 Y none none 3337,3338,3339 BLE-W {"22788":1,"22818":2,"22797":3,"22796":3,"22794":3,"22795":3,"22798":4,"22819":5,"22820":6,"21941":7,"22925":1,"22927":3,"22928":3,"22929":1,"22931":3,"22932":3,"22675":5,"22644":6} 1051256 0 0 0 1 0 0 0 0 1 0.00 0
65503 BLE-W-RND-LED P E C M A A 0 A 1 515.00 1000 0.000 0 0 0 0.00 0 1603735826 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1753110843 Price increased 5% from $545 to $572 - DC 6/1/21 Price increased 10% from $572 to $630 - DC 6/2/22 Price decreased from $630 to $515 - DC 11/3/22 Y none none 3340,3341,3342 BLE-W {"22788":1,"22818":2,"22797":3,"22796":3,"22794":3,"22795":3,"22798":4,"22819":5,"22820":6,"21941":7,"22925":1,"22927":3,"22928":3,"22921":1,"22923":3,"22924":3,"22675":5,"22644":6} 1051256 0 0 0 1 0 0 0 0 1 0.00 0