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

There are 6 total Cable and Other Pay Television Services businessess in Springfield Illinois.

Insight Home

Insight Home is in the business in Illinois. Serving a wide range of needs, Insight Home is an ideal place to start your search ...read more

  • (217) 788-5656
  • PO Box 3066 Springfield,IL
Listed in: Cable and Other Pay Television Services

Cable Illinois Inc

Cable Illinois Inc is in the business in Illinois. Serving a wide range of needs, Cable Illinois Inc is an ideal place to start ...read more

  • (217) 241-0506
  • 2663 Farragut Dr Springfield,IL
Listed in: Cable and Other Pay Television Services

Insight Communications

Insight Communications is in the business in Illinois. Serving a wide range of needs, Insight Communications is an ideal place to ...read more

  • (217) 788-5656
  • 711 S Dirksen Pkwy Springfield,IL
Listed in: Cable and Other Pay Television Services

Galaxy 1 Marketing Inc

Galaxy 1 Marketing Inc is in the business in Illinois. Serving a wide range of needs, Galaxy 1 Marketing Inc is an ideal place to ...read more

  • (217) 793-6237
  • 3511 S Douglas Ave Springfield,IL
Listed in: Cable and Other Pay Television Services

Greene County Partners Inc

Greene County Partners Inc is in the business in Illinois. Serving a wide range of needs, Greene County Partners Inc is an ideal ...read more

  • (217) 793-8939
  • 2663 Farragut Dr Springfield,IL
Listed in: Cable and Other Pay Television Services

TCI American Cable Holdings Lp

TCI American Cable Holdings Lp is in the business in Illinois. Serving a wide range of needs, TCI American Cable Holdings Lp is ...read more

  • (217) 788-5898
  • 711 S Dirksen Pkwy Springfield,IL
Listed in: Cable and Other Pay Television Services


DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.8174133300781E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017399787902832 / seconds
host not found setting manual db connection
loadtime:0.010038137435913 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010290145874023 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010452032089233 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010514974594116 / seconds
zipcode:
loadtime:0.01054310798645 / seconds
Query Executed:select * from search_referrer where page_hash='23548cf4d41860d99c5935be9458588f' limit 10 DB:ezrox_toadli
loadtime:0.010776996612549 / seconds
Operation header executed (non global)
loadtime:0.010814189910889 / seconds
Operation leaderboard executed (non global)
loadtime:0.010864973068237 / seconds
Operation square executed (non global)
loadtime:0.010895013809204 / seconds
Operation square_bottom executed (non global)
loadtime:0.010924100875854 / seconds
Operation smallsquare executed (non global)
loadtime:0.010964155197144 / seconds
Operation headeradright executed (non global)
loadtime:0.010992050170898 / seconds
Operation google_analytics executed (non global)
loadtime:0.011018037796021 / seconds
Operation topstories executed (non global)
loadtime:0.011046171188354 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011075019836426 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011100053787231 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01137113571167 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011558055877686 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011599063873291 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011659145355225 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011707067489624 / seconds
Template key: archive_menu pushed
loadtime:0.01171612739563 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011729001998901 / seconds
Template key: get_gravatar pushed
loadtime:0.011736154556274 / seconds
Operation directorycity executed (chunk cache operation)
loadtime:0.011744022369385 / seconds
*30)-30)+1 | start:0
loadtime:0.012436151504517 / seconds
Query loaded from cache:select * from categories where cat_URLid='cable-and-other-pay-television-services'
loadtime:0.012482166290283 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='illinois'
loadtime:0.012516975402832 / seconds
DB connected to localhost business_master_new
loadtime:0.01274299621582 / seconds
Query Executed:select * from geodata_geocity where region='IL' && url_id='springfield'DB:business_master_new
loadtime:0.013806104660034 / seconds
Query stored in cache : _QUERY_www.toadli.com2a02b1bac53293aa02677ed5355e0e30
loadtime:0.014373064041138 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE city='Springfield' && SIC_code='4841' GROUP BY il.id ORDER BY deals_id DESCDB:business_master_new
loadtime:0.01938009262085 / seconds
Query Executed:SELECT il.id FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE city='Springfield' && SIC_code='4841' GROUP BY il.id ORDER BY deals_id DESCDB:business_master_new
loadtime:0.022408008575439 / seconds
Query Executed:select sum(totalcount) as totalsum from `il_catmap` where city='springfield' && sic='4841'DB:business_master_new
loadtime:0.031548023223877 / seconds
Query stored in cache : _QUERY_www.toadli.com3752965fce93d5c72c8013d20119953c
loadtime:0.031588077545166 / seconds
Query Executed:select count(*) as thecount from `il` where SIC_code='4841' && city_URLid='springfield'DB:business_master_new
loadtime:0.032032012939453 / seconds
Query stored in cache : _QUERY_www.toadli.com5398756607bae8025651f187a47a6411
loadtime:0.032072067260742 / seconds
6 / 31
loadtime:0.032112121582031 / seconds
Query loaded from cache:select * from `il_catmap` where sic='4841' order by city asc
loadtime:0.0348961353302 / seconds
Query Executed:select * from geodata_usstates where url_id='' GROUP BY url_idDB:business_master_new
loadtime:0.035175085067749 / seconds
Query loaded from cache:select sum(totalcount) as totalsum from `il_catmap` where sic='4841'
loadtime:0.03522515296936 / 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.043698072433472 / seconds
RESULT COUNT: 6
loadtime:0.043962001800537 / seconds
Business 0
loadtime:0.043975114822388 / seconds
Query Executed:select * from `il` where id='342403'DB:business_master_new
loadtime:0.044324159622192 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.044666051864624 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.044922113418579 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.046061992645264 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.046282052993774 / 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.046446084976196 / 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.046579122543335 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='342403'DB:business_master_new
loadtime:0.047161102294922 / seconds
Business 1
loadtime:0.047291040420532 / seconds
Query Executed:select * from `il` where id='152317'DB:business_master_new
loadtime:0.052091121673584 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.05240797996521 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.05265212059021 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.053747177124023 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.0539710521698 / 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.054121971130371 / 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.054254055023193 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='152317'DB:business_master_new
loadtime:0.054809093475342 / seconds
Business 2
loadtime:0.054949998855591 / seconds
Query Executed:select * from `il` where id='347482'DB:business_master_new
loadtime:0.057660102844238 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.057981967926025 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.058225154876709 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.059324026107788 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.059535026550293 / 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.059683084487915 / 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.05982518196106 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='347482'DB:business_master_new
loadtime:0.060386180877686 / seconds
Business 3
loadtime:0.060516119003296 / seconds
Query Executed:select * from `il` where id='279169'DB:business_master_new
loadtime:0.063317060470581 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.063632965087891 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.063884019851685 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.064985990524292 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.065196990966797 / 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.065348148345947 / 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.065479040145874 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='279169'DB:business_master_new
loadtime:0.066044092178345 / seconds
Business 4
loadtime:0.066177129745483 / seconds
Query Executed:select * from `il` where id='644270'DB:business_master_new
loadtime:0.069440126419067 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.069754123687744 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.070003032684326 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.071102142333984 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.071313142776489 / 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.071464061737061 / 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.071598052978516 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='644270'DB:business_master_new
loadtime:0.072167158126831 / seconds
Business 5
loadtime:0.072298049926758 / seconds
Query Executed:select * from `il` where id='26604'DB:business_master_new
loadtime:0.076584100723267 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.076913118362427 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.077166080474854 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.078267097473145 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.078480958938599 / 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.078633069992065 / 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.078766107559204 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='26604'DB:business_master_new
loadtime:0.07933497428894 / seconds
Operation template executed (chunk cache operation)
loadtime:0.080504179000854 / seconds
template override:Default
loadtime:0.08056902885437 / 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.082163095474243 / seconds
Template Constructed, Array Rows:73
loadtime:0.082966089248657 / seconds
TOTAL EXECUTION TIME: 0.08226
loadtime:0.083940029144287 / 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] => springfield )


_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.083959102630615
TOTAL KEY ARRAYS: 69