SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    520, 521, 522, 523, 524, 525, 526, 527, 
    528, 529, 530, 531, 532, 533, 534, 535, 
    536, 537, 538, 539, 540, 541, 542, 543, 
    544, 545, 546, 547, 548, 549, 550, 551, 
    552, 553, 554, 555, 556, 557, 558, 559, 
    560, 561, 562, 563, 564, 565, 566, 567
  )

Query time 0.00094

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "115.21"
    },
    "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",
      "index_condition": "(`danishecarter_latest`.`cscart_products`.`product_id` in (520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567))",
      "cost_info": {
        "read_cost": "105.61",
        "eval_cost": "9.60",
        "prefix_cost": "115.21",
        "data_read_per_join": "212K"
      },
      "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",
        "units_in_product",
        "show_price_per_x_units",
        "gross_price",
        "mdc_vat",
        "is_mobilede",
        "seller_id",
        "mdc_product_id"
      ]
    }
  }
}

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 units_in_product show_price_per_x_units gross_price mdc_vat is_mobilede seller_id mdc_product_id
520 mdc_1144439 P A 4 46500.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
521 mdc_1144442 P A 4 75300.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
522 mdc_1144444 P A 4 13300.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
523 mdc_1144570 P A 4 4990.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
524 mdc_1144572 P A 4 4990.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
525 mdc_1144740 P A 4 3550.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
526 mdc_1145431 P A 4 23200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
527 mdc_1145432 P A 4 23200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
528 mdc_1145439 P A 4 26000.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
529 mdc_1145445 P A 4 17600.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
530 mdc_1145446 P A 4 17600.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
531 mdc_1145448 P A 4 17200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
532 mdc_1145449 P A 4 17200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
533 mdc_1145451 P A 4 39200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
534 mdc_1145452 P A 4 39200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
535 mdc_1145458 P A 4 52000.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
536 mdc_1145462 P A 4 41900.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
537 mdc_1145464 P A 4 23200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
538 mdc_1145465 P A 4 23200.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
539 mdc_1145468 P A 4 28000.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
540 mdc_1145473 P A 4 22400.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
541 mdc_1145474 P A 4 4000.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
542 mdc_1145475 P A 4 4000.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
543 mdc_1145476 P A 4 22400.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
544 mdc_1145478 P A 4 20000.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
545 mdc_1145854 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
546 mdc_1145855 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
547 mdc_1145856 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
548 mdc_1145857 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
549 mdc_1145859 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
550 mdc_1145861 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
551 mdc_1145863 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
552 mdc_1146246 P A 4 2950.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
553 mdc_1146247 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
554 mdc_1146251 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
555 mdc_1146252 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
556 mdc_1146254 P A 4 69900.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
557 mdc_1146255 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
558 mdc_1146256 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
559 mdc_1146258 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
560 mdc_1146259 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
561 mdc_1146262 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
562 mdc_1146266 P A 4 5750.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
563 mdc_1146267 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
564 mdc_1146268 P A 4 4500.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
565 P A 4 2000.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
566 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0
567 P A 4 0.00 1 0.000 0 0 0 0.00 0 1745215681 1745215680 0 N N N N N N N Y 10 0 N N 0 0 0.000 1.000 0.00 0.00 N 0 0