SELECT 
  q_products.* 
FROM 
  q_products 
WHERE 
  q_products.product_id IN (
    8764, 8765, 8766, 8767, 8768, 8769, 8770, 
    8771, 8772, 8773, 8774, 8776, 8788, 
    8825, 8826, 8827, 8828, 8829, 8830, 
    8831, 8832, 8833, 8834, 8835, 8841, 
    8843, 8844, 8845, 8846, 8847
  )

Query time 0.00089

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.01"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "index_condition": "(`portal`.`q_products`.`product_id` in (8764,8765,8766,8767,8768,8769,8770,8771,8772,8773,8774,8776,8788,8825,8826,8827,8828,8829,8830,8831,8832,8833,8834,8835,8841,8843,8844,8845,8846,8847))",
      "cost_info": {
        "read_cost": "66.01",
        "eval_cost": "6.00",
        "prefix_cost": "72.01",
        "data_read_per_join": "176K"
      },
      "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
8764 CAT-DRPHX-CLRM P A 64 220.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580727163 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8765 CAT-IPHOX-TEAL P A 64 399.00 223.20 3 0.000 0 0 0 0.00 0 1557951994 1622962127 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8766 CTF-2658679-6511901 P A 64 199.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580727521 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
8767 CTF-2913728-7311900 P A 64 189.00 95.20 3 0.000 0 0 0 0.00 0 1557951994 1580727544 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8768 CTF-3164967-298601 P A 64 187.00 79.20 3 0.000 0 0 0 0.00 0 1557951994 1580727658 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
8769 CTF-3164967-298701 P A 64 166.00 79.20 3 0.000 0 0 0 0.00 0 1557951994 1582787413 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
8770 CTF-4087600-6511801 P A 64 200.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580727294 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
8771 CTF-4087600-6511901 P A 64 250.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580475001 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8772 CTF-4087600-6512001 P A 64 230.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580475026 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8773 CTF-4139590-6111900 P A 64 230.00 127.20 3 0.000 0 0 0 0.00 0 1557951994 1580475045 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8774 CTF-4250603-7312000 P A 64 199.00 95.20 3 0.000 0 0 0 0.00 0 1557951994 1580475066 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8776 EMT-333-200E-01 P A 64 200.00 103.20 3 0.000 0 0 0 0.00 0 1557951994 1719986495 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8788 NU-CLIC-BLK-WD-NP17 P A 64 230.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580475110 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8825 CAT-DRPHX-BLKL-1 P A 64 310.00 151.20 3 0.000 0 0 0 0.00 0 1557951994 1580475120 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8826 CAT-DRPHX-BLKM P A 64 229.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580475140 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8827 CAT-DRPHX-CLR P A 64 269.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580475420 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8828 CAT-DRPHX-SUN P A 64 210.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580475464 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8829 CAT-DRPHX-TBFCL P A 64 299.00 151.20 3 0.000 0 0 0 0.00 0 1557951994 1580475490 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8830 CAT-DRPHX-TBFCM P A 64 199.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580475530 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8831 CAT-IPHO7-BLK P A 64 359.00 199.20 3 0.000 0 0 0 0.00 0 1557951994 1622962127 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8832 CAT-IPHO7P-BLK P A 64 410.00 223.20 3 0.000 0 0 0 0.00 0 1557951994 1622962127 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8833 CAT-IPHO7P-WHT P A 64 410.00 223.20 3 0.000 0 0 0 0.00 0 1557951994 1622962127 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8834 CAT-IPHO7-WHT P A 64 410.00 199.20 3 0.000 0 0 0 0.00 0 1557951994 1622962127 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8835 CAT-IPHOX-BLK P A 64 430.00 223.20 3 0.000 0 0 0 0.00 0 1557951994 1622962127 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8841 CLIC-SMO-AIR-7 P A 64 109.00 55.20 3 0.000 0 0 0 0.00 0 1557951994 1580474254 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8843 CM-CM034690 P A 64 280.00 127.20 3 0.000 0 0 0 0.00 0 1557951994 1580474306 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8844 CM-CM034760 P A 64 199.00 103.20 3 0.000 0 0 0 0.00 0 1557951994 1580474394 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8845 CM-CM036174 P A 64 250.00 116.00 3 0.000 0 0 0 0.00 0 1557951994 1580474426 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8846 CM-CM036252 P A 64 210.00 116.00 3 0.000 0 0 0 0.00 0 1557951994 1580474454 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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
8847 CM-CM037240 P A 64 300.00 119.20 3 0.000 0 0 0 0.00 0 1557951994 1580474468 0 N N N B N R N N N Y 10 0 N 1 0 1 0 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