Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.1048736572266E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018270015716553 / seconds
host not found setting manual db connection
loadtime:0.0096371173858643 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.009896993637085 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010078907012939 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010142087936401 / seconds
zipcode:
loadtime:0.01016902923584 / seconds
Query Executed:select * from search_referrer where page_hash='50a230197a7668ab0cdd1d27a5b939f7' limit 10 DB:ezrox_toadli
loadtime:0.010453939437866 / seconds
Operation header executed (non global)
loadtime:0.010494947433472 / seconds
Operation leaderboard executed (non global)
loadtime:0.010546922683716 / seconds
Operation square executed (non global)
loadtime:0.010576963424683 / seconds
Operation square_bottom executed (non global)
loadtime:0.010603904724121 / seconds
Operation smallsquare executed (non global)
loadtime:0.010633945465088 / seconds
Operation headeradright executed (non global)
loadtime:0.010664939880371 / seconds
Operation google_analytics executed (non global)
loadtime:0.010690927505493 / seconds
Operation topstories executed (non global)
loadtime:0.010715961456299 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010743141174316 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010766983032227 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011076927185059 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011318922042847 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011353969573975 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011413097381592 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.01147198677063 / seconds
Template key: archive_menu pushed
loadtime:0.011482000350952 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011496067047119 / seconds
Template key: get_gravatar pushed
loadtime:0.011502981185913 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011512041091919 / seconds
*10)-10)+1 | start:0
loadtime:0.011554002761841 / seconds
Query loaded from cache:select * from categories where cat_URLid='schools-and-educational-services-nec'
loadtime:0.01159405708313 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.011635065078735 / seconds
DB connected to localhost business_master_new
loadtime:0.011883020401001 / seconds
Query Executed:select * from `ct_catmap` where sic='8299' order by city ascDB:business_master_new
loadtime:0.022910118103027 / seconds
Query stored in cache : _QUERY_www.toadli.comd775325b7de2a60fe5e417d3af95171a
loadtime:0.024011135101318 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.024060964584351 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='8299'DB:business_master_new
loadtime:0.025690078735352 / seconds
Query stored in cache : _QUERY_www.toadli.coma3e1584842b69991901ffd40eb24a04c
loadtime:0.025726079940796 / seconds
273 / 11
loadtime:0.025782108306885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.0258469581604 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='8299'DB:business_master_new
loadtime:0.038613080978394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amston' limit 1
loadtime:0.038674116134644 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='8299'DB:business_master_new
loadtime:0.039720058441162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.039788961410522 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='8299'DB:business_master_new
loadtime:0.041070938110352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonia' limit 1
loadtime:0.041125059127808 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='8299'DB:business_master_new
loadtime:0.049130916595459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.049209117889404 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='8299'DB:business_master_new
loadtime:0.050738096237183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.050792932510376 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='8299'DB:business_master_new
loadtime:0.058161020278931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballouville' limit 1
loadtime:0.058233976364136 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='8299'DB:business_master_new
loadtime:0.058929920196533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.058984994888306 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='8299'DB:business_master_new
loadtime:0.060051918029785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bantam' limit 1
loadtime:0.060105085372925 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='8299'DB:business_master_new
loadtime:0.061489105224609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barkhamsted' limit 1
loadtime:0.061542987823486 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='8299'DB:business_master_new
loadtime:0.062813997268677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon Falls' limit 1
loadtime:0.062868118286133 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='8299'DB:business_master_new
loadtime:0.065546989440918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.065601110458374 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='8299'DB:business_master_new
loadtime:0.072874069213867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.072945117950439 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='8299'DB:business_master_new
loadtime:0.076465129852295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.076539039611816 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='8299'DB:business_master_new
loadtime:0.08340311050415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.083481073379517 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='8299'DB:business_master_new
loadtime:0.085477113723755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.085531949996948 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='8299'DB:business_master_new
loadtime:0.09299111366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.093064069747925 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='8299'DB:business_master_new
loadtime:0.095010995864868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Botsford' limit 1
loadtime:0.095066070556641 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='8299'DB:business_master_new
loadtime:0.095919132232666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozrah' limit 1
loadtime:0.095972061157227 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='8299'DB:business_master_new
loadtime:0.097219944000244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branford' limit 1
loadtime:0.097288131713867 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='8299'DB:business_master_new
loadtime:0.10417294502258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.10425710678101 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='8299'DB:business_master_new
loadtime:0.11113595962524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.11123895645142 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='8299'DB:business_master_new
loadtime:0.11268591880798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.11275792121887 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='8299'DB:business_master_new
loadtime:0.11962103843689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Brook' limit 1
loadtime:0.11969304084778 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='8299'DB:business_master_new
loadtime:0.12125897407532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.12131309509277 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='8299'DB:business_master_new
loadtime:0.12817692756653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.12826204299927 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='8299'DB:business_master_new
loadtime:0.13019013404846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.13024592399597 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='8299'DB:business_master_new
loadtime:0.13269209861755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.13275909423828 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='8299'DB:business_master_new
loadtime:0.13486003875732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.1349139213562 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='8299'DB:business_master_new
loadtime:0.13650107383728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.13656806945801 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='8299'DB:business_master_new
loadtime:0.14368891716003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton Center' limit 1
loadtime:0.14375710487366 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='8299'DB:business_master_new
loadtime:0.14454102516174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerbrook' limit 1
loadtime:0.14459490776062 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='8299'DB:business_master_new
loadtime:0.14584708213806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Village' limit 1
loadtime:0.14591503143311 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='8299'DB:business_master_new
loadtime:0.14674091339111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaplin' limit 1
loadtime:0.14679503440857 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='8299'DB:business_master_new
loadtime:0.14788699150085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.1479389667511 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='8299'DB:business_master_new
loadtime:0.15480613708496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.15487909317017 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='8299'DB:business_master_new
loadtime:0.15716791152954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.1572380065918 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='8299'DB:business_master_new
loadtime:0.16439008712769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobalt' limit 1
loadtime:0.1644721031189 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='8299'DB:business_master_new
loadtime:0.16522908210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.16528391838074 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='8299'DB:business_master_new
loadtime:0.17244911193848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.17252707481384 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='8299'DB:business_master_new
loadtime:0.17335104942322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.17341613769531 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='8299'DB:business_master_new
loadtime:0.17429804801941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.17435097694397 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='8299'DB:business_master_new
loadtime:0.17611908912659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall' limit 1
loadtime:0.176185131073 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='8299'DB:business_master_new
loadtime:0.17702698707581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall Bridge' limit 1
loadtime:0.17708110809326 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='8299'DB:business_master_new
loadtime:0.17829394340515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cos Cob' limit 1
loadtime:0.17834806442261 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='8299'DB:business_master_new
loadtime:0.18562602996826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.18570303916931 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='8299'DB:business_master_new
loadtime:0.1885130405426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.1885941028595 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='8299'DB:business_master_new
loadtime:0.19580602645874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.19587707519531 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='8299'DB:business_master_new
loadtime:0.20281291007996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danielson' limit 1
loadtime:0.20291900634766 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='8299'DB:business_master_new
loadtime:0.20612406730652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.20619702339172 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='8299'DB:business_master_new
loadtime:0.21318197250366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:0.21326613426208 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='8299'DB:business_master_new
loadtime:0.21502804756165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.21508407592773 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='8299'DB:business_master_new
loadtime:0.21718192100525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.21724891662598 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='8299'DB:business_master_new
loadtime:0.22461009025574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.22468400001526 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='8299'DB:business_master_new
loadtime:0.22725296020508 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berlin' limit 1
loadtime:0.22730898857117 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='8299'DB:business_master_new
loadtime:0.2285521030426 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Canaan' limit 1
loadtime:0.22860503196716 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='8299'DB:business_master_new
loadtime:0.22944211959839 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Glastonbury' limit 1
loadtime:0.22950506210327 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='8299'DB:business_master_new
loadtime:0.23023891448975 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Granby' limit 1
loadtime:0.23029208183289 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.2329409122467 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haddam' limit 1
loadtime:0.23299407958984 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='8299'DB:business_master_new
loadtime:0.23489308357239 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampton' limit 1
loadtime:0.2349591255188 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='8299'DB:business_master_new
loadtime:0.24207210540771 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartford' limit 1
loadtime:0.24214196205139 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='8299'DB:business_master_new
loadtime:0.24914002418518 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartland' limit 1
loadtime:0.24922108650208 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='8299'DB:business_master_new
loadtime:0.2502601146698 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.25031495094299 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='8299'DB:business_master_new
loadtime:0.25721502304077 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Killingly' limit 1
loadtime:0.25729393959045 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='8299'DB:business_master_new
loadtime:0.25808691978455 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lyme' limit 1
loadtime:0.25814294815063 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='8299'DB:business_master_new
loadtime:0.26055002212524 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.26061797142029 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='8299'DB:business_master_new
loadtime:0.2676990032196 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor Hill' limit 1
loadtime:0.26775407791138 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='8299'DB:business_master_new
loadtime:0.26850891113281 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Woodstock' limit 1
loadtime:0.26856207847595 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='8299'DB:business_master_new
loadtime:0.26933908462524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastford' limit 1
loadtime:0.26939296722412 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='8299'DB:business_master_new
loadtime:0.27052092552185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.27061104774475 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='8299'DB:business_master_new
loadtime:0.27771711349487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellington' limit 1
loadtime:0.27778911590576 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='8299'DB:business_master_new
loadtime:0.28487706184387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.28494691848755 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='8299'DB:business_master_new
loadtime:0.29184007644653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.29191613197327 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='8299'DB:business_master_new
loadtime:0.29897308349609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fabyan' limit 1
loadtime:0.29902911186218 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='8299'DB:business_master_new
loadtime:0.2997100353241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.29976391792297 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='8299'DB:business_master_new
loadtime:0.30665707588196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Village' limit 1
loadtime:0.3067479133606 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='8299'DB:business_master_new
loadtime:0.3079080581665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.30796504020691 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='8299'DB:business_master_new
loadtime:0.31482911109924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Ferry' limit 1
loadtime:0.31489992141724 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='8299'DB:business_master_new
loadtime:0.31680393218994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylordsville' limit 1
loadtime:0.31685900688171 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='8299'DB:business_master_new
loadtime:0.31782197952271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.31787705421448 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='8299'DB:business_master_new
loadtime:0.31919598579407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.31924891471863 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='8299'DB:business_master_new
loadtime:0.31994795799255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgo' limit 1
loadtime:0.32000112533569 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='8299'DB:business_master_new
loadtime:0.32067894935608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glastonbury' limit 1
loadtime:0.32073307037354 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='8299'DB:business_master_new
loadtime:0.32758593559265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.32765913009644 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='8299'DB:business_master_new
loadtime:0.32939505577087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.32945799827576 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.33224606513977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greens Farms' limit 1
loadtime:0.33231496810913 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='8299'DB:business_master_new
loadtime:0.33326101303101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.33331704139709 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='8299'DB:business_master_new
loadtime:0.34019494056702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosvenor Dale' limit 1
loadtime:0.34028196334839 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='8299'DB:business_master_new
loadtime:0.34099507331848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.34105205535889 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='8299'DB:business_master_new
loadtime:0.34840297698975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.34848713874817 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='8299'DB:business_master_new
loadtime:0.35535001754761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:0.35544800758362 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='8299'DB:business_master_new
loadtime:0.35686898231506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:0.35692596435547 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='8299'DB:business_master_new
loadtime:0.35772013664246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:0.3577721118927 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='8299'DB:business_master_new
loadtime:0.36463809013367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.36473393440247 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='8299'DB:business_master_new
loadtime:0.36585807800293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.36592602729797 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='8299'DB:business_master_new
loadtime:0.36661791801453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.3666729927063 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='8299'DB:business_master_new
loadtime:0.37354898452759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:0.37365198135376 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='8299'DB:business_master_new
loadtime:0.3756959438324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:0.37576603889465 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='8299'DB:business_master_new
loadtime:0.37655711174011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.37661600112915 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='8299'DB:business_master_new
loadtime:0.37875604629517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:0.37882304191589 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='8299'DB:business_master_new
loadtime:0.38038992881775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:0.38045406341553 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='8299'DB:business_master_new
loadtime:0.38159108161926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:0.38165807723999 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='8299'DB:business_master_new
loadtime:0.38453912734985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.38461112976074 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='8299'DB:business_master_new
loadtime:0.38673496246338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:0.38680291175842 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='8299'DB:business_master_new
loadtime:0.38907194137573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.38913893699646 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='8299'DB:business_master_new
loadtime:0.38989305496216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:0.38995909690857 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='8299'DB:business_master_new
loadtime:0.39168810844421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.39174294471741 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='8299'DB:business_master_new
loadtime:0.39377093315125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.39382600784302 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='8299'DB:business_master_new
loadtime:0.39569902420044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.3957691192627 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='8299'DB:business_master_new
loadtime:0.39937710762024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.39945292472839 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='8299'DB:business_master_new
loadtime:0.40637612342834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.40645813941956 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='8299'DB:business_master_new
loadtime:0.41332101821899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:0.41340112686157 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='8299'DB:business_master_new
loadtime:0.41540694236755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:0.41548204421997 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='8299'DB:business_master_new
loadtime:0.41625094413757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:0.41630506515503 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='8299'DB:business_master_new
loadtime:0.41701197624207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.41706609725952 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='8299'DB:business_master_new
loadtime:0.41797208786011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.41802501678467 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='8299'DB:business_master_new
loadtime:0.42031192779541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.42037796974182 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='8299'DB:business_master_new
loadtime:0.42725110054016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:0.42733097076416 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='8299'DB:business_master_new
loadtime:0.42812395095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.42817902565002 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='8299'DB:business_master_new
loadtime:0.43546295166016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:0.43553113937378 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='8299'DB:business_master_new
loadtime:0.43730306625366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.43736910820007 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='8299'DB:business_master_new
loadtime:0.44428110122681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.44435691833496 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='8299'DB:business_master_new
loadtime:0.45126891136169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:0.45135498046875 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='8299'DB:business_master_new
loadtime:0.45243501663208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.45249104499817 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='8299'DB:business_master_new
loadtime:0.45935010910034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:0.45943403244019 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='8299'DB:business_master_new
loadtime:0.46032691001892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:0.46038198471069 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='8299'DB:business_master_new
loadtime:0.46158909797668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:0.46164298057556 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='8299'DB:business_master_new
loadtime:0.46283411979675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:0.46288895606995 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='8299'DB:business_master_new
loadtime:0.46415305137634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.4642059803009 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='8299'DB:business_master_new
loadtime:0.47132301330566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.47139406204224 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='8299'DB:business_master_new
loadtime:0.47827410697937 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:0.47834706306458 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='8299'DB:business_master_new
loadtime:0.48522901535034 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:0.48530507087708 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='8299'DB:business_master_new
loadtime:0.49220013618469 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:0.49229001998901 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='8299'DB:business_master_new
loadtime:0.49960613250732 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.49968409538269 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='8299'DB:business_master_new
loadtime:0.50187206268311 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.50193905830383 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='8299'DB:business_master_new
loadtime:0.50887012481689 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.50898599624634 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='8299'DB:business_master_new
loadtime:0.51651906967163 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:0.51660895347595 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='8299'DB:business_master_new
loadtime:0.52350401878357 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:0.52358102798462 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='8299'DB:business_master_new
loadtime:0.52507495880127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.52513313293457 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='8299'DB:business_master_new
loadtime:0.53258800506592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.53266906738281 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='8299'DB:business_master_new
loadtime:0.53953909873962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:0.53961896896362 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='8299'DB:business_master_new
loadtime:0.54667997360229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.54675197601318 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='8299'DB:business_master_new
loadtime:0.5483250617981 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:0.54838109016418 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='8299'DB:business_master_new
loadtime:0.55564403533936 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:0.55569911003113 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='8299'DB:business_master_new
loadtime:0.55638408660889 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:0.55643701553345 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='8299'DB:business_master_new
loadtime:0.55777907371521 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:0.55783295631409 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.55894207954407 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:0.55899596214294 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='8299'DB:business_master_new
loadtime:0.56020307540894 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:0.5602560043335 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='8299'DB:business_master_new
loadtime:0.56716895103455 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:0.56724810600281 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='8299'DB:business_master_new
loadtime:0.56922507286072 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:0.56929206848145 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='8299'DB:business_master_new
loadtime:0.56998300552368 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:0.57003903388977 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='8299'DB:business_master_new
loadtime:0.57127594947815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.57133102416992 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='8299'DB:business_master_new
loadtime:0.5722439289093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:0.57229804992676 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='8299'DB:business_master_new
loadtime:0.57540607452393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.57546901702881 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='8299'DB:business_master_new
loadtime:0.58236193656921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.5824761390686 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='8299'DB:business_master_new
loadtime:0.58994293212891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.59001803398132 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='8299'DB:business_master_new
loadtime:0.59154605865479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.59160399436951 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='8299'DB:business_master_new
loadtime:0.59348511695862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:0.59353804588318 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='8299'DB:business_master_new
loadtime:0.60093307495117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:0.60100698471069 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='8299'DB:business_master_new
loadtime:0.60821104049683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:0.60828399658203 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='8299'DB:business_master_new
loadtime:0.60920310020447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:0.60925793647766 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='8299'DB:business_master_new
loadtime:0.6165509223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:0.61662101745605 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='8299'DB:business_master_new
loadtime:0.6173939704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.61744809150696 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='8299'DB:business_master_new
loadtime:0.62431502342224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.62438797950745 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='8299'DB:business_master_new
loadtime:0.63164305686951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:0.63171291351318 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='8299'DB:business_master_new
loadtime:0.63400793075562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:0.6340639591217 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='8299'DB:business_master_new
loadtime:0.6348729133606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:0.63492608070374 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='8299'DB:business_master_new
loadtime:0.63567996025085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.63573408126831 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='8299'DB:business_master_new
loadtime:0.63819098472595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:0.63825702667236 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='8299'DB:business_master_new
loadtime:0.64549207687378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:0.64555907249451 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='8299'DB:business_master_new
loadtime:0.64807891845703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.64814710617065 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='8299'DB:business_master_new
loadtime:0.64883804321289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.64889311790466 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='8299'DB:business_master_new
loadtime:0.65008211135864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:0.6501350402832 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='8299'DB:business_master_new
loadtime:0.65102410316467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:0.65107798576355 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='8299'DB:business_master_new
loadtime:0.65264511108398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:0.65271306037903 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='8299'DB:business_master_new
loadtime:0.65348505973816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:0.65353798866272 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='8299'DB:business_master_new
loadtime:0.65667605400085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.65674209594727 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='8299'DB:business_master_new
loadtime:0.65830492973328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.65835905075073 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='8299'DB:business_master_new
loadtime:0.66555595397949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:0.66562509536743 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='8299'DB:business_master_new
loadtime:0.67262005805969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:0.67269492149353 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='8299'DB:business_master_new
loadtime:0.67390108108521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:0.67396807670593 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='8299'DB:business_master_new
loadtime:0.67477297782898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.67482709884644 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='8299'DB:business_master_new
loadtime:0.68205904960632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:0.6821300983429 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='8299'DB:business_master_new
loadtime:0.68293213844299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:0.6829879283905 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='8299'DB:business_master_new
loadtime:0.68381690979004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:0.68387007713318 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='8299'DB:business_master_new
loadtime:0.69073510169983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.69082403182983 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='8299'DB:business_master_new
loadtime:0.69800901412964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.69808602333069 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='8299'DB:business_master_new
loadtime:0.69893193244934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:0.69899892807007 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='8299'DB:business_master_new
loadtime:0.69986391067505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:0.69991898536682 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='8299'DB:business_master_new
loadtime:0.70733404159546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.70740604400635 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='8299'DB:business_master_new
loadtime:0.70816612243652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.7082200050354 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='8299'DB:business_master_new
loadtime:0.70979690551758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.70985007286072 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='8299'DB:business_master_new
loadtime:0.71144700050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.71152091026306 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='8299'DB:business_master_new
loadtime:0.71298813819885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.71304392814636 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='8299'DB:business_master_new
loadtime:0.72016501426697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.72023701667786 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='8299'DB:business_master_new
loadtime:0.721195936203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.72125101089478 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='8299'DB:business_master_new
loadtime:0.72866702079773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.72875809669495 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='8299'DB:business_master_new
loadtime:0.73102712631226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:0.73111200332642 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='8299'DB:business_master_new
loadtime:0.73798608779907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.73806810379028 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='8299'DB:business_master_new
loadtime:0.74060606956482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:0.74066805839539 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='8299'DB:business_master_new
loadtime:0.74595212936401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.74602794647217 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='8299'DB:business_master_new
loadtime:0.74893093109131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:0.74899792671204 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='8299'DB:business_master_new
loadtime:0.74978613853455 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:0.74984002113342 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='8299'DB:business_master_new
loadtime:0.75054001808167 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:0.75059413909912 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='8299'DB:business_master_new
loadtime:0.752277135849 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:0.75233197212219 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='8299'DB:business_master_new
loadtime:0.75322008132935 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:0.75328612327576 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='8299'DB:business_master_new
loadtime:0.75406002998352 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:0.7541139125824 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='8299'DB:business_master_new
loadtime:0.75485491752625 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:0.75491905212402 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='8299'DB:business_master_new
loadtime:0.75580310821533 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:0.75585603713989 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='8299'DB:business_master_new
loadtime:0.76272797584534 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.76279997825623 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='8299'DB:business_master_new
loadtime:0.76369404792786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:0.76376104354858 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='8299'DB:business_master_new
loadtime:0.77160310745239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:0.77168011665344 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='8299'DB:business_master_new
loadtime:0.77921009063721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:0.77927994728088 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='8299'DB:business_master_new
loadtime:0.78423690795898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.78429198265076 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='8299'DB:business_master_new
loadtime:0.78516793251038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:0.78522109985352 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='8299'DB:business_master_new
loadtime:0.78841400146484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:0.78849101066589 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='8299'DB:business_master_new
loadtime:0.78923201560974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.7892861366272 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='8299'DB:business_master_new
loadtime:0.79620599746704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.79634809494019 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='8299'DB:business_master_new
loadtime:0.79744005203247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:0.79750990867615 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='8299'DB:business_master_new
loadtime:0.79831600189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:0.79836893081665 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='8299'DB:business_master_new
loadtime:0.80136394500732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:0.80141806602478 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='8299'DB:business_master_new
loadtime:0.8042049407959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.804279088974 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='8299'DB:business_master_new
loadtime:0.81115007400513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:0.81122994422913 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='8299'DB:business_master_new
loadtime:0.81448197364807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:0.81455111503601 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='8299'DB:business_master_new
loadtime:0.81523990631104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:0.81529498100281 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='8299'DB:business_master_new
loadtime:0.81643891334534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:0.8165020942688 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='8299'DB:business_master_new
loadtime:0.8174409866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:0.81751704216003 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='8299'DB:business_master_new
loadtime:0.81961297988892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:0.81968402862549 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='8299'DB:business_master_new
loadtime:0.82235598564148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.82242298126221 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='8299'DB:business_master_new
loadtime:0.82396292686462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:0.82401704788208 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='8299'DB:business_master_new
loadtime:0.8277690410614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.82783913612366 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='8299'DB:business_master_new
loadtime:0.83502101898193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:0.83509302139282 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='8299'DB:business_master_new
loadtime:0.84200000762939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:0.84208512306213 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='8299'DB:business_master_new
loadtime:0.84439206123352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.84444904327393 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='8299'DB:business_master_new
loadtime:0.84658002853394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:0.84665608406067 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='8299'DB:business_master_new
loadtime:0.85413193702698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:0.85421299934387 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='8299'DB:business_master_new
loadtime:0.85496401786804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:0.85502004623413 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='8299'DB:business_master_new
loadtime:0.85629391670227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.85634803771973 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='8299'DB:business_master_new
loadtime:0.86327004432678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.86335706710815 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='8299'DB:business_master_new
loadtime:0.8646719455719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:0.86474013328552 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='8299'DB:business_master_new
loadtime:0.86628913879395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.86634492874146 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='8299'DB:business_master_new
loadtime:0.87321591377258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.87330412864685 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='8299'DB:business_master_new
loadtime:0.88053798675537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.88059997558594 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='8299'DB:business_master_new
loadtime:0.88776993751526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:0.88782405853271 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='8299'DB:business_master_new
loadtime:0.88860011100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:0.88865399360657 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='8299'DB:business_master_new
loadtime:0.8902850151062 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:0.89033794403076 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='8299'DB:business_master_new
loadtime:0.8915319442749 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:0.89158797264099 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.89247703552246 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.89253211021423 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='8299'DB:business_master_new
loadtime:0.89940905570984 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:0.89950394630432 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='8299'DB:business_master_new
loadtime:0.90025091171265 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.90030694007874 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='8299'DB:business_master_new
loadtime:0.90717911720276 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:0.90725612640381 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='8299'DB:business_master_new
loadtime:0.90808200836182 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:0.90813803672791 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='8299'DB:business_master_new
loadtime:0.90904307365417 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:0.90909695625305 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='8299'DB:business_master_new
loadtime:0.91073513031006 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:0.91080212593079 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='8299'DB:business_master_new
loadtime:0.9121561050415 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:0.91221213340759 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='8299'DB:business_master_new
loadtime:0.91290998458862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:0.91296410560608 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='8299'DB:business_master_new
loadtime:0.91610193252563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.91615700721741 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='8299'DB:business_master_new
loadtime:0.92344903945923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.92352294921875 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='8299'DB:business_master_new
loadtime:0.93039798736572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:0.93052101135254 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='8299'DB:business_master_new
loadtime:0.93797492980957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:0.93805193901062 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='8299'DB:business_master_new
loadtime:0.94172501564026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:0.94179511070251 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='8299'DB:business_master_new
loadtime:0.9434700012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.94352507591248 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='8299'DB:business_master_new
loadtime:0.95042204856873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:0.95050191879272 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='8299'DB:business_master_new
loadtime:0.95123505592346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.95129108428955 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='8299'DB:business_master_new
loadtime:0.95244193077087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.95249509811401 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='8299'DB:business_master_new
loadtime:0.95983099937439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:0.95990300178528 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='8299'DB:business_master_new
loadtime:0.963711977005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:0.96378612518311 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='8299'DB:business_master_new
loadtime:0.96743893623352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.96750807762146 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='8299'DB:business_master_new
loadtime:0.97437906265259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:0.97445893287659 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='8299'DB:business_master_new
loadtime:0.98131895065308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.98138999938965 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='8299'DB:business_master_new
loadtime:0.98825597763062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.9883279800415 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='8299'DB:business_master_new
loadtime:0.99520897865295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:0.995276927948 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='8299'DB:business_master_new
loadtime:0.99609708786011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:0.99615097045898 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='8299'DB:business_master_new
loadtime:0.99704194068909 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.99719905853271 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.99759912490845 / seconds
Operation template executed (chunk cache operation)
loadtime:0.99775409698486 / seconds
template override:Default
loadtime:0.99779510498047 / 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.99913001060486 / seconds
Template Constructed, Array Rows:49
loadtime:0.99967002868652 / seconds
TOTAL EXECUTION TIME: 0.99922
loadtime:1.0014820098877 / 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] => schools-and-educational-services-nec [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:1.001492023468
TOTAL KEY ARRAYS: 69