SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    423, 424, 455, 433, 495, 453, 468, 467, 
    418, 420, 421, 422, 406, 407, 437, 494, 
    454, 442, 426, 429, 428, 410, 438, 440, 
    443, 463, 460, 450, 446, 447, 476, 457, 
    482, 483, 472, 441, 405, 403, 485, 492, 
    479, 480, 413, 401, 449, 474, 473, 448
  )

Query time 0.00086

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "97.86"
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 362,
      "rows_produced_per_join": 48,
      "filtered": "13.26",
      "cost_info": {
        "read_cost": "88.26",
        "eval_cost": "9.60",
        "prefix_cost": "97.86",
        "data_read_per_join": "211K"
      },
      "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",
        "is_mobilede",
        "seller_id",
        "mdc_product_id"
      ],
      "attached_condition": "(`danishecarter_latest`.`cscart_products`.`product_id` in (423,424,455,433,495,453,468,467,418,420,421,422,406,407,437,494,454,442,426,429,428,410,438,440,443,463,460,450,446,447,476,457,482,483,472,441,405,403,485,492,479,480,413,401,449,474,473,448))"
    }
  }
}

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 is_mobilede seller_id mdc_product_id
420 mdc_1144199 P A 4 17226.00 1 0.000 0 0 0 0.00 0 1743749273 1743749273 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144199
401 mdc_399533351 P A 3 42016.81 1 0.000 0 0 0 0.00 0 1743672814 1743745362 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 17181675 399533351
403 mdc_418928772 P A 3 0.00 1 39000.000 0 0 0 0.00 0 1743672817 1743745363 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 17181675 418928772
405 mdc_421010830 P A 2 9900.00 1 39000.000 0 0 0 0.00 0 1743672907 1743672907 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 28673582 421010830
406 mdc_421014709 P A 2 14000.00 1 39000.000 0 0 0 0.00 0 1743672908 1743672908 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 28673582 421014709
407 mdc_421019214 P A 2 18000.00 1 39000.000 0 0 0 0.00 0 1743672910 1743672910 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 28673582 421019214
410 mdc_408307528 P A 3 22900.00 1 18000.000 0 0 0 0.00 0 1743745692 1743747154 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 497267 408307528
413 mdc_415941684 P A 3 8500.00 1 39000.000 0 0 0 0.00 0 1743745708 1743747158 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 497267 415941684
418 mdc_417135060 P A 3 9000.00 1 35000.000 0 0 0 0.00 0 1743745731 1743747166 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 497267 417135060
421 mdc_1144221 P A 4 0.00 1 0.000 0 0 0 0.00 0 1743749273 1743749273 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144221
422 mdc_1144223 P A 4 0.00 1 0.000 0 0 0 0.00 0 1743749273 1743749273 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144223
423 mdc_1144298 P A 4 0.00 1 0.000 0 0 0 0.00 0 1743749273 1743749273 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144298
424 mdc_1144299 P A 4 0.00 1 0.000 0 0 0 0.00 0 1743749273 1743749273 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144299
426 mdc_1144438 P A 4 28000.00 1 8281.000 0 0 0 0.00 0 1743749277 1743749277 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144438
428 mdc_1144440 P A 4 20500.00 1 8311.000 0 0 0 0.00 0 1743749278 1743749278 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144440
429 mdc_1144441 P A 4 28000.00 1 8281.000 0 0 0 0.00 0 1743749278 1743749278 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144441
433 mdc_1144472 P A 4 8000.02 1 0.000 0 0 0 0.00 0 1743749282 1743749282 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1144472
437 mdc_1145074 P A 4 12605.04 1 2500.000 0 0 0 0.00 0 1743749290 1743749290 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145074
438 mdc_1145103 P A 4 0.00 1 3500.000 0 0 0 0.00 0 1743749291 1743749291 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145103
440 mdc_1145114 P A 4 0.00 1 3500.000 0 0 0 0.00 0 1743749297 1743749297 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145114
441 mdc_1145281 P A 4 19833.96 1 0.000 0 0 0 0.00 0 1743749301 1743749301 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145281
442 mdc_1145429 P A 4 12400.00 1 18000.000 0 0 0 0.00 0 1743749304 1743749304 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145429
443 mdc_1145430 P A 4 33600.00 1 0.000 0 0 0 0.00 0 1743749308 1743749308 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145430
446 mdc_1145433 P A 4 54000.00 1 43000.000 0 0 0 0.00 0 1743749320 1743749320 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145433
447 mdc_1145434 P A 4 54000.00 1 43000.000 0 0 0 0.00 0 1743749324 1743749324 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145434
448 mdc_1145435 P A 4 15600.00 1 18000.000 0 0 0 0.00 0 1743749325 1743749325 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145435
449 mdc_1145436 P A 4 10600.00 1 11990.000 0 0 0 0.00 0 1743749331 1743749331 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145436
450 mdc_1145437 P A 4 37600.00 1 18000.000 0 0 0 0.00 0 1743749335 1743749335 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145437
453 mdc_1145440 P A 4 7200.00 1 10000.000 0 0 0 0.00 0 1743749349 1743749349 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145440
454 mdc_1145441 P A 4 33600.00 1 18000.000 0 0 0 0.00 0 1743749353 1743749353 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145441
455 mdc_1145442 P A 4 30000.00 1 0.000 0 0 0 0.00 0 1743749354 1743749354 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145442
457 mdc_1145444 P A 4 16800.00 1 15000.000 0 0 0 0.00 0 1743749363 1743749363 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145444
460 mdc_1145447 P A 4 4000.00 1 18000.000 0 0 0 0.00 0 1743749376 1743749376 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145447
463 mdc_1145450 P A 4 4000.00 1 18000.000 0 0 0 0.00 0 1743749385 1743749385 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145450
467 mdc_1145454 P A 4 8800.00 1 36000.000 0 0 0 0.00 0 1743749398 1743749398 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145454
468 mdc_1145455 P A 4 7600.00 1 35000.000 0 0 0 0.00 0 1743749402 1743749402 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145455
472 mdc_1145459 P A 4 4800.00 1 36000.000 0 0 0 0.00 0 1743749420 1743749420 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145459
473 mdc_1145460 P A 4 22400.00 1 18000.000 0 0 0 0.00 0 1743749424 1743749424 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145460
474 mdc_1145461 P A 4 22400.00 1 18000.000 0 0 0 0.00 0 1743749428 1743749428 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145461
476 mdc_1145463 P A 4 10000.00 1 11990.000 0 0 0 0.00 0 1743749438 1743749438 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145463
479 mdc_1145466 P A 4 22000.00 1 36000.000 0 0 0 0.00 0 1743749445 1743749445 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145466
480 mdc_1145467 P A 4 22000.00 1 36000.000 0 0 0 0.00 0 1743749449 1743749449 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145467
482 mdc_1145469 P A 4 28000.00 1 7490.000 0 0 0 0.00 0 1743749455 1743749455 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145469
483 mdc_1145470 P A 4 28000.00 1 7490.000 0 0 0 0.00 0 1743749460 1743749460 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145470
485 mdc_1145472 P A 4 7500.00 1 36000.000 0 0 0 0.00 0 1743749466 1743749466 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145472
492 mdc_1145479 P A 4 12800.00 1 36000.000 0 0 0 0.00 0 1743749495 1743749495 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145479
494 mdc_1145654 P A 4 23100.84 1 0.000 0 0 0 0.00 0 1743749505 1743749505 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145654
495 mdc_1145837 P A 4 66072.96 1 0.000 0 0 0 0.00 0 1743749506 1743749506 0 N N N N N N N Y 10 0 N 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.000 1.000 Y 1819 1145837