SELECT 
  product_id 
FROM 
  cscart_product_bundle_product_links 
WHERE 
  bundle_id = 2200 
  AND show_on_product_page = 'N'

Query time 0.00012

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_bundle_product_links ref bundle_id bundle_id 4 const 31 Using where

Result

product_id
125557
125558
125559
125560
125561
125562
125563
125564
125565
125566
125567
125568
125569
125570
125571
125572
125573
125574
125575
125576
125577
125578
125579
125580
125581
125582
125583
125584
125585
125586
125587
125588
125589
125590