SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    85355, 83040, 90876, 90955, 83350, 83351, 
    83352, 83353, 85054, 85055, 85140, 
    85141, 85186, 85187, 85232, 85233, 
    82812, 82814, 82885, 82887, 82958, 
    82960, 83332, 83334, 83342, 83344, 
    85350, 83026, 83027, 90862, 90863, 
    90941, 90942, 82809, 82882, 82955, 
    83329, 83339, 85094, 85095, 83549, 
    83554, 86491, 86767, 85305, 85402, 
    85453, 85504
  )

Query time 0.00096

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 (85355,83040,90876,90955,83350,83351,83352,83353,85054,85055,85140,85141,85186,85187,85232,85233,82812,82814,82885,82887,82958,82960,83332,83334,83342,83344,85350,83026,83027,90862,90863,90941,90942,82809,82882,82955,83329,83339,85094,85095,83549,83554,86491,86767,85305,85402,85453,85504))"
    }
  }
}

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
82809 ARN2522A P A 2 419.17 0 24.000 0 0 0 0.00 0 1679754611 1777579205 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 1777579205 N N N 0.00
82812 ARN2522D P A 2 423.33 0 24.000 0 0 0 0.00 0 1679754621 1777579205 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 1777579205 N N N 0.00
82814 ARN2522G P A 2 423.33 0 24.000 0 0 0 0.00 0 1679754627 1777579205 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 1777579205 N N N 0.00
82882 ARN522A P A 2 419.17 0 24.000 0 0 0 0.00 0 1679754729 1777579205 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 1777579205 N N N 0.00
82885 ARN522D P A 2 423.33 0 24.000 0 0 0 0.00 0 1679754734 1777579205 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 1777579205 N N N 0.00
82887 ARN522G P A 2 423.33 0 24.000 0 0 0 0.00 0 1679754738 1777579205 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 1777579205 N N N 0.00
82955 ARN622A P A 2 419.17 0 24.000 0 0 0 0.00 0 1679754848 1777579205 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 1777579205 N N N 0.00
82958 ARN622D P A 2 423.33 0 24.000 0 0 0 0.00 0 1679754854 1777579205 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 1777579205 N N N 0.00
82960 ARN622G P A 2 423.33 0 24.000 0 0 0 0.00 0 1679754860 1777579205 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 1777579205 N N N 0.00
83026 ARN821D P A 2 420.83 0 22.100 0 0 0 0.00 0 1679754972 1777579205 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 1777579205 N N N 0.00
83027 ARN821G P A 2 420.83 0 21.600 0 0 0 0.00 0 1679754973 1777579205 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 1777579205 N N N 0.00
83040 ARN823B P A 2 425.83 0 24.960 0 0 0 0.00 0 1679754995 1777579205 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 1777579205 N N N 0.00
83329 ATH039A P A 2 419.17 0 23.000 0 0 0 0.00 0 1679755507 1777579205 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 1777579205 N N N 0.00
83332 ATH039D P A 2 423.33 0 24.000 0 0 0 0.00 0 1679755511 1777579205 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 1777579205 N N N 0.00
83334 ATH039G P A 2 423.33 0 24.000 0 0 0 0.00 0 1679755514 1777579205 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 1777579205 N N N 0.00
83339 ATH040A P A 2 419.17 0 23.000 0 0 0 0.00 0 1679755521 1777579205 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 1777579205 N N N 0.00
83342 ATH040D P A 2 423.33 0 24.000 0 0 0 0.00 0 1679755526 1777579205 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 1777579205 N N N 0.00
83344 ATH040G P A 2 423.33 0 24.000 0 0 0 0.00 0 1679755529 1777579205 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 1777579205 N N N 0.00
83350 ATH041A17 P A 2 425.00 0 0.010 0 0 0 0.00 0 1679755538 1777579205 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 1777579205 N N N 0.00
83351 ATH041A68 P A 2 425.00 0 0.010 0 0 0 0.00 0 1679755542 1777579205 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 1777579205 N N N 0.00
83352 ATH041A69 P A 2 425.00 0 0.010 0 0 0 0.00 0 1679755542 1777579205 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 1777579205 N N N 0.00
83353 ATH041A7 P A 2 425.00 0 0.010 0 0 0 0.00 0 1679755543 1777579205 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 1777579205 N N N 0.00
83549 ATH073A P A 2 417.50 0 23.740 0 0 0 0.00 0 1679755881 1777579205 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 1777579205 N N N 0.00
83554 ATH073B P A 2 417.50 0 22.200 0 0 0 0.00 0 1679755886 1777579205 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 1777579205 N N N 0.00
85054 DFF1491A P A 2 424.17 0 23.040 0 0 0 0.00 0 1679758769 1777579205 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 1777579205 N N N 0.00
85055 DFF1491B P A 2 424.17 0 21.500 0 0 0 0.00 0 1679758770 1777579205 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 1777579205 N N N 0.00
85094 DFF191A P A 2 419.17 0 23.040 0 0 0 0.00 0 1679758825 1777579205 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 1777579205 N N N 0.00
85095 DFF191B P A 2 419.17 0 21.500 0 0 0 0.00 0 1679758826 1777579205 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 1777579205 N N N 0.00
85140 DFF291A P A 2 424.17 0 23.040 0 0 0 0.00 0 1679758901 1777579205 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 1777579205 N N N 0.00
85141 DFF291B P A 2 424.17 0 21.500 0 0 0 0.00 0 1679758902 1777579205 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 1777579205 N N N 0.00
85186 DFF391A P A 2 424.17 0 23.040 0 0 0 0.00 0 1679758981 1777579205 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 1777579205 N N N 0.00
85187 DFF391B P A 2 424.17 0 21.500 0 0 0 0.00 0 1679758983 1777579205 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 1777579205 N N N 0.00
85232 DFF891A P A 2 424.17 0 23.040 0 0 0 0.00 0 1679759060 1777579205 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 1777579205 N N N 0.00
85233 DFF891B P A 2 424.17 0 21.500 0 0 0 0.00 0 1679759063 1777579205 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 1777579205 N N N 0.00
85305 DPF1494B P A 2 416.67 0 23.760 0 0 0 0.00 0 1679759199 1777579205 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 1777579205 N N N 0.00
85350 DPF194A P A 2 422.50 0 24.000 0 0 0 0.00 0 1679759262 1777579205 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 1777579205 N N N 0.00
85355 DPF194G P A 2 426.67 0 24.000 0 0 0 0.00 0 1679759271 1777579205 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 1777579205 N N N 0.00
85402 DPF294B P A 2 416.67 0 23.760 0 0 0 0.00 0 1679759351 1777579205 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 1777579205 N N N 0.00
85453 DPF394B P A 2 416.67 0 23.760 0 0 0 0.00 0 1679759443 1777579205 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 1777579205 N N N 0.00
85504 DPF894B P A 2 416.67 0 23.760 0 0 0 0.00 0 1679759527 1777579205 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 1777579205 N N N 0.00
86491 JNU1823B P A 2 417.50 0 25.460 0 0 0 0.00 0 1679761306 1777579205 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 1777579205 N N N 0.00
86767 JNU2623B P A 2 417.50 0 0.000 0 0 0 0.00 0 1679761820 1777579205 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 1777579205 N N N 0.00
90862 ARN1421D P A 2 420.83 0 22.100 0 0 0 0.00 0 1688552200 1777579205 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 1777579205 N N N 0.00
90863 ARN1421G P A 2 420.83 0 21.600 0 0 0 0.00 0 1688552201 1777579205 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 1777579205 N N N 0.00
90876 ARN1423B P A 2 425.83 0 24.960 0 0 0 0.00 0 1688552218 1777579205 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 1777579205 N N N 0.00
90941 ARN2221D P A 2 420.83 0 22.100 0 0 0 0.00 0 1688552432 1777579205 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 1777579205 N N N 0.00
90942 ARN2221G P A 2 420.83 0 21.600 0 0 0 0.00 0 1688552433 1777579205 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 1777579205 N N N 0.00
90955 ARN2223B P A 2 425.83 0 24.960 0 0 0 0.00 0 1688552453 1777579205 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 1777579205 N N N 0.00