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

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

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

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


DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.7949295043945E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017368793487549 / seconds
host not found setting manual db connection
loadtime:0.0099930763244629 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010247945785522 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010432958602905 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010499954223633 / seconds
zipcode:
loadtime:0.010529041290283 / seconds
Query Executed:select * from search_referrer where page_hash='23548cf4d41860d99c5935be9458588f' limit 10 DB:ezrox_toadli
loadtime:0.010768890380859 / seconds
Operation header executed (non global)
loadtime:0.010801076889038 / seconds
Operation leaderboard executed (non global)
loadtime:0.01085090637207 / seconds
Operation square executed (non global)
loadtime:0.010887861251831 / seconds
Operation square_bottom executed (non global)
loadtime:0.010917901992798 / seconds
Operation smallsquare executed (non global)
loadtime:0.01094388961792 / seconds
Operation headeradright executed (non global)
loadtime:0.010968923568726 / seconds
Operation google_analytics executed (non global)
loadtime:0.010993957519531 / seconds
Operation topstories executed (non global)
loadtime:0.011019945144653 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011059045791626 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011085033416748 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011313915252686 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011474847793579 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011509895324707 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011574029922485 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011626958847046 / seconds
Template key: archive_menu pushed
loadtime:0.011636018753052 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011648893356323 / seconds
Template key: get_gravatar pushed
loadtime:0.011656045913696 / seconds
Operation directorycity executed (chunk cache operation)
loadtime:0.011664867401123 / seconds
*30)-30)+1 | start:0
loadtime:0.012374877929688 / seconds
DB connected to localhost business_master_new
loadtime:0.012647867202759 / seconds
Query Executed:select * from categories where cat_URLid='cable-and-other-pay-television-services'DB:business_master_new
loadtime:0.013649940490723 / seconds
Query stored in cache : _QUERY_www.toadli.comcbe20b1a1aac24ca94b6b0e5ae7709bc
loadtime:0.013706922531128 / seconds
Query Executed:select * from geodata_usstates where url_id='illinois'DB:business_master_new
loadtime:0.013906955718994 / seconds
Query stored in cache : _QUERY_www.toadli.coma3676d09f7babf1211c04eeabd48d99b
loadtime:0.013951063156128 / seconds
Query Executed:select * from geodata_geocity where region='IL' && url_id='springfield'DB:business_master_new
loadtime:0.015024900436401 / seconds
Query stored in cache : _QUERY_www.toadli.com2a02b1bac53293aa02677ed5355e0e30
loadtime:0.015588998794556 / 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.020369052886963 / 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.023705005645752 / seconds
Query Executed:select sum(totalcount) as totalsum from `il_catmap` where city='springfield' && sic='4841'DB:business_master_new
loadtime:0.030319929122925 / seconds
Query stored in cache : _QUERY_www.toadli.com3752965fce93d5c72c8013d20119953c
loadtime:0.03036093711853 / seconds
Query Executed:select count(*) as thecount from `il` where SIC_code='4841' && city_URLid='springfield'DB:business_master_new
loadtime:0.030788898468018 / seconds
Query stored in cache : _QUERY_www.toadli.com5398756607bae8025651f187a47a6411
loadtime:0.03082799911499 / seconds
6 / 31
loadtime:0.030869960784912 / seconds
Query Executed:select * from `il_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.040603876113892 / seconds
Query stored in cache : _QUERY_www.toadli.com78429183a7a62bb0de7c727a8e7491e2
loadtime:0.046274900436401 / seconds
Query Executed:select * from geodata_usstates where url_id='' GROUP BY url_idDB:business_master_new
loadtime:0.046542882919312 / seconds
Query Executed:select sum(totalcount) as totalsum from `il_catmap` where sic='4841'DB:business_master_new
loadtime:0.053622007369995 / seconds
Query stored in cache : _QUERY_www.toadli.com61706ee92618c5e2ac0b3a69239262b2
loadtime:0.053663969039917 / seconds
Query Executed:SELECT * FROM `il` LEFT JOIN `geodata_geocity` ON il.City=geodata_geocity.city WHERE SIC_Code='4841' GROUP BY il.CityDB:business_master_new
loadtime:0.15804505348206 / seconds
Query stored in cache : _QUERY_www.toadli.comb463154a7af1b1151e99fdf95de6ce89
loadtime:0.17346596717834 / seconds
RESULT COUNT: 6
loadtime:0.17371392250061 / seconds
Business 0
loadtime:0.17372393608093 / seconds
Query Executed:select * from `il` where id='279169'DB:business_master_new
loadtime:0.17824697494507 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.17859792709351 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.17884206771851 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.17998600006104 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.18022203445435 / 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.18039488792419 / 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.18053102493286 / 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.18113303184509 / seconds
Business 1
loadtime:0.18126201629639 / seconds
Query Executed:select * from `il` where id='644270'DB:business_master_new
loadtime:0.18832993507385 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.18864703178406 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.18889188766479 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.19000601768494 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.1902289390564 / 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.19037890434265 / 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.19051098823547 / 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.19108605384827 / seconds
Business 2
loadtime:0.19121694564819 / seconds
Query Executed:select * from `il` where id='26604'DB:business_master_new
loadtime:0.19946098327637 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.19977688789368 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.20002698898315 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.20114398002625 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.20135593414307 / 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.20150685310364 / 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.20163893699646 / 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.20221495628357 / seconds
Business 3
loadtime:0.20234489440918 / seconds
Query Executed:select * from `il` where id='342403'DB:business_master_new
loadtime:0.20441508293152 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.20473098754883 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.20497894287109 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.2060980796814 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.2063090801239 / 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.20645785331726 / 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.20658898353577 / 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.20715403556824 / seconds
Business 4
loadtime:0.20728492736816 / seconds
Query Executed:select * from `il` where id='152317'DB:business_master_new
loadtime:0.21483492851257 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.21515989303589 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.21540188789368 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.21651697158813 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.21672987937927 / 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.21688294410706 / 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.21701908111572 / 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.21758389472961 / seconds
Business 5
loadtime:0.21771287918091 / seconds
Query Executed:select * from `il` where id='347482'DB:business_master_new
loadtime:0.22041392326355 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.2207510471344 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.22105288505554 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.22222089767456 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.22243404388428 / 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.22258591651917 / 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.22271990776062 / 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.22329187393188 / seconds
Operation template executed (chunk cache operation)
loadtime:0.22414207458496 / seconds
template override:Default
loadtime:0.22421288490295 / 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.22535705566406 / seconds
Template Constructed, Array Rows:73
loadtime:0.22615098953247 / seconds
TOTAL EXECUTION TIME: 0.22545
loadtime:0.22714686393738 / 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.2271580696106
TOTAL KEY ARRAYS: 69