Cable and Other Pay Television Services deals/coupons Staunton, Illinois

There are 1 total Cable and Other Pay Television Services businessess in Staunton Illinois.

Citizens National Bank

Citizens National Bank is in the business in Illinois. Serving a wide range of needs, Citizens National Bank is an ideal place to ...read more

  • (618) 635-5450
  • 315 W Main St Staunton,IL
Listed in: Cable and Other Pay Television Services


DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:4.7922134399414E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00035190582275391 / seconds
host not found setting manual db connection
loadtime:0.00066494941711426 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010018348693848 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0011179447174072 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0011630058288574 / seconds
zipcode:
loadtime:0.0011789798736572 / seconds
Query Executed:select * from search_referrer where page_hash='2c450c40d944c9f691afcb82f095d0e4' limit 10 DB:ezrox_toadli
loadtime:0.0013368129730225 / seconds
Operation header executed (non global)
loadtime:0.0013530254364014 / seconds
Operation leaderboard executed (non global)
loadtime:0.0013778209686279 / seconds
Operation square executed (non global)
loadtime:0.0013918876647949 / seconds
Operation square_bottom executed (non global)
loadtime:0.00140380859375 / seconds
Operation smallsquare executed (non global)
loadtime:0.0014150142669678 / seconds
Operation headeradright executed (non global)
loadtime:0.0014259815216064 / seconds
Operation google_analytics executed (non global)
loadtime:0.0014359951019287 / seconds
Operation topstories executed (non global)
loadtime:0.0014619827270508 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0014770030975342 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0014870166778564 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017108917236328 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0018548965454102 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0018908977508545 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0019478797912598 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0019848346710205 / seconds
Template key: archive_menu pushed
loadtime:0.0019898414611816 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0019958019256592 / seconds
Template key: get_gravatar pushed
loadtime:0.0019989013671875 / seconds
Operation directorycity executed (chunk cache operation)
loadtime:0.0020039081573486 / seconds
*30)-30)+1 | start:0
loadtime:0.0020549297332764 / seconds
Query loaded from cache:select * from categories where cat_URLid='cable-and-other-pay-television-services'
loadtime:0.0020899772644043 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='illinois'
loadtime:0.0021178722381592 / seconds
DB connected to localhost business_master_new
loadtime:0.0023419857025146 / seconds
Query Executed:select * from geodata_geocity where region='IL' && url_id='staunton'DB:business_master_new
loadtime:0.0026769638061523 / seconds
Query stored in cache : _QUERY_www.toadli.com94cce5dd69aa0cba00044f7a3893d7c9
loadtime:0.0027289390563965 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE city='Staunton' && SIC_code='4841' GROUP BY il.id ORDER BY deals_id DESCDB:business_master_new
loadtime:0.0041728019714355 / seconds
Query Executed:SELECT il.id FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE city='Staunton' && SIC_code='4841' GROUP BY il.id ORDER BY deals_id DESCDB:business_master_new
loadtime:0.0049209594726562 / seconds
Query Executed:select sum(totalcount) as totalsum from `il_catmap` where city='staunton' && sic='4841'DB:business_master_new
loadtime:0.006138801574707 / seconds
Query stored in cache : _QUERY_www.toadli.comb4b8ff64db7ba99f71534e41551a509c
loadtime:0.0061650276184082 / seconds
Query Executed:select count(*) as thecount from `il` where SIC_code='4841' && city_URLid='staunton'DB:business_master_new
loadtime:0.00642991065979 / seconds
Query stored in cache : _QUERY_www.toadli.comc5ce31462360fbfd17c662f8e2b13d2f
loadtime:0.0064759254455566 / seconds
1 / 31
loadtime:0.0065000057220459 / seconds
Query loaded from cache:select * from `il_catmap` where sic='4841' order by city asc
loadtime:0.0078818798065186 / seconds
Query Executed:select * from geodata_usstates where url_id='' GROUP BY url_idDB:business_master_new
loadtime:0.0080950260162354 / seconds
Query loaded from cache:select sum(totalcount) as totalsum from `il_catmap` where sic='4841'
loadtime:0.008126974105835 / seconds
Query loaded from cache:SELECT * FROM `il` LEFT JOIN `geodata_geocity` ON il.City=geodata_geocity.city WHERE SIC_Code='4841' GROUP BY il.City
loadtime:0.012704849243164 / seconds
RESULT COUNT: 1
loadtime:0.012809991836548 / seconds
Business 0
loadtime:0.012814998626709 / seconds
Query Executed:select * from `il` where id='205689'DB:business_master_new
loadtime:0.013485908508301 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.013682842254639 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.013845920562744 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.014400959014893 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.014554023742676 / seconds
QUERY ERROR:Table 'business_master_new.IL' doesn't existSQL:SELECT COUNT(*) as thecount FROM `IL` WHERE SIC_code='4841' && city_URLid='' DB:business_master_new / business_master
loadtime:0.014662027359009 / seconds
QUERY ERROR:Table 'business_master_new.IL' doesn't existSQL:SELECT COUNT(*) FROM `IL` WHERE SIC_Code='4841'DB:business_master_new / business_master
loadtime:0.014750957489014 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='205689'DB:business_master_new
loadtime:0.015048980712891 / seconds
Operation template executed (chunk cache operation)
loadtime:0.015466928482056 / seconds
template override:Default
loadtime:0.015491962432861 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='directorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.01609992980957 / seconds
Template Constructed, Array Rows:73
loadtime:0.016412973403931 / seconds
TOTAL EXECUTION TIME: 0.01614
loadtime:0.01647686958313 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorycity;
subKey: template;



_GET


Array ( [cat_URLid] => cable-and-other-pay-television-services [stateURLid] => illinois [cityURLid] => staunton )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


Array ( [0] => cache [1] => query [2] => output [3] => session [4] => db [5] => db2 [6] => dbnew [7] => sphinxsearch [8] => sphinx [9] => dbConn [10] => functions [11] => sphinx_search [12] => template_operations [13] => buildtemplate [14] => syndication_handler [15] => directorycity [16] => unSpinner [17] => businessDescriptionHandler )


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.016481876373291
TOTAL KEY ARRAYS: 69