SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62406, 63202, 61213, 62430, 64775, 65002, 
    65006, 65046, 65014, 65010, 65054, 
    64998, 65042, 65071, 64994, 65066, 
    65125, 65058, 65050, 65018, 65033, 
    65115, 65038, 65110
  )

Query time 0.00101

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 (62406,63202,61213,62430,64775,65002,65006,65046,65014,65010,65054,64998,65042,65071,64994,65066,65125,65058,65050,65018,65033,65115,65038,65110)"
    }
  }
}

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
61213 BLE-G-LAR-LED P E C M W D 0 A 1 510.00 1000 0.000 0 0 0 0.00 0 1336017600 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;} 1738605296 Price increased by $68 - DC 2/19/20 Price increased 5% from $500 to $525 - DC 6/1/21 Price decreased from $525 to $399 - DC 12/13/21 Price increased 10% from $399 to $439 - DC 6/2/22 Price increased from $439 to $510 - DC 10/31/22 Y none none 1683,1684 BLE-G {"22952":3,"22644":11,"22675":10,"22645":12,"23188":9,"22254":7,"22040":8,"23556":6} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
62406 BLE-G-ULS-LED P E C M W D 0 A 1 525.00 1000 0.000 0 0 0 0.00 0 1401681600 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;} 1776715425 Price increased by $68 - DC 2/17/20 Price increased 5% from $422 to $443 - DC 6/1/21 Price decreased by $38 - DC 12/10/21 Price increased 10% from $405 to $446 - DC 6/2/22 Price increased from $446 to $525 - DC 10/31/22 Y none none 1648,1649,1650 BLE-G {"23116":12,"22644":13,"22861":6,"22862":6,"22863":8,"22864":8,"22865":8,"22872":9,"22852":10,"22873":11,"22874":11,"22875":11} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
62430 BLE-G-ULC-LED P E C M W D 0 A 1 595.00 1000 0.000 0 0 0 0.00 0 1401681600 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;} 1732201267 Price increased by $68 - DC 3/11/20 Price increased 5% from $463 to $486 - DC 6/1/21 Price decreased by $41 - DC 10/28/21 Price increased 10% from $445 to $490 - DC 6/2/22 Price increased from $490 to $595 - DC 11/1/22 Y none none 1891,1892,1893 BLE-G {"22117":3,"23116":9,"22644":10,"22598":6,"22599":6,"22592":7,"22594":8,"22595":8,"22596":8} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
63202 BLE-G-LAR-CGG-LED P E C M W D 0 A 1 570.00 1000 0.000 0 0 0 0.00 0 1432612800 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;} 1732201268 Price increased by $68 - DC 3/13/20 Price increased 5% from $573 to $602 - DC 6/1/21 Price increased 10% from $602 to $663 - DC 6/2/22 Price decreased from $663 to $570 - DC 10/31/22 Y none none 1908,1909,1910 BLE-G {"23311":2,"22714":4,"22035":6,"21970":3,"22659":7,"21933":9,"21934":9,"21935":9,"22034":8,"22697":9,"22698":9,"23304":9,"22345":9,"23116":11,"22644":12,"23328":9} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64775 BLE-G-SI P E C P W A 0 A 1 315.00 1000 0.000 0 0 0 0.00 0 1565717079 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;} 1753280122 Price decreased by $20 - DC 5/12/21 38% commercial discount to base price manually added - DC 5/12/21 Price increased 5% from $268 to $281 - DC 5/24/21 Price increased 10% from $281 to $310 - DC 6/2/22 Price increased from $310 to $315 - DC 11/4/22 Y none none 372,373,1983 BLE-G {"22348":6,"22349":6,"22353":8,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11,"21941":12} 1008383 0 0 0 1 0 0 0 0 1 0.00 0
64994 BLE-G-DCS-LED P E C M W D 0 A 1 410.00 1000 0.000 0 0 0 0.00 0 1580149049 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;} 1769536426 Price increased by $68 - DC 1/27/20 Price increased 5% from $385 to $404 - DC 6/1/21 Price decreased from $404 - DC 12/15/21 Price increased 10% from $386 to $425 - DC 6/2/22 Price decreased from $425 to $410 - DC 11/1/22 Y none none 1316,1317,1318 BLE-G {"22646":7,"22649":9,"22650":9,"22648":9,"22643":10,"22644":11,"22645":12,"22254":7,"22675":10} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
64998 BLE-G-WHE10-LED P E C M W D 0 A 1 405.00 1000 0.000 0 0 0 0.00 0 1580225477 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;} 1769536795 Price increased by $68 - DC 1/28/20 Price increased 5% from $397 to $417 - DC 6/1/21 Price increased by $9 - DC 10/28/21 Price increased 10% from $426 to $469 - DC 6/2/22 Price increased from $469 to $405 - DC 11/1/22 Y none none 1329,1330,1356 BLE-G-WHE10 {"22646":7,"22649":9,"22650":9,"22648":9,"22643":10,"22644":11,"22645":12,"23141":10,"23137":10,"23136":10,"21927":2,"23159":3,"22012":5,"21931":5,"21930":5,"21968":8,"21969":8,"21939":8,"21938":8,"22675":10} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65002 BLE-G-WHD-LED P E C M W D 0 A 1 415.00 1000 0.000 0 0 0 0.00 0 1580240254 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;} 1769458775 Price increased by $68 - DC 1/28/20 Price increased 5% from $461 to $484 - DC 6/1/21 Price decreased by $64 - DC 10/28/21 Price increased 10% from $420 to $462 - DC 6/2/22 Price decreased from $462 to $415 - DC 10/29/22 Y none none 1340,1341,1342 BLE-G {"22646":8,"22649":10,"22650":10,"22648":10,"22643":10,"22644":12,"22645":13,"23141":10,"23137":10,"23136":11,"23161":11,"21930":6,"21931":6,"22012":6,"21969":9,"21968":9,"21939":9,"21938":9} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65006 BLE-G-OI-LED P E C P W A 0 A 1 535.00 1000 0.000 0 0 0 0.00 0 1580327312 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;} 1769186614 Price increased by $68 - DC 1/29/20 Price increased 5% from $431 to $453 - DC 6/1/21 Price decreased $78 from $453 to $375 - DC 12/2/21 Price increased 10% from $375 to $413 - DC 6/2/22 Price increased from $413 to $535 - DC 11/7/22 Y none none 1352,1353 BLE-G {"23116":12,"22644":13,"22348":6,"22349":6,"22353":8,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65010 BLE-G-CI-LED P E C P W A 0 A 1 545.00 1000 0.000 0 0 0 0.00 0 1580393358 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;} 1769185091 Price increased by $68 - DC 1/30/20 Price increased 5% from $431 to $453 - DC 6/1/21 Price decreased $74 from $453 to $379 - DC 12/2/21 Price increased 10% from $379 to $417 - DC 6/2/22 Price increased from $417 to $545 - DC 11/4/22 Y none none 1362,1363 BLE-G {"23116":12,"22644":13,"22348":6,"22349":6,"22353":8,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65014 BLE-G-SI-LED P E C P W A 0 A 1 535.00 1000 0.000 0 0 0 0.00 0 1580404418 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;} 1769189684 Price increased by $68 - DC 2/7/20 Price increased 5% from $431 to $453 - DC 6/1/21 Price decreased $73 from $453 to $380 - DC 12/2/21 Price increased 10% from $380 to $418 - DC 6/2/22 Price increased from $418 to $535 - DC 11/4/22 Y none none 1372,1373 BLE-G {"23116":12,"22644":13,"22348":6,"22349":6,"22353":8,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65018 BLE-G-AI-LED P E C P W A 0 A 1 560.00 1000 0.000 0 0 0 0.00 0 1580415257 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;} 1769184451 Price increased by $68 - DC 1/30/20 Price increased 5% from $431 to $453 - DC 6/1/21 Price increased 10% from $453 to $499 - DC 6/2/22 Price increased from $499 to $560 - DC 11/7/22 Y none none 1380,1381 BLE-G {"23116":12,"22644":13,"22348":6,"22349":6,"22353":8,"22365":9,"22355":10,"22356":10,"22357":11,"22358":11,"22359":11,"22360":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65033 BLE-G-WHA-CGG-LED P E C P W A 0 A 1 475.00 1000 0.000 0 0 0 0.00 0 1580747465 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;} 1777900056 Price increased by $68 - DC 2/3/20 Price increased 5% from $503 to $528 - DC 6/1/21 Price increased 10% from $528 to $581 - DC 6/2/22 Price decreased from $581 to $475 - DC 10/28/2022 Y none none 1419,1420,1421 BLE-G {"23116":12,"22644":13,"22195":2,"22659":8,"21930":6,"21931":6,"22012":6,"23328":10,"21935":10,"21934":10,"21933":10,"21936":9,"21937":9,"21974":11,"21975":11,"22052":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65038 BLE-G-WHU-CGG-LED P E C P W A 0 A 1 485.00 1000 0.000 0 0 0 0.00 0 1580754758 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;} 1769444101 Price increased by $68 - DC 2/3/20 Price increased 5% from $495 to $520 - DC 6/1/21 Price increased 10% from $520 to $572 - DC 6/2/22 Price decreased from $572 to $485 - DC 10/28/22 Y none none 1437,1439,1440 BLE-G {"23116":12,"22644":13,"22659":8,"21930":6,"21931":6,"22012":6,"23328":10,"21935":10,"21934":10,"21933":10,"21936":9,"21937":9,"21974":11,"21975":11,"22052":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65042 BLE-G-WHB-CGG-LED P E C P W A 0 A 1 515.00 1000 0.000 0 0 0 0.00 0 1580762273 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;} 1769191798 Price increased by $68 - DC 2/3/20 Price increased 5% from $493 to $518 - DC 6/1/21 Price increased 10% from $518 to $570 - DC 6/2/22 Price decreased from $570 to $515 - DC 10/24/22 Y none none 1453,1455,1456 BLE-G {"23116":11,"22644":12,"22659":7} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65046 BLE-G-SBA-CGG-LED P E C P W A 0 A 1 485.00 1000 0.000 0 0 0 0.00 0 1580838640 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;} 1769444157 Price increased 5% from $486 to $510 - DC 6/1/21 Price decreased from $510 to $402 - DC 12/13/21 Price increased 10% from $402 to $443 - DC 6/2/22 Price increased from $443 to $485 - DC 10/28/22 Y none none 1469,1471,1472 BLE-G {"22659":8,"23116":12,"22644":13,"21930":6,"21931":6,"22012":6,"23328":10,"21935":10,"21934":10,"21933":10,"21936":9,"21937":9,"21974":11,"21975":11,"22052":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65050 BLE-G-SBD-CGG-LED P E C M W A 0 A 1 465.00 1000 0.000 0 0 0 0.00 0 1580849387 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;} 1769455824 Price increased by $68 - DC 2/4/20 Price increased 5% from $500 to $525 - DC 6/1/21 Price increased 10% from $525 to $578 - DC 6/2/22 Price decreased from $578 to $465 - DC 10/31/22 Y none none 1485,1487,1488 BLE-G {"23116":12,"22644":13,"22659":8,"21930":6,"21931":6,"22012":6,"23328":10,"21935":10,"21934":10,"21933":10,"21936":9,"21937":9,"21974":11,"21975":11,"22052":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65054 BLE-G-WHD-CGG-LED P E C M W A 0 A 1 520.00 1000 0.000 0 0 0 0.00 0 1580924725 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;} 1769191347 Price Increased by $68 - DC 2/5/20 Price increased 5% from $516 to $542 - DC 6/1/21 Price increased 10% from $542 to $597 - DC 6/2/22 Price decreased from $597 to $475 - DC 10/29/22 Price increased by $45 - DC 7/18/23 Y none none 1501,1503,1504 BLE-G {"22659":7,"23116":11,"22644":12} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65058 BLE-G-RWS-CGG-LED P E C M W A 0 A 1 495.00 1000 0.000 0 0 0 0.00 0 1581003885 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;} 1769198189 Price increased by $68 - DC 2/6/20 Price increased 5% from $522 to $548 - DC 6/1/21 Price increased 10% from $548 to $603 - DC 6/2/22 Price decreased from $603 to $495 - DC 10/28/22 Y none none 1517,1519,1520 BLE-G {"22659":7,"23116":11,"22644":12} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65066 BLE-G-YDM-CGG-LED P E C P W A 0 A 1 465.00 1000 0.000 0 0 0 0.00 0 1581024107 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;} 1775230049 Price increased 5% from $473 to $497 - DC 6/1/21 Price increased 10% from $497 to $547 - DC 6/2/22 Price decreased from $547 to $465 - DC 10/31/22 Y none none 1549,1551,1554 BLE-G {"22659":7,"23116":11,"22644":12} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65071 BLE-G-DBW-CGG-LED P E C M W A 0 A 1 465.00 1000 0.000 0 0 0 0.00 0 1581099637 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;} 1767904240 Price increased by $89 - DC 2/7/20 Price increased 5% from $499 to $524 - DC 6/1/21 Price increased 10% from $524 to $577 - DC 6/2/22 Price decreased from $577 to $465 - DC 10/17/22 Y none none 1566,1568,1569 BLE-G {"22659":8,"23116":12,"22644":13,"22049":6,"22050":6,"22051":6,"23328":10,"22148":10,"22147":10,"22146":10,"22149":9,"22150":9,"22053":11,"22054":11,"22055":11} 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65110 BLE-G-MIL-LED P E C M A D 0 A 1 715.00 1000 0.000 0 0 0 0.00 0 1587134008 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;} 1767381840 Price increased by $68 - DC Price increased 5% from $678 to $712 - DC 6/3/21 Price increased 10% from $712 to $784 - DC 6/2/22 Price decreased from $784 to $715 - DC 11/8/22 Y none none 2387,2388,2389 BLE-G 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65115 BLE-G-OIL-LED P E C M A D 0 A 1 725.00 1000 0.000 0 0 0 0.00 0 1587484631 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;} 1767382113 Price increased by $68 - DC Price increased 5% from $669 to $702 - DC 6/3/21 Price increased 10% from $702 to $773 - DC 6/2/22 Price decreased from $773 to $725 - DC 11/8/22 Y none none 2407,2408,2409 BLE-G 1056013 0 0 0 1 0 0 0 0 1 0.00 0
65125 BLE-G-LDBW-LED P E C M A D 0 A 1 735.00 1000 0.000 0 0 0 0.00 0 1587648449 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;} 1767382145 Price increased by $68 - DC Price increased 5% from $723 to $759 - DC 6/3/21 Price increased 10% from $759 to $835 - DC 6/2/22 Price decreased from $835 to $735 - DC 11/8/22 Y none none 2447,2448,2449 BLE-G 1056013 0 0 0 1 0 0 0 0 1 0.00 0