Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00012588500976562 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0007479190826416 / seconds
host not found setting manual db connection
loadtime:0.0012679100036621 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001533031463623 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0018310546875 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0018949508666992 / seconds
zipcode:
loadtime:0.0019140243530273 / seconds
Query Executed:select * from search_referrer where page_hash='cd9a0784cba1ee6742f630a690568473' limit 10 DB:ezrox_toadli
loadtime:0.0021700859069824 / seconds
Operation header executed (non global)
loadtime:0.0021898746490479 / seconds
Operation leaderboard executed (non global)
loadtime:0.0022449493408203 / seconds
Operation square executed (non global)
loadtime:0.0022599697113037 / seconds
Operation square_bottom executed (non global)
loadtime:0.0022718906402588 / seconds
Operation smallsquare executed (non global)
loadtime:0.0022850036621094 / seconds
Operation headeradright executed (non global)
loadtime:0.0022969245910645 / seconds
Operation google_analytics executed (non global)
loadtime:0.0023078918457031 / seconds
Operation topstories executed (non global)
loadtime:0.0023188591003418 / seconds
Operation businessnearyou executed (non global)
loadtime:0.002331018447876 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0023419857025146 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.002579927444458 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0027570724487305 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0027980804443359 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0028660297393799 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0029060840606689 / seconds
Template key: archive_menu pushed
loadtime:0.002910852432251 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.002918004989624 / seconds
Template key: get_gravatar pushed
loadtime:0.0029220581054688 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0029270648956299 / seconds
*10)-10)+1 | start:0
loadtime:0.002953052520752 / seconds
Query loaded from cache:select * from categories where cat_URLid='eating-places'
loadtime:0.0029878616333008 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.0030179023742676 / seconds
DB connected to localhost business_master_new
loadtime:0.0032830238342285 / seconds
Query Executed:select * from `ct_catmap` where sic='5812' order by city ascDB:business_master_new
loadtime:0.0067570209503174 / seconds
Query stored in cache : _QUERY_www.toadli.come77d82a7416768327dd1eee38fbc0828
loadtime:0.0072119235992432 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.00724196434021 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='5812'DB:business_master_new
loadtime:0.0088150501251221 / seconds
Query stored in cache : _QUERY_www.toadli.com53b155edb4cd6adced98c55922ff9043
loadtime:0.0088560581207275 / seconds
273 / 11
loadtime:0.0088920593261719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.008936882019043 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='5812'DB:business_master_new
loadtime:0.0094778537750244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amston' limit 1
loadtime:0.0095369815826416 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='5812'DB:business_master_new
loadtime:0.011169910430908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.011223077774048 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='5812'DB:business_master_new
loadtime:0.012625932693481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonia' limit 1
loadtime:0.012695074081421 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='5812'DB:business_master_new
loadtime:0.061655044555664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.061752080917358 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='5812'DB:business_master_new
loadtime:0.062905073165894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.062968015670776 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='5812'DB:business_master_new
loadtime:0.099498987197876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballouville' limit 1
loadtime:0.099564075469971 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='5812'DB:business_master_new
loadtime:0.10005593299866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.10010600090027 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='5812'DB:business_master_new
loadtime:0.10088586807251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bantam' limit 1
loadtime:0.10093402862549 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='5812'DB:business_master_new
loadtime:0.10195899009705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barkhamsted' limit 1
loadtime:0.10202097892761 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='5812'DB:business_master_new
loadtime:0.1029748916626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon Falls' limit 1
loadtime:0.10302686691284 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='5812'DB:business_master_new
loadtime:0.12130498886108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.12136888504028 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='5812'DB:business_master_new
loadtime:0.14096689224243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.14103102684021 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='5812'DB:business_master_new
loadtime:0.14950394630432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.14956593513489 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='5812'DB:business_master_new
loadtime:0.19178485870361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.1918740272522 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='5812'DB:business_master_new
loadtime:0.19343400001526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.19350004196167 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='5812'DB:business_master_new
loadtime:0.21275591850281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.21282005310059 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='5812'DB:business_master_new
loadtime:0.21430897712708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Botsford' limit 1
loadtime:0.21435785293579 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='5812'DB:business_master_new
loadtime:0.21489000320435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozrah' limit 1
loadtime:0.21493792533875 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='5812'DB:business_master_new
loadtime:0.21594595909119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branford' limit 1
loadtime:0.21598792076111 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='5812'DB:business_master_new
loadtime:0.22509098052979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.22519898414612 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='5812'DB:business_master_new
loadtime:0.24130892753601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.24152803421021 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='5812'DB:business_master_new
loadtime:0.24261808395386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.24268794059753 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='5812'DB:business_master_new
loadtime:0.26755404472351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Brook' limit 1
loadtime:0.26762795448303 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='5812'DB:business_master_new
loadtime:0.26891994476318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.2689790725708 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='5812'DB:business_master_new
loadtime:0.27157402038574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.27164387702942 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='5812'DB:business_master_new
loadtime:0.27315187454224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.27320003509521 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='5812'DB:business_master_new
loadtime:0.27982902526855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.27987599372864 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='5812'DB:business_master_new
loadtime:0.28153395652771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.28157997131348 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='5812'DB:business_master_new
loadtime:0.2827730178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.28281188011169 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='5812'DB:business_master_new
loadtime:0.28958988189697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton Center' limit 1
loadtime:0.28963685035706 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='5812'DB:business_master_new
loadtime:0.29015493392944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerbrook' limit 1
loadtime:0.29018187522888 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='5812'DB:business_master_new
loadtime:0.29109597206116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Village' limit 1
loadtime:0.29113698005676 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='5812'DB:business_master_new
loadtime:0.2916579246521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaplin' limit 1
loadtime:0.29169392585754 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='5812'DB:business_master_new
loadtime:0.29243803024292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.29248285293579 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='5812'DB:business_master_new
loadtime:0.29594898223877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.2960090637207 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='5812'DB:business_master_new
loadtime:0.30127501487732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.30131888389587 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='5812'DB:business_master_new
loadtime:0.30944395065308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobalt' limit 1
loadtime:0.30958890914917 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='5812'DB:business_master_new
loadtime:0.31012606620789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.31017804145813 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='5812'DB:business_master_new
loadtime:0.31603288650513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.31609487533569 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='5812'DB:business_master_new
loadtime:0.31665802001953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.31672596931458 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='5812'DB:business_master_new
loadtime:0.31738996505737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.31743288040161 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='5812'DB:business_master_new
loadtime:0.3188009262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall' limit 1
loadtime:0.31885004043579 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='5812'DB:business_master_new
loadtime:0.31950688362122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall Bridge' limit 1
loadtime:0.31965088844299 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='5812'DB:business_master_new
loadtime:0.32063388824463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cos Cob' limit 1
loadtime:0.32068991661072 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='5812'DB:business_master_new
loadtime:0.33069205284119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.3307569026947 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='5812'DB:business_master_new
loadtime:0.33631491661072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.33637595176697 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='5812'DB:business_master_new
loadtime:0.34868001937866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.34874796867371 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='5812'DB:business_master_new
loadtime:0.36315202713013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danielson' limit 1
loadtime:0.36333703994751 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='5812'DB:business_master_new
loadtime:0.36787700653076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.36794805526733 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='5812'DB:business_master_new
loadtime:0.37097406387329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:0.37104392051697 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='5812'DB:business_master_new
loadtime:0.37254285812378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.37260103225708 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='5812'DB:business_master_new
loadtime:0.37435388565063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.37441086769104 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='5812'DB:business_master_new
loadtime:0.38310194015503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.38318204879761 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='5812'DB:business_master_new
loadtime:0.38687801361084 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berlin' limit 1
loadtime:0.38693284988403 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='5812'DB:business_master_new
loadtime:0.38785696029663 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Canaan' limit 1
loadtime:0.38791584968567 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='5812'DB:business_master_new
loadtime:0.38852906227112 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Glastonbury' limit 1
loadtime:0.38856387138367 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='5812'DB:business_master_new
loadtime:0.38910102844238 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Granby' limit 1
loadtime:0.38915205001831 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='5812'DB:business_master_new
loadtime:0.3936460018158 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haddam' limit 1
loadtime:0.39370894432068 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='5812'DB:business_master_new
loadtime:0.39519190788269 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampton' limit 1
loadtime:0.3952419757843 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='5812'DB:business_master_new
loadtime:0.39919590950012 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartford' limit 1
loadtime:0.39925789833069 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='5812'DB:business_master_new
loadtime:0.41353988647461 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartland' limit 1
loadtime:0.41359901428223 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='5812'DB:business_master_new
loadtime:0.41434502601624 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.41439390182495 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='5812'DB:business_master_new
loadtime:0.42629098892212 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Killingly' limit 1
loadtime:0.42637586593628 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='5812'DB:business_master_new
loadtime:0.42685794830322 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lyme' limit 1
loadtime:0.42690205574036 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='5812'DB:business_master_new
loadtime:0.42916202545166 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.42921996116638 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='5812'DB:business_master_new
loadtime:0.43475103378296 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor Hill' limit 1
loadtime:0.4347939491272 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='5812'DB:business_master_new
loadtime:0.43528294563293 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Woodstock' limit 1
loadtime:0.43532705307007 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='5812'DB:business_master_new
loadtime:0.43583488464355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastford' limit 1
loadtime:0.43587493896484 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='5812'DB:business_master_new
loadtime:0.43666100502014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.43672704696655 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='5812'DB:business_master_new
loadtime:0.44056701660156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellington' limit 1
loadtime:0.44061589241028 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='5812'DB:business_master_new
loadtime:0.44394302368164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.44400095939636 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='5812'DB:business_master_new
loadtime:0.45500087738037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.45507287979126 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='5812'DB:business_master_new
loadtime:0.45925998687744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fabyan' limit 1
loadtime:0.45932197570801 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='5812'DB:business_master_new
loadtime:0.45975303649902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.45979189872742 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='5812'DB:business_master_new
loadtime:0.46481490135193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Village' limit 1
loadtime:0.46491694450378 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='5812'DB:business_master_new
loadtime:0.4657769203186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.46583485603333 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='5812'DB:business_master_new
loadtime:0.47669386863708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Ferry' limit 1
loadtime:0.47675704956055 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='5812'DB:business_master_new
loadtime:0.47825002670288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylordsville' limit 1
loadtime:0.47828698158264 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='5812'DB:business_master_new
loadtime:0.47899794578552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.47904706001282 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='5812'DB:business_master_new
loadtime:0.48013591766357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.48018288612366 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='5812'DB:business_master_new
loadtime:0.48066687583923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgo' limit 1
loadtime:0.4807300567627 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='5812'DB:business_master_new
loadtime:0.48120808601379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glastonbury' limit 1
loadtime:0.48125290870667 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='5812'DB:business_master_new
loadtime:0.49345993995667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.49352097511292 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='5812'DB:business_master_new
loadtime:0.49494886398315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.49499702453613 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='5812'DB:business_master_new
loadtime:0.49914002418518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greens Farms' limit 1
loadtime:0.49920105934143 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='5812'DB:business_master_new
loadtime:0.49988794326782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.49994206428528 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='5812'DB:business_master_new
loadtime:0.50477194786072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosvenor Dale' limit 1
loadtime:0.50488591194153 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='5812'DB:business_master_new
loadtime:0.50539994239807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.50544786453247 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='5812'DB:business_master_new
loadtime:0.51214790344238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.51220989227295 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='5812'DB:business_master_new
loadtime:0.51484894752502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:0.51491785049438 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='5812'DB:business_master_new
loadtime:0.51610803604126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:0.5161669254303 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='5812'DB:business_master_new
loadtime:0.51673102378845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:0.51678490638733 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='5812'DB:business_master_new
loadtime:0.52122187614441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.5213360786438 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='5812'DB:business_master_new
loadtime:0.52223801612854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.52229595184326 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='5812'DB:business_master_new
loadtime:0.52274394035339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.52278304100037 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='5812'DB:business_master_new
loadtime:0.52687287330627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:0.52694892883301 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='5812'DB:business_master_new
loadtime:0.52859592437744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:0.52867388725281 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='5812'DB:business_master_new
loadtime:0.52930998802185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.52936887741089 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='5812'DB:business_master_new
loadtime:0.53114295005798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:0.53119397163391 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='5812'DB:business_master_new
loadtime:0.5325300693512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:0.53259086608887 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='5812'DB:business_master_new
loadtime:0.53350186347961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:0.53355097770691 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='5812'DB:business_master_new
loadtime:0.53656601905823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.53662705421448 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='5812'DB:business_master_new
loadtime:0.5383620262146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:0.53842186927795 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='5812'DB:business_master_new
loadtime:0.54036593437195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.54042387008667 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='5812'DB:business_master_new
loadtime:0.54089403152466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:0.5409369468689 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='5812'DB:business_master_new
loadtime:0.54235696792603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.54241800308228 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='5812'DB:business_master_new
loadtime:0.54410791397095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.54415988922119 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='5812'DB:business_master_new
loadtime:0.54569792747498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.54575395584106 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='5812'DB:business_master_new
loadtime:0.5493688583374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.5494339466095 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='5812'DB:business_master_new
loadtime:0.56284093856812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.56291103363037 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='5812'DB:business_master_new
loadtime:0.57539200782776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:0.57545900344849 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='5812'DB:business_master_new
loadtime:0.57713603973389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:0.57719707489014 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='5812'DB:business_master_new
loadtime:0.57773804664612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:0.57777905464172 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='5812'DB:business_master_new
loadtime:0.57826590538025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.57831597328186 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='5812'DB:business_master_new
loadtime:0.57890701293945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.57894802093506 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='5812'DB:business_master_new
loadtime:0.58086490631104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.58092308044434 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='5812'DB:business_master_new
loadtime:0.58454298973083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:0.58465194702148 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='5812'DB:business_master_new
loadtime:0.58523488044739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.58528900146484 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='5812'DB:business_master_new
loadtime:0.59025192260742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:0.59031987190247 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='5812'DB:business_master_new
loadtime:0.59177589416504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.59183406829834 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='5812'DB:business_master_new
loadtime:0.594074010849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.59413599967957 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='5812'DB:business_master_new
loadtime:0.5986180305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:0.5987548828125 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='5812'DB:business_master_new
loadtime:0.59959292411804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.5996470451355 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='5812'DB:business_master_new
loadtime:0.61353898048401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:0.61361789703369 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='5812'DB:business_master_new
loadtime:0.6142430305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:0.61429500579834 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='5812'DB:business_master_new
loadtime:0.61522698402405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:0.61526799201965 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='5812'DB:business_master_new
loadtime:0.61617994308472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:0.61623907089233 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='5812'DB:business_master_new
loadtime:0.61718702316284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.61724591255188 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='5812'DB:business_master_new
loadtime:0.6214919090271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.62155199050903 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='5812'DB:business_master_new
loadtime:0.63219094276428 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:0.63227796554565 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='5812'DB:business_master_new
loadtime:0.64620399475098 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:0.64626288414001 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='5812'DB:business_master_new
loadtime:0.64888286590576 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:0.64895796775818 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='5812'DB:business_master_new
loadtime:0.65362405776978 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.65369486808777 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='5812'DB:business_master_new
loadtime:0.65542697906494 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.65548706054688 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='5812'DB:business_master_new
loadtime:0.66286301612854 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.66310501098633 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='5812'DB:business_master_new
loadtime:0.66997003555298 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:0.67004704475403 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='5812'DB:business_master_new
loadtime:0.67848896980286 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:0.6785409450531 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='5812'DB:business_master_new
loadtime:0.67969703674316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.67975807189941 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='5812'DB:business_master_new
loadtime:0.68733096122742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.6873939037323 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='5812'DB:business_master_new
loadtime:0.69920802116394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:0.69928193092346 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='5812'DB:business_master_new
loadtime:0.70233988761902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.70240187644958 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='5812'DB:business_master_new
loadtime:0.70361089706421 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:0.70365500450134 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='5812'DB:business_master_new
loadtime:0.7090470790863 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:0.70911502838135 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='5812'DB:business_master_new
loadtime:0.70958685874939 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:0.709636926651 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='5812'DB:business_master_new
loadtime:0.71063303947449 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:0.71068787574768 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='5812'DB:business_master_new
loadtime:0.71153998374939 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:0.71159601211548 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='5812'DB:business_master_new
loadtime:0.71247792243958 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:0.71253204345703 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='5812'DB:business_master_new
loadtime:0.71579504013062 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:0.71587991714478 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='5812'DB:business_master_new
loadtime:0.7173969745636 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:0.71744990348816 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='5812'DB:business_master_new
loadtime:0.71787095069885 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:0.71790289878845 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='5812'DB:business_master_new
loadtime:0.71877503395081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.71883296966553 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='5812'DB:business_master_new
loadtime:0.719486951828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:0.71953296661377 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='5812'DB:business_master_new
loadtime:0.72204399108887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.72210693359375 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='5812'DB:business_master_new
loadtime:0.72815489768982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.72831606864929 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='5812'DB:business_master_new
loadtime:0.73581194877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.7358820438385 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='5812'DB:business_master_new
loadtime:0.73707103729248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.73713088035583 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='5812'DB:business_master_new
loadtime:0.73859691619873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:0.73867702484131 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='5812'DB:business_master_new
loadtime:0.74386787414551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:0.74391794204712 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='5812'DB:business_master_new
loadtime:0.74750900268555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:0.74756908416748 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='5812'DB:business_master_new
loadtime:0.74828290939331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:0.74832487106323 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='5812'DB:business_master_new
loadtime:0.75399899482727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:0.75405597686768 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='5812'DB:business_master_new
loadtime:0.75455594062805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.75460600852966 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='5812'DB:business_master_new
loadtime:0.76540994644165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.76550006866455 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='5812'DB:business_master_new
loadtime:0.77014589309692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:0.77020001411438 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='5812'DB:business_master_new
loadtime:0.77204585075378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:0.7721049785614 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='5812'DB:business_master_new
loadtime:0.77263402938843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:0.77268886566162 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='5812'DB:business_master_new
loadtime:0.77322602272034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.77328300476074 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='5812'DB:business_master_new
loadtime:0.77528095245361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:0.77534484863281 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='5812'DB:business_master_new
loadtime:0.77968907356262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:0.77975106239319 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='5812'DB:business_master_new
loadtime:0.78184103965759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.781898021698 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='5812'DB:business_master_new
loadtime:0.78240203857422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.78244805335999 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='5812'DB:business_master_new
loadtime:0.78340291976929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:0.78345108032227 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='5812'DB:business_master_new
loadtime:0.78408885002136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:0.78414797782898 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='5812'DB:business_master_new
loadtime:0.78540301322937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:0.7854380607605 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='5812'DB:business_master_new
loadtime:0.78605699539185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:0.78610491752625 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='5812'DB:business_master_new
loadtime:0.78873491287231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.78879189491272 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='5812'DB:business_master_new
loadtime:0.79011607170105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.79016804695129 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='5812'DB:business_master_new
loadtime:0.7952139377594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:0.79527902603149 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='5812'DB:business_master_new
loadtime:0.79800796508789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:0.79806590080261 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='5812'DB:business_master_new
loadtime:0.79905104637146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:0.79910492897034 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='5812'DB:business_master_new
loadtime:0.79969000816345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.79974007606506 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='5812'DB:business_master_new
loadtime:0.80506992340088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:0.80511808395386 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='5812'DB:business_master_new
loadtime:0.80572485923767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:0.80577206611633 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='5812'DB:business_master_new
loadtime:0.80632400512695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:0.80637192726135 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='5812'DB:business_master_new
loadtime:0.80936408042908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.80944585800171 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='5812'DB:business_master_new
loadtime:0.81329107284546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.81335687637329 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='5812'DB:business_master_new
loadtime:0.81393694877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:0.81397891044617 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='5812'DB:business_master_new
loadtime:0.81461095809937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:0.81466293334961 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='5812'DB:business_master_new
loadtime:0.82074499130249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.8208019733429 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='5812'DB:business_master_new
loadtime:0.82133889198303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.82138586044312 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='5812'DB:business_master_new
loadtime:0.82260990142822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.82267594337463 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='5812'DB:business_master_new
loadtime:0.82392597198486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.82398390769958 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='5812'DB:business_master_new
loadtime:0.8252010345459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.82525086402893 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='5812'DB:business_master_new
loadtime:0.82876205444336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.82882595062256 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='5812'DB:business_master_new
loadtime:0.82949995994568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.82954597473145 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='5812'DB:business_master_new
loadtime:0.83592391014099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.8359968662262 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='5812'DB:business_master_new
loadtime:0.83786797523499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:0.83792805671692 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='5812'DB:business_master_new
loadtime:0.84123206138611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.84133386611938 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='5812'DB:business_master_new
loadtime:0.84349608421326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:0.84355092048645 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='5812'DB:business_master_new
loadtime:0.84826803207397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.84832787513733 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='5812'DB:business_master_new
loadtime:0.85080099105835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:0.85085988044739 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='5812'DB:business_master_new
loadtime:0.85146307945251 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:0.85150599479675 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='5812'DB:business_master_new
loadtime:0.85195589065552 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:0.8520028591156 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='5812'DB:business_master_new
loadtime:0.8533718585968 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:0.85342502593994 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='5812'DB:business_master_new
loadtime:0.85410094261169 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:0.85415196418762 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='5812'DB:business_master_new
loadtime:0.85470294952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:0.85474896430969 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='5812'DB:business_master_new
loadtime:0.85521101951599 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:0.85526299476624 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='5812'DB:business_master_new
loadtime:0.85585904121399 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:0.85590505599976 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='5812'DB:business_master_new
loadtime:0.85798597335815 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.85804891586304 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='5812'DB:business_master_new
loadtime:0.85869193077087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:0.85873508453369 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='5812'DB:business_master_new
loadtime:0.86886405944824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:0.86893200874329 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='5812'DB:business_master_new
loadtime:0.87581992149353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:0.87588691711426 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='5812'DB:business_master_new
loadtime:0.88007998466492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.88014388084412 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='5812'DB:business_master_new
loadtime:0.88076996803284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:0.88082003593445 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='5812'DB:business_master_new
loadtime:0.88344502449036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:0.88350105285645 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='5812'DB:business_master_new
loadtime:0.88402795791626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.88408708572388 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='5812'DB:business_master_new
loadtime:0.91808390617371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.91831207275391 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='5812'DB:business_master_new
loadtime:0.91922903060913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:0.91928386688232 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='5812'DB:business_master_new
loadtime:0.91985392570496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:0.91990685462952 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='5812'DB:business_master_new
loadtime:0.92242193222046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:0.92308306694031 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='5812'DB:business_master_new
loadtime:0.92535901069641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.92543387413025 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='5812'DB:business_master_new
loadtime:0.92895007133484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:0.92905187606812 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='5812'DB:business_master_new
loadtime:0.93176698684692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:0.93183207511902 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='5812'DB:business_master_new
loadtime:0.93227791786194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:0.93231606483459 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='5812'DB:business_master_new
loadtime:0.93314599990845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:0.93322086334229 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='5812'DB:business_master_new
loadtime:0.93391394615173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:0.93395900726318 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='5812'DB:business_master_new
loadtime:0.93561506271362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:0.93570899963379 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='5812'DB:business_master_new
loadtime:0.93793892860413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.93804287910461 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='5812'DB:business_master_new
loadtime:0.93922805786133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:0.939288854599 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='5812'DB:business_master_new
loadtime:0.94294190406799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.94304585456848 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='5812'DB:business_master_new
loadtime:0.95159888267517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:0.9517719745636 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='5812'DB:business_master_new
loadtime:0.95474791526794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:0.95496606826782 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='5812'DB:business_master_new
loadtime:0.95696187019348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.9571259021759 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='5812'DB:business_master_new
loadtime:0.9588930606842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:0.95902895927429 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='5812'DB:business_master_new
loadtime:0.96483302116394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:0.96500396728516 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='5812'DB:business_master_new
loadtime:0.9655818939209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:0.96573495864868 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='5812'DB:business_master_new
loadtime:0.96678400039673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.96686601638794 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='5812'DB:business_master_new
loadtime:0.970871925354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.97115898132324 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='5812'DB:business_master_new
loadtime:0.97220206260681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:0.97233295440674 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='5812'DB:business_master_new
loadtime:0.97370195388794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.97385597229004 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='5812'DB:business_master_new
loadtime:0.98001790046692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.98054504394531 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='5812'DB:business_master_new
loadtime:0.98476099967957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.98495101928711 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='5812'DB:business_master_new
loadtime:0.98889708518982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:0.98906087875366 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='5812'DB:business_master_new
loadtime:0.98974299430847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:0.98986291885376 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='5812'DB:business_master_new
loadtime:0.99120688438416 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:0.99125504493713 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='5812'DB:business_master_new
loadtime:0.99221706390381 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:0.99235701560974 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='5812'DB:business_master_new
loadtime:0.99313592910767 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.99327397346497 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='5812'DB:business_master_new
loadtime:0.996013879776 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:0.99616694450378 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='5812'DB:business_master_new
loadtime:0.99672293663025 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.99683499336243 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='5812'DB:business_master_new
loadtime:1.0006530284882 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:1.0009748935699 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='5812'DB:business_master_new
loadtime:1.0016429424286 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:1.0018379688263 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='5812'DB:business_master_new
loadtime:1.0025720596313 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:1.0027370452881 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='5812'DB:business_master_new
loadtime:1.0041079521179 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:1.0042459964752 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='5812'DB:business_master_new
loadtime:1.0053770542145 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:1.005527973175 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='5812'DB:business_master_new
loadtime:1.0061209201813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:1.0062580108643 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='5812'DB:business_master_new
loadtime:1.0089690685272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:1.0091199874878 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='5812'DB:business_master_new
loadtime:1.0142810344696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:1.0144519805908 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='5812'DB:business_master_new
loadtime:1.01859998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:1.0188970565796 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='5812'DB:business_master_new
loadtime:1.02503490448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:1.0252058506012 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='5812'DB:business_master_new
loadtime:1.0283999443054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:1.0285260677338 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='5812'DB:business_master_new
loadtime:1.0299620628357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.0301170349121 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='5812'DB:business_master_new
loadtime:1.0329658985138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:1.0331699848175 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='5812'DB:business_master_new
loadtime:1.03373503685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:1.0338499546051 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='5812'DB:business_master_new
loadtime:1.034777879715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.0349068641663 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='5812'DB:business_master_new
loadtime:1.0408799648285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:1.0410070419312 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='5812'DB:business_master_new
loadtime:1.0442759990692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:1.044440984726 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='5812'DB:business_master_new
loadtime:1.0476250648499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:1.0478270053864 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='5812'DB:business_master_new
loadtime:1.0546309947968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:1.0548739433289 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='5812'DB:business_master_new
loadtime:1.0608818531036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:1.0610530376434 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='5812'DB:business_master_new
loadtime:1.0649700164795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.0651249885559 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='5812'DB:business_master_new
loadtime:1.0669510364532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:1.0670480728149 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='5812'DB:business_master_new
loadtime:1.067754983902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:1.067892074585 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='5812'DB:business_master_new
loadtime:1.0685629844666 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.0688140392303 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.0692398548126 / seconds
Operation template executed (chunk cache operation)
loadtime:1.0694289207458 / seconds
template override:Default
loadtime:1.0694770812988 / 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:1.0706448554993 / seconds
Template Constructed, Array Rows:49
loadtime:1.0712130069733 / seconds
TOTAL EXECUTION TIME: 1.0708
loadtime:1.0713179111481 / 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] => eating-places [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.0713219642639
TOTAL KEY ARRAYS: 69