select 
  * 
from 
  cscart_vendor_pages 
where 
  vendor_id = 174

Query time 0.00094

Result

id vendor_id page_id new_items on_sale bestsellers about_us vendor_pages contact
176 174 N N N Y N Y