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

Query time 0.00013

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 21 Using where

Result

product_id
111732
111733
111734
111735
111736
111737
111738
111739
111740
111741
111742
111743
111744
111745
111746
111747
111748
111749
111750
111751
111752
111753
111754
111755
111756