•Banner•

All independent businesses, all under one virtual roof.  Shop local, independent first.



 

Veterinary

•Listings• RSS
•Add your listing here•

Back Mountain Veterinary Hospital

732 Center Hill Road, Dallas, PA, 18612
Telephone570-675-3406

Northeast Veterinary Referral Hospital

242 South River Street, Plains, PA, 18705
Telephone570-208-8877

•Profile Information•

Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.155 seconds, 5.38 MB
Application afterRoute: 0.228 seconds, 8.51 MB
Application afterDispatch: 0.374 seconds, 12.62 MB
Application afterRender: 0.443 seconds, 13.40 MB

•Memory Usage•

14349976

•48 queries logged•

  1. DELETE
      FROM jos_session
      WHERE ( TIME < '1534287876' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 'ufb3kmmvm1dg6hi95eavtjd2b6'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'ufb3kmmvm1dg6hi95eavtjd2b6','1534295076','','0','1','0' )
  4. SELECT *
      FROM jos_components
      WHERE parent = 0
  5. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  6. SELECT setting,VALUE
      FROM jos_jfbconnect_config
  7. SELECT `value`

      FROM `jos_admintools_storage`

      WHERE `key` = 'cparams'
  8. SELECT *
      FROM jos_redj
      WHERE ( (('/directory/veterinary' REGEXP BINARY fromurl)>0
      AND case_sensitive<>'0') OR (('/directory/veterinary' REGEXP fromurl)>0
      AND case_sensitive='0') )
      AND published='1'
      ORDER BY ordering
  9. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  10. SELECT `varname`, `value`, `default`
      FROM jos_mt_config
  11. SELECT cat_id, cat_parent, alias
      FROM jos_mt_cats
      WHERE cat_published='1'
      AND cat_approved='1' && BINARY alias = 'veterinary'
  12. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 247)
      ORDER BY menuid DESC
      LIMIT 0, 1
  13. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '117'
  14. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 66
      AND rgt > 67
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  15. SELECT *
      FROM jos_mt_cats
      WHERE cat_id='117'
      AND cat_published = 1
      LIMIT 1
  16. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '117'
      LIMIT 1
  17. SELECT COUNT(*)
      FROM (jos_mt_links AS l, jos_mt_cl AS cl)
      WHERE l.link_published = 1
      AND l.link_approved = 1 && cl.cat_id = '117'
     
      AND ( l.publish_up = '0000-00-00 00:00:00' OR l.publish_up <= '2018-08-15 01:04:37'  )
     
      AND ( l.publish_down = '0000-00-00 00:00:00' OR l.publish_down >= '2018-08-15 01:04:37' )
     
      AND cl.link_id = l.link_id
  18. SELECT cat.*
      FROM jos_mt_cats AS cat
      WHERE cat_published=1 && cat_approved=1 && cat_parent= '117'
      ORDER BY cat_name ASC
  19. SELECT r.rel_id
      FROM jos_mt_relcats AS r
      LEFT JOIN jos_mt_cats AS c
      ON c.cat_id = r.rel_id
      WHERE r.cat_id = '117'
      AND c.cat_published = 1
  20. SELECT l.*, cl.*, cat.*, u.username AS username, u.name AS owner, img.filename AS link_image
      FROM jos_mt_links AS l
     
      LEFT JOIN jos_mt_cl AS cl
      ON cl.link_id = l.link_id
     
      LEFT JOIN jos_users AS u
      ON u.id = l.user_id
     
      LEFT JOIN jos_mt_cats AS cat
      ON cl.cat_id = cat.cat_id
     
      LEFT JOIN jos_mt_images AS img
      ON img.link_id = l.link_id
      AND img.ordering = 1
     
      WHERE link_published='1' && link_approved='1' && cl.cat_id = '117'
     
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-08-15 01:04:37'  )
     
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-08-15 01:04:37' )
     
      ORDER BY link_featured DESC, link_name ASC
     
      LIMIT 0, 20
  21. SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS VALUE, field_type
      FROM jos_mt_customfields
  22. SELECT cf.*, cfv.link_id, cfv.VALUE, cfv.attachment, cfv.counter, ft.ft_class
      FROM jos_mt_customfields AS cf

      LEFT JOIN jos_mt_cfvalues AS cfv
      ON cf.cf_id=cfv.cf_id

      LEFT JOIN jos_mt_fieldtypes AS ft
      ON ft.field_type=cf.field_type

      WHERE cf.published = '1'
      AND cf.summary_view = '1'

      AND cfv.link_id IN (260,261)

      ORDER BY cf.ordering ASC, link_id DESC
  23. SELECT cf. * , NULL AS link_id, '' AS VALUE, NULL AS attachment, ft.ft_class

      FROM jos_mt_customfields AS cf

      LEFT JOIN jos_mt_fieldtypes AS ft
      ON ft.field_type=cf.field_type

      WHERE cf.published = '1'

      AND cf.summary_view = '1'

      AND cf.iscore = '1'

      ORDER BY cf.ordering ASC
  24. SELECT r.link_id, COUNT( * ) AS total
      FROM jos_mt_cl AS cl
     
      LEFT JOIN jos_mt_reviews AS r
      ON cl.link_id = r.link_id
     
      WHERE cl.link_id IN ('260','261')
      AND r.rev_approved = '1'
      AND cl.main = '1'
     
      GROUP BY r.link_id
  25. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '117'
      LIMIT 1
  26. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '117'
      LIMIT 1
  27. SELECT params
      FROM jos_mt_templates
      WHERE tem_name = 'm2'
      LIMIT 1
  28. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '260'
      AND main = 1
  29. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '117'
      LIMIT 1
  30. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  31. SELECT cf_id, caption
      FROM jos_mt_customfields
      WHERE tag_search = 1
      AND published = 1
  32. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  33. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  34. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  35. SELECT l.*, cl.cat_id AS cat_id
      FROM jos_mt_links AS l, jos_mt_cl AS cl
      WHERE l.link_id = cl.link_id
      AND l.link_id = '261'
      AND main = 1
  36. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '117'
      LIMIT 1
  37. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  38. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  39. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  40. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  41. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  42. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 247 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  43. SELECT cat_id, cat_name
      FROM jos_mt_cats  
      WHERE cat_approved=1
      AND cat_published=1
      AND cat_parent = 0
      ORDER BY cat_name ASC
  44. SELECT *, RAND() AS ordering
      FROM jos_banner
      WHERE showBanner = 1
      AND (imptotal = 0 OR impmade < imptotal)
      AND catid = 8
      ORDER BY sticky DESC, ordering
      LIMIT 0, 1
  45. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 30
  46. SELECT a.id, a.alias AS username, a.title AS fullname, a.catid, a.sectionid, a.introtext AS intro, u.email AS email, u.id AS user_id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.username = a.alias
      WHERE a.sectionid = 15
      AND a.state = 1
  47. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '117'
      LIMIT 1
  48. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '117'
      LIMIT 1

•0 legacy queries logged•

    •Language Files Loaded•

    •Untranslated Strings Diagnostic•

    •None•

    •Untranslated Strings Designer•

    •None•