SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    110359, 110330, 110326, 110421, 110420, 
    110418, 110417, 110416, 110415, 110414, 
    110413, 110412, 110411, 110410, 110409, 
    110408, 110407, 110406, 110405, 110404
  )

Query time 0.00041

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
110326 STI335 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668556800 0 Y N N B N R Y N N Y 10 1668556800 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 5054286959083 GBKQU2292437 N Copyright Control Ronnie Carter 1665983701 Y 2022-10-17 06:15:01 0
110330 MQDREP009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668556800 0 Y N N B N R Y N N Y 10 1668556800 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 5054286949800 GBKQU2264675 N +QDance Records David Almarcha, Miguel Bort, Guillermo Tormo 1665984604 Y 2022-10-17 06:30:04 0
110359 STI319 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668729600 0 Y N N B N R Y N N Y 10 1668729600 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 5054286899433 GBKQU2283431 N Copyright Control G. Covington 1666156501 Y 2022-10-19 06:15:01 0
110404 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801324 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286107 Y 2022-10-20 18:15:07 0
110405 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBPSX1300161 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286107 Y 2022-10-20 18:15:07 0
110406 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBPSX1200116 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286108 Y 2022-10-20 18:15:08 0
110407 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBPSX1400009 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286108 Y 2022-10-20 18:15:08 0
110408 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBPSX1700067 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286108 Y 2022-10-20 18:15:08 0
110409 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801282 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286108 Y 2022-10-20 18:15:08 0
110410 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801027 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286108 Y 2022-10-20 18:15:08 0
110411 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801114 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286109 Y 2022-10-20 18:15:09 0
110412 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801326 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286109 Y 2022-10-20 18:15:09 0
110413 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801228 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286109 Y 2022-10-20 18:15:09 0
110414 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1400573 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286109 Y 2022-10-20 18:15:09 0
110415 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801332 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286110 Y 2022-10-20 18:15:10 0
110416 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801276 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286110 Y 2022-10-20 18:15:10 0
110417 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBPSX1800009 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286110 Y 2022-10-20 18:15:10 0
110418 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801018 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286110 Y 2022-10-20 18:15:10 0
110420 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBPSX1700044 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286111 Y 2022-10-20 18:15:11 0
110421 SDA013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1668470400 0 Y N N B N R Y N N Y 10 1668470400 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 5054286987147 GBACW1801183 N 110422 PEER MUSIC K.armstrong, M.elliott, L.marie, S.hanley, A.laddin, D, Edgecombe, D.laxton, J.hughes, L.avecedo 1666286111 Y 2022-10-20 18:15:11 0