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

There are 3 total Cable and Other Pay Television Services businessess in Elgin Illinois.

At and T Comcast

At and T Comcast is in the business in Illinois. Serving a wide range of needs, At and T Comcast is an ideal place to start your ...read more

  • (847) 697-2289
  • 1617 Weld Rd Elgin,IL
Listed in: Cable and Other Pay Television Services

Centel Cable Television Co Il

Centel Cable Television Co Il is in the business in Illinois. Serving a wide range of needs, Centel Cable Television Co Il is an ...read more

  • (630) 231-6950
  • 1765 Holmes Rd Elgin,IL
Listed in: Cable and Other Pay Television Services

Satellite Direct Inc

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

  • (847) 608-5306
  • 220 Coventry Ct Elgin,IL
Listed in: Cable and Other Pay Television Services


DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.0837478637695E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00051784515380859 / seconds
host not found setting manual db connection
loadtime:0.00086688995361328 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011680126190186 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0013840198516846 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0014388561248779 / seconds
zipcode:
loadtime:0.0014569759368896 / seconds
Query Executed:select * from search_referrer where page_hash='2ebffbea3ed3fa7efdcee380c862d3ea' limit 10 DB:ezrox_toadli
loadtime:0.0016689300537109 / seconds
Operation header executed (non global)
loadtime:0.0016858577728271 / seconds
Operation leaderboard executed (non global)
loadtime:0.001727819442749 / seconds
Operation square executed (non global)
loadtime:0.001741886138916 / seconds
Operation square_bottom executed (non global)
loadtime:0.0017538070678711 / seconds
Operation smallsquare executed (non global)
loadtime:0.0017659664154053 / seconds
Operation headeradright executed (non global)
loadtime:0.0017769336700439 / seconds
Operation google_analytics executed (non global)
loadtime:0.0017879009246826 / seconds
Operation topstories executed (non global)
loadtime:0.0017988681793213 / seconds
Operation businessnearyou executed (non global)
loadtime:0.00180983543396 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0018208026885986 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0020408630371094 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0022008419036865 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0022389888763428 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0023019313812256 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0023369789123535 / seconds
Template key: archive_menu pushed
loadtime:0.0023419857025146 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0023529529571533 / seconds
Template key: get_gravatar pushed
loadtime:0.0023579597473145 / seconds
Operation directorycity executed (chunk cache operation)
loadtime:0.0023620128631592 / seconds
*30)-30)+1 | start:0
loadtime:0.0023980140686035 / seconds
Query loaded from cache:select * from categories where cat_URLid='cable-and-other-pay-television-services'
loadtime:0.002424955368042 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='illinois'
loadtime:0.0024490356445312 / seconds
DB connected to localhost business_master_new
loadtime:0.0026679039001465 / seconds
Query Executed:select * from geodata_geocity where region='IL' && url_id='elgin'DB:business_master_new
loadtime:0.0030808448791504 / seconds
Query stored in cache : _QUERY_www.toadli.come784ddf26e4346853748f6bf506d3633
loadtime:0.0031588077545166 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE city='Elgin' && SIC_code='4841' GROUP BY il.id ORDER BY deals_id DESCDB:business_master_new
loadtime:0.0064709186553955 / seconds
Query Executed:SELECT il.id FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE city='Elgin' && SIC_code='4841' GROUP BY il.id ORDER BY deals_id DESCDB:business_master_new
loadtime:0.0088608264923096 / seconds
Query Executed:select sum(totalcount) as totalsum from `il_catmap` where city='elgin' && sic='4841'DB:business_master_new
loadtime:0.010645866394043 / seconds
Query stored in cache : _QUERY_www.toadli.coma741890927a04a92cbf3c8a83dbec65e
loadtime:0.010668992996216 / seconds
Query Executed:select count(*) as thecount from `il` where SIC_code='4841' && city_URLid='elgin'DB:business_master_new
loadtime:0.011127948760986 / seconds
Query stored in cache : _QUERY_www.toadli.comce5df82cd7beef5826d2c1d6e03e6883
loadtime:0.011159896850586 / seconds
3 / 31
loadtime:0.01121997833252 / seconds
Query loaded from cache:select * from `il_catmap` where sic='4841' order by city asc
loadtime:0.013725996017456 / seconds
Query Executed:select * from geodata_usstates where url_id='' GROUP BY url_idDB:business_master_new
loadtime:0.014130830764771 / seconds
Query loaded from cache:select sum(totalcount) as totalsum from `il_catmap` where sic='4841'
loadtime:0.014211893081665 / 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.025122880935669 / seconds
RESULT COUNT: 3
loadtime:0.025413036346436 / seconds
Business 0
loadtime:0.025426864624023 / seconds
Query Executed:select * from `il` where id='621859'DB:business_master_new
loadtime:0.026628017425537 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.027004957199097 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.027351856231689 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.028333902359009 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.028584003448486 / 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.028733968734741 / 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.028940916061401 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='621859'DB:business_master_new
loadtime:0.029619932174683 / seconds
Business 1
loadtime:0.029739856719971 / seconds
Query Executed:select * from `il` where id='578273'DB:business_master_new
loadtime:0.037503004074097 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.037820816040039 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.038105010986328 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.038810968399048 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.039067983627319 / 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.039287805557251 / 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.039453983306885 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='578273'DB:business_master_new
loadtime:0.040056943893433 / seconds
Business 2
loadtime:0.040199995040894 / seconds
Query Executed:select * from `il` where id='584390'DB:business_master_new
loadtime:0.041138887405396 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.041450977325439 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.041747808456421 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.042688846588135 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.042941808700562 / 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.043126821517944 / 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.043294906616211 / seconds
Query Executed:SELECT * FROM il LEFT JOIN il_deals ON il.ezid=il_deals.ezid WHERE il.id='584390'DB:business_master_new
loadtime:0.043751001358032 / seconds
Operation template executed (chunk cache operation)
loadtime:0.044790029525757 / seconds
template override:Default
loadtime:0.044857978820801 / 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.046029806137085 / seconds
Template Constructed, Array Rows:73
loadtime:0.046926975250244 / seconds
TOTAL EXECUTION TIME: 0.04612
loadtime:0.04706883430481 / 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] => elgin )


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