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

Query time 0.00014

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

Result

product_id
77689
77690
77691
77692
77693
77694
77695
77696
77697
77698
77699
77700
77701
77702
77703
77704
77705
77706
77707
77708
77709
77710
77711
77712
77713
77714
77715
77716