SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    40617, 40645, 40646, 54711, 40650, 40647, 
    40675, 40684, 40668, 40614, 40676, 
    40644, 40659, 40618, 40683, 40685, 
    40664, 40642, 40655, 40678, 40605, 
    40686, 40649, 40677, 40660, 40609, 
    40656, 40670, 40682, 40710, 40711, 
    55943, 40657, 40648, 40663, 40613, 
    70304
  )

Query time 0.00133

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "25.91"
    },
    "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": 37,
      "rows_produced_per_join": 37,
      "filtered": "100.00",
      "index_condition": "(`cscartdb`.`cscart_products`.`product_id` in (40617,40645,40646,54711,40650,40647,40675,40684,40668,40614,40676,40644,40659,40618,40683,40685,40664,40642,40655,40678,40605,40686,40649,40677,40660,40609,40656,40670,40682,40710,40711,55943,40657,40648,40663,40613,70304))",
      "cost_info": {
        "read_cost": "22.21",
        "eval_cost": "3.70",
        "prefix_cost": "25.91",
        "data_read_per_join": "198K"
      },
      "used_columns": [
        "product_id",
        "lead_time",
        "etsy_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",
        "allow_notes",
        "buy_now_url",
        "master_product_id",
        "master_product_status",
        "master_product_offers_count",
        "variation_sku",
        "has_color",
        "color_feature_id",
        "featured",
        "shopify_parent_product_id",
        "shopify_variant_product_id"
      ]
    }
  }
}

Result

