SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    106065, 106064, 106063, 106062, 106060, 
    106059, 106058, 106057, 106056, 106055, 
    106054, 106053, 105009, 105008, 105007, 
    105006, 105005, 105004, 105003, 106207
  )

Query time 0.00046

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 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
105003 ThHR22004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649113200 0 Y N N B N R Y N N Y 10 1649113200 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;} labelworx 5054286516354 GBKQU2223086 N Twisted Hardcore Records Valeria M. 1646543105 Y 2022-03-06 06:05:05 0
105004 ThHR22004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649113200 0 Y N N B N R Y N N Y 10 1649113200 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;} labelworx 5054286516354 GBKQU2223087 N Twisted Hardcore Records Valeria M. 1646543106 Y 2022-03-06 06:05:06 0
105005 DARKUG005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649113200 0 Y N N B N R Y N N Y 10 1649113200 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;} labelworx 5054286488989 GBKQU2218182 N Copyright Control R.Santi 1646543107 Y 2022-03-06 06:05:07 0
105006 DARKUG005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649113200 0 Y N N B N R Y N N Y 10 1649113200 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;} labelworx 5054286488989 GBKQU2218183 N Copyright Control R.Santi 1646543107 Y 2022-03-06 06:05:07 0
105007 DARKUG005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649113200 0 Y N N B N R Y N N Y 10 1649113200 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;} labelworx 5054286488989 GBKQU2218184 N Copyright Control R.Santi 1646543108 Y 2022-03-06 06:05:08 0
105008 DARKUG005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649113200 0 Y N N B N R Y N N Y 10 1649113200 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;} labelworx 5054286488989 GBKQU2218185 N Copyright Control R.Santi 1646543108 Y 2022-03-06 06:05:08 0
105009 DARKUG005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649113200 0 Y N N B N R Y N N Y 10 1649113200 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;} labelworx 5054286488989 GBKQU2218186 N Copyright Control R.Santi 1646543108 Y 2022-03-06 06:05:08 0
106053 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 0 B 0 0 0 0 6 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;} labelworx 5028386719434 GBACW1801312 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1649416405 Y 2022-03-28 20:15:03 0
106054 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801313 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494904 Y 2022-03-28 20:15:04 0
106055 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801314 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494904 Y 2022-03-28 20:15:04 0
106056 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801315 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494904 Y 2022-03-28 20:15:04 0
106057 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801316 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494904 Y 2022-03-28 20:15:04 0
106058 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801317 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494904 Y 2022-03-28 20:15:04 0
106059 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801318 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494905 Y 2022-03-28 20:15:05 0
106060 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801319 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494905 Y 2022-03-28 20:15:05 0
106062 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801321 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494905 Y 2022-03-28 20:15:05 0
106063 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801322 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494905 Y 2022-03-28 20:15:05 0
106064 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801324 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494906 Y 2022-03-28 20:15:06 0
106065 SD200 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649199600 0 Y N N B N R Y N N Y 10 1649199600 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;} labelworx 5028386719434 GBACW1801325 N 106067 Peer Music S.Antill, R.Leigh Aird, J.Keeble, K.Martin, K.Haynes, K.Armstrong, T.Mansfield, A.Cavendish, M.Elliot, R. Gallagher, B.Mansfield, S.Pasternak, C.Cutting, D.Rowland, A.Schilier, B.Mansfield, T.Mansfield, D. Wignall, D.Edgecombe, S.Theobald, J.Michael Peter 1648494906 Y 2022-03-28 20:15:06 0
106207 Ycore45 P A 1 1.69 1 0.000 0 0 0 0.00 0 1649026800 0 Y N N B N R Y N N Y 10 1649026800 0 B 0 0 0 0 6 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;} labelworx 5054286589471 GBKQU2234923 N Copyright Control L Pilling 1649416390 Y 2022-04-01 18:45:02 0