SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62676, 57923, 57919, 63369, 57930, 57936, 
    57912, 63445, 63383, 62954, 57913, 
    57917, 57924, 63431, 63395, 57934, 
    57915, 57914, 57940, 57946, 63419, 
    63407, 57947, 57916, 57927, 57920, 
    57922, 57918, 57928, 57929, 63684, 
    63457, 57911, 57935, 63443, 63682
  )

Query time 0.00139

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "25.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": 36,
      "rows_produced_per_join": 36,
      "filtered": "100.00",
      "index_condition": "(`cscartdb`.`cscart_products`.`product_id` in (62676,57923,57919,63369,57930,57936,57912,63445,63383,62954,57913,57917,57924,63431,63395,57934,57915,57914,57940,57946,63419,63407,57947,57916,57927,57920,57922,57918,57928,57929,63684,63457,57911,57935,63443,63682))",
      "cost_info": {
        "read_cost": "21.61",
        "eval_cost": "3.60",
        "prefix_cost": "25.21",
        "data_read_per_join": "192K"
      },
      "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
57911 {"from":"7","to":"21"} f32c2c71-c85f-4e94-bb9e-2cee0182d0c6 P A 404 0.00 174 0.000 0 0 0 0.00 0 1723782926 1723869338 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 Y 0 A 0 f32c2c71-c85f-4e94-bb9e-2cee0182d0c6 0 0 0
57912 {"from":"7","to":"21"} ae1fcd20-e82e-480d-a7d3-0808fbaf1447 P A 404 0.00 167 0.000 0 0 0 0.00 0 1723765463 1723865622 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 Y 0 A 0 ae1fcd20-e82e-480d-a7d3-0808fbaf1447 1 1466 0
57913 {"from":"7","to":"21"} 2c198c6d-0b53-4203-9da8-b52e037c38d8 P A 404 0.00 200 0.500 0 0 0 0.00 0 1723747851 1723865606 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 2c198c6d-0b53-4203-9da8-b52e037c38d8 1 1466 0
57914 {"from":"7","to":"21"} 4542752b-e72f-4ca5-9f63-fff01e8402ed P A 404 0.00 138 0.000 0 0 0 0.00 0 1723752129 1723869715 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 Y 0 A 0 4542752b-e72f-4ca5-9f63-fff01e8402ed 1 1466 0
57915 {"from":"7","to":"21"} 7de0beac-cc18-4b6f-82ef-8ce8066db4f9 P A 404 0.00 197 0.625 0 0 0 0.00 0 1723751146 1723865674 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 Y 0 A 0 7de0beac-cc18-4b6f-82ef-8ce8066db4f9 1 1466 0
57916 {"from":"7","to":"21"} f01bdd63-f690-4fc0-bab4-ed344006f52e P A 404 0.00 194 0.938 0 0 0 0.00 0 1723788496 1723865756 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 Y 0 A 0 f01bdd63-f690-4fc0-bab4-ed344006f52e 1 1466 0
57917 {"from":"7","to":"21"} 5cfa9c88-d03b-46e6-aada-28d030d7a05f P A 404 0.00 189 0.000 0 0 0 0.00 0 1723789163 1723865769 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 5cfa9c88-d03b-46e6-aada-28d030d7a05f 1 1466 0
57918 {"from":"7","to":"21"} eb30e9fe-5e50-42ae-999e-2d7a3fb29108 P A 404 0.00 163 0.000 0 0 0 0.00 0 1723755468 1723865666 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 eb30e9fe-5e50-42ae-999e-2d7a3fb29108 1 1466 0
57919 {"from":"7","to":"21"} a19e199e-6f47-49b7-9ac0-ddbb91c146a1 P A 404 0.00 200 0.500 0 0 0 0.00 0 1723744423 1723865594 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 Y 0 A 0 a19e199e-6f47-49b7-9ac0-ddbb91c146a1 1 1466 0
57920 {"from":"7","to":"21"} dd99a78e-2363-475c-85e7-20fcb51c8aa7 P A 404 0.00 153 0.000 0 0 0 0.00 0 1723765797 1723865648 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 Y 0 A 0 dd99a78e-2363-475c-85e7-20fcb51c8aa7 1 1466 0
57922 {"from":"7","to":"21"} 48a80ebc-b3fe-4a0b-9a00-4d671012a121 P A 404 0.00 176 0.000 0 0 0 0.00 0 1723765064 1723865691 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 Y 0 A 0 48a80ebc-b3fe-4a0b-9a00-4d671012a121 1 1466 0
57923 {"from":"7","to":"21"} 8a1ce9d5-3953-4612-8124-e10bdf2d8333 P A 404 0.00 151 0.000 0 0 0 0.00 0 1723764053 1723865641 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 8a1ce9d5-3953-4612-8124-e10bdf2d8333 1 1466 0
57924 {"from":"7","to":"21"} 27ef9cb6-4f9f-41c0-9e76-672d57b8b8d6 P A 404 0.00 194 0.000 0 0 0 0.00 0 1723748301 1723865628 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 Y 0 A 0 27ef9cb6-4f9f-41c0-9e76-672d57b8b8d6 1 1466 0
57927 {"from":"7","to":"21"} 80717389-cd11-49c9-99ac-a100aecaf1cd P A 404 0.00 184 0.938 0 0 0 0.00 0 1723753276 1723866303 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 Y 0 A 0 80717389-cd11-49c9-99ac-a100aecaf1cd 1 1466 0
57928 {"from":"7","to":"21"} b26eb32e-1968-4ff8-97c4-dc81e3546186 P A 404 0.00 178 0.000 0 0 0 0.00 0 1723764651 1723865698 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 b26eb32e-1968-4ff8-97c4-dc81e3546186 1 1466 0
57929 {"from":"7","to":"21"} 06b18e47-99b0-41f1-b42b-7931d51d2095 P A 404 0.00 182 0.000 0 0 0 0.00 0 1723755950 1723865727 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 Y 0 A 0 06b18e47-99b0-41f1-b42b-7931d51d2095 1 1466 0
57930 {"from":"7","to":"21"} 3788657a-d6df-4391-9fec-ad5d1d35817b P A 404 0.00 181 0.000 0 0 0 0.00 0 1723754399 1723869255 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 Y 0 A 0 3788657a-d6df-4391-9fec-ad5d1d35817b 1 1466 1
57934 {"from":"7","to":"21"} 8837846c-2f7e-456e-8c80-a284532169c4 P A 404 0.00 194 2.000 0 0 0 0.00 0 1723787919 1723865733 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 Y 0 A 0 8837846c-2f7e-456e-8c80-a284532169c4 1 1466 0
57935 {"from":"7","to":"21"} 086bff54-7965-494c-8269-eae8d156ae85 P A 404 0.00 177 2.000 0 0 0 0.00 0 1723789490 1723865685 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 Y 0 A 0 086bff54-7965-494c-8269-eae8d156ae85 0 0 0
57936 {"from":"7","to":"21"} b58dceaf-d451-4848-97b7-d172d5bf5047 P A 404 0.00 163 0.625 0 0 0 0.00 0 1723749351 1723865634 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 b58dceaf-d451-4848-97b7-d172d5bf5047 1 1466 0
57940 {"from":"7","to":"21"} 92be1c51-ca92-493c-bd69-ff59ba0de119 P A 404 0.00 177 0.000 0 0 0 0.00 0 1723748689 1723865703 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 Y 0 A 0 92be1c51-ca92-493c-bd69-ff59ba0de119 1 1466 0
57946 {"from":"7","to":"21"} fa211cc0-b23e-48a6-86bf-1464b0d45e24 P A 404 0.00 181 2.000 0 0 0 0.00 0 1723785864 1723865716 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 Y 0 A 0 fa211cc0-b23e-48a6-86bf-1464b0d45e24 1 1466 1
57947 {"from":"7","to":"21"} 4b1e79cf-4dbb-4480-a216-dfb65d4dd4e0 P A 404 0.00 194 2.000 0 0 0 0.00 0 1723787332 1723865762 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 4b1e79cf-4dbb-4480-a216-dfb65d4dd4e0 1 1466 0
62676 {"from":"7","to":"21"} eb30e9fe-5e50-42ae-999e-2d7a3fb29108 P A 404 0.00 163 0.000 0 0 0 0.00 0 1723755468 1723865587 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 eb30e9fe-5e50-42ae-999e-2d7a3fb29108 1 1466 1
62954 {"from":"7","to":"21"} fa211cc0-b23e-48a6-86bf-1464b0d45e24 P A 404 0.00 181 2.000 0 0 0 0.00 0 1723785864 1723865722 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 Y 0 A 0 fa211cc0-b23e-48a6-86bf-1464b0d45e24 1 1466 0
63369 {"from":"7","to":"21"} P A 404 0.00 100 0.500 0 0 0 0.00 0 1723845686 1723865615 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 Y 0 A 0 1 1480 0
63383 {"from":"7","to":"21"} P A 404 0.00 100 0.500 0 0 0 0.00 0 1723845686 1723865660 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 Y 0 A 0 1 1480 1
63395 {"from":"7","to":"21"} P A 404 0.00 100 0.500 0 0 0 0.00 0 1723845686 1723865744 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 Y 0 A 0 1 1480 0
63407 {"from":"7","to":"21"} P A 404 0.00 100 0.500 0 0 0 0.00 0 1723845686 1723865775 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 Y 0 A 0 1 1480 0
63419 {"from":"7","to":"21"} P A 404 0.00 100 0.500 0 0 0 0.00 0 1723845686 1723865781 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 Y 0 A 0 1 1480 0
63431 {"from":"7","to":"21"} P A 404 0.00 100 0.500 0 0 0 0.00 0 1723845686 1723865787 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 Y 0 A 0 1 1480 0
63443 {"from":"7","to":"21"} P A 404 0.00 100 0.500 0 0 0 0.00 0 1723845686 1723865793 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 Y 0 A 0 0 0 0
63445 {"from":"7","to":"21"} 8837846c-2f7e-456e-8c80-a284532169c4 P A 404 0.00 194 2.000 0 0 0 0.00 0 1723787919 1724882262 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 Y 0 A 0 8837846c-2f7e-456e-8c80-a284532169c4 1 1466 1
63457 {"from":"7","to":"21"} P A 404 0.00 100 0.938 0 0 0 0.00 0 1723845686 1723865680 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 Y 0 A 0 0 0 1
63682 {"from":"7","to":"21"} f32c2c71-c85f-4e94-bb9e-2cee0182d0c6 P A 404 0.00 174 0.000 0 0 0 0.00 0 1723782926 1723874915 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 Y 0 A 0 f32c2c71-c85f-4e94-bb9e-2cee0182d0c6 0 0 0
63684 {"from":"7","to":"21"} fa211cc0-b23e-48a6-86bf-1464b0d45e24 P A 404 0.00 181 2.000 0 0 0 0.00 0 1723785864 1723874700 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 Y 0 A 0 fa211cc0-b23e-48a6-86bf-1464b0d45e24 0 0 0