select 
  * 
from 
  cscart_vendor_pages 
where 
  vendor_id = 393

Query time 0.00284

Result

id vendor_id page_id new_items on_sale bestsellers about_us vendor_pages contact
144 393 N N N Y N Y