SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    11137, 11136, 11152, 11153, 11236, 11237, 
    11352, 11355, 11362, 11363, 11388, 
    11389, 11390, 11391, 11399, 11400, 
    11416, 11415, 11414, 11417, 11430, 
    11431, 11458, 11460, 11462, 11463, 
    11479, 11481, 11520, 11521, 11530, 
    11532, 11535, 11536, 11598, 11599, 
    11600, 11633, 11634, 11635, 11636
  )

Query time 0.00115

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "28.71"
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 41,
      "rows_produced_per_join": 41,
      "filtered": "100.00",
      "index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_products`.`product_id` in (11137,11136,11152,11153,11236,11237,11352,11355,11362,11363,11388,11389,11390,11391,11399,11400,11416,11415,11414,11417,11430,11431,11458,11460,11462,11463,11479,11481,11520,11521,11530,11532,11535,11536,11598,11599,11600,11633,11634,11635,11636))",
      "cost_info": {
        "read_cost": "24.61",
        "eval_cost": "4.10",
        "prefix_cost": "28.71",
        "data_read_per_join": "181K"
      },
      "used_columns": [
        "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",
        "ab__stickers_manual_ids",
        "ab__stickers_generated_ids"
      ]
    }
  }
}

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 ab__stickers_manual_ids ab__stickers_generated_ids
11136 RB2216 61 901/31 P A 1 295500.00 100 0.000 0 0 0 0.00 0 1769034936 1769036821 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11137 RB2216 61 901/B1 V A 1 295500.00 100 0.000 0 0 0 0.00 0 1769035317 1769036821 0 N N N N Y N N Y 3 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;} activity 11136 0.000 0.000
11152 RB2231 58 141833 P A 1 316500.00 100 0.000 0 0 0 0.00 0 1769043914 1769043986 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11153 RB2231 58 901/31 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769044043 1769043986 0 N N N N Y N N Y 3 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;} activity 11152 0.000 0.000
11236 RB3717 60 003/3F P A 1 352500.00 100 0.000 0 0 0 0.00 0 1769221524 1769221625 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11237 RB3717 60 919631 V A 1 334500.00 100 0.000 0 0 0 0.00 0 1769221728 1769221625 0 N N N N Y N N Y 3 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;} activity 11236 0.000 0.000
11352 RB3684CH 58 001/AN P A 1 411000.00 100 0.000 0 0 0 0.00 0 1769449370 1769449529 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11355 RB3684CH 58 004/4L V A 1 411000.00 100 0.000 0 0 0 0.00 0 1769449899 1769449529 0 N N N N Y N N Y 3 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;} activity 11352 0.000 0.000
11362 RB3694 55 001/51 P A 1 334500.00 100 0.000 0 0 0 0.00 0 1769459697 1769459807 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11363 RB3694 55 001/31 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769459850 1769459807 0 N N N N Y N N Y 3 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;} activity 11362 0.000 0.000
11388 RB3016 55 1367B1 P A 1 312000.00 100 0.000 0 0 0 0.00 0 1769523473 1769525127 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11389 RB3016 55 W0365 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769523680 1769525127 0 N N N N Y N N Y 3 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;} activity 11388 0.000 0.000
11390 RB3683 56 002/31 P A 1 294000.00 100 0.000 0 0 0 0.00 0 1769525421 1769525798 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11391 RB3683 56 003/B1 V A 1 294000.00 100 0.000 0 0 0 0.00 0 1769525662 1769525798 0 N N N N Y N N Y 3 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;} activity 11390 0.000 0.000
11399 RBR0502S 50 6677VR P A 1 354000.00 100 0.000 0 0 0 0.00 0 1769528978 1769529079 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11400 RBR0502S 50 6707GR V A 1 354000.00 100 0.000 0 0 0 0.00 0 1769529239 1769529079 0 N N N N Y N N Y 3 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;} activity 11399 0.000 0.000
11414 RB3547 54 001/31 P A 1 312000.00 100 0.000 0 0 0 0.00 0 1769545449 1769549115 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11415 RB3547 54 9202S2 V A 1 402000.00 100 0.000 0 0 0 0.00 0 1769548333 1769549115 0 N N N N Y N N Y 3 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;} activity 11414 0.000 0.000
11416 RB3547 54 002/B1 V A 1 312000.00 100 0.000 0 0 0 0.00 0 1769548333 1769549115 0 N N N N Y N N Y 3 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;} activity 11414 0.000 0.000
11417 RB3547 54 003/3F V A 1 334500.00 100 0.000 0 0 0 0.00 0 1769548333 1769549115 0 N N N N Y N N Y 3 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;} activity 11414 0.000 0.000
11430 RB3736 56 003/6G P A 1 390000.00 100 0.000 0 0 0 0.00 0 1769586833 1769586924 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11431 RB3736 56 004/80 V A 1 354000.00 100 0.000 0 0 0 0.00 0 1769587006 1769586924 0 N N N N Y N N Y 3 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;} activity 11430 0.000 0.000
11458 RB3809 55 001/51 P A 1 334500.00 100 0.000 0 0 0 0.00 0 1769640330 1769640390 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11460 RB3809 55 92623F V A 1 334500.00 100 0.000 0 0 0 0.00 0 1769640423 1769640390 0 N N N N Y N N Y 3 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;} activity 11458 0.000 0.000
11462 RB3809 53 001/31 P A 1 316500.00 100 0.000 0 0 0 0.00 0 1769640787 1769640844 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11463 RB3809 53 002/B1 V A 1 316500.00 100 0.000 0 0 0 0.00 0 1769640896 1769640844 0 N N N N Y N N Y 3 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;} activity 11462 0.000 0.000
11479 RB3768 56 001/71 P A 1 295500.00 100 0.000 0 0 0 0.00 0 1769643630 1769643783 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11481 RB3768 56 003/80 V A 1 295500.00 100 0.000 0 0 0 0.00 0 1769643985 1769643783 0 N N N N Y N N Y 3 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;} activity 11479 0.000 0.000
11520 RB3947 57 001/31 P A 1 316500.00 100 0.000 0 0 0 0.00 0 1769872006 1769872084 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11521 RB3947 57 002/B1 V A 1 316500.00 100 0.000 0 0 0 0.00 0 1769872138 1769872084 0 N N N N Y N N Y 3 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;} activity 11520 0.000 0.000
11530 RB4258 50 601/71 P A 1 295500.00 100 0.000 0 0 0 0.00 0 1769873750 1769873865 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11532 RB4258 50 710/73 V A 1 295500.00 100 0.000 0 0 0 0.00 0 1769873934 1769873865 0 N N N N Y N N Y 3 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;} activity 11530 0.000 0.000
11535 RB4305 53 601/71 P A 1 295500.00 100 0.000 0 0 0 0.00 0 1769874244 1769874356 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11536 RB4305 53 710/73 V A 1 295500.00 100 0.000 0 0 0 0.00 0 1769874455 1769874356 0 N N N N Y N N Y 3 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;} activity 11535 0.000 0.000
11598 RB3767 54 001/13 V A 1 313500.00 100 0.000 0 0 0 0.00 0 1770165436 1770165499 0 N N N N Y N N Y 3 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;} activity 11600 0.000 0.000
11599 RB3767 54 003/87 V A 1 295500.00 100 0.000 0 0 0 0.00 0 1770165594 1770165499 0 N N N N Y N N Y 3 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;} activity 11600 0.000 0.000
11600 RB3767 54 001/71 P A 1 295500.00 100 0.000 0 0 0 0.00 0 1770165594 1770165499 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11633 RB4306 54 601/71 P A 1 294000.00 100 0.000 0 0 0 0.00 0 1770281561 1770282207 0 N N N N Y N N Y 3 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;} activity 0 0.000 0.000
11634 RB4306 54 710/73 V A 1 294000.00 100 0.000 0 0 0 0.00 0 1770281885 1770282207 0 N N N N Y N N Y 3 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;} activity 11633 0.000 0.000
11635 RB4306 54 6788V1 V A 1 313500.00 100 0.000 0 0 0 0.00 0 1770281885 1770282207 0 N N N N Y N N Y 3 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;} activity 11633 0.000 0.000
11636 RB4306 54 678846 V A 1 313500.00 100 0.000 0 0 0 0.00 0 1770281885 1770282207 0 N N N N Y N N Y 3 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;} activity 11633 0.000 0.000