SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    67662, 67159, 67063, 67062, 67639, 67207, 
    67629, 67628, 67627, 67613, 67589, 
    67514, 66982, 66835, 66813, 65968, 
    67122, 66719, 67363, 67411, 67360, 
    66786, 66785, 66691, 61783, 67303, 
    67302, 67270, 67269, 67268, 67267, 
    67266, 67265, 67264, 67263, 67262, 
    67261, 67260, 67259, 67258
  )

Query time 0.00099

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 40 Using where

Result

product_id product_code product_type 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 exclusive_end_date 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 final_category aggregator aggregator_id ean isrc tbid is_album from_album publisher writers updated_timestamp available_worldwide stream_release_date download_release_date added_timestamp parent_product_id
61783 VCR263 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522969200 0 Y N N B N R Y N N Y 10 1522969200 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Defensive Music Ben Stevens / Dave Neale 1516037421 Y 2021-12-17 17:37:27 0
65968 IOD054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523487600 0 Y N N B N R Y N N Y 10 1523487600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Inside Out Digital Sean Taylor 1517601886 Y 2021-12-17 17:37:27 0
66691 TT016b P A 1 1.69 1 0.000 0 0 0 0.00 0 1522969200 0 Y N N B N R Y N N Y 10 1522969200 1524178800 B 0 0 0 0 6 N 0 P F 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;} 4 labelworx 5054283523447 GBKQU1818644 N Tuff Trax Garett Reimond 1520485213 Y 2021-12-17 17:37:27 0
66719 AAA158 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523055600 0 Y N N B N R Y N N Y 10 1523055600 1524265200 B 0 0 0 0 6 N 0 P F 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;} 3 labelworx 5054283546002 GBKQU1822809 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1520571602 Y 2021-12-17 17:37:27 0
66785 FBR291 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522969200 0 Y N N B N R Y N N Y 10 1522969200 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Dina Watson / Simon Stevens 1520949810 Y 2021-12-17 17:37:27 0
66786 FBR291 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522969200 0 Y N N B N R Y N N Y 10 1522969200 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Dina Watson / Simon Stevens 1520949818 Y 2021-12-17 17:37:27 0
66813 TBF008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523574000 0 Y N N B N R Y N N Y 10 1523574000 0 B 0 0 0 0 6 N 0 P F 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;} 4 N The Bounce Factory Dimtri Bruev / Jamie Russell 1521062178 Y 2021-12-17 17:37:27 0
66835 TT016c P A 1 1.69 1 0.000 0 0 0 0.00 0 1523574000 0 Y N N B N R Y N N Y 10 1523574000 1524783600 B 0 0 0 0 6 N 0 P F 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;} 4 labelworx 5054283545777 GBKQU1822760 N Tuff Trax Sean Taylor 1521090006 Y 2021-12-17 17:37:27 0
66982 HWR002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523574000 0 Y N N B N R Y N N Y 10 1523574000 0 N 0 0 0 0 6 N 0 P F 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;} 4 N Hooverweight Records Sean Inside Out 1711483454 Y 2021-12-17 17:37:27 0
67062 FLA028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523833200 0 Y N N B N R Y N N Y 10 1523833200 1525042800 B 0 0 0 0 6 N 0 P F 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;} 4 labelworx 5054283581409 GBKQU1830598 N FLAUNT Shaun Williams 1522126813 Y 2021-12-17 17:37:27 0
67063 FLA028 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523833200 0 Y N N B N R Y N N Y 10 1523833200 1525042800 B 0 0 0 0 6 N 0 P F 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;} 3 labelworx 5054283581409 GBKQU1830599 N FLAUNT Shaun Williams 1522126813 Y 2021-12-17 17:37:27 0
67122 HOT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523228400 0 Y N N B N R Y N N Y 10 1523228400 1524438000 B 0 0 0 0 6 N 0 P F 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;} 4 labelworx 5054283585933 GBKQU1831958 N Hot Box Digital Matt Wade & Joe Swales 1522126894 Y 2021-12-17 17:37:27 0
67159 HOT003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523833200 0 Y N N B N R Y N N Y 10 1523833200 1525042800 B 0 0 0 0 6 N 0 P F 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;} 4 labelworx 5054283588200 GBKQU1832410 N Hot Box Digital Matt Wade & Jay Goodall 1522213219 Y 2021-12-17 17:37:27 0
67207 RE100 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523660400 0 Y N N B N R Y N N Y 10 1523660400 1524870000 B 0 0 0 0 6 N 0 P F 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;} 4 labelworx 5054283591620 GBKQU1833012 N Relay Records DJ Jaycee 1522386004 Y 2021-12-17 17:37:27 0
67258 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681476 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Defensive Music Ben Stevens / Adam Martin / Mark Tench 1522682159 Y 2021-12-17 17:37:27 0
67259 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681509 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682180 Y 2021-12-17 17:37:27 0
67260 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681541 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682199 Y 2021-12-17 17:37:27 0
67261 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681571 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682218 Y 2021-12-17 17:37:27 0
67262 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681605 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682238 Y 2021-12-17 17:37:27 0
67263 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681657 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Ben Stevens / Adam Martin / Mark Tench 1522682256 Y 2021-12-17 17:37:27 0
67264 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681691 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682273 Y 2021-12-17 17:37:27 0
67265 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681739 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Paul Norris / Adam Martin / Mark Tench 1522682294 Y 2021-12-17 17:37:27 0
67266 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681769 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682311 Y 2021-12-17 17:37:27 0
67267 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681824 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682331 Y 2021-12-17 17:37:27 0
67268 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681855 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682352 Y 2021-12-17 17:37:27 0
67269 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681897 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Frank Farrell / Adam Martin / Mark Tench 1522682371 Y 2021-12-17 17:37:27 0
67270 HOKTCD003DIGI P A 1 1.69 1 0.000 0 0 0 0.00 0 1522681934 0 Y N N B N R Y N N Y 10 1522623600 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Adam Martin / Mark Tench 1522682388 Y 2021-12-17 17:37:27 0
67302 420003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522881657 0 Y N N B N R Y N N Y 10 1522796400 0 B 0 0 0 0 6 N 0 P F 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;} 4 Copyright Co N AL G AL G/Desseminate 1529971325 Y 2021-12-17 17:37:27 0
67303 420004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522881824 0 Y N N B N R Y N N Y 10 1522796400 0 B 0 0 0 0 6 N 0 P F 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;} 4 Copyright Co N Grady G Grady G, Riggsy 1529971313 Y 2021-12-17 17:37:27 0
67360 PDHH092 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522969200 0 Y N N B N R Y N N Y 10 1522969200 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Premonition/Shenton/Smith Matt Smith/Andrew Shenton 1522926546 Y 2021-12-17 17:37:27 0
67363 HLXR047 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523026984 0 Y N N B N R Y N N Y 10 1522969200 0 N 0 0 0 0 6 N 0 P F 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;} 4 GB9W51800003 N Toolbox Publishing Dale West 1641936832 Y 06/04/2018 06/05/2018 2021-12-17 17:37:27 0
67411 HWR011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1522969200 0 Y N N B N R Y N N Y 10 1522969200 0 B 0 0 0 0 6 N 0 P F 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;} 4 UK/LD7/18/00 N Hard West Records Andy McCall 1523101521 Y 2021-12-17 17:37:27 0
67514 HWR012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523574000 0 Y N N B N R Y N N Y 10 1523574000 0 B 0 0 0 0 6 N 0 P F 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;} 4 UK/LD7/18/00 N Hard West Records Ross Baldwin 1523437362 Y 2021-12-17 17:37:27 0
67589 TND015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523574000 0 Y N N B N R Y N N Y 10 1523574000 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Copyright Control Simon Mowling 1523473584 Y 2021-12-17 17:37:27 0
67613 FR054 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523574000 0 Y N N B N R Y N N Y 10 1523574000 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Toolbox Publishing Rob Yellowley 1641474149 Y 13/04/2018 13/05/2018 2021-12-17 17:37:27 0
67627 UBT008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523603614 0 Y N N B N R Y N N Y 10 1523574000 0 N 0 0 0 0 6 N 0 P F 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;} 4 N Hatfish Music Damien Blanes / Dave Owens 1588683976 Y 2021-12-17 17:37:27 0
67628 TBRDR002A P A 1 1.69 1 0.000 0 0 0 0.00 0 1523604334 0 Y N N B N R Y N N Y 10 1523574000 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Truelove Music Paul King / Nik Denton 1523604623 Y 2021-12-17 17:37:27 0
67629 TBRDR002B P A 1 1.69 1 0.000 0 0 0 0.00 0 1523604372 0 Y N N B N R Y N N Y 10 1523574000 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Hatfish Music Nik Denton 1523604643 Y 2021-12-17 17:37:27 0
67639 DD132 P A 1 1.69 1 0.000 0 0 0 0.00 0 1523730887 0 Y N N B N R Y N N Y 10 1523660400 0 B 0 0 0 0 6 N 0 P F 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;} 4 GBKQU1806785 N copyright Control Miric 1523731524 Y 2021-12-17 17:37:27 0
67662 TDOG206 P A 1 1.69 1 0.000 0 0 0 0.00 0 1524010908 0 Y N N B N R Y N N Y 10 1524006000 0 B 0 0 0 0 6 N 0 P F 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;} 4 N Hatfish Dave Owens 1524011419 Y 2021-12-17 17:37:27 0