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

Query time 0.00038

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

Result

product_id
103703
103704
103705
103706
103707
103708
103709
103710
103711
103712
103713
103714
103715
103716