SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2227, 2060, 2122, 2274, 2061, 1957, 1814, 
    2331, 1748, 2005, 2214, 2342, 2215, 
    2211, 2225, 2212, 2213, 2226, 2303, 
    2260, 2195, 2130, 2332, 1840, 2163, 
    2173, 2175, 2177, 2176, 2070, 2069, 
    2351, 2209, 2261, 2174, 2235
  )

Query time 0.00055

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "25.21"
    },
    "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": 36,
      "rows_produced_per_join": 36,
      "filtered": "100.00",
      "index_condition": "(`cscartdevel`.`cscart_products`.`product_id` in (2227,2060,2122,2274,2061,1957,1814,2331,1748,2005,2214,2342,2215,2211,2225,2212,2213,2226,2303,2260,2195,2130,2332,1840,2163,2173,2175,2177,2176,2070,2069,2351,2209,2261,2174,2235))",
      "cost_info": {
        "read_cost": "21.61",
        "eval_cost": "3.60",
        "prefix_cost": "25.21",
        "data_read_per_join": "164K"
      },
      "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",
        "ss_omnibus_display",
        "rp_enable",
        "rp_pre_auth",
        "rp_pay_type",
        "rp_period",
        "rp_free_period",
        "rp_shipping_cost",
        "rp_addon_id",
        "rp_struct_billing",
        "ss_deepl_auto_translate",
        "ss_deepl_changed_fields"
      ]
    }
  }
}

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 ss_omnibus_display rp_enable rp_pre_auth rp_pay_type rp_period rp_free_period rp_shipping_cost rp_addon_id rp_struct_billing ss_deepl_auto_translate ss_deepl_changed_fields
1748 5907814669179 P A 273 14.99 895 0.120 0 0 0 0.00 0 1754584789 1755186893 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
1814 5907814660107 P A 273 8.59 273 0.160 0 0 0 0.00 0 1754584925 1755186894 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
1840 5907814664907 P A 273 9.96 1379 0.410 0 0 0 0.00 0 1754584980 1755186894 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
1957 4016249003531 P A 273 16.29 1431 0.090 0 0 0 0.00 0 1754652258 1755186894 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2005 5902448165073 P A 273 0.00 380 0.040 0 0 0 0.00 0 1754652347 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2060 8594006666480 P A 273 0.00 5979 0.050 0 0 0 0.00 0 1754652458 1754667956 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2061 8594006666497 P A 273 0.00 7412 0.050 0 0 0 0.00 0 1754652460 1754667956 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2069 5901641002918 P A 273 0.00 153 0.350 0 0 0 0.00 0 1754652477 1754667409 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2070 5901641002901 P A 273 0.00 100 0.350 0 0 0 0.00 0 1754652479 1754667409 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2122 8594006668354 P A 273 0.00 6722 0.050 0 0 0 0.00 0 1754652580 1754667956 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2130 8717496906700 P A 273 0.00 630 0.210 0 0 0 0.00 0 1754652593 1754667395 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2163 5902425055922 P A 273 0.00 44 0.620 0 0 0 0.00 0 1754652656 1754667406 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2173 4820219346500 P A 273 0.00 197 0.140 0 0 0 0.00 0 1754652676 1754667406 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2174 4820219343851 P A 273 0.00 79 0.140 0 0 0 0.00 0 1754652678 1754667409 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2175 4820219346517 P A 273 0.00 209 0.140 0 0 0 0.00 0 1754652680 1754667406 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2176 4820219346487 P A 273 0.00 239 0.140 0 0 0 0.00 0 1754652681 1754667406 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2177 4820219346494 P A 273 0.00 177 0.140 0 0 0 0.00 0 1754652683 1754667406 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2195 5906395341368 P A 273 0.00 142 0.380 0 0 0 0.00 0 1754652719 1754667395 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2209 5902425055687 P A 273 0.00 299 0.170 0 0 0 0.00 0 1754652743 1754667409 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2211 8716788002472 P A 273 0.00 229 0.100 0 0 0 0.00 0 1754652746 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2212 8716788002458 P A 273 0.00 147 0.100 0 0 0 0.00 0 1754652749 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2213 8716788019159 P A 273 0.00 253 0.100 0 0 0 0.00 0 1754652751 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2214 8716788019142 P A 273 0.00 272 0.100 0 0 0 0.00 0 1754652753 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2215 8716788002380 P A 273 0.00 672 0.070 0 0 0 0.00 0 1754652755 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2225 8721082004114 P A 273 0.00 181 0.110 0 0 0 0.00 0 1754652772 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2226 8721082004121 P A 273 0.00 28 0.110 0 0 0 0.00 0 1754652774 1754667957 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2227 5905279630017 P A 273 0.00 67 0.080 0 0 0 0.00 0 1754652775 1754667956 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2235 4820219349488 P A 273 0.00 26 0.400 0 0 0 0.00 0 1754652789 1754667409 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2260 8713576002591 P A 273 16.95 46 0.450 0 0 0 0.00 0 1754898562 1755182433 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2261 5902650275744 P A 273 0.00 36 0.420 0 0 0 0.00 0 1754898711 1755182451 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2274 8594006666985 P A 273 4.59 1414 0.050 0 0 0 0.00 0 1755535507 1755863081 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2303 3431590002674 P A 273 0.00 296 0.340 0 0 0 0.00 0 1755535561 1755535747 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2331 5907738151866 P A 273 7.19 65 0.060 0 0 0 0.00 0 1755535605 1755863194 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2332 5907738150333 P A 273 14.79 233 0.310 0 0 0 0.00 0 1755535607 1755865594 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2342 8718754505024 P A 273 13.90 425 0.080 0 0 0 0.00 0 1755535625 1755863224 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N
2351 8009004811812 P A 273 0.00 155 0.050 0 0 0 0.00 0 1755535641 1755535750 0 N N N N Y N N Y 10 0 N 6 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 Y N N B 0 0.00 N