SELECT 
  q_products.* 
FROM 
  q_products 
WHERE 
  q_products.product_id IN (
    8501, 8503, 8504, 8506, 8507, 8508, 8509, 
    8510, 8511, 8512, 8514, 8515, 8516, 
    8517, 8518, 8519, 8521, 8477, 8476, 
    8474, 8377, 8376, 8375, 8374, 8368, 
    8367, 8272, 8271, 8270, 8269, 8268, 
    8267
  )

Query time 0.00096

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "76.81"
    },
    "table": {
      "table_name": "q_products",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 32,
      "rows_produced_per_join": 32,
      "filtered": "100.00",
      "index_condition": "(`portal`.`q_products`.`product_id` in (8501,8503,8504,8506,8507,8508,8509,8510,8511,8512,8514,8515,8516,8517,8518,8519,8521,8477,8476,8474,8377,8376,8375,8374,8368,8367,8272,8271,8270,8269,8268,8267))",
      "cost_info": {
        "read_cost": "70.41",
        "eval_cost": "6.40",
        "prefix_cost": "76.81",
        "data_read_per_join": "188K"
      },
      "used_columns": [
        "product_id",
        "product_code",
        "product_type",
        "status",
        "company_id",
        "list_price",
        "vendor_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",
        "__variation_code",
        "__variation_options",
        "__is_default_variation",
        "buy_now_url"
      ]
    }
  }
}

Result

product_id product_code product_type status company_id list_price vendor_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 __variation_code __variation_options __is_default_variation buy_now_url
8267 8K-RB6F-DEYL P A 57 200.00 140.00 4 0.000 0 0 0 0.00 0 1557814935 1558342050 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8268 B07BXTN6GJ P A 57 200.00 150.00 2 0.000 0 0 0 0.00 0 1557815633 1567837999 0 N N N B N R N N N Y 10 0 S 1 0 1 0 6 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;} 0 N
8269 20MLNL P A 57 20.00 5.00 100 0.000 0 0 0 0.00 0 1557817273 1558513846 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8270 Q1FW30G P A 57 50.00 20.00 20 0.000 0 0 0 0.00 0 1557817736 1565175106 0 N N N B N R N N N Y 10 0 S 1 0 1 0 6 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;} 0 N
8271 v1blc21 P A 57 20.00 3.00 1000 0.000 0 0 0 0.00 0 1557818071 1558247693 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8272 B07MX9WHV1 P A 57 150.00 85.00 3 0.000 0 0 0 0.00 0 1557819153 1652346552 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8367 B00B8TO93G P A 57 100.00 65.00 5 0.000 0 0 0 0.00 0 1557819636 1652346552 0 N N N B N R N N N Y 10 0 S 1 0 1 0 6 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;} 0 N
8368 WLKT0000123 P A 57 54.00 19.00 12 0.000 0 0 0 0.00 0 1557819924 1558341975 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8374 HCK00001 P A 57 30.00 15.00 12 0.000 0 0 0 0.00 0 1557821179 1558247693 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8375 D3RX00002 P A 57 30.00 10.00 12 0.000 0 0 0 0.00 0 1557821524 1569747585 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8376 D3RX00003 P A 57 30.00 10.00 12 0.000 0 0 0 0.00 0 1557821699 1569747585 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8377 D3RX00004 P A 57 40.00 4.00 12 0.000 0 0 0 0.00 0 1557821864 1569747585 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8474 B07MJZ7GNM P A 57 150.00 95.00 5 0.000 0 0 0 0.00 0 1557823446 1558350703 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8476 B07MX2JMCB P A 57 60.00 28.00 12 0.000 0 0 0 0.00 0 1557823894 1558350441 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8477 B003014L6U P A 57 70.00 35.00 12 0.000 0 0 0 0.00 0 1557824104 1652346552 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8501 HV-D2L0-N8AG P A 57 120.00 75.00 1 0.000 0 0 0 0.00 0 1557825497 1558379792 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8503 JN-6P0G-T8W5 P A 57 120.00 75.00 1 0.000 0 0 0 0.00 0 1557825497 1558380071 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8504 L8-DWOQ-5G0H P A 57 199.00 110.00 2 0.000 0 0 0 0.00 0 1557825497 1652346552 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8506 MM-16TT-1N6M P A 57 200.00 150.00 2 0.000 0 0 0 0.00 0 1557825497 1558437740 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8507 NG-BNMG-3AIN P A 57 199.00 100.00 13 0.000 0 0 0 0.00 0 1557825497 1652346552 0 N N N B N R N N N Y 10 0 S 1 0 1 0 6 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;} 0 N
8508 O3-X1XD-VHJD P A 57 99.00 45.00 3 0.000 0 0 0 0.00 0 1557825497 1558437768 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8509 O4-EBHO-MTN8 P A 57 218.00 145.00 3 0.000 0 0 0 0.00 0 1557825497 1578392470 0 N N N B N R N N N Y 10 0 S 1 0 1 0 6 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;} 0 N
8510 OC-E4BK-WXNR P A 57 450.00 320.00 2 0.000 0 0 0 0.00 0 1557825497 1558437914 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8511 OZ-QZID-2D7D P A 57 300.00 210.00 2 0.000 0 0 0 0.00 0 1557825497 1558437923 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8512 PY-FACU-06FJ P A 57 200.00 150.00 1 0.000 0 0 0 0.00 0 1557825497 1558437964 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8514 Q4-X51S-M2CW P A 57 250.00 150.00 3 0.000 0 0 0 0.00 0 1557825497 1558247692 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8515 QM-UD7Q-GOL9 P A 57 200.00 120.00 3 0.000 0 0 0 0.00 0 1557825497 1558247692 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8516 QZ-7C0J-7USG P A 57 200.00 150.00 2 0.000 0 0 0 0.00 0 1557825497 1719986495 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8517 SU-EHC4-7Z45 P A 57 250.00 170.00 2 0.000 0 0 0 0.00 0 1557825497 1558438094 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8518 T9-TJII-P1XW P A 57 300.00 200.00 3 0.000 0 0 0 0.00 0 1557825497 1558247692 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8519 V8-X201-UISR P A 57 150.00 80.00 2 0.000 0 0 0 0.00 0 1557825497 1558438288 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N
8521 Y7-DR33-XBSN P A 57 200.00 135.00 1 0.000 0 0 0 0.00 0 1557825497 1652346552 0 N N N B N R N N N Y 10 0 N 1 0 1 0 6 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;} 0 N