product_id lead_time etsy_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 allow_notes buy_now_url master_product_id master_product_status master_product_offers_count variation_sku has_color color_feature_id featured shopify_parent_product_id shopify_variant_product_id
40605 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-Electra P A 307 0.00 2 0.000 0 0 0 0.00 0 1722292045 1722935065 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40609 { "from": "1", "to": "3"} HarnessXChest P A 307 0.00 4 0.000 0 0 0 0.00 0 1722463038 1722607385 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40613 { "from": "1", "to": "3"} FootHarnessThreeStraps P A 307 0.00 8 0.000 0 0 0 0.00 0 1723022559 1723022667 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40614 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-Rose P A 307 0.00 2 0.000 0 0 0 0.00 0 1722465689 1722938357 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40617 { "from": "3","to": "5" } MilkingTable P A 307 0.00 4 0.000 0 0 0 0.00 0 1722287488 1722607235 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 1
40618 { "from": "1", "to": "3"} ButtPlug-RoseGold-Swarovski-Clear P A 307 0.00 4 0.000 0 0 0 0.00 0 1722502573 1723024904 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40642 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-SmokedTopaz P A 307 0.00 2 0.000 0 0 0 0.00 0 1722938649 1722938684 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40644 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-Aquamarine P A 307 0.00 2 0.000 0 0 0 0.00 0 1722506673 1722934830 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40645 { "from": "1", "to": "3"} FootHarness P A 307 0.00 8 0.000 0 0 0 0.00 0 1722358070 1723025358 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40646 { "from": "1", "to": "3"} ButtPlugSpankmeFuckmeBreedme P A 307 0.00 5 0.000 0 0 0 0.00 0 1722358607 1722636378 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40647 { "from": "1", "to": "3"} ButtPlug-Gold-Swarovski-Clear P A 307 0.00 4 0.000 0 0 0 0.00 0 1722507137 1722938015 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40648 { "from": "1", "to": "3"} HolographicReykjavik P A 307 0.00 9 0.000 0 0 0 0.00 0 1722527546 1723038068 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40649 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-Emeral P A 307 0.00 2 0.000 0 0 0 0.00 0 1722860605 1723025059 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40650 { "from": "1", "to": "3"} BlackHorseTail P A 307 0.00 5 0.000 0 0 0 0.00 0 1722344885 1722607385 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40655 { "from": "1", "to": "3"} ButtPlug-Gold-Swarovski-SmokedTopaz P A 307 0.00 2 0.000 0 0 0 0.00 0 1722939067 1722939112 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40656 { "from": "1", "to": "3"} FootHarnessFiveStraps P A 307 0.00 6 0.000 0 0 0 0.00 0 1722527919 1723025253 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 1
40657 { "from": "1", "to": "3"} ButtPlug-Gold-Swarovski-Chrysolite P A 307 0.00 2 0.000 0 0 0 0.00 0 1722983171 1722983190 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40659 { "from": "1", "to": "3"} FauxLeatherBowAnklet P A 307 0.00 12 0.000 0 0 0 0.00 0 1722507995 1723025457 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40660 { "from": "1", "to": "3"} ButtPlugBabyboyGoodboyDaddysboy P A 307 0.00 5 0.000 0 0 0 0.00 0 1722897144 1722897410 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40663 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-ChiliPepper P A 307 0.00 2 0.000 0 0 0 0.00 0 1722982118 1722982140 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40664 { "from": "1", "to": "3"} ButtPlug-Gold-Swarovski-CrystalAB P A 307 0.00 4 0.000 0 0 0 0.00 0 1722937966 1722938007 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40668 { "from": "1", "to": "3"} ButtPlug-Gold-Swarovski-Electra P A 307 0.00 2 0.000 0 0 0 0.00 0 1722640444 1723024974 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40670 { "from": "1", "to": "3"} HolographicParis P A 307 0.00 9 0.000 0 0 0 0.00 0 1722505379 1723025176 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40675 { "from": "1", "to": "3"} ButtPlug-Gunmetal-Swarovski-Clear P A 307 0.00 4 0.000 0 0 0 0.00 0 1722507362 1723025035 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 1
40676 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-Clear P A 307 0.00 4 0.000 0 0 0 0.00 0 1722285135 1722935203 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40677 { "from": "1", "to": "3"} HolographicSahara P A 307 0.00 9 0.000 0 0 0 0.00 0 1722982699 1722982732 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40678 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-PurpleHaze P A 307 0.00 2 0.000 0 0 0 0.00 0 1722959490 1722959826 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40682 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-Jet P A 307 0.00 4 0.000 0 0 0 0.00 0 1723021436 1723021454 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40683 { "from": "1", "to": "3"} ChristmasCustomPlugs P A 307 0.00 5 0.000 0 0 0 0.00 0 1722376961 1722935256 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40684 { "from": "1", "to": "3"} ButtPlug-RoseGold-Swarovski-Chrysolite P A 307 0.00 2 0.000 0 0 0 0.00 0 1722937556 1723025083 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40685 { "from": "1", "to": "3"} ButtPlugSlutBitchWhore P A 307 0.00 5 0.000 0 0 0 0.00 0 1722636471 1722637063 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40686 { "from": "1", "to": "3"} ButtPlug-RoseGold-Swarovski-Aquamarine P A 307 0.00 2 0.000 0 0 0 0.00 0 1722940361 1723025091 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40710 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-Chrysolite P A 307 0.00 2 0.000 0 0 0 0.00 0 1723020764 1723020795 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
40711 { "from": "1", "to": "3"} ButtPlug-Silver-Swarovski-CrystalAB P A 307 0.00 4 0.000 0 0 0 0.00 0 1723021059 1723021089 0 N N N Y P 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;} activity 0 N 0 A 0 0 0 0
54711 { "from": "1", "to": "3"} ButtPlug-SterlingSilver-Clear P A 307 0.00 4 0.000 0 0 0 0.00 0 1722285135 1722607385 0 N N N Y P N N N Y 10 0 N N 0 P F 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;} activity 0 N 0 A 0 0 0 0
55943 { "from": "1", "to": "3"} ButtPlug-Gunmetal-Swarovski-Jet P A 307 0.00 4 0.000 0 0 0 0.00 0 1722507362 1723070228 0 N N N Y P N N N Y 10 0 N N 0 P F 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;} activity 0 N 0 A 0 0 0 0
70304 { "from": "1", "to": "3"} ButtPlug-RoseGold-Swarovski-Electra P A 307 0.00 2 0.000 0 0 0 0.00 0 1722937556 1724710842 0 N N N Y P N N N Y 10 0 N N 0 P F 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;} activity 0 N 0 A 0 0 0 0