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

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

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

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


DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.7949295043945E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017518997192383 / seconds
host not found setting manual db connection
loadtime:0.0099639892578125 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010223865509033 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010356903076172 / seconds
Query Executed:select * from image_settings where id=1DB:ezrox_toadli
loadtime:0.010547876358032 / seconds
Query stored in cache : _QUERY_www.toadli.com3e245edfcf809fb719a7803874ee91be
loadtime:0.010612964630127 / seconds
zipcode:
loadtime:0.010640859603882 / seconds
Query Executed:select * from search_referrer where page_hash='2ebffbea3ed3fa7efdcee380c862d3ea' limit 10 DB:ezrox_toadli
loadtime:0.010861873626709 / seconds
Operation header executed (non global)
loadtime:0.010892868041992 / seconds
Operation leaderboard executed (non global)
loadtime:0.010949850082397 / seconds
Operation square executed (non global)
loadtime:0.01098895072937 / seconds
Operation square_bottom executed (non global)
loadtime:0.01102089881897 / seconds
Operation smallsquare executed (non global)
loadtime:0.011047840118408 / seconds
Operation headeradright executed (non global)
loadtime:0.011074066162109 / seconds
Operation google_analytics executed (non global)
loadtime:0.011101007461548 / seconds
Operation topstories executed (non global)
loadtime:0.01112699508667 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011155843734741 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011180877685547 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011425018310547 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011584043502808 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011618852615356 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011673927307129 / seconds
Operation archive_menu executed (global stored into APC)
loadtime:0.011715888977051 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='12' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.011914014816284 / seconds
Query stored in cache : _QUERY_www.toadli.com3d55f7f91e5bf9ad20be90a8091cca87
loadtime:0.011951923370361 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='11' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.012102842330933 / seconds
Query stored in cache : _QUERY_www.toadli.comcf39e902491c8710f992a39e3dc95995
loadtime:0.012135982513428 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='10' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.012274026870728 / seconds
Query stored in cache : _QUERY_www.toadli.com4102be7d709809e0b4a30c72a8b370d5
loadtime:0.012305021286011 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='09' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.012441873550415 / seconds
Query stored in cache : _QUERY_www.toadli.com532d812bce0b0ae43e5f575e7d23be41
loadtime:0.012474060058594 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='08' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.012609958648682 / seconds
Query stored in cache : _QUERY_www.toadli.com3cf6dff8268cfcf980c92c4980392b19
loadtime:0.012640953063965 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='07' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.012776851654053 / seconds
Query stored in cache : _QUERY_www.toadli.com43f75ed6592b4b49722b3412155af13f
loadtime:0.012817859649658 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='06' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.012959957122803 / seconds
Query stored in cache : _QUERY_www.toadli.comc02dd8052b191b154cce9c5b82f49431
loadtime:0.012995958328247 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='05' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.01313591003418 / seconds
Query stored in cache : _QUERY_www.toadli.come9fce3b5a4267d8b11c9f3d8eb1202b2
loadtime:0.013166904449463 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='04' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.01330304145813 / seconds
Query stored in cache : _QUERY_www.toadli.com309d67572808dbdbbf2ebfe1eeb971ad
loadtime:0.013334035873413 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='03' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.013469934463501 / seconds
Query stored in cache : _QUERY_www.toadli.coma0321a7834f4b82a8f36a356333212db
loadtime:0.013500928878784 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='02' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.013635873794556 / seconds
Query stored in cache : _QUERY_www.toadli.comd7153766b04f12df1c04b2f28d068b8d
loadtime:0.013666868209839 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='01' && year(publish_date)='2018')DB:ezrox_toadli
loadtime:0.013812065124512 / seconds
Query stored in cache : _QUERY_www.toadli.com5a1a496d9a0e9876352591762e51ce45
loadtime:0.013844013214111 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='12' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.014008045196533 / seconds
Query stored in cache : _QUERY_www.toadli.com4f052a89dfe49aa187f94a37826fe376
loadtime:0.014040946960449 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='11' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.014190912246704 / seconds
Query stored in cache : _QUERY_www.toadli.com6cc7c74b06647cf9e51d5693d6b90931
loadtime:0.014224052429199 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='10' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.014371871948242 / seconds
Query stored in cache : _QUERY_www.toadli.comfa9465c368c943a5380d7ceb806fa79c
loadtime:0.014404058456421 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='09' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.014551877975464 / seconds
Query stored in cache : _QUERY_www.toadli.coma81dc5768b7c37653b17fdd54679ce44
loadtime:0.014584064483643 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='08' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.014731884002686 / seconds
Query stored in cache : _QUERY_www.toadli.comeaca6d0a4597e1bd4e9bb9588579bb14
loadtime:0.014764070510864 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='07' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.014921903610229 / seconds
Query stored in cache : _QUERY_www.toadli.com449c8af3485e1fd7fceac39de06991f1
loadtime:0.014956951141357 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='06' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.015114068984985 / seconds
Query stored in cache : _QUERY_www.toadli.comabbaafa636eac82f6afd2d156b30aeb8
loadtime:0.015146017074585 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='05' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.015295028686523 / seconds
Query stored in cache : _QUERY_www.toadli.comc61bf25346de9dddd8b2fce27fc37f49
loadtime:0.015326976776123 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='04' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.015475034713745 / seconds
Query stored in cache : _QUERY_www.toadli.com79f573eda97feab0c1aee66d5abcec74
loadtime:0.015506982803345 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='03' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.015653848648071 / seconds
Query stored in cache : _QUERY_www.toadli.com5c758144e0983364c371e4a1968ed259
loadtime:0.01568603515625 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='02' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.015842914581299 / seconds
Query stored in cache : _QUERY_www.toadli.com14bbc59def9309186f290164d3d2dd19
loadtime:0.015876054763794 / seconds
Query Executed:select count(*) as count from content where status=1 && active=1 && (month(publish_date)='01' && year(publish_date)='2017')DB:ezrox_toadli
loadtime:0.01603102684021 / seconds
Query stored in cache : _QUERY_www.toadli.com1171cc59227b107f934714e97a85541c
loadtime:0.016063928604126 / seconds
Operation get_gravatar executed (global stored into APC)
loadtime:0.016098976135254 / seconds
Operation directorycity executed (chunk cache operation)
loadtime:0.01616096496582 / seconds
*30)-30)+1 | start:0
loadtime:0.016938924789429 / seconds
DB connected to localhost business_master_new
loadtime:0.017201900482178 / seconds
Query Executed:select * from categories where cat_URLid='cable-and-other-pay-television-services'DB:business_master_new
loadtime:0.018234968185425 / seconds
Query stored in cache : _QUERY_www.toadli.comcbe20b1a1aac24ca94b6b0e5ae7709bc
loadtime:0.018290042877197 / seconds
Query Executed:select * from geodata_usstates where url_id='illinois'DB:business_master_new
loadtime:0.018485069274902 / seconds
Query stored in cache : _QUERY_www.toadli.coma3676d09f7babf1211c04eeabd48d99b
loadtime:0.018527984619141 / seconds
Query Executed:select * from geodata_geocity where region='IL' && url_id='elgin'DB:business_master_new
loadtime:0.019044876098633 / seconds
Query stored in cache : _QUERY_www.toadli.come784ddf26e4346853748f6bf506d3633
loadtime:0.019182920455933 / 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.023880004882812 / 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.026699066162109 / seconds
Query Executed:select sum(totalcount) as totalsum from `il_catmap` where city='elgin' && sic='4841'DB:business_master_new
loadtime:0.033880949020386 / seconds
Query stored in cache : _QUERY_www.toadli.coma741890927a04a92cbf3c8a83dbec65e
loadtime:0.033915996551514 / seconds
Query Executed:select count(*) as thecount from `il` where SIC_code='4841' && city_URLid='elgin'DB:business_master_new
loadtime:0.034371852874756 / seconds
Query stored in cache : _QUERY_www.toadli.comce5df82cd7beef5826d2c1d6e03e6883
loadtime:0.034404993057251 / seconds
3 / 31
loadtime:0.034446954727173 / seconds
Query Executed:select * from `il_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.044018030166626 / seconds
Query stored in cache : _QUERY_www.toadli.com78429183a7a62bb0de7c727a8e7491e2
loadtime:0.049679040908813 / seconds
Query Executed:select * from geodata_usstates where url_id='' GROUP BY url_idDB:business_master_new
loadtime:0.049927949905396 / seconds
Query Executed:select sum(totalcount) as totalsum from `il_catmap` where sic='4841'DB:business_master_new
loadtime:0.05690598487854 / seconds
Query stored in cache : _QUERY_www.toadli.com61706ee92618c5e2ac0b3a69239262b2
loadtime:0.056941986083984 / 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.15955996513367 / seconds
Query stored in cache : _QUERY_www.toadli.comb463154a7af1b1151e99fdf95de6ce89
loadtime:0.17523598670959 / seconds
RESULT COUNT: 3
loadtime:0.17548298835754 / seconds
Business 0
loadtime:0.17549300193787 / seconds
Query Executed:select * from `il` where id='578273'DB:business_master_new
loadtime:0.17583703994751 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.17615294456482 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.17637300491333 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.1774640083313 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.17765688896179 / 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.17781400680542 / 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.17795705795288 / 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.17851591110229 / seconds
Business 1
loadtime:0.17866802215576 / seconds
Query Executed:select * from `il` where id='584390'DB:business_master_new
loadtime:0.17896890640259 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.17926287651062 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.17947006225586 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.18055391311646 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.18092489242554 / 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.18104600906372 / 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.1811408996582 / 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.18164801597595 / seconds
Business 2
loadtime:0.1817889213562 / seconds
Query Executed:select * from `il` where id='621859'DB:business_master_new
loadtime:0.18208289146423 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='Transportation, Communications, Electric, Gas, And'DB:business_master_new
loadtime:0.18236303329468 / seconds
Query Executed:SELECT * FROM business_description_spinner WHERE category='All Categories'DB:business_master_new
loadtime:0.18256497383118 / seconds
Query Executed:SELECT * FROM categories WHERE sic=4841DB:business_master_new
loadtime:0.18364787101746 / seconds
Query Executed:SELECT * FROM geodata_usstates WHERE statecode='IL'DB:business_master_new
loadtime:0.18382787704468 / 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.18394684791565 / 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.18404603004456 / 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.18454885482788 / seconds
Operation template executed (chunk cache operation)
loadtime:0.18553686141968 / seconds
template override:Default
loadtime:0.18560194969177 / 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.1871919631958 / seconds
Template Constructed, Array Rows:73
loadtime:0.18796801567078 / seconds
TOTAL EXECUTION TIME: 0.18727
loadtime:0.18882703781128 / 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.1888370513916
TOTAL KEY ARRAYS: 69