Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00016689300537109 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0013389587402344 / seconds
host not found setting manual db connection
loadtime:0.0022768974304199 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0028729438781738 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0033118724822998 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0034430027008057 / seconds
zipcode:
loadtime:0.0034890174865723 / seconds
Query Executed:select * from search_referrer where page_hash='394cb6b841b8139b91504a5cfe19f55b' limit 10 DB:ezrox_toadli
loadtime:0.0039899349212646 / seconds
Operation header executed (non global)
loadtime:0.0040369033813477 / seconds
Operation leaderboard executed (non global)
loadtime:0.0041239261627197 / seconds
Operation square executed (non global)
loadtime:0.0041608810424805 / seconds
Operation square_bottom executed (non global)
loadtime:0.0042300224304199 / seconds
Operation smallsquare executed (non global)
loadtime:0.0042810440063477 / seconds
Operation headeradright executed (non global)
loadtime:0.0042970180511475 / seconds
Operation google_analytics executed (non global)
loadtime:0.0043160915374756 / seconds
Operation topstories executed (non global)
loadtime:0.0043280124664307 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0043389797210693 / seconds
Operation memberbuscount executed (non global)
loadtime:0.004349946975708 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0045709609985352 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.004878044128418 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0049149990081787 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0049769878387451 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.005012035369873 / seconds
Template key: archive_menu pushed
loadtime:0.005018949508667 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0050299167633057 / seconds
Template key: get_gravatar pushed
loadtime:0.0050349235534668 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0050389766693115 / seconds
*10)-10)+1 | start:0
loadtime:0.0050919055938721 / seconds
Query loaded from cache:select * from categories where cat_URLid='furniture-stores'
loadtime:0.0051829814910889 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.0052919387817383 / seconds
DB connected to localhost business_master_new
loadtime:0.0056369304656982 / seconds
Query Executed:select * from `ct_catmap` where sic='5712' order by city ascDB:business_master_new
loadtime:0.04284405708313 / seconds
Query stored in cache : _QUERY_www.toadli.comd4cd77e156817c20747de347d0c679b6
loadtime:0.043683052062988 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.043760061264038 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='5712'DB:business_master_new
loadtime:0.047329902648926 / seconds
Query stored in cache : _QUERY_www.toadli.com07695a261018dc890e33e497b9adc3c4
loadtime:0.047430992126465 / seconds
273 / 11
loadtime:0.047518014907837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.047631025314331 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='5712'DB:business_master_new
loadtime:0.051363945007324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amston' limit 1
loadtime:0.051420927047729 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='5712'DB:business_master_new
loadtime:0.052556037902832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.052603960037231 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='5712'DB:business_master_new
loadtime:0.054106950759888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonia' limit 1
loadtime:0.054238080978394 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='5712'DB:business_master_new
loadtime:0.055911064147949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.055974006652832 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='5712'DB:business_master_new
loadtime:0.063994884490967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.064052104949951 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='5712'DB:business_master_new
loadtime:0.065330982208252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballouville' limit 1
loadtime:0.065386056900024 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='5712'DB:business_master_new
loadtime:0.067354917526245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.067404985427856 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='5712'DB:business_master_new
loadtime:0.088321924209595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bantam' limit 1
loadtime:0.088377952575684 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='5712'DB:business_master_new
loadtime:0.10675406455994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barkhamsted' limit 1
loadtime:0.10682010650635 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='5712'DB:business_master_new
loadtime:0.10790109634399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon Falls' limit 1
loadtime:0.10795187950134 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='5712'DB:business_master_new
loadtime:0.11207103729248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.1121199131012 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='5712'DB:business_master_new
loadtime:0.11398196220398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.1140398979187 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='5712'DB:business_master_new
loadtime:0.11507987976074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.11513590812683 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='5712'DB:business_master_new
loadtime:0.11700201034546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.11706304550171 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='5712'DB:business_master_new
loadtime:0.1188530921936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.11891293525696 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='5712'DB:business_master_new
loadtime:0.11986088752747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.11989593505859 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='5712'DB:business_master_new
loadtime:0.12271499633789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Botsford' limit 1
loadtime:0.12276601791382 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='5712'DB:business_master_new
loadtime:0.12329792976379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozrah' limit 1
loadtime:0.12332487106323 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='5712'DB:business_master_new
loadtime:0.12911105155945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branford' limit 1
loadtime:0.12916493415833 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='5712'DB:business_master_new
loadtime:0.22285890579224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.22295904159546 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='5712'DB:business_master_new
loadtime:0.22808790206909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.22819495201111 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='5712'DB:business_master_new
loadtime:0.24247193336487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.24254393577576 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='5712'DB:business_master_new
loadtime:0.2437219619751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Brook' limit 1
loadtime:0.24378204345703 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='5712'DB:business_master_new
loadtime:0.26233887672424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.26238989830017 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='5712'DB:business_master_new
loadtime:0.26734304428101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.26740789413452 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='5712'DB:business_master_new
loadtime:0.27848601341248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.27854704856873 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='5712'DB:business_master_new
loadtime:0.28245306015015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.28248405456543 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='5712'DB:business_master_new
loadtime:0.28558301925659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.28562808036804 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='5712'DB:business_master_new
loadtime:0.28726601600647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.28730702400208 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='5712'DB:business_master_new
loadtime:0.28813290596008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton Center' limit 1
loadtime:0.28819704055786 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='5712'DB:business_master_new
loadtime:0.2887270450592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerbrook' limit 1
loadtime:0.28875803947449 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='5712'DB:business_master_new
loadtime:0.28969597816467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Village' limit 1
loadtime:0.28974008560181 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='5712'DB:business_master_new
loadtime:0.29029989242554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaplin' limit 1
loadtime:0.29032897949219 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='5712'DB:business_master_new
loadtime:0.29210495948792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.29215288162231 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='5712'DB:business_master_new
loadtime:0.29700207710266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.29705691337585 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='5712'DB:business_master_new
loadtime:0.30046010017395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.3005108833313 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='5712'DB:business_master_new
loadtime:0.3013699054718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobalt' limit 1
loadtime:0.30141091346741 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='5712'DB:business_master_new
loadtime:0.30188703536987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.30192995071411 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='5712'DB:business_master_new
loadtime:0.3027560710907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.30279898643494 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='5712'DB:business_master_new
loadtime:0.30334997177124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.30339193344116 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='5712'DB:business_master_new
loadtime:0.30461597442627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.30465698242188 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='5712'DB:business_master_new
loadtime:0.31721305847168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall' limit 1
loadtime:0.31726598739624 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='5712'DB:business_master_new
loadtime:0.31809902191162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall Bridge' limit 1
loadtime:0.31813097000122 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='5712'DB:business_master_new
loadtime:0.32133793830872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cos Cob' limit 1
loadtime:0.3213849067688 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='5712'DB:business_master_new
loadtime:0.32225298881531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.32229900360107 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='5712'DB:business_master_new
loadtime:0.322998046875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.32304286956787 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='5712'DB:business_master_new
loadtime:0.32383704185486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.32388305664062 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='5712'DB:business_master_new
loadtime:0.32866191864014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danielson' limit 1
loadtime:0.32872700691223 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='5712'DB:business_master_new
loadtime:0.32948398590088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.32953000068665 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='5712'DB:business_master_new
loadtime:0.33422207832336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:0.33427000045776 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='5712'DB:business_master_new
loadtime:0.34868597984314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.34879207611084 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='5712'DB:business_master_new
loadtime:0.35673689842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.35678696632385 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='5712'DB:business_master_new
loadtime:0.35775089263916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.35780692100525 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='5712'DB:business_master_new
loadtime:0.35853791236877 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berlin' limit 1
loadtime:0.3585798740387 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='5712'DB:business_master_new
loadtime:0.36197996139526 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Canaan' limit 1
loadtime:0.36202502250671 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='5712'DB:business_master_new
loadtime:0.36337900161743 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Glastonbury' limit 1
loadtime:0.36342787742615 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='5712'DB:business_master_new
loadtime:0.36453199386597 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Granby' limit 1
loadtime:0.36458206176758 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='5712'DB:business_master_new
loadtime:0.36534905433655 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haddam' limit 1
loadtime:0.36538410186768 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='5712'DB:business_master_new
loadtime:0.37191104888916 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampton' limit 1
loadtime:0.37195992469788 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='5712'DB:business_master_new
loadtime:0.37271499633789 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartford' limit 1
loadtime:0.37275004386902 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='5712'DB:business_master_new
loadtime:0.37379598617554 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartland' limit 1
loadtime:0.37385392189026 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='5712'DB:business_master_new
loadtime:0.37454104423523 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.37458300590515 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='5712'DB:business_master_new
loadtime:0.37563109397888 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Killingly' limit 1
loadtime:0.37569093704224 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='5712'DB:business_master_new
loadtime:0.37648606300354 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lyme' limit 1
loadtime:0.37653398513794 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='5712'DB:business_master_new
loadtime:0.38169288635254 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.38172793388367 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='5712'DB:business_master_new
loadtime:0.38248991966248 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor Hill' limit 1
loadtime:0.38254499435425 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='5712'DB:business_master_new
loadtime:0.38303303718567 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Woodstock' limit 1
loadtime:0.38306403160095 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='5712'DB:business_master_new
loadtime:0.38650608062744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastford' limit 1
loadtime:0.38655304908752 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='5712'DB:business_master_new
loadtime:0.38955187797546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.38959407806396 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='5712'DB:business_master_new
loadtime:0.39038395881653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellington' limit 1
loadtime:0.39043498039246 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='5712'DB:business_master_new
loadtime:0.39113903045654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.39117193222046 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='5712'DB:business_master_new
loadtime:0.39212608337402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.39217209815979 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='5712'DB:business_master_new
loadtime:0.39288592338562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fabyan' limit 1
loadtime:0.39292192459106 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='5712'DB:business_master_new
loadtime:0.39334797859192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.393385887146 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='5712'DB:business_master_new
loadtime:0.39829897880554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Village' limit 1
loadtime:0.39834403991699 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='5712'DB:business_master_new
loadtime:0.40027093887329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.4003210067749 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='5712'DB:business_master_new
loadtime:0.4013569355011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Ferry' limit 1
loadtime:0.40141487121582 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='5712'DB:business_master_new
loadtime:0.40765905380249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylordsville' limit 1
loadtime:0.40771889686584 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='5712'DB:business_master_new
loadtime:0.40879797935486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.40883898735046 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='5712'DB:business_master_new
loadtime:0.40981388092041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.40985488891602 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='5712'DB:business_master_new
loadtime:0.41026306152344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgo' limit 1
loadtime:0.41029000282288 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='5712'DB:business_master_new
loadtime:0.4106719493866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glastonbury' limit 1
loadtime:0.41070795059204 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='5712'DB:business_master_new
loadtime:0.41206908226013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.41210293769836 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='5712'DB:business_master_new
loadtime:0.41679406166077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.41684198379517 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='5712'DB:business_master_new
loadtime:0.4176139831543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greens Farms' limit 1
loadtime:0.41765999794006 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='5712'DB:business_master_new
loadtime:0.41995191574097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.41999292373657 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='5712'DB:business_master_new
loadtime:0.42477798461914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosvenor Dale' limit 1
loadtime:0.42484593391418 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='5712'DB:business_master_new
loadtime:0.42590689659119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.42595100402832 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='5712'DB:business_master_new
loadtime:0.42686796188354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.42692399024963 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='5712'DB:business_master_new
loadtime:0.43162894248962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:0.43168091773987 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='5712'DB:business_master_new
loadtime:0.43410491943359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:0.43415403366089 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='5712'DB:business_master_new
loadtime:0.43464803695679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:0.43468809127808 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='5712'DB:business_master_new
loadtime:0.43935894966125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.43942189216614 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='5712'DB:business_master_new
loadtime:0.44202899932861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.44207906723022 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='5712'DB:business_master_new
loadtime:0.44251894950867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.44255590438843 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='5712'DB:business_master_new
loadtime:0.44720506668091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:0.44724297523499 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='5712'DB:business_master_new
loadtime:0.45183205604553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:0.45188188552856 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='5712'DB:business_master_new
loadtime:0.45287108421326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.45291304588318 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='5712'DB:business_master_new
loadtime:0.45573902130127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:0.4557991027832 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='5712'DB:business_master_new
loadtime:0.45880889892578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:0.45885992050171 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='5712'DB:business_master_new
loadtime:0.46047902107239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:0.46051597595215 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='5712'DB:business_master_new
loadtime:0.46127104759216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.46133208274841 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='5712'DB:business_master_new
loadtime:0.46490502357483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:0.4649510383606 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='5712'DB:business_master_new
loadtime:0.46792387962341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.46798300743103 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='5712'DB:business_master_new
loadtime:0.46846199035645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:0.46849203109741 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='5712'DB:business_master_new
loadtime:0.4712929725647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.47133994102478 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='5712'DB:business_master_new
loadtime:0.47479891777039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.47485899925232 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='5712'DB:business_master_new
loadtime:0.4773850440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.47743105888367 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='5712'DB:business_master_new
loadtime:0.47822594642639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.47828197479248 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='5712'DB:business_master_new
loadtime:0.48016691207886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.48024010658264 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='5712'DB:business_master_new
loadtime:0.48495101928711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:0.48500895500183 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='5712'DB:business_master_new
loadtime:0.48756790161133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:0.48760294914246 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='5712'DB:business_master_new
loadtime:0.4880850315094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:0.4881329536438 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='5712'DB:business_master_new
loadtime:0.48857808113098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.48862600326538 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='5712'DB:business_master_new
loadtime:0.48967504501343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.48971009254456 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='5712'DB:business_master_new
loadtime:0.49467396736145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.49472308158875 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='5712'DB:business_master_new
loadtime:0.49940204620361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:0.49945187568665 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='5712'DB:business_master_new
loadtime:0.50061702728271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.50064706802368 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='5712'DB:business_master_new
loadtime:0.50148391723633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:0.50152802467346 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='5712'DB:business_master_new
loadtime:0.50394105911255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.50398206710815 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='5712'DB:business_master_new
loadtime:0.50864195823669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.50867605209351 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='5712'DB:business_master_new
loadtime:0.51335406303406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:0.51341390609741 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='5712'DB:business_master_new
loadtime:0.51483702659607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.51488900184631 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='5712'DB:business_master_new
loadtime:0.51607799530029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:0.51612305641174 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='5712'DB:business_master_new
loadtime:0.51673698425293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:0.51678705215454 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='5712'DB:business_master_new
loadtime:0.5185968875885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:0.51862788200378 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='5712'DB:business_master_new
loadtime:0.52016401290894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:0.52021598815918 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='5712'DB:business_master_new
loadtime:0.52255797386169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.52260088920593 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='5712'DB:business_master_new
loadtime:0.52339696884155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.52343606948853 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='5712'DB:business_master_new
loadtime:0.52449297904968 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:0.52453708648682 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='5712'DB:business_master_new
loadtime:0.52919602394104 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:0.52923393249512 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='5712'DB:business_master_new
loadtime:0.53387093544006 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:0.53391909599304 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='5712'DB:business_master_new
loadtime:0.53476190567017 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.53480792045593 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='5712'DB:business_master_new
loadtime:0.53835701942444 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.53844308853149 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='5712'DB:business_master_new
loadtime:0.54316902160645 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.5432460308075 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='5712'DB:business_master_new
loadtime:0.54414200782776 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:0.54419589042664 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='5712'DB:business_master_new
loadtime:0.54514694213867 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:0.54519510269165 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='5712'DB:business_master_new
loadtime:0.54716897010803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.54726195335388 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='5712'DB:business_master_new
loadtime:0.5483238697052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.54839706420898 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='5712'DB:business_master_new
loadtime:0.54950308799744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:0.54954195022583 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='5712'DB:business_master_new
loadtime:0.55029296875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.55033493041992 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='5712'DB:business_master_new
loadtime:0.55282402038574 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:0.55285692214966 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='5712'DB:business_master_new
loadtime:0.55375194549561 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:0.55379891395569 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='5712'DB:business_master_new
loadtime:0.55471992492676 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:0.55474710464478 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='5712'DB:business_master_new
loadtime:0.55641889572144 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:0.55645895004272 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='5712'DB:business_master_new
loadtime:0.55727100372314 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:0.55731701850891 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='5712'DB:business_master_new
loadtime:0.55945301055908 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:0.55948400497437 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='5712'DB:business_master_new
loadtime:0.56414604187012 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:0.56421089172363 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='5712'DB:business_master_new
loadtime:0.56598591804504 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:0.56602001190186 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='5712'DB:business_master_new
loadtime:0.56678295135498 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:0.5668408870697 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='5712'DB:business_master_new
loadtime:0.5684449672699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.56847405433655 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='5712'DB:business_master_new
loadtime:0.56907200813293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:0.56948590278625 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='5712'DB:business_master_new
loadtime:0.57026696205139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.57030701637268 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='5712'DB:business_master_new
loadtime:0.57501602172852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.57509398460388 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='5712'DB:business_master_new
loadtime:0.5760669708252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.57612705230713 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='5712'DB:business_master_new
loadtime:0.57838201522827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.57843399047852 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='5712'DB:business_master_new
loadtime:0.58061194419861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:0.58065795898438 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='5712'DB:business_master_new
loadtime:0.58160090446472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:0.58165001869202 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='5712'DB:business_master_new
loadtime:0.58243799209595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:0.58247709274292 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='5712'DB:business_master_new
loadtime:0.58309292793274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:0.58312392234802 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='5712'DB:business_master_new
loadtime:0.58396196365356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:0.5840048789978 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='5712'DB:business_master_new
loadtime:0.58447504043579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.5845000743866 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='5712'DB:business_master_new
loadtime:0.58571791648865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.58578610420227 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='5712'DB:business_master_new
loadtime:0.58661389350891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:0.58665609359741 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='5712'DB:business_master_new
loadtime:0.58952307701111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:0.58955001831055 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='5712'DB:business_master_new
loadtime:0.59048795700073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:0.59054207801819 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='5712'DB:business_master_new
loadtime:0.59149098396301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.5915379524231 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='5712'DB:business_master_new
loadtime:0.59520506858826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:0.59525203704834 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='5712'DB:business_master_new
loadtime:0.59606409072876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:0.59609889984131 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='5712'DB:business_master_new
loadtime:0.59682202339172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.59687209129333 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='5712'DB:business_master_new
loadtime:0.59731101989746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.59735202789307 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='5712'DB:business_master_new
loadtime:0.5991370677948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:0.59920501708984 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='5712'DB:business_master_new
loadtime:0.60056710243225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:0.60060405731201 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='5712'DB:business_master_new
loadtime:0.60279488563538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:0.602863073349 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='5712'DB:business_master_new
loadtime:0.60507702827454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:0.60511994361877 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='5712'DB:business_master_new
loadtime:0.60584092140198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.60588192939758 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='5712'DB:business_master_new
loadtime:0.60787796974182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.60790705680847 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='5712'DB:business_master_new
loadtime:0.60874795913696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:0.60879588127136 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='5712'DB:business_master_new
loadtime:0.60957193374634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:0.60961294174194 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='5712'DB:business_master_new
loadtime:0.61047601699829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:0.61051392555237 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='5712'DB:business_master_new
loadtime:0.61100697517395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.61104488372803 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='5712'DB:business_master_new
loadtime:0.61193895339966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:0.61198306083679 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='5712'DB:business_master_new
loadtime:0.61252093315125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:0.61255097389221 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='5712'DB:business_master_new
loadtime:0.61309289932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:0.61312794685364 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='5712'DB:business_master_new
loadtime:0.61782598495483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.61788702011108 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='5712'DB:business_master_new
loadtime:0.61869502067566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.6187469959259 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='5712'DB:business_master_new
loadtime:0.61931490898132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:0.6193470954895 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='5712'DB:business_master_new
loadtime:0.62022089958191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:0.62032508850098 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='5712'DB:business_master_new
loadtime:0.62149691581726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.62154507637024 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='5712'DB:business_master_new
loadtime:0.62201189994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.62204790115356 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='5712'DB:business_master_new
loadtime:0.62359309196472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.6236400604248 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='5712'DB:business_master_new
loadtime:0.62485194206238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.62490010261536 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='5712'DB:business_master_new
loadtime:0.62739896774292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.62747287750244 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='5712'DB:business_master_new
loadtime:0.6282320022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.62830090522766 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='5712'DB:business_master_new
loadtime:0.62889289855957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.6289439201355 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='5712'DB:business_master_new
loadtime:0.62987804412842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.62994194030762 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='5712'DB:business_master_new
loadtime:0.6324200630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:0.63245606422424 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='5712'DB:business_master_new
loadtime:0.63713788986206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.63721990585327 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='5712'DB:business_master_new
loadtime:0.64070200920105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:0.64075207710266 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='5712'DB:business_master_new
loadtime:0.6416380405426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.64169692993164 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='5712'DB:business_master_new
loadtime:0.64241003990173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:0.64246702194214 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='5712'DB:business_master_new
loadtime:0.64299488067627 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:0.64303088188171 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='5712'DB:business_master_new
loadtime:0.64350390434265 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:0.64355301856995 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='5712'DB:business_master_new
loadtime:0.64519095420837 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:0.64523386955261 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='5712'DB:business_master_new
loadtime:0.64582490921021 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:0.64587998390198 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='5712'DB:business_master_new
loadtime:0.64634704589844 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:0.64637589454651 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='5712'DB:business_master_new
loadtime:0.64679408073425 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:0.64684295654297 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='5712'DB:business_master_new
loadtime:0.64740610122681 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:0.64744091033936 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='5712'DB:business_master_new
loadtime:0.65210890769958 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.65216898918152 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='5712'DB:business_master_new
loadtime:0.65275907516479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:0.65281510353088 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='5712'DB:business_master_new
loadtime:0.65395188331604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:0.65399694442749 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='5712'DB:business_master_new
loadtime:0.65497207641602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:0.65502691268921 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='5712'DB:business_master_new
loadtime:0.65587496757507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.65591907501221 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='5712'DB:business_master_new
loadtime:0.65653705596924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:0.65658593177795 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.65734505653381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:0.65738797187805 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='5712'DB:business_master_new
loadtime:0.65784597396851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.6578950881958 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='5712'DB:business_master_new
loadtime:0.66260099411011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.66267490386963 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='5712'DB:business_master_new
loadtime:0.66356897354126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:0.66361904144287 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='5712'DB:business_master_new
loadtime:0.66416192054749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:0.66423392295837 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='5712'DB:business_master_new
loadtime:0.66500091552734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:0.66506195068359 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='5712'DB:business_master_new
loadtime:0.66759610176086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.66765093803406 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='5712'DB:business_master_new
loadtime:0.67231488227844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:0.67236590385437 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='5712'DB:business_master_new
loadtime:0.67314505577087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:0.6732120513916 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='5712'DB:business_master_new
loadtime:0.67365908622742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:0.67369508743286 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='5712'DB:business_master_new
loadtime:0.67451000213623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:0.67455887794495 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='5712'DB:business_master_new
loadtime:0.67568588256836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:0.67572093009949 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='5712'DB:business_master_new
loadtime:0.67779588699341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:0.6778450012207 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='5712'DB:business_master_new
loadtime:0.68153190612793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.68159198760986 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='5712'DB:business_master_new
loadtime:0.68271088600159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:0.68275189399719 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='5712'DB:business_master_new
loadtime:0.68356394767761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.6836199760437 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='5712'DB:business_master_new
loadtime:0.68468499183655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:0.68474507331848 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='5712'DB:business_master_new
loadtime:0.68944096565247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:0.68948602676392 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='5712'DB:business_master_new
loadtime:0.69209098815918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.6921489238739 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='5712'DB:business_master_new
loadtime:0.6938099861145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:0.69386100769043 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='5712'DB:business_master_new
loadtime:0.69478297233582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:0.69483995437622 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='5712'DB:business_master_new
loadtime:0.6952760219574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:0.69530391693115 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='5712'DB:business_master_new
loadtime:0.69624304771423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.69629001617432 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='5712'DB:business_master_new
loadtime:0.70098400115967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.70104694366455 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='5712'DB:business_master_new
loadtime:0.70242500305176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:0.70248293876648 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='5712'DB:business_master_new
loadtime:0.70363807678223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.70367407798767 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='5712'DB:business_master_new
loadtime:0.70836210250854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.70843100547791 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='5712'DB:business_master_new
loadtime:0.70922708511353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.70928287506104 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='5712'DB:business_master_new
loadtime:0.71008896827698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:0.71013498306274 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='5712'DB:business_master_new
loadtime:0.71066403388977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:0.71071195602417 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='5712'DB:business_master_new
loadtime:0.71279096603394 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:0.71283388137817 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='5712'DB:business_master_new
loadtime:0.71369099617004 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:0.71373796463013 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='5712'DB:business_master_new
loadtime:0.71434497833252 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.71437287330627 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='5712'DB:business_master_new
loadtime:0.7190089225769 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:0.71906399726868 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='5712'DB:business_master_new
loadtime:0.71952390670776 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.71956396102905 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='5712'DB:business_master_new
loadtime:0.72423100471497 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:0.72429299354553 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='5712'DB:business_master_new
loadtime:0.7248420715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:0.72487807273865 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='5712'DB:business_master_new
loadtime:0.7254810333252 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:0.72552704811096 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='5712'DB:business_master_new
loadtime:0.72670888900757 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:0.72675609588623 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='5712'DB:business_master_new
loadtime:0.72823810577393 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:0.72827410697937 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='5712'DB:business_master_new
loadtime:0.72871804237366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:0.72876501083374 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='5712'DB:business_master_new
loadtime:0.72952604293823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.72957301139832 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='5712'DB:business_master_new
loadtime:0.73041105270386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.73046493530273 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='5712'DB:business_master_new
loadtime:0.73517608642578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:0.73524594306946 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='5712'DB:business_master_new
loadtime:0.73620104789734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:0.73625898361206 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='5712'DB:business_master_new
loadtime:0.73702502250671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:0.73706007003784 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='5712'DB:business_master_new
loadtime:0.73832297325134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.73836898803711 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='5712'DB:business_master_new
loadtime:0.74303889274597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:0.74310088157654 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='5712'DB:business_master_new
loadtime:0.74360394477844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.74364495277405 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='5712'DB:business_master_new
loadtime:0.74602198600769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.74606895446777 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='5712'DB:business_master_new
loadtime:0.74698805809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:0.7470428943634 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='5712'DB:business_master_new
loadtime:0.74784708023071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:0.7478940486908 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='5712'DB:business_master_new
loadtime:0.74867987632751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.74871587753296 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='5712'DB:business_master_new
loadtime:0.74965691566467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:0.74971199035645 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='5712'DB:business_master_new
loadtime:0.75062203407288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.75067090988159 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='5712'DB:business_master_new
loadtime:0.75148391723633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.7515389919281 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='5712'DB:business_master_new
loadtime:0.75222206115723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:0.75226497650146 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='5712'DB:business_master_new
loadtime:0.75279402732849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:0.75284290313721 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='5712'DB:business_master_new
loadtime:0.75347709655762 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.75356006622314 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.75373888015747 / seconds
Operation template executed (chunk cache operation)
loadtime:0.75382089614868 / seconds
template override:Default
loadtime:0.75383996963501 / 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.75461506843567 / seconds
Template Constructed, Array Rows:49
loadtime:0.75485301017761 / seconds
TOTAL EXECUTION TIME: 0.75466
loadtime:0.75495004653931 / 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] => furniture-stores [stateURLid] => connecticut )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


Array ( [0] => cache [1] => query [2] => output [3] => session [4] => db [5] => db2 [6] => dbnew [7] => sphinxsearch [8] => sphinx [9] => dbConn [10] => functions [11] => sphinx_search [12] => template_operations [13] => buildtemplate [14] => syndication_handler [15] => directorystate )


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.75495505332947
TOTAL KEY ARRAYS: 69