SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    82437, 87416, 82532, 82545, 87415, 82524, 
    87414, 89565, 82517, 82546, 89571, 
    87413, 91476, 82516, 82544, 89559, 
    89569, 87412, 82515, 87359, 91475, 
    82514, 82511, 89564, 82485, 82510, 
    89555, 82499, 91473, 82436, 87381, 
    85611, 82497, 91472, 82495, 91471, 
    82498, 89547, 89533, 82493, 82435, 
    87375, 85606, 82496, 85610, 89539, 
    85605, 82494
  )

Query time 0.00046

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 (82437,87416,82532,82545,87415,82524,87414,89565,82517,82546,89571,87413,91476,82516,82544,89559,89569,87412,82515,87359,91475,82514,82511,89564,82485,82510,89555,82499,91473,82436,87381,85611,82497,91472,82495,91471,82498,89547,89533,82493,82435,87375,85606,82496,85610,89539,85605,82494))"
    }
  }
}

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
82435 ADFSP80-E8 P A 2 367.50 0 31.400 0 0 0 0.00 0 1679753810 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
82436 ADFSP90-E8 P A 2 396.67 0 35.100 0 0 0 0.00 0 1679753816 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
82437 ADHD80-E8 P A 2 544.17 0 34.400 0 0 0 0.00 0 1679753818 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
82485 AQBD8 P A 2 408.33 0 22.100 0 0 0 0.00 0 1679753936 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
82493 AQHD70H3 P A 2 368.33 0 0.000 0 0 0 0.00 0 1679753962 1788120006 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 1788120006 N N N 0.00
82494 AQHD76 P A 2 351.67 0 25.100 0 0 0 0.00 0 1679753964 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
82495 AQHD76H3 P A 2 378.33 0 0.000 0 0 0 0.00 0 1679753967 1788120006 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 1788120006 N N N 0.00
82496 AQHD80 P A 2 362.50 0 26.500 0 0 0 0.00 0 1679753968 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
82497 AQHD80H3 P A 2 389.17 0 0.000 0 0 0 0.00 0 1679753971 1788120006 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 1788120006 N N N 0.00
82498 AQHD90 P A 2 373.33 0 29.200 0 0 0 0.00 0 1679753972 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
82499 AQHD90H3 P A 2 400.00 0 0.000 0 0 0 0.00 0 1679753978 1788120006 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 1788120006 N N N 0.00
82510 AQSL10 P A 2 405.00 0 31.000 0 0 0 0.00 0 1679754017 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
82511 AQSL10H3 P A 2 431.67 0 0.000 0 0 0 0.00 0 1679754021 1788120006 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 1788120006 N N N 0.00
82514 AQSL12 P A 2 436.67 0 37.300 0 0 0 0.00 0 1679754028 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
82515 AQSL12H3 P A 2 463.33 0 0.000 0 0 0 0.00 0 1679754029 1788120006 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 1788120006 N N N 0.00
82516 AQSL14 P A 2 477.50 0 43.300 0 0 0 0.00 0 1679754030 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
82517 AQSL14H3 P A 2 504.17 0 0.000 0 0 0 0.00 0 1679754033 1788120006 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 1788120006 N N N 0.00
82524 AQSLD14 P A 2 516.67 0 43.000 0 0 0 0.00 0 1679754041 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
82532 AQU10 P A 2 538.33 0 49.500 0 0 0 0.00 0 1679754059 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
82544 AQU8 P A 2 477.50 0 39.000 0 0 0 0.00 0 1679754086 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
82545 AQU8H3 P A 2 530.83 0 0.000 0 0 0 0.00 0 1679754088 1788120006 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 1788120006 N N N 0.00
82546 AQU9 P A 2 496.67 0 44.800 0 0 0 0.00 0 1679754089 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
85605 ERBD76 P A 2 359.17 0 20.300 0 0 0 0.00 0 1679759676 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
85606 ERBD80 P A 2 365.83 0 21.500 0 0 0 0.00 0 1679759677 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
85610 ERCE8080 P A 2 362.50 0 38.500 0 0 0 0.00 0 1679759686 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
85611 ERCE8080H5 P A 2 394.17 0 38.700 0 0 0 0.00 0 1679759688 1788120006 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 1788120006 N N N 0.00
87359 M10EP-E8 P A 2 450.83 0 40.600 0 0 0 0.00 0 1679762927 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
87375 M80EP-E8 P A 2 367.50 0 31.400 0 0 0 0.00 0 1679762971 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
87381 M90EP-E8 P A 2 396.67 0 35.100 0 0 0 0.00 0 1679762979 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
87412 MH70-E8 P A 2 469.17 0 30.200 0 0 0 0.00 0 1679763051 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
87413 MH70H4 P A 2 493.33 0 0.000 0 0 0 0.00 0 1679763053 1788120006 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 1788120006 N N N 0.00
87414 MH76-E8 P A 2 506.67 0 31.400 0 0 0 0.00 0 1679763054 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
87415 MH76H4 P A 2 530.83 0 0.000 0 0 0 0.00 0 1679763055 1788120006 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 1788120006 N N N 0.00
87416 MH80-E8 P A 2 544.17 0 34.000 0 0 0 0.00 0 1679763056 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
89533 SQBD90 P A 2 370.00 0 26.700 0 0 0 0.00 0 1679767094 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
89539 SQHD80BP P A 2 362.50 0 27.900 0 0 0 0.00 0 1679767102 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
89547 SQPD90BP P A 2 371.67 0 31.100 0 0 0 0.00 0 1679767116 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
89555 SQSL10BP P A 2 405.00 0 30.500 0 0 0 0.00 0 1679767132 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
89559 SQSL14BP P A 2 477.50 0 41.200 0 0 0 0.00 0 1679767147 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
89564 SQU108 P A 2 428.33 0 43.500 0 0 0 0.00 0 1679767158 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
89565 SQU108BP P A 2 505.83 0 43.500 0 0 0 0.00 0 1679767158 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
89569 SQU8BP P A 2 477.50 0 38.500 0 0 0 0.00 0 1679767171 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
89571 SQU9BP P A 2 496.67 0 44.300 0 0 0 0.00 0 1679767176 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
91471 SQHD70BB P A 2 375.83 0 24.500 0 0 0 0.00 0 1688606812 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
91472 SQHD76BB P A 2 386.67 0 26.800 0 0 0 0.00 0 1688606818 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
91473 SQHD80BB P A 2 399.17 0 27.900 0 0 0 0.00 0 1688606821 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
91475 SQSL10BB P A 2 445.83 0 30.500 0 0 0 0.00 0 1688606846 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
91476 SQSL12BB P A 2 480.00 0 36.800 0 0 0 0.00 0 1688606851 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