SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    1335, 1338, 1233, 1324, 1323, 1081, 1326, 
    1325, 1333, 1082, 1321, 1330
  )

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.0216566,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_products",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "loops": 1,
          "rows": 12,
          "cost": 0.0216566,
          "filtered": 100,
          "attached_condition": "cscart_products.product_id in (1335,1338,1233,1324,1323,1081,1326,1325,1333,1082,1321,1330)"
        }
      }
    ]
  }
}

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_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 facebook_obj_type parent_product_id buy_now_url units_in_product show_price_per_x_units sg_locations trr_shop_id trr_is_parent trr_product_id trr_cost_price trr_product_type allow_gift_wrap allow_gift_wrap_modifier gift_modifier sg_hubspot_id sg_is_synced sg_solr_update_timestamp sg_review_analysis sg_seo_suggest sg_performance_suggest sg_is_gmc_synced sg_gmc_update_timestamp sg_zoho_id
1081 RP100P P A 1 0.00 10 0.000 0 0 0 0.00 0 1749647374 1749647374 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD4703 198.53 product Y N 0.00 143592262375 N 0 N N Y 1774591902
1082 RP150P P A 1 0.00 9 0.000 0 0 0 0.00 0 1749647380 1749647380 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD4704 328.81 product Y N 0.00 143592263393 N 0 N N Y 1774591902
1233 TIE DOWN EYELET P A 1 0.00 10 0.000 0 0 0 0.00 0 1749648729 1769581982 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD2109 28.95 product Y N 0.00 143592263360 N 0 Y N Y 1774591902
1321 ABP P A 1 0.00 10 0.000 0 0 0 0.00 0 1749705694 1751025697 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD4166 78.58 product Y N 0.00 143592262384 N 0 N N Y 1774591902
1323 AC100 P A 1 0.00 9 0.000 0 0 0 0.00 0 1749705718 1756212116 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD0345 750.68 product Y N 0.00 143592262381 N 0 N N Y 1774591902
1324 AC100NP P A 1 0.00 10 0.000 0 0 0 0.00 0 1749705731 1756202712 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD3242 539.75 product Y N 0.00 143592263356 N 0 N N Y 1774591902
1325 AC150 P A 1 0.00 10 0.000 0 0 0 0.00 0 1749705739 1749705739 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD0346 893.38 product Y N 0.00 143592262393 N 0 N N Y 1774591902
1326 AC150NP P A 1 0.00 9 0.000 0 0 0 0.00 0 1749705744 1749705744 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD3243 556.29 product Y N 0.00 143592263365 N 0 N N Y 1774591902
1330 AJSH P A 1 5556.00 14 0.000 0 0 0 0.00 0 1749705785 1769599475 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 {"AL":{"state":"AL","price":"35.00"},"AK":{"state":"AK","price":"35.00"},"AZ":{"state":"AZ","price":"35.00"},"AR":{"state":"AR","price":"35.00"},"CA":{"state":"CA","price":"35.00"},"CO":{"state":"CO","price":"35.00"},"CT":{"state":"CT","price":"35.00"},"DE":{"state":"DE","price":"35.00"},"DC":{"state":"DC","price":"35.00"},"FL":{"state":"FL","price":"35.00"},"GA":{"state":"GA","price":"35.00"},"GU":{"state":"GU","price":"35.00"},"HI":{"state":"HI","price":"35.00"},"ID":{"state":"ID","price":"35.00"},"IL":{"state":"IL","price":"35.00"},"IN":{"state":"IN","price":"35.00"},"IA":{"state":"IA","price":"35.00"},"KS":{"state":"KS","price":"35.00"},"KY":{"state":"KY","price":"35.00"},"LA":{"state":"LA","price":"35.00"},"ME":{"state":"ME","price":"35.00"},"MD":{"state":"MD","price":"35.00"},"MA":{"state":"MA","price":"35.00"},"MI":{"state":"MI","price":"35.00"},"MN":{"state":"MN","price":"35.00"},"MS":{"state":"MS","price":"35.00"},"MO":{"state":"MO","price":"35.00"},"MT":{"state":"MT","price":"35.00"},"NE":{"state":"NE","price":"35.00"},"NV":{"state":"NV","price":"35.00"},"NH":{"state":"NH","price":"35.00"},"NJ":{"state":"NJ","price":"35.00"},"NM":{"state":"NM","price":"35.00"},"NY":{"state":"NY","price":"35.00"},"NC":{"state":"NC","price":"35.00"},"ND":{"state":"ND","price":"35.00"},"MP":{"state":"MP","price":"35.00"},"OH":{"state":"OH","price":"35.00"},"OK":{"state":"OK","price":"35.00"},"OR":{"state":"OR","price":"35.00"},"PA":{"state":"PA","price":"35.00"},"PR":{"state":"PR","price":"35.00"},"RI":{"state":"RI","price":"35.00"},"SC":{"state":"SC","price":"35.00"},"SD":{"state":"SD","price":"35.00"},"TN":{"state":"TN","price":"35.00"},"TX":{"state":"TX","price":"35.00"},"UT":{"state":"UT","price":"35.00"},"VT":{"state":"VT","price":"35.00"},"VI":{"state":"VI","price":"35.00"},"VA":{"state":"VA","price":"35.00"},"WA":{"state":"WA","price":"35.00"},"WV":{"state":"WV","price":"35.00"},"WI":{"state":"WI","price":"35.00"},"WY":{"state":"WY","price":"35.00"}} 1 Y PD0349 148.90 product Y N 0.00 143592262391 N 0 N N Y 1774591902
1333 ALEC150 P A 1 0.00 9 0.000 0 0 0 0.00 0 1749705815 1749705815 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD0786 146.83 product Y N 0.00 143592263395 N 0 N N Y 1774591902
1335 ARD P A 1 0.00 0 0.000 0 0 0 0.00 0 1749705839 1756290142 0 N N N B N N N N Y 10 0 N N 0 default a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:500;s:9:"box_width";i:100;s:10:"box_height";i:200;} 0 0.000 1.000 1 Y PD0659 397.06 product Y N 0.00 143592262390 N 0 N N N 0
1338 ARS P A 1 0.00 10 0.000 0 0 0 0.00 0 1749705862 1749705862 0 N N N B N N N N Y 10 0 N N 0 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;} 0 0.000 1.000 1 Y PD0675 270.91 product Y N 0.00 143592262371 N 0 N N Y 1774591902