SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    92977, 92978, 92979, 92980, 92981, 92982, 
    92983, 92984, 92985, 92986, 92987, 
    92988, 92989, 92990, 92991, 92992, 
    92993, 92994, 92995, 92996, 92997, 
    92998, 92999, 93000, 93001, 94766, 
    94767, 94768, 94769, 94770, 94771, 
    94772, 94773, 94774, 94775, 94776, 
    94777, 94778, 94779, 94780, 94781, 
    94782, 94783, 94784, 94785, 94786, 
    94787, 94788
  )

Query time 0.00043

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 (92977,92978,92979,92980,92981,92982,92983,92984,92985,92986,92987,92988,92989,92990,92991,92992,92993,92994,92995,92996,92997,92998,92999,93000,93001,94766,94767,94768,94769,94770,94771,94772,94773,94774,94775,94776,94777,94778,94779,94780,94781,94782,94783,94784,94785,94786,94787,94788))"
    }
  }
}

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
92977 CBI3031A P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521062 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3031A 1787515205 N N N 0.00
92978 CBI3032 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521062 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3032 1787515205 N N N 0.00
92979 CBI3032A P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521062 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3032A 1787515205 N N N 0.00
92980 CBI3033 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521063 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3033 1787515205 N N N 0.00
92981 CBI3033A P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521063 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3033A 1787515205 N N N 0.00
92982 CBI3034 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521063 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3034 1787515205 N N N 0.00
92983 CBI3034A P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521063 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3034A 1787515205 N N N 0.00
92984 CBI3035 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521064 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3035 1787515205 N N N 0.00
92985 CBI3036 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521064 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3036 1787515205 N N N 0.00
92986 CBI3036A P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521064 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3036A 1787515205 N N N 0.00
92987 CBI3037 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521064 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3037 1787515205 N N N 0.00
92988 CBI3038 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521064 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3038 1787515205 N N N 0.00
92989 CBI3039 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521065 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3039 1787515205 N N N 0.00
92990 CBI3040 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521065 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3040 1787515205 N N N 0.00
92991 CBI3040A P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521065 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3040A 1787515205 N N N 0.00
92992 CBI3041 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521065 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3041 1787515205 N N N 0.00
92993 CBI3041A P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521065 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3041A 1787515205 N N N 0.00
92994 CBI3044 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521066 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3044 1787515205 N N N 0.00
92995 CBI3045 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521066 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3045 1787515205 N N N 0.00
92996 CBI3046 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521066 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3046 1787515205 N N N 0.00
92997 CBI3047 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521066 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3047 1787515205 N N N 0.00
92998 CBI3048 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521067 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3048 1787515205 N N N 0.00
92999 CBI3049 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521067 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3049 1787515205 N N N 0.00
93000 CBI3050 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521067 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3050 1787515205 N N N 0.00
93001 CBI3051 P A 2 0.00 0 0.000 0 0 0 0.00 0 1734521067 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3051 1787515205 N N N 0.00
94766 CBI3202 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473742 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3202 1787515205 N N N 0.00
94767 CBI3203 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473742 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3203 1787515205 N N N 0.00
94768 CBI3204A P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473743 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3204A 1787515205 N N N 0.00
94769 CBI3207 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473743 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3207 1787515205 N N N 0.00
94770 CBI3207A P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473745 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3207A 1787515205 N N N 0.00
94771 CBI3209 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473745 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3209 1787515205 N N N 0.00
94772 CBI3210 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473745 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3210 1787515205 N N N 0.00
94773 CBI3211 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473746 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3211 1787515205 N N N 0.00
94774 CBI3212 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473746 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3212 1787515205 N N N 0.00
94775 CBI3213 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473747 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3213 1787515205 N N N 0.00
94776 CBI3214 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473748 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3214 1787515205 N N N 0.00
94777 CBI3215 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473749 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3215 1787515205 N N N 0.00
94778 CBI3216 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473751 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3216 1787515205 N N N 0.00
94779 CBI3217 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473753 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3217 1787515205 N N N 0.00
94780 CBI3218 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473753 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3218 1787515205 N N N 0.00
94781 CBI3219A P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473754 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3219A 1787515205 N N N 0.00
94782 CBI3224 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473754 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3224 1787515205 N N N 0.00
94783 CBI3224A P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473754 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3224A 1787515205 N N N 0.00
94784 CBI3226 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473755 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3226 1787515205 N N N 0.00
94785 CBI3227 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473755 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3227 1787515205 N N N 0.00
94786 CBI3234 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473755 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3234 1787515205 N N N 0.00
94787 CBI3234A P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473756 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3234A 1787515205 N N N 0.00
94788 CBI3244 P A 2 0.00 0 0.000 0 0 0 0.00 0 1753473756 1787515205 0 N N N N N N N Y 10 0 N N 0 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 1 0 CBI3244 1787515205 N N N 0.00