•Banner•

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



 

City:Edwardsville

•Listings• RSS

A&B Used Tires

16 S Wyoming Ave, Edwardsville, PA, USA, 18704
•Category•:•Directory•
Telephone570-288-1700
E-mail

Tilbury’s Knob

Gateway Gardens Shopping Center Unit110, Edwardsville, PA, 18704
•Category•:Unique Shops
Telephone570-331-2012

Fresh Sportswear

10 Gateway Shopping Center, Edwardsville, PA, 18704
•Category•:Apparel
Telephone570-287-2251

City Tobacco Company

11 Gateway Shopping Center, Edwardsville, PA, 18704
•Category•:Unique Shops
Telephone570-288-6585

Scott Saylor Designs

Gateway Shopping Center, Edwardsville, PA, 1704
•Category•:Home Furnishings
Telephone570-288-2000
E-mail

CBXMAN.COM

378 Main Street, Edwardsville, PA, 18704
•Category•:Automotive
Telephone570-718-1844

Gastroenterology Consultants

490 Northampton Street, Edwardsville, PA, 18704
Telephone570-288-8100

Java's Brewin

Gateway Shopping Center, Edwardsville, PA, 18704
•Category•:Restaurants
Telephone570-714-2816
E-mail

Turosky Natural Healing Center

420 Main Street, Edwardsville, PA, 18704
•Category•:Fitness & Nutrition
Telephone570-287-8893

•Profile Information•

Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.053 seconds, 5.38 MB
Application afterRoute: 0.076 seconds, 8.53 MB
Application afterDispatch: 0.169 seconds, 13.00 MB
Application afterRender: 0.195 seconds, 13.78 MB

•Memory Usage•

14821736

•108 queries logged•

  1. DELETE
      FROM jos_session
      WHERE ( TIME < '1539980947' )
  2. SELECT *
      FROM jos_session
      WHERE session_id = 't0alrr3126u6oc7snk2u6edfq5'
  3. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 't0alrr3126u6oc7snk2u6edfq5','1539988147','','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/search-by/city/Edwardsville' REGEXP BINARY fromurl)>0
      AND case_sensitive<>'0') OR (('/directory/search-by/city/Edwardsville' 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 cf_id, caption
      FROM jos_mt_customfields
      WHERE tag_search = 1
      AND published = 1
  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 *
      FROM jos_mt_customfields AS cf
      WHERE cf.cf_id = '5'
      AND published = 1
      AND tag_search = 1
      LIMIT 1
  14. SELECT l.*, u.username, c.*, img.filename AS link_image
      FROM (jos_mt_links AS l, jos_mt_cl AS cl)
           
      LEFT JOIN jos_mt_images AS img
      ON img.link_id = l.link_id
      AND img.ordering = 1
           
      LEFT JOIN jos_mt_cats AS c
      ON c.cat_id = cl.cat_id
     
      LEFT JOIN jos_users AS u
      ON u.id = l.user_id
           
      WHERE
            link_published='1'
      AND link_approved='1'
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-10-19 22:29:07'  )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-10-19 22:29:07' )
     
      AND cl.link_id = l.link_id
     
      AND cl.main = 1
     
      AND l.city LIKE '%Edwardsville%'
     
      ORDER BY link_featured DESC, link_hits DESC
     
      LIMIT 0, 20
  15. SELECT COUNT(DISTINCT l.link_id)
      FROM (jos_mt_links AS l, jos_mt_cl AS cl)
           
      LEFT JOIN jos_mt_cats AS c
      ON c.cat_id = cl.cat_id
           
      WHERE link_published='1'
      AND link_approved='1'
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-10-19 22:29:07'  )
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-10-19 22:29:07' )
     
      AND cl.link_id = l.link_id
     
      AND cl.main = 1
     
      AND l.city LIKE '%Edwardsville%'
  16. SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS VALUE, field_type
      FROM jos_mt_customfields
  17. 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 (516,257,233,323,386,25,121,353,187)

      ORDER BY cf.ordering ASC, link_id DESC
  18. 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
  19. 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 ('516','257','233','323','386','25','121','353','187')
      AND r.rev_approved = '1'
      AND cl.main = '1'
     
      GROUP BY r.link_id
  20. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  21. SELECT cf_id, caption
      FROM jos_mt_customfields
      WHERE tag_search = 1
      AND published = 1
  22. SELECT params
      FROM jos_mt_templates
      WHERE tem_name = 'm2'
      LIMIT 1
  23. 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 = '516'
      AND main = 1
  24. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  25. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  26. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  27. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  28. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  29. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  30. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  31. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  32. 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 = '257'
      AND main = 1
  33. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '116'
  34. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 64
      AND rgt > 65
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  35. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '116'
      LIMIT 1
  36. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      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 = '116'
      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 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 = '233'
      AND main = 1
  42. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '112'
  43. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 58
      AND rgt > 59
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  44. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '112'
      LIMIT 1
  45. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  46. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  47. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '112'
      LIMIT 1
  48. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  49. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  50. 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 = '323'
      AND main = 1
  51. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '116'
      LIMIT 1
  52. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  53. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  54. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '116'
      LIMIT 1
  55. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  56. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  57. 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 = '386'
      AND main = 1
  58. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '131'
  59. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 86
      AND rgt > 87
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  60. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '131'
      LIMIT 1
  61. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  62. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  63. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '131'
      LIMIT 1
  64. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  65. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  66. 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 = '25'
      AND main = 1
  67. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '122'
  68. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 74
      AND rgt > 75
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  69. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '122'
      LIMIT 1
  70. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  71. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  72. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '122'
      LIMIT 1
  73. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  74. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  75. 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 = '121'
      AND main = 1
  76. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '97'
  77. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 32
      AND rgt > 33
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  78. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '97'
      LIMIT 1
  79. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  80. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  81. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '97'
      LIMIT 1
  82. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  83. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  84. 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 = '353'
      AND main = 1
  85. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '111'
  86. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 56
      AND rgt > 57
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  87. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  88. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  89. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  90. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '111'
      LIMIT 1
  91. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  92. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  93. 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 = '187'
      AND main = 1
  94. SELECT cat_name, cat_id, lft, rgt
      FROM jos_mt_cats
      WHERE cat_id = '93'
  95. SELECT cat_id
      FROM jos_mt_cats
      WHERE lft < 24
      AND rgt > 25
      AND cat_id > 0
      AND cat_parent >= 0
      ORDER BY lft ASC
  96. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '93'
      LIMIT 1
  97. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  98. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  99. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '93'
      LIMIT 1
  100. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  101. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1
  102. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  103. 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
  104. 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
  105. 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
  106. UPDATE jos_banner
      SET impmade = impmade + 1
      WHERE bid = 30
  107. 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
  108. SELECT alias
      FROM jos_mt_cats
      WHERE cat_id = '0'
      LIMIT 1

•0 legacy queries logged•

    •Language Files Loaded•

    •Untranslated Strings Diagnostic•

    •None•

    •Untranslated Strings Designer•

    •None•