Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.7036361694336E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00077915191650391 / seconds
host not found setting manual db connection
loadtime:0.0013880729675293 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018231868743896 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.00211501121521 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0022041797637939 / seconds
zipcode:
loadtime:0.0022330284118652 / seconds
Query Executed:select * from search_referrer where page_hash='e7ba6bd73cd727d718071e6ab28223ca' limit 10 DB:ezrox_toadli
loadtime:0.0025641918182373 / seconds
Operation header executed (non global)
loadtime:0.0026111602783203 / seconds
Operation leaderboard executed (non global)
loadtime:0.0026760101318359 / seconds
Operation square executed (non global)
loadtime:0.0026991367340088 / seconds
Operation square_bottom executed (non global)
loadtime:0.0027201175689697 / seconds
Operation smallsquare executed (non global)
loadtime:0.0027401447296143 / seconds
Operation headeradright executed (non global)
loadtime:0.0027580261230469 / seconds
Operation google_analytics executed (non global)
loadtime:0.0027761459350586 / seconds
Operation topstories executed (non global)
loadtime:0.0027940273284912 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0028131008148193 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0028300285339355 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0032072067260742 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0034592151641846 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0035250186920166 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0036580562591553 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.00372314453125 / seconds
Template key: archive_menu pushed
loadtime:0.0037322044372559 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0037510395050049 / seconds
Template key: get_gravatar pushed
loadtime:0.0037591457366943 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0037660598754883 / seconds
*10)-10)+1 | start:0
loadtime:0.0038051605224609 / seconds
Query loaded from cache:select * from categories where cat_URLid='gasoline-service-station'
loadtime:0.0039060115814209 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.0039350986480713 / seconds
DB connected to localhost business_master_new
loadtime:0.0042910575866699 / seconds
Query Executed:select * from `ct_catmap` where sic='5541' order by city ascDB:business_master_new
loadtime:0.042733192443848 / seconds
Query stored in cache : _QUERY_www.toadli.coma13523d9a6c03ea4a8696faa3268755e
loadtime:0.0435471534729 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.043617010116577 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='5541'DB:business_master_new
loadtime:0.04610800743103 / seconds
Query stored in cache : _QUERY_www.toadli.comc0deed71494a46941437082d749355be
loadtime:0.04615306854248 / seconds
273 / 11
loadtime:0.046205997467041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.046296119689941 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='5541'DB:business_master_new
loadtime:0.062718152999878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amston' limit 1
loadtime:0.062772035598755 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='5541'DB:business_master_new
loadtime:0.074636220932007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.074726104736328 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='5541'DB:business_master_new
loadtime:0.1000862121582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonia' limit 1
loadtime:0.10014319419861 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='5541'DB:business_master_new
loadtime:0.10425806045532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.10432314872742 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='5541'DB:business_master_new
loadtime:0.14578223228455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.14583301544189 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='5541'DB:business_master_new
loadtime:0.14750909805298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballouville' limit 1
loadtime:0.14759016036987 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='5541'DB:business_master_new
loadtime:0.14985013008118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.14990019798279 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='5541'DB:business_master_new
loadtime:0.16123914718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bantam' limit 1
loadtime:0.16128516197205 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='5541'DB:business_master_new
loadtime:0.18211317062378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barkhamsted' limit 1
loadtime:0.18217706680298 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='5541'DB:business_master_new
loadtime:0.20141506195068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon Falls' limit 1
loadtime:0.20146703720093 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.27510499954224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.27516317367554 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='5541'DB:business_master_new
loadtime:0.27686905860901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.27692723274231 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='5541'DB:business_master_new
loadtime:0.27799320220947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.27805018424988 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='5541'DB:business_master_new
loadtime:0.28068709373474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.28075218200684 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='5541'DB:business_master_new
loadtime:0.31828308105469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.31833505630493 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='5541'DB:business_master_new
loadtime:0.32064414024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.3206901550293 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='5541'DB:business_master_new
loadtime:0.35690021514893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Botsford' limit 1
loadtime:0.35696315765381 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='5541'DB:business_master_new
loadtime:0.36309814453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozrah' limit 1
loadtime:0.36312913894653 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='5541'DB:business_master_new
loadtime:0.37780809402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branford' limit 1
loadtime:0.37784910202026 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='5541'DB:business_master_new
loadtime:0.6114490032196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.61152005195618 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='5541'DB:business_master_new
loadtime:0.62376022338867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.6240131855011 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:0.64772510528564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.64777421951294 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='5541'DB:business_master_new
loadtime:0.64896702766418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Brook' limit 1
loadtime:0.6490170955658 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='5541'DB:business_master_new
loadtime:0.67440605163574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.67447113990784 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='5541'DB:business_master_new
loadtime:0.68049812316895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.68066620826721 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='5541'DB:business_master_new
loadtime:0.71547913551331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.71563410758972 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='5541'DB:business_master_new
loadtime:0.77192616462708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.77197122573853 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='5541'DB:business_master_new
loadtime:0.81744718551636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.81751012802124 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='5541'DB:business_master_new
loadtime:0.84457612037659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.84464001655579 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='5541'DB:business_master_new
loadtime:0.8455011844635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton Center' limit 1
loadtime:0.84601402282715 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='5541'DB:business_master_new
loadtime:0.84901404380798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerbrook' limit 1
loadtime:0.84904909133911 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='5541'DB:business_master_new
loadtime:0.86500811576843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Village' limit 1
loadtime:0.8653461933136 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='5541'DB:business_master_new
loadtime:0.86844801902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaplin' limit 1
loadtime:0.86848306655884 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='5541'DB:business_master_new
loadtime:0.87821006774902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.87826800346375 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='5541'DB:business_master_new
loadtime:0.88457703590393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.88465619087219 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='5541'DB:business_master_new
loadtime:0.93074512481689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.93080806732178 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='5541'DB:business_master_new
loadtime:0.93169116973877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobalt' limit 1
loadtime:0.93172907829285 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='5541'DB:business_master_new
loadtime:0.93448519706726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.93453502655029 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='5541'DB:business_master_new
loadtime:0.9354100227356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.93545913696289 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='5541'DB:business_master_new
loadtime:0.93811917304993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.93816709518433 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='5541'DB:business_master_new
loadtime:0.94289708137512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.94294500350952 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='5541'DB:business_master_new
loadtime:0.96651005744934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall' limit 1
loadtime:0.96656012535095 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='5541'DB:business_master_new
loadtime:0.97012114524841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall Bridge' limit 1
loadtime:0.97015619277954 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='5541'DB:business_master_new
loadtime:0.98335719108582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cos Cob' limit 1
loadtime:0.98340010643005 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='5541'DB:business_master_new
loadtime:0.98433899879456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.98438310623169 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='5541'DB:business_master_new
loadtime:1.0441272258759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:1.0441951751709 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='5541'DB:business_master_new
loadtime:1.0450611114502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:1.0451121330261 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='5541'DB:business_master_new
loadtime:1.0513601303101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danielson' limit 1
loadtime:1.0514280796051 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='5541'DB:business_master_new
loadtime:1.0522091388702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:1.0522561073303 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='5541'DB:business_master_new
loadtime:1.0581271648407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:1.0581831932068 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='5541'DB:business_master_new
loadtime:1.0792820453644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:1.0793421268463 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='5541'DB:business_master_new
loadtime:1.1114151477814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:1.1114740371704 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='5541'DB:business_master_new
loadtime:1.1125450134277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:1.1126070022583 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='5541'DB:business_master_new
loadtime:1.1567680835724 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berlin' limit 1
loadtime:1.1568171977997 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='5541'DB:business_master_new
loadtime:1.1638700962067 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Canaan' limit 1
loadtime:1.1639130115509 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='5541'DB:business_master_new
loadtime:1.1679940223694 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Glastonbury' limit 1
loadtime:1.1680431365967 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='5541'DB:business_master_new
loadtime:1.172119140625 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Granby' limit 1
loadtime:1.1721661090851 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='5541'DB:business_master_new
loadtime:1.2118520736694 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haddam' limit 1
loadtime:1.211905002594 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='5541'DB:business_master_new
loadtime:1.2349851131439 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampton' limit 1
loadtime:1.2350342273712 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='5541'DB:business_master_new
loadtime:1.2358531951904 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartford' limit 1
loadtime:1.2358980178833 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='5541'DB:business_master_new
loadtime:1.2370631694794 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartland' limit 1
loadtime:1.2371230125427 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='5541'DB:business_master_new
loadtime:1.2418730258942 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:1.2419140338898 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='5541'DB:business_master_new
loadtime:1.2430021762848 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Killingly' limit 1
loadtime:1.2430610656738 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='5541'DB:business_master_new
loadtime:1.2460470199585 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lyme' limit 1
loadtime:1.2460942268372 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='5541'DB:business_master_new
loadtime:1.2773342132568 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:1.2773690223694 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='5541'DB:business_master_new
loadtime:1.2781481742859 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor Hill' limit 1
loadtime:1.2781980037689 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='5541'DB:business_master_new
loadtime:1.2786891460419 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Woodstock' limit 1
loadtime:1.2787210941315 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='5541'DB:business_master_new
loadtime:1.2819581031799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastford' limit 1
loadtime:1.2819981575012 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='5541'DB:business_master_new
loadtime:1.2907230854034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:1.2907631397247 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='5541'DB:business_master_new
loadtime:1.29154920578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellington' limit 1
loadtime:1.2915871143341 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='5541'DB:business_master_new
loadtime:1.2923581600189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:1.292396068573 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='5541'DB:business_master_new
loadtime:1.293407201767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:1.2934551239014 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='5541'DB:business_master_new
loadtime:1.2942152023315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fabyan' limit 1
loadtime:1.2942581176758 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='5541'DB:business_master_new
loadtime:1.2946720123291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.2947101593018 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='5541'DB:business_master_new
loadtime:1.3009250164032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Village' limit 1
loadtime:1.3014161586761 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='5541'DB:business_master_new
loadtime:1.3084480762482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:1.3084981441498 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='5541'DB:business_master_new
loadtime:1.3098561763763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Ferry' limit 1
loadtime:1.3099181652069 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='5541'DB:business_master_new
loadtime:1.330423116684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylordsville' limit 1
loadtime:1.3304750919342 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='5541'DB:business_master_new
loadtime:1.3351190090179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:1.3351612091064 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='5541'DB:business_master_new
loadtime:1.3455810546875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:1.3456530570984 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='5541'DB:business_master_new
loadtime:1.346351146698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgo' limit 1
loadtime:1.3463881015778 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='5541'DB:business_master_new
loadtime:1.3471200466156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glastonbury' limit 1
loadtime:1.3471641540527 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='5541'DB:business_master_new
loadtime:1.3531801700592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:1.3532290458679 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='5541'DB:business_master_new
loadtime:1.3748350143433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:1.374899148941 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='5541'DB:business_master_new
loadtime:1.4282150268555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greens Farms' limit 1
loadtime:1.4282701015472 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='5541'DB:business_master_new
loadtime:1.4315371513367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:1.4315659999847 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='5541'DB:business_master_new
loadtime:1.4379370212555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosvenor Dale' limit 1
loadtime:1.4380080699921 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='5541'DB:business_master_new
loadtime:1.4384670257568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:1.4385170936584 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='5541'DB:business_master_new
loadtime:1.4394481182098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:1.4394881725311 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='5541'DB:business_master_new
loadtime:1.4452900886536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:1.4453301429749 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='5541'DB:business_master_new
loadtime:1.456728219986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:1.4567761421204 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='5541'DB:business_master_new
loadtime:1.4586851596832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:1.4587352275848 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='5541'DB:business_master_new
loadtime:1.4646751880646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:1.4647371768951 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='5541'DB:business_master_new
loadtime:1.4727962017059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.472852230072 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='5541'DB:business_master_new
loadtime:1.4736840724945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.4737331867218 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='5541'DB:business_master_new
loadtime:1.4795341491699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:1.47958111763 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='5541'DB:business_master_new
loadtime:1.5009310245514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:1.5009951591492 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='5541'DB:business_master_new
loadtime:1.5031042098999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:1.5032441616058 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='5541'DB:business_master_new
loadtime:1.5244851112366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:1.5245201587677 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='5541'DB:business_master_new
loadtime:1.5350320339203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:1.5350852012634 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='5541'DB:business_master_new
loadtime:1.5414071083069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:1.541451215744 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='5541'DB:business_master_new
loadtime:1.5749690532684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:1.5750510692596 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='5541'DB:business_master_new
loadtime:1.5883510112762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:1.5884051322937 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='5541'DB:business_master_new
loadtime:1.6018872261047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:1.6019480228424 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='5541'DB:business_master_new
loadtime:1.6024250984192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.6024692058563 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='5541'DB:business_master_new
loadtime:1.6083390712738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:1.6083881855011 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='5541'DB:business_master_new
loadtime:1.6178410053253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:1.6179010868073 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='5541'DB:business_master_new
loadtime:1.6235229969025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:1.6235771179199 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='5541'DB:business_master_new
loadtime:1.6244821548462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.6245391368866 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='5541'DB:business_master_new
loadtime:1.6307511329651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.6308121681213 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='5541'DB:business_master_new
loadtime:1.6366381645203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:1.6367042064667 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='5541'DB:business_master_new
loadtime:1.6505661010742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:1.6506161689758 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='5541'DB:business_master_new
loadtime:1.6515262126923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:1.6515772342682 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='5541'DB:business_master_new
loadtime:1.652036190033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.6520850658417 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='5541'DB:business_master_new
loadtime:1.6537570953369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:1.6537930965424 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='5541'DB:business_master_new
loadtime:1.664605140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:1.664656162262 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='5541'DB:business_master_new
loadtime:1.6705331802368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:1.6706120967865 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='5541'DB:business_master_new
loadtime:1.6715180873871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:1.6715540885925 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='5541'DB:business_master_new
loadtime:1.6724650859833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:1.6725261211395 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='5541'DB:business_master_new
loadtime:1.6789481639862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:1.6789991855621 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='5541'DB:business_master_new
loadtime:1.6848640441895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.6849150657654 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='5541'DB:business_master_new
loadtime:1.6907460689545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:1.6908161640167 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='5541'DB:business_master_new
loadtime:1.6943712234497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.6944241523743 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='5541'DB:business_master_new
loadtime:1.7002630233765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:1.7003111839294 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='5541'DB:business_master_new
loadtime:1.7039771080017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:1.7040281295776 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='5541'DB:business_master_new
loadtime:1.7068800926208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:1.706915140152 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='5541'DB:business_master_new
loadtime:1.711483001709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:1.7115371227264 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='5541'DB:business_master_new
loadtime:1.7194650173187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:1.7195181846619 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='5541'DB:business_master_new
loadtime:1.7204291820526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:1.7204811573029 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='5541'DB:business_master_new
loadtime:1.7219321727753 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:1.72199010849 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='5541'DB:business_master_new
loadtime:1.7278201580048 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:1.727884054184 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='5541'DB:business_master_new
loadtime:1.7337410449982 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:1.7338030338287 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='5541'DB:business_master_new
loadtime:1.7347249984741 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:1.7347772121429 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='5541'DB:business_master_new
loadtime:1.7417871952057 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:1.7419040203094 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='5541'DB:business_master_new
loadtime:1.7554841041565 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.7557451725006 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='5541'DB:business_master_new
loadtime:1.7574021816254 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:1.7574610710144 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='5541'DB:business_master_new
loadtime:1.7594611644745 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:1.7595100402832 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='5541'DB:business_master_new
loadtime:1.7636280059814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:1.7637581825256 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='5541'DB:business_master_new
loadtime:1.765928030014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:1.7660942077637 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='5541'DB:business_master_new
loadtime:1.7693400382996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:1.7694661617279 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='5541'DB:business_master_new
loadtime:1.7812230587006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:1.7812850475311 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='5541'DB:business_master_new
loadtime:1.7843379974365 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:1.784373998642 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='5541'DB:business_master_new
loadtime:1.7853200435638 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:1.7853710651398 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='5541'DB:business_master_new
loadtime:1.7859530448914 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:1.7859802246094 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='5541'DB:business_master_new
loadtime:1.7895710468292 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:1.7896490097046 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='5541'DB:business_master_new
loadtime:1.7910490036011 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:1.791088104248 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='5541'DB:business_master_new
loadtime:1.7932472229004 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:1.7932810783386 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='5541'DB:business_master_new
loadtime:1.7990880012512 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:1.7991421222687 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='5541'DB:business_master_new
loadtime:1.8043570518494 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:1.8044090270996 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='5541'DB:business_master_new
loadtime:1.8052570819855 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:1.8053181171417 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='5541'DB:business_master_new
loadtime:1.8069920539856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.8070340156555 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='5541'DB:business_master_new
loadtime:1.8076992034912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:1.8077390193939 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='5541'DB:business_master_new
loadtime:1.8085310459137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:1.8085780143738 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='5541'DB:business_master_new
loadtime:1.8143360614777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:1.8144021034241 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='5541'DB:business_master_new
loadtime:1.8154330253601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:1.8154802322388 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='5541'DB:business_master_new
loadtime:1.8182570934296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:1.8183100223541 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='5541'DB:business_master_new
loadtime:1.8225820064545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:1.8227560520172 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='5541'DB:business_master_new
loadtime:1.8250670433044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:1.8251261711121 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='5541'DB:business_master_new
loadtime:1.8269441127777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:1.8271021842957 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='5541'DB:business_master_new
loadtime:1.8290460109711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:1.8291611671448 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='5541'DB:business_master_new
loadtime:1.83083319664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:1.8309650421143 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='5541'DB:business_master_new
loadtime:1.8319680690765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.8320081233978 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='5541'DB:business_master_new
loadtime:1.8341979980469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.8342571258545 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='5541'DB:business_master_new
loadtime:1.8351092338562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:1.8351490497589 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='5541'DB:business_master_new
loadtime:1.8389370441437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:1.8389902114868 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='5541'DB:business_master_new
loadtime:1.8397600650787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:1.8398170471191 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='5541'DB:business_master_new
loadtime:1.8405530452728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.8406181335449 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='5541'DB:business_master_new
loadtime:1.8433082103729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:1.843355178833 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='5541'DB:business_master_new
loadtime:1.8442671298981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:1.8443100452423 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='5541'DB:business_master_new
loadtime:1.8469111919403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:1.8469731807709 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.8473961353302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.8474371433258 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='5541'DB:business_master_new
loadtime:1.8487272262573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:1.8487710952759 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='5541'DB:business_master_new
loadtime:1.8493411540985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:1.8493661880493 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='5541'DB:business_master_new
loadtime:1.8513171672821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:1.851368188858 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='5541'DB:business_master_new
loadtime:1.8523290157318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:1.8523700237274 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='5541'DB:business_master_new
loadtime:1.8531911373138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:1.8532540798187 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='5541'DB:business_master_new
loadtime:1.8545291423798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:1.8545801639557 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='5541'DB:business_master_new
loadtime:1.8554980754852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:1.8555541038513 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='5541'DB:business_master_new
loadtime:1.856388092041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:1.8564410209656 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='5541'DB:business_master_new
loadtime:1.857791185379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:1.8578441143036 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='5541'DB:business_master_new
loadtime:1.8584020137787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:1.8584530353546 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='5541'DB:business_master_new
loadtime:1.859432220459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:1.8594810962677 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='5541'DB:business_master_new
loadtime:1.8600361347198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:1.8600702285767 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='5541'DB:business_master_new
loadtime:1.8606472015381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:1.8606851100922 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='5541'DB:business_master_new
loadtime:1.8665990829468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:1.8666591644287 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='5541'DB:business_master_new
loadtime:1.8675072193146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:1.8675651550293 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='5541'DB:business_master_new
loadtime:1.8681859970093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:1.8682281970978 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='5541'DB:business_master_new
loadtime:1.8687980175018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:1.8688480854034 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='5541'DB:business_master_new
loadtime:1.8697891235352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:1.8698492050171 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='5541'DB:business_master_new
loadtime:1.8703200817108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:1.8703560829163 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='5541'DB:business_master_new
loadtime:1.8715620040894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.8716192245483 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='5541'DB:business_master_new
loadtime:1.875226020813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:1.8752942085266 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='5541'DB:business_master_new
loadtime:1.8765511512756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:1.8766100406647 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='5541'DB:business_master_new
loadtime:1.8773791790009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:1.8774180412292 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='5541'DB:business_master_new
loadtime:1.8780791759491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:1.8781161308289 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='5541'DB:business_master_new
loadtime:1.879102230072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:1.8791520595551 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='5541'DB:business_master_new
loadtime:1.8816611766815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:1.8817040920258 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='5541'DB:business_master_new
loadtime:1.8875880241394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:1.8876640796661 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='5541'DB:business_master_new
loadtime:1.8902690410614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:1.8903200626373 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='5541'DB:business_master_new
loadtime:1.8912281990051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:1.8912920951843 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='5541'DB:business_master_new
loadtime:1.8942091464996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:1.8942592144012 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='5541'DB:business_master_new
loadtime:1.8947741985321 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:1.8948240280151 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='5541'DB:business_master_new
loadtime:1.8952751159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:1.8953242301941 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='5541'DB:business_master_new
loadtime:1.8972141742706 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:1.8972570896149 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='5541'DB:business_master_new
loadtime:1.8978250026703 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:1.8978641033173 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='5541'DB:business_master_new
loadtime:1.8983421325684 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:1.8983771800995 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='5541'DB:business_master_new
loadtime:1.8987920284271 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:1.8988370895386 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='5541'DB:business_master_new
loadtime:1.8994112014771 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:1.899453163147 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='5541'DB:business_master_new
loadtime:1.9052321910858 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:1.9052832126617 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='5541'DB:business_master_new
loadtime:1.9058492183685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:1.9059031009674 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='5541'DB:business_master_new
loadtime:1.9070680141449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:1.9071311950684 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='5541'DB:business_master_new
loadtime:1.9081702232361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:1.9082350730896 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='5541'DB:business_master_new
loadtime:1.9091000556946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:1.9091441631317 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='5541'DB:business_master_new
loadtime:1.9097340106964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:1.9097781181335 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='5541'DB:business_master_new
loadtime:1.9297430515289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:1.9297800064087 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='5541'DB:business_master_new
loadtime:1.9302182197571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:1.9302580356598 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='5541'DB:business_master_new
loadtime:1.9360611438751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:1.9361290931702 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='5541'DB:business_master_new
loadtime:1.9368481636047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:1.9368810653687 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='5541'DB:business_master_new
loadtime:1.9374182224274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:1.9374580383301 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='5541'DB:business_master_new
loadtime:1.9419860839844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:1.9421381950378 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='5541'DB:business_master_new
loadtime:1.9483442306519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:1.9484992027283 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='5541'DB:business_master_new
loadtime:1.9631161689758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:1.963278055191 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='5541'DB:business_master_new
loadtime:1.9706280231476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:1.9707901477814 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='5541'DB:business_master_new
loadtime:1.9719851016998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:1.972020149231 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='5541'DB:business_master_new
loadtime:1.9738721847534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:1.9746181964874 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='5541'DB:business_master_new
loadtime:1.976035118103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:1.9760711193085 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='5541'DB:business_master_new
loadtime:1.9800910949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:1.9801502227783 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='5541'DB:business_master_new
loadtime:1.9848880767822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:1.9849491119385 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='5541'DB:business_master_new
loadtime:1.9878060817719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:1.9879500865936 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='5541'DB:business_master_new
loadtime:1.9902911186218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:1.9904432296753 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='5541'DB:business_master_new
loadtime:1.9936311244965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:1.9937980175018 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='5541'DB:business_master_new
loadtime:2.0099861621857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:2.0101110935211 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='5541'DB:business_master_new
loadtime:2.0153071880341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:2.0153682231903 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='5541'DB:business_master_new
loadtime:2.0185570716858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:2.0187351703644 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='5541'DB:business_master_new
loadtime:2.0212190151215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:2.0213952064514 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='5541'DB:business_master_new
loadtime:2.0227110385895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:2.0228090286255 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='5541'DB:business_master_new
loadtime:2.0255532264709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:2.0257430076599 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='5541'DB:business_master_new
loadtime:2.0404322147369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.0406441688538 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='5541'DB:business_master_new
loadtime:2.0432021617889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:2.0433390140533 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='5541'DB:business_master_new
loadtime:2.0466871261597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:2.0468001365662 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='5541'DB:business_master_new
loadtime:2.0610132217407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:2.0612151622772 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='5541'DB:business_master_new
loadtime:2.063903093338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.0639622211456 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='5541'DB:business_master_new
loadtime:2.0659301280975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:2.0660691261292 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='5541'DB:business_master_new
loadtime:2.0677402019501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:2.0679090023041 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='5541'DB:business_master_new
loadtime:2.0712761878967 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:2.0713710784912 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='5541'DB:business_master_new
loadtime:2.0734231472015 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:2.0735771656036 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='5541'DB:business_master_new
loadtime:2.0753710269928 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:2.0754811763763 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='5541'DB:business_master_new
loadtime:2.0911822319031 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:2.0913310050964 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='5541'DB:business_master_new
loadtime:2.0925920009613 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:2.0927350521088 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='5541'DB:business_master_new
loadtime:2.1040720939636 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:2.1041440963745 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='5541'DB:business_master_new
loadtime:2.1052050590515 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:2.1052842140198 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='5541'DB:business_master_new
loadtime:2.1064331531525 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:2.106486082077 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='5541'DB:business_master_new
loadtime:2.1088130474091 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:2.1089491844177 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='5541'DB:business_master_new
loadtime:2.1115062236786 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:2.111661195755 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='5541'DB:business_master_new
loadtime:2.1125071048737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:2.1126720905304 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='5541'DB:business_master_new
loadtime:2.1194071769714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.1195662021637 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='5541'DB:business_master_new
loadtime:2.1212661266327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.1214141845703 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='5541'DB:business_master_new
loadtime:2.1364860534668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:2.1366691589355 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='5541'DB:business_master_new
loadtime:2.1393880844116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:2.1395390033722 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='5541'DB:business_master_new
loadtime:2.1415002346039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:2.1416530609131 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='5541'DB:business_master_new
loadtime:2.1450610160828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:2.1451880931854 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='5541'DB:business_master_new
loadtime:2.1603260040283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:2.1604971885681 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='5541'DB:business_master_new
loadtime:2.1616611480713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:2.1622891426086 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='5541'DB:business_master_new
loadtime:2.1639111042023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.1639602184296 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='5541'DB:business_master_new
loadtime:2.1662950515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:2.1664481163025 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='5541'DB:business_master_new
loadtime:2.1685612201691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:2.1687490940094 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='5541'DB:business_master_new
loadtime:2.171079158783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:2.1712141036987 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='5541'DB:business_master_new
loadtime:2.1860291957855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:2.1861951351166 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='5541'DB:business_master_new
loadtime:2.1889860630035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:2.1891222000122 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='5541'DB:business_master_new
loadtime:2.1916301250458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:2.1917810440063 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='5541'DB:business_master_new
loadtime:2.1937181949615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:2.1938161849976 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='5541'DB:business_master_new
loadtime:2.1952881813049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:2.1954212188721 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='5541'DB:business_master_new
loadtime:2.1970291137695 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.1972720623016 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.1977481842041 / seconds
Operation template executed (chunk cache operation)
loadtime:2.1979382038116 / seconds
template override:Default
loadtime:2.1979851722717 / 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:2.1999950408936 / seconds
Template Constructed, Array Rows:49
loadtime:2.2006480693817 / seconds
TOTAL EXECUTION TIME: 2.20011
loadtime:2.2008671760559 / 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] => gasoline-service-station [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:2.2008790969849
TOTAL KEY ARRAYS: 69