SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    85289, 85290, 85386, 85387, 85437, 85438, 
    85488, 85489, 91092, 91093, 91178, 
    91179, 91233, 91234, 89214, 89227, 
    89240, 83016, 83567, 89746, 89747, 
    90849, 90928, 86517, 86518, 86650, 
    86719, 86793, 86794, 82837, 82910, 
    82983, 83397, 83407, 86140, 86163, 
    86648, 86717, 84818, 84819, 91155, 
    82844, 82845, 82917, 82918, 82990, 
    82991, 83474
  )

Query time 0.00092

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.67"
    },
    "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": 48,
      "rows_produced_per_join": 48,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "16.87",
        "eval_cost": "4.80",
        "prefix_cost": "21.67",
        "data_read_per_join": "230K"
      },
      "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",
        "my_supplier_id",
        "supplier_amount",
        "manufacturer_code",
        "supplier_access_time",
        "rf_stop_update_price",
        "rf_stop_update_amount",
        "rf_stop_update_status",
        "rf_cost"
      ],
      "attached_condition": "(`nuie_scalesta_net`.`cscart_products`.`product_id` in (85289,85290,85386,85387,85437,85438,85488,85489,91092,91093,91178,91179,91233,91234,89214,89227,89240,83016,83567,89746,89747,90849,90928,86517,86518,86650,86719,86793,86794,82837,82910,82983,83397,83407,86140,86163,86648,86717,84818,84819,91155,82844,82845,82917,82918,82990,82991,83474))"
    }
  }
}

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 my_supplier_id supplier_amount manufacturer_code supplier_access_time rf_stop_update_price rf_stop_update_amount rf_stop_update_status rf_cost
82837 ARN2524LBG P A 2 505.83 0 23.500 0 0 0 0.00 0 1679754663 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82844 ARN2525D P A 2 504.17 0 31.500 0 0 0 0.00 0 1679754673 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82845 ARN2525G P A 2 504.17 0 32.000 0 0 0 0.00 0 1679754676 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82910 ARN524LBG P A 2 505.83 0 23.500 0 0 0 0.00 0 1679754773 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82917 ARN525D P A 2 504.17 0 31.500 0 0 0 0.00 0 1679754783 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82918 ARN525G P A 2 504.17 0 32.000 0 0 0 0.00 0 1679754785 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82983 ARN624LBG P A 2 505.83 0 23.500 0 0 0 0.00 0 1679754895 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82990 ARN625D P A 2 504.17 0 31.500 0 0 0 0.00 0 1679754905 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
82991 ARN625G P A 2 504.17 0 32.000 0 0 0 0.00 0 1679754907 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
83016 ARN803A P A 2 508.33 0 30.500 0 0 0 0.00 0 1679754954 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
83397 ATH046LBG P A 2 505.83 0 22.500 0 0 0 0.00 0 1679755621 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
83407 ATH047LBG P A 2 505.83 0 22.500 0 0 0 0.00 0 1679755634 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
83474 ATH060D P A 2 504.17 0 31.500 0 0 0 0.00 0 1679755773 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
83567 ATH075A P A 2 508.33 0 31.000 0 0 0 0.00 0 1679755909 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
84818 CLC194A P A 2 505.00 0 22.500 0 0 0 0.00 0 1679758297 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
84819 CLC194B P A 2 505.00 0 22.500 0 0 0 0.00 0 1679758299 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85289 DPF1492A P A 2 511.67 0 29.040 0 0 0 0.00 0 1679759181 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85290 DPF1492B P A 2 511.67 0 27.500 0 0 0 0.00 0 1679759182 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85386 DPF292A P A 2 511.67 0 29.040 0 0 0 0.00 0 1679759319 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85387 DPF292B P A 2 511.67 0 27.500 0 0 0 0.00 0 1679759320 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85437 DPF392A P A 2 511.67 0 29.040 0 0 0 0.00 0 1679759407 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85438 DPF392B P A 2 511.67 0 27.500 0 0 0 0.00 0 1679759410 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85488 DPF892A P A 2 511.67 0 29.040 0 0 0 0.00 0 1679759499 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
85489 DPF892B P A 2 511.67 0 27.500 0 0 0 0.00 0 1679759500 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86140 HAV2204W P A 2 505.83 0 0.000 0 0 0 0.00 0 1679760701 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86163 HAV2304W P A 2 505.83 0 0.000 0 0 0 0.00 0 1679760752 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86517 JNU1825LSB P A 2 507.50 0 20.750 0 0 0 0.00 0 1679761346 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86518 JNU1825LSW P A 2 507.50 0 20.750 0 0 0 0.00 0 1679761348 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86648 JNU2224W P A 2 505.83 0 26.000 0 0 0 0.00 0 1679761596 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86650 JNU2225A P A 2 507.50 0 33.000 0 0 0 0.00 0 1679761599 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86717 JNU2324W P A 2 505.83 0 26.000 0 0 0 0.00 0 1679761710 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86719 JNU2325A P A 2 507.50 0 33.000 0 0 0 0.00 0 1679761718 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86793 JNU2625LSB P A 2 507.50 0 0.000 0 0 0 0.00 0 1679761863 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
86794 JNU2625LSW P A 2 507.50 0 0.000 0 0 0 0.00 0 1679761863 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
89214 SAR162 P A 2 510.00 0 36.000 0 0 0 0.00 0 1679766567 1757016007 0 N N N N R N N N Y 10 0 B 1 50 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 0 1757016007 N N N 0.00
89227 SAR262 P A 2 510.00 0 36.000 0 0 0 0.00 0 1679766607 1757016007 0 N N N N R N N N Y 10 0 B 1 50 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 0 1757016007 N N N 0.00
89240 SAR362 P A 2 510.00 0 36.000 0 0 0 0.00 0 1679766644 1757016007 0 N N N N R N N N Y 10 0 B 1 50 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 0 1757016007 N N N 0.00
89746 URB102D P A 2 508.33 0 0.100 0 0 0 0.00 0 1679767435 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
89747 URB102G P A 2 508.33 0 0.000 0 0 0 0.00 0 1679767436 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
90849 ARN1403A P A 2 508.33 0 30.500 0 0 0 0.00 0 1688552179 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
90928 ARN2203A P A 2 508.33 0 30.500 0 0 0 0.00 0 1688552410 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
91092 CLC1425F P A 2 511.67 0 37.750 0 0 0 0.00 0 1688599123 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
91093 CLC1425G P A 2 511.67 0 42.800 0 0 0 0.00 0 1688599125 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
91155 CLC194H P A 2 505.00 0 36.000 0 0 0 0.00 0 1688599235 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
91178 CLC225F P A 2 511.67 0 37.750 0 0 0 0.00 0 1688599276 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
91179 CLC225G P A 2 511.67 0 42.800 0 0 0 0.00 0 1688599277 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
91233 CLC825F P A 2 511.67 0 37.750 0 0 0 0.00 0 1688599374 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00
91234 CLC825G P A 2 511.67 0 42.800 0 0 0 0.00 0 1688599376 1777233605 0 N N N N R N N N Y 10 0 B 1 50 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 0 1777233605 N N N 0.00