SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    119395, 119394, 119393, 119392, 119391, 
    119390, 119389, 119388, 119387, 119386, 
    119385, 119384, 119383, 119382, 119381, 
    119380, 119379, 119378, 119377, 119376, 
    119375, 119374, 119373
  )

Query time 0.00044

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 23 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
119373 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300043 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585638 Y 2023-11-10 04:07:18 0
119374 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300044 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585642 Y 2023-11-10 04:07:22 0
119375 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300045 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585648 Y 2023-11-10 04:07:28 0
119376 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300046 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585655 Y 2023-11-10 04:07:35 0
119377 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300047 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585671 Y 2023-11-10 04:07:51 0
119378 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300048 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585680 Y 2023-11-10 04:08:00 0
119379 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300049 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585705 Y 2023-11-10 04:08:25 0
119380 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300050 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585708 Y 2023-11-10 04:08:28 0
119381 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300051 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585714 Y 2023-11-10 04:08:34 0
119382 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300052 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585718 Y 2023-11-10 04:08:38 0
119383 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300053 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585722 Y 2023-11-10 04:08:42 0
119384 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300054 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585727 Y 2023-11-10 04:08:47 0
119385 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300055 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585730 Y 2023-11-10 04:08:50 0
119386 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300056 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585732 Y 2023-11-10 04:08:52 0
119387 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300057 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585735 Y 2023-11-10 04:08:55 0
119388 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300058 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1707469903 Y 2023-11-10 04:08:58 0
119389 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300059 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585740 Y 2023-11-10 04:09:00 0
119390 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300060 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1707469947 Y 2023-11-10 04:09:05 0
119391 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300061 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1716367874 Y 2023-11-10 04:09:08 0
119392 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300062 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585750 Y 2023-11-10 04:09:10 0
119393 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300063 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1707469911 Y 2023-11-10 04:09:17 0
119394 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300064 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585765 Y 2023-11-10 04:09:25 0
119395 TDV25TD P A 1 1.69 1 0.000 0 0 0 0.00 0 1700179200 0 Y N N B N R Y N N Y 10 1700179200 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 5054287759903 GBLV62300065 N 119396 Tidy Publishing, Truelove Music Tony De Vit, Simon Parkes 1699585771 Y 2023-11-10 04:09:31 0