SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.short_description, 
  cscart_product_descriptions.full_description, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.page_title, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (277101, 243684, 277987) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00048

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "6.61"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 3,
      "rows_produced_per_join": 3,
      "filtered": "100.00",
      "index_condition": "((`s2cart`.`cscart_product_descriptions`.`product_id` in (277101,243684,277987)) and (`s2cart`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "6.31",
        "eval_cost": "0.30",
        "prefix_cost": "6.61",
        "data_read_per_join": "22K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description",
        "meta_keywords",
        "meta_description",
        "search_words",
        "page_title",
        "promo_text"
      ]
    }
  }
}

Result

product_id search_words short_description full_description meta_description meta_keywords page_title promo_text
243684 Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A,TES.AMM.101620432 Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A <p> </p><p>7 Segment 4 Digit LED display, true RMS based Singal phase Ampere Meter Acc Class 0.5 CT Ratio Programmable Optional</p><p> </p><p>Features</p><p> </p><ul><li>60A, 100A direct measurement with Hanging CT,  and Transducer Output range: 0-20mA, 4-20mA, 0-1Vdc etc.)</li></ul><p><br />Please Note: Product may differ (eg. colour) from the product Image displayed on website. Kindly check the technical specifications provided in description to make better purchase decision.</p><p class="mart">Buy Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A online in India at wholesale rates. If you have been looking for Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A dealers, your search ends here as you can get the best Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A distributors in top cities such as Delhi NCR, Mumbai, Chennai, Bengaluru, Kolkata, Chennai, Pune, Jaipur, Hyderabad and Ahmedabad. You can purchase Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A of the finest quality and rest assured to get the best in terms of both durability and performance. If you are bothered about the Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A prices, you can be totally sure to get the best rates as Industrybuying brings you genuine Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A rates and quality assured products only from the best of brands with exclusive brand discounts you won’t find anywhere else. Procure Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A today and avail the best offers on your purchase.</p> Buy Elmeasure Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A in India from stock2cart.com Buy Elmeasure Elmeasure Digital Meter DC Ammeter ALPHA+ADCCL0.5-30A in India from stock2cart.com Extra 18% GST!
277101 1SDA068170R1 BREAKING PART TMAX XT2H 160 FIXED FOUR-POLE WITH FRONT TERMINALS XT2H 160 BREAKING PART 4p F F
277987 1SCA107786R1001 BS Type Fuse gG 500V 80KA OFFNF1GG2