SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    124642, 124641, 124640, 124639, 124638, 
    124637, 124636, 124635, 124634, 124633, 
    124632, 124631, 124630, 124629, 124628, 
    124627, 124626, 124625, 124624, 124623, 
    124622, 124621, 124620, 124619
  )

Query time 0.00039

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 24 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
124619 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2412352 N 124643 Copyright Control Various Artists 1715992227 Y 2024-05-18 01:25:03 0
124620 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2401483 N 124643 Copyright Control Various Artists 1715992237 Y 2024-05-18 01:25:03 0
124621 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2411342 N 124643 Copyright Control Various Artists 1715992247 Y 2024-05-18 01:25:04 0
124622 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2405930 N 124643 Copyright Control Various Artists 1715992258 Y 2024-05-18 01:25:04 0
124623 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2407544 N 124643 Copyright Control Various Artists 1715992267 Y 2024-05-18 01:25:04 0
124624 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2411554 N 124643 Copyright Control Various Artists 1715992277 Y 2024-05-18 01:25:04 0
124625 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2412524 N 124643 Copyright Control Various Artists 1715992287 Y 2024-05-18 01:25:04 0
124626 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62323354 N 124643 Copyright Control Various Artists 1715992296 Y 2024-05-18 01:25:04 0
124627 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 TFT202400004 N 124643 Copyright Control Various Artists 1715992306 Y 2024-05-18 01:25:04 0
124628 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62322895 N 124643 Copyright Control Various Artists 1715992315 Y 2024-05-18 01:25:04 0
124629 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2403011 N 124643 Copyright Control Various Artists 1715992325 Y 2024-05-18 01:25:05 0
124630 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62321511 N 124643 Copyright Control Various Artists 1715992335 Y 2024-05-18 01:25:05 0
124631 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62319618 N 124643 Copyright Control Various Artists 1715992343 Y 2024-05-18 01:25:05 0
124632 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62320470 N 124643 Copyright Control Various Artists 1715992353 Y 2024-05-18 01:25:05 0
124633 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62304466 N 124643 Copyright Control Various Artists 1715992365 Y 2024-05-18 01:25:05 0
124634 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 NLG3W2300284 N 124643 Copyright Control Various Artists 1715992375 Y 2024-05-18 01:25:05 0
124635 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62303164 N 124643 Copyright Control Various Artists 1715992385 Y 2024-05-18 01:25:05 0
124636 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62300296 N 124643 Copyright Control Various Artists 1715992394 Y 2024-05-18 01:25:06 0
124637 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2399860 N 124643 Copyright Control Various Artists 1715992406 Y 2024-05-18 01:25:06 0
124638 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBLV62302250 N 124643 Copyright Control Various Artists 1715992416 Y 2024-05-18 01:25:06 0
124639 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2380999 N 124643 Copyright Control Various Artists 1715992428 Y 2024-05-18 01:25:06 0
124640 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2373077 N 124643 Copyright Control Various Artists 1715992438 Y 2024-05-18 01:25:06 0
124641 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2385499 N 124643 Copyright Control Various Artists 1715992446 Y 2024-05-18 01:25:06 0
124642 LWHTS21b P A 1 1.69 1 0.000 0 0 0 0.00 0 1715900400 0 Y N N B N R Y N N Y 10 1715900400 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 5054288241667 GBKQU2374124 N 124643 Copyright Control Various Artists 1715992457 Y 2024-05-18 01:25:06 0