DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00017881393432617 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0012948513031006 / seconds
host not found setting manual db connection
loadtime:0.0023088455200195 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0029969215393066 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0033388137817383 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0034580230712891 / seconds
zipcode:
loadtime:0.0035018920898438 / seconds
Query Executed:select * from search_referrer where page_hash='3f45c7b264c9b58efe84fc60e0cd1de2' limit 10 DB:ezrox_toadli
loadtime:0.0040090084075928 / seconds
Operation header executed (non global)
loadtime:0.0040538311004639 / seconds
Operation leaderboard executed (non global)
loadtime:0.0041589736938477 / seconds
Operation square executed (non global)
loadtime:0.0041990280151367 / seconds
Operation square_bottom executed (non global)
loadtime:0.0042319297790527 / seconds
Operation smallsquare executed (non global)
loadtime:0.0042610168457031 / seconds
Operation headeradright executed (non global)
loadtime:0.004288911819458 / seconds
Operation google_analytics executed (non global)
loadtime:0.0043168067932129 / seconds
Operation topstories executed (non global)
loadtime:0.0043458938598633 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0043749809265137 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0044019222259521 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0050179958343506 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0054118633270264 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0055139064788818 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0056798458099365 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0057978630065918 / seconds
Template key: archive_menu pushed
loadtime:0.0058038234710693 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.005810022354126 / seconds
Template key: get_gravatar pushed
loadtime:0.0058138370513916 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0058178901672363 / seconds
*10)-10)+1 | start:0
loadtime:0.0058419704437256 / seconds
Query loaded from cache:select * from categories where cat_URLid='cable-and-other-pay-television-services'
loadtime:0.0058720111846924 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.005903959274292 / seconds
DB connected to localhost business_master_new
loadtime:0.0061409473419189 / seconds
Query Executed:select * from `ct_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.16901302337646 / seconds
Query stored in cache : _QUERY_www.toadli.com3617364b6cea868077aa5604467258b0
loadtime:0.17019581794739 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.17027497291565 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='4841'DB:business_master_new
loadtime:0.17426681518555 / seconds
Query stored in cache : _QUERY_www.toadli.comc06ccf8fa01d13042c186a69ef083dd4
loadtime:0.17430090904236 / seconds
273 / 11
loadtime:0.17433285713196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.17437195777893 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='4841'DB:business_master_new
loadtime:0.19012498855591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amston' limit 1
loadtime:0.190260887146 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='4841'DB:business_master_new
loadtime:0.20337700843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.20349097251892 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='4841'DB:business_master_new
loadtime:0.20499801635742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonia' limit 1
loadtime:0.20508885383606 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='4841'DB:business_master_new
loadtime:0.20646786689758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.20657086372375 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='4841'DB:business_master_new
loadtime:0.20728087425232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.20731687545776 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='4841'DB:business_master_new
loadtime:0.20824599266052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballouville' limit 1
loadtime:0.20827484130859 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='4841'DB:business_master_new
loadtime:0.21145987510681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.21150994300842 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='4841'DB:business_master_new
loadtime:0.21257781982422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bantam' limit 1
loadtime:0.21268391609192 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='4841'DB:business_master_new
loadtime:0.21409296989441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barkhamsted' limit 1
loadtime:0.21418595314026 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='4841'DB:business_master_new
loadtime:0.21558690071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon Falls' limit 1
loadtime:0.21568894386292 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='4841'DB:business_master_new
loadtime:0.21675992012024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.21686482429504 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='4841'DB:business_master_new
loadtime:0.21827101707458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.21840596199036 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='4841'DB:business_master_new
loadtime:0.21983695030212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.21990394592285 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='4841'DB:business_master_new
loadtime:0.22094488143921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.22105383872986 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='4841'DB:business_master_new
loadtime:0.22243785858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.22253394126892 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='4841'DB:business_master_new
loadtime:0.22397494316101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.22405481338501 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='4841'DB:business_master_new
loadtime:0.22553491592407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Botsford' limit 1
loadtime:0.22567582130432 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='4841'DB:business_master_new
loadtime:0.22709584236145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozrah' limit 1
loadtime:0.22721982002258 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='4841'DB:business_master_new
loadtime:0.22871398925781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branford' limit 1
loadtime:0.2288830280304 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='4841'DB:business_master_new
loadtime:0.23031687736511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.23044300079346 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='4841'DB:business_master_new
loadtime:0.23193883895874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.2321298122406 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='4841'DB:business_master_new
loadtime:0.2337110042572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.23388385772705 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='4841'DB:business_master_new
loadtime:0.23536586761475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Brook' limit 1
loadtime:0.2354748249054 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='4841'DB:business_master_new
loadtime:0.23648500442505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.23653197288513 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='4841'DB:business_master_new
loadtime:0.23792791366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.2380588054657 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='4841'DB:business_master_new
loadtime:0.23940801620483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.23945999145508 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='4841'DB:business_master_new
loadtime:0.24084687232971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.24097800254822 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='4841'DB:business_master_new
loadtime:0.24251699447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.24265003204346 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='4841'DB:business_master_new
loadtime:0.2441029548645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.24417495727539 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='4841'DB:business_master_new
loadtime:0.24539279937744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton Center' limit 1
loadtime:0.24551892280579 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='4841'DB:business_master_new
loadtime:0.24703192710876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerbrook' limit 1
loadtime:0.24716901779175 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='4841'DB:business_master_new
loadtime:0.24880385398865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Village' limit 1
loadtime:0.24891901016235 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='4841'DB:business_master_new
loadtime:0.25038599967957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaplin' limit 1
loadtime:0.25052094459534 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='4841'DB:business_master_new
loadtime:0.2515230178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.25165700912476 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='4841'DB:business_master_new
loadtime:0.25250196456909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.25266790390015 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='4841'DB:business_master_new
loadtime:0.25407791137695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.2542188167572 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='4841'DB:business_master_new
loadtime:0.25581979751587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobalt' limit 1
loadtime:0.25591492652893 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='4841'DB:business_master_new
loadtime:0.2590479850769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.25909900665283 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='4841'DB:business_master_new
loadtime:0.25964188575745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.25968980789185 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='4841'DB:business_master_new
loadtime:0.26048994064331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.26062083244324 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='4841'DB:business_master_new
loadtime:0.26209592819214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.26223087310791 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='4841'DB:business_master_new
loadtime:0.26382184028625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall' limit 1
loadtime:0.26394391059875 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='4841'DB:business_master_new
loadtime:0.26550102233887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall Bridge' limit 1
loadtime:0.26563787460327 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='4841'DB:business_master_new
loadtime:0.26713800430298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cos Cob' limit 1
loadtime:0.26727390289307 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='4841'DB:business_master_new
loadtime:0.26886391639709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.26895999908447 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='4841'DB:business_master_new
loadtime:0.27042102813721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.27056980133057 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='4841'DB:business_master_new
loadtime:0.27210783958435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.27226090431213 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='4841'DB:business_master_new
loadtime:0.27386689186096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danielson' limit 1
loadtime:0.27402091026306 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='4841'DB:business_master_new
loadtime:0.27542686462402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.27547192573547 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='4841'DB:business_master_new
loadtime:0.27659201622009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:0.27664184570312 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='4841'DB:business_master_new
loadtime:0.27806282043457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.27817296981812 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='4841'DB:business_master_new
loadtime:0.27978801727295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.27991485595703 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='4841'DB:business_master_new
loadtime:0.28141283988953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.28154993057251 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='4841'DB:business_master_new
loadtime:0.28307294845581 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berlin' limit 1
loadtime:0.28320980072021 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='4841'DB:business_master_new
loadtime:0.28443694114685 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Canaan' limit 1
loadtime:0.28455090522766 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='4841'DB:business_master_new
loadtime:0.28603792190552 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Glastonbury' limit 1
loadtime:0.28617000579834 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='4841'DB:business_master_new
loadtime:0.28946590423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Granby' limit 1
loadtime:0.28951191902161 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='4841'DB:business_master_new
loadtime:0.29003691673279 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haddam' limit 1
loadtime:0.29006481170654 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='4841'DB:business_master_new
loadtime:0.29055881500244 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampton' limit 1
loadtime:0.29060196876526 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='4841'DB:business_master_new
loadtime:0.29111099243164 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartford' limit 1
loadtime:0.29114389419556 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='4841'DB:business_master_new
loadtime:0.29163599014282 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartland' limit 1
loadtime:0.29168295860291 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='4841'DB:business_master_new
loadtime:0.2921929359436 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.29222989082336 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='4841'DB:business_master_new
loadtime:0.29271483421326 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Killingly' limit 1
loadtime:0.29275298118591 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='4841'DB:business_master_new
loadtime:0.29545783996582 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lyme' limit 1
loadtime:0.29550981521606 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='4841'DB:business_master_new
loadtime:0.29602384567261 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.29605603218079 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='4841'DB:business_master_new
loadtime:0.29655599594116 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor Hill' limit 1
loadtime:0.29659986495972 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.29960584640503 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Woodstock' limit 1
loadtime:0.29963397979736 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='4841'DB:business_master_new
loadtime:0.30417084693909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastford' limit 1
loadtime:0.30421090126038 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='4841'DB:business_master_new
loadtime:0.30471181869507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.30476093292236 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='4841'DB:business_master_new
loadtime:0.30524897575378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellington' limit 1
loadtime:0.30528402328491 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='4841'DB:business_master_new
loadtime:0.30578780174255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.30582690238953 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='4841'DB:business_master_new
loadtime:0.30631995201111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.30635285377502 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='4841'DB:business_master_new
loadtime:0.30686497688293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fabyan' limit 1
loadtime:0.3068950176239 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='4841'DB:business_master_new
loadtime:0.30724501609802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.30728197097778 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='4841'DB:business_master_new
loadtime:0.30779099464417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Village' limit 1
loadtime:0.30782580375671 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='4841'DB:business_master_new
loadtime:0.30833387374878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.30836582183838 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='4841'DB:business_master_new
loadtime:0.30887889862061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Ferry' limit 1
loadtime:0.30890989303589 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='4841'DB:business_master_new
loadtime:0.3094048500061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylordsville' limit 1
loadtime:0.30944180488586 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='4841'DB:business_master_new
loadtime:0.30994391441345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.30997896194458 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='4841'DB:business_master_new
loadtime:0.31047081947327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.3104989528656 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='4841'DB:business_master_new
loadtime:0.31168389320374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgo' limit 1
loadtime:0.31174397468567 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='4841'DB:business_master_new
loadtime:0.31305003166199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glastonbury' limit 1
loadtime:0.31309199333191 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='4841'DB:business_master_new
loadtime:0.31362986564636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.31366991996765 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='4841'DB:business_master_new
loadtime:0.31420588493347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.31424283981323 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='4841'DB:business_master_new
loadtime:0.31475591659546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greens Farms' limit 1
loadtime:0.3147919178009 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='4841'DB:business_master_new
loadtime:0.31530284881592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.3153338432312 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='4841'DB:business_master_new
loadtime:0.31583786010742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosvenor Dale' limit 1
loadtime:0.31586790084839 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='4841'DB:business_master_new
loadtime:0.3174409866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.31747698783875 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='4841'DB:business_master_new
loadtime:0.3188099861145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.31890392303467 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='4841'DB:business_master_new
loadtime:0.32021284103394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:0.3202497959137 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='4841'DB:business_master_new
loadtime:0.32151198387146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:0.32157683372498 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='4841'DB:business_master_new
loadtime:0.32644987106323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:0.32654190063477 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='4841'DB:business_master_new
loadtime:0.32804393768311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.3281729221344 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='4841'DB:business_master_new
loadtime:0.32966184616089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.32982492446899 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='4841'DB:business_master_new
loadtime:0.33234882354736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.33244585990906 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='4841'DB:business_master_new
loadtime:0.33398485183716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:0.33411884307861 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='4841'DB:business_master_new
loadtime:0.33571481704712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:0.33586382865906 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='4841'DB:business_master_new
loadtime:0.3373658657074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.33749198913574 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='4841'DB:business_master_new
loadtime:0.33901286125183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:0.33914995193481 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='4841'DB:business_master_new
loadtime:0.34080696105957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:0.34091687202454 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='4841'DB:business_master_new
loadtime:0.34238982200623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:0.34252786636353 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='4841'DB:business_master_new
loadtime:0.34404802322388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.34420585632324 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='4841'DB:business_master_new
loadtime:0.34582090377808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:0.34591603279114 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='4841'DB:business_master_new
loadtime:0.34738302230835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.34752082824707 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='4841'DB:business_master_new
loadtime:0.35038781166077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:0.35044193267822 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='4841'DB:business_master_new
loadtime:0.35192084312439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.35205292701721 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='4841'DB:business_master_new
loadtime:0.35359382629395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.35376691818237 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='4841'DB:business_master_new
loadtime:0.35527086257935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.35540294647217 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='4841'DB:business_master_new
loadtime:0.3569610118866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.35710382461548 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='4841'DB:business_master_new
loadtime:0.3586859703064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.35886001586914 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='4841'DB:business_master_new
loadtime:0.36025500297546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:0.36030602455139 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='4841'DB:business_master_new
loadtime:0.3616099357605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:0.36170601844788 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='4841'DB:business_master_new
loadtime:0.36521100997925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:0.36526083946228 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='4841'DB:business_master_new
loadtime:0.36700582504272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.3670539855957 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='4841'DB:business_master_new
loadtime:0.36843585968018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.36856293678284 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='4841'DB:business_master_new
loadtime:0.37010788917542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.3702449798584 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='4841'DB:business_master_new
loadtime:0.37187790870667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:0.37199687957764 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='4841'DB:business_master_new
loadtime:0.37638998031616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.37644195556641 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='4841'DB:business_master_new
loadtime:0.37769484519958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:0.37776184082031 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='4841'DB:business_master_new
loadtime:0.37917995452881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.37931180000305 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='4841'DB:business_master_new
loadtime:0.38040995597839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.38046789169312 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='4841'DB:business_master_new
loadtime:0.38196802139282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:0.38212299346924 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='4841'DB:business_master_new
loadtime:0.38376593589783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.3838939666748 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='4841'DB:business_master_new
loadtime:0.38479089736938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:0.38493084907532 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='4841'DB:business_master_new
loadtime:0.38652682304382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:0.38664197921753 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='4841'DB:business_master_new
loadtime:0.38814902305603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:0.38819789886475 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='4841'DB:business_master_new
loadtime:0.389408826828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:0.38954782485962 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='4841'DB:business_master_new
loadtime:0.39104199409485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.39115500450134 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='4841'DB:business_master_new
loadtime:0.39245581626892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.39259386062622 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='4841'DB:business_master_new
loadtime:0.39410901069641 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:0.39424180984497 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='4841'DB:business_master_new
loadtime:0.39583396911621 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:0.39594388008118 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='4841'DB:business_master_new
loadtime:0.39718079566956 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:0.39731693267822 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='4841'DB:business_master_new
loadtime:0.39880990982056 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.39890480041504 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='4841'DB:business_master_new
loadtime:0.40007781982422 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.40013694763184 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='4841'DB:business_master_new
loadtime:0.40094399452209 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.40110397338867 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='4841'DB:business_master_new
loadtime:0.40257000923157 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:0.4027099609375 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='4841'DB:business_master_new
loadtime:0.4041759967804 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:0.40421986579895 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='4841'DB:business_master_new
loadtime:0.40514302253723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.40519189834595 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='4841'DB:business_master_new
loadtime:0.40644598007202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.40652680397034 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='4841'DB:business_master_new
loadtime:0.4070827960968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:0.40713500976562 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='4841'DB:business_master_new
loadtime:0.40767598152161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.40772199630737 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='4841'DB:business_master_new
loadtime:0.40827488899231 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:0.40830898284912 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='4841'DB:business_master_new
loadtime:0.40903401374817 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:0.40915393829346 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='4841'DB:business_master_new
loadtime:0.41201400756836 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:0.41206502914429 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='4841'DB:business_master_new
loadtime:0.41295480728149 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:0.41299796104431 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='4841'DB:business_master_new
loadtime:0.41433882713318 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:0.41438484191895 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='4841'DB:business_master_new
loadtime:0.41572880744934 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:0.41579079627991 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='4841'DB:business_master_new
loadtime:0.41665101051331 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:0.41680502891541 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='4841'DB:business_master_new
loadtime:0.41785883903503 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:0.41799187660217 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='4841'DB:business_master_new
loadtime:0.41970586776733 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:0.41975593566895 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='4841'DB:business_master_new
loadtime:0.42062497138977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.42079401016235 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='4841'DB:business_master_new
loadtime:0.42186594009399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:0.42200493812561 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='4841'DB:business_master_new
loadtime:0.42331099510193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.42336297035217 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='4841'DB:business_master_new
loadtime:0.42443490028381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.42456603050232 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='4841'DB:business_master_new
loadtime:0.42566180229187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.42583298683167 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='4841'DB:business_master_new
loadtime:0.42684388160706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.42698693275452 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='4841'DB:business_master_new
loadtime:0.42818689346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:0.42832589149475 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='4841'DB:business_master_new
loadtime:0.42950892448425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:0.42960596084595 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='4841'DB:business_master_new
loadtime:0.4308500289917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:0.43091988563538 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='4841'DB:business_master_new
loadtime:0.4322829246521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:0.43232583999634 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='4841'DB:business_master_new
loadtime:0.4335629940033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:0.43369483947754 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='4841'DB:business_master_new
loadtime:0.43754982948303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.43759894371033 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='4841'DB:business_master_new
loadtime:0.43860483169556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.43878388404846 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='4841'DB:business_master_new
loadtime:0.439945936203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:0.43998098373413 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='4841'DB:business_master_new
loadtime:0.44135093688965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:0.44140100479126 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='4841'DB:business_master_new
loadtime:0.44503879547119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:0.445072889328 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='4841'DB:business_master_new
loadtime:0.44927382469177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.44941902160645 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='4841'DB:business_master_new
loadtime:0.45059299468994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:0.45073080062866 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='4841'DB:business_master_new
loadtime:0.45184588432312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:0.45197701454163 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='4841'DB:business_master_new
loadtime:0.45328402519226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.45341491699219 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.45494484901428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.45499181747437 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='4841'DB:business_master_new
loadtime:0.45626902580261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:0.45631098747253 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='4841'DB:business_master_new
loadtime:0.45778393745422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:0.45792198181152 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='4841'DB:business_master_new
loadtime:0.45940780639648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:0.45950293540955 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='4841'DB:business_master_new
loadtime:0.46495580673218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:0.46500897407532 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='4841'DB:business_master_new
loadtime:0.46651983261108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.46664786338806 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='4841'DB:business_master_new
loadtime:0.46814489364624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.46828484535217 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='4841'DB:business_master_new
loadtime:0.46980881690979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:0.46994185447693 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='4841'DB:business_master_new
loadtime:0.47141289710999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:0.4715518951416 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.47307395935059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:0.47318387031555 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='4841'DB:business_master_new
loadtime:0.47883296012878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.47888588905334 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='4841'DB:business_master_new
loadtime:0.48043298721313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:0.48057103157043 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='4841'DB:business_master_new
loadtime:0.48207688331604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:0.48218989372253 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='4841'DB:business_master_new
loadtime:0.48381590843201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:0.48394894599915 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='4841'DB:business_master_new
loadtime:0.4854679107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.4856128692627 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='4841'DB:business_master_new
loadtime:0.48709583282471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.48719191551208 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='4841'DB:business_master_new
loadtime:0.48842883110046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:0.48856997489929 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='4841'DB:business_master_new
loadtime:0.49009799957275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:0.49021697044373 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.49179983139038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.49193096160889 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='4841'DB:business_master_new
loadtime:0.4961519241333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.49620389938354 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='4841'DB:business_master_new
loadtime:0.49771189689636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.49788284301758 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='4841'DB:business_master_new
loadtime:0.4991238117218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.49917483329773 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='4841'DB:business_master_new
loadtime:0.50006699562073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.50012803077698 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='4841'DB:business_master_new
loadtime:0.50141286849976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.50155401229858 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='4841'DB:business_master_new
loadtime:0.5026319026947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.50280499458313 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='4841'DB:business_master_new
loadtime:0.50385284423828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.50401496887207 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='4841'DB:business_master_new
loadtime:0.5052649974823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:0.5053768157959 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='4841'DB:business_master_new
loadtime:0.50644993782043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.50659394264221 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='4841'DB:business_master_new
loadtime:0.50716185569763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:0.50721001625061 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='4841'DB:business_master_new
loadtime:0.50798201560974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.50802302360535 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='4841'DB:business_master_new
loadtime:0.50867080688477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:0.50884485244751 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='4841'DB:business_master_new
loadtime:0.51404690742493 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:0.51408195495605 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='4841'DB:business_master_new
loadtime:0.51680493354797 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:0.51685500144958 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='4841'DB:business_master_new
loadtime:0.51785492897034 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:0.51800298690796 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='4841'DB:business_master_new
loadtime:0.51912403106689 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:0.51921892166138 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='4841'DB:business_master_new
loadtime:0.52328896522522 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:0.52334094047546 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='4841'DB:business_master_new
loadtime:0.52459383010864 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:0.52464699745178 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='4841'DB:business_master_new
loadtime:0.52521991729736 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:0.52525997161865 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='4841'DB:business_master_new
loadtime:0.52577495574951 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.52582383155823 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='4841'DB:business_master_new
loadtime:0.52635788917542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:0.52639293670654 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='4841'DB:business_master_new
loadtime:0.52690291404724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:0.52694082260132 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='4841'DB:business_master_new
loadtime:0.52746987342834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:0.52751898765564 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='4841'DB:business_master_new
loadtime:0.52807402610779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.52813386917114 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='4841'DB:business_master_new
loadtime:0.52867102622986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:0.52871894836426 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.52926588058472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:0.52931499481201 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='4841'DB:business_master_new
loadtime:0.53204798698425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.53209280967712 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='4841'DB:business_master_new
loadtime:0.53323101997375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.53341197967529 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='4841'DB:business_master_new
loadtime:0.53472995758057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:0.53479385375977 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='4841'DB:business_master_new
loadtime:0.54089498519897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:0.5409460067749 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='4841'DB:business_master_new
loadtime:0.5420618057251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:0.5421769618988 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='4841'DB:business_master_new
loadtime:0.54333400726318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.54346585273743 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='4841'DB:business_master_new
loadtime:0.54456400871277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:0.54461884498596 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='4841'DB:business_master_new
loadtime:0.54576992988586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:0.54581093788147 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='4841'DB:business_master_new
loadtime:0.54723501205444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:0.54728579521179 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='4841'DB:business_master_new
loadtime:0.54825282096863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:0.54828786849976 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='4841'DB:business_master_new
loadtime:0.54906702041626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:0.54919981956482 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='4841'DB:business_master_new
loadtime:0.55032992362976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:0.55040192604065 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='4841'DB:business_master_new
loadtime:0.5514190196991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.55152893066406 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='4841'DB:business_master_new
loadtime:0.55236196517944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:0.55250287055969 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='4841'DB:business_master_new
loadtime:0.55359792709351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.55369281768799 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='4841'DB:business_master_new
loadtime:0.55492687225342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:0.55497884750366 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='4841'DB:business_master_new
loadtime:0.55622792243958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:0.55626893043518 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='4841'DB:business_master_new
loadtime:0.55719184875488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.55732393264771 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='4841'DB:business_master_new
loadtime:0.55811500549316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:0.55825400352478 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='4841'DB:business_master_new
loadtime:0.55935192108154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:0.55949592590332 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='4841'DB:business_master_new
loadtime:0.56234979629517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:0.56239080429077 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='4841'DB:business_master_new
loadtime:0.56357383728027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.56371092796326 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='4841'DB:business_master_new
loadtime:0.56488394737244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.56494784355164 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='4841'DB:business_master_new
loadtime:0.56635689735413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:0.56639885902405 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='4841'DB:business_master_new
loadtime:0.56761693954468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.56778383255005 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='4841'DB:business_master_new
loadtime:0.5688648223877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.56902289390564 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='4841'DB:business_master_new
loadtime:0.57020688056946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.57034301757812 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='4841'DB:business_master_new
loadtime:0.57148790359497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:0.57163286209106 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='4841'DB:business_master_new
loadtime:0.57540988922119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:0.57545280456543 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='4841'DB:business_master_new
loadtime:0.57653403282166 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:0.57666492462158 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='4841'DB:business_master_new
loadtime:0.57776188850403 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:0.57786083221436 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='4841'DB:business_master_new
loadtime:0.57903099060059 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.57908201217651 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='4841'DB:business_master_new
loadtime:0.5805459022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:0.58058786392212 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='4841'DB:business_master_new
loadtime:0.5821578502655 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.58220601081848 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='4841'DB:business_master_new
loadtime:0.58334589004517 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:0.5834789276123 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='4841'DB:business_master_new
loadtime:0.58463382720947 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:0.58479881286621 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='4841'DB:business_master_new
loadtime:0.58584880828857 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:0.58596181869507 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='4841'DB:business_master_new
loadtime:0.58718085289001 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:0.58723092079163 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='4841'DB:business_master_new
loadtime:0.58829188346863 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:0.58840298652649 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='4841'DB:business_master_new
loadtime:0.58944797515869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:0.58949995040894 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='4841'DB:business_master_new
loadtime:0.59051084518433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.59055781364441 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='4841'DB:business_master_new
loadtime:0.59185385704041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.59197902679443 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='4841'DB:business_master_new
loadtime:0.59263181686401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:0.59267091751099 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='4841'DB:business_master_new
loadtime:0.59354281425476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:0.59358882904053 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='4841'DB:business_master_new
loadtime:0.59433197975159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:0.59444379806519 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='4841'DB:business_master_new
loadtime:0.59549188613892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.59559392929077 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='4841'DB:business_master_new
loadtime:0.59648990631104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:0.59653186798096 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='4841'DB:business_master_new
loadtime:0.59868192672729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.59874582290649 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='4841'DB:business_master_new
loadtime:0.59927701950073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.59931802749634 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='4841'DB:business_master_new
loadtime:0.59983396530151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:0.5998899936676 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='4841'DB:business_master_new
loadtime:0.60043597221375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:0.60048294067383 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='4841'DB:business_master_new
loadtime:0.60102891921997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.60107684135437 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='4841'DB:business_master_new
loadtime:0.60160493850708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:0.6016538143158 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='4841'DB:business_master_new
loadtime:0.60220098495483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.60223698616028 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='4841'DB:business_master_new
loadtime:0.60275888442993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.60279893875122 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='4841'DB:business_master_new
loadtime:0.60332584381104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:0.60337400436401 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='4841'DB:business_master_new
loadtime:0.6038818359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:0.60390996932983 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='4841'DB:business_master_new
loadtime:0.60441994667053 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.60450983047485 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.60466194152832 / seconds
Operation template executed (chunk cache operation)
loadtime:0.60472393035889 / seconds
template override:Default
loadtime:0.60475897789001 / 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='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.60547685623169 / seconds
Template Constructed, Array Rows:49
loadtime:0.60570287704468 / seconds
TOTAL EXECUTION TIME: 0.60552
loadtime:0.60577487945557 / seconds

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


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


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


_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] => directorystate )


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.60577988624573
TOTAL KEY ARRAYS: 69