SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    64916, 62863, 64359, 64374, 64375, 64470, 
    62654, 62657, 64961, 62648, 64930, 
    62653, 64990, 62655, 64986, 62656, 
    64978, 64972, 64926, 64968, 64934, 
    65074, 65030, 64982
  )

Query time 0.00073

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_products",
      "access_type": "range",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 24,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (64916,62863,64359,64374,64375,64470,62654,62657,64961,62648,64930,62653,64990,62655,64986,62656,64978,64972,64926,64968,64934,65074,65030,64982)"
    }
  }
}

Result

product_id product_code product_type trustmark_origin trustmark_certified trustmark_leadtime trustmark_location trustmark_return owner_id status company_id list_price amount weight length width height shipping_freight low_avail_limit 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 updated_timestamp pricing_note use_new_layout category_image tax_code upc_code product_detail_ids nav_sku sku_columns nav_review_user_id hide_price vendor_fulfilled hide_commercial_price non_returnable ble_basics commercial_hidden allow_configurator enable_customize enable_buy_american base_cost redline_p
62648 BLE-C-WGGWS-CN36-LED P E C M A D 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1407470400 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1747928087 Price increased 5% from $402 to $422 - DC 6/1/21 Price increased 10% from $422 to $465 - DC 6/2/22 Price increased from $465 to $495 - DC 11/3/22 Y none none 1600,1601 BLE-C {"21970":3,"21951":4,"21954":6,"22587":8,"23116":9,"22644":10} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
62653 BLE-CN-CGG P E C M A D 0 A 1 560.00 1000 0.000 0 0 0 0.00 0 1407729600 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1776883882 Price increased 5% from $335 to $352 - DC 6/1/21 Price increased 10% from $352 to $388 - DC 6/2/22 Price increased from $388 to $560 - DC 11/4/22 Y images/category_images/more-styles-available-industrial-guard-chain-navy-galvanized.jpg none none 1053,1054 BLE-CN-CGG {"23050":1,"21951":2,"21954":4,"23051":5,"23015":6,"23016":7,"23020":8,"23019":8,"23018":8,"22644":10,"23116":9,"21970":1,"24042":7} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62654 BLE-CN-ULM-LED P E C M A D 0 A 1 545.00 1000 0.000 0 0 0 0.00 0 1407729600 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1753285765 Price increased 5% from $412 to $433 - DC 6/1/21 Price increased from $433 to $439 - DC 12/10/21 Price increased 10% from $439 to $483 - DC 6/2/22 Price increased from $483 to $545 - DC 10/31/22 Y none none 1638,1639,1640 BLE-CN {"21951":4,"21954":7,"23116":12,"22644":13,"22889":6,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62655 BLE-CN-ULA-LED P E C M A D 0 A 1 625.00 1000 0.000 0 0 0 0.00 0 1407729600 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1753286496 Price increased 5% from $424 to $445 - DC 6/1/21 Price decreased from $445 to $423 - DC 12/10/21 Price increased 10% from $423 to $466 - DC 6/2/22 Price increased from $466 to $625 - DC 10/26/22 Y none none 1608,1609,1610 BLE-CN {"21951":4,"21954":7,"23116":12,"22644":13,"22889":6,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62656 BLE-CN-ULS-LED P E C M A D 0 A 1 555.00 1000 0.000 0 0 0 0.00 0 1407729600 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1753285467 Price increased 5% from $412 to $433 - DC 6/1/21 Price decreased by $7 - DC 12/10/21 Price increased 10% from $433 to $469 - DC 6/2/22 Price increased from $469 to $555 - DC 10/31/22 Y none none 1654,1655,1656 BLE-CN {"21951":4,"21954":7,"23116":12,"22644":13,"22889":6,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62657 BLE-CN-ULO-LED E C M A D 0 A 1 615.00 1000 0.000 0 0 0 0.00 0 1407729600 0 N N N D N P N N N Y 30 0 N 0 0 0 0 13 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;} 1747927039 Price increased 5% from $402 to $422 - DC 6/1/21 Price increased 10% from $422 to $465 - DC 6/2/22 Price increased from $465 to $615 - DC 10/31/22 Y none none 1623,1624,1625 BLE-CN {"21951":4,"23116":12,"22644":13,"21954":7,"22889":6,"22872":9,"22852":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62863 BLE-C-SCH-CN36-LED P E C M A D 0 A 1 545.00 1000 0.000 0 0 0 0.00 0 1418878800 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1757952737 Price increased 5% from $528 to $554 - DC 6/1/21 Price increased 10% from $554 to $610 - DC 6/2/22 Price decreased from $610 to $475 - DC 11/3/22 Price increased from $475 to $545 - DC 2/24/23 Y none none 1590,1591,1592 BLE-C {"21951":4,"22817":6,"21954":7,"22796":9,"22797":9,"22795":9,"22794":9,"22798":10,"22675":12,"22644":13,"23182":3} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64359 BLE-CN-LBP-LED P 0 A 1 510.00 1000 0.000 0 0 0 0.00 0 1514302604 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1747927935 Price increased 5% from $424 to $445 - DC 6/1/21 Price increased 10% from $445 to $490 - DC 6/2/22 Price decreased from $490 to $510 - DC 11/8/22 Y none none 2986,2987 BLE-CN-LBP {"23465":0,"23466":0,"23467":0,"23468":0,"21970":1,"21951":2,"22588":3,"21954":4} 0 0 0 0 1 0 0 0 0 1 0.00 0
64374 BLE-CN-CYLM-LED P E C M A A 0 A 1 425.00 1000 0.000 0 0 0 0.00 0 1516126654 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1747928288 Price increased 5% from $363 to $381 - DC 6/1/21 Price increased 10% from $381 to $420 - DC 6/2/22 Price increased from $420 to $425 - DC 11/1/22 Y none none 733,734 BLE-CN-CYLM-LRG {"22856":3,"21951":4,"21954":6,"22904":7,"23116":9,"22644":10} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64375 BLE-CN-CYLV-LED P E C M A A 0 A 1 425.00 1000 0.000 0 0 0 0.00 0 1516126913 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1747928311 Price increased 5% from $363 to $381 - DC 6/1/21 Price increased 10% from $381 to $420 - DC 6/2/22 Price increased from $420 to $425 - DC 11/1/22 Y none none 727,728 BLE-CN-CYLV-LRG {"22855":3,"21951":4,"21954":6,"22904":7,"22644":10,"23116":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64470 BLE-C-SCH-LED P E C M A D 0 A 1 839.00 1000 0.000 0 0 0 0.00 0 1524493051 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1757953108 Price increased 5% from $726 to $762 - DC 6/1/21 Price increased 10% from $762 to $839 - DC 6/2/22 Y none none 1677,1678,1679 BLE-CN-SCH {"23182":3,"21951":4,"21954":5} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64916 BLE-CN-WHS-LED P E C M A D 0 A 1 445.00 1000 0.000 0 0 0 0.00 0 1572280889 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1767726043 Price increased 5% from $402 to $422 - DC 6/1/21 Price increased 10% from $422 to $465 - DC 6/2/22 Price decreased from $465 to $445 - DC 10/12/22 Y none none 840,841,842 BLE-CN {"21951":4,"21954":7,"22646":8,"22643":10,"22644":12,"22645":13,"23139":11,"23138":11,"23136":11,"21952":6,"21953":6,"21938":9,"21939":9,"21968":9,"21969":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64926 BLE-CN-SBA-LED P E C M A D 0 A 1 455.00 1000 0.000 0 0 0 0.00 0 1573846855 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1769457994 Price increased 5% from $450 to $472 - DC 6/1/21 Price decreased from $472 to $418 - DC 12/13/21 Price increased 10% from $418 to $460 - DC 6/2/22 Price decreased from $460 to $455 - DC 10/28/22 Y none none 945,946,947 BLE-CN {"21951":4,"21954":7,"22646":7,"22644":12,"22645":13,"22643":10,"23142":11,"23136":10,"22254":8,"21952":6,"21953":6,"21938":9,"21939":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64930 BLE-CN-WHA-LED P E C M A D 0 A 1 445.00 1000 0.000 0 0 0 0.00 0 1574100992 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1777899960 Price increased 5% from $420 to $441 - DC 6/1/21 Price increased 10% from $441 to $486 - DC 6/2/22 Price decreased from $486 to $445 - DC 10/28/2022 Y none none 959,960,961 BLE-CN {"21951":4,"21954":6,"22646":7,"22643":10,"22644":11,"22645":12,"23141":10,"23137":10,"23136":10} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64934 BLE-CN-SBD-LED P E C M A D 0 A 1 435.00 1000 0.000 0 0 0 0.00 0 1574109613 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1775140258 Price increased 5% from $410 to $430 - DC 6/1/21 Price increased by $45 - DC 10/28/21 Price increased 10% from $430 to $523 - DC 6/2/22 Price decreased from $523 to $435 - DC 10/31/22 Y none none 971,972,973,2874 BLE-CN {"21951":4,"21954":7,"22646":7,"22643":11,"22644":12,"22645":13,"22254":8,"21952":6,"21953":6,"21938":9,"21939":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64961 BLE-CN-DBW-LED P E C M A D 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1577821743 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1769197861 Price increased 5% from $450 to $472 - DC 6/1/21 Price increased 10% from $472 to $520 - DC 6/2/22 Price decreased from $520 to $435 - DC 10/17/22 Price increased from $435 to $495 - DM 8/22/23 Y none none 1207,1208,1209 BLE-CN {"21951":4,"21954":7,"23102":8,"22643":10,"22644":12,"22645":13,"23143":11,"23138":11,"23137":11,"23136":11,"22174":6,"22175":6,"22155":9,"22153":9,"22154":9,"22151":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64968 BLE-CN-WHB-LED P E C M A D 0 A 1 485.00 1000 0.000 0 0 0 0.00 0 1578342057 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1769443889 Price increased 5% from $427 to $448 - DC 6/1/21 Price decreased by $32 - DC 10/28/21 Price increased 10% from $482 to $531 - DC 6/2/22 Price decreased from $531 to $485 - DC 10/24/22 Y none none 1225,1226,1227 BLE-CN {"21951":4,"21954":6,"22646":7,"22643":10,"22644":11,"22645":12,"23144":10,"23137":10,"23136":10,"22254":7} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64972 BLE-CN-WHU-LED P E C M A D 0 A 1 455.00 1000 0.000 0 0 0 0.00 0 1578586189 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1775138382 Price increased 5% from $373 to $392 - DC 6/1/21 Price increased from $392 to $420 - DC 12/13/21 Price increased 10% from $420 to $462 - DC 6/2/22 Price decreased from $462 to $455 - DC 10/28/22 Y none none 1243,1244,1245 BLE-CN {"21951":4,"21954":7,"22646":8,"22643":10,"22644":12,"22645":13,"23140":11,"23136":11,"23137":11,"21952":6,"21953":6,"21938":9,"21939":9,"21968":9,"21969":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64978 BLE-CN-RWS-LED P E C M A D 0 A 1 465.00 1000 0.000 0 0 0 0.00 0 1579192829 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1769455587 Price increased 5% from $430 to $452 - DC 6/1/21 Price decreased by $28 - DC 10/28/21 Price increased 10% from $424 to $467 - DC 6/2/22 Price decreased from $467 to $465 - DC 10/28/22 Y none none 1263,1264,1265 BLE-CN {"21951":4,"21954":6,"22646":7,"22643":10,"22644":9,"22645":10,"22675":8} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64982 BLE-CN-YDM-LED P E C M A D 0 A 1 435.00 1000 0.000 0 0 0 0.00 0 1579631918 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1775141069 Price increased 5% from $438 to $460 - DC 6/1/21 Price decreased by $31 - DC 10/28/21 Price increased 10% from $429 to $472 - DC 6/2/22 Price decreased from $472 to $435 - DC 10/31/22 Y none none 1280,1281,1282 BLE-CN {"21951":4,"21954":7,"22646":7,"22643":10,"22644":12,"22645":13,"23132":11,"22280":6,"22281":6,"23123":8,"22260":9,"22261":9,"22262":9,"22263":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64986 BLE-CN-FCC-LED P E C M A D 0 A 1 430.00 1000 0.000 0 0 0 0.00 0 1579721171 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1769534956 Price increased 5% from $412 to $433 - DC 6/1/21 Price decreased from $433 - DC 12/16/21 Price increased 10% from $425 to $468 - DC 6/2/22 Price increased by $13 to account for removing 10" shade - DC 6/22/22 Price decreased from $481 to $430 - DC 11/1/22 Y none none 1292,1293,1294 BLE-CN {"21951":4,"21954":6,"22646":7,"22643":10,"22644":9,"22645":10,"23132":8} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
64990 BLE-CN-SBS-LED P E C M A D 0 A 1 430.00 1000 0.000 0 0 0 0.00 0 1579795948 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1774368049 Price increased 5% from $408 to $428 - DC 6/1/21 Price decreased from $428 to $415 - DC 12/10/21 Price increased 10% from $415 to $457 - DC 6/2/22 Price decreased from $457 to $430 - DC 11/1/22 Y none none 1304,1305,1306 BLE-CN {"21951":4,"21954":6,"22646":7,"22643":10,"22644":11,"22645":12,"23132":10,"22254":7} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65030 BLE-CN-WHS-CGG-LED P E C M A A 0 A 1 505.00 1000 0.000 0 0 0 0.00 0 1580497786 0 N N N D N P N N N Y 10 0 N 0 0 0 0 13 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;} 1774379452 Price increased 5% from $480 to $504 - DC 6/1/21 Price increased 10% from $504 to $555 - DC 6/2/22 Price decreased from $555 to $505 - DC 10/17/22 Y none none 1408,1410,1411 BLE-CN {"21951":4,"21954":7,"23116":12,"22644":13,"22659":8,"21952":6,"21953":6,"21933":10,"21934":10,"21935":10,"23328":10,"21936":9,"21937":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65074 BLE-CN-DBW-CGG-LED P E C P A A 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1581351459 0 N N N D N R N N N Y 10 0 N 0 0 0 0 13 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;} 1767905081 Price increased 5% from $525 to $551 - DC 6/1/21 Price increased 10% from $551 to $607 - DC 6/2/22 Price decreased from $607 to $495 - DC 10/17/22 Y none none 1577,1579,1580 BLE-CN {"21951":4,"21954":7,"23116":12,"22644":13,"22659":8,"22174":6,"22175":6,"22146":10,"22147":10,"22148":10,"23328":10,"22149":9,"22150":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0